All work stories
Anonymized case studyServices marketplace / Online and on-site work

Connecting marketplace acquisition to fees, cash and break-even

A two-sided services marketplace needed to distinguish offline and digital outreach to providers and buyers, then connect those acquisition paths to active participants, completed service activity and platform fees.

Growth, pricing and funding planningFinancial model
Fictional services marketplace connecting offline and digital outreach to buyers, remote professionals, on-site providers and completed service work.
Original concept illustration. No client data shown.
CONFIDENTIAL BY DESIGNWhy you won’t see the client workbook

Financial models contain pricing, salaries, conversion assumptions, funding plans and other sensitive data. I do not publish client workbooks, identifiable screenshots or proprietary inputs—especially where an NDA applies. This page uses an anonymized summary and original concept art to explain the business decision and my modeling approach.

Offline + digitalAcquisition routes

Each route can carry its own start timing, seasonal pattern, budget and acquisition cost.

Providers ↔ buyersNetwork balance

Both sides accumulate separately before marketplace activity is calculated.

Interest → completed workRevenue gate

Registrations become economically relevant only through active buyers and successful service activity.

Fees → cashDecision bridge

Pricing, costs, working capital and funding remain connected to the operating engine.

WHY THIS WASN’T A TEMPLATE EXERCISE

The model had to respect
how the business actually moved.

The supplied formula-linked workbook connects annual marketing budgets and monthly seasonality to user acquisition, active participants, successful deals, two-sided fees, costs, cash, funding, break-even and valuation. The reconstruction keeps unresolved pricing rules visibly separate from implemented calculations.

01

Marketing was an assumption, not a demand guarantee

Outreach could attract providers and buyers, but neither registrations nor completed services were assured. The forecast needed an explicit bridge from spending to acquisition and then to activity.

02

Acquisition paths did not behave alike

Offline and digital campaigns could begin at different times, follow different monthly patterns and acquire each side of the marketplace at different costs.

03

Registered users were not the same as completed deals

The model had to distinguish the active population, the number of service opportunities, the share completed and the value of those completed transactions.

04

Both sides of a completed deal affected pricing

Provider and buyer fees were linked to the same completed service value, so changing either side altered revenue and downstream profitability.

05

The pricing discussion extended beyond the base engine

The scope raised minimum-charge and service-channel questions that were not visible as separate calculations in the supplied workbook. Those items had to remain explicit gaps rather than assumed features.

06

Capital outputs depended on operating assumptions

Break-even, minimum cash, funding needs and valuation sat downstream from acquisition, transaction behavior, costs, working capital and launch investment.

MODEL ARCHITECTURE

From operating activity
to a decision-ready view.

Each layer has one job. Together they keep the commercial story, unit economics and cash consequences on the same timeline.

01

Campaign architecture

Offline and digital budgets are separated by audience and service channel, with an explicit start date for each acquisition lane.

02

Monthly seasonality

Annual budgets are distributed across months, with launch-year weights normalized when a campaign starts partway through the year.

03

Acquisition economics

Monthly campaign spend is divided by the applicable acquisition cost to estimate new providers and buyers.

04

Active marketplace base

Acquired providers and buyers accumulate into separate active populations and a visible network-balance measure.

05

Service opportunities

Active buyers and expected monthly frequency determine the number of potential marketplace deals.

06

Completion and mix

A success rate converts opportunities into completed work, which is then allocated across customer-size groups with different average values.

07

Two-sided fee revenue

Provider and buyer percentage fees are calculated separately on completed service value, then reconciled into total marketplace revenue.

08

Pricing-extension register

Minimum charges, channel-specific pricing and other exceptions remain outside the base engine until each has a defined and testable calculation path.

09

Costs, people and investment

Direct costs, operating expenses, payroll, launch spending, assets and working capital carry the resource consequences of the growth plan.

10

Statements and decision views

Integrated statements, sources and uses, capitalization, break-even scenarios, fee sensitivity and cash-flow valuation connect operations to funding decisions.

WHAT THE ANALYSIS SURFACED

Useful answers,
without exposing client data.

The takeaways are intentionally qualitative. Exact assumptions, calculations and outputs remain inside the confidential client model.

Reconstructed insight

Registrations needed a second conversion step

Acquisition estimates became decision-useful only after the model separated active participants, service frequency and the share of deals successfully completed.

Generalized project pattern

Seasonality mattered most around launch timing

A campaign beginning partway through a year needed its remaining monthly weights recalibrated so the annual budget was neither lost nor double-counted.

Reconstructed insight

Marketing mix affected both growth speed and unit cost

Moving budget between outreach routes could change when each side joined the platform and how much acquisition capacity the same spend produced.

Generalized project pattern

Fee sensitivity was inherently two-dimensional

Provider-side and buyer-side rates both changed revenue, but the effect still depended on completed deal value and the fixed and variable cost base.

Reconstructed insight

A pricing question was not an implemented rule

Keeping minimum charges and channel-specific exceptions in a visible gap register prevented a scope discussion from being mistaken for a formula already present in the model.

Generalized project pattern

Funding and value remained scenario outputs

Sources and uses, break-even and discounted value became traceable planning views, not proof that users, transactions, financing or returns had occurred.

MODELING APPROACH

The working system
behind the answer.

  • Offline and digital marketing assumption schedule
  • Monthly launch-timing and seasonality engine
  • Provider and buyer acquisition-cost schedules
  • Active-participant and network-balance bridge
  • Deal frequency, completion, service-mix and value schedules
  • Provider- and buyer-side fee-revenue schedules
  • Direct-cost, operating-expense and payroll model
  • Launch investment, assets and working-capital schedules
  • Integrated income statement, cash flow and balance sheet
  • Sources and uses, capitalization, break-even, fee sensitivity and valuation views

CASE CONFIDENTIALITY

This anonymized case explains the acquisition, participant, transaction, fee, cost, cash and funding logic without naming the client, platform, people, location or dates. Exact marketing, pricing, registration, activity, service-mix, transaction, cost, staffing, asset, working-capital, financing, ownership, forecast, break-even and valuation assumptions remain private because client work can be confidential or NDA-protected. No workbook, worksheet, formula, chart, screenshot, source document, file name, logo, interface or proprietary term is reproduced. The sources were reviewed as planning evidence, not as a recalculation, financial-model audit, accuracy certification, legal assessment or proof of implementation. The illustration is an original fictional services marketplace rather than a real platform, client asset, workplace or operating result.

CUSTOM PROJECTS START AT $2,500 USD

Need a financial model?
Or the complete business package?

The final fee reflects the agreed scope, complexity and deliverables. Combined packages are quoted individually.