Companion files · The Private Markets Career Guides

The Regulated Utility Investor

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 six workbooks, the toolkit and the read-me, in one archive247 KB

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.

The files

Three numbers to reproduce first

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 return8.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.