Companion files
Economics, Governance, Waterfalls and Clawbacks
These are the companion files of How to Read a Limited Partnership Agreement by Julian R. Sterling.The book on Amazon →
One Excel workbook with no added inputs at all: chapter 11’s clawback, worked to the escrow that actually covers it. Around it, the same model blank plus a fee and waterfall model for your own fund, thirteen 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.
Seven workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 23 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 Contracts Reading Pack: four PDF editions on leases, loan agreements, LPAs and credit agreements, this book included, $49.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.
Appendix F · Chapter 11
The two negotiations the chapter recommends pull against each other. Lowering the assumed tax rate from 45 to 37 per cent raises the obligation from 13.20 to 15.12 million — the point of doing it. The escrow does not move. So the uncollateralised balance rises from 6.00 to 7.92 million, an increase of 1.92 — which is precisely the 1.92 million the chapter says the tax argument is worth. Every dollar won on the assumed rate lands, in full, in the uncollateralised column. The investor holds a larger claim and is no better secured. Not an argument against winning the tax point; an argument for never winning it alone.
The rule, in one line. Uncollateralised = C × max(0, (1 − t) − e), which is zero whenever e ≥ 1 − t. It does not depend on the size of the fund or how badly it performed. A gross clawback needs a 100 per cent escrow; a 45 per cent clause needs 55; a 37 per cent clause needs 63 — which inverts the intuition, because the more generous net-of-tax assumption is the one that needs the smaller escrow.
“Fifty per cent rather than thirty roughly doubles the protected amount” — it multiplies it by five thirds. 7.20 to 12.00 is 1.67 times, not two, and the chapter overstates the gain by a third in the sentence recommending the negotiation. It matters because the protected amount is capped by the obligation, and the chapter discusses thirty and fifty without ever naming fifty-five, past which every further point is dead money held against nothing.
The four backstops are one mechanism and three beliefs. The chapter ranks escrow, personal guarantees, a management company guarantee and a bare obligation, and says the guarantees depend on solvency “nobody can assess in advance”. So they are the escrow plus three beliefs about one number. At a 30 per cent escrow the honest answer to what will be recovered is anywhere between 7.20 and 13.20 million — forty-five per cent of the obligation riding on the unknowable. At 55 it is 13.20 either way.
And that prices the third recommendation. An interim clawback test changes the probability of collection, never the obligation, and probability only operates on the residual. On a 55 per cent escrow an interim test is housekeeping. On a 30 per cent escrow it is worth up to 6.00 million — the figure to put in front of a manager who calls it an administrative burden. Twenty-nine checks.
Download the workbook20 KBChange the assumed tax rate on sheet 1 and watch sheet 5. Then change the escrow. Those two cells are the entire negotiation, and the rule connecting them is one line long. Then put your own carry figure in and everything rescales, because the whole result is proportional to it.
It cannot tell you the probability that an uncollateralised balance is collected eight years after the carry was paid, and that is the point rather than a limitation: the chapter is right that nobody can assess it in advance, and the workbook’s answer is to bound the recovery between the escrow and the obligation and show how much of the range that unknowable actually governs. Nor can it read your escrow release language — an escrow released on a schedule rather than on the clawback position is not the instrument modelled here.
Two workbooks with every input emptied. The checks sheets count what is still missing and test what holds for any inputs.
Chapters 7 to 11 · Appendix F
The clawback workbook with its inputs emptied: your carry paid and due, escrow and the two tax rates. And a new file for the two calculations the book says nobody does: the fee total over the fund’s life, from the rates, the bases and the step-down, and a whole-fund waterfall built from your own calls and distributions, year by year, with the four running balances of Chapter 10 and its four tests.
The book’s figures are listed in a text file inside the archive. Type them back in and the files return a 6.00 uncollateralised balance, 71.35 of fees, 485.85 drawn and 78.83 of carry.
Download the blank set32 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 2 to 19 · Appendix B
Each chapter ends with a page to fill in; these are those pages, with the tables the text describes. The map: seven facts, six dates and one number. The mandate and investment period, three questions per restriction. The commitment page with a stressed call profile. The fee page with the total computed year by year. The expense review in four steps, with the prior funds’ actuals. The carry page and the waterfall on two outcomes, with the four tests. The clawback: six answers and the recovery. Key person and removal, read against the investor register. The remedies page. Conflicts, valuation and reporting, with the computability test. Transfers and the side letter pack tabulated. The thirty red flags. And the one-day review with the ranked negotiation list.
Download the PDF35 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Seven on structure, mandate and term, eight on the economics, seven on the clawback and governance, seven on conflicts through side letters and the one-day review, five on the appendices and red flags, and six 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 book17 KBNew material, not a restatement. Three situations the chapters name 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.
Chapters 9 and 10 · Case one
The worked fund’s whole-fund waterfall, run from 1.00x to 3.00x instead of at one outcome. Carry switches on at 1.91x and the catch-up completes just above 2.05x: in between, about 57 of distributions go entirely to the manager and the investors’ net return is pinned at the 8 per cent hurdle. The book’s 2.2x outcome clears the catch-up by 0.15x. A hard hurdle would pay 27.25 instead of 78.83; a preferred return that skips fee and expense contributions moves the switch-on to 1.80x. The book’s IRRs cannot be checked: it prints no dates.
Chapters 6, 7 and 11 · Case two
What each clause moves on the 71.35. “Each additional year of the investment period is worth ten million” holds only if every exit slips with it; if realisations stay put it is 3.00. A post-period base of commitments adds 22.40, not “roughly twenty”. And Chapter 11’s “same fund” exits on a schedule that gives a fee of 64.00 and 478.50 drawn, not 485.85: the clawback conclusion stands, the reused figure does not.
Chapters 3 and 5 · Case three
A one-year subscription line at 5 per cent on the worked fund. The investors’ net IRR rises 0.95 points, the multiple falls from 1.649x to 1.580x, and the interest is 24.29. The effect neither chapter mentions: the preferred return accrues from contribution, so calling later lowers the hurdle: carry switches on at 1.85x instead of 1.91x. If the line cannot be renewed, the fund calls 93.7 at once.
Download the three cases178 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| ADDED | nothing in the book’s workbook: every input is a figure the chapter states. The cases and the waterfall model add dates, which the book never gives, and mark them ADDED |
| Checks sheet | twenty-nine controls — eight reproduce the chapter before anything is questioned |
The fund and its five investments are the book’s own and fictional, as they are in the book. This is not legal advice, and no workbook substitutes for reading the agreement.
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.
| 23 Sep 2026 | Added: the clawback model blank, a fee and waterfall model for your own fund with the four tests of Chapter 10, thirteen working documents, forty questions that mark themselves and three new cases. The workbook can now also be downloaded on its own; it is unchanged. |
More in private equity and funds, with free companion files. The full list of titles is on the author page.
How to Read a Limited Partnership Agreement 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 How to Read a Limited Partnership Agreement. 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.