Working with Financial Models
Making sense of existing financial models
Working with Financial Models teaches the principles and skills needed to work safely and effectively with financial models, including how to test and review them. What you learn may be applied to any financial models, regardless of how they have been designed and constructed. The course is practical and hands-on, and suitable for all model types and business sectors. It includes ongoing post-course support from our team of expert modellers.
Book Your Course
| Date | Format | Location | Duration | Instructor | Price | |
|---|---|---|---|---|---|---|
| As requested | In house | As requested | As requested | Any | Variable | Enquire |
Our Clients
Course Content
What will I learn?
We will learn how to navigate and read models more effectively, including understanding the best practices that models should follow. We will perform technical reviews of models, including reviewing them for inconsistent formulas, embedded constants, unused inputs and workings.
We will build a best practice input structure including scenario and sensitivity functionality, use standard Excel structures to maintain version control and an audit trail and undertake high level analytical reviews of a model’s outputs and a more focussed review on targeted elements of the model.
Is this course right for me?
This course is designed for professionals who need to work with and rely on complex financial models, either on an ongoing basis or to support a particular transaction.
The case study for the course is based upon a going concern but the principles and techniques we teach are transferable to all business sectors and all types of financial models.
Course Topics
Initial high level review
- The case study
- Model familiarization
- Analytical review of outputs and inputs
Establishing the review environment
- Overlay sheets
- Maintaining audit trail
- Reviewing changes in model outputs
Detailed techniques
- Technical review
- Running scenarios
- Delta sheets
Meet Our Instructors
John Dimberline
John has 18+ years of experience and has led advisory teams on many complex projects supporting both public sector procurers, private sector bidders and corporates. Formerly head of financial modelling at Grant Thornton, John leads the senior management team at F1F9.
Andrew Berkley
With a background in business education and financial advisory work, Andrew leads training delivery at F1F9. Andrew has delivered financial modelling courses to numerous institutions including European Bank of Reconstruction and Development, Deloitte, KPMG, Grant Thornton and Siemens.
Omar Shaker
Omar is a highly experienced financial modeller having spent 15+ years building FAST compliant and best practice models in the project finance advisory (debt and equity) sector. He has worked on some of the largest transactions globally with an aggregate value exceeding USD 20bn. He is fluent in Arabic both written and spoken.
Morten Siersted
Morten founded F1F9 in 1999. He has played a key role in developing the FAST Standard, including setting up the FAST Standard Organisation in 2011.
Client Reviews
S. C. Invest NL
I liked the format and the fact that you are building up the model. i think the course was most helpful when you needed to think for yourself and build a part – perhaps more time spent doing this would have been good.
S. V.EBRD
Thanks a lot for the course, it was very useful and well structured. The instructor explained it awesome!
Jord W.
Excellent training! well thought program, really guiding you through the process of setting a financial model! I can really recommend it to everybody who is interested in following a financial modelling course.
Maryam Ahmed Network Rail
Great course- has given me a solid foundation to understand and build basic models within my role. Pacing is good and found the tutor’s instructions to be very straighforward to follow. Highly informative and will definitely consider coming back for the next level once I have put some of the skills learnt on this course into practice. Thank you
Charles Serinet SUEZ
Very useful to understand the impact of changes in revenue, gearing, DSCR on CFADS, Average DSCR, Div and Equity IRR. Very interesting as well to build step by step the balance sheet, P&L and CF to understand the connections between each statements. The track and resources tabs are really useful too.
Michael Leonhart KPN
The structure of the course was good and gave a good insight in how to build the consistent model. Sometimes, it was more about doing rather than really understanding why, so maybe a little more time spend on that topic would be nice. In general I learned a lot about the various shortcuts an modelling in general.
Mthandeni Vilakazi, AIIM
Specifically found the shortcuts and best-practice principles on model construction particularly helpful in improving productivity and efficiency. I also appreciated the use of a tracking sheet, as well as the time taken to explore alternative functions and approaches to understand their limitations.
Agie Turowska, Network Rail
The practical tools were great and will be very handy to pass on and help my colleagues too. The format was very good and easy to follow. I liked that we had two instructors helping when anyone got stuck while the rest were able to carry on.
Anonymous
Andrew was comprehensive, friendly and attentive. He managed the group very well, catered to all learning speeds, and ensured everyone’s questions were answered without disrupting the flow of the course.
Mthandeni Vilakazi, AIIM
The shortcuts and model construction best practices were particularly helpful in improving my productivity and efficiency. Andrew and Judith were phenomenal, the pace of teaching was excellent and very accommodating.
Get In Touch
Are you or your team looking to increase their financial modelling skills? Are you interested in team-based training focused on best practice and standardised approaches? Are you hoping to build up your own skills and expertise?
Our financial modelling instructors would be pleased to hear from you…