This may vary greatly from business to business, as assets in some sectors depreciate much more quickly than they do in others.
This may vary greatly from business to business, as assets in some sectors depreciate much more quickly than they do in others.Tags: Music And Mathematics Research PaperImage Processing Iit ThesisHow Solve Math ProblemsExample Of College Application EssayEssay Writer.Org CodeComplete Research PaperWrite My Essay ReviewsHome Daycare Business Plan SampleEssay Creative Thinking Saves The Day
Some parts of this are already filled in based on information you put on the Model Inputs, for example, depreciation, maintenance and interest on long-term debt.
Years 2-5 are also filled in for you across all categories based on the inflation information entered in the Model Inputs sheet.
At the bottom of this section is a space for you to enter any other current assets you may have that do not fall into any of these categories.
Depending on the nature of your business, you may have assets such as Buildings, Land, Capital Improvements and Machinery.
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.
Income Tax is filled in based on the information you enter into the model inputs.These can be entered manually in the white cells in Column B for Year 1, Column C for Year 2 and so on.There are pre-entered categories for rental, lost income and loss (or gain) on the sale of assets, as well as an additional row where you can enter your own non-operation income.The spreadsheet will automatically calculate the annual cost of goods sold based on this information, along with your forecasted revenue.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.Simply use the white boxes to enter the number of units you expect to sell, and the price you expect to sell them for, and the spreadsheet will calculate the total revenue for each product for the year.If you want to give your products names, simply type over the words "Product 1", "Product 2" etc.Although you cannot be certain of the level of inflation, you will still need to try and plan for it when coming up with a 5-year financial plan.The International Monetary Fund provide forecasts for a number of countries, so is a good place to look if you are unsure what to enter here. As a consumer, you are no doubt aware that the price of products goes up over time.The profit and loss assumptions, along with income, are automatically calculated using information entered in the model inputs sheet.You may have, or be expecting some income in addition to your operating income.