Home And Transportation Savings

Resistance Heat To Heat Pump Calculator

Compare keeping your electric baseboards or electric furnace with switching to a heat pump: yearly electricity, running cost, payback, and the cost over the years you choose. Estimates for planning, not financial advice.

Last updated

How to Use the Resistance Heat to Heat Pump Calculator: Keep Baseboards or Switch?

Plays from YouTube. Close the video to keep working on your drawing.

Calculator overview

Inputs and outputs

This summary comes from the calculator's published input and output contract.

Inputs

H04 New Source (required)
About this input

Pick a currently certified ENERGY STAR model by its outdoor unit, or type the HSPF2 from the AHRI certificate your contractor gives you.

Default Model from current ENERGY STAR list Allowed Model from current ENERGY STAR list, Manual entry (AHRI certificate)
H04 New Type (required)
About this input

Ducted split (uses ducts), ductless mini or multi-split, or single package. It chooses which model list is shown.

Default Ducted split Allowed Ducted split, Ductless mini/multi-split, Single package
H04 Old Heating KWh (required)
About this input

The electricity your baseboards or electric furnace use for heating in a year: your winter bills minus the use of a month without heating, for example. It must be more than 0; it is the baseline the heating load is worked out from.

Unit kWh/yr Default 10000 Range 0 to 100000
H04 New Model Mini (required) Conditional
About this input

Brand and outdoor unit model as listed by ENERGY STAR (ductless mini and multi-split). The lowest HSPF2 of its certified combinations is used.

Default 1HVAC | ACIQ-06ZPL-HP230B Allowed 1HVAC | ACIQ-06ZPL-HP230B, 1HVAC | ACIQ-06ZPL-HP230C, 1HVAC | ACIQ-09Z-HP115B, 1HVAC | ACIQ-09Z-HP115C, 1HVAC | ACIQ-09Z-HP230C, 1HVAC | ACIQ-09ZPL-HP230B, 1HVAC | ACIQ-09ZPL-HP230C, 1HVAC | ACIQ-09ZS-HP115C, 1HVAC | ACIQ-09ZS-HP230C, 1HVAC | ACIQ-12ZPL-HP230B, and 7,091 more (the calculator lists them all)
H04 New Model Pkg (required) Conditional
About this input

Brand and model as listed by ENERGY STAR (single package). The lowest HSPF2 of its certified combinations is used.

Default 1HVAC | ACIQ-PHH1748000K000V Allowed 1HVAC | ACIQ-PHH1748000K000V, 1HVAC | ACIQ-PHH1760000K000V, AC PRO | AK-H04TC/NAA-T(U), AC PRO | AK-H05TC/NAA-T(U), AC PRO | PKHP-X-024VBC, AC PRO | PKHP-X-036VBC, AC PRO | PKHP-X-048VBC, AC PRO | PKHP-X-060VBC, ACIQ | ACIQ-PHH1748000K000V, ACIQ | ACIQ-PHH1760000K000V, and 820 more (the calculator lists them all)
H04 New Model Split (required) Conditional
About this input

Brand and outdoor unit model as listed by ENERGY STAR. The lowest HSPF2 of its certified combinations is used.

Default Carrier | D5CURAH36AAK Allowed 1HVAC | ACIQ-12-EHPB, 1HVAC | ACIQ-12-EHPD, 1HVAC | ACIQ-18-EHPD, 1HVAC | ACIQ-18-HPB, 1HVAC | ACIQ-18-HPD, 1HVAC | ACIQ-18ZPL-HP230B, 1HVAC | ACIQ-24-EHPB, 1HVAC | ACIQ-24-EHPD, 1HVAC | ACIQ-24-HP32, 1HVAC | ACIQ-24-HPB, and 4,581 more (the calculator lists them all)
H04 Rate Growth (required)
About this input

Applied to electricity and gas prices alike. 0% means flat prices.

Default 0.02 Range -0.1 to 0.15
H04 Sales Tax Rate
When omitted Blank
About this input

Applied to the installed price only.

Default Not set Range 0 to 0.15
H04 State (required)
About this input

USPS state code, or US for the national average. It sets the default electricity price (a state average, not your tariff) and the climate used by the two climate checks.

