| Scenario | Cost | Incentives | Energy Savings | Maintenance | Years | Escalation | Discount |
|---|---|---|---|---|---|---|---|
| Heat pump + sealing | 8,000 | 1,200 | 900 | 150 | 15 | 3.0% | 7.0% |
| Insulation upgrade | 4,500 | 500 | 420 | 60 | 15 | 3.0% | 7.0% |
| Efficient water heating | 2,700 | 300 | 220 | 35 | 12 | 3.0% | 7.0% |
- Net Investment = Cost − Incentives − Down Payment.
- Year t Benefit = (Energy + Maintenance + Other) × (1 + Escalation)(t−1).
- Loan Payment (monthly) uses standard amortization with APR and loan term.
- Net Cashflow = Benefit − Annual Loan Payments (if enabled), plus residual value in final year.
- Discounted Net = Net Cashflow ÷ (1 + Discount)t.
- NPV = −Net Investment + Σ Discounted Net.
- ROI = NPV ÷ Net Investment.
- IRR solves NPV(rate)=0 using a numeric search.
- Enter total retrofit cost and expected incentives.
- Add first‑year savings for energy and maintenance.
- Set analysis years, escalation, and discount rate.
- Enable financing only if you will borrow for upgrades.
- Click Calculate ROI to view results above the form.
- Download CSV or PDF to share your scenario.
Typical Cost Ranges and Payback Windows
Whole-home retrofits often span 2,000 to 25,000 in total cost, depending on envelope work, HVAC replacement, and controls. When incentives cover 10% to 30%, net investment drops materially. With year‑1 savings of 600 to 1,800 and 2% to 4% escalation, simple payback commonly lands between 5 and 14 years. Track bills for three months before and after upgrades to validate results.
How Escalation Changes Long-Term Benefits
Energy prices and usage shifts compound. A 3% escalation turns 1,000 of first‑year savings into about 1,558 by year 15, adding over 4,000 of extra undiscounted benefit compared with flat savings. Use escalation to reflect tariff inflation, rising cooling demand, or improved occupancy habits after commissioning. Run a low case at 0% and a high case at 5% to bracket risk.
Discount Rate and Opportunity Cost
Discount rate frames what “good” looks like. At 7%, 1,000 received in year 10 is worth roughly 508 today, so distant savings matter less. If your alternative is paying down high‑interest debt, a higher discount rate may be appropriate. For conservative budgeting, many homeowners test 5%, 7%, and 10% side by side. Align the rate with your loan APR or expected investment return.
Financing Effects on Net Cashflow
Loans can smooth upfront cash needs but reduce early net cashflow. For example, financing 7,000 over 7 years at 9.5% yields about 1,350 in annual payments. If year‑1 benefit is 1,050, early years show negative net cashflow, yet NPV can remain positive when later savings outlast payments. Consider making principal prepayments to shorten the payment window.
Using NPV and IRR for Upgrade Ranking
NPV summarizes total value after discounting, while IRR expresses efficiency as a percent return. If two upgrades have similar payback, choose the higher NPV for absolute wealth or the higher IRR for capital efficiency. Residual value at the end of the period can meaningfully lift both metrics for longer‑life measures. Combine air sealing with HVAC sizing to avoid overspending on capacity.
1) What does ROI mean in this calculator?
ROI is calculated as NPV divided by net investment. It indicates how much discounted value you gain per unit invested over the analysis period.
2) Why can simple payback differ from discounted payback?
Simple payback ignores the time value of money. Discounted payback applies your discount rate, so future savings count less and payback can take longer.
3) How should I estimate annual energy savings?
Use prior utility bills, audit estimates, or contractor projections. Start conservative, then test a higher scenario to see how results change under better performance.
4) Do incentives reduce the cost immediately?
This model treats incentives as reducing upfront cost. If you receive rebates later, you can approximate that by adding the amount to year‑1 benefit instead.
5) What if my retrofit has a residual value?
Enter an end‑of‑period residual value to reflect remaining equipment life or resale value. It is added to the final year cashflow and discounted accordingly.
6) How accurate is the IRR output?
IRR is a numerical estimate based on your yearly cashflows. It is reliable for comparing scenarios, but real outcomes depend on actual usage, prices, and maintenance.