Skip to content
Back to Solar Energy
Solar Energy

Long-Term Solar Savings: Build a Year-by-Year Model

Model long-term solar savings with separate self-use and export values, annual costs, replacement timing and clearly labelled assumptions.

Arshia Jahangiri
4 min

Table of contents

Listen to this article

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.

Check what the production estimate represents

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.

Build year one from two electricity quantities

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.

Write an annual assumptions register

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.

Carry the assumptions through each year

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.

Separate the investment from operating results

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.

Use scenarios to explain uncertainty

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.

Share this article