IFF Training

Financial Modelling Using Excel

Available dates

Nov 18—20, 2019
3 days
London, United Kingdom
GBP 3599 ≈USD 4625
GBP 1199 per day
Apr 22—24, 2020
3 days
London, United Kingdom
GBP 3599 ≈USD 4625
GBP 1199 per day


Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with IFF Training.

Full disclaimer.

About the course

Different types of analysis require that the financial model be built in a particular way. This course covers:

Model Design

  • the different modelling approaches required for:
  • valuation models
  • volatility models in structured financings
  • statistical probability models (Monte Carlo)
  • data manipulation models

Analysis Worksheets For

  • sensitivity analysis
  • scenario analysis
  • breakeven analysis

Modelling Best Practice

  • including the potential consequences of not applying such practices. . Model Review

  • procedures upon receiving a model which has been prepared by others.

How You Will Learn

Trainer Richard Capps has extensive banking experience so can relate the modelling to the real world very well. His practical sessions include:

Setting up the Model; Creating the Forecast of Financial Statements & Cashflows; Modelling Currency Exposures; Breakeven Analysis; Modelling of Operating Costs; IRR and NPV Calculation; Annuity-based Amortisation; Straightline Amortisation; Cash Sweep; Sculpting Loan Amortisations – to ADSCR; Sculpting Loan Amortisations – to LLCR; Cashflow Waterfall; Sensitivity Analysis; Scenario Analysis; Model Administration

Trust the experts

Richard Capps

Richard obtained a law degree from Cambridge University and was called to the English Bar in 1976. Shortly thereafter he entered banking joining Chase Manhattan Bank where, for most of the 5 years service, he was a corporate relationship manager in London and New York. For the following 6 years ...


Course reviews

Downloadable files