Companion files · The Private Markets Career Guides
The Practitioner's Guide to Electric and Gas Utilities, from Rate Base and the Allowed Return to Rate Cases, Regulatory Lag, Capital Plans, Credit and Valuation.
These are the companion files of the book. Six workbooks follow Halvenmoor Electric, the fictional utility of the case, and the 19.9 percent stake that Wexbridge Infrastructure Partners studies, from the rate base to the price: the rate base roll-forward, the revenue requirement, the earned ROE and lag, holding and credit, the stake valuation and the storm securitization. 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 3 and 11
The capital plan by category, plant placed in service, depreciation, deferred taxes, CWIP and AFUDC, and rate base from $8,549.9 million at the end of 2025 to $13,691.0 million at the end of 2031. Sheets: Inputs, Rate base, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: no exercise.
Download workbook 124 KBChapters 4, 5 and 6
The 2026 test year, requested against authorized, line by line ($2,693.6 million asked, $2,581.0 million authorized), the bridge between the two, the pre-tax return and the later rate cases of the plan. Sheets: Inputs, Rate base, Revenue requirement, Earned ROE, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: exercises 1, 2 and 3.
Download workbook 230 KBChapters 7, 8 and 9
Revenue between rate cases, the transmission rider, regulated net income and the earned ROE year by year (8.51 percent in 2026 against 9.70 percent authorized), with the holding and the stake so that a change reaches earnings per share and the fund’s return. Sheets: Inputs, Rate base, Revenue requirement, Earned ROE, Holding, Stake, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: exercises 4, 5 and 6.
Download workbook 342 KBChapters 10 and 12
Halvenmoor Gas, the holding’s debt and earnings per share, FFO to debt at the utility and on a consolidated basis (10.4 percent in 2026), and the holding without the sale beside it. Sheets: Inputs, Rate base, Revenue requirement, Earned ROE, Holding, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: exercise 10.
Download workbook 446 KBChapters 14, 15 and 16
Wexbridge’s cash flows, the multiples the price implies, the internal rate of return (8.85 percent against a hurdle of 8.00 percent), the value at the hurdle, and the outputs to compare when an input changes. Sheets: Inputs, Rate base, Revenue requirement, Earned ROE, Holding, Stake, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: exercises 7 and 8.
Download workbook 539 KBChapter 13
The storm recovery bonds ($450.0 million, level payments of $43.06 million a year, about $3.12 per customer per month) against recovery through rate base, and the storm in the 2025 credit metrics. Sheets: Inputs, Rate base, Revenue requirement, Earned ROE, Storm, then Checks, which puts the figures printed in the book beside the cells that compute them. Appendix A: exercise 9.
Download workbook 631 KBAppendix B
Reading a rate case order; Building the rate base roll-forward; Earned against allowed; Reading a capital plan; Holding and operating company credit; Event risk; Diligence on a minority stake; The annual review.
Download the toolkit40 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| The revenue requirement | $1,050.0 million + $477.6 million + $280.0 million + $631.6 million + $141.8 million = $2,581.0 million, authorized on 14 April 2026 |
| The earned return | 8.51 percent earned in 2026 against 9.70 percent authorized: four months at the old rates and a rate base larger than the one in rates |
| The stake | $1,520.0 million for 19.9 percent: an internal rate of return of 8.85 percent against a hurdle of 8.00 percent |
The files are provided as they are, without warranty of any kind. The model is illustrative: Wexbridge Infrastructure Partners, Halvenmoor Electric Company, Halvenmoor Energy Holdings, Halvenmoor Gas and their state are fictional, and the balances, plans, rates of return, prices, multiples and thresholds are the book’s teaching assumptions, not market terms, averages or the decision of any real commission. The years 2026 to 2031 are projections of the case model.