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

© 2019 Excel Model Shop

Free model template (coupon: SAMPLE)

Purpose

The purpose of the model is to enable the user to experience the style of excel models and tools sold on excelmodelshop.com for free. To get your free sample enter "SAMPLE" as a coupon code in at checkout.

 

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 and IRR

 

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 when entering opening Balance Sheet assumptions

 

Sales

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

 

Cost of sales

  • Cost of sales are calculated based on an annual gross margin assumption

 

Administration costs

  • 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

  • No working capital assumptions

 

Corporation / company income tax

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

 

Valuation

  • Ability to enter a date on which the valuation is taken
  • User enters a terminal growth rate
  • User enters an assumed discount rate
  • Valuation is calculated using the net present value methodology
  • T&Cs

    Refer to T&Cs tab for Terms & Conditions of sale

£0.01Price