Car Rental Financial Model – Subscription Platform in Excel
$120.00
Description
A detailed, investor-ready car rental financial model for a subscription-based online rental platform — with a four-tier subscription ladder, a user acquisition and retention funnel, a depreciating vehicle fleet and advertising revenue, plus platform-development and operation phases, an exit strategy and valuation, in one integrated Excel model.
An online car rental business is two businesses fused together. One is a subscription platform — an app that acquires users, retains them, and charges a recurring fee for access to vehicles. The other is a capital-heavy fleet operation, with real cars that are bought, depreciate and eventually need replacing. Model only the app and you ignore the largest asset on the balance sheet; model only the fleet and you miss the retention dynamics that drive the revenue. This model holds both together.
Revenue is driven from a user funnel — downloads, retention and active-user rates — converted into subscribers across four plan tiers, with advertising on top. The vehicle fleet is capitalised as a depreciating fixed asset, while the platform itself is amortised as an intangible. The whole business flows through to a complete, investor-ready output set.
The output set is comprehensive: Project and Equity IRR and NPV (with and without terminal value), equity payback, a DCF valuation, an exit strategy and a fully linked dashboard.
A Four-Tier Subscription Ladder
The revenue engine is built on four subscription tiers — daily, weekly, monthly and yearly — each with its own charge and its own share of the active user base. That structure captures how rental subscriptions actually price: a yearly plan trades a lower effective rate for committed, upfront revenue and better retention, while a daily plan captures occasional users at a premium. The mix between them is yours to model and to flex.
Each tier can be activated or deactivated independently, so you can model a platform that launches on daily and weekly rentals and adds longer commitments later, or one that runs all four from the start. The split of active users across tiers drives the revenue, and can be tested across scenarios.
The Fleet on the Balance Sheet
What separates this from a pure software platform is the vehicle fleet. Car purchase is modelled as capital expenditure, depreciated over the useful life of the vehicles, with refresh capex to fund fleet replacement as cars age out. This matters enormously to the returns: a rental business lives and dies on asset utilisation and the residual value of its fleet, and a model that treats the cars as a real, depreciating, replaceable asset — rather than a vague cost line — is the only kind an investor in a capital-heavy business will trust.
Assumptions You Control
Every driver of the business is an explicit, editable input. The assumptions cover:
| User Base | Downloads per month (Base, Management, Upside), retention rate and active-user percentage |
| Subscription Plans | Daily, weekly, monthly and yearly charges, with the split of active users across the four tiers |
| Advertising | Sessions per month, minutes per session, ad impressions per minute and CPM |
| Variable O&M | Operating cost as a percentage of revenue, set separately for each subscription tier and advertising |
| Fixed Costs | Management salary, technical and central-office staff, rental, office expenses, SPV cost, insurance and security |
| Platform Capex | UI/UX, native platform and app, backend, admin panel, DevOps, project management and contingency, amortised as an intangible |
| Fleet & Other Capex | Car purchase, equipment and other setup cost, depreciated with refresh capex at end of life |
| Financing & Exit | Debt-equity ratio, development and operations debt, holding period and exit assumptions |
Two Asset Bases, Costed Correctly
The model recognises that this business has two very different capital bases. The platform — UI/UX, native apps, backend, DevOps — is capitalised as an intangible and amortised over its useful life. The vehicle fleet is a tangible fixed asset, depreciated on its own schedule. Both carry refresh capex to fund replacement. Treating the two correctly, rather than lumping them together, is what makes the statements realistic and the valuation defensible.
Valuation and a Defined Exit
The model derives a full DCF valuation — Project and Equity NPV and IRR, both with and without terminal value — and a dedicated exit strategy lets you set a holding period and model a sale of the business. For a rental venture built to scale a fleet and a subscriber base toward an eventual acquisition, that exit view is exactly the analysis that frames the investment case.
Five Years, Monthly, Three Cases
The model forecasts across development and operation on a monthly basis, with financial statements on both monthly and annual views. Every revenue and cost assumption can be entered across Base, Management and Upside cases and switched at the click of a button — and because the model uses no macros, every change flows through instantly.
Who This Car Rental Financial Model Is For
- Car rental and mobility founders building an investor-ready business plan and valuation
- Subscription mobility startups modelling a fleet-backed rental platform
- Venture and mobility investors assessing subscriber economics, utilisation and fleet returns
- Lenders and grant bodies evaluating a mobility or fleet-financing application
- Advisors and consultants preparing feasibility studies for rental ventures
Why This Model
Four-tier subscription ladder
Daily, weekly, monthly and yearly plans, each priced and weighted separately, activate independently.
Fleet as a real asset
Car purchase depreciated with refresh capex, so the capital-heavy side of the business is modelled honestly.
Exit and valuation
A holding-period exit plus a full DCF valuation with and without terminal value.
New to these metrics? Read an overview of internal rate of return. For a model built to your own specification, see our financial advisory services, or browse the full range of business plan Excel models.
Plan Your Car Rental Platform
A four-tier subscription ladder, a depreciating fleet, software amortised and a full exit — five years of monthly projections, ready in Excel.











