Financial Modelling ExampleConsolidation Financial Model
Consolidation Financial Model
Client:
Saas provider
Project:
Consolidate a number of subsidiaries to produce monthly and annual Internal reporting and reporting to shareholders.
Reason for new model:
Lack of transparency of current process and no functionality to incorporate additional subsidiaries
Inputs:
Excel Trial Balances
Structure:
Monthly. Prior Year. Last 12 Months, 10 years history, Budget, multiple forecasts
Outputs:
Profit and Loss, Balance Sheet, Cashflow, Capex Schedule.
Challenges:
Complex Mapping between legal and reporting entities
Observations:
With our experience in developing consolidation 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.
