Trusted by 25,000+ startup founders, investors and CPAs
Simplified Scenario Planning
Megan Carter, NY
I stopped wasting time juggling low, base, and high cases in separate tabs. It cut my planning time by about 4 hours and made it easier to explain downside and upside cases in one meeting.
Cleaner Assumption Setup
David Nguyen, CA
The pricing, cost, and growth inputs are laid out in a way that finally makes sense. I got my assumptions cleaned up in under an hour instead of rebuilding the sheet all afternoon.
Profitability Was Easy To See
Lauren Mitchell, IL
The margin and break-even views made it much easier to spot where the model was actually earning money. I booked a follow-up with my partner the same day because the numbers were finally clear.
Model review
What is the financial model of an online auction?
It is an editable five-year workbook that models the acquisition of sellers and buyers, transaction commissions, subscriptions, additions, scenarios and basic financial statements.
Use the model to plan the two-way auction market by combining separate seller and buyer growth assumptions with orders, GMV, fees and financial results.
The effects of editable purchases, level, duration of use, frequency of orders, AOV, commissions, subscriptions and additional seller data flow through monthly calculations to the reports and management reports.
The marketed Revenues remain separate from GMVThe model shall treat GMV as the transaction value and calculate revenue from the seller's commission, subscription and eligible surpluses.
revenue engine of the online auction market
How is revenue calculated in an online auction shop?
The model acquires sellers and buyers separately, builds buyers' orders at the level and GMV, and then adds seller commissions, subscriptions and surcharges as monthly revenue.
01
Get the users
The purchasing budgets of the seller and the buyer are divided by the separate CAC assumptions.
02
Building Cohorts
New sellers and buyers are allocated by level and stored for the life of each level.
03
Calculating orders
Purchasers' contracts shall combine initial contracts with recurring contracts from qualifying active purchasers' qualifications.
04
Price transactions
Orders use the buyer's AOV level to generate GMV, followed by interest and fixed commissions.
05
Total revenue
The Commission's Revenue, the seller's and the buyer's subscriptions and the seller's eligible additional amounts shall be summed up on a monthly basis.
Basic formularevenue = Commission revenue + subscriptions + supplements from the seller
01 / Revenue
How is market revenue generated?
In the revenue view, a single operating schedule organises the seller and buyer acquisitions, the levels' usage times, subsequent orders, AOV, commissions, subscriptions and monthly sales additions of the sellers.
Revenue
The revenue report shall contain information on the seller's acquisition, level, order, AOV, commission, subscription and additional inputs.
02 / COGS & OPEX
How are the operating expenses planned?
In terms of COGS and OPEX, there is a separation between direct costs, variable costs associated with acquisition and constant operating expenses, so that the monthly operating expenses are clearly linked to forecast.
COGS & OPEX
Worksheet COGS & OPEX is divided into direct costs, Variable Costs and Fixed operating expenses.
03 / Scenarios
What can be compared in different scenarios?
The scenario compares the low, basic and high levels for revenue, gross margin, contribution margin and EBITDA over the forecast period of five years.
Scenarios
The scenario report compares the low, basic and high paths for revenue and profitability measures.
04 / Dashboard
What Does the Dashboard Bring Together?
The Dashboard system combines scenario selection, financing and working capital control, core finance, a mixture of revenue, cash flow, profitability and returns reporting at a glance.
Dashboard
The Dashboard combines configuration controls, scenario results, a mix of revenue, profitability, cash flow and return charts.
Product adjustment
Is the financial model of an online auction shop right for you?
It corresponds to markets using seller and buyer acquisitions, activity in stages, commission orders, subscriptions and additional sellers; substantially different economies may require individual modelling.
Model ready
It fits perfectly
Your market is attracting sellers and buyers through separate budgets and CAC assumptions.
The buyer's activity may be planned in terms of terms, periods of use, recurring orders and AOV.
Transaction Revenue shall be based on interest rates plus optional fixed commission fees.
The seller's subscriptions and supplements constitute a substantial complement to the revenue from the market commissions.
Order structure
Think about the model
Your revenue depends on mechanisms other than buyers' transactions, subscriptions and sellers.
You need a completely different cohort, allocation, ability, or time logic.
Your operating schedules require structures that go beyond a confirmed model market configuration.
Your report requires substantially different outcomes or views on workbook decisions.
The indicator is the starting point for planning, not a guarantee of performance.
Financial modelling service for orders
Do you need a pattern that meets your requirements?
The Financial Model Laboratory may build or adapt the model where the revenue logic, operational schedules or reporting requirements differ from the finished structure.
You will receive an instantly downloadable, editable financial model of Excel with five-year monthly and annual forecasts, scenarios, reports and management reports.
01
Book to be edited
Updating the market assumptions directly in the downloaded financial model of Excel.
02
Forecast five years old
Review of forecasts with monthly and annual financial details over five years.
03
Analysis of scenarios
Compare the Low, Base and High cases in a special scenario view.
04
Financial statements
Use the income statement, the cash flow, the balance sheet, the Dashboard and the supplementary reports.
Before purchase
Online auction house financial model FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the model calculate the revenue from online auctions?
It calculates the seller's and buyer's acquisitions, buyer's orders and GMV, the seller's commissions, subscriptions and allowances, and then sums the source of revenue on a monthly basis.
02
Which assumptions can I change?
The acquisition budgets and seasonality, CAC, levels and lifetime mixes, repetition frequency, AOV, commission terms, subscription fees and seller surcharges may be changed.
03
What can I compare between low, basic and high scenarios?
Alternative cases for revenue, gross margin, contribution margin and EBITDA under the five-year forecast can be compared.
04
What financial results are taken into account?
The product shall present the income statement, the cash flow report, the balance sheet, the dashboard, the scenario analysis, the review and other supplementary reports.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab offers personalised financial modelling for different revenue logics, operational schedules or reporting requirements.
06
Is the book a prediction or a guarantee?
This is a planning forecast based on edited assumptions, not a guarantee of business results or financial results.
What Does the Online Auction House Financial Model Contain?
This downloadable online auction financial forecast spreadsheet includes everything you need to build a comprehensive financial plan from the ground up.
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
