Ceiling Fan Replacement Calculator

This calculator weighs keeping your ceiling fans against replacing them. Pick the old fan from the ENERGY STAR lists or enter its watts, pick the new fan, and enter how many fans, how many hours a day they run, the speed and what you pay for electricity. It works out each fan's yearly energy use and cost, the yearly saving, the net cost of the new fans, the paybacks, and the cost over the years you choose of keeping the old fans, replacing them now, or replacing them when they wear out.

Fan figures come from federal sources only: the ENERGY STAR certified and historical lists published by the EPA, and the DOE test procedure. Default electricity prices come from the EIA. You set the price of the new fan; the opening example uses an illustrative one, not a quote or a current price.

Purpose and model boundary

This calculator compares two ways forward for ceiling fans: keep the fans you have, or replace them with new ones. It takes each fan's power at the speed you use and its standby power, multiplies by the hours a day it runs and the number of fans, prices that at your electricity rate, and sets the yearly saving against what the new fans cost installed. Over the number of years you choose, it compares keeping them, replacing them now and, when you say how many years the old fans have left, replacing them when they wear out.

Every figure on this page is computed by the spreadsheet; the page adds nothing to it. The model covers running cost and purchase cost only. It does not judge performance, noise, size or reliability, and it does not price financing, warranties or your own time.

Inputs and units

• The old fan, described in one of three ways:
  • a model from the ENERGY STAR Version 3 list (fans qualified from 2011 to 2018);
  • a model from the current ENERGY STAR list;
  • manual entry: its power in watts at the speed you use, and optionally its standby power.
• For a listed fan, pick the model from its list. Each entry reads "Brand | Model number", exactly as ENERGY STAR lists it; the product type (standard, hugger or high-speed small-diameter, with or without a light kit) is shown on the model card.
• The new fan: a model from the current ENERGY STAR list, or manual entry, and its price per fan, more than $0 and at most $5,000. The price is always yours to set; the examples use round illustrative prices, not quotes.
• Use: the number of fans (1 to 20), the hours a day they run (0 to 24; the default, 6.4, is the DOE test basis) and the speed: low, high, or the DOE test average.
• Electricity price, optional: the state, which sets the default price, or your own price in dollars per kWh.
• Purchase and upkeep: installation, removal and disposal of the old fans, sales tax on the price, verified rebates, the sale value of the old fans, and yearly upkeep. Each is optional and counts as zero when left blank.
• The comparison: the years to compare (1 to 30), the yearly change in electricity prices, the discount rate, and, optionally, the years the old fans have left and the expected life of the new ones.

Power is in watts, energy in kWh a year and money in dollars.

Governing relationships

Energy. Each fan uses its power at the chosen speed for the hours it runs and its standby power for the rest of the day: yearly kWh = fans × (watts × hours + standby watts × (24 − hours)) × 365 ÷ 1000. Light kits are not counted; lighting belongs to the LED conversion calculator.

The DOE test average. DOE's test procedure (Appendix U) runs a standard or hugger fan 3.4 hours a day at high speed and 3.0 hours at low speed, 6.4 hours in all, with 17.6 hours in standby. The test-average power is (3.4 × high-speed watts + 3.0 × low-speed watts) ÷ 6.4; for a single-speed fan it is its high-speed power.

Watts are the comparable figure. The current list rates efficiency as a weighted CFM per watt under DOE Appendix U, the Version 3 list as CFM per watt by speed under an older method; the two efficiencies are not comparable, but the power at low and high speed is. Version 3 fans report no standby power, which then counts as zero.

Yearly cost. For each ceiling fan, the yearly running cost is its yearly kWh times the electricity price; adding yearly upkeep gives its yearly cost, and the yearly saving is the old ceiling fan's yearly cost less the new one's.

Electricity price. Your own price, when you enter one, is used; otherwise the average residential price for the state you choose.

Purchase cost. The capital cost is the price × (1 + sales tax rate) + installation − rebates. The net initial cost adds removal and disposal and takes off the old unit's sale value.

Payback. Simple payback is the net initial cost ÷ the first year's saving, when the saving is positive; otherwise there is no payback. Discounted payback is the first year in which the cumulative discounted net benefit of replacing now reaches zero within the years compared.

The three paths over the years compared. Electricity prices change each year by the rate you enter; upkeep stays flat; costs fall at the end of each year and are discounted at your rate.

• Keep: the old unit's yearly cost every year.
• Replace now: the net initial cost today, then the new unit's yearly cost, less the value left in the new unit at the end.
• Replace at end of life (when you enter the years the old unit has left and they are fewer than the years compared): the old unit's yearly cost until it fails, then the capital cost and disposal in that year, then the new unit's yearly cost, less the value left in the new unit at the end.

The value left in the new unit at the end is its capital cost × the share of its expected life still remaining, on a straight line; with no expected life entered, no value is counted. The net present value of replacing now is the present cost of keeping less the present cost of replacing now: positive means replacing now costs less.

Calculation sequence

