Trusted by 25,000+ startup founders, investors and CPAs
Built For Faster Builds
Megan Carter, TX
This template saved me from rebuilding a freight brokerage model line by line. I cut hours off setup and had cleaner numbers ready for my first planning call the same day.
Scenario Planning Got Simple
Ryan Mitchell, IL
I used to juggle low, base, and high cases in separate sheets. This model kept them in one place, so I could compare assumptions in minutes instead of spending half a day sorting formulas.
Cleaner Reports, Less Hunting
Lauren Hayes, FL
I no longer had to chase the P&L, cash flow, and charts across different files. Everything was in one workbook, which made it easy to send a clean update to my team in one meeting.
MODEL OVERVIEW
What Is Brokerage Freight Finance Model?
The Brokerage Freight financial model is a five-year workbook that modeles market purchase, order economy, costs, statements and low/base / high cases.
Use the workbook to translate the purchase plans by the seller and buyer into active cohorts, orders, market revenues, operating costs and financial results.
The editorial assumptions provide monthly calculations, so changes in acquisition budgets, CAC, mixes of levels, life, order behaviour, prices, commissions, subscriptions and additions affect reports.
Built for Testing DriversChange of trade assumptions to review the impact on market size forecast and its monetisation.
REVENUE FROM TWO MARKET ENGINED ENGINE
How do You Calculate the Revenues from Broker's Activity in the Model?
The model separately acquires sellers and buyers, retains level cohorts, forecasts of buyers' orders and GMV, and then monetizes commissions, subscriptions and seller allowances each month.
01
Acquisition of Both Sides
The sales and buyer budgets divided by CACs determine new monthly users with a distinct seasonality.
02
Building of the Cohort
New users and users starting up are allocated according to the level of accuracy and retained for each duration of the model.
03
Prognose Procurement
The initial and qualified repeated orders of the buyer are merged and then the buyer-tier AOV converts these orders to GMV.
04
Apply Monetization
GMV and orders generate percentage and fixed commissions, and subscriptions and vendor allowances add recurring revenues.
05
Total Revenue
Monthly amounts of commission revenues, seller and subscriber, and included extras seller without treating GMV as revenue.
FORM OF CORRECTIONRevenue = Commission revenue + subscriptions + allowances from the seller
01 / REVENUE RESULTS
Which Marketplace Drivers Can i Edit?
The tax application may be attributed to separate transactions of acquisition of the seller and the buyer, the duration of the segment, the repeat order, AOV, commissions, subscriptions and the seller's allowances.
GROUNDS FOR THE REVENUE
Preview purchases, buyer behaviour, prices, commission, subscription and extra seller assumptions in one revenue view.
02 / COGS & OPEX
How to Structure Direct and Operational Costs?
View COGS & OPEX separates direct transaction costs, variable operating costs and fixed overhead costs with the possibility of editing the schedule and expenditure assumptions.
COGS & OPEX
The forecast shall check direct costs, variable cost factors and planned fixed operating costs.
03 / SCENARIOS
What Can the Scripts Compare?
The Scenarios compared the low, base and high cases in terms of revenue, gross margin, premium margin and EBITDA in the five-year forecast.
SCENARIOS
Review of low, base and high trends in income and key profitability measures.
04 / DASHBOARD
What Does the Distribution Board Have in Common?
The navigation desk combines configuration controls, scenario multipliers, main finances, revenue mix, profitability, cash flow and return on investment in one management view.
DASHBOARD
Review of the control of scenarios, basic financial results, revenue mix, cash flow, profitability and return charts.
FIT OF PRODUCTS
Is the Brokerage Freight Finance Model Suitable for You?
The template fits the bilateral market using a separate acquisition of the seller and buyer, the retention of cohorts, order economy, commissions, subscriptions and seller allowances.
MODEL BY MADA READY
Good Example
You purchase sellers and buyers separately from their own marketing budgets and assumptions CAC.
The buyer's value levels vary according to life expectancy, frequency of repeating the order and average order value.
Revenue combines transaction fees with sales and subscription income of the buyer.
The additions to the sale, such as advertising, listings, or processing tools, are part of the monetaryisation.
CUSTOMS STRUCTURE
Consider Custom Pattern
Your company doesn't use separate sales funnels and buyers.
The economics of the transaction requires essentially a different order, cohort, or price logic.
Your operational plans need specialized structures outside the model market drivers.
Reporting requirements require a much different financial and starting structure.
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 adapt a model when you need different revenue logic, operational schedules or reporting for needs.
You will receive an immediate, editable Excel financial model with five-year monthly and annual forecasts, scenarios, reports and management reports.
01
Editable workbook
Update of the seller, buyer, income, costs, wages, capital and financial assumptions of the model.
02
year forecast 5
Review of detailed monthly forecasts together with annual summaries throughout the five-year planning period.
03
Analysis of scenarios
Compare low, basic and high cases with regard to income and key profitability measures.
04
Financial statements
Use the Income Account, the Cash Flow, Balance, Navigation Desktop and Other Confirmed Reports.
BEFORE BUYING IMPORTANT INFORMATION
Stock Brokerage Financial Model FAQ
The basic answers are visible in their entirety, without clicking on the accordion.
01
How does the model calculate the revenues from brokerage?
Buys sellers and buyers separately, builds layer-based cohorts, predicts the buyer's orders and GMV, and then calculates commissions, subscriptions and accessories of the seller. GMV is the indirect value of the transaction, not the revenue.
02
What are the assumptions I can change?
You can change budgets and seasonality of sales and buyers, CAC, mixes and levels life, repeated orders, AOV, commission terms, subscription fees and included seller accessories.
03
What can I compare in Low, Base and High scenarios?
The Scenarios compared low, base and high revenue paths, gross margin, premium margin and EBITDA in the five-year forecast.
04
What financial results are taken into account?
The product presents a statement of income, a statement of cash flow, a balance sheet, a dashboard, a summary, an analysis of scenarios and additional financial statements and charts.
05
Can the Financial Models Lab adapt it to its own requirements?
Yes. The financial models Lab offers custom financial modelling when you need different revenue logic, operating schedules or reporting structures.
06
Is the workbook a forecast or a guarantee?
This is a forecast based on assumptions to be edited, not a guarantee of performance, profitability, financing or returns.
What Does the Freight Brokerage Financial Model Contain?
This template provides everything you need to build a comprehensive financial plan, from initial cost analysis for freight brokerage operations to a five-year pro forma income statement.
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.
GROUNDS FOR THE REVENUE
COGS & OPEX
SCENARIOS
DASHBOARD
