Companion files
The Role, the Craft, and Proving the Value You Created
These are the companion files of The ESG Manager in Private Equity by Julian R. Sterling.The book on Amazon →
One Excel workbook that closes the gap between the book’s most quantitative chapter and its exit chapter, now corrected. Around it, a blank version for your own company, twelve 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 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.
Appendix G · Chapter 14
Enterprise value is the wrong unit. Chapter 10 lands on 9.7 million of enterprise value and stops. No investment committee decides in enterprise value. Carried through an ordinary capital structure the same programme is worth 8.86 of equity, 0.16× on invested capital and 2.2 points of gross IRR — and a return of 10.7× on the money spent, measured the way the committee measures it. That is one multiplication and one subtraction from what the book already computes, and it is nowhere in the book.
The book prices a line and then drops it. The same case spends 150,000 to meet two large customers’ requirements and says it “protects 11 million of revenue”. The chapter’s total excludes it. Two paragraphs later the case reports that the buyer cited supplier-readiness as its reason for preferring the asset. At the case’s own 14.7 per cent margin and its own 8.5× multiple, that line protected 6.89 million — 46× its cost, against 14.3× for the two lines the chapter does count (11.7× only if you divide by the whole 830,000, which includes the cost of the line the total leaves out). Per euro spent it is the best thing in the book’s own example, and it is the one item left out.
And here is why the file will not let you say it that way. 6.89 does not beat the 9.69 created, and the commercial diligence would have priced customer concentration anyway. So the sheet reports the answer at 0, 50 and 100 per cent attribution — nothing, 3.44, 6.89 — and shows the exact point where defence overtakes creation: when the share lost times the attribution passes 0.70. One of the checks fails on purpose if the defensive case is claimed as the larger one. Over-claiming is what gets an ESG manager’s numbers discounted entirely, which is a warning the book itself makes.
The half-turn nobody controls. The case buys at 8× and sells at 8.5× and never says why. On the exit earnings that step is worth 10.0 million — slightly more than the entire programme beside it. Put the other way, the whole four-year programme is worth 0.485 of a turn. If the multiple lands half a turn light, everything the function did is cancelled by the credit market.
And a correction. Chapter 14 says eighteen months is enough to “remediate contamination, obtain a certification…”. The two clocks are walked as editable week counts: a management-system certification runs about 8–11 months; contaminated land to a closure statement runs about 19–32, because four quarterly rounds of validation monitoring cannot be compressed and cannot start until the works finish. Eighteen months is generous for the first and short for the second — and the second is the one the sentence lists first. Twenty-nine checks.
Download the workbook25 KBSet the attribution share to zero and watch the defensive case go to nothing — that is the version a sceptical commercial partner will argue for, and it is worth seeing before the meeting rather than during it. Then change the remediation works from twelve weeks to fifty-two and watch the exit preparation date move out of year four and into year two.
It cannot tell you how much of the protected revenue belongs to the ESG function rather than to the commercial workstream — that is the input the whole defensive case turns on, and the only way to settle it is to ask the losing bidders what moved their number. It cannot tell you whether ESG moves the exit multiple, which is the largest term of all and the one the book calls “harder to isolate”. And the process durations are illustrative and vary by jurisdiction and site; the shape is the point, not the weeks.
The workbook with every input emptied. Enter your own company, programme and capital structure; the checks sheet counts what is still missing and tests what holds for any inputs.
Chapters 10 and 14 · Appendix G
Revenue, EBITDA, entry and exit multiples, what each initiative delivered and cost, the revenue a defensive line protects, leverage, exit EBITDA and net debt, the share lost and the share you can claim, and the durations of your own slowest processes. The file gives the enterprise value and the equity created, the change in multiple and IRR, the defensive line at three attributions with its break-even point, what the multiple step is worth beside the programme, and your exit-preparation clock.
The book’s inputs are listed in a text file inside the archive. Type them back in and the file returns 9.69 of enterprise value, 8.86 of equity, 2.2 points of IRR and a contamination clock of 19 to 32 months.
Download the blank set24 KBTwelve pages to print and use. A4, with margins wide enough for US Letter.
Chapters 8 to 15 · Appendices A to C
Screening and the risk assessment with its three outputs. The Appendix A diligence checklist, with a column for why an item does not apply. The IC paper section: findings, ranges, one recommendation in deal language, what was not investigated, the exit line. The post-completion action list in its three categories, with the hundred days. The company that cannot and the company that will not, with the escalation ladder. The value creation plan, sized and tracked, carried through to equity. The core metric set as a data dictionary with a destination column. The collection calendar and validation log, with the coverage statement. The abatement cost curve and the choice of target type. The incident protocol and the first seventy-two hours. Exit readiness and the data room. And the first ninety days: the commitments register and the portfolio map.
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
Six on the field and the rules, seven on the role and getting hired, seven on fundraising, diligence and the hundred days, eight on value creation, data and carbon with Appendix G, six on governance, exit and the first ninety days, 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 8 · Case one
Chapter 8’s model answer, priced: “a €1.2m price reduction, plus a specific indemnity capped at €3m” for groundwater, on a site whose range is €0.8 to 2.4 million. The only part the indemnity does not cover is the 0.8 without migration, so the buyer is overpaid by €0.4 million in every outcome, clean plume or worst case, at any probabilities. The cap, larger than the whole site’s high case, invites the reading in which the whole 1.2 is paid twice. The clean version: reprice 0.8, indemnify the groundwater, cap it at the width of the range.
Chapter 12 · Case two
The food manufacturer’s five actions, costed per tonne: compressed air -432 €, lighting -345, heat recovery -24, refrigerant +87, boiler +232. The chapter calls the refrigerant “the single largest abatement”: at 310 tonnes it is a third of the boiler’s 900, which nobody funded. The four funded actions pay for themselves together, €70k a year after their capital, and abate 45% of the identified tonnes.
Chapter 12 · Appendix F · Case three
The Common Mistake the chapter warns against, run through five years of deployment. Twelve companies, each cutting its own emissions 6 per cent a year; a fund-level target of minus 30 per cent. Financed emissions end up 238%, and intensity per euro invested ends above where it started. Hitting the target would take every company cutting 43% a year. And the first cohort alone shows a fall of 50% of which 32% is its valuations rising, not its emissions falling.
Download the three cases52 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| Checks sheet | twenty-nine controls — two test the file against the book, and one fails on purpose if the appendix over-claims |
Every figure is illustrative. The company and the programme are the book’s own invented case; the capital structure, the exit earnings and the process durations are added because the book does not state them, and each is an editable cell.
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 | The book’s workbook corrected: the two lines Chapter 10 counts cost 680,000, not 830,000, and returned 14.3×, not 11.7; defence overtakes creation once share lost × attribution passes 0.70, not only at total loss and full attribution; the buyer’s remark is credited to Chapter 10. Twenty-nine checks. Added: a blank version, twelve working documents, forty questions that mark themselves and three new cases. The 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: ESG value creation model.
The ESG Manager in Private Equity 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 ESG Manager in Private Equity. 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.