Calculator Inputs
Use the checkboxes to include measures in a bundle. Costs and savings are annual.
Example Bundle Data
| Measure | Cost ($) | Annual Savings ($) | Incentive ($) | Life (years) |
|---|---|---|---|---|
| Attic Insulation | 1,800 | 260 | 150 | 20 |
| Air Sealing | 700 | 140 | 75 | 15 |
| Heat Pump Upgrade | 6,500 | 520 | 600 | 15 |
| Smart Thermostat | 250 | 55 | 25 | 10 |
| LED Lighting | 300 | 60 | 0 | 10 |
| Window Film | 900 | 110 | 0 | 12 |
This sample set is meant for demonstration only. Replace values with your project quotes and expected savings.
Formula Used
Net Upfront Cost
Net Upfront = Gross Cost − (Gross Cost × Bundle Discount%) − Total Incentives.
Bundled Savings (Year 1)
Effective Savings = Sum of Measure Savings × (1 − Overlap%) × (1 + Synergy%).
Escalation and Discounting
Savingsy = Savings1 × (1 + Escalation)y−1
Discount Factor = 1 / (1 + Discount Rate)y
NPV, ROI, Payback
NPV = Σ(Net Cash Flowy / (1+r)y) − Net Upfront
ROI = (PV(Net Cash Flows) − Net Upfront) / Net Upfront
Simple Payback = Net Upfront / Year-1 Net Savings
How to Use This Calculator
- Check the measures you plan to install, then enter quoted costs and expected annual savings.
- Add incentives (rebates, credits, or grants) to reduce net upfront cost.
- Set overlap to reduce double-counted savings between interacting measures.
- Use synergy if the bundle improves performance beyond simple addition.
- Choose a discount rate and escalation rate to reflect your financial view.
- Press Calculate and use the download buttons in the results.
Bundled cost and incentive leverage
Bundling treats multiple upgrades as one investment. The calculator totals measure costs, applies a bundle discount, then subtracts incentives to estimate net upfront cost. With the example data, gross cost is $10,450 and a 5% bundle discount saves $522.50 before rebates. If incentives total $850, the modeled net upfront becomes $9,077.50, improving every return metric.
Overlap control for realistic savings
Individual savings often overlap because measures influence the same loads. The overlap factor reduces the summed annual savings to avoid double counting. If six measures total $1,145/year and overlap is 10%, effective savings drops to $1,030.50/year. This assumption is conservative for insulation plus HVAC, or air sealing plus ventilation tuning.
Synergy and escalation modeling
Synergy adds a performance bonus when measures reinforce each other. A 2% synergy on $1,030.50 raises effective savings to $1,051.11 in year one. Escalation then increases savings annually; at 3% escalation, year five savings becomes about $1,183.08. These two levers separate engineering interaction from future price movement.
NPV, ROI, and payback signals
Net cash flow equals escalated savings minus maintenance. Discounting converts those cash flows into present value using the discount rate. NPV is the present value of cash flows minus net upfront; positive NPV suggests the bundle beats the chosen hurdle rate. ROI reports the same relationship as a percentage, while discounted payback shows when cumulative discounted benefits recover the upfront cost. For sensitivity, test 6%, 8%, and 10% discount rates, then adjust overlap from 0–20%. Keep measures constant and watch NPV and discounted payback shift; this supports budgeting and risk discussions with stakeholders and financing partners.
Interpreting the cash flow table
The yearly table shows escalated savings, net cash flow, discount factor, discounted cash flow, and cumulative discounted totals. Use it to spot whether savings growth is strong enough to offset discounting. When cumulative discounted benefits cross the upfront line, the discounted payback year is reached. Export CSV for audit trails and generate a PDF for proposals or approvals.
FAQs
What does “measure bundling” mean in this calculator?
It groups several upgrades into one package, then estimates total cost, incentives, and combined savings. The model applies a bundle discount and adjusts savings for overlap and synergy to reflect real-world interactions.
How are overlap and synergy different?
Overlap reduces summed savings to avoid double counting when measures affect the same loads. Synergy adds a small bonus when measures reinforce performance, such as air sealing improving HVAC efficiency beyond a simple sum.
Why does the discount rate matter?
Discounting converts future savings into today’s value. A higher discount rate lowers present value, usually reducing NPV and extending discounted payback. Use a rate that matches your required return or cost of capital.
How are incentives and rebates applied?
Incentives are subtracted after the bundle discount, reducing net upfront cost. Enter all expected rebates, credits, or grants as incentives for each measure to reflect your true out-of-pocket cost.
What if my net upfront cost becomes negative?
The calculator floors net upfront at $0. This prevents unrealistic payback math when incentives exceed costs and keeps ROI, NPV, and IRR calculations stable for comparison across scenarios.
Why is IRR sometimes shown as N/A?
IRR requires a solvable rate where discounted savings equal the upfront cost. If cash flows never recover the upfront amount, or the math does not cross zero over tested rates, IRR may be unavailable.