Click main image to view in full screen.
Equipment Hire / Rental Fleet Model - Per-Asset ROI & Utilisation – Excel XLSX
Excel (XLSX)
BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT
- Per-asset economics: day rate, utilisation, running costs and return on the capital tied up in each machine.
- Fleet dashboard rolls the whole yard up so the winners and the dead weight are both visible.
- Utilisation sensitivity shows how fast a marginal asset tips from profitable to loss-making.
ASSET MANAGEMENT EXCEL DESCRIPTION
The Equipment Hire / Rental Fleet Model answers the question every plant-hire, tool-hire or rental-yard operator should be asking: which assets actually earn their keep? Rather than a single blended P&L, it gives every asset its own economics, then rolls the fleet up so the winners and the dead weight are both visible.
What it does: for each machine you enter the capital cost, day rate, expected utilisation and running costs, and the model computes its annual revenue, contribution and return on the capital tied up in it. A fleet dashboard aggregates the picture – total revenue, utilisation and ROI – and a utilisation sensitivity shows how quickly a marginal asset tips from profitable to loss-making as its days-on-hire fall. That last point is where hire businesses quietly lose money, and the model makes it explicit.
Main features: a fleet register with one row per asset; per-asset annual economics and ROI; a fleet-level dashboard; and utilisation sensitivity analysis. A worked example is preloaded – a six-asset yard with day rates from $180 to $650 – so the mechanics are visible before you enter your own fleet. 253 live formulas, recalc-verified with zero formula errors.
How to work with it: the fleet register is where your inputs live; overwrite the example rows with your own assets. Everything to the right of your inputs calculates. Only the input cells are meant to be changed; formulas are visible and marked by the colour scheme (blue = input, black = formula, green = cross-sheet link).
Why you need it: capital allocation in a hire fleet is a per-asset decision, and a blended template hides which machines to buy more of and which to sell. This model is fully unlocked, every formula visible, with a plain-English guide and honest notes on the cover. Currency-agnostic; treat $ as your currency. For analysis only.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Asset Management, Integrated Financial Model Excel: Equipment Hire / Rental Fleet Model - Per-Asset ROI & Utilisation Excel (XLSX) Spreadsheet, g59076599o70
