Business and Financial Modelling

Course Info

Date: July-04-2022

Length: 1 Week

City: Zurich

Fees: 4,600

Type: In Classroom

the date is no longer available,
kindly check other dates from the table below

Available Dates

  • Aug-29-2022

    Zurich

  • Sep-26-2022

    Zurich

  • Oct-10-2022

    Zurich

  • Oct-31-2022

    Zurich

  • Nov-07-2022

    Zurich

  • Nov-21-2022

    Zurich

  • Dec-12-2022

    Zurich

  • Dec-20-2022

    Zurich

  • Dec-26-2022

    Zurich

  • Dec-27-2022

    Zurich

  • Jan-17-2023

    Zurich

  • Feb-21-2023

    Zurich

  • Mar-21-2023

    Zurich

  • Apr-18-2023

    Zurich

  • May-23-2023

    Zurich

  • June-13-2023

    Zurich

  • July-04-2023

    Zurich

Dates in Other Venues

  • Aug-15-2022

    Kuala Lumpur

  • Aug-15-2022

    Istanbul

  • Aug-22-2022

    Madrid

  • Aug-22-2022

    Amsterdam

  • Aug-22-2022

    Singapore

  • Aug-29-2022

    Paris

  • Aug-29-2022

    London

  • Aug-29-2022

    Dubai

  • Aug-29-2022

    Barcelona

  • Aug-29-2022

    Munich

  • Sep-05-2022

    Madrid

  • Sep-05-2022

    London

  • Sep-05-2022

    Dubai

  • Sep-05-2022

    Amsterdam

  • Sep-19-2022

    Kuala Lumpur

  • Sep-19-2022

    Istanbul

  • Sep-19-2022

    Paris

  • Sep-19-2022

    Singapore

  • Sep-19-2022

    Barcelona

  • Sep-19-2022

    Munich

  • Sep-26-2022

    London

  • Sep-26-2022

    Dubai

  • Oct-03-2022

    Istanbul

  • Oct-03-2022

    Paris

  • Oct-03-2022

    London

  • Oct-03-2022

    Singapore

  • Oct-03-2022

    Barcelona

  • Oct-03-2022

    Munich

  • Oct-10-2022

    Madrid

  • Oct-10-2022

    Dubai

  • Oct-17-2022

    Kuala Lumpur

  • Oct-17-2022

    London

  • Oct-17-2022

    Amsterdam

  • Oct-24-2022

    Istanbul

  • Oct-24-2022

    Paris

  • Oct-24-2022

    Singapore

  • Oct-24-2022

    Barcelona

  • Oct-24-2022

    Munich

  • Oct-31-2022

    Kuala Lumpur

  • Oct-31-2022

    Madrid

  • Oct-31-2022

    Dubai

  • Oct-31-2022

    Amsterdam

  • Nov-07-2022

    Madrid

  • Nov-07-2022

    Dubai

  • Nov-14-2022

    Kuala Lumpur

  • Nov-14-2022

    Istanbul

  • Nov-14-2022

    Paris

  • Nov-14-2022

    London

  • Nov-14-2022

    Amsterdam

  • Nov-14-2022

    Singapore

  • Nov-14-2022

    Barcelona

  • Nov-14-2022

    Munich

  • Nov-21-2022

    Madrid

  • Nov-28-2022

    Kuala Lumpur

  • Nov-28-2022

    Istanbul

  • Nov-28-2022

    Paris

  • Nov-28-2022

    London

  • Nov-28-2022

    Dubai

  • Nov-28-2022

    Amsterdam

  • Nov-28-2022

    Singapore

  • Nov-28-2022

    Barcelona

  • Nov-28-2022

    Munich

  • Dec-05-2022

    Kuala Lumpur

  • Dec-05-2022

    Istanbul

  • Dec-05-2022

    Paris

  • Dec-05-2022

    London

  • Dec-05-2022

    Dubai

  • Dec-05-2022

    Amsterdam

  • Dec-05-2022

    Singapore

  • Dec-05-2022

    Barcelona

  • Dec-05-2022

    Munich

  • Dec-12-2022

    Madrid

  • Dec-19-2022

    Istanbul

  • Dec-19-2022

    Amsterdam

  • Dec-20-2022

    Paris

  • Dec-20-2022

    Kuala Lumpur

  • Dec-20-2022

    Amsterdam

  • Dec-20-2022

    Singapore

  • Dec-20-2022

    Barcelona

  • Dec-20-2022

    Munich

  • Dec-26-2022

    Kuala Lumpur

  • Dec-26-2022

    Paris

  • Dec-26-2022

    Madrid

  • Dec-26-2022

    London

  • Dec-26-2022

    Dubai

  • Dec-26-2022

    Singapore

  • Dec-26-2022

    Barcelona

  • Dec-26-2022

    Munich

  • Dec-27-2022

    Madrid

  • Dec-27-2022

    Istanbul

  • Dec-27-2022

    London

  • Dec-27-2022

    Dubai

  • Jan-03-2023

    Kuala Lumpur

  • Jan-03-2023

    London

  • Jan-10-2023

    Istanbul

  • Jan-10-2023

    Dubai

  • Jan-17-2023

    Paris

  • Jan-17-2023

    Amsterdam

  • Jan-17-2023

    Singapore

  • Jan-17-2023

    Barcelona

  • Jan-17-2023

    Munich

  • Jan-24-2023

    Madrid

  • Jan-24-2023

    London

  • Jan-31-2023

    Istanbul

  • Jan-31-2023

    Dubai

  • Feb-07-2023

    Kuala Lumpur

  • Feb-07-2023

    London

  • Feb-07-2023

    Dubai

  • Feb-14-2023

    Istanbul

  • Feb-21-2023

    Paris

  • Feb-21-2023

    Amsterdam

  • Feb-21-2023

    Singapore

  • Feb-21-2023

    Barcelona

  • Feb-21-2023

    Munich

  • Feb-21-2023

    Munich

  • Feb-28-2023

    Madrid

  • Feb-28-2023

    London

  • Feb-28-2023

    Dubai

  • Mar-07-2023

    Kuala Lumpur

  • Mar-07-2023

    London

  • Mar-07-2023

    Dubai

  • Mar-14-2023

    Istanbul

  • Mar-21-2023

    Paris

  • Mar-21-2023

    Amsterdam

  • Mar-21-2023

    Singapore

  • Mar-21-2023

    Barcelona

  • Mar-21-2023

    Munich

  • Mar-21-2023

    Munich

  • Mar-28-2023

    Madrid

  • Mar-28-2023

    London

  • Mar-28-2023

    Dubai

  • Apr-04-2023

    Kuala Lumpur

  • Apr-04-2023

    London

  • Apr-04-2023

    Dubai

  • Apr-11-2023

    Istanbul

  • Apr-18-2023

    Paris

  • Apr-18-2023

    Singapore

  • Apr-18-2023

    Amsterdam

  • Apr-18-2023

    Barcelona

  • Apr-18-2023

    Munich

  • Apr-18-2023

    Munich

  • Apr-25-2023

    Madrid

  • Apr-25-2023

    London

  • Apr-25-2023

    Dubai

  • May-02-2023

    Kuala Lumpur

  • May-02-2023

    Madrid

  • May-02-2023

    London

  • May-02-2023

    Dubai

  • May-02-2023

    Amsterdam

  • May-16-2023

    Paris

  • May-16-2023

    Barcelona

  • May-16-2023

    Munich

  • May-16-2023

    Munich

  • May-23-2023

    Istanbul

  • May-23-2023

    London

  • May-23-2023

    Singapore

  • May-30-2023

    Dubai

  • June-06-2023

    London

  • June-06-2023

    Dubai

  • June-06-2023

    Singapore

  • June-13-2023

    Kuala Lumpur

  • June-13-2023

    Paris

  • June-13-2023

    Barcelona

  • June-13-2023

    Munich

  • June-27-2023

    Istanbul

  • June-27-2023

    Madrid

  • June-27-2023

    London

  • June-27-2023

    Dubai

  • June-27-2023

    Amsterdam

  • July-04-2023

    Paris

  • July-04-2023

    London

  • July-04-2023

    Dubai

  • July-04-2023

    Barcelona

  • July-04-2023

    Munich

  • July-11-2023

    Istanbul

  • July-11-2023

    Madrid

  • July-11-2023

    Singapore

  • July-11-2023

    Amsterdam

  • July-25-2023

    Kuala Lumpur

  • July-25-2023

    London

  • July-25-2023

    Dubai

  • Aug-01-2023

    Dubai

  • Aug-08-2023

    London

Course Details

Course Outline

5 days course

 

 Introduction and overview of Financial Modelling

 

  • Characterise 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

 

  • Understand 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 company’s Financial Performance.
  • Use “Peer Group” Analysis to Measure a company’s Financial Performance.
  • Use Financial Ratios Models to Analyse a company’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.
  • Rationalise 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 Optimisation 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

 

  • Comprehend How Models are Created and Used.
  • Deal with Problems in the Development and Use of Financial Models.
  • Use Financial Models Effectively.

Course Video