IFF is part of the Knowledge & Networking 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.

Informa

Financial Modelling Using Excel Training Course

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

3 - 5 April 2019

Radisson Blu Edwardian Vanderbilt Hotel

Agenda Summary (access the full agenda here)

  • 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