Financial Modelling using Excel

IFF - International Faculty of Finance
Training overview
Professional Course
Self-paced Online
3 days
From 2,999 GBP

Start dates
2,999 GBP
Start anytime

Course description

Financial Modelling using Excel

Improve your modelling skills in transaction structuring, valuation and MBOs and master an optimal decision-making process.

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.

COVID-19 Update

This provider offers an online version of their classroom courses

Training content

  • Modelling Best Practice
  • Model Design and Planning
  • Different Model Types
  • The Analysis Worksheet
  • Practical Exercise 1 – Setting up the Model
  • Models For Valuation & Appraisal Purposes
  • Practical Exercise 2 – Creating the Forecast of Financial Statements & Cashflows
  • Practical Exercise 3 – Modelling Currency Exposures
  • Visual Basic Introduction
  • Practical Exercise 4 – Breakeven Analysis
  • Volatility Modelling
  • Practical Exercise 5 – Modelling of Operating Costs
  • Procedures Upon Receiving a Model
  • IRR and NPV
  • Practical Exercise 6 – IRR and NPV Calculations
  • Financing
  • Practical Exercise 7 – Annuity-based Amortisation
  • Practical Exercise 8 – Straightline Amortisation
  • Practical Exercise 9 – Cash Sweep
  • Practical Exercise 10 – Sculpting Loan Amortisations – to ADSCR
  • Practical Exercise 11 – Sculpting Loan Amortisations – to LLCR
  • Practical Exercise 12 – Cashflow Waterfall
  • Analysis Worksheets
  • Practical Exercise 13 – Sensitivity Analysis
  • Practical Exercise 14 – Scenario Analysis
  • Practical Exercise 15 – Model Administration

About IFF

International Faculty of Finance - IFF Finance & IFE Energy - Specialist Training Courses

As one of the world's leading specialist financial training organisations, The International Faculty of Finance, provides participants in the global financial markets with intensive technical training programmes designed to help them succeed on the global stage.  Established in 1991 we...

Read more and show all training delivered by this supplier

Contact this provider

Fill out your details to find out more about Financial Modelling using Excel.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

IFF - International Faculty of Finance

 Show phone number

Contact provider

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

Training reviews

No reviews available

Need help with your search? offers a free consultancy service to help compare training for you and your team

Request a free quote

Request a free training quote