Working with 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. 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.

This course is available on an in-house, open or tutor-led distance learning basis.

Book and pay online for your place below, or contact us to request an invoice.

What will you learn?

By the end of the course you will be able to:

  • Navigate and read models more effectively
  • Understand the best practices that models should follow
  • Perform technical reviews of models, including reviewing them for inconsistent formulas, embedded constants, unused inputs and workings
  • Build a best practice input structure including scenario and sensitivity functionality
  • Use Excel structures to maintain version control and an audit trail
  • Undertake high level analytical reviews of a model’s outputs and a more focussed review on targeted elements of the model

Who should attend?

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.

Image

Book your course

Change currency

All of our courses are now available as Tutor-led Distance Learning: contact us to learn more about this option. If you’d like to receive special offers and discounts via email let us know.

Date
Format
Location
Duration
Instructor
Price
12 & 14 Jan 2021 (GMT time zone)
Tutor-led distance learning
live online
12 hours
John Dimberline
£495
Dates to follow
Classroom-based
London
1 day
John Dimberline
£950

Course Topics

Set up
  • Working with a new model.
  • Using Excel functionality and shortcuts for model navigation and review.
  • Creation of a version control structure.
High-level model review
  • Familiarisation with the model’s features.
  • Performing a high-level analytical review of the outputs.
Model risk
  • Explanation of best practices and why they’re important.
  • Consideration of the level of risk the model poses and the importance of the model's results.
Technical review
  • Technical review of the model.
  • Inconsistent formulas, embedded constants, unused inputs, unused workings, Excel errors, misplaced inputs.
Targeted model review
  • Interrogating formulas.
  • Further technical review.
  • Consideration of other review methods.
Scenarios and sensitivities
  • Implementing a best practice structure for scenarios and sensitivities.
  • Running scenarios and analysing the impact on the model’s outputs.
Find out more:
Working with Financial Models training course
Looking for live online training?
Tutor-led Distance Learning

Any of our courses can be delivered as tutor-led distance learning - to learn more about this interactive and flexible option call Andrew Berkley on +44 20 3239 8534 or email info@f1f9.com.