Companion files · The Buyout Investor
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.
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 →
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 listRun by MailerLite, off this site. How your address is used.
Chapters 3 to 10, 12 and 14
Kestrel Fluid Systems from the seller's adjusted EBITDA of $55.0 million to the $50.0 million the fund paid 9.0x for; sources and uses; the term loan, the second lien and the revolver year by year with interest on opening balances and the cash sweep; tax with the interest cap; a balance sheet that closes every year; the covenant that held by 0.12x in year 3; the exit waterfall with the option pool; the sponsor's IRR by annual and by dated flows. Every computed figure is a live formula, checked on the Checks sheet.
Download the workbook88 KBChapters 1, 6, 11 to 13, 15, 16 and 19
The bridge whose parts add to the $260.2 million gain; the exit multiple from 8.62 percent to 23.75 percent; the entry price with the debt held constant and the wrong table that resizes it; leverage at closing; the holding period; the plan delivered; the two-way grid; and the scenarios of the add-on, the bad year with its equity cure and its amendment, the recap, the unitranche, higher rates and the all-equity purchase, each on its own sheet as a complete live case.
Download the workbook524 KBChapters 17 and 18
Commitments behind the $190.0 million invested, the management fee, the preferred return compounded from each contribution, the catch-up and the $41.3 million of carry; 17.05 percent for the deal, 15.14 percent after fees, 12.70 percent net, 14.39 percent with a subscription line that adds not a dollar.
Download the workbook54 KBChapters 5, 7, 15 and 17
Sources and uses with the equity as the balancing item, a five-year one-page LBO model with a term loan, a sweep and an interest cap, a returns bridge, and a deal-to-fund sheet with fee, preferred return, catch-up and carry. Every input is empty and every output a live formula.
Download the workbook20 KBThe whole book
A separate, smaller deal. Start a timer, build the fifteen answers, then open the Score sheet and the Answer Key.
Download the workbook17 KBRead first
What each file is, which chapters it serves, the order to read them in and the conventions.
Download the read-me4 KBSix pages to print and use. A4, with margins wide enough for US Letter.
Chapters 8 and 19 · Appendix B
Appendix B’s checks, arranged by the moment each must be asked: before the price, before the debt, before the equity, in each year of the hold, before a dividend recapitalization, before the exit, and the questions a subscriber puts to a manager. The ten mistakes of Chapter 19 as a model review, each with the test the model must pass. And a covenant tracker with Kestrel’s figures beside blank rows for your own deal.
Download the PDF19 KBNew 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.
Chapters 9 and 12 · Case one
Half the pool vests only if the sponsor reaches 2.0x, whole pool counted. That line sits at $417.4m of exit equity. One dollar above it, 8.70 million options vest at once: the sponsor receives $7.9m less and management $7.9m more. The sponsor is worse off than just below the line until $426.4m, a $9.0m band in which it would gain by selling for less. The deeper bad year ends $3.7m under the line.
Chapter 9 · Case two
The same $200m split into a preferred strip and a thin ordinary layer (split and coupon ADDED: $170m at 10%). The preferred is $273.8m at exit, and only what lies above it is shared. Management makes 6.21x in the base case against 4.28x on the book’s package, and 1.10x in the downside against 1.96x. The same idea as options, geared harder.
Chapter 9 · Case three
An ADDED ladder: 8, 10 and 12 percent of the shares at 2.0x, 2.5x and 3.0x. It pays exactly the book’s package in three of the four exits and $59.8m against $53.3m with no bad year. Every step, at $417.4m, $533.3m and $654.5m of exit equity, opens its own band in which the sponsor and management want different prices.
Download the three cases27 KB| The entry | Sources 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 year | Year 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 return | Bridge: $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.
| 15 Nov 2026 | Added 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. |
9 of the calculations in these workbooks, worked out in full. All articles.
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.
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).