Financial Plan Template 3 - Free Download
4.4, 2945 votes
Please vote for this template if it helps you.
How to use this template
Step 1 Set a starting point for your projections
Start date 2009-1-1
Step 2 Set-up costs
Use the set-up costs sheet to calculate the cost of setting up your business.
Step 3 Profit and loss forecast
Step 4 Cash flow forecast
Step 5 Balance sheet forecast
Step 6 Break-even analysis
Enter figures in any white field. The yellow fields are calculated for you.
Save the template (XLT file) to your computer. Double-click on it to create a new plan,
then follow these steps:
Forecast your month-by-month profit and loss for the first 12 months of operations. Enter sales in
the month when they're invoiced, rather than the month when they're paid.
Forecast your month-by-month cash flow for the first 12 months of operations. Enter sales revenue
in the month when it's received, rather than the month when it's invoiced.
Forecast your balance sheet position at the end of the first 12 months of operation. The balance
sheet draws on the figures you've entered in your profit and loss forecast.
Find out how many sales you need to make in the first 12 months to cover your fixed costs and
Enter as much or as little information as you like. The more information you record, the better your
By default, the sheets in this template are locked, so that the formulas cannot be changed. If you are
a confident Excel user, you may wish to unlock a sheet and modify it.
Please send any feedback or questions to firstname.lastname@example.org
The figures shown in this Financial Forecast spreadsheet are intended as a guide only. It has been
prepared without considering your objectives, financial situation or needs. Before acting on the
calculations in this spreadsheet, you should consider its appropriateness to your circumstances.
The Commonwealth Bank accepts no responsibility for any financial loss resulting from the use of
this spreadsheet. We recommend you seek professional advice before acting on the information or
calculations contained in it.