Cash Flow Forecast for a Business Loan

A cash flow forecast for a business loan estimates when money enters and leaves the business, showing the funding gap and cash available for repayments. Start with reconciled balances, put transactions in their expected payment periods and test what happens when trading assumptions worsen.

For a broker, the forecast connects the requested loan to the client’s operating cycle. It can expose a cash shortage before a bill falls due, even when the business expects an annual profit. Its usefulness depends on the evidence behind the assumptions and how often the business updates them.

Set the Forecast Period and Opening Position

Start with monthly periods covering the funding need, the trading cycle and the repayment dates you need to assess. Extend the forecast through a seasonal low point or a final loan payment that falls beyond the initial period. An annual total alone can hide the month when cash runs out.

1. Agree the starting date with the business owner and preparer. Use the last reconciled reporting date, then include the transactions between that date and the forecast’s start.
2. Reconcile opening cash to bank statements and the accounting records. Separate restricted funds from cash available to pay business bills.
3. Reconcile existing debt to current loan statements. Record drawn balances, undrawn limits, repayment dates and any final amounts due.
4. Record unpaid customer invoices and supplier bills at the starting date. Put their expected collections and payments into the forecast, so opening balances aren’t lost.

The opening position is ready when the forecast’s cash and debt agree with the records for the same date. An undrawn credit limit is borrowing capacity, not cash already in the bank.

A profit forecast records revenue and expenses under its accounting basis. A cash forecast records money moving through the business. A credit sale can increase accounting profit before the customer pays, while depreciation reduces profit without creating a cash payment.

Keep equipment purchases and debt principal payments in the cash forecast when money leaves the account. Don’t copy depreciation into payments or assume an unpaid invoice is a receipt. The business plan explains how the business expects to trade, while the cash forecast tests whether the timing funds that plan.

Build Receipts and Payments

Translate each sales and cost assumption into the period when the business expects to receive or pay money. Use customer payment behaviour and supplier terms, with separate schedules for payroll and tax obligations.

1. Estimate receipts from cash sales and collections of credit sales. Separate existing customer debts from future sales, then apply collection timing to each.
2. Schedule payments for stock, suppliers and other operating costs. Use payment dates, including deposits paid before stock arrives.
3. Add wages and the separate dates for superannuation or payroll-related remittances. Include rent, insurance and other commitments even in quiet trading months.
4. Schedule tax payments or refunds, equipment spending and owner withdrawals. Record the purpose and timing of any owner contribution separately.
5. Calculate each period’s closing cash. Carry it forward as the next period’s opening cash, then check that every balance follows that calculation.

A simple forecast can use a spreadsheet, including Excel. The basic reconciliation is opening cash plus receipts, less payments, equals closing cash. Keep operating receipts separate from borrowing so the lender can see how trading supports repayment.

Evidence for Each Assumption

Attach a source to every assumption that could change the requested funding or repayment case. Use signed orders for committed sales, debtor ageing for collection timing and supplier quotes for planned purchases. Historical bank activity can show whether customers actually pay within the terms printed on invoices.

Label a forecast judgement when a figure depends on expected growth or an unsigned order. Record the preparer, calculation and reason beside it. If projected sales exceed recent trading, explain the extra capacity or contracts supporting that increase.

Include Tax Without Double Counting

A bank-balance forecast must capture the actual amounts received and paid, including goods and services tax (GST) where it applies. One practical method uses GST-inclusive customer and supplier cash amounts, with a separate line for net tax remittances or refunds.

Reconcile that line to the business’s tax reporting basis and payment schedule with its accountant. Don’t add GST to wages or every expense automatically. Don’t deduct the same GST again as a separate supplier payment if it is already included in that payment.

The Australian Government’s cash flow statement guidance says to state whether forecast figures include or exclude GST. Whichever presentation you use, the forecast must reconcile to expected bank movements.

Add the Proposed Finance

Show the proposed finance separately so the lender can distinguish the trading gap from the cash created by borrowing. Put drawdowns and fees in their expected periods, then add repayments and any end-of-term amount from the proposed terms.

Record whether a fee is paid in cash, deducted from proceeds or added to the debt. A loan approved for a stated amount doesn’t necessarily put that full amount into the business account. Include the cash effect once and reconcile the debt schedule to the same treatment.

A Fictional Monthly Funding Example

This fictional business begins January with $20,000 cash and $12,000 of existing debt. Existing debt payments are $2,000 principal each month, and this example assumes zero interest on both debts solely to simplify the arithmetic. The operating payments exclude existing and proposed finance payments.

All figures below are Australian dollars and reflect cash amounts, including any applicable GST. Operating payments include all forecast tax payments, with no additional tax line omitted. The model assumes a $10,000 January drawdown, a $500 cash fee and $1,000 principal repayments starting in February.

Cash movement	January	February	March
Opening cash	$20,000	$2,500	$9,500
Customer receipts	$30,000	$45,000	$50,000
Operating payments	$55,000	$35,000	$38,000
Existing debt payments	$2,000	$2,000	$2,000
Proposed drawdown	$10,000	$0	$0
Proposed cash fee	$500	$0	$0
Proposed principal payments	$0	$1,000	$1,000
Closing cash	$2,500	$9,500	$18,500

January reconciles as $20,000 + $30,000 - $55,000 - $2,000 + $10,000 - $500 = $2,500. The $2,500 carries into February, whose net movements add $7,000 and leave $9,500. March then adds $9,000 to that opening balance, leaving $18,500.

Existing debt falls to $10,000 in January, $8,000 in February and $6,000 in March. Proposed debt closes at $10,000, $9,000 and $8,000 respectively. These are illustrative assumptions, not a lender offer or a forecast of interest-free borrowing.

