Courses · Video course
A video course that builds a complete leveraged buyout model: sources and uses, a seven-year plan, four debt tranches without a circular reference, covenants with headroom, exit returns and a value creation bridge, a management package with a ratchet, scenarios, sensitivity grids and 31 integrity checks.
Sixteen video lessons (about 55 minutes of video), a 32-page Course Book, an Excel workbook that checks your answers, eight step files from the first sheet to the finished model, a 160-question quiz app with a timed final exam and a certificate, and the finished Pro model. Download right after payment.
Secure checkout by Stripe. Not sure yet? Watch the first lesson, read module 1 and try ten quiz questions below, or start with the free LBO model template.
Most LBO templates hand you a finished file. This course builds one with you, in the order a private equity associate builds it, and stops at every step to show why the line is there and what goes wrong when it is not.
Each module has two video lessons, a chapter of the Course Book with a worked example and the classic mistakes, a step file, one exercise tab and twenty quiz questions.
A full module. Module 1, How a buyout makes money, as it appears in the Course Book: download the free sample (PDF).
Ten quiz questions. Click an answer: it turns green or red and the explanation appears. The questions use the running case:
Corvane Industrial Components, Inc. (fictional): LTM EBITDA $50.0m, bought at 9.0x, so $450.0m. Debt $305.0m (6.10x): revolver, Term Loan B at SOFR + 3.50% with a 0.50% floor, 8% senior notes, 11% PIK notes. Year 1 SOFR 4.00%. Exit at the end of year 5 at 9.0x.
Module 1
1. Corvane's LTM EBITDA is $50.0m and the sponsor pays 9.0x. What is the enterprise value?
Answer: $450.0m. 9.0 x $50.0m = $450.0m. The equity price and total uses come after; year 1 EBITDA is not the LTM figure.
Module 1
2. An investment returns 2.0x in five years with no interim cash flow. What is the IRR?
Answer: 14.9%. 2.0^(1/5) - 1 = 14.9%. 20% a year is simple interest; 14.4% is the rule of 72 shortcut; 26.0% is the three-year answer.
Module 2
3. What is year 1 EBITDA?
Answer: $54.26m. $126.64m - SG&A $72.38m = $54.26m.
Module 3
4. What is year 1 Term Loan B interest?
Answer: $15.00m. 7.50% x opening $200m = $15.00m. The average-balance figure needs a circular reference.
Module 3
5. Why does an average-balance interest calculation create a circular reference?
Answer: Interest depends on the closing balance, which depends on the sweep, which depends on interest. The loop closes through the cash sweep.
Module 4
6. Against a maximum of 5.00x, what is the leverage headroom in year 1?
Answer: 33.4%. 1 - 3.329 / 5.00 = 33.4%: EBITDA can fall that much before the test fails.
Module 5
7. What is equity value at exit?
Answer: $442.78m. 648.76 - costs 9.73 - net debt 196.24 = $442.78m.
Module 6
8. What is the envy ratio?
Answer: 5.24x. (165.07 / 0.85) / (5.56 / 0.15) = 5.24x.
Module 7
9. On the grid, what is the IRR if the sponsor buys at 9.5x and sells at 8.5x?
Answer: 15.1%. Row 9.5x, column 8.5x: 15.1%.
Module 8
10. Where should the master check appear?
Answer: On the Dashboard, next to the results. Read it before the IRR.



| File | What it is |
|---|---|
| Videos, one zip per module | Sixteen lessons in 1080p, about 55 minutes of video, with English subtitles (.srt) and chapters. |
| Course_Book.pdf | Eight modules, 32 pages: lesson, worked example, pitfalls, summary, practice questions, glossary and dated sources. |
| Step_Files | Eight workbooks: the model as it stands at the end of each module, from the first sheets to the finished model. |
| Exercise_Workbook.xlsx | Eight exercise tabs, 71 answers checked automatically, eight hidden solution tabs. |
| Quiz_App.html | 160 questions, practice by module with explanations, timed final exam, score by module, certificate. |
| LBO_Model_Pro | The Pro model with the worked example, a blank copy and the 18-page user guide. |
| Start_Here.pdf | The order to use it all in, on one page. |
Corvane Industrial Components, Inc., a fictional US maker of industrial components, is bought by a sponsor for $450.0m. The course follows the deal from the sources and uses to the sponsor's returns in three scenarios:
| Measure | Value |
|---|---|
| LTM revenue / EBITDA | $350.0m / $50.0m |
| Debt at closing / equity check | $305.0m (6.10x) / $170.6m |
| Year 1 interest cover headroom: base / downside | 20.6% / 0.3% |
| Equity value at exit, year 5 | $442.8m |
| Sponsor IRR: downside / base / upside | 4.8% / 19.9% / 24.5% |
| Management MOIC, base case / envy ratio | 6.14x / 5.24x |
Analysts and associates joining a private equity, leveraged finance or transaction services team, students preparing for private equity modeling tests and interviews, and anyone who wants to build a buyout model they can defend line by line. You need basic Excel.
Sixteen video lessons, two per module, about 55 minutes of video in total. With the reading, the exercise tabs and the quizzes, most learners need six to ten hours.
Nine downloads right after payment: the course zip (Course Book, Exercise Workbook, Quiz App, eight step files and the LBO Model, Pro Edition with a blank copy and its 18-page user guide) and one video zip per module, with subtitles and chapters.
Excel (LibreOffice and Google Sheets also work), a PDF reader, a video player and a web browser. The videos show the model in LibreOffice Calc; every formula works the same way in Excel. No macros, no add-ins.
No. Interest is charged on opening balances, so the debt schedule with a cash sweep has no circular reference, no iterative calculation and no macro. Module 3 explains why and what it costs.
No. The Quiz App prints a certificate of completion when you score 70% or more on the final exam. It shows the work you did; it is not a license or an accredited qualification.
It is a digital download delivered immediately, so the right of withdrawal ends at delivery, as the checkout explains. If a file is faulty, write to [email protected] and it will be fixed or refunded. Details in the terms of sale.
No. The company, the sponsor and every deal are fictional. The course teaches modeling mechanics. It was prepared with AI assistance; the voice of the videos is synthetic, and every figure is computed and checked by script.
The videos, the Course Book, the step files, the exercises, the quiz and the LBO Model, Pro Edition. Download right after payment.
Only need the model? The LBO Model, Pro Edition is $99 on its own.