Companion files
Fair Value, Governance and Judgment in Private Markets
These are the companion files of The Private Markets Valuation Specialist by Julian R. Sterling.The book on Amazon →
Five Excel workbooks, revised. The book describes its worked illustrations without numbers, on purpose — the reasoning is the lesson. These files close the chain, with one full set of figures and every input in a cell you can overwrite. Around them: the same five with the inputs emptied, twelve working documents to print, forty questions that mark themselves, and three cases the chapters name and never take to a number. All free. Nothing is gated behind a sign-up, and no email address is asked for.
The five workbooks, the blank set, the printable documents, the question book, the three cases 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? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
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 5, 7 and 14
The chain of Chapter 5, link by link: five comparable peers and why each is in the set, reported EBITDA normalised to the figure a market participant would use, and a multiple built from four named, signed judgments — size, customer concentration, growth, margin — that net to seven-tenths of a turn. Under one turn, as the chapter says, but now four things that can be challenged separately rather than one number asserted.
Then the confrontation that makes it calibration rather than arithmetic. The entry price two years ago implied its own relationship to the peer set; the file computes that relationship independently and puts it beside the bottom-up build. When they disagree it says by how much, and converts the disagreement into dollars of enterprise value. The day-one test is on the same sheet: re-run at the acquisition date, does the model reproduce the price paid?
The last sheet splits the movement in enterprise value into the part caused by comparable multiples moving, the part caused by the company’s own metric moving, and the part caused by a deliberate change in the calibrated relationship. The three sum to the total with a residual of exactly zero.
Download the workbook23 KBChapter 6
Chapter 6 says the ten years of forecast may account for only a minority of present value while the terminal value carries the majority, and calls the split dependent on the discount rate and the growth assumption. Here it is: 171.5 of present value in ten years of forecasting, 196.2 in a single estimate of everything after.
The terminal value is computed both ways the chapter prescribes — a perpetuity growth capitalisation and an exit multiple — and the two are put side by side, because a wide gap means one of the assumptions is unreasonable and the model should not proceed until you know which. A grid of five growth rates against five discount rates shows the same split moving, with nothing in the ten forecast years changing at all.
Download the workbook20 KBChapters 8 and 9
The bridge Chapter 9 calls deceptively simple, walked twice. Once at a single enterprise value: seven components of net debt, six of which contain a judgment, and then a waterfall through a participating preferred, a non-participating preferred, common and an option pool.
The non-participating preferred chooses. The file computes both branches on every row — convert, or take the liquidation preference — and takes the one the holder would actually choose, because a model that assumes otherwise is valuing a security nobody owns. At the base case it takes the preference, and the common is worth 1.24 a share against the round price of 2.00: 62 per cent of what the headline post-money implies for it. That gap is the preference stack, and Chapter 8 calls treating the two as the same a well-known error. The exit ladder shows where each layer bites: the common is worth nothing below an enterprise value of 190, the options come in at 302.5, the preferred converts at 344.
Download the workbook22 KBChapter 10
One senior secured term loan of fifty million, floating over a base rate with a floor, four years to run — walked from performing, through moves in rates and spreads, into trouble. Move the base rate two points either way and the price does not change, to four decimal places. Move the spread and it moves nine and a half points. Nothing about the borrower’s cash changed in either case.
Then the borrower gets into trouble and the question stops being a yield. The file asks what the enterprise is worth, subtracts what ranks ahead, caps the answer at the face amount, discounts it for the eighteen months a restructuring takes, and probability-weights three states. The mark comes out at 74.8 per cent of face. A final sheet draws the payment-in-kind accrual trap: a balance compounding at twelve per cent against the value left to cover it once the senior claim is paid, growing at 8.1 per cent and slowing. The two lines cross in year four.
Download the workbook25 KBChapter 11, and Appendix F
Chapter 11 says it is on real assets, secondaries and the hardest judgments that valuations most often succeed or fail under scrutiny — and it is the one chapter in the book that contains no figure at all. This file computes all five of its instructions on one consistent set of inputs, and Appendix F walks through what each one turns out to be worth.
A secondary interest reported at 50 becomes an honest 45 once the lag and the distribution come out, and the bid lands at 34.41. The 31.2-point headline discount then splits: 10.0 points of stale reporting, 21.2 points of the secondary market pricing the interest, residual zero. Two thirds of the discount is the part a roll-forward never recovers.
Then the double-count, in money: an entry at 7.3 times against peers at 8.9 already embeds 18.0 per cent, and a conventional 20 per cent on top compounds to 34.4 — 16.4 points too much, or 19.7 of equity value removed twice on an enterprise value of 120.
The marketability sheet is the one that argues with the convention. A protective put at 45 per cent volatility over two and a half years indicates 22.0 per cent. Invert it and the required volatility for a conventional 30 per cent is 60 per cent — and no holding period whatever reaches 30 at 45 per cent volatility. The method peaks at 28.6 per cent, at 9.6 years, and declines after that. Volatility is an input cell; change it and the ceiling moves with it.
Two more. Three distressed trades — 71 cents after three days, 78 after forty-two, 84 after sixty-three — fit to an orderly sixty-day price of 81.7, against which the prior-quarter mark of 96 overstates by 17.5 per cent and the three-day trade understates by 13.1. And an appraisal delivered as a single 121.9 sits inside a range of 13.7 per cent of itself, resting on seventy-five basis points of capitalisation-rate judgment nobody had to defend in writing.
Download the workbook24 KBSet the exit multiple in the income file to twelve times. One check turns from PASS to EXPLAIN, and the terminal value sheet tells you why: at a discount rate of 8.5 per cent, a twelve-times exit implies long-term growth of about a sixth of one per cent. If that is not a growth rate you would have typed, it is not an exit multiple you should have typed either. Run that inversion in both directions and the terminal value stops being a number you assume and becomes one you defend.
Then open the exit ladder in the waterfall file and read down the price-per-common-share column. It is flat at zero until both preferences are covered, then rises, then kinks where the options come into the money, then kinks again where the non-participating preferred converts and the pool it shares with grows: at enterprise values of 190, 302.5 and 344. Three kinks, none of them visible from a single mark, all of them load-bearing for anyone holding the common.
And in the calibration file, type a non-zero number into the cell marked deliberate change in the relationship this quarter. A third line appears in the roll-forward attribution with your name on it, and the residual stays at zero. That is the whole discipline of Chapter 14: a change you can decompose is a change you can defend.
The five workbooks with every input emptied. The checks sheets count what is still missing and test what holds for any inputs.
Chapters 5 to 11 · Appendix F
Your comparable set, normalisation and multiple build, with the entry anchor and last quarter for the calibration and the roll-forward. Your forecast, discount rate and terminal assumptions. Your net debt and capital structure. Your loan, its recovery states and a payment-in-kind position. And the five hard calls: a fund interest, an entry discount, a protective put, three distressed trades and an appraisal. The grids and the exit ladder are steps, not data, and are kept.
Each file stays blank until every input is in, then runs the tests that hold for any inputs: the roll-forward closes, the waterfall distributes exactly its equity, recovery never exceeds face, the discount decomposes with no residual. The book’s figures are listed in a text file inside the archive; type them back in and the book’s results come back.
Download the blank set107 KBTwelve pages to print and use. A4, with margins wide enough for US Letter.
Chapters 3 to 14 · Appendices B and C
The valuation policy on one page, method by asset type. The quarterly calendar worked backward from the reporting deadline. The quarterly checklist of Appendix C. The valuation memorandum of Appendix B, one box per section. The market approach link by link. Calibration, the day-one test and the roll-forward with its residual. The terminal value review with a blank sensitivity grid. The bridge from enterprise value to the security held, with the post-money test. The credit mark: yield, recovery states and payment-in-kind coverage. The five hardest calls. The valuation committee agenda and minutes. And audit readiness with model control.
Download the documents31 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Seven on fair value and governance, seven on the market approach and calibration, six on the income approach, seven on equity and the bridge, seven on credit, the hard calls and Appendix F, 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 book18 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.
Chapter 11 · Case one
Chapter 11 lists the remaining unfunded commitments among what drives a secondary discount, and Appendix F prices the interest without them. With 12 still to be called and the called capital returning 1.40× (ADDED), the bid falls from 34.41 to 32.41, and the headline discount splits three ways: 10.0 points of stale reporting, 21.2 of market pricing and 4.0 for the commitment. The capital called later must return 1.74× merely to be worth nothing.
Chapter 9 · Case two
The market workbook’s quarter, in a euro company held by a dollar fund: up 19.1 per cent in euros, up 13.1 in dollars after a five per cent fall in the euro (ADDED). The currency line is -10.63 in the policy order and -8.93 in the other; the 1.70 between them belongs to neither driver, and the policy has to say where it goes. A fall of 16.0 per cent would have hidden the quarter entirely.
Chapter 11 · Case three
The 28 per cent customer gives notice after the measurement date. At a 30 per cent contribution margin (ADDED) EBITDA falls 39.6 per cent. Classified as evidence of conditions at the date, the equity mark is 82.18 once the multiple is re-underwritten; as a new development, 193.24: 111.06 rides on the dates. Leaving the multiple alone lands close, but only because a double count of 8.20 offsets a margin premium the company no longer earns. And the concentration discount had implied a 10.9 per cent chance of losing the customer.
Download the three cases34 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| Checks sheet | fifty-one controls across the five workbooks, each stating its own verdict; the blank set and the cases end with their own |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
Two of the checks are deliberately not PASS. One reads as warned when the terminal value carries more than half the answer, because that is what Chapter 6 warns about. Another reads as Chapter 8 warns when the common is worth less than the headline price implies for its own shares. Both are findings, not faults.
The Private Markets Valuation Specialist 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.
The workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers; the PDF prints on A4 or US Letter. They use 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 | The five workbooks revised. Waterfall: the common is worth 62.2 per cent of what the headline implies for its own shares, not the 29 per cent of the whole headline the first edition compared it with; the options come in at 302.5, before the preferred converts at 344. Market: the subject out-earns all five peers, by 300 basis points over the median, not 212. Income: the terminal value carries 53.4 per cent on the base case, not above sixty. Credit: the cure value now uses its own spread input, the payment-in-kind chart is drawn, and one check that failed on other inputs is rebuilt. Fifty-one checks. Added: a blank set of the five workbooks, twelve working documents, forty questions that mark themselves and three new cases. Each workbook can now also be downloaded on its own. |
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: DCF with terminal value.
These files accompany The Private Markets Valuation Specialist. 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.