Trusted by 25,000+ startup founders, investors and CPAs
Saved Hours on Setup
Megan Turner, CA
I used to spend days building the numbers from scratch. This template cut that down to an afternoon, so I could focus on pricing and planning instead of wrestling with formulas.
Clearer Cash-Flow View
Brian Collins, NY
Runway used to feel like a guess. With the monthly cash flow forecast in place, I could spot a shortfall early and finish our funding plan with more confidence.
Easy Enough to Use
Laura Bennett, TX
I’m not strong in Excel, and the layout made it much easier to follow. I filled in the inputs, got a clean forecast, and booked a review meeting without needing extra help.
Model review
What does the financial model of a product called Secondhand Marketplace include?
This is an editable five-year workbook combining drivers of sellers and buyers with monthly and annual reports, scenarios and management results.
Use your workbook to plan the purchase of the seller and buyer, keep customers in terms of volume, market monetaryisation, operating costs, employee employment, capital needs and financial results.
The Editable assumptions are the source of related monthly calculations, five-year reports, scenario analyses and management reports, so that changes pass through the forecast.
Bilateral marketBefore calculating transactions and revenues from the account services, the seller and buyer shall be modelled separately.
Two-way revenue engine on the market
How does the market for used hands calculate revenue?
The model acquires buyers and sellers separately, converts orders of buyers in GMV, and then coinizes commissions, subscriptions and accessories of sellers; GMV itself is not an income.
01
Get both sides
New sellers and buyers shall be equal to their separate purchasing budget divided into their respective CAC.
02
Sections of the cohort
Set the sellers and buyers to levels and retain each cohort for the duration of its validity.
03
Build Buyer Orders
Contracts combine the initial orders of the new buyer with orders repeated from the quahorite of the eligible active buyers.
04
Monetization of transactions
GMV applies AOV at the buyer level, while commissions apply a collection rate plus fixed order fees.
05
Calculation of revenue
The monthly revenue adds revenue to the commission, seller subscriptions, buyer subscriptions and enabled additional sellers.
the spreadsheet shows the purchase of the seller and buyer, the mixture of levels, the life of the cohorts, subsequent orders, AOV, commission, subscription and additional assumptions of the seller.
Revenue
Check the purchase of the seller and buyer, maintaining levels, order economy and assumptions regarding the monetaryisation.
02 / COGS & OPEX
How are market costs organised?
The COGS and OPEX spreadsheet separates direct costs, variable operating costs and recurring fixed costs from the model forecast.
COGS & OPEX
Check direct costs, variable expenditure categories and repeated fixed operational assumptions.
03 / Scenarios
What can be compared with Low, Base, and High cases?
The scenario compares the Low, Base, and High cases for revenue, gross margin, contribution margin and EBITDA over five years.
Scenarios
Check five-year low, base and high paths to obtain four operational performance measurements.
04 / Dashboard
What does a Dashboard put in a single management view?
You can use the navigation desktop to review global configuration, multiple scenarios, basic financial results, mix of revenue, profitability, cash flow and return charts.
Dashboard
Check the model control, the outcome of the scenario, the basic financial data and the management charts together.
Product adjustment
Is the financial model of the used hand market suitable for you?
It adapts to market-based companies using this bilateral purchasing and coinisation logic; indeed, different operating rules or reporting structures may require individual modelling.
Model ready
It fits perfectly
You run a two-way market with a separate acquisition of the seller and buyer.
Revenue depends on the buyer's transactions, commission rates, subscriptions and optional add-ons of the seller.
The buyer levels use different usage times, repeat rates and average order values.
You want five-year forecasts with monthly and annual details plus low / base / high cases.
Order structure
Think about the model
The economics of the seller or buyer shall make use of a substantially different structure of acquisition or storage.
Revenues require transaction logic beyond commissions, subscriptions and accessories of the seller.
Operations require a schedule outside the market, costs, pay or structure of CAPEX.
The report requires specific results or calculations that go beyond the workbook views.
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 can build or adapt the model when you need different revenue logic, operational timetable or reporting requirements.
After purchase you receive an immediate, fully editable financial model with five-year forecasts, three scenarios and related financial statements.
01
Editable workbook
Open and change the model's assumptions in Excel or Google Sheets.
02
Five-year forecast
Five-year plan with detailed monthly and annual projections.
03
Analysis of scenarios
Compare Low, Base, and High cases in a special scenario view.
04
Financial statements
Review of the related profit and loss account, cash flow, balance sheet, summary and management results.
Before purchase
Financial model for used market FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the secondhand marketplace financial model calculate revenue?
Calculates the order of the buyer and GMV at the level of the buyer, then recognizes the revenue from commissions, subscriptions and the additional results of the seller. GMV itself is not an income.
02
What market assumptions can be changed?
You can edit separate budgets of purchase of the seller and buyer, CAC, seasonality, mixture levels, life expectancy, frequency of repeat orders, AOV, commissions, subscriptions and enabling add-ons of the seller.
03
What can I compare between Low, Base, and High scenarios?
The low, base and high revenue paths, gross margin, coverage margin and EBITDA can be compared in a five-year perspective.
04
What financial results are taken into account?
The workbook contains the profit and loss account, cash flow report, balance sheet, navigation desktop, summary, scenarios, valuations, profitability threshold, ROIC, charts, KPIs and additional reports.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab can build or customize the model when you need a different revenue logic, operating schedule or reporting.
06
Is this workbook a prediction or a guarantee?
It is a planning forecast based on edited assumptions and not a guarantee of business results.
What Does the Secondhand Marketplace Financial Model Contain?
This downloadable financial model for a peer-to-peer selling app provides all the essential tools for financial planning and analysis in one organized file.
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
