Companion files · The Buyout Investor

The deal made 17.05 percent. The subscriber earned 12.70 percent.

The Buyout Investor: Private Equity Buyouts by the Numbers: Entry Price, Leverage, Value Creation and Exit, Where the Return Really Comes From, With the Models Supplied.

These are the companion files of The Buyout Investor by Julian R. Sterling.The book on Amazon →

Also as a DRM-free PDF edition ($19.99).

These are the companion files of the book. A buyout fund pays $450.0 million for a mid-market industrial company earning $50.0 million, puts in $190.0 million of its own money and $275.0 million of borrowed money, buys an add-on, lives through a bad year and sells after five years for $417.4 million: 2.20x, 17.05 percent a year. The same company bought with no debt would have returned 11.96 percent; the subscriber who financed the fund earned 12.70 percent; one turn of exit multiple would have moved the equity by $76.7 million. Three workbooks reproduce every figure the book prints. No sign-up, no email is asked for, nothing is locked. Yellow cells with blue type are inputs; grey cells are formulas.

All the companion files and the read-me, in one archive721 KB

The archive holds the six files below, six working documents and three new worked cases, with 00_START_HERE.md at its root. Last revised 15 November 2026. No macros, no circular references, no external links in any workbook. They recalculate in Excel, LibreOffice or Google Sheets.

Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample

Finished the book? The Private Equity Career Pack: five PDF editions, from buyouts to venture capital, this book included, $59.99. See the pack →
The working models behind the books, built out for live deals: the Pro models →

Get an email if these files are corrected

Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.

Join the reader list

Run by MailerLite, off this site. How your address is used.

The files

The documents the chapters describe

Six pages to print and use. A4, with margins wide enough for US Letter.

Three cases the book does not work

New material, not a restatement. Chapter 9 describes the management package and names three variants it never takes to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Any value the book does not give is marked ADDED.

Three numbers to reproduce first

The entrySources and uses of $475.0 million: $450.0 million of enterprise value, $15.0 million of fees, $10.0 million of cash; $275.0 million of debt at 5.5x EBITDA and $200.0 million of equity, 42.1 percent of the total
The bad yearYear 3: platform EBITDA down -19.8 percent, covenant leverage 4.63x against a maximum of 4.75x, headroom 0.12x; in the deeper version the test fails by 0.64x and the equity cure costs $7.0 million
The returnBridge: $250.4 million of EBITDA growth, $35.3 million of deleveraging, no multiple change, -$25.5 million of fees, $260.2 million in all; the sponsor's 17.05 percent becomes 12.70 percent for the subscriber, and 14.39 percent with a subscription line

The files are provided as they are, without warranty of any kind. The models are illustrative: the fund, the company, the lenders and every person in them are fictional, and the figures are the book's assumptions, not market statistics or forecasts. Nothing here is investment, legal or tax advice.

Also available as a standalone free template: LBO model. For the full seven-year model with four debt tranches, covenants and a management ratchet, watch the five-minute demo of the LBO Model, Pro Edition.

Five-minute video demo of the LBO Model, Pro Edition: no circular reference, no macros, 31 checks

What changed, and when

15 Nov 2026Added six working documents to print (Appendix B’s checks by stage, the Chapter 19 model review, a covenant tracker) and three new worked cases on the management package: the dead zone above the 2.0x hurdle, sweet equity priced, and a ratchet with its steps. The three Kestrel workbooks are unchanged and their checks still pass.

Articles on this book

9 of the calculations in these workbooks, worked out in full. All articles.

Also by Julian R. Sterling

More in private equity, with free companion files. The full list of titles is on the author page.

If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.

Learn to build the whole model

Sixteen video lessons that build a complete LBO model in Excel on one case, from sources and uses to sponsor returns, with step files, exercises that check your answers, a 160-question quiz and the LBO Model, Pro Edition included ($149).

Watch lesson 1.1 and try ten quiz questions, free →