Courses · Video course

Build an LBO Model in Excel, step by step

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.

$149, with the LBO Model, Pro Edition ($99 on its own)

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.

Get the course, $149 →

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.

What you will be able to do

The program

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.

Try it free

Lesson 1.1, Sources and uses: the first of the sixteen lessons, free.

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.

Inside the course

Exercise Workbook, module 3: given data in blue, answers in yellow and automatic Correct checks for year 1 of the debt schedule
The Exercise Workbook: one tab per module, your answers in yellow, an automatic check, a hidden solution built with live formulas.
Quiz App: a module 3 question on circular references with the explanation after the answer
The Quiz App: 160 questions with explanations, a timed final exam of 40 questions and a case, and a printable certificate from 70%. It runs offline.
Dashboard of the LBO Model, Pro Edition for the running case
The LBO Model, Pro Edition, included: the whole case in one workbook, with 31 checks and a master check.

What you receive

FileWhat it is
Videos, one zip per moduleSixteen lessons in 1080p, about 55 minutes of video, with English subtitles (.srt) and chapters.
Course_Book.pdfEight modules, 32 pages: lesson, worked example, pitfalls, summary, practice questions, glossary and dated sources.
Step_FilesEight workbooks: the model as it stands at the end of each module, from the first sheets to the finished model.
Exercise_Workbook.xlsxEight exercise tabs, 71 answers checked automatically, eight hidden solution tabs.
Quiz_App.html160 questions, practice by module with explanations, timed final exam, score by module, certificate.
LBO_Model_ProThe Pro model with the worked example, a blank copy and the 18-page user guide.
Start_Here.pdfThe order to use it all in, on one page.

The running case

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:

MeasureValue
LTM revenue / EBITDA$350.0m / $50.0m
Debt at closing / equity check$305.0m (6.10x) / $170.6m
Year 1 interest cover headroom: base / downside20.6% / 0.3%
Equity value at exit, year 5$442.8m
Sponsor IRR: downside / base / upside4.8% / 19.9% / 24.5%
Management MOIC, base case / envy ratio6.14x / 5.24x

Questions people ask

Who is the course for?

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.

How long is it?

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.

What do I get exactly?

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.

Which software do I need?

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.

Does the model use circular references or macros?

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.

Is the certificate a professional qualification?

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.

Can I get a refund?

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.

Is it investment advice?

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.

Build an LBO Model in Excel: $149

The videos, the Course Book, the step files, the exercises, the quiz and the LBO Model, Pro Edition. Download right after payment.

Get the course, $149 →

Only need the model? The LBO Model, Pro Edition is $99 on its own.

Related