Clearer Investor Story
This model gave me the structure I was missing, so I could show investors exactly what mattered without rebuilding the file. I booked a follow-up meeting the same day because the outputs finally made sense.
This model gave me the structure I was missing, so I could show investors exactly what mattered without rebuilding the file. I booked a follow-up meeting the same day because the outputs finally made sense.
I could finally see margins and break-even in one place instead of digging through tabs. It cut my planning time by a few hours and made the numbers much easier to explain.
The pricing, cost, and growth inputs were laid out cleanly, so I could update everything without losing track. What used to feel messy is now a model I can actually work with in minutes.
This is a five-year market creation workbook that combines the business of the seller and buyer with monthly and annual financial statements, scenarios and results of the panel.
Use the model to plan how delivery and demand for a patient or transport facility translate into orders, GMV, commissions, subscriptions, vendor allowances, costs, personnel, cash and profitability.
The purchase budgets that can be edited, CAC, level mixes, cohort life periods, order frequency, AOV, commission terms, subscriptions, seller allowances, expenses, wages and investment funds are the basis for the related forecast and reports.
The model acquires sellers and buyers separately, retains layered cohorts, calculates initial and repeats the buyer's orders, applies AOV and commission terms and then adds subscriptions and accessories to the seller.
Sales and buyer budgets divided by CAC, with seasonality, calculate monthly new users.
New sellers and buyers enter different levels and remain active for each life period in Tier.
The buyer's orders combine the initial orders from new buyers with the orders repeated from authorised cohorts.
Orders times buyer-tier AOV create GMV, then accept the bet and fixed fees create commissions.
The Commission's revenue, the seller's and buyer's subscriptions and the allowances for the seller shall be added up monthly.
The Commission therefore considers that, in the absence of State aid to BSCA, it cannot be considered State aid.
REVENUE
The COGS & OPEX worksheet organises direct costs, variable expenditure and fixed general assumptions that affect the monthly operating forecast.
COGS & OPEX
The Scenarios compare low, base and high revenue, gross margin, premium margins and EBITDA over the time horizon.
SCENARIOS
The data table consolidates scenario control, basic finances, income mix, profitability, cash flow and return on investment in one management view.
DASHBOARD
The ready model fits the bilateral market economy with the levels of cohorts and the coining of orders; materially different revenue logic or schedules may require custom modelling.
The template is the starting point of planning, not a guarantee of performance.
Lab financial models can build or customize a model when you need a different revenue logic, operating schedules or reporting from a ready-made template.
ORDER A CUSTOM FINANCIAL MODELYou will receive a fully edited workbook for handling patients transport with five-year forecasting, scenario analysis, integrated financial statements and management reports available for immediate download.
Updating the market, costs, wages, capital and other available model inputs.
Review of monthly calculations and annual financial projections throughout the five-year planning period.
Compare low, base and high revenue, margin, contribution and EBITDA cases.
Use integrated statements, dashboard views, summary results, charts and supporting financial statements.
The basic answers are visible in their entirety, without clicking on the accordion.
Combines the buyer's orders with specific orders from the level of AOV and commission terms, and then adds the seller's subscriptions, the buyer's subscriptions and the included seller's accessories. GMV remains the centre of transaction value, not revenue.
You can change separate acquisition budgets and seasonality, seller and buyer CAC, mixes of levels and life, frequency of repeat orders, AOV, commission terms, subscription fees and included in the sale.
The Scenarios compared alternative income, gross margin, premium margin and EBITDA over the forecast period.
The product page contains a statement of income, statement of cash flow, balance sheet, navigation desk, summary, valuation, break-even, ROIC, charts, KPIs, indicators and additional reports.
Yes. Custom financial modelling can adjust revenue logic, operational schedules and reporting when the ready structure does not fit the required model.
This is a financial planning forecast based on the assumptions to be edited, not a guarantee of the performance of business or financial results.
You get a comprehensive, five-year patient transport service profit and loss statement template with integrated financial statements, a cap table, and a dynamic dashboard.
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