Companion files
Creating Value in Portfolio Companies
These are the companion files of The Private Equity Operating Partner by Julian R. Sterling.The book on Amazon →
One Excel workbook that builds the artifact the book calls the most important one an operating partner produces. Around it, a blank version for your own deal, four working documents to print, forty questions that mark themselves, and three cases the book does not work. All free. Nothing is gated behind a sign-up, and no email address is asked for.
Six workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 22 September 2026.
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.
Chapter 13, and the appendix
Chapter 13 is about building the value creation bridge, and it does not build one. It gives the Vireo Health Services example three numbers — 6.2 million of gross initiative impact, 14 million of entry EBITDA, 4.1 million of actual growth — and says a reconciliation was built. It never shows it.
This workbook builds it. Vireo enters at 14.0 of EBITDA on 9.5×, levered 4.5×, and exits five years later at 24.5 on 10.2× — 3.08× money, 25.3 per cent. The 145.73 of equity value created decomposes into six buckets with a residual of zero to six decimal places, because a bridge with a residual is not a bridge.
Then read the shape rather than the numbers. The operating work the whole book is about is 41 per cent of the value created. Deleveraging — which no operating partner performs — is 20 per cent, almost as much. Another 14.5 per cent came from the market and the multiple, which is to say from nothing anyone in the firm did.
Download the workbook25 KBThe 28.50 attributed to acquisitions is what a value creation deck prints. The add-ons were bought for 12.0 of cash — cash that would otherwise have repaid debt, which is why the deleveraging bucket is 28.83 and not roughly 41. Net contribution: 16.50. The difference between a buy-and-build programme that made 19.6 per cent of the value and one that made 11.3.
What the add-ons genuinely produced is multiple arbitrage: EBITDA bought at 4.0×, sold inside a platform trading at 10.2×. That is real, repeatable, and a far stronger claim than an inflated gross figure — because it comes with a mechanism a buyer can verify and continue.
Enterprise value is EBITDA times a multiple. When both move, the change has three parts, and the third — growth multiplied by re-rating, 7.35 here — belongs to both and to neither. Assign it to growth and re-rating contributed 9.80. Assign it to the multiple and re-rating contributed 17.15.
The growth bucket swings 7.4 per cent on that choice. The multiple bucket swings 75. And the multiple bucket is precisely the one a buyer discounts, because the next owner cannot repeat a re-rating. A seller has a direct incentive to starve it, and nothing in the arithmetic stops them. Show the cross-term as its own line and let the buyer allocate it — the credibility is worth more than the 7.35.
The belief is that heavy leverage dilutes the operating contribution. Run the same deal from 3.5× to 6.5× entry leverage and the operating share of value created rises, from 39.7 to 44.1 per cent — because more debt means more interest, less free cash flow, and a smaller deleveraging bucket. Leverage does not add a bucket. It shrinks one.
And the figure that does not move at all: organic improvement contributes 59.85 at every leverage level, identical at 3.5× and at 6.5×, because it is a property of the business and not of the balance sheet. Leverage does not change what the operating work is worth — it changes the size of the equity base that work is measured against.
Four initiatives, 6.2 of gross impact. Two headwinds — caregiver wage inflation and a licensing delay — worth −2.1. Net movement 4.1, which is the figure in the book.
Now price the gap. 2.1 of EBITDA at the entry multiple is 19.95 of enterprise value — 28.5 per cent of the equity cheque. A board reading the gross figure and believing EBITDA stood at 20.2 rather than 18.1 was wrong about the value of its own investment by more than a quarter of what it put in. An unreconciled gross number is not a reporting inconvenience; it is a mispricing of the fund's own position, carried quarter after quarter until a buyer finds it.
The book’s model with every input emptied. Type in your own entry, hold and exit; the checks sheet counts what is still missing and tests that the bridge reconciles.
Chapter 13 and the appendix
Entry EBITDA, multiples, leverage, the EBITDA path by source, the add-on and the eighteen-month reconciliation: every amber cell is empty. The file runs a five-year hold, one row per year, and ends on a checks sheet: how many inputs are still missing, then six tests, starting with the only one that matters, a residual of zero.
The Vireo inputs are listed in a text file inside the archive. Type them back in and the file returns 70.0 in, 215.7 out and a bridge of 145.73, exactly as the appendix does.
Download the blank set22 KBFour pages to print and take into a meeting. A4, with margins wide enough for US Letter.
Appendices B, C and D · Chapters 5 and 13
The first hundred days of Appendix B, phase by phase, with owners and evidence. The value creation plan of Appendix C: the initiative inventory, the gross-to-net reconciliation the Vireo board needed at eighteen months, and a risk register. A board dashboard with the six-bucket bridge, the cross-term on its own line. And the twenty practitioner questions of Appendix D, with what to listen for.
Download the PDF12 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Six on the role and the return model, nine on plans and levers, six on buy-and-build, the board and exit, eleven on the Vireo bridge and eight on the three cases below. Numbers are marked to a tolerance, multiple choice to the letter, and the score sheet counts your errors part by part: that is your revision list.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the question book16 KBNew material, not a restatement. Three situations the chapters name in passing and never take 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. Type your own figures in and every finding recomputes.
Chapter 8 · Case one
A blanket 4 per cent increase against Tanner’s method: the underpriced quartile moved halfway to its band median. On the plan the blanket increase wins, 1.96 against 1.32 of EBITDA. But each extra point of lost volume costs it 0.34 against 0.09, and if churn runs 2.6 points above the estimate, the segmented plan is ahead. The chapter’s warning, priced.
Chapter 13 · Case two
Vireo exits with 2.0 of run-rate EBITDA the P&L does not yet show. The deck prices it at 20.4; a buyer crediting 40 per cent pays 8.2, and the seller loses 12.2 of equity. Holding a sixth year adds 37.9 of equity and lowers the IRR from 26.2 to 24.6 per cent. Which is better depends on which number the fund is paid on.
Chapter 8 and the appendix · Case three
Receivable days cut from 75 to 60 release 5.9 in year 2 and add 8.49 of exit equity, without moving EBITDA. The appendix bridge files all of it under deleveraging, the bucket it says no operating partner performs: 22.7 per cent of that bucket is now operating work. If the days drift back before exit, the gain falls to 1.30.
Download the three cases34 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| Checks sheet | thirty-two controls, each stating its own verdict |
Every company and figure is illustrative, as everything in the book is. What is not illustrative is the shape of the result, which holds for any plausible set of inputs. One of the thirty-two controls tests that the bridge's residual is zero — because a bridge with a residual is not a bridge.
The workbook opens in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers. It uses no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline — there are none.
| 22 Sep 2026 | A blank version of the bridge, four working documents, forty questions that mark themselves and three new cases. The book’s workbook can now also be downloaded on its own; its content has not changed. |
More in private equity and funds, with free companion files. The full list of titles is on the author page.
Also available as a standalone free template: value creation bridge.
The Private Equity Operating Partner develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on Amazon Read the related analysisAlso as an ebook on Apple Books · Google Play · DRM-free PDF edition ($19.99).
These files accompany The Private Equity Operating Partner. The book is on Amazon.
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.