
Home Energy Upgrade Payback: Simple and Discounted Methods
Calculate home energy upgrade payback with a clear baseline, net annual benefit and simple...

Model long-term solar savings with separate self-use and export values, annual costs, replacement timing and clearly labelled assumptions.
Long-term solar savings need a year-by-year model of electricity value and ownership costs. Canadian homeowners should start with the proposed site’s production, the utility arrangement and the household’s use pattern, then show how each assumption changes over the period being considered.
The goal is a transparent cash-flow record, not a promised national payback or a second spreadsheet software tutorial. Keep the evidence for every input so a quote, utility rule or service assumption can be checked later.
Request the estimated annual generation, roof and shading assumptions, equipment configuration and loss treatment. Ask whether the figure describes an initial year, a typical year or a lifetime average.
NRCan’s PV-resource maps describe lifetime-average potential and explain modelling limitations. Do not automatically treat a lifetime-average resource estimate as a first-year forecast and apply another decline series without checking what has already been included. The site’s actual roof and proposed installation still need assessment.
Separate solar used at the property from electricity exported. Apply the avoidable charge to self-use and the usable credit or other value to exports under the applicable arrangement. Keep charges that remain outside the claimed reduction.
For an invented example, assume 2,000 kWh is used directly at an avoidable value of $0.15 per kWh, and 3,000 kWh is exported at a usable value of $0.10 per kWh. That gives $300 plus $300, or $600 gross annual value. The quantities and values are not forecasts or current tariff quotations.
The OEB’s Ontario explanation shows why credits cannot simply be applied to every type of bill charge. Confirm your own utility rules, including whether all forecast credits can actually be used, rather than applying the Ontario example nationwide.
| Input | Record with it |
|---|---|
| Generation | Estimate source, year basis, shading and changes over time. |
| Self-use | Household demand assumptions, including planned equipment changes. |
| Export value | Applicable account rules and usable-credit assumptions. |
| Recurring costs | Service, monitoring and other relevant ownership costs. |
| One-time costs | Timing assumptions for repairs, replacement or roof-related work. |
| Initial funding | Cash outlay, conditional assistance and any separate borrowing structure. |
Mark an input as measured, quoted or assumed. An explicit placeholder is more useful than an unsupported precise figure.
Extend the invented example with $100 of annual ownership costs and a purely assumed 1% annual reduction in generation value. Hold unit values, the self-use/export proportions and recurring costs constant only to isolate the arithmetic. Add an assumed $1,500 equipment cost in year ten.
| Year | Gross electricity value | Modelled costs | Net operating cash flow |
|---|---|---|---|
| 1 | $600.00 | $100 | $500.00 |
| 2 | $594.00 | $100 | $494.00 |
| 10 | $548.11 | $1,600 | −$1,051.89 |
| 20 | $495.70 | $100 | $395.70 |
Gross value here is $600 × 0.99 raised to the year minus one. These assumptions are neither a degradation forecast nor a service schedule. They demonstrate why simply multiplying first-year savings by twenty can hide changing production and a large cost year.
Record the initial capital outlay separately and combine it with annual net flows for an investment analysis. In a financed household cash-flow model, use the actual deposit and debt payments; do not count the full financed purchase price and its principal repayments twice.
Keep conditional assistance and payment timing visible. A loan is repayable funding, and an unapproved incentive is not cash already received. Solenery’s personalized rebate discovery and address matching remain premium features in the existing property flow.
Review lower production, different electricity values, changed household use and earlier repair scenarios. Keep rate-growth tests distinct from the base assumptions rather than treating future inflation as guaranteed.
The solar spreadsheet guide can help implement a model. This annual record supplies the traceable assumptions and cash flows to put into it. Finish by stating what is known, what is assumed and which changes would materially alter the decision.

Calculate home energy upgrade payback with a clear baseline, net annual benefit and simple...

Assess Ottawa winter solar production with a monthly evidence sheet covering snow assumptions,...

Check net-zero building code claims against the locally applicable code, defined performance...