Click here to download (.xls template)
We've already put in the required formulas so once you've added your ongoing and outgoings you should be left with a fully-fledged forecast!
Tips for completing the forecast template
Owner’s contribution is any personal money you put into the business. Owner’s drawings are any amounts you took out for personal use. Only fill out the ‘Money from loans’ row if newly borrowed money hits your account during the period. Don’t put existing loans in there.
Some costs can go in multiple places. Car insurance could go under insurance or vehicles, for instance. Don’t sweat the decision too much. Just stay consistent once you’ve made a call.
The numbers to watch...
- Net cash flow: shows whether you’ll be putting money in the bank or scrambling to meet costs.
- Closing balance: a negative amount suggests you may need to delay expenditures if you can or sort out some finance.