Infrastructure and project financeAdvanced · ~45 minWorking draft · 10 sheets · 668 formulas

Regulated utility model: electricity network

Rate base, allowed revenue, regulatory lag, FFO / debt. Build a regulated network from its rate base up: the roll-forward with the capital plan and regulatory depreciation, the revenue requirement as its building blocks, revenue in rates between rate cases and the lag that opens against the requirement, actual costs against their allowances, debt and equity issued to hold the equity layer, FFO / debt against a rating threshold, EPS and a dividend grown at a set rate, then value from discounted dividends and as a premium to the rate base.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: regulated utility model: electricity network.Updated 11 November 2026

Who builds it, and for whatThe model an equity research analyst covering the listed electricity, gas and water networks keeps for each of them, and that an infrastructure fund or a power and utilities banker rebuilds before bidding for one. The analyst uses it to say what the next rate case does to earnings and whether the dividend and the capital plan can both be funded without more new shares than the market expects; the buyer reads the same lines to decide what premium to the rate base the allowed return can support, and the rating agency’s FFO / debt to see how much debt the price can carry.

Every sheet below, in your browser, with its outputs and checks

Starter workbook free with an account. Worked model: one a month with Plus, every one with Pro. Downloads

Inspect the workbook
All checks read zero100%
Every value, every sheet, as the workbook holds it.
ABCDEFGHIJK
1Assumptions
2$m unless stated. Per-share figures in dollars. All figures are illustrative.
4YearUnitFY0FY1FY2FY3FY4FY5FY6Notes
5Year number#0123456FY0 = 0. Drives cost inflation, the dividend and discounting.
7Scenario
8Scenario#11 = base, 2 = adverse rate case, 3 = capex overrun. Selects a row of each case on the Scenarios sheet, from FY2.
10Rate base and capital plan
11Rate base, FY0$m12,000.0The regulator’s value of the network: capital invested and not yet recovered through depreciation.
12Capital plan$m1,000.01,050.01,100.01,150.01,200.01,250.0Replacement, reinforcement and new connections, as filed with the regulator.
13Regulatory depreciation, % of opening rate base%3.3%The return of capital: about a thirty-year average life.
14Share of a capex overrun the regulator disallows%50.0%Spending above the plan found imprudent: kept out of the rate base and written off.
16Rate cases and the allowed return
17Rate case yearflag1001001 = rates are reset to the revenue requirement in this year. FY1 must be a rate case year.
18Allowed return on equity%9.6%After tax, on the equity layer. The scenario changes it at a rate case.
19Equity layer%48.0%The share of the rate base the regulator treats as financed by equity. The company finances itself to match.
20Allowed cost of debt%5.0%On the debt layer, before tax.
21Tax rate%25.0%
22Sales growth between rate cases%1.0%New connections and demand: revenue in rates grows with it until the next case.
23Share of rate base growth recovered through a capital rider%40.0%Between cases, the return and depreciation on this share of the growth in the rate base are added to rates each year.
25Operating costs and pass-through
26Operating cost allowance, FY0 prices$m700.0What the regulator allows for operations, maintenance and overhead.
27Actual operating costs, FY0 prices$m685.0Below the allowance: the company keeps the difference.
28Cost inflation%2.5%Annual, on the allowance and on actual costs.
29Pass-through costs, FY0$m900.0Purchased power and transmission charges, recovered from customers at cost.
30Pass-through cost growth%3.0%
32Financing and credit
33Interest rate on debt%4.9%On opening debt. Below the allowed cost of debt, the difference is kept.
34FFO / debt threshold for the rating%13.0%Below it the rating agency would consider a downgrade.
36Shares and dividends
37Shares outstanding, FY0m shares400.0
38Dividend per share, FY0$ per share0.88
39Dividend per share growth%4.0%The dividend is grown at a set rate; the payout ratio is the result.
41Valuation
42Cost of equity%8.0%
43Long-run rate base growth%4.0%After FY6 the rate base and equity grow at this rate; the dividend per share resets to the payout the earned ROE and this growth allow, (earned ROE - growth) x book value per share.
44Sector multiple, enterprise value / rate basex1.20Illustrative input for the cross-check.

Select a cell to see its row, its schedule and the type of cell. Font colours: blue for inputs, black for formulas, green for links to other sheets. Scroll sideways to see every period.

Download

Regulated utility model: electricity network: the workbook

An Excel workbook with working formulas, no macros and no external links: the same model you can work with on this page.

  1. Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
  2. Free accountWork with every model online: change the inputs, switch the case, see every formula. And every starter workbook, with its key schedules left blank to build.
  3. L3VLUP Plus$4.99/monthEverything in Free, and one worked model each billing month as an Excel file: every schedule built, formulas live, checks at zero, yours to keep.
  4. L3VLUP Pro$25/monthEverything in Plus, every worked model in the library, and the Pro applications.
The worked model
10 sheets and 668 live formulas, all 10 schedules built and linked, every check reading zero. Change an input in Excel and the whole model moves.
The starter
The same inputs and layout with the rate base roll-forward left blank for you to build, each blank cell marked. The worked model is its answer.

What the base case says

