Cashflow forecast for the year ended
July Receipts Sales GST collections Other Total Receipts Payments Purchases creditors Labour costs: Wages, loading Superannuation Workers comp. insurance Overhead costs: Accounting fees Advertising Bank fees Cleaning costs Electricity and gas Insurance Interest on overdraft Motor vehicle expense Printing and stationery Rates and taxes Rent, variable outgoings Repairs and maintenance Telephone GST paid Subtotal Capital costs and drawings Loan repayments Proprietors' drawings GST paid to ATO Total payments Bank balances Opening balance Add total receipts Less total payments Closing balance 0
30 June 2007 Aug Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
TOTAL 0 0 0 0
0
0
0
0
0
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Page 1
D:\Docstoc\Working\pdf\90245468-9c7d-4f59-98c6-dbd7f2ea0607.xls
CASHFLOW FORECAST This simple Cashflow forecast consists of three sections each going across the page: the first for receipts - inflows of cash; the second for payments - outflows of cash; and the third for calculating the bank balance at the end of each month. There is a row (line) for each category of anticipated receipts and expenses.
For each category of receipts and payments, plot anticipated inflows and outflows of cash fo
The excel spreadsheet will automatically calculate the total receipts and payments for each m and the anticipated bank balance at the end of each month and at the end of the year.
Note that the closing bank balance at the end of the last month (June), must equal the closi
This format has been taken from the SBDC publication Step-by-step business plan . This publication may be purchased from the SBDC online bookshop, or from the SBDC Busin
The publication contains more detailed instructions, and formats for sales forecasts, debtors payments to creditors, and for statements of financial performance and position.
ng across the page:
ach month. expenses.
ws and outflows of cash for each month, in the appropriate column.
ts and payments for each month and for the year, t the end of the year.
June), must equal the closing bank balance shown in the total column.
ep business plan . op, or from the SBDC Business Information and Licence Centre.
or sales forecasts, debtors’ collections, ce and position.