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...
Contact this provider
Contact info
IFF - International Faculty of Finance
Have a question about this course? Fill out this form and the provider will get in touch with you shortly
No reviews available
Need help with your search?
findcourses.com offers a free consultancy service to help compare training for you and your team
