top of page



User-friendly Excel model intended for the preparation of a 3 statement (Income Statement, Balance Sheet and Cash flow Statement) 5-year financial projection for a generic start-up or existing business


The model follows good practice financial modelling principles and includes instructions, checks and input validations.





The key outputs include:

  • Projected full financial statements (Income Statement, Balance Sheet and Cash flow Statement) across 5 years.
  • Dashboard with
    • Summarised projected Income Statement and Balance Sheet
    • List of key metrics including Average revenue growth, Average profit margins, Average return on assets and equity and Average Debt to Equity ratio
    • Bar charts summarising income statement and Balance Sheet projections





Inputs are split into setup, actual and projection inputs and include input validations to help users populate correctly.


Setup Inputs:

  • Name of business;
  • Currency;
  • First projection year


Projection Inputs:

  • Revenue and other income inputs;
  • Expense inputs including cost of sales percentages, marketing and general admin expenses;
  • Corporate tax and interest rate inputs
  • Fixed Assets including addition amounts and useful life;
  • Working capital inputs including average debtor and creditor days and inventory percentages;
  • Borrowings including addition amounts and interest rate;
  • Share Capital additions and dividend distributions





The model comprises of 9 tabs split into input ('i_'), calculation ('c_'), output ('o_’) and system tabs. The tabs to be populated by the user are the input tabs ('i_Setup', ‘i_Actuals’ and 'i_Assumptions'). The calculation tab uses the user-defined inputs to calculate and produce the projection outputs which are presented in 'o_Fin Stats' and ‘o_Dashboard’

System tabs include:

  • A 'Front Sheet' containing a disclaimer, instructions and contents;
  • A Checks dashboard containing a summary of checks by tab.





Other key features of this model include the following:

  • The model follows good practice financial modelling guidelines and includes instructions, checks and input validations to help ensure input fields are populated accurately;
  • The model includes an 8-year timeline consisting of 3 years of actuals (if applicable) and 5 projection years;
  • The model is password protected (a non-password protected version is also available);
  • Apart from projecting revenue and costs the tool includes the possibility to model receivables and payables, fixed assets, borrowings, dividends and corporate tax;
  • Business Name, currency, starting projection year are fully customisable
  • The model includes a checks dashboard which summarises all the checks included in the various tabs making it easier to identify any errors.





If you require any be-spoke modifications or support, we are more than happy to assist. Please send us a message below or contact us on

5-Year 3-Statement Financial Projection Model - Password Protected

  • 1 Blank Excel model & 1 Excel model with a populated example

bottom of page