Clean Reporting In One Place
I stopped chasing charts and statements across different files. Now everything sits in one model, and I saved about 3 hours on each monthly update.
I stopped chasing charts and statements across different files. Now everything sits in one model, and I saved about 3 hours on each monthly update.
It made margins and break-even easy to see without digging through formulas. I had a clearer read on profitability before our planning call, and that shortened the meeting prep by a full afternoon.
Building low, base, and high cases used to take forever, but this template keeps it organized. I ran all three scenarios in one sitting and booked a follow-up review the same day.
This editable five-year gaming workbook, e-scooter models, sales and buyer market revenues, repeat orders, order value, commissions, subscriptions and vendor allowances.
Use the workbook to plan how the supplier supply, buyer demand, order activity, prices and monetization translate into market revenues, costs, cash flow and financial results.
Separate acquisition budgets, CAC, level mixes, viability, seasonality, order repetition frequency, AOV, rates, subscriptions and extras sellers supply forecast and reports.
The model acquires sellers and buyers separately, retains layered conglomerates, converts the buyer's business to GMV, and then records commissions, subscriptions and vendor allowances as revenue.
Calculation of new sellers and buyers separately from acquisition budgets divided by their respective CAC.
Allocation of each party to tiers, maintenance of the cohort for the life of each layer and application of the acquisition seasonality.
Combine the first orders from new buyers with subsequent orders from authorized active-buyers of cohorts.
Calculate GMV as orders times the buyer-tier AOV, then calculates commissions with take rates and fixed fees per order.
Add commission, subscriptions to seller and buyer and included vendor allowances per month; GMV is not revenue itself.
The income sheet The assumption separates the sale and purchase of the buyer, periods of validity, repeated preservation of the order, value of the order, commissions, subscriptions and accessories of the seller.
GROUNDS FOR THE REVENUE
The COGS & OPEX card separates the COGS sheet, variable and fixed expenditure, including payment processing, acquisition, hosting, support, rental, legal and utility.
COGS & OPEX
The Scenarios compared low, base and high revenue paths, gross margin, premium margin and EBITDA in the five-year forecast.
SCENARIOS
The dashboard combines configuration control, scenarios results, basic finance, revenue mix, profitability, cash flow and return on investment in one management view.
DASHBOARD
The ready model fits the bilateral planning of e-commerce e-commerce market, while structurally different revenue logic, operational schedules or reporting requirements may require non-standard modelling.
The template is the starting point of planning, not a guarantee of performance.
Lab financial models can build or adapt a model when you need different revenue logic, operating schedules or financial statements for your needs.
ORDER A CUSTOM FINANCIAL MODELAfter booking you will receive the five-year E-Scooter Rental as an immediate download with analysis of scenarios and financial reports.
Download the fully editable Excel and Google Sheets model for designing e-scooter rental market.
Work with detailed monthly and annual forecasts over five years.
Compare low, base and high cases using the scenario view model.
Profit and Loss Review, Cash Flows, Balance Sheet, Dashboard, Summary and Complementary Reports.
The basic answers are visible in their entirety, without clicking on the accordion.
Buys sellers and buyers separately, builds active cohort groups, calculates orders of buyers and GMV, and then adds commissions, subscriptions and vendor allowances as revenue.
You can edit sales and buyer budgets, seasonality, CAC, level mixes, durability, order repetition frequency, AOV, commissions, subscription fees and included additional sales.
The Scenarios’ view compares low, base and high revenue paths, gross margin, premium margin and EBITDA throughout the forecast.
Product Shows Profits and Losses, Cash Flows, Balance Sheet, Resolution Board, Summary, Screenplays, Charts and Report KPI.
Yes. The financial models Lab offers custom financial modelling when you need different revenue logic, operating schedules or reporting structures.
This is a planned forecast, not a performance guarantee; the results depend on assumptions and actual operations.
Get a comprehensive, five-year e-scooter rental financial model template designed to help you plan, fund, and launch your micromobility startup.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark