Inputs
How to use this calculator
- Enter your annual utility cost from recent bills.
- Add the audit cost and expected upgrade implementation cost.
- Include rebates or incentives you can reasonably claim.
- Set an estimated savings percentage from audit recommendations.
- Adjust escalation and discount rate to match your assumptions.
- Click Calculate ROI to see ROI, NPV, and payback.
- Download CSV or PDF for sharing and recordkeeping.
Formula used
- Initial Cost = Audit Cost + Implementation Cost − Incentives
- Energy Cost (Year t) = Annual Energy Cost × (1 + Escalation)^(t−1)
- Gross Savings (Year t) = Energy Cost (Year t) × Savings %
- Net Savings (Year t) = Gross Savings − Annual Maintenance Change
- Present Value (Year t) = Net Savings ÷ (1 + Discount Rate)^t
- NPV = −Initial Cost + Σ(Present Value of Net Savings)
- ROI % = (Total Net Savings − Initial Cost) ÷ Initial Cost × 100
- Payback = first year where cumulative savings ≥ Initial Cost
Example data table
| Scenario | Audit Cost | Upgrade Cost | Incentives | Annual Energy Cost | Savings % | Project Life | Typical Outcome |
|---|---|---|---|---|---|---|---|
| Small home | $300 | $1,800 | $300 | $1,500 | 10% | 10 | Moderate ROI, 3–6 year payback |
| Mid-size home | $450 | $3,200 | $600 | $1,800 | 15% | 10 | Higher NPV when prices escalate |
| Small business | $950 | $8,500 | $1,500 | $9,600 | 18% | 12 | Strong ROI, often 2–5 years payback |
Audit scope and baseline
An audit ROI starts with a credible baseline. Use your last 12 months of utility spend as the annual energy cost, then confirm the building schedule, peak demand drivers, and major equipment runtimes. Even a 5–10% error in the baseline can shift payback by a full year on small projects. Document assumptions so the savings estimate stays defensible.
Turning findings into savings
This calculator converts an expected savings percentage into yearly gross savings. For example, a $1,800 baseline and 15% savings produces $270 in year‑1 gross savings. If utility prices escalate 3% annually, year‑5 gross savings rises to about $304. Pair the percentage with specific measures—air sealing, controls tuning, lighting, or HVAC optimization—to keep the estimate realistic.
Accounting for costs and incentives
Initial cost combines the audit, implementation cost, and any incentives. A $450 audit plus $3,200 upgrades minus $600 rebates yields $3,050 upfront. If the audit cost is already included in contractor pricing, set it to zero to avoid double counting. Include annual maintenance changes to reflect filter upgrades, service contracts, or reduced callouts.
NPV, discounting, and risk
NPV discounts each year’s net savings back to today using your discount rate. A higher discount rate reduces NPV and can turn a marginal project negative, even when simple payback looks acceptable. Treat the discount rate as a risk knob: higher uncertainty, shorter tenant tenure, or volatile savings should push the rate upward.
Using results to decide
Use ROI, NPV, and payback together. ROI compares total net savings to initial cost, while payback highlights cash recovery speed. Benefit‑cost ratio above 1.0 indicates discounted benefits exceed costs. If IRR is available, compare it to your hurdle rate. Then export CSV or PDF to share a consistent business case. For multi-measure bundles, run best, expected, and conservative cases to see sensitivity. Projects that remain positive under conservative inputs usually deserve priority in your capital plan in next budget cycle.
FAQs
What savings percentage should I use?
Start with the audit’s recommended range, then choose a conservative mid‑point. If measures are well‑defined and verified, 10–20% is common. If estimates are early-stage or behavioral, use a lower value and compare best and worst cases.
How do incentives affect ROI?
Incentives reduce the upfront initial cost, improving ROI, NPV, and payback. Enter only amounts you are confident you can claim, and treat delayed rebates as smaller by using a slightly higher discount rate.
Why include energy price escalation?
Escalation models rising utility prices over time. If escalation is positive, future savings grow, raising NPV and reducing payback. If you expect flat prices, set escalation to zero for a neutral forecast.
What discount rate should I pick?
Use your required return or borrowing cost, adjusted for risk. Homeowners often use 5–10%, while businesses may use a higher hurdle rate. Higher discount rates make long‑term savings less valuable today.
What does IRR mean here?
IRR is the annualized rate that makes NPV equal zero for the cashflows. If IRR exceeds your hurdle rate, the project is financially attractive. IRR may show as N/A when cashflows do not cross zero.
Can I use this for multiple upgrades?
Yes. Bundle measures by combining total implementation cost, incentives, and an overall savings percentage. For better accuracy, run separate scenarios for each major measure and compare the combined results.