Inputs
Example data table
| Scenario | Installed cost | Rebates | Energy bill | Savings % | Years | Discount % | Escalation % |
|---|---|---|---|---|---|---|---|
| Conservative | USD 6,500 | USD 500 | USD 1,500 | 8% | 15 | 7% | 2% |
| Balanced | USD 7,200 | USD 800 | USD 1,900 | 12% | 15 | 6% | 3% |
| Optimistic | USD 7,800 | USD 1,000 | USD 2,200 | 18% | 20 | 5% | 4% |
Formula used
- Net cost = Installed cost − Rebates and credits.
- Year‑t energy savings = Annual bill × Savings% × (1 + Escalation%)(t−1).
- Year‑t benefit = Energy savings + Maintenance change.
- Present value = Year‑t benefit ÷ (1 + Discount%)t.
- NPV = Σ(PV benefits) + PV(resale gain) − Net cost.
- ROI% = (NPV ÷ Net cost) × 100.
- Simple payback = Net cost ÷ Year‑1 benefit (if positive).
How to use this calculator
- Enter the full installed cost for your double‑pane upgrade.
- Add rebates, credits, or incentives you expect to receive.
- Use your yearly heating and cooling spending as the energy bill.
- Choose a savings percent; start conservative if unsure.
- Set escalation and discount rates to match your assumptions.
- Pick an analysis period and optional resale gain.
- Press Submit to see ROI, payback, NPV, and yearly table.
Professional insights
Energy savings assumptions
Double-pane upgrades usually reduce heat transfer and air leakage, so the calculator models savings as a percent of your annual heating and cooling spend. Many households start with 5% to 20% savings, then validate using utility bills and a quick audit. If your annual energy bill is 1,800, a 12% savings rate estimates 216 in year one, before maintenance changes. Escalation increases that savings over time; at 3% escalation, year ten savings become about 281, assuming constant performance.
Discounting and time value
Future benefits are worth less than benefits today, so the tool discounts each year’s benefit by your chosen rate. A 6% discount rate values a 300 benefit in year five at about 224 in present terms. Lower discount rates favor long-lived improvements; higher rates push the result toward quick payback projects. Discounted payback shows when cumulative discounted benefits recover the net cost, which is stricter than simple payback.
Payback interpretation
Simple payback divides net cost by year-one benefit, so it ignores price escalation and discounting. It is useful for quick screening, but can mislead when energy prices rise or when you plan to sell the home. Discounted payback considers both effects, and the NPV summarizes total value over your analysis period.
Sensitivity to key inputs
ROI is most sensitive to net cost, savings percent, and the starting energy bill. A 10% rebate improvement reduces net cost immediately, while a 2-point increase in savings percent can materially change NPV. Try three scenarios: conservative 8% savings, balanced 12%, and optimistic 18%. Keep escalation within -5% to 15% and align the analysis period with expected occupancy.
Decision guidance
Use NPV to compare upgrades under a consistent discount rate. Positive NPV suggests the discounted benefits and resale gain exceed cost. IRR provides a comparable “return” metric; if IRR is above your hurdle rate, the investment clears your threshold. Finally, balance dollars with comfort: reduced drafts, condensation, and noise can justify a project even when payback is longer.
FAQs
What inputs matter most for ROI?
Net cost, savings percent, and your baseline annual energy bill drive most of the result. Discount rate and analysis years shape how much future savings count today. Use conservative savings first, then refine with real bills or an energy assessment.
How should I choose a savings percent?
Start with 8% to 12% if you lack measured data. Homes with very leaky windows or extreme climates may justify higher values. After installation, compare usage against similar weather months to validate the estimate.
Why can discounted payback differ from simple payback?
Simple payback ignores discounting and energy-price changes. Discounted payback reduces future benefits using your discount rate and still applies escalation to savings. It is a stricter test of when value truly recovers cost.
What does a negative NPV mean?
A negative NPV means discounted benefits plus resale gain do not exceed the net upfront cost over the selected years. You can test sensitivity by increasing rebates, lengthening the analysis period, lowering discount rate, or using a more realistic savings estimate.
How is resale value handled?
Resale gain is added in the final year and discounted back to today, like any other cashflow. If you expect to move sooner than the analysis period, shorten the years and adjust resale gain to match your likely selling timeline.
Is IRR always available?
IRR requires a pattern of negative then positive cashflows. If benefits are too small or inputs create unusual cashflow shapes, the approximation may fail. In that case, use NPV, payback, and scenario testing for decisions.