Fleet vehicle replacement scenario calculator

Calculate scenario cost [replacement year,net undiscounted horizon cost currency] and lowest supplied-cost scenario years with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use scenario cost [replacement year,net undiscounted horizon cost currency] and lowest supplied-cost scenario years to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Existing vehicle annual operating/repair costs (USD/year)
4000,5000,7000
Replacement annual costs from purchase age 1 onward (USD/year)
2500,3000,3500
Existing resale values at years 0..horizon (USD)
10000,8000,6000,4000
Replacement resale values at ages 0..horizon (USD)
20000,17000,14000,11000
Replacement purchase at any scenario year (USD)
20000
Candidate replacement years; horizon means keep existing (years)
0,1,2,3
Scenario cost [replacement year,net undiscounted horizon cost currency] (USD)
[[0,8000],[1,7500],[2,8500],[3,12000]]
Lowest supplied-cost scenario years
[1]
Minimum supplied scenario cost (USD)
$7,500.00

Try another scenario

Existing vehicle annual operating/repair costs (USD/year)
4000,5000,7000
Replacement annual costs from purchase age 1 onward (USD/year)
2500,3000,3500
Existing resale values at years 0..horizon (USD)
10000,8000,6000,4000
Replacement resale values at ages 0..horizon (USD)
20000,17000,14000,11000
Replacement purchase at any scenario year (USD)
24000
Candidate replacement years; horizon means keep existing (years)
0,1,2,3
Scenario cost [replacement year,net undiscounted horizon cost currency] (USD)
[[0,12000],[1,11500],[2,12500],[3,12000]]
Lowest supplied-cost scenario years
[1]
Minimum supplied scenario cost (USD)
$11,500.00
Calculation method

Calculation method

Scenario cost [replacement year,net undiscounted horizon cost currency] (USD)

If t<H: sum old costs years before t + purchase-oldResale[t] + replacement operating costs for age years 1..H-t - replacementResale[H-t]. If t=H: sum old costs-oldResale[H].

Lowest supplied-cost scenario years

All candidate years tied for minimum modeled undiscounted cost.

Minimum supplied scenario cost (USD)

Minimum computed cost, not an investment recommendation.

Symbols and units
a
Existing vehicle annual operating/repair costs (USD/year)
b
Replacement annual costs from purchase age 1 onward (USD/year)
c
Existing resale values at years 0..horizon (USD)
d
Replacement resale values at ages 0..horizon (USD)
e
Replacement purchase at any scenario year (USD)
f
Candidate replacement years; horizon means keep existing (years)

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • Explicit undiscounted cash scenarios, one replacement maximum. Purchase price assumed invariant by scenario year; exclude financing, tax, inflation, risk and time value unless already included by user in cash inputs. Existing vehicle initial sunk cost excluded. Supported limits: H=1..30; old/new cost arrays length H; resale arrays H+1; nonnegative inputs; candidate integer years 0..H, unique.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.