Equity value per share ($)
19.62
Premium to the rate base
17.4%
Enterprise value
$14,086.5m
Rate base, FY6
$16,055.7m
Rate base growth a year
5.0%
Revenue requirement, FY1
$2,162.8m
Earned ROE, FY1
9.9%
Earned ROE, FY3
8.9%
Earned ROE, FY6
8.9%
EPS, FY1 ($)
1.42
EPS, FY6 ($)
1.53
EPS growth a year, FY1 to FY4
3.4%
Dividend payout, FY6
72.9%
FFO / debt, lowest year
13.9%
Equity issued, FY1 to FY6
$791.3m

Read from the workbook as served, every input at its default. Periods: FY0, FY1, FY2, FY3, FY4, FY5, FY6. The figures are invented and move with whatever you type in.

What this model is

A six-year model (FY1 to FY6, from an FY0 opening balance sheet) of an invented regulated electricity network with a $12.0 billion rate base, through two rate cases.

The rate base rolls forward with the capital the regulator allows, less regulatory depreciation. The revenue requirement is built from it: a return on the equity layer at the allowed ROE, a return on the debt layer at the allowed cost of debt, depreciation, an operating cost allowance and a tax allowance.

Rates are reset to the requirement only at a rate case. Between cases revenue grows with sales and a capital rider while the rate base and costs grow faster, so the earned ROE falls short of the allowed ROE. The Earnings sheet splits that gap into regulatory lag, operating costs against the allowance, interest against the allowed cost of debt and write-offs.

Debt and equity are issued each year to hold the equity layer, so the plan shows what the capital programme costs shareholders in new shares, sold at the price each scenario’s own valuation puts on them. FFO / debt is read against a rating threshold, the dividend per share grows at a set rate with the payout as the result, and EPS follows.

Value is read two ways: dividends discounted with a terminal value from the earned ROE and long-run growth, and the premium to the rate base that implies beside a sector multiple. Three scenarios (base, an adverse rate case and a capex overrun partly disallowed) and two board-style sensitivity tables.

Seats: Equity research and hedge funds, Investment banking, Private equity.

Careers that do this work: infrastructure & real assets, debt capital markets, private credit.

How the schedules connect

Every row in the workbook is tagged with the schedule it belongs to; the inspector above shows the tag when you click a row. These are the schedules this model is made of and where each one lives.

What you should be able to explain

  • Why a regulated network’s profit is the equity layer of its rate base times the allowed ROE, and why growing the rate base is how it grows earnings.
  • How the revenue requirement is built from a return on equity, a return on debt, depreciation, an operating cost allowance and a tax allowance.
  • What regulatory lag is: why the earned ROE falls short of the allowed ROE between rate cases, and what a capital rider does to the gap.
  • Why a capital plan larger than depreciation needs new equity as well as debt, and what holding the equity layer costs in new shares.
  • Why rating agencies read FFO / debt for a utility, and how a cut in the allowed ROE reaches it.
  • When a premium to the rate base is justified: only where the earned ROE is above the cost of equity, and more so the faster the rate base grows.

What a reviewer looks for

  • Revenue grown at a rate rather than built from the rate base, so the capital plan and the allowed return cannot move it.
  • Rates reset to the full revenue requirement every year, which assumes away regulatory lag and overstates the earned ROE.
  • Pass-through costs left inside the margin, so a rise in purchased power appears to raise profit.
  • Capital spending funded with debt alone, so the equity layer thins, FFO / debt falls and no new shares are ever issued.
  • Disallowed spending left in the rate base, earning a return the regulator has refused.
  • New shares priced at one fixed multiple of book value in every scenario, so in a bad case new investors pay more than the model says the stock is worth and existing holders look better off than they are.
  • A terminal value that grows the rate base for ever without asking whether the return on it covers the cost of equity.

Conventions this workbook uses

Stated on the cover sheet too. A model is only as trustworthy as the decisions it tells you it made.

  • Annual periods. FY0 is the opening balance sheet; the valuation date is the end of FY0. Rate cases fall in FY1 and FY4. Every scenario changes FY2 onwards only, apart from the price of the shares issued at the end of FY1, which is set by the case’s own valuation.
  • Rate base = opening + capital spending allowed - regulatory depreciation, which is a rate on the opening balance. Book depreciation equals regulatory depreciation, and deferred tax and working capital are left out, so net assets equal the rate base.
  • The revenue requirement is set on the opening rate base: equity layer x allowed ROE, debt layer x allowed cost of debt, depreciation, the operating cost allowance and a tax allowance of the equity return x tax rate / (1 - tax rate).
  • In a rate case year revenue in rates equals the revenue requirement. Otherwise it is last year’s revenue plus sales growth plus the capital rider, which recovers the return, tax and depreciation on a share of the growth in the rate base. The allowed ROE and the operating cost allowance change only at a rate case.
  • Pass-through costs are billed at cost in the year they arise. Actual operating costs are compared with the allowance for the year, and the difference stays with shareholders.
  • Half of an overrun on the capital plan, unless changed, is disallowed: it never enters the rate base and is written off, deductible for tax, in the year it is spent.
  • Debt is brought to the debt layer of the closing rate base each year and equity issued for the rest of the funding need, so book equity equals the equity layer of the rate base. Interest is on opening debt.
  • New shares are issued at the end of the year, so the year’s EPS and dividend are on opening shares. They are priced at opening book value per share x the selected scenario’s own terminal price / book, the multiple the valuation capitalises FY6 book at, so new investors pay what the case says the stock is worth. The dividend per share grows at a set rate.
  • FFO is net income plus depreciation and write-offs; FFO / debt is on closing debt. Earned ROE is net income over opening equity.
  • Value per share discounts FY1 to FY6 dividends at the cost of equity and adds FY6 book value per share at (earned ROE - growth) / (cost of equity - growth), the earned ROE being the FY4 to FY6 average.

