![]() Use the white box to enter the number of years you expect your assets to depreciate over. This will be used to calculate your operating expenses in the profit and loss sheet. Annual Maintenance, Repair and OverhaulĪs 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. The spreadsheet will automatically calculate the annual cost of goods sold based on this information, along with your forecasted revenue. Your margins are unlikely to be the same on all of your products, so the cost of goods sold allows you to enter your expected gross margin for each product into the white boxes in Column B. and these names will be carried through to the rest of the spreadsheet. If you want to give your products names, simply type over the words "Product 1", "Product 2" etc. ![]() 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. ![]() The forecasted revenue section allows you to estimate your revenue for 4 different products. Use the Model Inputs sheet to enter information about your business that will be used to model results seen on the other pages.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |