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.
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
| 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
| 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 timing |
How to use this chart
Record cost basis
Write gross cost, user-entered incentives, net installed cost, quote scope, and exclusions.
Attach production and rate data
Document annual kWh, self-consumption share, retail rate, export credit, O&M, and scheduled replacement.
Route finance review
Use the worksheet to list sensitivity cases, financing notes, and reviewer follow-up.
Worksheet checklist
- 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
- 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.
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.
Assumptions
- 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
- Use this chart as an educational planning 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.
Related calculators
Solar ROI Calculator
Calculate planning-level solar payback, export-credit value, user-entered incentives, degradation, and cash-flow assumptions
Solar Calculator
Calculate solar panel energy production, cost savings, and payback period for residential solar installations
ROI Calculator
Calculate return on investment for electrical projects, energy efficiency upgrades, and equipment purchases
Related charts
Solar Panel Output Chart
Use a solar panel output chart to document panel watts, panel count, peak sun hours, PVWatts-style losses, daily kWh, average monthly kWh, annual kWh, degradation, and offset notes.
ROI Payback Chart
Use an ROI payback chart to document investment cost, annual benefit, operating cost, simple payback, ROI percent, cash-flow notes, and sensitivity assumptions.
Energy Savings Payback Chart
Use an energy savings payback chart to document project cost, baseline energy, improved energy, utility rate, annual savings, payback, and sensitivity notes.
Frequently asked questions
These answers explain how to use the chart without turning a quick reference into a final design decision.