Equipment Rental Model

Operating Businesses Financial Model (Free Excel Download)

Forecast equipment-rental economics through fleet size, utilization, rental rates, maintenance, transport, depreciation, replacement capex, financing, and branch-level returns.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model helps you assess an equipment rental business serving construction, events, industrial clients, or homeowners. It brings fleet size, rental demand, delivery, damage, and resale proceeds together with the costs of buying, maintaining, and operating equipment.

Use it to evaluate a fleet purchase, branch expansion, or acquisition. Test utilisation, rental rates, equipment mix, and financing to understand the effect on cash flow and business value.

What every model includes

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

What's inside the Equipment Rental Model

  • Operating inputs: days available per unit, utilisation ramp and ceiling, price escalation, equipment-cost inflation
  • Four equipment-category blocks: units, growth, acquisition cost, useful life, daily rate, starting utilisation, maintenance per unit
  • Fees & fleet losses: damage-waiver attach, delivery attach, loss/theft/damage write-off rate
  • Operating costs: locations, new locations, opex per location, yard labour %, transport %, marketing %, G&A %, tax
  • Capital & working capital: NWC %, base-year revenue
  • Valuation: WACC, terminal growth, exit multiple, net debt, shares outstanding
  • Fleet sheet: per-category unit roll-forward (opening, retirements, growth, purchases, closing, average units, utilisation, rental-days achieved) and a total-fleet block with blended utilisation
  • Revenue sheet: per-category rental revenue, total rental revenue, damage-waiver fees, delivery & pickup fees, total revenue

Equipment Rental Financial Model: Fleet, Utilisation and Cash Flows

This equipment rental financial model projects the economics of a multi-location rental yard over seven years. It links fleet units, utilisation, daily rates and ancillary fees to depreciation, maintenance, expenses and capital spending, then builds unlevered free cash flow and a DCF valuation.

Readers can see how replacement versus growth capex and utilisation shape enterprise value.

Fleet Roll-Forward and Equipment Categories

The model rolls each equipment category forward from opening units. Retirements are calculated as opening units divided by useful life and rounded, so roughly one life-fraction of the fleet reaches end-of-life each year.

  • Growth units equal opening units times a growth rate. Purchases equal retirements plus growth, which means the fleet never shrinks: closing units always exceed opening units by growth.
  • Average units, the base for revenue, depreciation and maintenance, is the mean of opening and closing. Four categories span tools, recreational gear, event equipment and specialty appliances.

Utilisation Drives Rental Days and Revenue

Available rental-days equal average units multiplied by days available per unit, which is 365 less maintenance, transit and downtime. Utilisation is the fraction of those days equipment is actually on hire.

  • Each category starts at its own Year-1 utilisation and ramps by a fixed number of percentage points per year toward a shared practical ceiling. Rental-days achieved equal available rental-days times utilisation, and this figure drives revenue.
  • Blended utilisation, total rental-days divided by total available days, is the headline operating KPI. The MIN function caps utilisation so no category exceeds its ceiling.

Revenue Build, Ancillary Fees and Fleet Costs

Rental revenue per category equals rental-days achieved times the average daily rate, escalated from Year 1 at a price-escalation rate.

  • On top of rental revenue, two ancillary lines are charged as attach rates: a damage-waiver or insurance fee and a delivery and pickup fee.
  • Both are percentages of rental revenue, so total revenue is rental revenue grossed up by the two attach rates.
  • Fleet costs include straight-line depreciation on average units at acquisition cost divided by useful life, maintenance and repair per unit, and a loss, theft and damage write-off applied to gross fleet value.

Capex Split, Cash Flow and Valuation

Fleet capex is split explicitly into replacement capex, equal to retirements times acquisition cost, and growth capex, equal to growth units times acquisition cost, both escalated at equipment cost inflation. Because useful lives are short, replacement capex alone is large.

  • The P&L moves from total revenue through fleet maintenance, fleet losses, yard labour, facilities, transport, marketing and G&A to EBITDA, then depreciation to EBIT, tax and net income. Unlevered free cash flow equals NOPAT plus depreciation less total fleet capex less the change in working capital.
  • The DCF sums explicit UFCF present values and a Gordon-growth terminal value to enterprise value, subtracts net debt for equity value, and cross-checks with an exit multiple.
Unlevered free cash flow = NOPAT + depreciation − total fleet capex − the change in working capital
income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Formatted to IB standards

Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Need help finding your model? You’ll find me in the Finamodel app!

Frequently asked

What is an equipment rental financial model?+

An equipment rental financial model captures the seven-year operating economics and intrinsic value of a multi-location gear rental yard - the rent-the-fleet business that owns a depreciating pool of tools, recreational gear, event equipment and specialty appliances and rents it by the day. It rolls a per-category fleet forward with retirement and replacement, converts a utilisation ramp into rental-days achieved and revenue, runs straight-line fleet depreciation and a replacement-versus-growth capex split, and discounts an unlevered free-cash-flow stream (with an exit-multiple cross-check) to enterprise value, equity value and value per share.

Why is utilisation the core driver?+

Idle equipment is the main margin leak. Available rental-days is average units times days available per unit, and utilisation is the fraction of those days the gear is actually on hire. Rental-days achieved - available days times utilisation - drives revenue rather than the raw unit count, so a single utilisation ramp with a per-category starting point and a practical ceiling below 100% is the core operating lever, and blended utilisation is the headline KPI.

How does the replacement-versus-growth capex split work?+

Each category rolls a unit count forward: opening plus purchases less retirements equals closing, where retirements follow a straight-line useful life and growth units are opening times a growth rate. Purchases equal replacement plus growth so the fleet never shrinks. Fleet capex is split explicitly into replacement capex (retirements times acquisition cost, keeping the fleet whole) and growth capex (growth units times acquisition cost, expanding it) - the dominant capital driver because short useful lives force constant renewal.

Why an unlevered DCF with an exit-multiple cross-check?+

The DCF sums the PV of explicit unlevered free cash flow and a Gordon-growth terminal value to enterprise value. An exit-multiple cross-check applies an EV/EBITDA multiple to terminal-year EBITDA and discounts it back, giving a second, independent read alongside the perpetuity method - useful for an asset-heavy fleet business that trades on EBITDA multiples. Implied EV/EBITDA ties the two together, and a Checks sheet asserts the P&L, revenue and capex identities, that utilisation stays within its cap, and that the fleet does not shrink.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview