Tags: Most Inspirational People EssayAnomie Theory EssayCorruption Good EssayThesis Statement For Julius Caesar EssayQualitative Doctoral DissertationAppendix Paper Research WriteShort Essay Cultural DiversityEnergy Drink Business Plan
Enter a number in the white box to show the expected annual price increase of your products to enable the spreadsheet to calculate income in future years.
This will be used to calculate your operating expenses in the profit and loss sheet.
Use the white box to enter the number of years you expect your assets to depreciate over.
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.
If your business is just starting out, you may be able to command higher prices for your products or services as the years go on, as you build up brand recognition and a good reputation.
The funding section allows you to enter information about your business loan.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.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.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.To use this section, simply fill in the three white boxes representing the amount of the loan, the annual interest rate and the term of the loan in months - for example, 12 for 1 year, 24 for 2 years, 36 for 3 years, 48 for 4 years, or 60 for a 5 year loan.This sheet calculates your profit and loss for each year over a 5 year period.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.