What this model does not cover

Where its answer stops, so you know what to add before relying on it.

  • Generation and retail supply, which carry price and volume risk. This is a network: the energy itself is passed through at cost.
  • Price controls that index the asset base to inflation and allow a real return, as in Great Britain and Australia. The rate base here is at historic cost and the allowed return is nominal.
  • Deferred tax, working capital and construction work in progress. Net assets equal the rate base, and capital spending enters it in the year it is spent.
  • Sharing mechanisms and incentives. The company keeps all of a saving against the operating cost allowance, and there are no performance rewards or penalties.
  • The timing of pass-through recovery, weather and customer numbers. Pass-through costs are recovered in the year they arise.
  • A holding company with debt of its own or businesses outside the regulated network.
  • A real company. National Grid and Consolidated Edison are candidates for a case built from their reports; this model uses invented figures.

Build it yourself

The starter workbook

The Rate Base sheet has been cleared: the opening rate base, the capital plan and any overrun on it in the selected scenario, the part the regulator disallows, additions, regulatory depreciation on the opening balance, the closing rate base and its growth. Rebuild it from the Assumptions and Scenarios sheets, then switch to the capex overrun and watch the disallowed spending miss the rate base and reach net income as a write-off.

Blanks: Rate base roll-forward. Download it beside the worked model.

The path around this model

Understand it, drill it, read the build, then apply it to a real company.

Vocabulary: Rate Base, Allowed Return on Equity (Allowed ROE), Regulatory Lag, Cost of Equity, Cost of Debt, Credit Rating, Dividend Yield, Terminal Growth Rate, CapEx.

Questions about this model

How does a regulated utility make its money?

It earns a return on its rate base, set by the regulator. In FY1 the network’s revenue requirement is $2,162.8 million on a $12,000.0 million rate base: $553.0 million of return on the 48% equity layer at the 9.6% allowed ROE, $312.0 million of return on debt, $396.0 million of depreciation, a $717.5 million operating cost allowance and a $184.3 million tax allowance. Purchased power and transmission of $927.0 million are passed through at cost on top. Net income is $569.2 million, or $1.42 a share, and the earned ROE of 9.9% sits above the allowed 9.6% because operating costs and interest come in under their allowances.

What is regulatory lag?

Rates are reset to the revenue requirement only at a rate case, here in FY1 and FY4. In between, revenue grows with sales and a capital rider while the rate base grows 5.0% a year and costs rise with inflation. By FY3 $82.0 million of the revenue requirement is not yet in rates, which costs 1.0 percentage points of return, and the earned ROE has fallen from 9.9% to 8.9%. The FY4 rate case restores it to 9.9%, and EPS steps up from $1.38 to $1.57.

What happens in the adverse rate case and the capex overrun?

In the adverse case the FY4 rate case cuts the allowed ROE to 8.6% and the operating cost allowance by 3%. The earned ROE falls to 7.7% by FY6 and EPS to $1.26 against a dividend still growing 4% a year, so the payout reaches 88.3%; FFO / debt falls to 12.8%, below the 13.0% threshold, and the value per share falls from $19.62 to $15.44. New shares are sold at the price each case’s own valuation puts on them, 1.04 times book value in the adverse case against 1.35 times in the base, so the adverse case issues 67.3 million new shares for $1,097.5 million of equity, against 37.0 million for $791.3 million. In the overrun, capital spending runs 30% over plan in FY2 and FY3 and the regulator disallows half of it: $322.5 million is written off, the earned ROE falls to 6.9% in FY3, and equity issued over the six years rises from $791.3 million to $1,200.4 million.

How is a regulated utility valued here?

Two ways. The dividends for FY1 to FY6 are discounted at an 8.0% cost of equity, and FY6 book value per share is capitalised at 1.35 times, the multiple that a 9.4% earned ROE and 4.0% growth justify: $19.62 a share. New shares are issued at the same multiple of book value, so a new investor pays what the model says the stock is worth. With $6,240.0 million of debt that is an enterprise value of $14,086.5 million, or 1.17 times the rate base, a 17.4% premium. The cross-check applies a sector multiple of 1.20 times the rate base, which gives $20.40 a share.

Related models

Questions about this model

Discussions open here soon.

All discussions

Share your result 📊

𝕏in💬🤖

Instagram and TikTok have no desktop share link, so copy the caption and paste it into the app.