Deep Retrofit ROI Calculator

Inputs

Enter project costs and expected savings. Financing is optional.

Project cost (before incentives)

$

Total installed cost for the deep retrofit scope.

Incentives / rebates

$

Grants, rebates, tax credits (enter dollar value).

Annual energy savings (year 1)

$

Estimated utility bill reduction in the first year.

Annual maintenance savings (year 1)

$

Reduced service calls, replacements, or routine maintenance.

Annual added operating cost

$

If the retrofit increases O&M, enter it here.

Savings growth rate (per year)

%

Captures energy price escalation and performance tuning.

Analysis period

years

Typical deep retrofit horizons are 10–30 years.

Discount rate

%

Use your required rate of return (real or nominal).

Residual value at end

$

Estimated remaining value at the end of the period.

Financing (optional)

Enable loan modeling

Down payment

%

Applies to net project cost after incentives.

Loan APR

%

Nominal annual rate.

Loan term

years

Debt service is applied through this term.

Financing is modeled as a fixed-payment amortizing loan. It affects annual net cash flow, but not the retrofit savings themselves.

Reset

Example data table

These sample values match the default inputs above.

Item	Example value	Notes
Project cost	$120,000.00	Envelope, HVAC, controls, and commissioning.
Incentives	$15,000.00	Rebates and program support.
Energy savings (Y1)	$18,000.00	Utility reduction in year one.
Maintenance savings (Y1)	$2,500.00	Fewer repairs and replacements.
Savings growth	3.00%	Energy price escalation and tuning.
Discount rate	6.00%	Required return for discounting.
Analysis period	20 years	Long-life retrofit horizon.
Residual value	$10,000.00	Remaining asset value at the end.

Formula used

Net project cost: net_cost = project_cost − incentives
Initial cash outlay: initial_cash = net_cost × down_payment%
Annual savings growth: savings_t = savings_1 × (1 + g)^(t−1)
Net cash flow: cf_t = savings_t − added_cost − debt_service_t (plus residual value in final year)
NPV: NPV = Σ cf_t / (1 + r)^t
IRR: the discount rate where NPV equals zero (solved numerically).
Payback: first year where cumulative cash flow becomes non‑negative.

Note: If you use nominal savings growth, consider using a nominal discount rate too.

How to use this calculator

Enter total retrofit cost and expected incentives or rebates.
Add year‑one energy and maintenance savings (cash savings).
Set the savings growth rate to reflect future price changes.
Choose an analysis period and discount rate that fits your policy.
Optional: enable financing and enter down payment, APR, and term.
Click Calculate ROI to see payback, NPV, IRR, and yearly cash flows.

This tool provides estimates for planning and comparison only. Validate assumptions with professional energy models and project quotes before making financial decisions.

Professional article section

Cash flow framing for retrofits

Deep retrofits usually create a large upfront cost followed by many small annual benefits. This calculator converts those benefits into year-by-year net cash flow by combining energy and maintenance savings, subtracting added operating costs, and optionally subtracting debt service. The final year can include residual value, which matters when equipment life extends beyond the analysis horizon.

Interpreting payback and ROI together

Simple payback tells you how quickly cumulative cash flow reaches zero. ROI summarizes the net gain relative to the initial cash outlay. Use payback for liquidity planning and ROI for overall efficiency. A project can have a longer payback but still deliver strong lifetime value when savings persist and grow with utility prices.

Discounting and the meaning of NPV

NPV discounts future cash flows at your chosen rate to reflect risk and opportunity cost. Positive NPV means the retrofit beats that required return. If two projects have similar payback, the one with higher NPV usually provides more value over time. IRR is the break-even discount rate where NPV equals zero, useful for comparing against hurdle rates.

Financing effects on annual results

Enabling financing changes timing, not physical savings. A loan reduces initial cash outlay but adds annual payments for the term, which can lower early cash flow and delay payback. If incentives cover a portion of cost, financing the remaining net cost can improve feasibility while keeping the analysis focused on real savings drivers.

Using the model for decisions

Treat inputs as scenarios. Start with conservative year-one savings, then test a higher savings growth rate to reflect energy escalation. Adjust discount rate to reflect stakeholder risk tolerance. Use the year-by-year table and the graph to spot years with weak cash flow and decide whether to phase measures or pursue additional incentives. When reviewing results, compare NPV per dollar invested and confirm payback aligns with planned ownership period, maintenance cycles, and comfort or carbon goals. for balanced business decisions.

FAQs

What is a deep retrofit in this context?

A deep retrofit is a major package of upgrades that significantly reduces building energy use, often combining envelope improvements, equipment replacement, controls, and commissioning to lock in durable savings.

Which savings should I include?

Include cash savings you can verify, such as reduced utility bills and lower maintenance contracts. Avoid double counting. If savings depend on behavior, use conservative numbers and test scenarios.

How should I choose the discount rate?

Use the return you require for similar risk. Public projects may use lower social rates, while private owners often use higher hurdle rates. Keep the rate consistent with how you model savings growth.

Why might IRR show as not available?

IRR requires cash flows that change sign and cross zero in a way that creates a valid root. If the pattern is unusual, NPV and payback are more reliable summaries.

Does financing improve ROI?

Financing can reduce upfront cash but adds debt service. ROI on cash outlay may look different, yet project economics still depend on savings versus total costs. Review NPV and the cash flow chart for timing impacts.

What if payback is not reached within the period?

That means cumulative cash flow stays negative by the end of the analysis horizon. Extend the period, increase residual value, or revisit savings and incentives. If NPV is still positive, it can remain attractive long term.