Operating schedules · in 1 model

Allowed revenue: the building blocks

Return on rate base, depreciation, opex and tax allowances.

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

On this subject: allowed revenue: the building blocks.Updated 11 November 2026

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

What it does

A regulator does not set a price; it sets the revenue the network may collect, as the sum of what it costs to run and finance. The return on equity is the rate base times the equity layer times the allowed ROE; the return on debt is the rest of the rate base at the allowed cost of debt; depreciation returns the capital itself; the operating cost allowance covers running the network; and the tax allowance grosses up the equity return so that shareholders keep the allowed ROE after tax. Costs the company cannot control, such as purchased power, are passed through on top at cost and earn nothing.

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 17–23: Rate case year, Allowed return on equity, Equity layer, Allowed cost of debt…
  • Allowed Revenue, rows 6–9: Opening rate base, Rate case year, Allowed ROE in force, Operating cost allowance in force, % of base
  • Allowed Revenue, rows 12–19: Return on equity, Return on debt, Regulatory depreciation, Operating cost allowance…
  • Allowed Revenue, rows 29–31: Pass-through costs recovered, Revenue, Check: rate case flag not 0 or 1, or FY1 not a rate case year

What a reviewer looks for

  • The allowed ROE applied to the whole rate base rather than to the equity layer.
  • No tax allowance, so the return shareholders keep is the allowed ROE less tax.
  • Pass-through costs given a margin.

Learn it, then build it

Vocabulary: Allowed Return on Equity (Allowed ROE), Rate Base, Cost of Debt.

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-forwardRegulatory 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