All templates

Cash Flow Forecast Template for Business Loans

See how a proposed loan changes each month’s cash balance and download the 12-month forecast as an editable spreadsheet.

Forecast start

Choose any day in the first month.

Cash on hand at the start of the first month.

Monthly receipts and payments

Cash from customers before GST.

Materials and other direct costs before GST.

Include staff wages and super paid.

Recurring business costs before GST.

Include tax, equipment and drawings paid from cash before GST.

GST in customer payments received.

GST in bills paid during this month.

Enter a refund as a negative amount.

Principal and interest paid on current loans.

Enter the total due in this month.

Results

Lowest monthly closing cash

-$1,230

Lowest month

Jan 2027

Annual cash cover

2.24×

Lowest closing cash -$1,230 in Jan 2027. Annual cash cover 2.24×.

Closing Cash by Month

Lowest closing cash -$1,230 in Jan 2027. Annual cash cover 2.24×.

Lowest closing cash -$1,230 in Jan 2027. Annual cash cover 2.24×.

Jan 2027 Cash Flow

ItemAmount
Opening cash$7,800.00
Total receipts$42,680.00
Non-debt cash payments$47,260.00
Cash before debt service-$4,580.00
Total loan repayments$4,450.00
Closing cash-$1,230.00

12-Month Closing Balances

MonthClosing cash
Jan 2027-$1,230.00
Feb 2027$8,440.00
Mar 2027$20,970.00
Apr 2027$21,360.00
May 2027$30,920.00
Jun 2027$38,720.00
Jul 2027$34,910.00
Aug 2027$42,710.00
Sep 2027$55,130.00
Oct 2027$58,120.00
Nov 2027$72,410.00
Dec 2027$74,160.00

All amounts are AUD. The forecast starts with the cash you enter and assumes no new loan proceeds.

Build the Monthly Forecast

Set the first month and enter the cash the business expects to have on hand that morning. Pick a month to enter its receipts and payments. Put each amount in the month the money changes hands. If a builder pays a March invoice in May, the receipt goes in May.

Enter sales, cost of sales and overheads before GST. Use the GST rows for the GST collected from customers, the GST paid to suppliers and the GST settled with the Australian Taxation Office (ATO). Enter the last amount in the month the business expects to pay it or receive a refund. A refund goes in as a negative amount. Enter existing and proposed principal and interest separately, using the total due that month. Enter zero in months with no amount due.

Closing cash is opening cash plus receipts less all cash payments, including the two loan repayment rows. Each closing balance carries forward to the next month. The forecast starts with the cash on hand that you enter. If loan drawdowns or other funding will materially change the balance, ask the accountant to model them separately.

NAB’s business finance checklist includes a cash flow budget and assumptions for the next 12 months. CommBank’s application guide lists cash flow projections among the documents it might ask for from a startup or a business with less than 12 months of trading. Confirm the period and format with the lender before lodging.

Download It as a Spreadsheet

Select Download Excel to save the current forecast as an editable .xlsx file. Open it in Excel and change the green cells to update the start month, opening cash or monthly amounts. Leave the formula cells in place so closing cash carries forward and annual cash cover recalculates. The browser prepares the file on your device.

Add the assumptions behind the forecast at the bottom of the sheet. For example, note which customers usually pay after 30 days and when the first repayment falls. Send the workbook to the client or their accountant so they can check the figures before it goes with the application.

Show the New Loan Repayment is Covered

Check the lowest monthly closing cash after both loans are paid. A negative balance shows the month the business would run short and the size of the projected shortfall. A positive month-end balance can still hide a gap if wages or a repayment falls before customers pay. Check the dates of large payments in tight months.

Subtract the cash payments above the loan rows from total receipts for the year to get cash before debt service. This includes GST movements. Divide that result by the year’s total existing and proposed repayments to get annual cash cover. Above 1×, the forecast produces more cash over the year than it needs for the scheduled repayments. The lender can calculate debt service cover on a different basis. CommBank’s business finance terms, for example, define a ratio using adjusted earnings. Use the lender’s method and test the monthly cash balance separately.

A Worked Example for a Trades Business

In the prefilled example, a fictional electrical contractor starts January with $7,800. Receipts dip after the holiday break. January sales bring in $38,800 before GST. The business collects $3,880 in GST and pays $2,360 in GST to suppliers, with no GST settlement to the ATO due in January. Its existing repayments are $1,750 a month and the proposed loan adds $2,700 a month.

January closes $1,230 short. February’s sales lift the balance back to $8,440. July is another tight month. A $10,400 GST payment to the ATO leaves $640 of cash before $4,450 in repayments, so the contractor draws on cash brought forward from June.

Fictional electrical contractor forecast in AUD
MonthOpening cashReceipts incl. GSTNon-debt paymentsLoan repaymentsClosing cash
Jan 2027$7,800$42,680$47,260$4,450-$1,230
Feb 2027-$1,230$65,120$51,000$4,450$8,440
Mar 2027$8,440$70,620$53,640$4,450$20,970
Apr 2027$20,970$67,650$62,810$4,450$21,360
May 2027$21,360$66,440$52,430$4,450$30,920
Jun 2027$30,920$63,690$51,440$4,450$38,720
Jul 2027$38,720$61,820$61,180$4,450$34,910
Aug 2027$34,910$64,020$51,770$4,450$42,710
Sep 2027$42,710$70,290$53,420$4,450$55,130
Oct 2027$55,130$71,940$64,500$4,450$58,120
Nov 2027$58,120$73,920$55,180$4,450$72,410
Dec 2027$72,410$53,240$47,040$4,450$74,160

Across 12 months the contractor has $119,760 before debt service and $53,400 in loan repayments, giving cash cover of 2.24×. January still needs another $1,230 at month-end. The broker can check whether the cash is available before the first repayment falls due.

Track My Trail Team

Read more

We develop software to simplify trail book management for mortgage brokers. Our tools provide fast and practical insights to help brokers get the most out of their trail books.