WorksheetPlanning limits applyLast reviewed May 7, 2026

Electrical reference chart

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-led planning worksheet. It documents gross cost, user-entered incentives, production, self-consumption, export credit, O&M, replacement, and payback assumptions before finance, utility, or installer review.

Solar ROI payback worksheet

Solar ROI payback worksheet
ItemRecord from calculatorFollow-up
System costGross cost and net cost enteredVerify quote scope and exclusions
ProductionAnnual kWh, self-consumption, and exported kWhConfirm site, production, and utility assumptions
SavingsSelf-consumption, export credit, O&M, first-year net savingsReview utility tariff and usage pattern
PaybackSimple payback, replacement, and cash-flow notesRun sensitivity before decision

Solar finance review lanes

Solar finance review lanes
Finance laneRecord on worksheetWhy it changes the decision
Export creditNet metering, buyback, or self-consumption basisThe same kWh can have different bill value
Incentive statusEntered incentive, eligibility note, expirationUnverified incentives can distort payback
Degradation and maintenanceAnnual degradation, O&M, inverter replacement noteLong-term cash flow is not the same as first-year savings
Roof and ownershipRoof age, financing term, transfer or resale notePayback can be limited by ownership and roof timing

How to use this chart

1

Record cost basis

Write gross cost, user-entered incentives, net installed cost, quote scope, and exclusions.

2

Attach production and rate data

Document annual kWh, self-consumption share, retail rate, export credit, O&M, and scheduled replacement.

3

Route finance review

Use the worksheet to list sensitivity cases, financing notes, and reviewer follow-up.

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 record

Record 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 record

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

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.