How to Build a 13 Week Cash Flow Forecast Before Seeking Financing

A financing request becomes more useful when it identifies the week cash runs short. An annual profit forecast can miss a payroll shortage in the middle of a profitable quarter. A weekly cash forecast gives the owner and the prospective lender a way to discuss the timing of the problem.

A 13 week forecast covers roughly one quarter. J.P. Morgan describes this horizon as a practical balance between detail and planning. The approach below is a suggested working method for a business preparing a financing request.

Start with cash that can actually be used

Begin with the bank balance available for operations. Separate restricted funds and amounts already committed to payments. Then create a column for each of the next 13 weeks.

Enter customer collections in the weeks you reasonably expect payment, rather than the weeks you expect to issue invoices. For your largest invoices, record the person responsible for confirming the collection date. Schedule payroll, supplier payments, rent, taxes and debt payments separately so that changes remain visible.

Show the funding gap before adding a new loan

Calculate each weekly closing balance from opening cash, receipts and payments. First run the forecast without the proposed financing. That version shows the underlying need.

Consider a hypothetical manufacturer starting with $180,000. During the next three weeks it expects $320,000 in receipts and $620,000 in payments. Its projected closing cash is negative $120,000. If management wants a $50,000 operating buffer, the gap to that target is $170,000. Later receipts may reverse the shortage, but they cannot pay an earlier bill.

The example is a planning illustration, not a recommended credit limit. Actual availability, fees and closing timing still need to be assessed.

Test the assumptions that could change the request

Create a second version that delays a major collection or brings forward a supplier payment. Ask which week becomes most difficult and what action management could take before that date.

Keep unapproved financing separate from confirmed cash. If a facility is subject to collateral availability, enter the amount that could realistically be drawn. An approved maximum alone should not fill every shortfall in the model.

Use the forecast after submitting the application

Each week, replace the completed forecast column with actual receipts and payments. Explain significant differences and add another week at the end. This makes the model useful during underwriting and after closing.

Send a short explanation alongside the numbers: what creates the gap, what financing is requested, and which collections are expected to support repayment. Lirodean can help connect that financing need with an appropriate lender discussion. Contact us to review working capital options for your business.

Explore the related service: Lirodean Working Capital Financing  |  Contact Lirodean