All work stories
Anonymized case studyConsumer fintech / Card membership

Modeling fintech growth from acquisition to ownership dilution

A consumer fintech model had to connect how customers arrived and stayed with card issuance, everyday transactions, cross-border conversion, subscription tiers and the financing needed to support growth. A top-line forecast alone would not show when customer growth translated into value—or what each capital round cost in dilution.

Launch, growth and fundraising planningFinancial model
Fictional fintech service connecting customer onboarding and verification with repeated card use at everyday merchants and a basic freemium path.
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.

Paid + organic + referralAcquisition system

Each route enters the same customer forecast while keeping its own economic driver visible.

Paid → basic → inactiveCustomer lifecycle

Retention, churn and the freemium fallback determine which customers can still generate value.

Recurring + usageRevenue system

Subscriptions sit beside transaction and conversion-linked revenue rather than being blended into one average.

Cash + ownershipFunding view

Operating liquidity and fully diluted ownership are evaluated within the same growth plan.

WHY THIS WASN’T A TEMPLATE EXERCISE

The model had to respect
how the business actually moved.

The formula-linked model rolls acquisition into retained, churned, freemium and inactive cohorts; converts active cards into transactions and separate revenue streams; and connects the operating forecast to cash burn, break-even, valuation and ownership dilution.

01

Acquisition did not equal an active customer

Marketing, organic demand and referrals created new accounts, but only retained customers continued into paid membership and card activity. Churned customers then split between a limited basic tier and inactivity.

02

Recurring and usage revenue shared a customer, not a driver

Subscription revenue followed retained paid members. Transaction and conversion revenue also depended on cards per member, usage frequency, transaction value and mix, so one blended revenue-per-user assumption would hide the operating logic.

03

Onboarding costs arrived before repeat activity

Marketing, identity verification and card issuance were incurred as customers entered the system. The economic value of those customers depended on how long they stayed and how often they used the service afterward.

04

Funding solved cash and changed ownership

Successive capital rounds could support growth, but each round also changed founder, employee and investor ownership. The financing schedule therefore had to connect liquidity to dilution rather than treat them as separate presentations.

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

Launch calendar

A monthly forecast controls when acquisition, operating costs and customer activity begin, then summarizes results into annual decision views.

02

Acquisition channels

Marketing spend and acquisition cost build paid customers, while organic demand and referrals remain separate growth routes.

03

Customer cohorts

Each acquisition period flows through retained, churned, freemium and inactive balances instead of relying on one closing customer total.

04

Cards and onboarding

Retained members determine active cards, while new additions create issuance and identity-verification costs.

05

Transaction activity

Cards, frequency and average value create payment volume; a separate mix assumption isolates activity involving conversion.

06

Revenue stack

Transaction fees, conversion-linked revenue, paid subscriptions and the lower-value freemium tier are calculated independently.

07

Operating model

Pre-launch spending, fixed expenses, people, variable costs and investment feed the income statement, cash flow and balance sheet.

08

Capital and decision outputs

Cash burn, break-even, sensitivities and valuation sit beside debt, equity rounds, options and the fully diluted capitalization table.

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

Marketing and referrals formed a compound growth system

A stronger referral rate amplified the customer base created by marketing and organic demand. Testing referral efficiency beside acquisition spend showed why the channels could not be planned as simple substitutes.

Reconstructed insight

Retention affected more than subscription revenue

When a paid member churned, the model lost recurring membership value and the card activity that supported transaction and conversion revenue. A freemium path preserved a smaller relationship, but did not recreate the paid economics.

Generalized project pattern

Activity could change value without changing customer count

The same number of retained members could produce a different result when card adoption, payment frequency, average transaction value or conversion mix changed.

Reconstructed insight

Every funding round had two consequences

New capital changed the cash available to execute the plan and the ownership retained by founders and employees. Keeping both effects visible turned fundraising from a plug into a strategic tradeoff.

MODELING APPROACH

The working system
behind the answer.

  • Monthly paid, organic and referral acquisition forecast
  • Retained, churned, freemium and inactive customer cohorts
  • Card issuance, identity-verification and active-card schedules
  • Transaction-frequency, value and conversion-mix model
  • Subscription, freemium, transaction and conversion-linked revenue schedules
  • Pre-launch, payroll, fixed-expense, variable-cost and investment plans
  • Integrated income statement, cash flow and balance sheet
  • Cash-burn, break-even, KPI and acquisition sensitivity views
  • Debt, equity-round, option-pool, capitalization and valuation models

CASE CONFIDENTIALITY

This anonymized case explains the customer, card, subscription, transaction, operating-cost, funding and ownership logic without naming the client, individuals, company, product, model author, market or dates. Exact acquisition, churn, card, transaction, pricing, cost, staffing, financing, cap-table, valuation and forecast inputs remain private because client work can be confidential or NDA-protected. No source workbook, screenshot, chart, formula, logo or branded interface is reproduced. The illustration is an original fictional service ecosystem rather than a real platform, office, merchant, customer, card program 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.