BusinessPlanHub

Two-Sided Marketplace Model: Free Excel Template

The BusinessPlanHub marketplace financial model is a free Excel download that turns traffic, transactions and take rate into revenue, with three statements over 60 months.

Download the free model Book a free consultation

Free · Excel (.xlsx) · Imports into Google Sheets

Download the marketplace financial model

Pick this if you earn a percentage of transactions rather than selling goods.

We use your email to send you the model and offer a free consultation. No spam.

What is the difference between GMV and revenue for a marketplace?

GMV is the total value of what changes hands on your platform. Revenue is only the share you keep. In the BusinessPlanHub marketplace model, revenue equals GMV multiplied by the take rate.

This is a common mistake in marketplace forecasts. A founder shows a large GMV figure on the revenue line, and the reader marks the whole model down. Show both numbers, label them, and let the income statement carry only the take.

How does the model build revenue?

It builds revenue from the buyer side in a short chain, one month at a time.

StepInput you setOutput
Visitors arriveWeb traffic, conversion rateNew customers
Customers returnReturning customer rateTotal customers
Customers transactAverage monthly transactions per customerTotal transactions
Transactions have sizeAverage transaction sizeGMV
You take a shareTake rateRevenue

Change the take rate and revenue moves one for one. Change the number of transactions and everything moves.

One caution on the middle rows. Transactions per customer is where optimism hides. A marketplace for a rare purchase, such as a one-off service, may see a customer once a year. One for weekly needs may see them four times a month. Pick the figure from your own category and say why.

Most of the 60-month model grows from that chain. The Financials tab then builds an income statement, balance sheet and statement of cash flows from it.

How should I set the take rate?

Set the take rate from what sellers will accept, then check what is left after you pay to process the money. Do not choose it from a competitor’s headline figure.

A seller compares your cut with their other options. Your payment processing cost also comes out of what you keep. The file has a payment processing line, so make sure the two fit. A take rate that looks healthy can shrink fast once those fees are paid.

Say how you reached the figure. A lender or investor will ask, and “it is what others charge” is a weak answer.

Why is customer acquisition harder for a two-sided marketplace?

You have to attract two groups, and each one only wants to come if the other is already there. Buyers want choice. Sellers want buyers.

That has a cost consequence. In practice, you usually pay to recruit one side before the other can find value. The file models customer acquisition through its channels, so build the cost of getting the first sellers into your own sales and marketing or people plan, and state it as an assumption. The 25-row people plan helps here: a seller-recruiting role is a salary line, not a rounding error.

The ten acquisition channels are the same as in the other models. Fill in only the ones you will really use.

What will a lender or investor question first?

Expect the same three questions.

  1. Where does repeat usage come from? A returning customer rate set high in month one has no evidence behind it.
  2. Is the take rate sustainable? Can you keep it once sellers have other options?
  3. What does it cost to get both sides? Is the cost of seller recruitment in the numbers?

Read what investors look for before you share your model. Remember the reader’s job is to find the assumption that breaks.

What does the marketplace file leave out?

It does not model supply-side behaviour directly, seller churn, or disputes and chargebacks. Those matter. Add them as rows or fold them into your assumptions, and note what you did.

If you earn a fee on payments rather than listings, the transaction-based model may fit better. All the models are listed on the financial model template hub.

Get a second opinion, free

The take rate and the acquisition cost of the first sellers are the two inputs worth a second opinion.

If you would like someone to look at them, book a free 30-minute consultation.

Sample business plans that fit this model

These are sample plans for businesses that earn money the way this model does. Every sample plan is a fictional example, so use it for structure, not for figures.

Browse more: Technology business plans

Marketplace financial model: common questions

Is GMV the same as revenue in this template?

No. Revenue is GMV multiplied by your take rate. The file builds it that way: total transactions times average transaction size gives GMV, and the take rate gives what you keep.

Does the model separate supply and demand?

It models customers acquired through your channels and their transactions. Supply-side costs, such as recruiting sellers, you add to sales and marketing or as your own assumptions.

Can I open the marketplace model in Google Sheets?

Yes, through File > Import in Google Sheets. Recheck the Financials tab once it has loaded.

Are the example numbers real benchmarks?

No. They only make the formulas calculate. Use your own traffic, transaction size and take rate.