Cash Flow Forecast for Business Credit: Build a Weekly Funding Plan

Set up a worksheet with useful boundaries

Choose a start date and opening bank balance, then reconcile outstanding transactions and funds unavailable for ordinary operations. State whether the forecast covers one entity or a group. If it combines related entities, show transfers clearly so internal movements are not mistaken for new outside receipts.

A rolling 13-week format is a practical near-term tool; BDC publishes a calculator using that approach alongside a longer forecast. Extend beyond thirteen weeks when the proposed repayment or seasonal cycle lasts longer. The format is a planning choice, not a universal lender requirement.

Use rows for customer receipts, other inflows, supplier payments, payroll, occupancy, taxes, existing debt, capital spending, and owner transactions as relevant. Place proposed draws and principal repayments in their own section. Keep interest and fees visible rather than assuming borrowing has no cash cost.

Build receipts and payments from evidence

For receivables already earned, start with customer invoices, payment history, and known disputes. For future sales, explain the expected volume, billing date, and collection delay. Avoid collecting every projected sale in the same week it is booked unless that reflects the business’s actual model.

For payments, use supplier due dates, payroll calendars, existing agreements, and purchase commitments. Separate confirmed payments from estimated spending. Include cash obligations that do not appear as a current profit-and-loss expense, such as principal payments or an equipment deposit.

Keep an assumptions tab with the source, date, and person responsible for each material figure. When an order changes or a customer pays late, you can update the relevant weeks without guessing which forecast line needs adjustment.

Use a simple example to reveal the funding gap

Hypothetical example: a company begins with $30,000 and wants to maintain $10,000 of cash. The following four-week schedule isolates the mechanics; all figures are dollars, and new-facility interest and fees are omitted and would need to be added for a real request. Without financing, cash would reach zero at the end of week two.

An assumed $10,000 draw in week two maintains the chosen reserve. Under the listed receipts, the company can repay that principal in week three and finish week four with $20,000. This is a forecast illustration, not an approved limit or assurance that the facility can be drawn.

Test timing before relying on the repayment

Delay $20,000 of week-three receipts into week four while keeping the other example assumptions. The planned week-three repayment no longer works. Beginning with $10,000, the business receives $20,000 and pays $25,000, leaving $5,000 before any new draw. Preserving the $10,000 reserve requires another $5,000 of borrowing, assuming it is available.

The illustrative peak balance becomes $15,000 instead of $10,000, before fees and interest. This change comes from collection timing, not a lower total four-week sales figure. Test delayed receipts separately from lower sales or higher costs so the cause of each funding requirement stays clear.

Also check whether the forecast’s required draw fits the actual borrowing conditions. A spreadsheet cannot make an expired commitment, ineligible receivable, or unapproved application available for use. Treat proposed financing separately from committed facilities.

Update actuals and present the funding case

At the end of each week, replace estimates with actual movements and explain material variances. Carry the reconciled closing balance into the next week and add another future week. Keep the prior forecast so you can tell whether the problem was a missed sale, late collection, changed payment, or modeling mistake.

Prepare a short summary of the lowest cash point, maximum proposed borrowing, expected repayment date, and downside scenario. State the operating reserve target and why management selected it. A larger reserve may be prudent for one business and unnecessary for another; it is a planning assumption to explain.

Bring the forecast and supporting records to a capital review with The Mortgage Calculator team. Identify the business purpose and timing, then let the actual financing review determine available structures and conditions.