Trusted by 25,000+ startup founders, investors and CPAs
Saved Hours on Setup
Michael Turner, TX
Building the model by hand would have taken me days, and this template cut that to a few hours. I had a working forecast fast, so I could spend time on delivery planning instead of spreadsheets.
Fewer Formula Headaches
Laura Bennett, NC
One broken formula can wreck a model, and this one kept everything organized and easy to trace. I spotted inputs quickly, made updates without fear, and sent a cleaner version to my partner the same day.
Clear View of Profitability
Daniel Ortiz, FL
This made margins and break-even much easier to see. I went from guessing at profitability to having a clear read on monthly cash flow and payback, which helped me prepare for a lender call.
MODEL OVERVIEW
What Is the Financial Model of the Last Delivery?
This is a five-year market forecast that sales and acquisition models, influence on orders, monthly and annual reports and scenario results.
Use the workbook to plan how separate sales and purchase programs translate into active market participants, orders, GMV, commissions, subscriptions and vendor allowances.
Therefore, the forecast may take account of changes in acquisition, combination of tiers, lifetime, frequency of orders, prices and charges.
Built for bilateral market planningThe sales and the buyer economy are modelled separately before their transaction activities are combined with market revenues.
REVENUE FROM TWO MARKET ENGINED ENGINE
How Does Model Calculate the Revenue from Deliveries Once Last?
The model acquires sellers and buyers separately, retains level cohorts, converts active buyers to orders and GMV, and then adds commissions, subscriptions and vendor allowances.
01
Buy Users
The budgets of sellers and buyers are divided by their assumptions of CAC to calculate new users.
02
Building of the Cohort
New users are allocated according to tiers and retained for each model lifetime.
03
Project Procurement
Purchasers’ orders combine the business of the new buyer with orders repeated from authorised active cohorts.
04
Census Activity
Orders use the buyer-level AOV, take the rates, fixed fees for the order, subscriptions and included in the sale of allowances.
05
Total Revenue
Monthly market revenues add up the income of commission, seller and subscriber, and the seller's allowances.
FORM OF CORRECTIONRevenue = GMV × Take Rate + Charges for Order + Subscriptions + Extras for Sale
01 / REVENUE
How to Structure Revenue Sales?
The income sheet separates the purchase, purchase, preservation of the level of accuracy, order economy, procurement resources, subscriptions and vendor allowances that provide monthly marketplace revenues.
REVENUE
The revenue worksheet shows acquisition, level, order, AOV, commission, subscription and additional input fees.
02 / COGS & OPEX
How Are Delivery and Operating Costs Modelled?
The COGS & OPEX card organises direct costs, variable operating costs and fixed expenditure with assumptions on schedule and revenue associated with margins and cash flow.
COGS & OPEX
The COGS & OPEX worksheet separates direct, variable and fixed assumptions of operating costs.
03 / SCENARIOS
What Does Scenario Analysis Compare?
The Scenarios compared low, base and high cases in relation to revenues, gross margin, premium margins and EBITDA to show how alternative assumptions change key results.
SCENARIOS
Scenarios Charts Sheets Low, Base and High cases in the main five years of results.
04 / DASHBOARD
What Can You Read on the Navigation Desktop?
The table contains global settings, scenario multipliers, selected operational and financial indicators, revenue set, profitability, cash flow and return on investment in one management view.
DASHBOARD
The board includes configuration checks, scenario results, basic finances and management charts.
FIT OF PRODUCTS
Is the Financial Model of the Last Delivery Suitable for You?
It fits market operators using a separate acquisition of a seller and buyer with transaction and account revenues; generally different operating logic may require a non-standard structure.
MODEL BY MADA READY
Good Example
You purchase sellers and buyers with separate marketing budgets and assumptions CAC.
You need a level-specific durability, mixes, repeat orders and average order values.
You're monetizing GMV through percentage rates and fixed commissions on order.
You also collect subscriptions or an additional part of the seller, such as promotions or tools.
CUSTOMS STRUCTURE
Consider Custom Pattern
Your income does not depend on the bilateral structure of the sales and purchase market.
You need material other fulfillment, fleet, route, or logic planning ability.
You require operating modules outside the acquisition and transaction frameworks of the model.
You need a different reporting structure or your own decision results for your organisation.
The template is the starting point of planning, not a guarantee of performance.
FINANCIAL MODEL SERVICE
Do You Need a Model Built Around Your Requirements?
The financial models of Lab can build or customize a model when you need a different revenue logic, operating schedules or reporting than the ready template provides.
After you have completed your order, you will receive the last-mile delivery model for five-year planning in Excel or Google sheets.
01
Editable workbook
Open and edit your financial model in Excel or Google Sheets.
02
Five-year forecast
Review of the five-year forecast containing detailed monthly and annual financial opinions.
03
Analysis of scenarios
Compare low, base and high cases through a special view of the script.
04
Financial statements
Review of related revenue, cash flow, balance sheet, dashboard and summary of results.
BEFORE BUYING IMPORTANT INFORMATION
The Last-mile Financial Model FAQ
The basic answers are visible in their entirety, without clicking on the accordion.
01
How does the model calculate the revenue from the last mile delivery?
Calculates the separate acquisitions of the seller and buyer, the buyer’s order and GMV and then adds the percentage and fixed commissions, subscriptions and included the seller’s allowances.
02
What are the assumptions I can change?
You can edit the budgets of sellers and buyers, seasonality, CAC, mixes levels, vitality, order frequency, AOV, commissions, subscriptions and included vendor accessories.
03
What can I compare in Low, Base and High scenarios?
The Scenarios compare low, base and high case forecasts for the main results, such as revenue, gross margin, premium margin and EBITDA.
04
What financial results are taken into account?
The product shows a related income statement, cash flow, balance sheet, distribution panel, summary, scenario and other reporting opinions.
05
Can the Financial Models Lab adapt it to its own requirements?
Yes. The financial models Lab offers custom financial modelling for various revenue logic, operational schedules, or reporting requirements.
06
Is the workbook a forecast or a guarantee?
This is a planned forecast based on the assumptions to be edited, not a guarantee of the results of business activity or financial results.
What Does the Last-Mile Delivery Financial Model Contain?
You get a pre-built financial model for your local delivery service, complete with a dynamic dashboard, detailed financial statements, and fully customizable assumption tabs.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
REVENUE
COGS & OPEX
SCENARIOS
DASHBOARD
