Calculator inputs
Example scenarios
These examples illustrate how inputs change payback and value. Replace them with your own numbers for accuracy.
| Scenario | Upfront/Down | Year 1 savings | Resale year | Resale uplift | NPV (10y) |
|---|---|---|---|---|---|
| Basic upgrade (cash) | $1,650 | $260 | 5 | $700 | $640 |
| Insulated door (cash) | $2,150 | $420 | 7 | $1,200 | $1,480 |
| Financed upgrade (loan) | $300 | $260 | 5 | $900 | $520 |
Formula used
Initial outlay
- Cash: (Purchase + Installation + Fees − Rebates)
- Financed: (Down payment + Fees). Loan principal = (Purchase + Installation − Rebates − Down payment)
Yearly gross savings (Year t)
GrossSavingst = [(CurrentRepairs − NewRepairs) + EnergySavings + InsuranceDiscount] × (1 + Inflation)t−1
Loan payment (monthly)
Payment = r×PV ÷ (1 − (1 + r)−n) where r = APR/12, PV = loan principal, n = term months.
Net cash flow (Year t)
NetCFt = GrossSavingst − LoanPaymentst + ResaleUpliftt
Net present value
NPV = Σ NetCFt ÷ (1 + DiscountRate)t, including Year 0 outlay.
How to use this calculator
- Enter your expected purchase, installation, and any rebates.
- Add your current yearly repair cost and expected repair cost after replacement.
- Optional: include yearly energy savings and any insurance discount.
- Choose cash or financing, then fill loan details if applicable.
- Set the analysis period and discount rate for time-value comparisons.
- Optional: set a resale year and value uplift to model exit value.
- Click Calculate savings. Results appear above the form.
- Use Download CSV or Download PDF for reporting.
Input assumptions that drive savings
Start with three cash components: purchase, installation, and rebates. If your total project cost is 1,850 and rebates are 100, the net price becomes 1,750. Savings usually come from lower repair spending, improved insulation, and reduced drafts. The model lets you separate current yearly repairs from expected repairs after replacement, so you can quantify the maintenance gap directly.
Financing and cash timing
Financing changes when cash leaves your pocket, not only how much. A 1,450 loan at 9.5% APR for 36 months creates a monthly payment using the standard amortization formula. Adding an extra 10 each month shortens payoff in real life; here it is treated as higher monthly payments, which reduces early-year net cash flow but can improve cumulative savings sooner.
Resale uplift and exit value
If you expect to sell in year 5, you can model a resale uplift, such as 900, to reflect marketability and curb appeal. Optionally apply appreciation to that uplift; for example, 2% growth over four years increases 900 to about 973. The uplift is added only in the resale year, keeping yearly operating savings and exit value clearly separated.
Interpreting payback and NPV
Payback is the first year when cumulative net turns positive; it answers “when do I recover my cash?” NPV answers “is it worth it at my required return?” With a 7% discount rate, earlier savings are valued more than later savings. A positive NPV means the upgrade beats your hurdle rate under the chosen assumptions.
Scenario planning and sensitivity checks
Run conservative, expected, and optimistic cases. Increase new repairs, lower energy savings, and delay resale to stress-test outcomes. Then raise energy savings and resale uplift to see upside. Watch the chart: if yearly net bars stay negative for several years, financing terms or upfront cost may be too heavy for the expected operating savings. As a rule, test discount rates at 5%, 7%, and 10% to understand how time value shifts your decision today materially.
FAQs
What does “gross savings” include?
Gross savings combines repair reduction, energy savings, and any insurance discount. It is inflated each year using your inflation rate, before subtracting loan payments or adding resale uplift.
Why is Year 0 negative?
Year 0 represents the cash you spend today. For cash purchases it includes project cost minus rebates. For financed purchases it includes down payment and fees, while the remaining cost is repaid over time.
How is payback calculated?
The calculator tracks cumulative net cash flow each year. Payback is when the cumulative total first becomes positive. If it never turns positive within your analysis period, payback is reported as not reached.
What discount rate should I use?
Use a rate that matches your opportunity cost or required return. Many homeowners test 5% to 10%. Higher discount rates reduce the value of later savings, lowering NPV and sometimes changing the decision.
Does extra monthly payment change interest savings?
Extra payments are modeled as a higher monthly outflow, which accelerates principal payoff in practice. Because the model does not compute full amortization schedules, treat results as directional and compare scenarios consistently.
How should I estimate resale uplift?
Use recent comparable sales, a contractor’s value perspective, or a conservative range. If uncertain, set uplift to zero and rerun with a modest value in the expected resale year to see how sensitive NPV becomes.