• Facebook - White Circle
  • Twitter - White Circle
  • LinkedIn - White Circle

© 2019 Excel Model Shop

Simple financial forecast model

Purpose

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.

 

Outputs

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

 

Timeline

  • 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

 

General

  • 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

  • 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

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

 

Dividend

  • Manually entered dividend distribution

 

 

Valuation

  • 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

£50.00Price