Trusted by 25,000+ startup founders, investors and CPAs
Clear Scenarios In One File
Megan Foster, NY
This saved me from juggling low, base, and high cases in separate tabs. I had all three scenarios ready in under an hour, and it made our board discussion much easier.
Cash Flow Became Easier To Read
Daniel Reed, TX
I could finally see runway and shortfalls without building the whole thing myself. It helped me spot a funding gap two months earlier than I expected, which made our planning a lot calmer.
No More Blank Spreadsheet Stress
Lauren Mitchell, CA
Starting from scratch felt impossible, and this template gave me a clean place to begin. I went from an empty file to a working forecast in one afternoon.
Model review
What is the financial model of the auction house?
Financial model Auction House is an editable five-year workbook Excel for the acquisition of sellers and buyers, revenue market, three-state scenarios and forecasts.
Use it to plan seller and buyer acquisitions, repeat orders, GMV-based commissions, subscriptions, seller additional costs, operating expenses and the resulting cash needs.
The editable assumptions flow through the monthly operational calculations to the five-year financial statements, scenario comparisons and management reports.
First, market logicGMV tracks the value of the transaction; revenue is the commission, subscription and additional income of the seller from the market activity.
Auction Market revenue Engine
How does the auction house model calculate revenue?
Revenue is calculated from the buyer's transaction and commission and then the seller's and buyer's subscriptions plus the seller's additional activities are added each month.
01
Get both sides
Separate purchasing budgets and CACs identify new sellers and new buyers, using monthly seasonality.
02
Building horizontal cohorts
New sellers and buyers are allocated by level and stored for the life of each level.
03
Calculating orders
Initial and recurring orders from qualifying active buyers generate orders and GMV of the buyer's level.
04
Monetization activity
GMV counting and orders generate commissions, while subscriptions and seller-to-seller additions increase revenue from services.
05
Total revenue
The monthly marketable revenue is equal to the commission income plus the seller's subscriptions, buyer's subscriptions and seller's surpluses.
Basic formularevenue = Commission revenue + subscriptions + supplements from the seller
01 / Revenue assumptions
What leads to market revenue?
The revenue article combines separate seller and buyer acquisitions, level maintenance, order activity, AOV, commission settings, subscriptions and supplements from the seller.
Revenue assumptions
Check the purchase, level, order, price, commission, subscription and additional seller information in one sheet.
02 / COGS & operating expenses
How are operating expenses organised?
The COGS and operating expenses section separates direct costs, variable acquisition and support expenses and fixed general costs across forecast.
COGS and operating expenses
Check the percentages of direct costs, the variables driving expenditure, the categories of fixed expenditure and the estimated monthly amounts.
03 / Analysis of the scenario
How do you compare alternative cases?
The scenario analysis compares low, basic and high cases with respect to revenue, gross margin, contribution margin and EBITDA over five years.
Analysis of scenarios
Check the five-year low, basic and high level charts for revenue and key profitability measures.
04 / Dashboard
What Does the Dashboard Bring Together?
In conclusion, if funds are placed on the market under the Dashboard programme, appropriate results can be obtained if the introduction of the Cash Flow scheme will have a characteristic impact on the financial situation.
Dashboard
Review controls on scenarios, basic finances, revenue mixtures, profitability, cash flow and repayment results.
Product adjustment
Is the financial model of the auction house right for you?
It is appropriate for markets using this acquisition logic and seller-buyer transactions; structurally different revenue, activity or reporting requirements may require individual modelling.
Model ready
It fits perfectly
You buy sellers and buyers separately using CAC budgets and assumptions.
Transactions with buyers lead to GMV, commissions, subscriptions and optional supplements from the seller.
The mix of levels, viability, recurring orders, AOV and seasonality corresponds to the market.
You need five-year statements, low/basic/high cases, and management reports in one workbook.
Order structure
Think about the model
Your revenue is not primarily a two-way market of sellers and buyers.
You need a very different logic of cohort behavior than the vibrancy and frequency of repetition.
You need tailored operating schedules beyond model purchase, cost, payment, or CAPEX structure.
You need reporting mechanics or transactions that require changes to the structural model.
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.
Once you've made the money, you'll receive an editable workbook Auction House on five-year planning, scenario analysis, financial statements and management reports.
01
Book to be edited
Changes in purchase, level, orders, prices, commissions, subscriptions, costs, employment and investment commitments.
02
Forecast five years old
A review of the projected financial results over the five-year model planning horizon.
03
Analysis of scenarios
Comparison of low, basic and high levels of each revenue and profitability measure.
04
Financial statements
Use the projected income statement, cash flow, balance sheet and management reporting results.
Before purchase
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 Financial model of the Auction House calculate revenue?
It calculates the purchaser's transaction fees and then adds the seller's and buyer's subscriptions plus the seller's eligible supplements. GMV itself is not revenue.
02
Which assumptions can I change?
It is possible to edit separate seller and buyer acquisition budgets, seasonality, CACs, level mixes, lifetime, repeat order frequency, AOV, commissions, subscriptions and additional seller results.
03
What can I compare between low, basic and high scenarios?
Low, Base and High cases can be compared for revenue, gross margin, contribution margin and EBITDA over the five-year period of forecast.
04
What financial results are taken into account?
The product shall present the projected income statement, the cash flow report, the balance sheet, the scenario analysis, the dashboard, the summary and the additional management 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 forecast based on edited assumptions, not a guarantee of business results or financial results.
What Does the Auction House Financial Model Contain?
This is a complete, downloadable auction house cash flow model designed to help you plan, fund, and launch your business.
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 assumptions
COGS and operating expenses
Analysis of scenarios
Dashboard
