Trusted by 25,000+ startup founders, investors and CPAs
Clear Scenarios Without Guessing
Megan Walsh, OR
The low, base, and high cases were easy to compare instead of rebuilding the sheet three times. It saved me about 2 hours and made the assumptions much easier to explain.
Cash Flow Was Easy To Read
Daniel Reed, NC
I could finally see runway and shortfalls month by month without digging through formulas. That helped me spot a gap early and walk into a funding call with clearer numbers.
Saved Me Hours Of Manual Work
Priya Shah, NJ
Building the financials by hand used to take forever, but this template gave me a clean starting point right away. I cut my setup time by a full afternoon and got to the analysis faster.
Model review
What does the financial model of a product called Handmade Goods Marketplace include?
This editable five-year workbook modeled the purchase of the seller and buyer, orders and fees and then linked them to three financial statements and scenario reports.
Use it to check how the seller's growth, demand for buyers, frequency of orders, AOV, commissions, subscriptions and allowances shape the monthly economy of the market.
The Editable assumptions are the source of related calculations of revenues, costs, employment, capital and financial statements, which allow changes to flow through forecasting and management prospects.
Driver planGMV is modelled as the volume of transactions; market revenues are commissions, subscriptions and additional sales activities.
Market revenue Engine
How does this market calculate revenue?
The model acquires sellers and buyers separately, builds groups and orders of buyers, converts orders into GMV, and then coinizes transactions, subscriptions and accessories of sellers.
01
Obtaining Users
Share the purchase budgets of the seller and the buyer according to their respective CAC values to calculate new sellers and buyers.
02
Build Cohorts
Grant new sellers and buyers to separate levels and then keep each cohort for the lifetime of the standard.
03
Calculation of contracts
Add initial orders of new buyers to repeat orders from quahorite eligible active buyers by level.
04
Monetization of orders
Multiply the order at the buyer level of AOV and then apply the collection rate and the fixed commission on order.
05
Revenue sum
Add commission income, vendor and buyer subscriptions and additional sales permissions each month.
Basic formularevenue = Commission revenue + subscriptions + supplements from the seller
01 / Revenue
How are the market revenue structured?
The revenue report separates the acquisition of the seller and buyer, the mixture of levels, the life of the cohorts, the frequency of orders, AOV, commissions, subscriptions and allowances of the seller.
Revenue
Income receipts show acquisitions, cohorts, order economy, commissions, subscriptions and accessories of the seller.
02 / COGS & OPEX
How are market costs planned?
The COGS & OPEX spreadsheet provides direct costs, variable operating costs and fixed costs over the forecast period.
COGS & OPEX
COGS & OPEX sets out the assumptions for direct, variable and fixed operating expenses.
03 / Scenarios
What can be compared in different scenarios?
The scenario compares the Low, Base, and High cases for revenue, gross margin, contribution margin and EBITDA of the five-year forecast.
Scenarios
Scenario charts compare low, base and high levels of income and profitability.
04 / Dashboard
What Does the Dashboard Bring Together?
You can use the navigation desktop to review scenarios, basic finance, mix of revenues, profitability, cash flow and return charts in one place.
Dashboard
The desktop panels summarize selected scenarios, revenue mix, profitability, cash flow and return.
Product adjustment
Is the financial model handmade goods marketplace suitable for you?
It adapts to markets using separate purchases of the seller and buyer, the behaviour of the buyer's order, market fees, subscriptions and allowances of the seller; different structures may require individual modelling.
Model ready
It fits perfectly
You buy sellers and buyers separately using budget assumptions and CAC.
You predict orders from buyers from new and maintained cohorts.
You will gain commissions, subscriptions and optional revenues from sales services.
You need related scenarios and financial statements for a five-year plan.
Order structure
Think about the model
Your market uses a completely different logic of demand, fulfillment or revenue.
You need customized cohort rules beyond the life and repetition frequency.
You need operating schedules that are not represented in the current workbook.
Reporting structures are needed significantly different from the confirmed model results.
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?
Lab financial models can build or adapt a financial model when revenue logic, operating schedules or reporting requirements differ from this formula.
After making the cashier you receive an editable financial model as an immediate download to five-year forecasting and scenario-based financial planning.
01
Editable workbook
Update of market revenues, costs, employment, capital, financing and operational assumptions in the workbook.
02
Five-year forecast
Review of monthly details for the first two years and annual summaries for the fifth year.
03
Analysis of scenarios
Compare Low, Base, and High cases by controlling scenario and model outcomes.
04
Financial statements
Review of the related profit and loss account, cash flow statements and balance sheet forecasts.
Before purchase
Craft goods market Financial models FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the financial model calculate the revenues from business activities called Handmade Goods Marketplace?
It calculates orders from new and active cohort buyers, converts orders in GMV at AOV level, and then adds commissions, subscriptions and allowances to the seller as revenue.
02
Which assumptions can I change?
The purchase budgets of the seller and buyer and CAC, the mix of levels and life expectancy, the frequency of repeat orders, AOV, commission fees, subscriptions, seasonality and the possibility of additional fees of the seller can be changed.
03
What can I compare low, base, and high scenarios to?
They allow for the comparison of alternative revenue, gross margin, contribution margin and EBITDA paths under the five-year forecast.
04
What financial results are taken into account?
The product shall present the related profit and loss account, the cash flow report and balance sheet results, as well as the report on the navigation desktop and scenarios.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab offers individual financial modeling when you need a different revenue logic, operational schedule or reporting.
06
Is the workbook a prediction or a guarantee?
This is a planning forecast based on your assumptions, not a guarantee of financial results or business results.
What Does the Handmade Goods Marketplace Financial Model Contain?
This pre-written financial template for a craft marketplace business plan includes everything you need to build a comprehensive financial forecast.
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
