Acquire Both Sides
Seller and buyer marketing budgets divided by their respective CAC values create new users.
It is an editable five-year workbook that models seller and buyer acquisition, cohort activity, orders, GMV, marketplace fees, and linked financial statements.
Use the workbook to plan separate seller and buyer acquisition, retained cohorts, buyer orders and GMV, then commissions, subscriptions, and seller extras as revenue.
Editable assumptions feed monthly and annual projections, Low/Base/High scenarios, core financial statements, and the management dashboard.
Separate seller and buyer acquisition builds retained cohorts; buyer orders create GMV, while commissions, subscriptions, and seller extras generate monthly revenue.
Seller and buyer marketing budgets divided by their respective CAC values create new users.
Sellers and buyers are split into separate tiers; starting and new cohorts remain active for their stated lifetimes.
Initial and repeat orders from eligible buyer cohorts combine, then multiply by tier AOV to create GMV.
GMV take rates and fixed order fees create commission revenue, alongside subscriptions and seller extras.
Monthly marketplace revenue sums commissions, seller subscriptions, buyer subscriptions, and enabled seller extras; GMV itself is not revenue.
The Revenue Assumptions sheet connects seller and buyer acquisition, tier cohorts, repeat orders, AOV, commissions, subscriptions, and seller extras to monthly revenue.
REVENUE ASSUMPTIONS
The COGS & Operational Expenses sheet separates direct costs, revenue-linked variable expenses, and scheduled fixed overhead across the forecast.
COGS & OPERATIONAL EXPENSES
The Scenario Analysis view charts Low, Base, and High paths for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
SCENARIO ANALYSIS
The Dashboard combines global setup, scenario controls, core financials, revenue mix, profitability, cash flow, and investment payback into one management view.
DASHBOARD
The ready-made model fits two-sided marketplace economics with cohort retention and transaction monetization; materially different royalty logic, schedules, or reporting may require custom structure.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or financial reporting for your requirements.
ORDER A CUSTOM FINANCIAL MODELYou receive an editable Excel and Google Sheets-ready financial model with five-year projections, Low/Base/High scenario analysis, dashboard reporting, and linked financial statements.
Excel and Google Sheets-ready files let you change marketplace, operating, and financial assumptions.
Monthly and annual projections cover five forecast years.
Low, Base, and High cases support comparison of alternative operating and financial outcomes.
Dashboard, P&L, cash flow, balance sheet, summary, and supporting reports organize projected results.
The essential answers are visible in full, with no accordion clicks required.
It acquires sellers and buyers separately, retains cohorts, builds initial and repeat buyer orders, calculates GMV, and monetizes activity through commissions, subscriptions, and seller extras.
You can edit seller and buyer budgets and seasonality, CAC, tier mixes, lifetimes, starting users, repeat frequency, AOV, take rate, fixed commission, subscription fees, and seller extras.
You can compare modeled revenue, gross margin, contribution margin, and EBITDA paths across Low, Base, and High cases.
The workbook includes a dashboard, P&L, cash flow, balance sheet, summary, scenario analysis, and supporting financial reports.
Yes. Financial Models Lab can build or adapt a model when your revenue logic, operating schedules, or reporting requirements need a different structure.
No. It is an editable planning forecast driven by assumptions, not a guarantee of business performance.
This royalty income forecasting Excel model includes everything you need to build a comprehensive financial plan, from detailed revenue and expense sheets to summary dashboards and key financial statements.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark
This template made margins and break-even easy to spot, so I stopped guessing at profitability. I cut my monthly planning time by hours and had a cleaner number to share in our next meeting.
I liked that the structure was already set, because one broken cell in a model like this can throw off everything. It saved me a full afternoon of checking formulas and gave me a version I could trust before sending it out.
Starting from scratch always stalled me, but this gave me a real place to begin. I had a working royalty management model in under an hour, and it made the first client call much easier.