A simple-to-use spreadsheet that takes you through the process of building your sales, costs and investment forecasts and then automatically generates the financial statements and dashboard information that you need for your first few years in business.
This nugget was developed by Christian Hertach, Jacques Hefti, Dr. Johan Björck and Dr. Ben Graziano.
To help you with your financial forecast we have constructed a simple-to-use template that is suitable for a startup business.
All you need to do is provide the three key sets of underlying data for the forecasting period (e.g 3-5 years) related to:
With this information, the spreadsheet will construct the three financial statements (the Profit and Loss Statement, the Cash Flow Statement and the Balance Sheet) and a dashboard of key performance metrics for you.
For a quick introduction to the spreadsheet, you can watch the film below:
Here are some example cases for you to follow, with full descriptions and video explanations: