For example, certain expenses will be the same or close to the same every month, including rent, insurance, and others. In order to prepare a comprehensive financial plan, the best method is to first prepare a pro forma financial statement.
You will also need to consider the current market and other economic conditions. You should have a figure for each individual year as well as a figure for the full three-year period.
In fact, sales forecasts based on a solid understanding of industry and market trends will show potential investors that you've done your homework and your forecast is more than just guesswork.
If you want to change a formula, we strongly recommend that you save a copy of this spreadsheet under a different name before doing so. Continue Reading.
The COGS forecast relates to your sales forecast. Download the Free Guide Three steps to creating your financial forecast Ready to peer into the crystal ball and see the future of your business?
Assess expense accounts one type of expense at a time.