Financial Modelling ExampleLong Range Plan Financial Model
Long Range Plan Financial Model
Client:
Multi national, multi site international entertainment company.
Project:
To rebuild the existing long range forecast model which supported the group business plan. Multi-site, multi currency.
Reason for new model:
Although an excellent model, the current model lacked capacity for growth and scenario analysis.
Inputs:
System trial balances for historical financial data, manual inputs for non financial historical data. Forecast performance drivers input individually by territory (Market and company) for revenue and costs.
Structure:
Group and territory models, Data - Quarterly, 10 years history, current year budget, current year forecast, 5 year long range forecast.
Outputs:
Profit and Loss, Balance Sheet, Cashflow, Capex Schedule. Covenant schedule. Price vs Volume analysis, Property Schedules.
Challenges:
The large volume of sites (230), detailed analysis required and volume of data meant that the model was unavoidably large.
With our experience in developing complex long range plan financial models in Excel within a range of industries, our London financial modelling consultancy is a responsive and competitive alternative to hiring an interim financial modeller.
