Compare courses
Register
IFF Training

Financial Modelling Using Excel

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

How it works

Disclaimer

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.

Description

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

Experts

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

Files

Detailed Description
Detailed Description