Operating schedules · in 1 model

Rate base roll-forward

Opening, capital plan, regulatory depreciation, closing.

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

On this subject: rate base roll-forward.Updated 11 November 2026

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

What it does

The base of every regulated utility forecast. The rate base is the regulator’s measure of the capital invested in the network and not yet recovered from customers. It opens at last year’s close, adds the capital spending the regulator allows, deducts regulatory depreciation and closes. Because the allowed return is earned on it, its growth is the company’s earnings growth: a capital plan above depreciation grows the rate base, and spending the regulator disallows never enters it and is written off instead.

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
  • Assumptions, rows 11–14: Rate base, FY0, Capital plan, Regulatory depreciation, % of opening rate base, Share of a capex overrun the regulator disallows
  • Rate Base, rows 6–13: Opening rate base, Capital plan, Overrun on the plan, Capital spending…
  • Rate Base, rows 16–19: Rate base growth, Capital spending / regulatory depreciation, Capital spending disallowed to date, Rate base growth a year, FY0 to FY6

What a reviewer looks for

  • Capital spending added in full when part of it has been disallowed.
  • Depreciation taken from the accounts at a different rate from the one the regulator uses.
  • Growth in the rate base assumed, rather than derived from the capital plan and depreciation.

Learn it, then build it

Vocabulary: Rate Base, CapEx.

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 factorAllowed revenue: the building blocksRegulatory lag: earned against allowed returnHeadcount 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