Comments are normally hidden from sight. Annual Maintenance, Repair and Overhaul As the cost of annual maintenance, repair and overhaul is likely to increase each year, you will need to enter a percentage factor on your capital equipment in the white box in Column B.
Forecasted Revenue The forecasted revenue section allows you to estimate your revenue for 4 different products.
The Unexpected Expenses row allows you to enter a contingency for unexpected expenses, whilst the Other Expenses row allows you to enter any other one off expenses you may be expecting to make, for example the purchase of new equipment part way into your 5 year plan.
You can also see a completed sample by downloading the Ann's Nursery Example.
Property and Equipment Depending on the nature of your business, you may have assets such as Buildings, Land, Capital Improvements and Machinery.
If you want to give your products names, simply type over the words "Product 1", "Product 2" etc.
The spreadsheet will automatically calculate the annual cost of goods sold based on this information, along with your forecasted revenue. This will allow you to get an idea of whether or not you can afford to borrow a bit extra, if you feel it would allow you to push your business into higher places, or whether you need to shop around for a better interest rate or adjust the loan term in order to afford the loan payments.