Leading Advisors in Project Finance

Assessing & Interrogating Financial Models Course2 day course

Overview

Learn a time-saving, dependable and repeatable method for understanding and checking unfamiliar financial models and running sensitivities through them.

This 2-day course teaches a reliable method for understanding unfamiliar financial models in project finance; applying some basic but insightful checks to them; and using them to perform sensitivity analysis. It is based on real-world techniques used by Operis analysts in their daily work.

It is aimed at professionals working in or around project finance who are not necessarily financial modelling experts, who nevertheless have to grapple with models which are written in a wide variety of styles by outsiders.

VAT of 20% is required to be levied for training courses conducted in the United Kingdom. Training courses conducted outside the UK may include local sales taxes, where applicable. The fees below are quoted net of any taxes.
  • Scheduled Courses

    Date Location Price Register interest
    7-8 December 2017 London £1600
    25-26 January 2018 London £1600
    26-27 February 2018 London £1600
    26-27 March 2018 London £1600
    26-27 April 2018 London £1600
    17-18 May 2018 London £1600

Closed Courses

This is a cost effective method of training participants from the one company, conducted on your chosen date, either at your premises or ours, for up to six delegates. Please get in touch for further details.

Selected course:

captcha

Alternatively, contact on or

Course Details

Who should attend this course

The Assessing & Interrogating Financial Models course is aimed at professionals working in or around project finance who are not necessarily financial modelling experts, who nevertheless have to grapple with models which are written in a wide variety of styles by outsiders.

Full course program
  • Day 1

    • Introduction
      • Introduction to case study model
      • Excel selection, navigation and editing techniques
    • The cash flow forecast as the centre of investigation
      • The assessment workbook
      • Different kinds of cash flow
      • Restate the cash flow according to a standardised, insightful layout
    • Inclusion analysis: a powerful technique for validating ratios
      • One way IA: project and equity IRR
      • Two way IA: DSCR
      • Mapping the model to ratio definitions
    • Subtleties in ratio definitions
      • Revenues and costs: cash or accruals basis?
      • Treatment of reserves
      • Treatment of debt fees
  • Day 2

    • Single cell reconstruction
      • Understanding the model’s revenue calculations
      • Understanding the model’s operating costs calculations
    • Running sensitivities
      • Keeping track of what you have changed and what effect it has had
      • How to be certain that sensitivities have been run correctly
      • When and how to freeze debt repayment profiles
      • How to run breakeven sensitivities
    • Finding which inputs to alter
      • Six different ways to trace through model logic
    • Reusing the analysis on new versions of the model
      • Linking the assessment workbook to the updated model
    • Conclusion

Companies we train

"Very useful training which provides you with the techniques you need to have a systematic approach in your review of financial models."
European Investment Bank
"At last. Training that addresses what we actually do."
ING
"Great course , will be very useful for future work - provides a trail and tested method to approach non-standardised models. "
Lloyds
"Great if you work with models but don't build them."
Old Mutual
"A very practical hands on course for those who deal with models prepared by third parties."
ING
"As a lawyer, I could follow and understand the principles that guide the interrogation of financial model."
Nedbank
"Great course for those who need to work with complex worksheets/models and run sensitivities. "
Fulcrum
"This is a great course for anyone working with financial models."
Mizuho Bank
"This course has provided me with a sound methodology to both begin building models and also to assess other’s models."
Fulcrum
Contact

Fill in our form and we’ll get back to you:

captcha