Default US Allowed AK, AL, AR, AZ, CA, CO, CT, DC, DE, FL, GA, HI, IA, ID, IL, IN, KS, KY, LA, MA, MD, ME, MI, MN, MO, MS, MT, NC, ND, NE, NH, NJ, NM, NV, NY, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VA, VT, WA, WI, WV, WY, US
H04 Old Maintenance
When omitted Blank
About this input

Service or repairs you expect each year if you keep the resistance heat.

Unit $/yr Default Not set Range 0 to 5000
H04 Old Remaining Life
When omitted Blank
About this input

Fills the replace-at-end-of-life comparison. Blank skips it.

Unit years Default Not set Range 0 to 30
H04 Old Sale Value
When omitted Blank
About this input

Money you receive for the old system if you replace it now.

Unit $ Default Not set Range 0 to 5000
H04 New Manual HSPF2 (required) Conditional
About this input

The heating seasonal performance factor (HSPF2, 2023 test basis) of the matched system. Never an older HSPF figure.

Unit Btu/Wh Default 8 Range 5 to 20
H04 Disposal
When omitted Blank
About this input

Removal or capping charge, if not in the quote.

Unit $ Default Not set Range 0 to 5000
H04 Electricity Rate Override
When omitted Blank
About this input

From your bill. Overrides the state average.

Unit $/kWh Default Not set Range 0.01 to 2
H04 Extra Work
When omitted Blank
About this input

Work beyond the installed price, if your quote lists it separately.

Unit $ Default Not set Range 0 to 50000
H04 Backup Share (required) Conditional
About this input

The extra share of the yearly heat the backup supplies. Read only when a backup is chosen.

Default 0.1 Range 0 to 1
H04 Backup Type (required)
About this input

HSPF2 already includes the backup heat of a moderate climate. Choose a backup only for extra heat in a colder climate: keeping your baseboards (electric resistance).

Default None beyond the rating Allowed None beyond the rating, Electric resistance (keep the baseboards)
H04 Discount Rate (required)
About this input

The yearly return you could earn on the money instead. 0% means no discounting.

Default 0.03 Range 0 to 0.2
H04 New Expected Life
When omitted Blank
About this input

Used only for the value left in the heat pump at the end of the period (straight line). Blank counts no value left: no lifetime is sourced for this app.

Unit years Default Not set Range 1 to 40
H04 New Installed Price (required)
About this input

The installed price of the heat pump job, from your contractor's quote. The calculator never looks up a price. Illustrative price for this example, not a quote or a current price. Prices vary: check current prices online or enter your own. Get a contractor quote.

Unit $ Default 12000 Range 1 to 60000
H04 New Maintenance
When omitted Blank
About this input

Service you expect each year for the heat pump.

Unit $/yr Default Not set Range 0 to 5000
H04 Horizon Years (required)
About this input

The comparison period, 1 to 30 whole years.

Unit years Default 15 Range 1 to 30
H04 HP Seasonal COP Override
When omitted Blank
About this input

A seasonal coefficient of performance for your climate, if your contractor states one. It replaces the HSPF2 rating, which assumes a moderate climate.

Unit W/W Default Not set Range 1 to 6
H04 Incentives
When omitted Blank
About this input

Only incentives you have confirmed you qualify for.

Unit $ Default Not set Range 0 to 5000

Outputs

H04 Old Seasonal COP Used
About this output

Old resistance heat: The seasonal coefficient of performance in the sums: 1.0 for resistance heat; for the heat pump your COP, or HSPF2 x 1000 / 3,412.

Unit W/W
H04 Old Model Card
About this output

Old resistance heat: The system as the calculator reads it: the resistance heat's yearly kWh, or the heat pump's model, HSPF2, capacities and record.

No unit declared
H04 PV Keep
About this output

Present value of keeping the resistance heat at the discount rate.

Unit $
H04 PV Replace Now
About this output

Present value of replacing now at the discount rate.

Unit $
H04 PV Replace End Of Life
About this output

Present value of replacing when the resistance heat fails. Blank when not evaluated.

Unit $
H04 Old Annual Heating KWh
About this output

Old resistance heat: Electricity used to heat: the resistance heat, or the heat pump and any electric backup.

Unit kWh/yr
H04 Old Annual Energy Cost
About this output

Old resistance heat: Electricity cost in year 1.

Unit $/yr
H04 Old Annual KWh
About this output

