Solar ROI Payback Chart

Use this worksheet after the calculator result to record gross cost, user-entered incentives, annual production, self-consumption, export credit, O&M, replacement, simple payback, and cash-flow assumptions.

Open calculator

Quick reference table

A solar ROI payback chart is a calculator-based worksheet. It documents gross cost, user-entered incentives, production, self-consumption, export credit, O&M, replacement, and payback assumptions before finance, utility, or installer quote checks.

Solar ROI payback worksheet

Solar ROI payback worksheet
Item	Record from calculator	Follow-up
System cost	Gross cost and net cost entered	Verify quote scope and exclusions
Production	Annual kWh, self-consumption, and exported kWh	Confirm site, production, and utility assumptions
Savings	Self-consumption, export credit, O&M, first-year net savings	Review utility tariff and usage pattern
Payback	Simple payback, replacement, and cash-flow notes	Run sensitivity before decision

Solar finance review lanes

Solar finance review lanes
Finance lane	Record on worksheet	Why it changes the decision
Export credit	Net metering, buyback, or self-consumption basis	The same kWh can have different bill value
Incentive status	Entered incentive, eligibility note, expiration	Unverified incentives can distort payback
Degradation and maintenance	Annual degradation, O&M, inverter replacement note	Long-term cash flow is not the same as first-year savings
Roof and ownership	Roof age, financing term, transfer or resale note	Payback can be limited by ownership and roof schedule

Formula basis

Simple solar payback = net installed cost / first-year net savings.

Net installed cost is gross installed cost minus incentive values entered by the user.
First-year net savings is self-consumed value plus exported value minus O&M.
Self-consumed value uses the entered retail electricity rate.
Exported value uses the entered export credit and should not automatically equal the retail rate.
Cash-flow assumptions include rate change, degradation, O&M, scheduled replacement, and finance inputs when used.

Worked examples

Residential solar payback recordRecord gross cost, user-entered incentive values, annual kWh, self-consumption, export credit, first-year net savings, simple payback, O&M, replacement, and review owner.

Export-credit sensitivity recordKeep annual production, self-consumed kWh, exported kWh, export credit, incentive note, degradation, maintenance, and conservative payback in one finance review.

Assumptions. Balanced load and line-to-line voltage assumptions behind this chart.

The worksheet is a planning comparison and does not provide tax, legal, financial, or investment advice.
No incentive is assumed by default; entered incentives require current eligibility and placed-in-service verification.
Solar economics depend on installed cost, production, rate design, export credit, maintenance, financing, and policy changes.

Code and standard notes. Planning limits that should be checked before final equipment selection.

Use this chart as a financial comparison worksheet; verify installer quote scope, utility tariff, interconnection rules, current IRS Form 5695 eligibility where relevant, incentive program terms, tax professional input where needed, manufacturer data, and owner finance assumptions before approval.

How to use this chart

1Record cost basisWrite gross cost, user-entered incentives, net installed cost, quote scope, and exclusions.

2Attach production and rate dataDocument annual kWh, self-consumption share, retail rate, export credit, O&M, and scheduled replacement.

3Route finance reviewUse the worksheet to list sensitivity cases, financing notes, and reviewer follow-up.

Worksheet checklist. Record source basis, review gaps, and assumptions before using the chart result.

Capture project inputsRecord system size, cost, user-entered incentives, production, self-consumption, export credit, O&M, degradation, and replacement.
Capture resultsWrite first-year net savings, payback, cash-flow notes, and sensitivity drivers.
Capture reviewList installer, utility, finance, and program-verification items.

Common mistakes to avoid. Review these before turning chart current into an equipment decision.

Treating a user-entered incentive as confirmed without checking program terms.
Comparing payback without roof, utility tariff, and export-credit context.
Reporting one payback value without sensitivity for export credit, degradation, maintenance, and financing assumptions.

Frequently asked questions

These answers explain how to use the chart without turning a quick reference into a final design decision.

Does payback mean the project is automatically worthwhile?

No. Payback is one screening metric. Cash flow, financing, roof condition, utility policy, maintenance, and owner goals also matter.

Why record incentives separately?

Programs and eligibility can change, so the worksheet keeps user-entered incentive values visible for review.