Leading Advisors in Project Finance

Financial Model Assessment and Review2 days

The objective of the training is to teach and implement a robust, reliable and repeatable framework for analysing unfamiliar financial models.

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.

  • Scheduled Courses

  • Date Course Format Time Zone Price Register interest
    11-14 January 2021 Online GMT £1200
    08-11 March 2021 Online GMT £1200
    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.

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

    Full course program
      • 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
      • 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"]