Old resistance heat: All electricity in the comparison (heating only in this app).

Unit kWh/yr
H04 Old Eff Heating Used
About this output

Old resistance heat: The heat pump's HSPF2: the lowest certified combination, your AHRI figure, or your seasonal COP as an HSPF2 equivalent. Blank for resistance heat.

Unit Btu/Wh
H04 Old Annual Total Cost
About this output

Old resistance heat: Energy cost plus upkeep in year 1.

Unit $/yr
H04 Rating Note
About this output

Which heat pump rating is used: the lowest certified combination, your AHRI figure, or your seasonal COP.

No unit declared
H04 Total Keep
About this output

Running cost of keeping the resistance heat over the years compared, without discounting.

Unit $
H04 Status Code
About this output

The deciding reason of the status line as a short code, OK when nothing applies.

No unit declared
H04 Total Replace End Of Life
About this output

Keep the resistance heat until it fails, then install the heat pump at today's price. Blank when no remaining life below the period is given.

Unit $
Model Status
About this output

OK, CHECK with a reason to read, or NOT VALID with what to fix.

No unit declared
H04 Total Replace Now
About this output

Net initial cost plus the heat pump's running cost over the years compared, less any value left at the end, without discounting.

Unit $
H04 Self Check
About this output

Whether the model's internal consistency checks hold.

No unit declared
H04 Replace Now Verdict
About this output

The comparison of replacing now with keeping, in words.

No unit declared
H04 Sensitivity Savings
About this output

Money saved in year 1 for 50% to 150% of the heating load (rows) and 50% to 150% of the electricity price used (columns).

No unit declared
H04 Simple Payback Years
About this output

Net initial cost divided by the money saved in year 1. Blank when nothing is saved or the price is missing.

Unit years
H04 Simple Payback Text
About this output

The simple payback in words: the years, no payback, or a missing price.

No unit declared
H04 Discounted Payback Year
About this output

The first year in which the cumulative discounted net benefit of replacing now reaches zero. Blank when it does not within the years compared.

Unit year
H04 Discounted Payback Text
About this output

The discounted payback in words.

No unit declared
H04 Electricity Rate Note
About this output

Where the electricity price comes from: the EIA state average and its year, or your own price.

No unit declared
H04 End Of Life Verdict
About this output

The comparison of replacing now with waiting until the resistance heat fails, in words.

No unit declared
H04 Electricity Rate Used
About this output

The electricity price in the sums: your own, or the state average.

Unit $/kWh
H04 Annual Savings USD
About this output

Old minus new running cost in year 1; negative means the heat pump costs more to run.

Unit $/yr
H04 Annual KWh Change
About this output

Old minus new electricity a year: the electricity the heat pump saves.

Unit kWh/yr
H04 Cash Flow
About this output

Year-by-year costs of keeping, replacing now and replacing at end of life, the net benefit of replacing now, and its cumulative and discounted values. Rows past the years compared are blank.

No unit declared
H04 Data Vintage Note
About this output

The sources and their dates.

No unit declared
H04 Climate HDD Used
About this output

Your state's yearly heating degree day normal (NOAA 1991-2020), used only by the two climate checks.

Unit deg F-day
H04 Heating Load MMBtu
About this output

Heat the home needs in a year, worked out from your heating kWh (resistance heat delivers all its electricity as heat). Old and new deliver the same heat.

Unit MMBtu/yr
H04 New Eff Heating Used
About this output

Heat pump: The heat pump's HSPF2: the lowest certified combination, your AHRI figure, or your seasonal COP as an HSPF2 equivalent. Blank for resistance heat.

Unit Btu/Wh
H04 New Annual Total Cost
About this output

Heat pump: Energy cost plus upkeep in year 1.

Unit $/yr
H04 New Model Card
About this output

Heat pump: The system as the calculator reads it: the resistance heat's yearly kWh, or the heat pump's model, HSPF2, capacities and record.

No unit declared
H04 NPV Replace Now
About this output

Present value of keeping minus that of replacing now; positive means replacing now costs less.

Unit $
H04 New Seasonal COP Used
About this output

Heat pump: The seasonal coefficient of performance in the sums: 1.0 for resistance heat; for the heat pump your COP, or HSPF2 x 1000 / 3,412.

