Calculator Inputs
Example Data Table
| Example input | Value | Notes |
|---|---|---|
| Installation cost | $4,500.00 | Typical attic and rim-joist scope. |
| Rebates / incentives | $500.00 | Utility rebate applied upfront. |
| Annual heating + cooling cost | $1,800.00 | Based on last 12 months of bills. |
| Insulation-driven reduction | 25.0% | Improved thermal performance. |
| Air-sealing bonus | 5.0% | Reduced infiltration and leakage. |
| Discount rate / Escalation | 5.0% / 3.0% | Finance assumptions for NPV and growth. |
| Analysis period / Residual value | 10 years / $500.00 | Optional terminal value added in year 10. |
Formula Used
- Net project cost = Installation cost − Rebates.
- Gross savings rate = Insulation reduction% + Air-sealing bonus% (capped).
- Year 1 savings = Annual HVAC cost × Gross savings rate − Maintenance change.
- Savings in year t = Year 1 savings × (1 + Escalation)^(t − 1).
- Net cash flow = Savings − Loan payment (+ Residual value in the final year).
- Discounted cash flow = Net cash flow / (1 + Discount rate)^t.
- NPV = Sum of discounted cash flows including year 0.
- Simple ROI = (Total nominal benefits − Net project cost) / Net project cost.
- IRR is the rate where NPV equals zero (if solvable).
How to Use This Calculator
- Enter the installed price and any rebates or incentives.
- Use your annual heating and cooling spend for the baseline.
- Choose reductions for insulation impact and air-sealing benefit.
- Set the analysis period, discount rate, and energy escalation.
- Optional: enable financing to include loan payments in cash flow.
- Click Calculate ROI to view results above the form.
- Use the download buttons to export a report as CSV or PDF.
Baseline spending and scope assumptions
The model starts with your annual heating and cooling spend, then applies a combined savings rate from insulation performance and air sealing. Using the example inputs, a $1,800 baseline and a 30% combined reduction produce $540 in first-year savings. Rebates reduce the upfront investment from $4,500 to a $4,000 net cost, which is treated as year 0 cash outflow unless you enable financing. For quick checks, run three scenarios: conservative, expected, and aggressive, then compare payback and NPV side-by-side.
Savings growth driven by energy escalation
Energy prices rarely stay flat, so savings can rise over time. With a 3% escalation rate, the $540 first-year savings grows to about $705 by year 10. The projection compounds savings annually and adds any residual value in the final year, which can represent durability, resale influence, or avoided replacement work.
Payback and ROI interpretation
Payback is calculated from cumulative net cash flow, using interpolation in the year the total crosses zero. With the example scenario (no loan), nominal payback is about 6.79 years, while discounted payback is about 8.34 years at a 5% discount rate. Over a 10‑year horizon, total nominal benefits are roughly $6,690, producing a simple ROI near 67% on the $4,000 net cost.
NPV, BCR, and rate sensitivity
NPV converts future cash flows into today’s dollars. In the example, NPV is approximately $1,031 at a 5% discount rate, and the benefit-cost ratio is about 1.26 (PV benefits ≈ $5,031 divided by $4,000 cost). If the discount rate rises to 8%, NPV drops near $309; around 10%, it turns slightly negative, consistent with an IRR near 9.5%.
Using the Plotly chart and exports
The chart visualizes annual net cash flow as bars and shows cumulative performance as two lines: nominal and discounted. Use it to see whether early loan payments reduce near‑term cash flow, and whether cumulative discounted value stays above zero. Export CSV for scenario comparisons and PDF for sharing with contractors, lenders, or budget reviews.
FAQs
What should I enter as annual heating and cooling cost?
Use your last 12 months of HVAC-related energy spend. If you cannot separate HVAC, use total utility cost and reduce the savings rate to avoid overstating benefits.
How do I choose the reduction percentages?
Start with conservative values, then run scenarios. Many homes fall in a 10–35% savings range depending on leakage, insulation gaps, and climate. Verify with an audit when possible.
Why does the calculator include escalation and discount rates?
Escalation models rising energy costs that increase savings over time. Discounting reflects the time value of money, converting future savings into today’s dollars for NPV and discounted payback.
Does financing change ROI and NPV?
Financing changes cash flow timing by adding loan payments, which can affect payback and NPV. The simple ROI is based on project benefits versus net cost, independent of how you pay.
Can maintenance change be negative?
Yes. Enter a negative number to represent estimated annual maintenance savings, such as reduced HVAC runtime and fewer service calls. Keep values modest unless supported by evidence.
Why might IRR show as N/A?
IRR may be unavailable when cash flows do not produce a clean sign change, or when multiple changes create ambiguity. In those cases, rely on NPV, payback, and scenario testing.