The spreadsheet first finds each unit's rated figure from the list, the federal standard for the year made or your entries, and checks the inputs. It then reduces each unit to a yearly energy figure that scales with your use, and from it computes the yearly kWh, the yearly costs and the saving. The purchase cost, the paybacks, the present values of the three paths and the year-by-year cash flow follow. The sensitivity table uses the same per-unit figures, so it cannot disagree with the main result. A block of consistency checks, including that the discounted cash flow reaches the same net present value as the closed-form formula, runs before the status is returned.

Outputs and interpretation

The headline is the yearly saving from replacing the old ceiling fan, with the simple payback and the net present value of replacing now. For each unit the results give its rated figure, its yearly kWh, and its yearly energy, upkeep and total cost, with the electricity price actually used and a note on where it came from. The decision results give the net initial cost, the discounted payback year, the total and present cost of keeping, of replacing now and of replacing at end of life, and a plain verdict on each.

The cash-flow table shows each year from 0 to 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 at 1, 2, 4, 6, 8, 12, 16 and 24 hours a day, and at 0.5, 0.75, 1, 1.25 and 1.5 times the electricity price used.

A model card beside each pick shows the fan's product type, blade span, its power at low and high speed and in standby, its weighted efficiency and the year it was listed or became available.

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 Electricity and Upkeep by unit, 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 source that is not one of its options; a listed model that is not in its list; manual watts missing or not above 0 and at most 500; a manual standby outside 0 to 10 watts or an upkeep figure outside 0 to $5,000 a year; hours a day outside 0 to 24, a fan count that is not a whole number from 1 to 20, a speed that is not one of its options, or a speed whose power is not published for the listed fan (low speed, or the DOE test average, for a two-speed fan with no low-speed figure); no electricity price, or your own price outside $0.01 to $2.00 per kWh; a price for the new fan that is missing, not above $0 or above $5,000; another money or rate input outside its range; years to compare that are not a whole number from 1 to 30, or a growth or discount rate outside its range; years left that are not a whole number from 0 to 30, or an expected life that is not a whole number from 1 to 40. 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: zero hours a day; a new unit that does not cost less to run than the old one at your use, so there is no payback; or an old unit with fewer years left than the years compared, so the end-of-life path is the realistic one.
• OK otherwise.

Assumptions and limitations

• 6.4 hours a day is the test basis, not your use. Your use enters through the hours and the speed you set.
• Light kits are left out. The fan's lighting power is listed separately and is not counted here.
• The historical list is a snapshot. It holds the Version 3 fans qualified from 2011 to 2018; older fans and fans never certified have no federal record and are entered manually. No federal limit on a fan's wattage exists, so there is no year-made route.
• Expected life. No federal lifetime for ceiling fans was found; enter the new fans' expected life if you want the value left in them at the end to count.
• The default electricity price is an average. It is the EIA's annual average residential price for the state, not your tariff. Enter your own price from your bill for a better answer.
• One price change rate applies to electricity in every year. The future purchase in the end-of-life path is priced at today's price.
• There is no loan, no depreciation other than the value left in the new unit at the end, and no resale other than the old unit's sale value when it is replaced now.

Data and vintage

The model lists and the federal standards are reviewed reference tables inside the workbook, refreshed from their federal publishers; their version is shown in the result details.

• Current models: the ENERGY STAR certified ceiling fans dataset (EPA), Version 4.0, 1,458 records downloaded 2026-10-28. Where a model is listed more than once, the most recent listing is used; one listing with an implausible 4,425 W is left out.
• Historical models: the ENERGY STAR Version 3 list, 400 fans qualified from 2011 to 2018, downloaded 2026-10-28.
• Default electricity prices: EIA 2025 annual average residential electricity prices by state (Form EIA-861).

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 model that is not in its list, a manual fan with no wattage and a missing price for the new fan 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 unit's EnergyGuide label or nameplate and your own bills before relying on a result for a purchase.

Sources and further reading

The calculator reads its model lists, its federal limits and its default electricity prices from reviewed reference tables inside the workbook, by record, 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.

• ENERGY STAR Certified Ceiling Fans (EPA) lists currently certified ceiling fans with their power at low and high speed and in standby (retrieved 2026-10-28).
• ENERGY STAR, Ceiling fans: information for partners (EPA) links the last Version 3 list, posted before Version 4 took effect in 2018 (retrieved 2026-10-28).
• DOE test procedures, 10 CFR 430 Subpart B (eCFR), whose Appendix U runs a fan 3.4 hours a day at high speed and 3.0 hours at low speed (retrieved 2026-10-28).
• DOE energy conservation standards, 10 CFR 430.32 (eCFR) sets the federal design requirements for ceiling fans and, from 2020, their minimum efficiency (430.32(s)); it sets no limit on wattage (retrieved 2026-10-28).
• EIA, Detailed state data (Form EIA-861) gives the average residential electricity price by state, used here for 2025 (retrieved 2026-10-28).

This is an educational estimate of running and purchase costs for the units and prices you enter, not a product recommendation or a quote. The ENERGY STAR lists show each model's rated use under the DOE test procedure, not your unit's measured use.