Bicycle Rental Financial Model – Subscription Platform in Excel

$120.00

Description

A detailed, investor-ready bicycle rental financial model for a subscription-based bike rental platform — with a four-tier subscription ladder, a user acquisition and retention funnel, a depreciating bicycle fleet and advertising revenue, plus platform-development and operation phases, an exit strategy and valuation, in one integrated Excel model.

An online bicycle 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 bikes. The other is a fleet operation, with real bicycles that are bought, depreciate and eventually need replacing. Model only the app and you ignore the fleet 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 bicycle 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 fits bike rental especially well: a daily plan serves the occasional rider or tourist, while a yearly plan captures the daily commuter at a committed, upfront rate. 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 bicycle fleet. Bicycle purchase is modelled as capital expenditure, depreciated over the useful life of the bikes, with refresh capex to fund replacement as they wear out. This matters to the returns: a rental business lives on asset utilisation and the working life of its fleet, and a model that treats the bicycles as a real, depreciating, replaceable asset — rather than a vague cost line — is the only kind an investor in a capital-backed business will trust. For bikes, where individual unit cost is low but fleet size is large and wear is high, getting the replacement cycle right is especially important.

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 Bicycle 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 bicycle 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 Bicycle Rental Financial Model Is For

  • Bike-share and micromobility 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
  • Cities, operators and grant bodies evaluating a bike-share or micromobility scheme
  • 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

Bicycle purchase depreciated with refresh capex, so the fleet 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 Bicycle Rental Platform

A four-tier subscription ladder, a depreciating fleet, software amortised and a full exit — five years of monthly projections, ready in Excel.

Add to Cart