Leading Advisors in Project Finance

Assessing & Interrogating Financial Models Course2 day course

Overview

The objective of the training is to teach and implement a robust, reliable and repeatable framework for analysing unfamiliar financial models. The basis of our approach is to record the investigation of a financial model, centred on the ‘Assessment Workbook’.

This 2 – day, hands-on training provides you with a range of formulaic and logical techniques that allow for easy code inspection.  The elegance of this approach is that findings are recorded separately from the model under test and can be presented to the model developers for subsequent discussion and revision.

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.

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 Format Time Zone/
    Location    		 Price Register interest
    23-26 November 2020 Online Live
    (1/2 days)    		 EST GMT-4 £1200
    11-14 January 2021 Online Live
    (1/2 days)    		 GMT £1200
    08-11 march 2021 Online Live
    (1/2 days)    		 GMT £1200

In-house 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:


I have read and accept the Privacy Policy

captcha
Course outline
Download

Course Details

Who should attend this course

The Assessing & Interrogating Financial Models course is aimed at professionals working in or around project finance who have to grapple with models which are written in a wide variety of styles.

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
"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
Call

Jack Clarke+44 207 562 0477

Email
Contact
[contact-form-7 404 "Not Found"]