Unit W/W
H04 Net Initial Cost
About this output

Installed price, sales tax and extra work, less incentives, plus removal, less the old system's sale value.

Unit $
H04 Load Basis Note
About this output

How the heating load is worked out: from your heating kWh, with resistance heat delivering all of it as heat.

No unit declared
H04 New Annual Energy Cost
About this output

Heat pump: Electricity cost in year 1.

Unit $/yr
H04 New Annual KWh
About this output

Heat pump: All electricity in the comparison (heating only in this app).

Unit kWh/yr
H04 New Annual Heating KWh
About this output

Heat pump: Electricity used to heat: the resistance heat, or the heat pump and any electric backup.

Unit kWh/yr
This page is provided by LogicCommons for informational purposes only. Results are model outputs computed from the inputs you supply and are not financial, investment, tax, accounting, or legal advice, and no advisory relationship is created. Verify all inputs and results independently before relying on them in any decision.

LogicCommons is in beta. If a result, label, or reference looks wrong, tell us here; we read every message.

What it is

This calculator weighs keeping your electric resistance heat against replacing it with a heat pump. Enter the electricity you use for heating in a year, pick the new heat pump from the ENERGY STAR list or enter its HSPF2, and choose whether to keep your old heaters as backup. It works out the heat your home needs, each system's yearly electricity use and cost, the yearly saving, the net cost of the heat pump, the simple and discounted payback, and the cost over the years you choose of keeping the old system, replacing it now, or replacing it when it wears out.

Equipment and climate figures come from federal sources only: ENERGY STAR (EPA), DOE standards and test procedures, NOAA climate normals and EIA electricity prices. You set the installed price; the opening example and each worked example carry a round illustrative price, labelled as such.

Methodology

Purpose and model boundary

This calculator compares two ways to heat a home with electricity: keep your electric resistance heat (baseboards, wall heaters or an electric furnace), or replace it with a heat pump. It turns the electricity you use for heating into the heat your home received, works out the electricity a heat pump needs to deliver the same heat, prices both at your electricity price, and sets the yearly saving against what the heat pump costs installed. Over the number of years you choose, it compares keeping the old system, replacing it now and, when you say how many years the old system has left, replacing it when it wears out.

Every figure on this page is computed by the spreadsheet; the page adds nothing to it. It covers the running cost of space heating and the purchase cost only. Cooling from the new heat pump is not credited, and adding ducts or ductless units is not modelled.

Inputs and units

  • Your heating electricity: the electricity you use for heating in a year, in kWh. From your bills, take the winter months' use minus your typical use in months with no heating.
  • The new heat pump: choose its type (ducted split, ductless mini or multi-split, or single package), then the model from that type's ENERGY STAR list, where each entry reads "Brand | Outdoor model"; or enter the HSPF2 from its AHRI certificate. You may also enter your contractor's seasonal COP, from 1.00 to 6.00, which then replaces the rating.
  • Backup heat: none beyond the rating, or keeping the existing resistance heaters as backup, with the share of the year's heat they supply, from 0 to 1.
  • Price: the state, which sets the default electricity price, and your own electricity price in dollars per kWh (0.01 to 2.00), optional.
  • Purchase and finance: the installed price of the heat pump, which is always yours to set; extra work such as permits, electrical or duct work; sales tax; verified incentives; removal; the old system's sale value; yearly upkeep of each system; the years the old system has left; the new system's expected life; the yearly change in electricity prices; the discount rate; and the years to compare.

Heating and cooling needs are in million Btu (MMBtu) a year of heat delivered or removed. Electricity is in kWh, fuel in US gallons or therms, efficiency ratings in Btu per watt-hour (CEER, SEER2, HSPF2) or as a fraction (AFUE), and money in dollars.

Governing relationships

  • Heat delivered by the old system = heating kWh x 3,412 Btu per kWh: resistance heat turns all of its electricity into heat in the home.
  • Heat-pump electricity = heat needed / (seasonal COP x 3,412 Btu per kWh). The seasonal COP is HSPF2 x 1000 / 3,412 unless you enter your own, so HSPF2 and COP give the same kWh for the same heat.
  • Backup heat: HSPF2 already includes the electric resistance heat a heat pump needs in DOE's moderate rating climate (Region IV), so the backup share is extra heat beyond that, supplied by your resistance heaters at 3,412 Btu per kWh.
  • Yearly cost = electricity x electricity price + upkeep. The yearly saving is the old cost minus the new cost.
  • Payback and present value follow the rules shared with the other replacement calculators: a simple payback only when the yearly saving is positive, and the costs of keeping, replacing now and replacing at the end of life discounted over the years you compare, with nothing counted twice.

