Stepwise Retrofit Planner Calculator

Formula used

• Baseline cost (year t): $Baseline_t = Baseline₀ × (1 + escalation)^t
• Stepwise energy reduction: RemainingEnergyCost = BaselineCost × Π(1 − savings%_step) for steps active that year
• Post‑retrofit total: PostCost = RemainingEnergyCost + Σ(maintenance Δ) for active steps
• Annual savings: Savings_t = max(0, Baseline_t − PostCost_t)
• Net capex per step: NetCapex = max(0, Capex − Incentive)
• Simple payback (snapshot): Payback = NetCapex ÷ AnnualSavingsNow
• NPV: NPV = −Σ(NetCapex in its start year) + Σ((Savings_t − Capex_t) ÷ (1 + discount)^t)
• ROI (PV basis): ROI = (PV(Savings) − NetCapex) ÷ NetCapex

How to use this calculator

1. Enter your baseline annual energy cost, or use kWh and rate.
2. Set start year, horizon, escalation, and discount rate.
3. Add retrofit steps in the order you expect to deliver.
4. For each step, enter capex, incentive, savings percent, and maintenance change.
5. Submit to view staged payback, NPV, ROI, and cashflows.
6. Download CSV or PDF for reporting and sharing.

Staged sequencing improves capital efficiency

A stepwise roadmap limits risk by proving savings early, then committing to deeper upgrades. Early measures like lighting and controls often deliver 8–15% savings with modest disruption. When demand drops first, later equipment can be right-sized, lowering installed capacity and reducing cost. This planner compounds savings by applying each step to the remaining energy cost rather than the original baseline.

Incentives reveal the true investment hurdle

Net capex equals capex minus incentives, so rebates change economics immediately and scheduled with the step. For example, an $18,000 lighting step with a $2,000 incentive becomes $16,000 net capex. The calculator keeps gross capex, incentives, and net totals visible so funding sources are not blended into savings. This supports consistent approval memos and reduces reconciliation issues in procurement.

Escalation and discounting separate nominal from valued savings

Annual baseline cost can grow using an escalation rate, reflecting tariffs and volatility. Future cashflows are discounted back to present value using your hurdle rate, enabling comparable evaluation across projects. NPV sums discounted yearly savings and subtracts net capex timed to each step’s start year. A positive NPV indicates the plan creates value under the selected discount rate and implementation timeline.

Maintenance deltas protect operating budgets

Some upgrades reduce service calls and parts, while others introduce annual contracts or commissioning. The model adds maintenance changes once a step becomes active, year by year, alongside energy savings. A negative maintenance delta improves savings; a positive delta reduces net benefit, even if energy drops materially. Including maintenance improves forecasting accuracy for facilities and finance teams.

Reading payback, ROI, and the timeline together

Step payback is a snapshot based on current-year savings, useful for screening and discussions. The year-by-year table captures timing, showing years where capex spikes and when savings ramp after later steps. ROI uses present-value savings versus net capex, aligning with finance review standards. Use the charts to validate that cumulative cashflow turns positive within the horizon you selected.

FAQs

1) What does “incremental savings” mean here?

Each step reduces the remaining energy cost after earlier steps. This avoids double counting and reflects how compounded improvements work in practice.

2) Why can payback differ from NPV?

Payback ignores timing, escalation, and discounting. NPV accounts for when savings occur and values future savings less using your discount rate.

3) How are incentives handled?

Incentives reduce net capex for the step. Reports show gross capex, incentives, and net capex separately so funding is transparent.

4) Can maintenance changes be negative?

Yes. Negative maintenance deltas represent reduced annual operating cost, such as fewer replacements, fewer service calls, or simpler maintenance.

5) What if a step starts later?

Savings and maintenance deltas begin in that step’s start year. Net capex is also applied in the same year within the cashflow table.

6) How should I choose the discount rate?

Use your hurdle rate or cost of capital. Higher discount rates favor faster payback measures and reduce the present value of distant savings.