Solar quote worksheet
Hypothetical estimates only. Enter your quote and utility terms; the worksheet cannot confirm eligibility.
← Return to Utah analysis, sources and household comparisonsSolar cash-flow worksheet
Compare assumed cash flows, not an address-specific forecast. No tariff, roof or incentive eligibility is looked up. Your worksheet entries are calculated in this browser; the worksheet does not send them anywhere or save them between visits. The site also loads Google advertising code; the privacy page explains what that code may collect and your choices.
Starting retail rate: 12.22¢/kWh — Calendar year 2024 annual average (Utah), from EIA Table 2.10. It is not your current tariff. All cost, export, usage, escalation and incentive entries are assumptions.
Starting export credit: 4.033¢/kWh, from the Utah PSC approval letter, Docket 26-035-T03. Rocky Mountain Power Schedule 137 credits exports at 4.033¢/kWh in October–May and 4.855¢ in June–September, effective March 1, 2026. The lower rate is applied to every exported kWh here; it is not seasonally weighted. Schedule 137 is a Rocky Mountain Power tariff for customers interconnected with its system; if another utility, such as a municipal utility or cooperative, serves the home, ask that utility for its own export terms. The 50% used on site is an assumption. Import starts at the EIA state average shown above; the household cases on this site's Utah page use an assumed round 12¢ import price instead, so the same winter-export case shows a slightly longer break-even there than the result below.
With no incentives or recurring costs, fixed cost/W and proportional generation mean that increasing size scales cost and savings equally: payback years cancel out. Unedited price and production follow that rule here. Once you edit either, it stays fixed when size changes; update it deliberately. Different cash prices, shading/production and export shares can change payback.
Optional assumed cash incentives — zero by default
No federal, state or utility incentive is inferred. Check eligibility and actual receipt timing. Recurring and delayed incentives arrive at year end; do not enter the same benefit in multiple fields. Operating cash is approximated uniformly within each year.
Starting scenario from the sourced export credit — nothing edited yet; modelled, not a quote
Every field is still at its starting value. Exports start at 4.033¢/kWh from the Utah PSC approval letter, Docket 26-035-T03 with an assumed 50% used on site, so this is not the retail-value benchmark; the separate box below values every kWh at the retail price. Edit any field to model your own assumptions.
- Modelled installed cash price
- $22,400
- Modelled initial outlay after upfront rebate
- $22,400
- Modelled year-one net cash, including receipts/costs
- $871
- Modelled first cash-flow break-even
- 20.1 years
- Modelled 25-year net cash after initial outlay
- $7,304
- Modelled production in year one
- 10,722 kWh
Modelled year-one energy value before costs/incentives: $871. The same production valued entirely at the import price above would be a modelled $1,310.
No break-even inside 25 years means the model never crosses within its horizon; it does not predict a later crossing. This is undiscounted cash flow, not investment return. A first crossing can reverse if later operating costs exceed cash benefits. Financing, taxes, changing export rules, time-of-use settlement, credit expiry and battery dispatch are not simulated.
How much does using your own solar matter?
This comparison changes only the fraction of production used on site. The worksheet's cash price, production, import and export prices, costs, degradation and incentives stay fixed. The rows are hypothetical shares, not predictions of your household usage or battery performance.
| Used on site | Modelled year-one net cash | Modelled first break-even |
|---|---|---|
| 0% | $432 | no break-even inside 25 years |
| 25% | $652 | no break-even inside 25 years |
| 50% (starting value) | $871 | 20.1 years |
| 75% | $1,091 | 16.8 years |
| 100% | $1,310 | 14.4 years |
Turn the comparison into a quote question
Ask for annual solar generation and annual exports over the same period. For a system without storage, (generation − exports) ÷ generation × 100 gives the share retained on site, provided both readings cover the same system boundary. Do not divide by household consumption: that answers a different question. With storage, ask how charging losses, grid charging and changes in stored energy were treated; this calculator does not simulate them.
For a worked example that values the same production two ways, see the net-metering guide.
If the rows match, check whether import and export prices are equal: changing the split then cannot change energy value in this model. If higher self-use reduces the result, check whether you entered an export price above the import price. Neither pattern alone proves the inputs are wrong. A time-of-use tariff or expiring credits needs a more detailed settlement calculation.
Work through the utility-bill auditAssumed price-escalation sensitivity
Same worksheet inputs, degradation and nominal fixed costs; only import/export price escalation changes. These are scenarios, not forecasts.
- 0%/year: no break-even inside 25 years
- 3%/year: 20.1 years
- 6%/year: 16.5 years
Separate common retail-value benchmark
This comparison uses 7 kW, assumed $3.20/W, production from the state's one-location NSRDB sunlight input and 12.22¢/kWh (Calendar year 2024 annual average) for every kWh. It ignores your entered cash price, production, tariff, costs and incentives; assumes 0.5% degradation and 3% escalation. It is not an address forecast.
- Benchmark assumed cash price
- $22,400
- Benchmark modelled year-one value
- $1,310
- Benchmark modelled break-even
- 14.4 years
Reproduce the 25-year modelled cash flows for the result above
Annual cash = degraded production × weighted import/export price × price-escalation factor − annual fixed cost + eligible year-end receipts. Cumulative cash starts at negative initial outlay. Incentives after year 25 are excluded.
Use your utility tariff and a site-specific production assessment to refine inputs. Methodology and limitations.