Every unit on the yard is a capital bet. Fleet ROI tells you which bets paid off, which are still in the hole, and which you should stop maintaining and sell. This dashboard puts lifetime revenue against acquisition cost per unit, so keep-sell-rebuy decisions stop being a gut call.
What this report answers
The overview answers the owner's core capital question: how much revenue has the fleet returned per dollar invested, and how many units have actually crossed their acquisition cost? Fleet ROI is lifetime rental revenue over acquisition cost — cost recovered to date. Net Return After Maintenance goes one step further, subtracting both acquisition cost and lifetime repair spend to show what the fleet has truly returned. Units Past Payback counts the winners. The payback-band column chart buckets the fleet into 0–12, 13–24, 25–36, and 37+ month cohorts so you can see how fast capital comes back.
The metrics that matter
Fleet ROI and Net Return After Maintenance are the headline pair — a unit can show positive ROI and still be a loser once repair spend is netted out. Maintenance Drag — lifetime maintenance over lifetime revenue — flags the categories quietly eating their own earnings. On the per-unit page, the scatter of acquisition cost versus lifetime revenue with a y=x payback reference line is the money chart: anything below the line hasn't earned back what it cost, and an old unit far below the line is a sell candidate.
Why the data is trapped
Lifetime rental revenue accrues in the rental ERP — Point of Rental, Wynne, InTempo — contract by contract, while acquisition cost and maintenance spend sit in QuickBooks. Neither system computes ROI or payback per unit on its own, because the calculation spans both. So the analysis that should drive every capital decision gets done in a spreadsheet a few times a year, if at all, instead of being a live view.
How to read it
Start with Units Past Payback and the payback-band chart for the shape of the fleet, then drop to the per-unit scatter. Units below the y=x line are still recovering cost; the ones far below it and high in age are the sell-or-don't-rebuy list. Cross-check Maintenance Drag by asset class — a category with acceptable ROI but heavy drag is a worse bet than it looks, and the next purchase order should go elsewhere.
The sample uses fully synthetic, anonymized data — no real units, costs, or revenue.
Metrics it tracks
| Metric | What it means |
|---|---|
| Fleet ROI % | DIVIDE(SUM(lifetime_rental_revenue), SUM(acquisition_cost)) — total revenue earned per dollar invested in the fleet (cost recovered to date). |
| Lifetime Revenue ($) | SUM(lifetime_rental_revenue) across all units. |
| Net Return After Maintenance ($) | SUM(lifetime_rental_revenue) - SUM(lifetime_maintenance_cost) - SUM(acquisition_cost) — dollars the fleet has actually returned net of its cost and upkeep. |
| Maintenance Drag % | DIVIDE(SUM(lifetime_maintenance_cost), SUM(lifetime_rental_revenue)) — share of lifetime rental earnings eaten by repair spend. |
| Units Past Payback (count) | SUM(payback_reached_flag) — count of units where lifetime revenue has crossed acquisition cost (integer 1/0 flag summed). |
Used by: Owner / regional ops manager making keep-sell-rebuy fleet decisions
Frequently asked questions
How is fleet ROI calculated for a rental yard?
Fleet ROI is total lifetime rental revenue divided by acquisition cost — how many dollars each dollar of fleet investment has earned back to date. A unit at 100% has recovered its purchase price; below that it's still in the hole. Netting out lifetime maintenance gives the truer picture of return.
What is a payback period for rental equipment?
Payback is the number of months it takes a unit's cumulative rental revenue to equal its acquisition cost. The report buckets the fleet into 0–12, 13–24, 25–36, and 37+ month bands so you can see how quickly capital comes back and which categories take too long.
Why net out maintenance from ROI?
A unit can show positive rental ROI yet still lose money once repair spend is counted. Maintenance Drag — lifetime maintenance over lifetime revenue — exposes categories that earn well on paper but bleed it back in the shop, which is exactly where keep-sell-rebuy decisions go wrong.
Build this report on your own data
Clone this Rental yards template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →