Asset Replacement Planning
This use case explains how to plan asset replacement, capex and lifecycle cost for fleets in logistics, transport and similar asset intensive businesses using Model Reef.
You will:
Represent vehicles and major equipment as Assets and Liabilities where financed.
Model acquisition, depreciation and disposal.
Plan replacement cycles and capex.
Connect replacement strategies to operating cost, cashflow and valuation.
The aim is to support decisions about when to replace or refurbish vehicles, how large the fleet should be and how to fund replacements.
When to use this pattern
Use this pattern when:
You manage a fleet of trucks, buses, vans or specialist vehicles.
Replacement timing has a major impact on maintenance cost, downtime and safety.
You need to plan capex and funding requirements over multiple years.
You want replacement strategies reflected in P&L, Balance Sheet, Cashflow and valuation.
You will normally combine this with:
Fleet Utilisation and Cost Modelling
Fuel and Maintenance Forecasting
Route and Region Profitability
Architecture overview
Build a simple fleet asset register
In the model, represent vehicles at a level of aggregation that is easy to maintain, for example:
By vehicle type (prime movers, rigid trucks, vans, buses).
By age band (0 to 3 years, 4 to 7 years, 8 plus years).
By region or depot where necessary.
Create Asset variables such as:
Assets - Vehicles - Prime Movers - NorthAssets - Vehicles - Vans - Metro
Set opening balances based on current fleet book value or replacement cost and set useful life and residual value assumptions for each group.
If you wish, you can keep a separate off-model register spreadsheet and import totals into Model Reef.
Define replacement and lifecycle drivers
In the Data Library, create drivers that describe lifecycle policies, for example:
Target Replacement Age - Prime Movers(in years)Target Replacement Kilometres - Linehaul UnitsResidual Value Percentage at ReplacementRefurbishment Cost per Vehicle at Mid Life
You can also define:
Replacement rate per year as a percentage of fleet size.
Different policies by region or duty cycle if relevant.
These drivers give structure to when and how assets are replaced or refurbished.
Plan replacement volumes and timing
Using the asset register and lifecycle drivers, estimate how many vehicles need replacement each period, for example:
Vehicles to Replace - Prime Movers - Year Nbased on age or kilometres.Vehicles to Replace - Vans - Metrousing a replacement rate per year.
You can compute this analytically within Model Reef using drivers and formulas or prepare a replacement schedule externally and import it as a driver.
Create Asset and Capex variables such as:
Capex - New Vehicles - Prime MoversCapex - New Vehicles - Vans - Metro
These should reflect purchase cost and purchase timing.
Model funding, depreciation and disposal
For each capex variable, decide how the purchase is funded:
Direct cash purchase.
Lease agreements.
Bank loans or asset finance.
Implement:
Asset variables for the new vehicles with appropriate useful life and depreciation method.
Liability variables for loans or leases where relevant, with drawdowns, interest and repayments.
Optional disposal variables to remove old vehicles, including any cash received for sale and residual book value impact.
Because all of this uses the standard Asset and Liability logic in Model Reef:
P&L will show depreciation and interest.
Balance Sheet will show asset and loan balances.
Cashflow will show capex, loan flows and lease or repayment cash outflows.
Cash Waterfall will show capex and financing flows below EBITDA.
Link age and replacement to operating cost
To connect replacement planning to operating cost:
Use age or lifecycle drivers to adjust maintenance cost per kilometre or per vehicle, as described in Fuel and Maintenance Forecasting.
Apply higher maintenance cost and potentially higher fuel consumption to older vehicle bands.
Reduce maintenance cost and fuel consumption for new vehicles.
This allows you to see:
The operating cost benefit of renewing the fleet earlier.
The cost of running older vehicles for longer.
Trade offs between capex and operating cost.
You can implement this using modifiers such as:
Maintenance Cost Modifier - Vehicles Over X YearsFuel Efficiency Modifier - New Vehicles
Build dashboards for fleet age, capex and cost
Create dashboards that show:
Fleet size and age profile over time.
Annual capex for replacement and any growth capex.
Maintenance cost and downtime proxies by age band.
Total cost of ownership per vehicle type (capex plus operating cost).
You can also show:
Differences between regions or depots.
Impact of replacement strategies on cash and debt.
Contribution of fleet changes to valuation via the Valuation Engine.
Use scenarios for replacement strategies
Clone your base model into scenario models representing different replacement strategies, for example:
Replace vehicles earlier (shorter lifecycle, higher capex, lower maintenance).
Run vehicles longer (lower capex in the short term, higher maintenance and potential risk).
Accelerated fleet renewal for safety, compliance or brand reasons.
Transition to alternative fuel vehicles with different cost structures.
In each scenario, adjust:
Lifecycle and replacement drivers.
Capex volumes and timing.
Funding mix between cash, leases and loans.
Operating cost modifiers for maintenance and fuel.
Compare scenarios using:
Total cost of ownership and cost per kilometre.
Capex and funding requirements.
P&L and cashflow patterns.
Valuation and risk metrics.
Check your work
The fleet asset register is at a level of detail you can maintain without excessive effort.
Replacement drivers reflect realistic fleet policies or the policies you wish to test.
Capex and depreciation patterns align broadly with historical behaviour when calibrated.
Maintenance and fuel cost changes with age reflect fleet manager expectations.
Troubleshooting
Related guides
Last updated