Live Digital
Live Digital
Master your modelling skills in transaction structuring, valuation and MBOs to improve decision-making
A three day intensive training course
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.
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.