Getting Started

We have built the one-page financial model template to have everything you need for including financial forecasts in your business planning or investment round.

👊 Firstly, a little bit on what you can do with the model

This model will allow you to build the next five year forecasts of your business, in practice this means;

• Build the Income Statement, Balance Sheet and Cashflow Statement of your business
• Build a Resources Plan and Corporate Investment Plan
• Map out up to three funding rounds which can be split out into a equity / debt structure
• Understand the company valuations for each round (pre / post money)
• Understand the changes to the Cap Table 
• Understand the investor returns
• Map out the Enterprise Value over the year using three well known methodologies 
• Tables and charts, that you can easily copy and paste into your investment docs
• Give your self corporate target KPIs and compare against the model outputs

 

👊 How the model works

The model is fully dynamic and so there are only a few cells that require input from you - all the other cells will take those inputs and add the calculations around them to produce the outputs.  All the key sections are on the same sheet and are the model works from left to right with each section and sub-section clearly titled and referenced.

To make things easy, we have also added clickable buttons that let you navigate the spreadsheet and get back to the place where you want to be - this key can be seen below:

 

👊 How the model is structured

As mentioned the model works from left to right and is made up of three sections 

1.  The inputs - this is where you put in the inputs that are relevant to your business and these will drive the outputs
2.  The Calculations - this is what much of the analysis is carried out and the financial statements are built
3.  The Outputs - this is the section where the results of the financial model are presented which in the case of this model is made up of a Summary Financials and KPIs, Funding Summary, Presentation Summary and Financial Statements

We have worked very hard on the design and UI of the model to ensure that it remains one of the easiest Excel / Google Sheets based models on the Internet.  This means we have focussed on consistency in formats and colours and provided additional guidance within the model itself and this supporting documentation.  However, we know there is always room to improve so please do give us feedback good and bad and if you have purchased this template through a third party platform, please drop us a review - it helps massively.  Equally, if the model does not quite do what you need, we can provide bespoke upgrades and modelling - please get in touch.

Thank you for reading and happy forecasting!