Operating schedules · in 1 model

Regulatory lag: earned against allowed return

Revenue in rates between rate cases, earned ROE, the gap.

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

On this subject: regulatory lag: earned against allowed return.Updated 11 November 2026

Part of project finance and infrastructure models, with the models, labs and guides around it.

What it does

Rates are reset to the revenue requirement only at a rate case. Between cases the revenue in rates moves with sales and with any rider that recovers new capital, while the rate base and costs go on growing, so each year a larger part of the requirement is not yet being collected. That shortfall, after tax, over the equity is the return lost to lag. The earned ROE is net income over equity; its distance from the allowed ROE splits into lag, operating costs against the allowance, interest against the allowed cost of debt and any write-off, and the four parts sum exactly to the gap.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Regulated utility model: electricity network
  • Allowed Revenue, rows 22–26: Sales growth, Capital rider, Revenue in rates, Revenue requirement not yet in rates…
  • Earnings, rows 24–32: Opening equity, Allowed ROE, Earned ROE, Earned less allowed ROE…

What a reviewer looks for

  • Earned ROE set equal to allowed ROE in every year.
  • The whole gap blamed on lag when part of it is an overspend against the allowance.
  • A rate case assumed every year, so the capital plan earns from the day it is spent.

Learn it, then build it

Vocabulary: Regulatory Lag, Allowed Return on Equity (Allowed ROE).

Other operating schedules

Working capital scheduleCapex and depreciation (PP&E roll-forward)Airline capacity and traffic: ASK, RPK and load factorAirline unit revenue and unit cost: RASK and CASKAirline fuel cost and hedgingType curves and production declineOil and gas reserves roll-forwardRealised prices and the field netbackUnits-of-production DD&AContainer fleet: owned, chartered, newbuilds and scrappingMine plan: from ore reserve to payable metalC1 cash cost and all-in sustaining costMine closure and rehabilitation provisionLiftings and freight rate: a liner’s revenueSystem sales and royalties: a franchisor’s units and volumesRestaurant unit economics: restaurant margin and new-unit returnsBunker fuel and the bunker adjustment factorRate base roll-forwardAllowed revenue: the building blocksHeadcount pyramid: hiring, attrition and promotionMobile subscriber roll-forward: gross adds, churn, net addsFibre build: homes passed, penetration and connectionsSpectrum licences: auction payments and amortisationTower site roll-forward: build-to-suit and decommissioningTenancy roll-forward: anchor, colocation and the tenancy ratioTower unit economics: yield on cost by tenantGround lease schedule: rent, escalators and buy-outsUtilisation and realisation: hours to fee revenueProfit per partner: pay, bonus pools and partnership profitStore estate roll-forward and cohortsRetail sales: density, like-for-like and onlineFour-wall EBITDA and new-store paybackStore leases under IFRS 16Driver-based budget: volume, price, heads and cost per headRolling forecast: actuals, reforecast and the outturnPrice-volume-mix: revenue and margin varianceCost variances: rate, volume, heads and cost per headEBITDA bridge: plan to actual and forecastCapacity cohorts: MW, GPUs, utilisation and revenueBacklog roll-forward: contracts to revenue to cashCapital roll-forwardRisk budgetTrading cost baseSponsorship revenue