Course Info

Length: 1 Week

Type: In Classroom

Available Dates

Venue

  • Nov-04-2024

    Kuala Lumpur

  • Nov-04-2024

    Istanbul

  • Nov-11-2024

    Paris

  • Nov-11-2024

    Singapore

  • Nov-18-2024

    Barcelona

  • Nov-18-2024

    Dubai

  • Nov-25-2024

    London

  • Nov-25-2024

    Amsterdam

  • Dec-02-2024

    Istanbul

  • Dec-02-2024

    Kuala Lumpur

  • Dec-09-2024

    Paris

  • Dec-09-2024

    Singapore

  • Dec-16-2024

    Dubai

  • Dec-16-2024

    Barcelona

  • Dec-23-2024

    London

  • Dec-23-2024

    Istanbul

  • Dec-30-2024

    Kuala Lumpur

  • Dec-30-2024

    Amsterdam

  • Jan-06-2025

    Paris

  • Jan-06-2025

    Singapore

  • Jan-13-2025

    London

  • Jan-13-2025

    Amsterdam

  • Jan-20-2025

    Dubai

  • Jan-20-2025

    Barcelona

  • Jan-27-2025

    Istanbul

  • Jan-27-2025

    Kuala Lumpur

  • Feb-03-2025

    Paris

  • Feb-03-2025

    Singapore

  • Feb-10-2025

    London

  • Feb-10-2025

    Amsterdam

  • Feb-17-2025

    Barcelona

  • Feb-17-2025

    Dubai

  • Feb-24-2025

    Kuala Lumpur

  • Feb-24-2025

    Istanbul

  • Mar-03-2025

    Paris

  • Mar-03-2025

    Singapore

  • Mar-10-2025

    London

  • Mar-10-2025

    Amsterdam

  • Mar-17-2025

    Dubai

  • Mar-17-2025

    Barcelona

  • Mar-24-2025

    Istanbul

  • Mar-24-2025

    Kuala Lumpur

  • Apr-07-2025

    Singapore

  • Apr-07-2025

    Paris

  • Apr-14-2025

    Amsterdam

  • Apr-14-2025

    London

  • Apr-21-2025

    Barcelona

  • Apr-21-2025

    Dubai

  • Apr-28-2025

    Kuala Lumpur

  • Apr-28-2025

    Istanbul

  • May-05-2025

    Paris

  • May-05-2025

    Singapore

  • May-12-2025

    London

  • May-12-2025

    Amsterdam

  • May-19-2025

    Barcelona

  • May-19-2025

    Dubai

  • May-26-2025

    Istanbul

  • May-26-2025

    Kuala Lumpur

  • June-02-2025

    Singapore

  • June-02-2025

    Paris

  • June-09-2025

    Amsterdam

  • June-09-2025

    London

  • June-16-2025

    Dubai

  • June-16-2025

    Barcelona

  • June-23-2025

    Kuala Lumpur

  • June-30-2025

    Istanbul

  • June-30-2025

    Singapore

  • June-30-2025

    Paris

  • July-07-2025

    Paris

  • July-07-2025

    Singapore

  • July-14-2025

    London

  • July-14-2025

    Amsterdam

  • July-21-2025

    Barcelona

  • July-21-2025

    Dubai

  • July-28-2025

    Istanbul

  • July-28-2025

    Kuala Lumpur

  • Aug-04-2025

    Singapore

  • Aug-04-2025

    Paris

  • Aug-11-2025

    London

  • Aug-11-2025

    Amsterdam

  • Aug-18-2025

    Barcelona

  • Aug-18-2025

    Dubai

  • Aug-25-2025

    Kuala Lumpur

  • Aug-25-2025

    Istanbul

  • Sep-01-2025

    Singapore

  • Sep-01-2025

    Paris

  • Sep-15-2025

    Barcelona

  • Sep-15-2025

    Dubai

  • Sep-15-2025

    Amsterdam

  • Sep-15-2025

    London

  • Sep-22-2025

    Kuala Lumpur

  • Sep-29-2025

    Paris

  • Sep-29-2025

    Singapore

  • Sep-29-2025

    Istanbul

  • Oct-06-2025

    Singapore

  • Oct-06-2025

    Paris

  • Oct-13-2025

    Amsterdam

  • Oct-13-2025

    London

  • Oct-20-2025

    Barcelona

  • Oct-20-2025

    Dubai

  • Oct-27-2025

    Istanbul

  • Oct-27-2025

    Kuala Lumpur

  • Nov-03-2025

    Paris

  • Nov-03-2025

    Singapore

  • Nov-10-2025

    London

  • Nov-10-2025

    Amsterdam

  • Nov-17-2025

    Dubai

  • Nov-17-2025

    Barcelona

  • Nov-24-2025

    Kuala Lumpur

  • Nov-24-2025

    Istanbul

  • Dec-01-2025

    Paris

  • Dec-01-2025

    Singapore

  • Dec-08-2025

    London

  • Dec-08-2025

    Amsterdam

  • Dec-15-2025

    Dubai

  • Dec-15-2025

    Barcelona

  • Dec-22-2025

    Kuala Lumpur

  • Dec-29-2025

    Istanbul

  • Dec-29-2025

    Paris

  • Dec-29-2025

    Singapore

