Heat Pump Payback & ROI Calculator from 12 Months of Bills
Enter a year of heating bills and monthly average temperatures. The tool runs a heating-degree-day regression on your actual usage, models a proposed heat pump with a temperature-dependent COP curve, and reports estimated annual savings, simple payback, and NPV for the upgrade.
An upgrade-economics estimator for the question "will a heat pump pay for itself" built on your own billing history rather than national averages. Fill in the 12-month billing table with your fuel type (propane, natural gas, fuel oil, or electric), monthly usage in native units, monthly cost, and the average outdoor temperature for each month; summer rows can be marked as baseload so non-heating use (water heating, cooking) is estimated and separated by the regression rather than counted as heating. The tool computes heating degree days from your entered temperatures, runs a linear regression of delivered BTU against HDD to characterize how your home actually responds to weather, and derives your current cost per delivered BTU. You then describe the proposed system: installed cost, rebates or incentives, electric rate, rated capacity at 47 F and 5 F, and a piecewise COP curve. The model re-prices each month of your historical heating load through the heat pump and reports estimated annual savings, simple payback period, and net present value at your chosen discount rate, with KPI tiles and month-by-month comparison charts. All outputs are estimates from your bills and assumptions: constant prices, your entered temperatures rather than official station weather, and no modeling of fuel escalation, maintenance, or financing.
Estimate your design-day BTU/hr load from the same bills before sizing the heat pump
Heat Load from Bills Calculator →Find the outdoor temperature where backup fuel beats the heat pump you are pricing
Mini-Split Efficiency & Cost Calculator →Run cost per BTU and other quick checks on the systems being compared
HVAC System Analyzer →Run the same payback logic on a heat pump water heater
Heat Pump Water Heater ROI Calculator →How It Works
-
Fill In the Billing Table
Enter 12 months of bills: fuel type, usage in native units (gallons, therms, m3, GJ, or kWh), dollar cost, and the average outdoor temperature for each month. The table pre-labels the last 12 months; pull average temperatures from your bills or a weather-history site.
-
Mark Baseload Months
Check the baseload box on summer months where the fuel use was not space heating. The regression uses those rows to estimate a non-heating intercept so water heating and cooking are not counted as savings potential.
-
Set Up the Current System
Enter the efficiency of your existing equipment (AFUE for combustion, or COP for existing electric heat) and the HDD base temperature (65 F is the conventional default). The tool computes HDD per month, regresses delivered BTU against HDD, and shows your home heating slope and current cost per delivered BTU.
-
Describe the Proposed Heat Pump
Enter installed cost, any rebate or incentive, your electric rate, the rated capacity at 47 F and 5 F, the COP curve points, and your discount rate. These come straight off the equipment submittal and the quote.
-
Read the Verdict
KPI tiles show estimated annual savings, simple payback in years, and NPV over the analysis horizon. The charts compare current versus projected monthly cost so you can see which months carry the savings and where backup heat would still run.
-
Share or Export
Share links encode the entire billing table and proposal for a second opinion, and PDF export produces a report with inputs, regression results, and the savings analysis.
Built For
- A propane-heated homeowner with a $14,000 cold-climate heat pump quote checking whether the projected savings justify the spend
- Comparing two quotes with different equipment by swapping capacity and COP inputs and watching payback and NPV move
- Checking how much of the heat pump case survives if electric rates rise 20 percent, by re-running with adjusted prices
- An energy auditor producing a quick bills-based savings estimate for a client before recommending a full assessment
- A homeowner with electric resistance baseboard estimating savings from a mini-split conversion, where paybacks are typically shortest
Features & Capabilities
HDD Regression on Your Actual Bills
Instead of assuming a typical home, the tool regresses your delivered BTU against heating degree days computed from your entered monthly temperatures, so the savings model reflects how your specific building responds to cold weather.
Baseload Separation
Months you mark as baseload anchor a regression intercept for non-heating fuel use, preventing water heating and cooking from being silently counted as space-heating savings.
Temperature-Dependent Heat Pump Model
The proposed system uses rated capacity at 47 F and 5 F with a piecewise COP curve, so cold months are priced at cold-weather efficiency instead of a single fixed COP, which is the mistake that makes most online heat pump savings claims optimistic.
Three Verdict Metrics
Estimated annual savings in dollars, simple payback period on the net installed cost after rebates, and NPV at your discount rate, because a 9-year payback reads differently at 2 percent and 8 percent discount rates.
Multi-Fuel and Multi-Unit Input
Propane, natural gas (therms, cubic meters, or GJ), fuel oil, and electric, each converted with standard heat contents, so US and Canadian bills both work.
Month-by-Month Comparison Charts
Current versus projected cost charted by month shows where the savings live and which months a backup fuel would still carry load.
Share Links and PDF Export
The full billing table and proposal encode into a share URL, and the PDF report packages inputs, regression results, and the savings verdict for the project file.
References
- Array
- Array
- Array
- Array
Frequently Asked Questions
Learn More
Is a Heat Pump Worth It?
How to figure out if a mini-split or heat pump will save you money. COP curves, switchover temperatures, when propane wins, and how to run the numbers with your actual bills.
How to Analyze Your HVAC System Performance
Seasonal efficiency vs rated efficiency, degree-day analysis, heat load from utility bills, oversizing problems, duct leakage, and when to replace vs repair.
Heat Pump Water Heaters: ROI, Sizing, and Installation Considerations
COP modeling by ambient temperature, first-hour delivery rates, space interaction effects, IRA 25C tax credits, break-even fuel cost analysis, and installation requirements for heat pump water heaters.
Related Tools
Mini-Split Efficiency & Cost Calculator
Is your mini-split cheaper than propane right now? Enter your electric rate and fuel prices to find the exact outdoor temperature where your heat pump stops saving money and your backup heat wins.
Heat Load from Bills Calculator
What size furnace or heat pump do you actually need? Skip the $300 Manual J - estimate your home's BTU/hr heat load from your gas, propane, or electric bills. See how your home compares by age and climate zone.
HVAC System Analyzer
6 HVAC calculators in one tool: cost per BTU, heat load, ventilation/ACH, switchover temp, duct sizing, and room CFM balancing. Built for technicians, contractors, and serious DIYers.