What is another period worth?
Weigh expected income against running costs, repairs, finance costs and the change in sale value.
Vehicle lifecycle costs & worksheetSee the whole cost.
See the whole cost.
Protect your profit.
Make better decisions about what to buy, keep and sell. Our vehicle lifecycle cost worksheet brings acquisition, finance, maintenance, running costs and resale preparation together with income and expected sale value. Understand what each vehicle earns across its working life—and compare keeping, replacing or defleeting it with the full picture in view.
Editable Excel workbook · Worked examples · No form required
One vehicle. The full picture.Income / Ownership costs / Resale value
Vehicle lifecycle cost calculationThe sale price is
The sale price is
only part of the story.
Follow one van through its ownership period. See the profit after the costs entered, then see what is released in cash when it is sold.
Example van · Whole ownership period
Hire & other operating income£54,000
Acquisition & ownership costs Purchase £28,000 · Maintenance £6,200
Running £7,800 · Finance costs £2,400 · Overheads £3,000−£47,400
Running £7,800 · Finance costs £2,400 · Overheads £3,000−£47,400
Net sale proceeds £18,000 sale value less £600 preparation & disposal+£17,400
Lifecycle profit£24,000
The return across the whole ownership period, after the costs entered.
Income − ownership costs + net sale proceedsSale value£18,000
Preparation & disposal Costs to prepare and sell the vehicle−£600
Outstanding finance principal Amount still to settle at sale−£7,000
Net cash released at sale£10,400
Cash released after sale costs and the remaining finance principal are settled.
Principal changes cash, not lifecycle profit.Example figures, before business taxes. Acquisition less resale already captures value loss. Finance costs include interest and fees; loan principal is kept out of the profit calculation.
The next decisionKeep it. Replace it.
Keep it. Replace it.
Or release the capital.
The workbook’s option selector compares the decision from today, using the same end date. Future income, costs and sale values drive the result.
Does the replacement earn its place?
Include the new acquisition, expected earnings and resale value, alongside the cash needed at the start.
What capital could you release?
See the net sale value and finance settlement, with any income or costs that would stop.
Past costs stay in the lifecycle record. The forward comparison starts with the current vehicle’s net sale value.
Fleet total cost of ownership worksheetYour figures.
Your figures.
A clearer decision.
Two editable sheets, with worked examples and visible formulas. Replace the highlighted inputs with your own vehicle records, costs and dated valuations.
Get the Excel worksheetAcquisition, operation and disposal
Bring income together with purchase costs, finance interest and fees, maintenance, running costs, overheads and resale preparation. See total lifecycle cost after resale and the resulting vehicle profit.
Profit and cash, kept distinct
Outstanding finance principal is included in cash released at sale. It is not deducted again as a cost after the vehicle’s acquisition has already been counted.
A consistent keep, replace or defleet comparison
Switch between three options in one calculation. Compare profit from today, cash at the start and net cash over a matching period. The example assumes vehicles are sold and finance is cleared by that period’s end.
Assumptions you can inspect
Values are editable estimates, not live market feeds. The worksheet shows its calculation steps and excludes business taxes, discounting and monthly cash timing. Use a consistent VAT basis and include the costs relevant to your operation.
Put the underlying data to workMake the next fleet decision
Make the next fleet decision
with the whole vehicle in view.
FleetSuite connects income, acquisition, repairs, finance and vehicle history to support buying and defleeting decisions. Bring the financial picture alongside the demands of your operation.
Explore connected vehicle decisionsSee FleetSuite in action
Tailored to your business · No obligation