# The Waste Infrastructure Investor: companion files

Julian R. Sterling

## What is here

- WII_1_Base_2026.xlsx (Chapters 2, 4 and 5; Base 2026 workbook; no exercise): sheets Inputs, Base, then Checks. 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.
- WII_2_Projection.xlsx (Chapters 4 to 6, 8 and 11; Projection workbook; no exercise): sheets Inputs, Base, Projection, then Checks. 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.
- WII_3_Debt_and_Covenants.xlsx (Chapters 12 and 15; Debt and covenants workbook; no exercise): sheets Inputs, Base, Projection, Debt, then Checks. 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.
- WII_4_Valuation_and_Returns.xlsx (Chapters 11, 13 and 14; Valuation and returns workbook; exercises 1, 2, 3, 4, 9 and 10): sheets Inputs, Base, Projection, Debt, Valuation, then Checks. 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.
- WII_5_Closure_Provision.xlsx (Chapter 7; Closure provision workbook; exercise 8): sheets Inputs, Provision, then Checks. 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.
- WII_6_Recycling_Energy_Special_Waste.xlsx (Chapters 8, 9 and 10; Recycling, energy and special waste workbook; exercises 5, 6 and 7): sheets Inputs, Ottercombe, Cindervale, Special, then Checks. 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).
- WII_Waste_Investor_Checklists.docx: the 10 check-lists of Appendix B, editable (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).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every assumption of the case, followed by an empty yellow column for yours and a Used column: the case's figures in blue on a light blue background, your figure in the yellow column when you type one. The Used column takes your figure when there is one and the case figure otherwise, and every other sheet reads the Used column. Black type is a formula, green type a link to another sheet. Each workbook carries every calculation sheet its outputs need, so it works on its own; the sheets are the same in every file. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow column is empty. Each of the 10 exercises of Appendix A is done in the workbook listed above: change the one input the exercise names, read the answer, then clear the cell.

Two inputs to try first:

1. In WII_4_Valuation_and_Returns.xlsx, on Inputs, type 90 percent for volumes: EBITDA falls in every year, interest cover and net leverage both fail their covenants in 2027 (1 year with a covenant breach), year-end cash turns negative until 2031 and the IRR on the Valuation sheet falls to 9.36 percent.
2. In WII_4_Valuation_and_Returns.xlsx, on Inputs, type 1 for the large contract lost at the rebid: residential revenue drops from 2030 and the IRR falls to 9.12 percent, under the hurdle.

To use a workbook on a real platform, replace every input with figures from the company's accounts, its contracts, the landfill engineer's airspace survey, the closure cost estimate and the financing documents, rebuild the base case until it matches what the company reports, and only then make your own changes. Take questions of law, tax, engineering and the environment to counsel, the tax adviser, the landfill engineer and the environmental consultant. The workbooks are separate files with no link between them.

## A word of caution

Marlowfield Infrastructure Partners, Brackenmoor Environmental Services, the Stonecairn Ridge Landfill, the Ottercombe Recycling Center, Tarnholme Hauling and the Cindervale Energy Recovery Facility are fictional, and their region is not named. Volumes, prices, costs, airspace, closure estimates, debt terms, covenants, multiples and discount rates are teaching assumptions, not market norms, averages or the terms of any real company, municipality, landfill or lender. The years 2027 to 2036 are projections of the case model, never a forecast. No real operator, fund, municipality or agency is described. Nothing here is investment, legal, tax, accounting or environmental advice.
