Financial Modelling using Excel

IFF - International Faculty of Finance
Course summary
Professional Training
3 days
2,999 GBP excl. VAT
London, Online courses

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.

Training Course 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


The cost of this course is £1899 + VAT / £2199 + VAT.

Get Inspired! Watch the Video

About provider

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 courses with this provider

Request info

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

Maple House 149, Tottenham Court Road
W1T 7AD London

 Show phone number


Average rating 5

Based on 4 reviews.

Shelley de Souza
Very useful content, Excellent standard of course matericals, using real world examples, useful for my job
Obinna Iheonu
Certainly one of the best course I have attended. High quality lecturer. A.K., CDC Globeleq
Request information

Find out more about this Financial Modelling using Excel course - simply fill out your details:

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here