Financial Modelling using Excel

Name: Financial Modelling using Excel
Brand: IFF - International Faculty of Finance
SKU: 269843
Rating: 5 (4 reviews)

IFF - International Faculty of Finance

Course summary

Professional Training

3 days

2,999 GBP excl. VAT

IFF - International Faculty of Finance

London, Online courses

5.0 (4 Reviews)

Contact provider Book Course

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.

Contact provider

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

Expenses

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