Course Details

Course Outline

5 days course

 

Introduction and overview of Financial Modelling

 

  • Define the Terms Model and Financial Model.
  • Learn the 10 steps to create good Financial Models.
  • The 12 steps to Improving traditional Financial Models.
  • Use Flowcharting Techniques to improve your model.

 

 Time Value Models

 

  • Comprehend the Time Value of Money.
  • Apply Time Value Concepts to Financial Models.
  • Learn Why the Weighted Average Cost of Capital (WACC) Is Used in Capital Budgeting Models.
  • Use Net Present Value (NPV) and Internal Rate of Return (IRR) Models in Making Capital Expenditure Decisions.
  • Use the built-in functions for NPV, IRR, MIRR.

 

Financial Analysis Models

 

  • Use Break-Even Analysis in Financial Models.
  • Use Scenario Analysis in Financial Models.
  • Use Sensitivity Analysis in Financial Models.
  • Compare These Approaches.
  • Incorporate Sensitivity Analysis and Scenario Analysis in Financial Models.

 

 Lease v Buy Analysis Models

 

  • Learn the Fundamental Concepts of Leasing.
  • Identify the Different Types of Leasing.
  • Learn How to Analyse Leasing an Asset vs. Purchasing the Asset.
  • Use Financial Models to Make Lease vs. Buy Decisions.

 

Financial Ratio Analysis Models

 

  • Identify Major Financial Ratios.
  • Use Financial Ratios to Measure a Firm’s Financial Performance.
  • Use “Peer Group” Analysis to Measure a Firm’s Financial Performance.
  • Use Financial Ratios Models to Analyse a Firm’s Performance.

 

 Models for Valuation of Stock and Bonds

 

  • Learn How to Apply Dividend Discount Techniques.
  • Calculate the “Intrinsic” Value of a Firm’s Common Stock.
  • Rationalize the Difference between Intrinsic Value vs. Market Value for a Firm’s Common Stock.
  • Learn How to Apply Bond Valuation Techniques.
  • Calculate the Price and Yield to Maturity (YTM) of a Bond.
  • Construct a Model to Evaluate Potential Bond Investments.

 

Comprehensive Models and Tools

 

  • Using Tools like Solver & Goal Seeker.
  • Developing a Financial Optimization Model.
  • Identify the Types of Financial Activities That Can Be Connected in a Model.
  • Build the Pieces of a “Connected” Model.
  • Link the Pieces to Form a Multiple-Part Model.

 

 

Putting It all Together

 

  • Understand How Models Are Created and Used.
  • Deal with Problems in the Development and Use of Financial Models.
  • Use Financial Models Effectively.
  • Case study 

Course Video