A forecast is a repayment explanation
Cash flow forecasting for lending explains when a business expects to receive money, what it must pay and how proposed debt fits between those events. It is not simply a profit forecast copied into a bank application. Australian businesses can have strong sales and still face cash pressure because inventory is purchased early, customers pay slowly or tax obligations arrive between trading peaks. A lender-ready forecast makes those timing differences visible. Its value comes from realistic assumptions and a clear audit trail, not from producing an uninterrupted sequence of positive balances that conceal the actual working capital demands.
Define the borrowing purpose before building the model. An equipment loan changes capacity, costs and repayments; a working capital facility changes the timing of available funds; a property purchase can alter rent, maintenance and debt obligations. The forecast should reflect those consequences rather than add a loan receipt to an otherwise unchanged spreadsheet. Identify the period that matters to the lender and the business. A shorter detailed cash view can reveal immediate pressure, while a longer monthly view can show seasonality and maturity obligations. Choose a horizon that captures the project's cash cycle rather than stopping just before a difficult period.
Start with reconciled opening balances
The forecast's opening cash must agree with accessible bank balances at the chosen date. Explain restricted funds, uncleared transactions and cash held in entities that cannot freely transfer it. Bring in existing receivables, payables, inventory commitments and debt balances rather than forecasting only new activity. If the model omits old supplier invoices, it can overstate available cash from the first month. Reconcile the opening position to management accounts and current records with the accountant or bookkeeper. A sound starting point lets a reviewer distinguish uncertainty about future trading from errors in the information already available.
Use a consistent structure for the operating entity and any related entities. Where intercompany payments are material, show their timing and legal basis instead of quietly offsetting them. Owner drawings, shareholder loan repayments and distributions can compete with business obligations, so include them transparently. Avoid counting the same funding twice through both a bank balance and an undrawn limit. The working capital forecast should separate cash the business owns from cash it may borrow. This distinction becomes essential when facility availability depends on eligible assets or when a lender can review the limit before the forecast period ends.
Convert sales into realistic cash receipts
Forecast receipts using actual payment behaviour, contract terms and customer mix. Credit sales invoiced this month may be collected later, while deposits may arrive before revenue is recognised. Review debtor ageing and identify disputed invoices or customers with unreliable payment histories. Do not assume every outstanding amount will be collected at the standard due date. New customers may have different terms from established ones, and a larger buyer can improve sales while extending the cash conversion cycle. Explain these effects explicitly so the forecast shows when growth creates a funding need rather than suggesting that every additional sale immediately improves liquidity.
Distinguish contracted revenue, repeat trading expectations and speculative opportunities. A sales pipeline can inform a forecast, but it should not be treated as guaranteed receipts. Record the evidence behind major assumptions, including signed agreements, historical conversion rates or confirmed orders where applicable. For project businesses, connect receipts to milestones and consider retention amounts, certification delays and disputes. For retailers, account for settlement timing, refunds and seasonal demand. A base case should be plausible on its own, with upside shown separately. This keeps the lending case from depending on opportunities that management has not yet secured.
Model the operating cash cycle
Map supplier payments to procurement and delivery requirements. Stock may need to be purchased well before the related sales, especially when imports or minimum orders are involved. Include deposits, freight and any costs needed to make inventory saleable. Supplier credit terms can change after a business ownership change or a period of slow payment. Do not assume historical terms will continue if there is reason to doubt them. Compare projected inventory with expected turnover and identify obsolete or slow moving stock. Money tied up in inventory cannot service debt until the stock is sold and customer cash is collected.
Payroll, rent, utilities, insurance and professional costs often follow different timing from sales. Model payments when they occur, including annual or irregular outgoings that a monthly average can obscure. For Australian operations, account for GST and other tax or employment-related payments using the business's actual arrangements and appropriate accounting advice. Avoid broad assumptions about due dates that may not apply. Currency changes can affect imported purchases, while maintenance costs can rise as equipment ages. A realistic model includes the cash needed to preserve current operations as well as the spending intended to generate growth.
Represent the proposed loan accurately
Enter the loan proceeds when they are expected to become available, net of any amounts deducted at settlement where appropriate. Include establishment costs and the actual repayment profile. Separate interest, principal and any final amount payable so the model explains both cash pressure and debt reduction. A revolving facility needs drawdowns and repayments linked to the cash requirement rather than a single permanent receipt. If availability depends on receivables or another borrowing base, model those conditions. A nominal facility limit can exaggerate usable funding when some underlying assets are ineligible or collections reduce the available amount.
Debt servicing includes existing facilities as well as the proposed borrowing. Reconcile opening debt with lender statements and ensure repayments are not duplicated in general operating expenses. For variable pricing, document the assumption and test changes separately rather than predicting a precise future rate. Where a facility has an interest-only period, show the point at which principal repayments begin. If maturity requires an asset sale or refinance, identify that dependency and its uncertainty. The forecast should demonstrate the intended repayment source clearly enough that a lender can challenge it without needing to reconstruct the whole model.
Link cash with profit and the balance sheet
An integrated model helps explain why profit and cash differ. Sales can increase profit while also increasing receivables. Equipment purchases consume cash but may be recognised through depreciation over time. Loan proceeds increase cash and liabilities rather than operating income. These distinctions prevent common errors that make a business appear more capable of debt repayment than it is. A simple balance sheet roll forward can reveal impossible inventory or debt balances. The model does not need unnecessary complexity, but key movements should reconcile so that reviewers can follow the relationship between trading, investment and financing.
Keep formulas consistent and separate inputs from calculations. Record the source and date of significant forecast assumptions, such as wages, customer terms or equipment quotations. Avoid hardcoded adjustments that create a desirable closing balance without an operating explanation. A reviewer should be able to change a collection delay or sales assumption and see the resulting effect. Version control matters when documents move between the business, accountant and lender. Label the forecast date and scenario, preserve the prior version and explain material revisions. This reduces confusion when assessment uses figures that no longer match the current plan.
Test downside cases and management responses
Useful sensitivities reflect the business's genuine uncertainties. Test slower collections, reduced sales, higher input costs, delayed commissioning or the loss of an important customer. Start with individual changes to identify their effects, then combine plausible stresses that could occur together. Examine the lowest cash balance and whether proposed facilities remain available. If the model shows a shortfall, do not simply increase the assumed borrowing limit. Identify actions management could take, the time required and any consequences. Reducing stock purchases may preserve cash but also limit sales, so responses need to be modelled realistically.
A forecast becomes more useful when it has decision thresholds. Management might review expenditure if collections fall behind the expected pattern or defer a second investment phase until a cash reserve is restored. Explain who will monitor those indicators and how quickly action can occur. Lenders may take comfort from disciplined planning, but no forecast guarantees approval. Keep contingency options proportional and supported by evidence. A supposed asset sale is not an immediate cash source unless there is a realistic market and sufficient time. Downside planning should acknowledge constraints rather than describe every response as costless and instant.
A hypothetical seasonal lending forecast
Imagine an Australian outdoor equipment distributor seeking finance for a larger seasonal stock order. Its initial spreadsheet assumes customer cash arrives in the month of sale, producing a comfortable repayment profile. Historical records show that wholesale customers pay later and that some inventory remains unsold after the peak. Management rebuilds receipts using observed payment patterns and separates retail receipts from wholesale collections. The revised working capital forecast identifies an earlier and deeper cash requirement. It also includes freight deposits and annual insurance that were missing from the first version, giving the lender a more accurate picture of the request.
The distributor then tests slower sales and delayed customer payments. Rather than asking the model to assume unlimited facility availability, it considers staged stock purchases and negotiates smaller supplier deposits where commercially possible. Management preserves a reserve for payroll and sets a trigger for reducing replenishment orders. A forecast pack explains the assumptions, downside results and supporting records. In this hypothetical case, the revised request could be larger, smaller or differently structured than originally expected. The important outcome is that borrowing is linked to the cash conversion cycle, with a practical plan for monitoring whether events are unfolding as forecast.
Steps to prepare the forecast pack
- Reconcile opening cash, receivables, payables and debt to current records. Gather customer terms, supplier commitments, payroll information, tax payment expectations and documents supporting the expenditure the finance will fund.
- Build receipts and payments around actual timing, then integrate the proposed facility and existing debt. Show assumptions clearly and check that cash, profit and key balance sheet movements remain consistent across the forecast.
- Test realistic downside cases and document management responses. Have the accountant or another appropriate independent adviser review the pack, then update actual results regularly so the forecast remains an operating tool after the lending decision.
Forecasting questions
Should the forecast show only positive months?
No. A cash shortfall can reveal the very reason finance is required. Concealing it prevents a useful assessment of timing and facility size. Explain how the shortfall would be funded and whether the proposed arrangement remains available under those conditions. Transparent assumptions are more useful than a model adjusted to produce consistently attractive balances.
Can historical accounts replace a forecast?
They provide evidence but do not fully explain future cash timing, new spending or proposed repayments. Use history to support assumptions, then model the changed position. A forecast should also reflect recent developments that older accounts do not capture. The required detail depends on the business, lending purpose and provider's assessment process.
How should actual results be used?
Compare them with the forecast, investigate differences and update future periods without erasing the record of earlier assumptions. Persistent collection delays or margin changes may require action, not simply another optimistic revision. A rolling review supports better debt management and lender communication, while accounting advice helps maintain consistent treatment of cash and noncash items.