Solar Utility Rate Escalation Calculator

Example Data Table

Sample assumptions and first five projection years.

Formula Used

• Utility rate escalation (compounded): Rate_y = Rate_y-1 × (1 + e_y)
• Utility rate escalation (linear): Rate_y = Rate₀ × (1 + e_y × (y - 1))
• Solar degradation: Solar_y = Solar₀ × (1 - d)^{(y - 1)}
• Bill without solar: Bill_no = Load × Rate
• Onsite offset and export: Onsite = min(Load, Solar × Self%) ; Export = Solar - Onsite
• Export credit: Credit = Export × Rate × Credit%
• Bill with solar: Bill_yes = (Load - Onsite) × Rate - Credit + O&M
• Annual savings: Savings = Bill_no - Bill_yes
• NPV of savings: NPV = Σ Savings_y / (1 + r)^{(y - 1)}

How to Use This Calculator

1. Enter your current retail utility rate and the analysis period.
2. Add annual load and expected year-1 solar production.
3. Set self-consumption and export credit based on your metering rules.
4. Choose fixed escalation, or enter a custom list for each year.
5. Include degradation, O&M, and discount rate for better accuracy.
6. Click Calculate Escalation to see results above the form.
7. Use the export buttons to download the full projection report.

Rate escalation shapes long-term cash flow

Utility prices often rise faster than general inflation, so escalation assumptions strongly affect lifetime savings. For many commercial proformas, planners test 2% to 5% annual increases, then compare how that range changes the year-25 bill. This calculator projects the retail rate year by year and converts it into an annual energy cost baseline. For example, a base rate of 0.18 currency/kWh with 4% escalation doubles to about 0.43 by year 25 under compounding.

Compounded versus linear growth matters

Compounded escalation applies the percentage to last year’s rate, creating an exponential curve that better matches many tariff histories more closely. Linear escalation applies the percentage to the base rate and grows by equal increments. Over 25 years, 3% compounded produces a noticeably higher end rate than 3% linear, which changes both savings and payback narratives. If you enter a custom list, you can mirror step changes after policy revisions, fuel shocks, or new transmission charges.

Solar performance inputs must be realistic

Annual site load and first-year solar production drive how many kilowatt-hours are offset. Typical module degradation falls around 0.3% to 0.8% per year, reducing output gradually. Self-consumption determines onsite offset, while excess generation becomes exported energy. Export credit is modeled as a percentage of the retail rate to reflect net metering or avoided-cost programs.

Operations costs and discounting improve accuracy

Including annual O&M is important for construction budgeting, because cleaning, inverter service, and monitoring add recurring costs. The model can escalate O&M separately, capturing inflationary pressure on labor and parts. Discount rate converts future savings into present value; many feasibility studies use 5% to 10% depending on capital structure and risk.

Use sensitivity checks to strengthen decisions

Run multiple scenarios: low escalation with low export credit, then higher escalation with stronger self-consumption. If results swing widely, the project is sensitive and deserves tariff research or interval load analysis. When the savings remain stable across scenarios, stakeholders gain confidence in bids, financing, and procurement schedules.

FAQs

1) What does “utility rate escalation” mean?

It is the assumed yearly change in the retail electricity price. The calculator applies that change to estimate future rates, bills, and solar savings over the chosen analysis period.

2) Should I choose compounded or linear escalation?

Compounded growth increases the rate by a percentage of the prior year and is common for long-term projections. Linear growth increases by equal increments from the base rate and is more conservative at longer horizons.

3) How should I set export credit percent?

Use 100% for full retail net metering. Use a lower value if exports are paid at avoided cost or a fixed buyback. If you have a known export price, convert it to a percent of the retail rate.

4) Why include solar degradation?

Panels typically produce slightly less each year. Adding degradation makes later-year offsets smaller, which reduces modeled savings and helps avoid overstating long-run performance.

5) What discount rate should I use for NPV?

Use your project’s required return or weighted cost of capital. Many feasibility screens fall between 5% and 10%, but higher rates are sometimes used for uncertain tariffs, contract risk, or small projects.

6) Does this model include demand charges or tiered tariffs?

No. It assumes a blended per-kWh rate. For complex tariffs, calculate an effective average rate from bills or interval data, then run multiple scenarios to bracket realistic outcomes.