Car Rental Economics Model
Logistics Financial Model (Free Excel Download)
Model car-rental economics through fleet size, utilization, rental days, pricing, vehicle depreciation, maintenance, insurance, and fleet purchases to forecast cash returns.
professionals from Deloitte
Used by professionals from
About this model
A car rental operator model projects profitability by tracking fleet size, vehicle age distribution, utilisation rates, revenue per day by vehicle class, fleet depreciation, and residual value changes, to determine whether the operator can support debt service on both fleet-backed and corporate debt and maintain positive free cash flow through fleet replacement cycles. The model answers what the adjusted corporate EBITDA margin is after accounting for depreciation and depreciation cycles, and whether residual value assumptions are realistic given used car market conditions.
Revenue is driven by time-and-mileage (T&M) rental revenue (fleet size × utilisation × 365 × revenue per day), growing as the fleet expands and RPD inflation compounds, plus ancillary revenue (insurance waivers, GPS, fuel, upgrades) which attaches to 15% of T&M. Fleet depreciation is the single largest cost line: the cost per vehicle per year equals (purchase price − residual value) / holding period. For a $32,000 vehicle with 24-month holding period and 65% book residual value, annual depreciation is $5,600 per vehicle. Direct operating expenses (branch staff, maintenance, airport concessions) are modelled at 45% of T&M revenue. SG&A covers corporate overhead at 10% of total operating revenue. Disposal proceeds are netted as a loss or gain on sale (market residual value differs from book residual, creating a P&L impact). Fleet debt is sized on an 80% LTV against gross fleet cost (not net book value), and the revolving debt structure repays as vehicles reach end-of-life. Corporate debt is a traditional amortising term loan.
Car rental operators, fleet financiers, and private equity sponsors use car rental models to project adjusted EBITDA margins (8–15% benchmark), stress residual value assumptions (critical assumption affecting profitability), and confirm the fleet debt covenants (LTV, debt service) are sustainable through fleet replacement.
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 Car Rental Economics Model
- Fleet size and composition by vehicle class
- Daily utilisation and occupancy projections
- Average daily rate (ADR) by class and season
- Cost of revenue: fuel, maintenance, insurance, registration
- Vehicle capex, depreciation, and fleet replacement timing
- Overhead: locations, customer service, and technology
Car Rental Economics Model: Fleet, Utilisation, and Residual Value Drivers
A car rental financial model for evaluating a mid-market operator with around 500 vehicles. It links fleet size and utilisation to daily rental revenue, ancillary income from channels, and vehicle disposal proceeds.
The template includes a Day 0 balance sheet, three-statement projections, fleet debt schedules, and sensitivity grids for exit multiples and IRR. This preview supports investment, acquisition, or financing review.
Rates and financial results described here reflect illustrative model settings, not industry benchmarks.
Fleet Utilisation and Revenue Drivers
The model begins with fleet size and utilisation. Average fleet is the average of opening and closing vehicles.
- Available rental days are average fleet times 365, and actual rental days apply a utilisation rate. Time and mileage revenue equals actual rental days times revenue per day.
- Ancillary revenue is a percentage of that time and mileage revenue, capturing attach-rate products. Together these form total operating revenue.
The design assumes annual periodicity, so seasonality is not captured within the year. This structure makes utilisation the key operational lever: small changes in fleet size or utilisation directly shift rental days and revenue.
Cost Structure and Fleet Depreciation
Direct operating expenses are modelled as a share of time and mileage revenue, covering items such as branch personnel, maintenance, insurance, and concession fees. SG&A is a percentage of total operating revenue and includes corporate staff, marketing, and IT.
- Fleet depreciation is the largest cost and is not revenue-based; it is calculated per vehicle as purchase price minus residual value, divided by holding period in years. Total fleet depreciation uses average fleet.
- Non-fleet depreciation is straight-line over seven years. Adjusted Corporate EBITDA subtracts operating costs and fleet depreciation from operating revenue, typically falling in an 8–15% margin range according to the design assumptions.
Fleet Roll-Forward, Disposal, and Debt Mechanics
The fleet roll-forward tracks additions, disposals, and closing fleet. In a steady-state fleet with a 24-month holding period, roughly half the vehicles reach end of life each year.
- Additions must cover disposals plus growth vehicles; otherwise the fleet shrinks. Fleet debt is sized at 80% of gross fleet cost and is drawn on additions and repaid on disposals.
- Disposal revenue uses a market residual percentage, while the net book value of sold vehicles comes from the fleet schedule. Because these differ, a gain or loss on sale arises.
Fleet disposal activity sits below operating EBITDA so it does not inflate the core operating margin.
Outputs and Practical Use
The model produces a full three-statement projection with a Day 0 balance sheet, a cash flow statement using the indirect method, and a KPI dashboard including IRR, MOIC, and fleet yield. Unit economics show per-vehicle revenue, cost, and NPV.
- Sensitivity grids test IRR against residual value and revenue per day, MOIC against utilisation and residual value, and equity value against discount rate and revenue per day. Terminal value combines an exit multiple and a Gordon Growth approach.
- These outputs help an analyst assess fleet financing, acquisition, or investment decisions for this documented mid-market operator scope.
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.
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 a car rental financial model?+
It is a model that projects rental revenue, vehicle costs, and fleet capex for a rental operator across vehicle classes and seasons.
What is average daily rate (ADR) and typical utilisation?+
ADR is the average revenue per rental day, typically $30–50 economy, $40–60 midsize, $80–120 luxury. Fleet utilisation is often 60–75%.
How do I model vehicle depreciation?+
Cars typically depreciate 50–70% in the first 3 years, then 5–10% annually. Older fleets have higher maintenance but lower capex.
What is included in cost of revenue?+
Fuel (largest variable cost), routine maintenance, repairs, insurance, registration, and contingency for loss and damage.
Can I model franchise or acquisition scenarios?+
Yes. Project cash flow for comparable locations and evaluate investment returns under different fleet mix and pricing assumptions.
Have more financial modelling questions? Contact us
Related templates
Airline Operations Model
Airline financial projections with route, fleet, and capacity planning.
Ride-Hailing P&L Model
Operating model for ride-hailing platforms with unit economics, driver supply costs, and demand pricing dynamics.
Hotel Operating Model
Operating model for hotel properties including occupancy rates, average daily rate (ADR), RevPAR optimization, and facility-level profitability.
Aircraft Leasing
10-aircraft operating lease portfolio model with NBV roll-forward, lease cash flows, debt schedule, and levered IRR.
