Electric Utility Tariff Model
Energy Financial Model (Free Excel Download)
Forecast utility earnings from customer connections, tariff structures, demand, generation costs, network capex, regulated returns, debt service, and cash flow.
professionals from Deloitte
Used by professionals from
About this model
Model a regulated electric utility's revenue requirement using a cost-plus regulatory formula: Revenue Requirement = O&M Expense + Book Depreciation + Recoverable Income Tax + Allowed Return on Rate Base. The rate base is the net book value of utility assets (PP&E); the allowed return is the regulatory WACC (typically 50% debt at 5%, 50% equity at 9.5%, implying 7.25% blended WACC). Fuel costs are fully passed through at zero margin.
The model projects 5-year cash flows for a mid-size IOU with $18B opening gross PP&E and $12M annual MWh sales. Capex grows the rate base (growth capex $500M + maintenance capex at 2% of opening net PP&E); depreciation is straight-line over 40 years. Key outputs: allowed net income, earned ROE, and cash flow after debt service and dividend distributions. Utilities typically pay out 60–80% of earnings as dividends, creating structural negative free cash flow that is funded by continuous debt and equity issuance.
Margin profile: EBITDA margin 35–45% (high due to cost-plus regulation), EBIT margin 15–25% (reduced by heavy depreciation), net margin 8–15%. FFO/Debt of 13–18% is the credit rating threshold. This model is foundational for utility valuations and regulatory case analysis; comparable companies (NextEra, Duke, Southern Company) trade at 12–16x P/E due to predictable earnings and dividend growth.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Electric Utility Tariff Model
- Customer classes (residential, commercial, industrial, municipal)
- Consumption assumptions by season and time of use
- Tariff structure with base charges, energy charges, and demand charges
- Tiered and time-of-use rates with peak and off-peak differentiation
- Rate change scenarios and revenue impact modeling
- Revenue by class and total utility revenue projection
Inside the Electric Utility Tariff Model: How Regulated Rates Drive Financials
This electric utility tariff model simulates a regulated investor-owned utility over a five-year horizon. It links capex, rate base, revenue requirement, and financial statements to show how cost-of-service regulation drives earnings and credit metrics.
Understand the key operating drivers, calculation flow, and practical applications for rate case preparation and utility valuation.
Key Operating Drivers and Regulatory Framework
The model reflects the cost-of-service paradigm where revenue is set to recover operating expenses, depreciation, taxes, and a regulated return on rate base. Revenue requirement is computed from O&M, book depreciation, income tax gross-up, and return on average net rate base.
- Approved base revenue resets at rate case years and escalates in between. Fuel revenue and cost are passed through at zero margin.
- Key levers include growth capex, O&M escalation, ROE, equity thickness, and cost of debt.
Calculation Flow: From Capex to Financial Statements
Growth and maintenance capex feed into CWIP and net PP&E, with AFUDC accruing when CWIP is excluded from rate base. The rate base rolls forward with capex, depreciation, and deferred tax movements.
- Revenue requirement is built from O&M, depreciation, taxes, and allowed return, then approved base revenue is determined via rate-case timing. This revenue, plus fuel pass-through, drives the income statement.
- Cash flow incorporates net income, non-cash items like AFUDC and deferred taxes, capex, and financing activities. The balance sheet balances through explicit debt and equity issuance, with regulatory assets and liabilities rolling forward.
Outputs: Financial Statements, Per-Share Metrics, and Credit Ratios
The model generates a full three-statement set: income statement, balance sheet, and cash flow, each for Years 1-5. A per-share block computes EPS, DPS, payout ratio, and DPS coverage based on share count roll-forward.
- Credit metrics include FFO/Debt, Debt/EBITDA, RCF/Debt, EBITDA/Interest, and FFO/Interest, each compared to thresholds. A checks sheet monitors 14 validations including balance sheet integrity, fuel parity, and earned ROE versus allowed.
- These outputs support assessment of dividend sustainability and investment-grade credit compliance.
Practical Use: Rate Case Preparation, DSM Analysis, and Valuation
For rate case preparation, the model quantifies the revenue requirement and the lag between approved and test-year rates, highlighting regulatory risk.
- It also shows how changes in ROE, equity thickness, or capex impact earned returns and credit metrics.
- For DSM impact analysis, adjusting annual MWh and heat rate flows through fuel revenue and cost with zero margin, affecting overall profitability.
- For utility valuation, the model projects free cash flow, debt and equity issuance needs, and credit ratios, providing a basis for estimating equity value and assessing financial health under different regulatory outcomes.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a typical utility tariff structure?+
Most utilities have fixed customer charges per month, energy charges per kilowatt-hour, and demand charges per kilowatt of peak usage for commercial and industrial customers. Some use tiered rates that increase at higher volumes.
How do you model peak and off-peak rates?+
Categorize consumption by time period (peak typically 2-8pm, off-peak all other hours) and apply different rates to each. Industrial customers often pay demand charges based on measured peak kilowatt usage.
What revenue growth should I project for a utility?+
Utilities typically see 1-3% volume growth from population and economic activity, plus inflation-linked rate increases allowed by regulators. Model volume growth and rate changes separately.
What is a demand-side management (DSM) impact?+
Energy efficiency programs, distributed solar adoption, and customer defection reduce kWh sales, which can shrink revenue even if the customer base grows. The model shows the net revenue effect of DSM scenarios.
Who uses electric utility tariff models?+
Utility regulators reviewing rate cases, utility investors modeling revenue, energy consultants designing tariff structures, and rate design specialists supporting regulatory proceedings.
Have more financial modelling questions? Contact us
Related templates
Renewable Energy Project Economics Model
Solar, wind, or hydro project generation, power purchase agreements, operating costs, and project IRR.
LNG Terminal Model
Project finance model for liquefied natural gas import or export terminals with throughput and storage economics.
Water Utility Financial Model
Model water utility revenue, infrastructure investment, and sustainability under rate regulation.
Commodity Hedging Model
Structure and monitor hedges for commodity price exposure with effectiveness metrics.
