LB
Advanced
Leveraged Buyout (LBO) Modeling
Model a private equity buyout, from sources and uses to returns analysis and IRR.
View courseFinancial Modeling Fundamentals
Build a three-statement model from scratch in Excel, with clean structure and checks.
What you'll learn
- Core concepts explained with real US company examples
- Step-by-step Excel walkthroughs you can follow along with
- Best practices used by analysts at leading firms
- A final assessment to earn your certificate of completion
Course curriculum
Module 1: Model structure and best practices45 min
Module 2: Building the income statement52 min
Module 3: Balance sheet and supporting schedules59 min
Module 4: Cash flow statement and integrity checks66 min
Module 5: Scenario and sensitivity analysis73 min
Module 6: Final project: full 3-statement model50 min
Who this course is for
Students, career changers and working professionals in finance, accounting, consulting and business who want practical, job-ready skills.
Requirements
A computer with Microsoft Excel (Microsoft 365 recommended). No prior experience is required for beginner courses.
Related courses
BF
Intermediate
Budgeting & Forecasting (FP&A)
Build driver-based budgets, rolling forecasts and variance reports for FP&A teams.
View course