Without the proposed finance, January cash would be negative $7,000. To leave a $2,500 cash buffer after the $500 fee, the example needs $10,000 of gross proceeds. A different fee, repayment structure or buffer changes that amount.

Match the requested amount to the lowest pre-funding cash balance and the dates of the gap. Check intramonth timing too, because a monthly closing surplus can hide an earlier missed payment. For a revolving facility, show peak drawn debt and available headroom separately from bank cash.

Stress and Explain the Forecast

Test collection delays, lower receipts and higher costs separately before combining them. Each test must show when cash becomes insufficient and which management action addresses the gap.

Test using the fictional example	Change to January	January closing cash after finance
Slower collections	Move $10,000 of January receipts to February	Negative $7,500
Lower sales receipts	Reduce January receipts by 10%, with payments unchanged	Negative $500
Higher costs	Increase January operating payments by 10%	Negative $3,000
Combined adverse case	Reduce receipts by $3,000, delay another $10,000 and increase payments by $5,500	Negative $16,000

In the delay-only case, February receives the delayed $10,000 and closes at $9,500. That later recovery doesn’t pay January’s bills when they fall due. In the combined case, the $10,000 drawdown leaves a January shortfall of $16,000.

Management could defer an uncommitted purchase or add an evidenced owner contribution. Changing supplier payment dates needs the supplier’s agreement. Additional borrowing needs an available facility and a revised repayment assessment.

Record the action’s amount, timing and responsible person, then run the forecast again. If borrowing covers recurring operating losses, explain how the business will reverse them and repay the larger debt. A forecast predicts the cash consequences of its assumptions, with no certainty that sales or collections will occur.

The benefits are earlier visibility of shortages and a clearer explanation of funding needs. The drawbacks are inaccurate assumptions, stale records and periods too broad to reveal payment problems. Compare actual results with the forecast to identify which assumption needs correction.

Submit the Supporting Records

Submit a dated forecast with assumption notes and records that let the lender trace the proposed funding and repayments. Keep the business owner’s trading assumptions identifiable throughout the broker’s review.

Australia and New Zealand Banking Group (ANZ), as at October 2026, lists a forecast for the next 12 months for business purchases or start-ups. Its business lending checklist specifies preparation within the last three months. This is an ANZ requirement for those circumstances, not a universal forecast period.

The same checklist includes financial statements and management accounts, with aged debtor or creditor listings among its supporting records. ANZ’s lending preparation guidance says some applications require a forecast, depending on circumstances. Its tools page provides an ANZ cash flow forecast file.

Build the submission around the chosen lender’s request and the actual transaction. Include the bank and debt reconciliations, contracts supporting material receipts and the finance terms used in the model. For an operating business, show recent actual results beside the earlier forecast and explain differences.

Record who prepared the model, who reviewed it and who approved each material assumption. Record who updates each material assumption and when they must review it against actual results.

The owner can approve expected sales while the accountant reviews their accounting and tax treatment. The broker checks the funding explanation and evidence without silently replacing the owner’s trading assumptions.

Before sending the file, verify these outcomes.

1. Every period’s opening cash equals the previous period’s closing cash.
2. Opening cash and debt reconcile to dated records for the borrowing entity.
3. Drawdowns and repayments reconcile to the separate debt schedule.
4. Each shortfall has an explained amount, date and evidenced response.
5. The submitted version records its preparation date and assumption approvals.

Choose the Horizon and Business Assumptions

Choose a forecast horizon that exposes the funding problem at the level where management can act. Monthly periods suit a broader business-loan assessment, while shorter periods reveal payment pressures hidden inside those months.

Horizon	Funding decision it helps assess	Limitation to address
Daily	Immediate cash availability for dated payments	Extend the view beyond the next few days
Weekly	Payroll, supplier runs and near-term collections	Reconcile weekly totals to the monthly model
13-week	Short-term working capital and collection delays	Extend through seasonal lows outside the quarter
Monthly over 12 months	Seasonal trading, investment and scheduled debt payments	Add shorter periods around cash pressure points
Annual totals	Longer-term business planning	Retain monthly detail so shortages remain visible

A rolling forecast replaces completed periods with actual results and adds new future periods. Keep the submitted version so later updates don’t erase the assumptions the lender reviewed.

A three-way forecast connects the cash forecast to a profit and loss forecast and a projected balance sheet. Use it when the assessment needs those connected projections, particularly where stock, customer debts or capital spending change materially. The closing cash must match the balance sheet, debt must follow drawdowns and principal repayments, and unpaid invoices must remain in customer debts.

Free cash flow often measures cash generated after capital spending. Define the measure used if it appears in the submission, then reconcile it to bank cash and scheduled debt payments. A free-cash-flow total alone doesn’t show whether a particular repayment date can be met.

Adjust for the Business’s Trading Cycle

A new business needs support for its ramp-up assumptions because it has no own trading history. Use signed customer orders, lease terms and supplier quotes, with labelled judgements for uncommitted sales. Model the period before opening as well as the first trading months.

For a coffee shop or restaurant, connect sales to customers served and average spend. Use settlement timing for card receipts, with rosters and supplier payments for outgoings. Test a slower opening or quiet season without assuming that labour and rent fall at the same rate as sales.

Retail businesses need stock purchases before peak selling periods, with refunds and supplier terms reflected in cash timing. Trades can incur materials and wages before customers pay invoices. Construction forecasts must distinguish deposits, progress claims and retentions, including the contract conditions that allow each receipt.

Use the separate cash flow forecast template for a reusable file and completion guidance. For choosing a tool, use the cash flow forecast software comparison. The output you need is a reconciled forecast with dated assumptions and a retained record of changes, whichever tool produces it.