# Electric Utility Tariff Model Build a utility tariff model with multiple customer classes, tiered pricing, peak and off-peak rates, and revenue projections without manually summing customer class revenues. Supports rate case preparation, DSM impact analysis, and utility valuation in one workbook. - Canonical: https://finamodel.com/templates/utility-model - Excel download: https://finamodel.com/templates/utility.xlsx - Category: Energy - Model type: Project finance - Difficulty: Intermediate - Audiences: Investors & analysts, Public sector, Utility regulators, Utility investors, Energy consultants, Rate design specialists - Tags: tariff, rate-design, consumption, customer-class, revenue ## Overview 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's included - 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 - Consumption assumptions (kWh per customer by season and time) - Tiered or time-of-use rates with peak/off-peak differentiation - 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. ## Customer class segmentation Residential, commercial, and industrial customers are modeled separately with distinct consumption patterns and rate sensitivities, because blending them obscures cross-subsidy and rate design effects. ## Tiered and time-of-use rate structures Complex tariff structures with multiple rate tiers, peak and off-peak periods, and seasonal cost variation are modeled to reflect actual regulatory rate design. ## Rate case revenue requirement Proposed rate increases and tariff changes are modeled to show their revenue impact by customer class and total utility, supporting regulatory filings and investor analysis. ## Customer class segmentation Residential, commercial, and industrial customers are modeled separately with distinct consumption patterns and rate sensitivities, because blending them obscures cross-subsidy and rate design effects. ## Tiered and time-of-use rate structures Complex tariff structures with multiple rate tiers, peak and off-peak periods, and seasonal cost variation are modeled to reflect actual regulatory rate design. ## Rate case revenue requirement Proposed rate increases and tariff changes are modeled to show their revenue impact by customer class and total utility, supporting regulatory filings and investor analysis. ## Features - **Tiered and time-of-use rate modeling:** Model complex tariff structures with multiple rate tiers, peak/off-peak periods, and seasonal variation in costs and prices. - **Customer class segmentation:** Track residential, commercial, and industrial customers separately with distinct consumption patterns and rate sensitivities. - **Rate case analysis:** Model the revenue impact of proposed rate increases or tariff changes and show the effect on customer bills by class. ## Use cases - **Rate case preparation:** Model revenue requirements under cost-of-service regulation and design tariff structures to meet revenue targets while balancing customer fairness. - **Demand-side management (DSM) impact:** Model the revenue impact of energy efficiency programs, distributed solar, or customer defection scenarios. - **Utility valuation and M&A:** Project utility revenue and EBITDA under alternative rate scenarios to support acquisition pricing and debt capacity analysis. ## Frequently asked questions ### 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. ## Related templates - [Renewable Energy Project Economics Model](https://finamodel.com/templates/renewable-energy-model) - [LNG Terminal Model](https://finamodel.com/templates/lng-terminal-model) - [Water Utility Financial Model](https://finamodel.com/templates/water-utility-model)