L'ensemble des places disponibles en ligne a été vendu ! Pour plus d'informations, rapprochez-vous de l'association organisatrice.

Voir la page

Advanced Financial Modeling Course!

par Bureau des Elèves du MBA d’HEC (isa)

Du 23 février 2017 au 16 mars 2017

Advanced Financial Modeling Course! - Bureau des Elèves du MBA d’HEC (isa)

The MBA Finance Club is pleased to announce a Advanced Financial Modeling Course taking place at HEC by the Professor Ferdinand Petra.

> Who

The MBA Finance Club is pleased to announce a Advanced Financial Modeling Course taking place at HEC by the Professor Ferdinand Petra. At the end of this course, you are expected to be able to set up an operating model (income statement, balance sheet, and free cash flow statement), a DCF, sensitivities, a merger model, and a basic LBO model meeting the level of standards required by investment banks.

> When

@15 hours:

  • 1st Session (180 minutes):  23 Feb 16:30-19:30
  • 2nd Session (180 minutes): 28 Feb 16:30-19:30
  • 3rd Session (180 minutes):    2 Mar 16:30-19:30
  • 4th Session (180 minutes):  10 Mar 16:30-19:30
  • 5th Session (180 minutes):  16 Mar 16:30-19:30

> Where

Computer room to be provided at HEC.

> Pricing

This course has an all-in-cost of €170. Price could vary slightly according to the number of subscribers.

Sponsorship: MBA Council

Course Training at a glance

In most of the jobs that are offered to MBA participants post a specialization in finance they will have to model the financial statements of a company in order to forecast its evolution, take key decisions on its development or know its value… The main objective of the course is to give participants the opportunity to implement the various finance skills learnt since the beginning of their MBA and build an operating model, a DCF, a merger model, a basic LBO model, tasks that those who choose a career in Investment Banking (and more generally in corporate finance) will have to perform on a daily basis.

Course Program

Introduction to the basic modeling rules and recap of the main accounting principles:
  • Recap of basic accounting concepts used to build a financial model
  • Introduction to the principles of modeling and practice through exercises
  • Presentation to common Excel shortcuts used in modeling
  • Presentation of the ‘choose’ and ‘offset’ functions
  • Introduction to circular references and their use in interest calculation

Creation of an operating model and of a DCF:
  • Creating an operating model and a DCF step by step
  • Sensitivities around the WACC and the long term growth rate
  • Sensitivities around the EBIT margin and the growth rate
Creation of a merger model:
  • Creating a merger model step by step
  • Accretion / dilution analysis
Creation of a basic LBO model:
  • Creating a LBO model step by step
  • Return calculations for PE funds


The computer rooms have 20 computers (Windows – Excel in English). If you prefer, you can bring your own laptop provided you have Windows/Excel (in English ideally) on it.

Note: using Excel on Mac OS for this class is not optimal as the modelling in most functions in Corporate Finance are based on Windows platform and part of this class pedagogical purpose is to train you in “real-life situation”.

Signaler la page