Financial model & budgeting model for a Stock Exchange
The client, is a holding company in Middle east with 4 companies under it, including a stock exchange, depository, financial securities company and tech innovation hub.
Problem Statement
We were engaged to deliver a robust financial model which included:
- Comprehensive model for the entity including all the holdings
- Reconstructing the existing financial model and making it dynamic
- Making it easy to automate procedures and update inputs
Action Taken
- Developed an input data template
- Updated historical data from previous model
- Calibrated the automation structure
- Designed the output template (revenues, expenses, balance sheet and cash flows)
- Constructed a taxonomy structure for revenue and costs.
- Automated the financial update processes
- Made a scalable structure for their various strategic initiatives
Deliverable
- Delivered a well integrated and dynamic financial model with automated processes.