Docstoc

Cashflow Forecast Template - Excel - Excel

Document Sample
Cashflow Forecast Template - Excel - Excel Powered By Docstoc
					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.


				
DOCUMENT INFO
Shared By:
Stats:
views:12628
posted:1/3/2008
language:English
pages:4
destined destined
About