← Back to all courses
Advanced
Advanced Financial Modeling
Take your modeling skills to the next level with advanced techniques used in investment banking, private equity, and corporate finance. Build complex models with scenario analysis, sensitivity tables, and advanced Excel functions.
40 hours32 lessonsAdvanced
What You'll Learn
- Build sophisticated multi-scenario models
- Master advanced Excel functions and VBA
- Create merger models with synergies
- Develop project finance models
- Implement Monte Carlo simulations
Prerequisites
- •Strong Excel skills
- •Financial modeling fundamentals
- •Understanding of corporate finance
Course Curriculum
1Advanced Excel Techniques
Dynamic Modeling
Advanced Excel for modeling
Named rangesData tablesGoal seek
VBA for Finance
Programming for financial models
MacrosAutomationCustom functions
2Complex Transaction Models
Merger Model
Building M&A models
Purchase accountingSynergiesAccretion/dilution
Restructuring Model
Modeling distressed situations
Debt refinancingRecovery analysisWaterfall
3Scenario Analysis & Risk
Sensitivity Analysis
Understanding model sensitivities
One-wayTwo-wayTornado charts
Monte Carlo Simulation
Probabilistic modeling techniques
Probability distributionsRisk analysisImplementation