Break-Even Was Easy To See
The model made margin and break-even points obvious without extra digging. I got our pricing scenarios cleaned up in under an hour, which made the next investor update much easier.
The model made margin and break-even points obvious without extra digging. I got our pricing scenarios cleaned up in under an hour, which made the next investor update much easier.
I’m not an Excel expert, and this template still felt manageable from the start. I saved about 6 hours of setup time and could finally build the forecasts without getting stuck in formulas.
Pricing, costs, and growth inputs were all in one place, so nothing felt scattered. That made it easier to review our numbers quickly and book a meeting with our team the same day.
This editable five-year workbook combines sales and purchases of buyers, transaction monetization, operating costs, scenarios and financial statements for Urban Air Mobility planning.
Use the model to plan a bilateral urban mobility market where operators and buyers are purchased separately and cash through account transactions and services.
Edit assumptions for acquisitions, mix levels, customer viability, order retention, AOV, commissions, subscriptions, allowances, costs and flow of financing to forecasts and reports.
The model acquires sellers and buyers separately, converts orders to the buyer to GMV and commissions, and then adds subscriptions and include extras seller as revenue.
The budgets for sale and the buyer divided by CAC create new monthly cohorts with a separate seasonality.
The two sides shall be divided into levels and the cohorts shall be kept for each configured layer life period.
Initial orders from new buyers are combined with subsequent orders from authorised active cohorts.
Orders and buyer-tier AOV form GMV, which drives interest and fixed commissions.
The Commission’s revenue, the seller’s and buyer’s subscriptions and the allowances for sellers are monthly.
View Assumption Revenues combines the purchase of the seller and buyer, the level economy, order behaviour, AOV, commissions, subscriptions and vendor allowances.
GROUNDS FOR THE REVENUE
View COGS & Operating expenditure separates direct percentage costs, variable operating costs and recurring fixed expenditure throughout the forecast.
OPERATING EXPENDITURE COGS
The analysis of the scenario compared revenues, gross margin, premium margin and EBITDA in cases with low, base and high levels over five years.
ANALYSIS SCENARIO
The dashboard combines a configuration model, scenarios multipliers, main financial results, revenue mix, profitability, cash flow and return on investment in one view.
DASHBOARD
The template fits market plans using separate cohorts of sellers and buyers; structural differences in income or operating logic may require custom modelling.
The template is the starting point of planning, not a guarantee of performance.
The financial models of Lab can build or adapt a model when the revenue logic, work schedules or reporting requirements differ from the final structure.
ORDER A CUSTOM FINANCIAL MODELYou will receive an immediate, editable financial model Excel or Google Sheets with five-year forecasts, scenarios and integrated financial reports.
Open and edit the model in Excel or Google sheets using your own assumptions.
Overview of the forecast 60-monthly for revenue, costs, profitability, cash flow and financial situation.
Compare low, base and high revenue, margin, premium and EBITDA.
Use P&L, Cash Flow Statement, Balance Sheets, Dashboard and Other Model Reports.
The basic answers are visible in their entirety, without clicking on the accordion.
Calculates the revenues from commissions on purchase orders and GMV, and then adds the seller subscriptions, subscriptions to buyers and the vendor extras included. GMV is not revenue itself.
You can change separate acquisition budgets, seasonality, seller and buyer CAC, mix levels, vitality, users running, recurring frequency, AOV, commissions, subscriptions and vendor allowances.
The alternative revenues, gross margin, premium margin and the EBITDA pathways can be compared over five years of forecasting.
The product includes P&L, Cash Flow Statement, Balance Sheet, Dashboard, Scenario Analysis, Summary and other financial opinions presented in the workbook gallery.
Yes. The financial models Lab offers custom financial modelling for various revenue logic, operational schedules, or reporting requirements.
This is a forecast built on the editing assumptions, not a guarantee of business results, financing, profitability or returns.
You will receive a comprehensive and easy-to-use financial model template designed specifically for an Urban Air Mobility development company, complete with pre-built financial statements, a dynamic dashboard, and a detailed assumptions sheet.
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