Companion files · The Private Markets Career Guides
The Practitioner's Guide to Solid Waste Collection, Landfills, Recycling and Environmental Services: Routes, Airspace, Pricing, Valuation and Risk.
These are the companion files of the book. Six workbooks follow Brackenmoor Environmental Services, the fictional waste platform of the case, and the purchase that Marlowfield Infrastructure Partners studies, from the curb to the price: the 2026 base, the projection with its airspace, the debt and the covenants, the valuation and returns, the closure provision, and the recycling, waste-to-energy and special waste modules. Each keeps the case’s figures in one column and an empty column for yours. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the six workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapters 2, 4 and 5
Brackenmoor’s 2026 base line by line: revenue of $229.44 million by line of business, 780 thousand tons collected, 70 percent internalized at Stonecairn, operating costs and EBITDA of $60.2 million. Sheets: Inputs, Base, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: no exercise.
Download workbook 118 KBChapters 4 to 6, 8 and 11
Every line of business projected from 2027 to 2036, the Tarnholme tuck-in, landfill tons, airspace and capex on top of the 2026 base: EBITDA of $63.9 million in 2027 and $111.3 million in 2036, 15.3 years of permitted capacity at the end of 2036. Sheets: Inputs, Base, Projection, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: no exercise.
Download workbook 246 KBChapters 12 and 15
The sources and uses, the term loan and the notes, the cash sweep, net leverage and interest cover year by year against the covenants: net leverage of 6.42 times in 2027, lowest headroom 11.4 percent. Sheets: Inputs, Base, Projection, Debt, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: no exercise.
Download workbook 363 KBChapters 11, 13 and 14
The exit, the equity IRR of 11.89 percent against a hurdle of 11.00 percent, the highest price that still earns the hurdle ($747.0 million, or $732.4 million with the closure provision treated as debt at exit) and a DCF cross-check ($754.5 million); exercises 1 to 4, 9 and 10 and the six sensitivities of the case run here. Sheets: Inputs, Base, Projection, Debt, Valuation, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: exercises 1, 2, 3, 4, 9 and 10.
Download workbook 470 KBChapter 7
The closure and post-closure provision, payment by payment: $23.2 million at present value against a regulatory estimate of $72.0 million in current dollars. Sheets: Inputs, Provision, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: exercise 8.
Download workbook 515 KBChapters 8, 9 and 10
The Ottercombe Recycling Center per inbound ton (a margin of $37.90), the Cindervale Energy Recovery Facility (EBITDA of $16.91 million) and special waste at Stonecairn ($45.00 a ton of margin). Sheets: Inputs, Ottercombe, Cindervale, Special, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: exercises 5, 6 and 7.
Download workbook 616 KBAppendix B
First look at a waste platform; The contract file; Landfill and airspace; Closure, post-closure and financial assurance; Environmental compliance and permits; Recycling facility; Waste-to-energy plant; Tuck-in; Financing and covenants; The first hundred days.
Download the toolkit42 KBRead first
What each file holds, which workbook answers which chapter and which exercise, and the two inputs to change first.
Download the read-me5 KB| EBITDA in 2026 | Revenue of $229.44 million less operating costs of $169.2 million: $60.2 million, a margin of 26.3 percent |
| Airspace | 20.8 million tons permitted at Stonecairn on 1 January 2027, 15.3 years of capacity left at the end of 2036 after the expansion |
| The return | $325.0 million of equity for an enterprise value of $720.0 million: an IRR of 11.89 percent against a hurdle of 11.00 percent, and a DCF value of $754.5 million |
The files are provided as they are, without warranty of any kind. The model is illustrative: Marlowfield Infrastructure Partners, Brackenmoor Environmental Services, the Stonecairn Ridge Landfill, the Ottercombe Recycling Center, Tarnholme Hauling, the Cindervale Energy Recovery Facility and their region are fictional, and the volumes, prices, costs, airspace, debt terms, multiples and discount rates are the book’s teaching assumptions, not market terms, averages or the terms of any real company. The years 2027 to 2036 are projections of the case model.