Advanced financial modeling in English – for global finance professionals
Build a fully integrated 3-statement financial model from scratch
Perform DCF valuation with WACC and terminal value
Construct a simplified LBO model with returns analysis
Build an accretion/dilution merger model
| 09h00 – 09h30 | Introduction : financial modeling best practices, FAST standards, colour-coding convention |
| 09h30 – 11h00 | Income statement build: revenue drivers, cost structure, EBITDA to net income bridge |
| 11h00 – 11h15 | — Pause — |
| 11h15 – 12h30 | Balance sheet mechanics: working capital schedule, capex and depreciation waterfall |
| 13h30 – 15h00 | Free cash flow build: FCFF vs FCFE, cash sweep, debt schedule |
| 15h00 – 15h15 | — Pause — |
| 15h15 – 16h45 | Scenario and sensitivity analysis: data tables, tornado charts, Monte Carlo basics |
| 16h45 – 17h30 | Day 1 wrap-up, Q&A |
| 09h00 – 10h30 | DCF valuation: WACC calculation, terminal value methods, football field chart |
| 10h30 – 10h45 | — Pause — |
| 10h45 – 12h30 | LBO model: sources & uses, debt tranches, returns waterfall, IRR/MOIC analysis |
| 13h30 – 15h30 | Merger model: accretion/dilution analysis, synergy assumptions, pro-forma combined P&L |
| 15h30 – 15h45 | — Pause — |
| 15h45 – 16h45 | Model auditing and documentation: error checks, version control, presenting to stakeholders |
| 16h45 – 17h30 | Final assessment (complete a model from scratch), wrap-up and certificates |
Investment bankers, M&A analysts, PE associates, CFOs in international
Réservez votre place et développez vos compétences