Calculation sequence

The spreadsheet first checks the inputs and finds the heat pump's rating and the electricity price. It turns your heating electricity into the heat your home needed, reduces each system to the electricity it uses per million Btu of heat, and from those computes the yearly electricity, costs and saving; the purchase cost, the paybacks, the present values and the year-by-year cash flow follow. The sensitivity table uses the same per-MMBtu figures, so it cannot disagree with the main result. Consistency checks, including that your heating electricity is reproduced from the computed heat and that the discounted cash flow reaches the same net present value as the closed-form formula, run before the status is returned.

Outputs and interpretation

For each system the results show the heat it delivers, the efficiency used, the yearly electricity and the yearly energy and total cost; then the yearly saving in dollars and in kWh, the net cost of the heat pump, the simple and discounted payback, and the cost of each path.

The cash-flow table shows each year of the years compared: the cost of each path, the net benefit of replacing now, and its cumulative, discounted and cumulative discounted values. The sensitivity table shows the yearly saving with the heat need scaled by 0.50, 0.75, 1.00, 1.25 and 1.50, at the same multiples of the electricity price used.

A model card beside the heat-pump pick shows the range of its ratings across the indoor units it is certified with, whether ENERGY STAR lists it as cold-climate, and its heating capacity. The calculator uses the lowest SEER2 and HSPF2 among those pairings, so it does not credit a better pairing than the one you may buy.

The first chart, “Cumulative net benefit of replacing now, by year”, shows Undiscounted and Discounted by year. The second chart, “Cost over the years compared”, shows Total and Present value by option. The third chart, “Running cost in year 1”, shows Heating electricity, Fuel (none) and Auxiliary electricity and upkeep by system, stacked.

Validation and status logic

The workbook returns one status, chosen in this order: NOT VALID, then CHECK, then OK.

  • NOT VALID names the first problem: a heat-pump choice that is not one of its options, a listed model that is not in its list or does not match the type chosen, or a manual HSPF2 missing or outside 5 to 20; a heating electricity figure missing or outside its limits; a backup choice that is not one of its options, or a backup share outside 0 to 1; a seasonal COP outside 1.00 to 6.00; no electricity price, or your own outside 0.01 to 2.00 dollars per kWh; a missing installed price, or one outside its limits; a money amount, the years compared, the price change, the discount rate or a life in years outside its limits. NOT VALID is a refusal, not a numeric answer: every figure reads zero and is withheld.
  • CHECK accompanies a computed result that needs the stated review: a cold state (6,000 heating degree days or more), a heat pump ENERGY STAR does not list as cold-climate, and no backup heat beyond the rating: the HSPF2 rating assumes a moderate climate, so real seasonal efficiency will be lower; with no backup heat, the heat pump's capacity at your coldest month's average temperature is below that month's average heating load, so you may need a larger model, more units or backup heat; a heating electricity figure of zero; no yearly saving, so there is no payback; the old system's remaining life is shorter than the years compared, so read the end-of-life comparison.
  • OK otherwise.

