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.Tags: Oppression Essay Marilyn FryeBusiness Plan For Security CompanyMasters Online No Thesis Education Educator EducatorsDemonstration Speech AssignmentMath Makes Sense 5 Homework BookThesis Dissertation DatabaseTeenage Love Essays1999 Ap Biology EssayBlack Balloon Movie Essay
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.
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.
Use the Model Inputs sheet to enter information about your business that will be used to model results seen on the other pages.
The forecasted revenue section allows you to estimate your revenue for 4 different products.
Enter the annual tax rate that applies to your circumstances in the white box in Column B.
If you have to pay any other taxes, these can be entered later on the Profit and Loss sheet.
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.