# The Midstream Infrastructure Investor: companion files

Julian R. Sterling

## What is here

- **Midstream_Infrastructure_Investor_Model.xlsx**: the workbook that rebuilds the Brackwater case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Harlan Draw Quarters, MVC Tests, Quarrystone Amendment, Harlan Draw Term Loan, Harlan Draw Valuation, Corrigan Cost of Service, Corrigan Pass Quarters, Corrigan Recontracting, Holdco Loan Tests, Corrigan Pass Valuation, Marrow Bayou Budget, Marrow Bayou Draws, Cost-to-Complete Test, Marrow Bayou Projection, Fund II Book, Checks.
- **Midstream_Infrastructure_Investor_Toolkit.docx**: the sixteen checklists of Appendix B (gathering and processing agreement, dedication and real property, MVC monitoring, producer credit, contract renegotiation, FERC tariff and rate, firm transportation contract, recontracting, LNG liquefaction contract, LNG construction and funding, opco debt covenant, holdco loan, valuation memo, joint ownership and governance, energy transition, quarterly monitoring), in editable form.

## Which sheet answers which chapter

- Chapters 2, 5 and 6: Harlan Draw Quarters (plant utilization from 87.0 percent in Q4 2024 to 76.3 percent, rounded, in Q3 2026; operating and covenant EBITDA by quarter)
- Chapters 5 and 6: MVC Tests (shortfalls of $736,000, $2,944,000 and $5,040,000, none in Q2 2026, $588,800 accrued in Q3 2026); Quarrystone Amendment ($2,520,000 paid and $2,520,000 released; yearly minimum fees of $102,200,000 and $78,840,000)
- Chapter 8: Corrigan Cost of Service (a $930,000,000 rate base, a revenue requirement of $180,261,263, rounded, and a recourse rate of $0.2744 per Dth/d)
- Chapter 9: Corrigan Pass Quarters (EBITDA of $40,006,000 in Q3 2026 and the Holdco's 25 percent of each distribution)
- Chapter 11: Corrigan Recontracting (yearly firm revenue lower by $16,060,000; contract life of 4.84 and 4.91 years, both rounded)
- Chapters 12 and 13: Marrow Bayou Budget, Marrow Bayou Draws and Cost-to-Complete Test (headroom of $100,000,000 at the last two draws, minus $600,000,000 without the June 2026 commitments)
- Chapters 13 and 16: Marrow Bayou Projection (equity IRR of 7.0 percent with the overrun against 8.3 percent at budget, both rounded; a projection, not a forecast)
- Chapter 14: Harlan Draw Term Loan (leverage from 4.668x to 4.863x, rounded, against 5.25x and 4.75x at each quarter end); Holdco Loan Tests (coverage of 3.50x and 2.85x, rounded, against 1.50x)
- Chapter 15: Harlan Draw Valuation (equity of $396,257,272, rounded) and Corrigan Pass Valuation (a mark of $152,880,000)
- Chapter 15 and the Conclusion: Fund II Book ($856,023,529 invested and a gross multiple of 1.02x, both rounded)

## Two inputs to change first

1. On Inputs, raise Quarrystone's Q3 2026 volume above 270 MMcf/d: watch the shortfall vanish on MVC Tests, then trailing covenant EBITDA and the 30 September 2026 distribution test on Harlan Draw Term Loan, and the mark on Harlan Draw Valuation.
2. On Inputs, set the switch for the June 2026 commitments to 0: watch the cost-to-complete test fail at the last two draws on Cost-to-Complete Test. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Brackwater, Harlan Draw, Quarrystone, Velden, Corrigan Pass, Marrow Bayou and every other name in the case are fictional; the model is a simplified teaching model; rules are general and dated October 2026; all case volumes, fees, tariffs, costs, rates and figures are illustrative assumptions, not market data or benchmarks. Provided as is, without warranty. Not investment, legal, tax, engineering, regulatory or accounting advice.
