Equipment Replacement Timing Calculator
Finds the economic life of a new machine by minimising equivalent annual cost, then runs the marginal analysis that determines which year to actually retire the one you own. Built for maintenance managers, plant engineers and capital planners who need a defensible replacement year, not just a verdict on whether to replace today.
Download This Calculator
Get the Excel spreadsheet behind this calculator to use offline, customize for your own equipment and hurdle rate, and publish as a web tool using Sheetflow.
A Year, Not A Verdict
Marginal analysis runs the cost of one more year against the challenger's benchmark: $52,500, $52,635, $54,593, $58,177 — all under $63,120 — then $63,278 in year five. Replace at the end of year 4.
Market Value, Not Book Value
The defender's basis is the $50,000 you give up by not selling, not the $95,000 on the depreciation schedule. The calculator runs it both ways so you can see the $45,000 of sunk cost reverse the decision.
The Full Eight-Year Curve
Equivalent annual cost at every life from one to eight years — $77,400 down to a $63,120 minimum at five years, then back up to $66,252 — so you see the U-shape rather than a single number.
Frequently Asked Questions
What is economic life and why is it shorter than useful life?
Economic life is the number of years of ownership that minimises equivalent annual cost. Useful life is how long the machine physically runs. They're rarely the same number, and the economic one is almost always shorter.
Two costs pull in opposite directions as an asset ages. Capital recovery falls: spread the purchase price and lost salvage over more years and the annual bite shrinks. Operating cost rises: maintenance climbs, downtime climbs, efficiency drops. Add them together and you get a U-shaped curve. The bottom of the U is economic life.
The calculator's defaults show the curve directly. A $120,000 machine with operating costs starting at $23,000 and growing 20% a year produces annual costs of $77,400 at a one-year life, falling to $63,120 at five years, then rising again to $66,252 by year eight.
Five years is the economic life. Capital recovery at that point is $30,266 and operating cost is $32,854 — roughly balanced, which is what the minimum of the curve means.
Run it past the minimum and you're paying more per year than you need to, even though the machine still works. That gap between "still functional" and "still economic" is the whole subject, and it's why maintenance departments and finance departments so often disagree about the same asset.
Why is the defender's book value the wrong number to use?
Because book value is a record of the past and the decision is about the future.
The defender's first cost in a replacement study is its current market value — the cash you give up by choosing not to sell it. That's a real, forward-looking opportunity cost. Book value is what depreciation schedules happen to say it's worth, and it has no bearing on anything you can still choose.
The gap between them is the sunk cost. In the calculator's defaults the machine has a $95,000 book value and a $50,000 market value, so $45,000 is sunk — already spent, unrecoverable, and irrelevant.
Here's why it matters more than a definitional quibble. Run the analysis correctly with a $50,000 basis and the defender costs $52,500 a year against the challenger's $63,120 — keep the defender. Run it with the $95,000 book value and the defender's annual cost jumps to $102,900 — replace now.
Same machine, same market, same challenger. The accounting basis reverses the decision.
This is the error the textbooks warn about most loudly, and it has a predictable direction: because book value usually exceeds market value on an ageing asset, using it makes the machine you own look worse than it is and biases you toward buying. Vendors are rarely in a hurry to correct that.
One exception worth knowing: when income tax effects are in scope, the sunk cost does re-enter the analysis, because the loss on disposal has a tax consequence. That's a different and larger computation than this one.
Should I replace the machine now, or in a particular year?
Two different questions, and only the second one is usually what you need.
Comparing the defender's minimum annual cost against the challenger's minimum annual cost answers whether to replace today. At the defaults the defender wins at $52,500 against $63,120, so the verdict is "keep the defender." True, and not very useful — it doesn't tell you when to revisit.
The answer to when comes from marginal analysis: compute the cost of keeping the defender for exactly one more year, and compare that single year against the challenger's minimum annual cost. Keep going while the marginal cost is lower. The rule is that the defender should be kept longer than its apparent economic life as long as its marginal cost stays below the challenger's minimum.
The marginal cost of one more year has three parts: the opportunity cost of not selling now, grown at your hurdle rate, minus what it will be worth a year later, plus that year's operating cost.
| Year kept | Marginal cost of that year | Challenger benchmark | Keep? |
|---|---|---|---|
| 1 | $52,500 | $63,120 | Yes |
| 2 | $52,635 | $63,120 | Yes |
| 3 | $54,593 | $63,120 | Yes |
| 4 | $58,177 | $63,120 | Yes |
| 5 | $63,278 | $63,120 | No — it exceeds the benchmark |
Replace at the end of year 4.
Now look at what the simpler method said. The defender's own economic life is one year. Marginal analysis says keep it four. Three extra years of service that the naive comparison gives no way to see, worth $27,052 in present value terms.
Why is the defender's economic life often just one year?
Because most of its value has already been lost, so there's very little capital recovery left to spread.
Economic life is short when the capital recovery curve is already flat. A machine worth $50,000 today and $37,500 next year only has $12,500 of value left to lose in that year, and no amount of extra ownership makes that number much smaller. Meanwhile operating costs keep climbing. The U-curve for an old asset barely has a left-hand side — it's rising almost from year one.
That's why the textbook observation is that the economic life of the defender is often one year, and it's exactly why the naive comparison misleads. A one-year economic life sounds like an instruction to replace immediately. It isn't. It's an artefact of an asset whose depreciation is mostly behind it.
The marginal test is the right one because it asks the question you can actually act on: is one more year of this machine cheaper than a year of the new one? At the defaults it is, four times over.
A useful side reading: the calculator reports the defender's market value at the optimal replacement year — $15,820 here. That's what you'll realise when you do sell, and it's worth checking against what a dealer will actually offer, because trade-in values and open-market values often diverge.
What does this analysis not account for?
Three assumptions worth stating, because each can change the answer.
- Repeated identical replacement. The framework assumes you'll replace the challenger with an identical challenger, indefinitely. Real technology improves. A materially better machine arriving in two years creates option value in waiting that this analysis cannot see, and in fast-moving equipment categories that option value can dominate everything here.
- Forecast accuracy. Operating cost growth and salvage decline are the two inputs doing most of the work, and both become unreliable beyond three to five years for most industrial equipment. Treat the later years of the schedule as indicative. If the replacement year lands at seven or eight, that's a signal to re-run annually rather than a decision to file away.
- Tax and financing. No depreciation, no tax shield, no interest deduction, no lease alternative. Where taxes matter — and they usually do for a large asset — the sunk cost re-enters through the disposal loss, and the after-tax answer can differ from this one.
What the analysis does handle well is the structural logic: market value not book value, minimum equivalent annual cost for the challenger, and marginal cost year by year for the defender. Get those three right and you're ahead of most capital requests, which typically compare a purchase price against a repair quote and call it an analysis.
Transform Your Excel Models into Web Tools
Turn your complex Excel calculations into online calculators, web forms, and APIs. No coding required — upload your spreadsheet and publish your calculations instantly.
Calculations are for estimation and planning purposes. Users should verify important results for their specific situations. No signup required. Calculations performed securely.