Automotive
Fleet Replacement Reserve Calculator
Project future unit purchase and resale values, net fleet replacement target, future value of an existing reserve, funding gap, monthly sinking-fund contribution, and annual reserve budget.
Inflated replacement cost per vehicle-
Projected resale per vehicle-
Net fleet replacement target-
Monthly reserve return-
Funding months-
Existing reserve at replacement-
Future funding gap-
Required end-of-month contribution-
Annual reserve budget-
Gross future vehicle outlay-
Projected fleet resale offset-
Decision view
Fleet age runway and reserve funding trajectory
Fleet age runway and reserve funding trajectoryA vehicle cohort timeline connects the current reserve, monthly deposits, compounding, resale offset, and replacement-date funding gate.
Exact scenario comparisonYears until cohort replacement changes while all other entered assumptions remain constant.
| Years until cohort replacement | Inflated replacement cost per vehicle | Projected resale per vehicle | Net fleet replacement target | Monthly reserve return | Funding months | Existing reserve at replacement | Future funding gap | Required end-of-month contribution | Annual reserve budget | Gross future vehicle outlay | Projected fleet resale offset |
|---|
How to use Fleet Replacement Reserve Calculator
- Group vehicles with a genuinely similar replacement date and specification.
- Use procurement and disposal assumptions in the same nominal-dollar basis.
- Enter only liquid, designated reserve assets and a conservative return assumption.
Calculator guide
Understanding Fleet Replacement Reserve Calculator
Fleet replacement is a dated liability rather than today's sticker price. The reserve must reflect compounded purchase cost, expected disposal proceeds, the future value of cash already set aside, and the deposits needed to close the remaining gap.
Detailed calculation process
Detailed fleet replacement target and sinking-fund calculation
The default cohort contains 24 vehicles replaced in six years, with $120,000 already reserved.
General formula: C_f=C_0*(1+g_c)^yS_f=S_0*(1+g_s)^yT=n*max(0,C_f-S_f)i=r/12m=12*yR_f=R_0*(1+i)^mG=max(0,T-R_f)P=G*i/((1+i)^m-1) Purchase and resale values are projected independently. The existing reserve grows for the entire horizon, while the remaining gap is funded by an ordinary monthly annuity.
What each symbol means
Worked substitution with the default inputs
The default cohort requires about $10,741 per month, subject to procurement, resale, timing, and return assumptions.
Worked situations
Practical examples
- The default 24-vehicle cohort grows a $42,000 unit cost for six years at 3.5%.
- The existing $120,000 reserve is compounded separately before the monthly deposit is solved.
Better inputs
Useful tips
- Use separate runs for staggered age cohorts instead of one average horizon.
- Model upfit, tax, delivery, and decommissioning inside replacement cost when material.
- Stress-test lower resale and higher purchase inflation together.
Before relying on the result
Limitations and common mistakes
- All vehicles in the run share one replacement date and average unit economics.
- The contribution formula assumes a constant return and end-of-month deposits.
- Taxes, investment fees, financing, downtime, varying mileage, and individual vehicle condition are excluded.
Reference
Key terms
- Net replacement target
- Future purchase outlay less projected disposal proceeds.
- Future reserve value
- Existing designated cash after modeled compounding.
- Sinking-fund contribution
- Regular deposit required to accumulate the remaining future target.
Important note
Reconcile the reserve plan with the fleet register, procurement policy, disposal history, capital budget, and restrictions on invested public or corporate funds.
Frequently asked questions
Can vehicles be replaced over several years?
Use a separate cohort for each replacement year, then sum the monthly reserve budgets.
Why require a positive reserve return?
The ordinary-annuity expression divides by the monthly rate; use a very small positive rate for a near-zero-return planning case.
Should debt be included?
This page models a cash reserve; financing requires a separate debt and cash-flow analysis.