Projecting Business Overheads for Business Plans & Budgets
The South Cork Business Alliance asked us to do a short presentation on financial projections for business plans. We decide to develop a spreadsheet that would allow users to prepare a monthly plan of overheads very quickly and to calculate a breakeven point.
It should be noted that preparing a budget or plan is just the start of good financial control. It is also essential to record your actual income and expenditure accurately and compare the outcome with the plan to allow you to run your business effectively. We have excellent software that can help in this regard.
Click here to download the spreadsheet.
The spreadsheet is very simple to use. First you input the starting date for the projection.
Then you input your individual expected expenses as:
- Annual Totals (A)
- Monthly Amounts (M)
- Quarterly (Q)
You can then decide how regularly each expense is to be paid as follows:
- Annually (A)
- Half Yearly (H)
- Quarterly (Q)
- Monthly (M)
You can also input the month of the first Payment for each expense.
If you need to add more expense items copy an existing row and insert it. There are a number of hidden formulae that have to be copied in order for the spreadsheet to work.
The spreadsheet will automatically calculate your monthly overheads and the totals.
There is also a tab for calculating your breakeven point and what level of sales are required to break even.
If you have any problems contact me by clicking here.
| Next > |
|---|