Complex Modelling

Design and development of complex models

We know that financial models can be complicated. At BDO we design our models to be user friendly, flexible and tailored to your needs.

All of our models are built using our established best practice methodology and independently quality assured by our separate model review team.

We have a highly experienced team of model developers with extensive commercial, technical and financial knowledge across a variety of sectors.

Model build experience

Project finance, PPP projects, IPOs, business planning and operational forecasting, portfolio analysis, post-financial close reporting.

Technical skills
Advanced MS Excel and VBA Programming, Optimisation, Monte Carlo simulation.

Sector experience
Energy (including alternative energy), oil and gas, mining, infrastructure, construction & materials, waste management, property, retail and leisure, environmental projects, healthcare, finance, telecoms, FMCG.

Our Model Build Approach

STEP 1	STEP 2	STEP 3	STEP 4	STEP 5	STEP 6
Develop an understanding of your business objectives and information requirements	Consider and define the strategic options in sufficient detail	Aim to produce the most efficient structure	Build the model to the specifications developed in previous steps	Business review of model functionality	Run strategic options/scenarios
Develop project plan and scope document	Develop the model inputs and outputs and define the calculations	Build prototypes and templates for final review and discussion	Weekly progress updates	Analytical review of scenario results	Deliver reports and recommen-dations
Agree on project scope and determine project deliverables and timings				Technical review of model	Model hand-over and user training