IFF is part of the Informa Connect Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 3099067.


Financial Modelling Using Excel Training Course

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

28 - 30 October 2020

Central London

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.

Download Financial Modelling Using Excel brochure

Dates: 28-30 October 2020
Venue: Central London
Course Leader: Richard Capps, International Modelling Expert
Course Fee: £2999.00 + VAT @ 20% = £3598.80

View the Financial Modelling Using Excel agenda

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

Richard Capps is an international project finance and modelling expert who has worked on:
• A 36MB model for a $20 Billion petrochemicals project, involving a refinery, cracker, utilities complex, and 42 downstream petrochemical plants
• A model for the construction and chartering of 4 LNG vessels
• A model for valuing acquisitions by a UK food processing company
• A pricing model for a UK power generation company

IFF's Financial Modelling Using Excel course is part of a portfolio of practical, professional courses that draw on our trainers' global experience.

Hear trainer Richard Capps introduce the course in this exclusive video.

Very useful content, Excellent standard of course matericals, using real world examples, useful for my job

Shelley de Souza, 

Senior Manager, Sumitomo Mitsui Banking Corp

You may also be interested in...