Enter Package Details
Example Data Table
| Package | Upfront | Rebate | Life | Savings (Yr1) | Maintenance (Yr1) | Escalation | Perf |
|---|---|---|---|---|---|---|---|
| HVAC Optimization | 12,000 | 1,500 | 12 | 2,600 | 220 | 3% | 95% |
| LED + Controls | 8,500 | 800 | 10 | 1,900 | 120 | 3% | 100% |
| Building Envelope | 18,000 | 2,500 | 15 | 3,100 | 260 | 3% | 90% |
These are sample inputs. Your results will differ by rates, incentives, and measured savings.
Formula Used
- Net Initial Cost = Upfront × (1 + Contingency) + Downtime − Rebates
- Annual Benefitst = Savings × Performance × (1 + Escalation)t−1 (+ Residual at final year)
- Annual Costst = Maintenance × (1 + Inflation)t−1
- NPV = Σ(Benefitst/(1+r)t) − [Net Initial + Σ(Costst/(1+r)t)]
- Discounted Payback = first year where cumulative discounted net cashflow ≥ 0
- ROI = (PV Benefits − PV Costs) ÷ PV Costs
- BCR = PV Benefits ÷ PV Costs
- Equivalent Annual Value converts NPV into an annualized figure over useful life.
How to Use This Calculator
- Enter a discount rate that matches your funding or hurdle rate.
- Fill in at least one package with upfront cost and annual savings.
- Add rebates, contingency, and downtime to reflect real implementation.
- Set escalation and inflation to model future price changes.
- Use the performance factor to apply a conservative savings haircut.
- Click Compare Packages to view ranked results above the form.
- Download CSV or PDF to share the comparison with stakeholders.
Decision Metrics That Matter
NPV captures total value after discounting, so it is the primary score for long-lived retrofits. A package with NPV above zero adds value at the chosen discount rate. Benefit‑cost ratio compares discounted benefits to discounted costs; values above 1.00 signal positive economics. ROI expresses value as a percentage, while equivalent annual value converts NPV into an annual figure for easy budgeting. Track NPV, payback, and EAV together to balance value and risk.
Handling Incentives And Hidden Costs
Upfront price rarely tells the full story. This calculator nets rebates and incentives against cost, then adds contingency and downtime to reflect delivery risk. For example, a $12,000 upgrade with an 8% contingency, $300 disruption cost, and a $1,500 rebate becomes $11,760 net initial cost. Capturing these items avoids underestimating payback time and overstating ROI.
Discount Rate And Escalation Assumptions
Discount rate represents required return, often 8%–15% for corporate capital and lower for public projects. Savings escalation can mirror utility tariff growth; 2%–5% is common where energy prices trend upward. Maintenance inflation can be set separately to reflect service contracts. Because these assumptions move results materially, compare scenarios: raise the discount rate to stress cashflows, or reduce escalation to test a flat‑price outlook.
Interpreting Payback Versus Value
Discounted payback is the first year when cumulative discounted net cashflow turns positive. It is useful for liquidity constraints, but it can penalize high‑value projects with longer lives. Two packages may have similar payback, yet one has far higher NPV because benefits persist longer. Use payback for risk screening, then finalize with NPV and EAV for value maximization.
Reporting For Stakeholders
Decision makers want transparent inputs and auditable outputs. Use the ranked table, charts, and the year‑by‑year discounted cashflow to explain why a package wins. Export CSV for spreadsheet review and PDF for approvals. When presenting, cite discount rate, escalation, and performance factor so reviewers understand how conservative the forecast is.
FAQs
What does discounted payback mean?
Discounted payback is the first year when cumulative discounted net cashflow becomes positive. It accounts for the time value of money, so it is stricter than simple payback and favors faster-returning upgrades.
Why can ROI be high but NPV lower?
ROI is a percentage and can look strong on a small project. NPV is an absolute value and rewards larger, longer-lasting benefits. A modest retrofit may have high ROI yet contribute less total value.
How do I choose a discount rate?
Use your organization’s hurdle rate or cost of capital. If uncertain, test a range such as 8% to 15%. Higher rates penalize distant savings, while lower rates emphasize long-life efficiency benefits.
What is the performance factor for?
It applies a realism adjustment to projected savings. Set 90%–100% when measured data is strong, or lower when savings are uncertain. This helps prevent overly optimistic forecasts and makes comparisons more defensible.
Should I include residual value?
Include resale, salvage, or avoided replacement value that occurs at end of life. If you are unsure, set it to zero for a conservative case. Adding realistic residual value improves accuracy for long-lived assets.
Can I compare more than three packages?
This version compares up to three packages per run for clarity. To evaluate more options, rerun with different package sets or duplicate the package block in the code while keeping the same calculation rules.
Disclaimer: This tool provides estimates for planning only. Validate assumptions with audits, quotes, and measured performance where possible.