All work stories
Anonymized case studySubscription app / Multi-sided marketplace

Connecting a subscription app and marketplace to cash

An app business was combining consumer and enterprise subscriptions with later marketplaces for services and products. A subsequent model review raised questions about how launch investment, spending, assets and depreciation flowed through the three statements.

Launch planning and model reviewFinancial model
Fictional operating ecosystem showing consumer and enterprise subscriptions feeding a service-and-product marketplace.
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.

Consumers + teamsSubscription routes

Individual and enterprise customers required separate plan, billing and collection logic.

Services + goodsMarketplace layers

Service transactions, prepaid usage and product purchases followed different operating mechanics.

Fixed or variablePlatform economics

Transaction fees and supplier payouts had to remain editable rather than blended into one margin.

Three statementsIntegrity check

Funding, launch spending, capital assets and depreciation had to reconcile through profit, cash and the balance sheet.

WHY THIS WASN’T A TEMPLATE EXERCISE

The model had to respect
how the business actually moved.

The reconstructed architecture gives each revenue stream its own activity, billing and settlement schedule, then forces every launch cost, capital asset and financing input through connected profit-and-loss, cash-flow and balance-sheet checks.

01

The business changed shape after launch

The subscription app came first and marketplace activity followed later. One growth rate could not represent customer subscriptions, enterprise adoption, supplier participation and marketplace conversion on different start dates.

02

Cash moved on several clocks

Monthly card collections, longer enterprise billing, prepaid service blocks, annual supplier access and delayed supplier settlements created timing differences between activity, revenue, cost and cash.

03

Services and products did not share one margin formula

Some transactions used a fixed platform amount while others used a percentage. Service fulfillment, product purchase value and supplier economics therefore needed separate drivers and an explicit presentation policy.

04

The balance sheet had to be a control

A later review questioned the relationship among injected capital, launch spending, reported assets, negative cash and missing depreciation. Those concerns pointed to broken links that a top-line forecast alone could not reveal.

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

Customer and plan engine

Consumer and enterprise customers enter separate subscription paths so plan mix and customer type remain visible.

02

Billing and collections

Monthly and longer billing cadences flow into cash collection and receivables schedules instead of being treated as earned revenue at the same moment.

03

Marketplace activation

A launch gate introduces marketplace activity only after the core app reaches the relevant operating phase.

04

Service transactions and prepaid use

Ordinary purchases and prepaid service blocks follow separate activity, usage, revenue and supplier-payment schedules.

05

Product conversion

App traffic, purchase conversion and average order value build product activity before the fixed or percentage platform amount is applied.

06

Supplier economics

Supplier subscriptions, transaction payouts and payment terms roll forward by supplier group and settlement timing.

07

Launch spend and assets

Operating launch costs, capital expenditure and depreciation remain distinct so each item reaches the correct statement and cash period.

08

Statements and sensitivities

The integrated model reconciles profit, cash and the balance sheet before comparing changes in subscription uptake, marketplace activity, direct costs and timing.

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.

Generalized project pattern

More revenue streams created more timing states

Recurring subscriptions, prepaid services, transaction economics and supplier access could diversify the commercial model while making collections, recognition and settlement materially harder to reconcile.

Generalized project pattern

Marketplace product revenue began with app behavior

Traffic alone did not create product economics. Purchase conversion and average order value had to be modeled before any fixed or percentage platform amount could be calculated.

Reconstructed insight

Prepayment could help cash before the service was used

A prepaid service block could improve collections early while creating a later fulfillment obligation. Keeping purchase and usage on separate schedules made that timing visible.

Reconstructed insight

A balance-sheet mismatch was a diagnostic signal

If financing, launch spending, cash, assets and depreciation did not move together, the model needed repair upstream. A dashboard could summarize the problem, but it could not replace the underlying schedules.

MODELING APPROACH

The working system
behind the answer.

  • Consumer and enterprise subscription roll-forward
  • Monthly and longer-cycle billing, collection and receivables schedules
  • Marketplace activation and traffic-to-purchase conversion model
  • Service-transaction, prepaid-usage and fulfillment schedules
  • Product-category and fixed-or-percentage platform-fee module
  • Supplier subscription, payout and settlement schedules
  • Launch-cost, capital-expenditure and depreciation schedules
  • Integrated statements, dashboard checks and operating sensitivities

CASE CONFIDENTIALITY

This anonymized case explains the subscription, marketplace, supplier, launch-investment and statement-reconciliation logic without naming the client, product, suppliers, customers, market or dates. Exact plan counts, rates, transaction values, payment terms, launch timing, capital inputs, costs, cell references and dashboard outputs remain private because client work can be confidential or NDA-protected. No source document, workbook screenshot, formula, logo or identifying interface is reproduced. The illustration is an original fictional business ecosystem rather than a real app, supplier network, client deliverable 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.