Discount rates and NPV for solar projects
How to choose a discount rate and build a defensible net present value model for a rooftop or ground-mount PV investment.
Two identical arrays on two identical roofs can differ by half in annual savings. The variable is not the hardware, it is what fraction of the generation is used on site.

Annual production is the figure every quote leads with. It is also the figure that matters least. What decides the value of a rooftop array is the share of those kilowatt-hours consumed inside the building rather than pushed onto the network — the self-consumption ratio.
The arithmetic is blunt. If you buy electricity at 0.28 EUR/kWh and are paid 0.07 EUR/kWh for exports, a kilowatt-hour used at home is worth four times a kilowatt-hour exported. Two households with the same 5 kWp array, one at 30 percent self-consumption and one at 60 percent, do not differ by a few euros a year. They differ by roughly 40 percent of the total benefit.
Two ratios sound alike and mean opposite things.
Self-consumption ratio = solar energy used on site ÷ total solar generation. It answers: how much of what I make do I keep?
Self-sufficiency ratio (also called autonomy) = solar energy used on site ÷ total household consumption. It answers: how much of what I need do I make?
A large array on a small load has high self-sufficiency and poor self-consumption. A small array on a large load has the reverse. Only the first ratio drives the value of each additional kilowatt-hour generated; the second describes exposure to the grid. A quote that quotes one and implies the other is being careless.
| System on a 4,500 kWh/yr household | Generation | Self-consumption | Self-sufficiency |
|---|---|---|---|
| 2 kWp, no storage | 2,300 kWh | 62% | 32% |
| 5 kWp, no storage | 5,750 kWh | 33% | 42% |
| 5 kWp + 5 kWh battery | 5,750 kWh | 58% | 74% |
| 5 kWp + 10 kWh battery | 5,750 kWh | 66% | 84% |
Figures are indicative for a central European load profile with daytime occupancy on two days a week. Your own profile can move each column by ten points or more.
Residential demand is bimodal: a morning peak before people leave, a larger evening peak after they return. Solar generation is unimodal and centred on solar noon. The two curves barely overlap. Standing loads — refrigeration, standby, ventilation, a router, a heat pump in shoulder season — form a baseline of perhaps 150 to 400 W that solar covers easily. Everything above that baseline happens at the wrong time.
That is why an unmodified household with no storage and no controllable loads lands between 25 and 35 percent almost regardless of country. It is a shape mismatch, not a hardware defect.
Do not accept a modelled ratio. Get the data.
The spreadsheet takes an hour and is the single most useful piece of analysis a prospective owner can do. Everything after this — battery size, array size, tariff choice — falls out of it.
Before buying storage, move the load. Shifting a kilowatt-hour costs nothing but attention; storing one costs the battery.
Combined, these interventions routinely take a household from the low thirties to the high forties without any storage. That is the same improvement a small battery buys, at a fraction of the cost.
Storage is not a way to raise self-consumption cheaply. It is a way to raise it further once the free options are exhausted, and to buy resilience and tariff arbitrage alongside.
The marginal value of each stored kilowatt-hour is the import price minus the export price, minus round-trip losses of roughly 10 to 15 percent, minus the amortised cost of the cycle. With a battery at 600 EUR/kWh usable, 6,000 cycles of warranted throughput and 90 percent round-trip efficiency, the storage cost per delivered kilowatt-hour is about 0.11 EUR before any financing. If your import-export spread is 0.21 EUR, storage clears the bar. If your spread is 0.09 EUR, it does not, and no amount of enthusiasm changes that.
Battery size follows the surplus curve, not the array size. Sum the daily exported energy across the year and look at the median, not the maximum. Sizing to the summer peak buys capacity that sits idle for eight months. Our battery sizing calculator works this through with a full year of daily surpluses.
Where dynamic or time-of-use pricing exists, the value of a stored kilowatt-hour is no longer just the avoided import price. It becomes the difference between the cheapest and dearest hours, which in volatile markets can exceed the flat spread by a wide margin. Under those tariffs a battery may profitably charge from the grid overnight and discharge into the evening peak, quite apart from what the array does.
This also inverts one piece of conventional advice. Under a flat tariff, west-facing modules are penalised for lower annual yield. Under an evening-peaked tariff, their later generation profile may be worth more per kilowatt-hour than a south-facing array's midday surplus. Orientation should be chosen against the tariff, not against a yield table alone. The trade-off is set out in detail in orientation and tilt.
What is a good self-consumption ratio? For a household without storage or controllable loads, 30 to 35 percent is normal and not a sign of a bad installation. With load shifting, 45 to 55 percent is achievable. With a well-sized battery, 60 to 75 percent. Above 80 percent usually means the array is undersized relative to the load rather than that the system is unusually good.
Does a bigger battery always raise self-consumption? It rises, but with sharply diminishing returns. Each additional kilowatt-hour of storage catches a smaller slice of surplus because the large surpluses occur on relatively few days. Beyond roughly one day's average household consumption, added capacity earns very little unless it is being used for tariff arbitrage or backup.
Is exporting to the grid a waste? No. Exported energy displaces generation elsewhere and still earns whatever the export rate is. It is simply worth less than energy used on site under most modern compensation schemes, which is why raising self-consumption is the priority when the two prices diverge.
Should I oversize the array if self-consumption will fall? Often yes. Fixed costs — scaffolding, design, connection, labour — are spread over more kilowatts as the array grows, so the cost per kilowatt-hour generated falls even as the average value of each kilowatt-hour falls. Run both effects through the payback calculator rather than reasoning about either in isolation.
First published.
Technical review: worked examples re-derived, standards references checked against current editions, sources verified.
How to choose a discount rate and build a defensible net present value model for a rooftop or ground-mount PV investment.
How flat, time-of-use and dynamic tariffs change the value of self-consumed and exported solar electricity, with a worked comparison.
How to compare a cash purchase against a solar loan on a like-for-like basis, including the effect of interest rates on payback and NPV.