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