# The Regulated Utility Investor: companion files

Julian R. Sterling

## What is here

- RUI_1_Rate_Base_Roll_Forward.xlsx (Chapters 3 and 11; Rate base roll-forward workbook of Appendix A; no exercise): sheets Inputs, Rate base, then Checks. 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.
- RUI_2_Revenue_Requirement.xlsx (Chapters 4, 5 and 6; Revenue requirement workbook of Appendix A; exercises 1, 2 and 3): sheets Inputs, Rate base, Revenue requirement, Earned ROE, then Checks. 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.
- RUI_3_Earned_ROE_and_Lag.xlsx (Chapters 7, 8 and 9; Earned ROE and lag workbook of Appendix A; exercises 4, 5 and 6): sheets Inputs, Rate base, Revenue requirement, Earned ROE, Holding, Stake, then Checks. 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.
- RUI_4_Holding_and_Credit.xlsx (Chapters 10 and 12; Holding and credit workbook of Appendix A; exercise 10): sheets Inputs, Rate base, Revenue requirement, Earned ROE, Holding, then Checks. 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.
- RUI_5_Stake_Valuation.xlsx (Chapters 14, 15 and 16; Stake valuation workbook of Appendix A; exercises 7 and 8): sheets Inputs, Rate base, Revenue requirement, Earned ROE, Holding, Stake, then Checks. 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.
- RUI_6_Storm_Securitization.xlsx (Chapter 13; Storm securitization workbook of Appendix A; exercise 9): sheets Inputs, Rate base, Revenue requirement, Earned ROE, Storm, then Checks. 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.
- RUI_Utility_Investor_Checklists.docx: the 8 check-lists of Appendix B, editable (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).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every assumption of the case, followed by an empty yellow column for yours and a Used column: the case's figures in blue on a light blue background, your figure in the yellow column when you type one. The Used column takes your figure when there is one and the case figure otherwise, and every other sheet reads the Used column. Black type is a formula, green type a link to another sheet. Each workbook carries every calculation sheet its outputs need, so it works on its own; the sheets are the same in every file. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow column is empty. Each of the 10 exercises of Appendix A is done in the workbook listed above: change the one input the exercise names, read the answer, then clear the cell.

Two inputs to try first:

1. In RUI_2_Revenue_Requirement.xlsx, on Inputs, type 9.20 percent as the authorized ROE: the revenue requirement and the increase granted fall at once, and the earned ROE of 2026 with them.
2. In RUI_3_Earned_ROE_and_Lag.xlsx, on Inputs, type 0 for the transmission rider: the earned ROE falls in the years between rate cases, and Wexbridge's internal rate of return on the Stake sheet with it.

To use a workbook on a real utility, replace every input with figures from that company's own filings and the commission's orders, rebuild the base case until it matches what the company reports, and only then make your own changes. Take questions of law, tax and accounting to counsel, regulatory counsel and the tax adviser. The workbooks are separate files with no link between them.

## A word of caution

Wexbridge Infrastructure Partners, Halvenmoor Electric Company, Halvenmoor Energy Holdings and Halvenmoor Gas are fictional, and their state is not named. Balances, plans, rates of return, costs, tax rates, prices, multiples and thresholds are teaching assumptions, not market norms, averages or regulatory requirements; the credit thresholds are the case fund's own tests, not those of any rating agency. The years 2026 to 2031 are projections of the case model, never a forecast of what a commission will decide. No real utility, fund, commission or rating agency is described. Nothing here is investment, legal, tax or accounting advice.
