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

TBC, Online

Live Digital

TBC, Online

Live Digital

Master your modelling skills in transaction structuring, valuation and MBOs to improve decision-making

A three day intensive training course

TAILOR THIS COURSE FOR YOUR TEAM

We can customise it to meet your specific training requirements and deliver it face-to-face or digitally. Contact Leigh Kendall for more information.

Financial modelling using excel training course

Learn how to

  • Understand model dsesign – the different modelling approaches required for:
    • valuation models
    • volatility models in structured financings
    • statistical probability models (Monte Carlo)
    • data manipulation models
  • Use analysis worksheets for:
    • sensitivity analysis
    • scenario analysis
    • breakeven analysis
  • Model using best practice techniques – including the potential consquences of not applying such practices
  • Review models – procedures upon receiving procedures upon receiving a model which has been prepared by others

Case studies and practical sessions

  • Setting up the model
  • Creating the forecast of financial statements & cashflows
  • Modelling currency exposures
  • Breakeven analysis
  • Modelling of operating costs
  • IRR and NPV calculations
  • Cash sweep
  • Sculpting loan amortisations – to ADSCR
  • Sculpting loan amortisations – to LLCR
  • Cashflow waterfall
  • Sensitivity analysis
  • Scenario analysis
  • Model administration

Key information

Dates: 2021

Venue: Online

Course Leader: Richard Capps

Course Fee: £2999.00 + VAT @ 20% = £3598.80

Why choose IFF

TRACK RECORD – we have been delivering expert training to the banking, finance and energy sectors since 1991

INNOVATION – our courses are continually reviewed so you can be sure they are focusing on the most current issues

KNOWLEDGE – all of our trainers are highly experienced practitioners and leading subject matter experts so you can be confident you are learning from the very best

SMALL CLASS SIZES – to aid learning and increase your personal interaction with the trainer

VALUE – we provide a practical training experience with skills that can be used immediately to gain a tangible return on your investment

ACCREDITATION – we are accredited by the British Accreditation Council (BAC)

Is this course for you?

Watch expert trainer Richard Capps to find out more.

Shelley de Souza

Senior Manager

Sumitomo Mitsui Banking Corp

Very useful content. Excellent standard of course materials, using real world examples. Useful for my job

CPD Certified

Engaging in Continuing Professional Development ensures that both academic and practical qualifications do not become out-dated or obsolete; allowing individuals to continually ‘up skill’ or ‘re-skill’, regardless of occupation, age or educational level. This course has been assessed and is CPD certified.