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.
and these names will be carried through to the rest of the spreadsheet.
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.
Forecasted financial statements help an entrepreneur determine the feasibility of his/her business venture.
Also, forecasted financial statements help to estimate the amount of money an entrepreneur will need in order to successfully launch and operate the proposed endeavor.
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.
This may vary greatly from business to business, as assets in some sectors depreciate much more quickly than they do in others.
In most parts of the world, you will have to pay income on your earnings.