Companion files · The Private Markets Career Guides

The Midstream Infrastructure Investor

How Pipelines, Processing Plants and LNG Terminals Are Bought, Contracted and Financed: MVCs and Take-or-Pay, FERC Tariffs, MLPs and Private Funds, Recontracting Risk and the Career.

These are the companion files of the book. One workbook rebuilds the Brackwater case: Harlan Draw’s volumes, fees and EBITDA by quarter, Quarrystone’s MVC tests and the amendment, the term loan with its leverage covenant and distribution test at each quarter end, Corrigan Pass’s cost of service and recourse rate, its quarters, the producer’s renewal and contract life, the holdco loan’s coverage tests, Marrow Bayou’s budget, draws and cost-to-complete test with and without the June 2026 commitments, a projection, the three marks and Fund II’s book. A toolkit holds the sixteen checklists of Appendix B in an editable form.

The workbook, the toolkit and the read-me, in one archive104 KB

The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

The gathering systemA $5,040,000 Q1 2026 shortfall settled at half; leverage of 4.863x (rounded) on 30 September 2026, inside the 5.25x covenant but above the 4.75x distribution test, so $11,879,397 (rounded) stays in the company
The pipeline stakeA recourse rate of $0.2744 per Dth/d under negotiated rates of $0.31 to $0.38; holdco coverage of 3.50x and 2.85x (rounded) against 1.50x; a renewal that cuts yearly firm revenue by $16,060,000
The LNG projectAn estimate raised from $12,400,000,000 to $13,500,000,000; $700,000,000 of new commitments keep cost-to-complete headroom at $100,000,000 instead of minus $600,000,000

The files are provided as they are, without warranty of any kind. The model is illustrative: Brackwater, Harlan Draw, Quarrystone, Corrigan Pass, Marrow Bayou and the other names are fictional, the model is simplified, the rules are general and dated October 2026, and the volumes, fees and figures are the book’s assumptions, not market data or benchmarks. Nothing here is investment, legal, tax, engineering, regulatory or accounting advice.

Also by Julian R. Sterling

More in infrastructure and energy, with free companion files. The full list of titles is on the author page.

Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.