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