Assumptions and limitations

  • A heat pump never uses more electricity than resistance heat for the same heat, so the energy saving is never negative. A result with no saving comes from the yearly upkeep you enter for the heat pump, or from your own prices; one worked example shows this with an illustrative service plan.
  • Your heating year is taken as a typical year, and your heating electricity is your estimate from your bills. The calculator does not adjust it for a mild or a harsh winter.
  • Heating only. Cooling from the new heat pump is not credited; if it also replaces an air conditioner, the cooling side belongs to the heat pump upgrade or central air conditioner calculators. Adding ducts or ductless units is not modelled.
  • Inputs with no federal source are your assumptions: the installed price and any backup share beyond the rating. Resistance heat is taken to deliver all its electricity as heat, a design value. The cold-state threshold of 6,000 heating degree days is a design choice that only sets a warning.
  • The size check is lenient by design. A true design load needs a design temperature, and no federal table in this calculator gives one per state. So the check compares the heat pump's capacity at the coldest month's mean temperature, read between its rated capacities at 47 °F and 5 °F, with that month's average heating load, worked out from your own heat use and NOAA's monthly degree-day normals. It warns only when the heat pump cannot meet even that average load and no backup heat is chosen.
  • Alaska, Hawaii and DC. NOAA publishes no statewide degree-day normals for any of the three. DC uses Maryland's figures; Alaska and Hawaii each use one NOAA station normal, at the Anchorage and Honolulu airports, labelled as a single station. No figure in this calculator depends on degree days: only the cold-state and size checks read them, and a check is not evaluated where its figures are missing.
  • Prices. The installed price of the heat pump is always your input; the workbook holds no price table. The opening example and each worked example carry a round illustrative price so that they compute, with the note: "Illustrative price for this example, not a quote or a current price. Prices vary: check current prices online or enter your own. Get a contractor quote."
  • The default electricity price is a state average. Your own price from your bill overrides it.

Data and vintage

  • Heat pumps: the ENERGY STAR certified air-source heat pump list (EPA), current certifications, one entry per outdoor unit sold in the US, each with the lowest SEER2 and HSPF2 among its certified indoor-unit pairings.
  • Climate: NOAA NCEI statewide heating degree-day normals for 1991-2020 (nClimDiv), with the monthly normals for the size check; the US figure covers the 48 contiguous states. NOAA calls these long-term averages rather than official normals, and its notes state neither the base temperature nor the weighting.
  • Default price: EIA final 2025 average residential electricity prices by state (Form EIA-861).
  • Conversion: 3,412 Btu per kWh, EIA's sample conversion factor.

Worked examples and prices

Prices are not part of the reference data: the price of the new unit is an input you set. The opening example and the five worked examples each use an illustrative price for the new unit, so that the example computes, and each says so: “Illustrative price for this example, not a quote or a current price. Prices vary: check current prices online or enter your own.”

Restrictions and non-computing states

The calculator enforces its numeric and choice limits before it accepts a result. A listed model that is not in its list or does not match the type chosen, a rating or quantity outside its limits, a missing installed price, and a missing electricity or fuel price where no default exists are refused by the workbook.

Errors and warnings

A request rejected by the page's input limits is not a computed result. A transport or service failure, a timeout or a cancelled run cannot establish a fresh workbook answer, and the last result stays on the page marked as out of date. Check your equipment's nameplate or AHRI certificate and your own bills before relying on a result for a purchase, and get a contractor quote for the installed price.

References

Sources and further reading

The calculator reads its model lists, its federal minimum ratings, its climate figures and its default energy prices from reviewed reference tables inside the workbook, with their version shown in the result details. Every table comes from a US federal source. The sources below publish the data and the rules the model applies. They do not endorse this calculator.

This is an educational estimate of running and purchase costs for the equipment and prices you enter, not a product recommendation or a quote. Ratings are measured under federal test procedures, not in your home.

Frequently asked questions

How do I find the electricity I use for heating?
From a year of bills, add up the winter months' use and subtract what you use in a typical month with no heating, times the number of winter months. Enter only that heating part, not your whole bill.
Why does a heat pump use so much less electricity?
Resistance heat turns each kWh into 3,412 Btu of heat. A heat pump moves heat from outdoors, so over a season it delivers several times that per kWh: its seasonal COP is its HSPF2 x 1000 / 3,412.
Does the HSPF2 rating hold in a cold winter?
HSPF2 is measured for DOE's moderate rating climate (Region IV) and already includes the electric backup heat needed there. In a colder state real seasonal efficiency is lower: choose a model ENERGY STAR lists as cold-climate, enter your contractor's seasonal COP, or add a backup share. The calculator warns when your state is cold and none of these is set.
Why is the model's rating the lowest of a range?
A split heat pump's rating belongs to the outdoor unit paired with a particular indoor unit, and ENERGY STAR certifies many pairings. The list holds one entry per outdoor unit with the lowest SEER2 and HSPF2 among its pairings, and the model card shows the range. If your contractor quotes a specific pairing, enter its HSPF2 from the AHRI certificate instead.
Results are informational and not professional advice. See our Terms of Use. Powered by SpreadsheetWeb · About · Privacy · Terms