Companion files · The Private Markets Career Guides
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 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.
Chapters 2 to 16 and the conclusion
One Inputs sheet holds every case assumption: Harlan Draw’s fees, costs, volumes, MVC and term loan, the shortfall invoices, Corrigan Pass’s shippers, notes, cost-of-service items and renewal, the holdco loan, Marrow Bayou’s budget, commitments, overrun and draws, and the projection terms. One sheet per question, and a Checks sheet that puts the figures printed in the book, and every dated test of the case, beside the cells that compute them.
Download the workbook67 KBAppendix 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 and quarterly monitoring.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me4 KB| The gathering system | A $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 stake | A 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 project | An 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.
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.