top of page
Simple financial forecast model

Simple financial forecast model


The purpose of the model is to enable the user to enter some simple assumptions in order to produce a simple three statement financial forecast and valuation.



  • Integrated Financial Statements including Income Statement, Balance Sheet and Cash Flow
  • Dashboard including key summary financials, results, sales split, sources & uses & exit, and valuation 



  • The model has a monthly timeline that runs for 8 years
  • There are annual summaries
  • A flexible model start date and flexible forecast start date
  • The ability to include both historical actual data and produce forecast data
  • The ability to enter historical Profit and Loss balance and an Opening Balance sheet



  • The ability to update the model units
  • The model provides check and commercial alert messages to assist the user in making sure that the Opening Balance Sheet balances



  • Sales entered annually and spread over a 12 month period (based on a user defined seasonality trend)


Cost of sales

  • Cost of sales entered on an annual gross margin assumption


Administration costs


  • Administration costs are entered annually as a percentage of sales


Fixed assets

  • Capital expenditure is entered annually and spread on a monthly basis
  • Depreciation is calculated on a straight-line basis


Working capital

  • Includes stock, debtors, creditors and VAT (sales tax)
  • Stock is calculated on a inventory days assumption based on cost of sales
  • Trade debtors is calculated on a debtor days assumption and based on total sales
  • Trade creditors is calculated on a creditor days assumption and includes administration expenses and capital expenditure
  • VAT/sales taxes are based on an annually entered percentage rate and calculed on both sales and costs (including capital expenditure) and are paid based on flexible payment flags


Income/corporation tax

  • Enter an effective tax rate and manually enter the tax payments



  • Interest rates are entered annually for both cash balance and overdraft balances



  • Manually entered dividend distribution




  • Ability to enter a date on which the valuation is taken
  • User enters a terminal growth rate
  • The discount rate is built up from multiple assumptions and is calculated using a weighted average cost of capital calculation (WACC)
  • Valuation is calculated using the net present value methodology
  • T&Cs

    Refer to T&Cs page for Terms and Conditions of sale

bottom of page