Clear Runway In Minutes
This template made our cash flow much easier to read, so we could spot a shortfall before it became a problem. It saved us about 6 hours of guesswork and gave us a cleaner plan for runway.
This template made our cash flow much easier to read, so we could spot a shortfall before it became a problem. It saved us about 6 hours of guesswork and gave us a cleaner plan for runway.
I was staring at a blank file for days, and this gave me a starting point right away. We built the first draft in one afternoon instead of spending a week piecing it together.
The low, base, and high cases were already set up in a way that actually made sense, so I wasn’t rebuilding scenarios by hand. It cut our planning time by almost half and made the assumptions easier to explain.
It is an editable five-year forecast marketplace built around seller and buyer acquisitions, buyer orders, commissions, subscriptions, costs and financial statements.
Use the workbook to translate separate seller and buyer acquisition plans into active cohorts, buyer transactions, market revenue, operating expenses and cash needs over time.
The editable assumptions shall provide monthly calculations and include annual reviews, financial statements, scenario comparisons and management reports where appropriate.
The model acquires sellers and buyers separately, builds active groups, calculates buyers' orders and GMV, and then monetizes transactions, subscriptions and additional sellers.
The seller and buyer's monthly budget follows the seasonality of the individual pages and is then divided into the CAC of the individual pages.
New sellers and buyers enter each level and remain active throughout the life of each level.
Purchasers' orders shall combine original purchases with recurring orders from eligible active purchaser cohorts.
The Regulations and the AOV level constitute a GMV which handles interest and fixed commission on orders.
Revenue to the Commission, seller and buyer subscriptions and additional seller amounts up to monthly revenue.
Worksheet revenue organises the acquisition of the seller and the buyer, the mix of levels, the lifetime, the retention of the order, the AOV, the commission terms, the subscriptions and the supplements of the seller.
Revenue
Worksheet COGS and OPEX separate direct costs, variable and fixed costs operating expenses as part of the five-year forecast and monthly schedule.
COGS & OPEX
The scenario compares the Low, Base, and High results for revenue, gross margin, contribution margin and EBITDA across the forecast horizon.
Scenarios
You can use the dashboard to view model settings, scenario selection, key finances, mix of revenue, profitability, cash flow and payback period charts of investments in one place.
Dashboard
A ready-made model fits into a bilateral market economy using these factors of acquisition, cohort, transaction and monetisation; structurally different firms may require individual modelling.
The indicator is the starting point for planning, not a guarantee of performance.
Financial Models Lab can build or customize a model when your business needs a different revenue logic, operational schedule or financial reporting structure.
Order of the financial model for the orderAfter purchase, you will receive an editable five-year financial model AI Matchmaking Service for instant download and use in Excel or Google Sheets.
Update assumptions regarding the market, costs, personnel, capital and model configuration of the plan.
Review of the monthly calculations with annual projections over the five-year model horizon.
Compare Low, Base, and High cases through the model scenario framework.
The financial review shall be carried out using financial statements, dashboard and supporting reports.
The basic answers are visible in their entirety, without the need to click on the accordion.
It calculates the purchaser's orders and GMV and then recognises the commission, the seller's and the buyer's subscriptions and the additional sales received from the seller as revenue. GMV itself is not revenue.
You can edit seller and buyer acquisition budgets, seasonality, CAC, level mixes, duration, repeat order frequency, AOV, commission terms, subscriptions and seller allowances.
A comparison can be made of how the alternative cases change revenue, gross margin, contribution margin and EBITDA over the forecast period.
In workbook you will find income statement, the report from cash flow, the balance sheet, dashboard, the scenarios, the summary and the additional financial statements shown in the product gallery.
Yes. the Financial Models Lab offers individual financial modelling where different revenue logics, operational schedules or reporting structures are required.
This is a planning forecast based on edited assumptions, not a guarantee of business results or financial results.
You get a comprehensive financial model for your online matchmaking service, complete with a 5-year forecast, dynamic dashboard, and detailed breakdowns of revenues, costs, and staffing.
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