DealScout

FWDI M&A Financial Analysis and Sensitivity

Comprehensive financial modeling for CoinGecko and Stocktwits acquisition opportunities.


Executive Summary

MetricCoinGeckoStocktwits
Entry Price$400M$72M
Base Case Y3 Revenue$94M$39M
Base Case Y3 EBITDA$68.5M$14M
Base Case Exit Value$752M$234M
Base Case MOIC1.9x3.25x
Base Case IRR23%48%
Expected MOIC (prob-weighted)2.2x3.6x
Breakeven Connection/Growth Rate3%15% MAU CAGR

Key Finding: Stocktwits offers higher expected returns (3.6x vs 2.2x MOIC) but with higher execution risk and lower strategic fit. CoinGecko offers more moderate returns with better strategic alignment.


Part 1: CoinGecko Financial Model

1.1 Current State Analysis

Revenue Decomposition

StreamRevenue% MixARPUKey Driver
Advertising$13.3M33%$0.3340M MAU × $0.33
API/Data$13.3M33%N/A~500 enterprise clients × $26.6K avg
CeFi Referrals$13.3M33%$0.33Affiliate clicks × conversion × bounty
Total$40M100%$1.00

User Economics (Current)

MetricValueBenchmarkAssessment
MAU40M-Top 3 crypto data site
DAU~4M (est.)-10% DAU/MAU (estimated)
ARPU$1.00Stocktwits: $20Very low monetization
Session Duration~3 min (est.)-Quick lookup behavior
Pages/Session~3 (est.)-Price check + 1-2 more
Geo Mix~30% US, ~70% RoW-Explains low ARPU

Cost Structure (Estimated)

CategoryAmount% RevBasis
Headcount (100 × $80K)$8M20%Malaysia-based, lower costs
Infrastructure$4M10%Data + hosting
Data Acquisition$3M8%API data sources
G&A$3M8%Corporate overhead
Total OpEx$18M45%
EBITDA$22M55%Strong margin

1.2 Revenue Model - Existing Business

Ad Revenue Model

Ad Revenue = MAU × Sessions/MAU × Impressions/Session × CPM/1000
VariableBearBaseBullNotes
MAU (M)354050Crypto market correlation
Sessions/MAU/month22.53Engagement level
Impressions/session345Ad density
Blended CPM$0.40$0.55$0.80Geo-adjusted

Ad Revenue Calculation:

ScenarioMonthly ImpressionsAnnual Revenue
Bear35M × 2 × 3 = 210M$1.0M × 12 = $12.0M
Base40M × 2.5 × 4 = 400M$2.2M × 12 = $13.2M
Bull50M × 3 × 5 = 750M$6.0M × 12 = $18.0M

API Revenue Model

API Revenue = Enterprise Clients × Avg Contract Value
VariableBearBaseBull
Enterprise clients450520650
ACV$25K$28K$32K
Revenue$11.3M$14.6M$20.8M

Referral Revenue Model

Referral Revenue = Clicks × Conversion Rate × Avg Bounty
VariableBearBaseBull
Monthly referral clicks800K1.2M2.0M
Conversion rate3%4%5%
Avg bounty$25$35$50
Annual Revenue$7.2M$20.2M$60.0M

Note: Referral revenue is highly volatile with crypto markets

Total Existing Revenue by Scenario

StreamBearBaseBull
Advertising$12.0M$13.2M$18.0M
API/Data$11.3M$14.6M$20.8M
Referrals$7.2M$20.2M$60.0M
Total Existing$30.5M$48.0M$98.8M

1.3 Revenue Model - New Trading Business

Conversion Funnel Model (Detailed)

StageDefinitionBearBaseBullCalculation
MAUMonthly active users35M40M50MMarket dependent
AwarenessSee trading feature50%70%85%UX prominence
↳ Aware Users17.5M28.0M42.5MMAU × Awareness
InterestClick to learn more10%20%30%Value prop
↳ Interested1.75M5.6M12.75M× Interest
ConnectionConnect wallet20%35%50%Friction
↳ Connected350K1.96M6.38M× Connection
FundingDeposit funds15%25%40%Trust
↳ Funded53K490K2.55M× Funding
ActivationComplete first trade40%60%75%UX quality
↳ Activated21K294K1.91M× Activation
RetentionMonthly active trader30%50%65%Stickiness
Monthly Traders6.3K147K1.24M× Retention

Funnel Rate Summary

PathBearBaseBull
MAU → Connected1.0%4.9%12.8%
Connected → Funded15%25%40%
Funded → Monthly Trader12%30%49%
MAU → Monthly Trader0.02%0.37%2.48%

Trading Economics

VariableBearBaseBullRationale
Avg trades/month3815Activity intensity
Avg trade size$75$150$300Retail ticket
Monthly volume/trader$225$1,200$4,500
Take rate (bps)305075Spread + fees
Monthly rev/trader$0.68$6.00$33.75
Annual rev/trader$8.10$72.00$405.00

Trading Revenue Build-Up

MetricBearBaseBull
Monthly traders6,300147,0001,240,000
Monthly volume$1.4M$176M$5.6B
Annual volume$17.0M$2.1B$67B
Take rate30 bps50 bps75 bps
Annual Trading Revenue$51K$10.6M$502M

Sanity check: Bull case implies 2.5% of MAU becoming monthly traders generating $400/yr each. This is aggressive but not impossible given pump.fun ($1,400 ARPU) and Robinhood ($197 ARPU) comparables.

Trading Revenue Ramp (Base Case)

QuarterMonthly TradersQtrly VolumeQtrly Revenue
Y1 Q110K$36M$180K
Y1 Q230K$108M$540K
Y1 Q370K$252M$1.26M
Y1 Q4120K$432M$2.16M
Y1 Total$828M$4.1M
Y2 Q1150K$540M$2.7M
Y2 Q2180K$648M$3.24M
Y2 Q3200K$720M$3.6M
Y2 Q4220K$792M$3.96M
Y2 Total$2.7B$13.5M
Y3 (annual)300K avg$4.3B$21.6M

Additional New Revenue Streams

StreamY1Y2Y3Basis
Staking/Yield$0.5M$2.0M$4.0MYield aggregation
Premium Features$0.5M$1.5M$3.0MPro tier
NFT Marketplace$0$1.0M$2.0MIf market recovers
Other New$1.0M$4.5M$9.0M

1.4 Total Revenue Model - CoinGecko

Base Case Revenue Build

StreamY0Y1Y2Y3Y4Y5
Advertising$13.3M$13.5M$14.0M$15.0M$16.0M$17.0M
API/Data$13.3M$14.6M$16.5M$18.5M$20.5M$22.5M
Referrals$13.3M$15.0M$18.0M$20.0M$22.0M$24.0M
Existing Total$40.0M$43.1M$48.5M$53.5M$58.5M$63.5M
Trading$0$4.1M$13.5M$21.6M$30.0M$40.0M
Other New$0$1.0M$4.5M$9.0M$12.0M$15.0M
New Total$0$5.1M$18.0M$30.6M$42.0M$55.0M
TOTAL REVENUE$40.0M$48.2M$66.5M$84.1M$100.5M$118.5M
YoY Growth-21%38%26%20%18%

Scenario Comparison - Revenue

ScenarioY1Y2Y3Y5
Bear$35M$38M$42M$50M
Base$48M$67M$84M$119M
Bull$70M$120M$180M$280M

1.5 Cost Model - CoinGecko

Investment Plan

CategoryY1Y2Y3Y4Y5Notes
Existing OpEx$19M$20M$21M$22M$23M5% annual growth
Product/Eng Hires$3M$2M$1.5M$1M$1MTrading team build
Infrastructure$2M$2M$1.5M$1M$1MTrading scale
Marketing$1M$2M$2.5M$3M$3MFeature awareness
Compliance$1M$1M$0.5M$0.5M$0.5MRegulatory
Incremental Total$7M$7M$6M$5.5M$5.5M
TOTAL OPEX$26M$27M$27M$27.5M$28.5M

Pro Forma P&L - Base Case

Line ItemY0Y1Y2Y3Y4Y5
Revenue$40.0M$48.2M$66.5M$84.1M$100.5M$118.5M
Gross Margin85%83%80%78%77%76%
Gross Profit$34.0M$40.0M$53.2M$65.6M$77.4M$90.1M
OpEx$18.0M$26.0M$27.0M$27.0M$27.5M$28.5M
EBITDA$16.0M$14.0M$26.2M$38.6M$49.9M$61.6M
EBITDA Margin40%29%39%46%50%52%
D&A$2M$2.5M$3M$3.5M$4M$4.5M
EBIT$14.0M$11.5M$23.2M$35.1M$45.9M$57.1M
Tax (25%)$3.5M$2.9M$5.8M$8.8M$11.5M$14.3M
Net Income$10.5M$8.6M$17.4M$26.3M$34.4M$42.8M

P&L by Scenario - Year 3

LineBearBaseBull
Revenue$42M$84M$180M
Gross Profit$34M$66M$135M
OpEx$25M$27M$35M
EBITDA$9M$39M$100M
EBITDA Margin21%46%56%
Net Income$5M$26M$70M

1.6 Valuation Model - CoinGecko

Comparable Transactions

CompanyYearRevenueEVMultipleNotes
CoinMarketCap2020~$30M$400M13xBinance acquisition
TradingView2021~$200M$3B15xGrowth equity
eToro2021$600M$10B17xSPAC (later failed)
Robinhood2021$1.8B$32B18xIPO peak
Robinhood2024$2.0B$8B4xCurrent

Multiple Framework:

Revenue ScaleBear MultipleBase MultipleBull Multiple
<$50M5x7x10x
$50-100M6x8x12x
$100-200M7x10x15x
>$200M8x12x18x

Exit Valuation - Year 3

ScenarioY3 RevenueMultipleEnterprise Value
Bear$42M6x$252M
Base$84M8x$672M
Bull$180M12x$2,160M

Exit Valuation - Year 5

ScenarioY5 RevenueMultipleEnterprise Value
Bear$50M5x$250M
Base$119M9x$1,071M
Bull$280M14x$3,920M

1.7 Returns Analysis - CoinGecko

Entry Price Scenarios

Entry PriceBasis
$300M7.5x current, aggressive negotiation
$350M8.75x current, earnout structure
$400M10x current, current ask
$450M11.25x current, competitive process
$500M12.5x current, bidding war

MOIC by Entry Price and Scenario (3-Year Exit)

Entry \ ScenarioBear ($252M)Base ($672M)Bull ($2,160M)
$300M0.84x2.24x7.20x
$350M0.72x1.92x6.17x
$400M0.63x1.68x5.40x
$450M0.56x1.49x4.80x
$500M0.50x1.34x4.32x

MOIC by Entry Price and Scenario (5-Year Exit)

Entry \ ScenarioBear ($250M)Base ($1,071M)Bull ($3,920M)
$300M0.83x3.57x13.07x
$350M0.71x3.06x11.20x
$400M0.63x2.68x9.80x
$450M0.56x2.38x8.71x
$500M0.50x2.14x7.84x

IRR Analysis (3-Year Hold)

Entry \ ScenarioBearBaseBull
$300M-6%30%93%
$350M-10%24%84%
$400M-14%19%76%
$450M-18%15%69%
$500M-21%11%63%

IRR Analysis (5-Year Hold)

Entry \ ScenarioBearBaseBull
$300M-4%29%68%
$350M-7%25%62%
$400M-9%22%58%
$450M-11%19%54%
$500M-13%16%51%

Part 2: Stocktwits Financial Model

2.1 Current State Analysis

Revenue Decomposition

StreamRevenue% MixDriver
Programmatic Ads$6.75M45%MAU × impressions × CPM
Direct Ads$6.75M45%Sales team capacity
Subscriptions$0.75M5%Premium users
Other$0.75M5%Events, data
Total$15M100%

User Economics (Current)

MetricValueNotes
MAU750KFlat for years
DAU350KExceptional engagement
DAU/MAU47%4-5x typical social
ARPU$2020x CoinGecko
High-twitch traders~50K DAUCore monetization target
Posts/DAU~0.3 (est.)Active content creation
Geo~85% USExplains high ARPU

Cost Structure (Current)

CategoryAmount% Rev
Headcount (~75)$10M67%
Infrastructure$1.5M10%
G&A$1.5M10%
Total OpEx$13M87%
EBITDA$2M13%

2.2 Growth Model - Stocktwits

User Growth Framework

New MAU = Prior MAU × (1 - Churn) + Organic Adds + Paid Adds
VariableBearBaseBullNotes
Annual churn25%20%15%Platform stickiness
Organic adds/month2K5K10KProduct + word of mouth
Marketing budget/year$0$3M$8MGrowth investment
CACN/A$20$15Paid efficiency
Paid adds/year0150K533KMarketing ÷ CAC

MAU Projection

YearBearBaseBullBase YoY
Y0750K750K750K-
Y1688K910K1,158K+21%
Y2640K1,138K1,694K+25%
Y3608K1,422K2,395K+25%
Y4578K1,778K3,353K+25%
Y5549K2,222K4,694K+25%

DAU Projection (Engagement Preservation)

YearMAUDAU/MAUDAUDAU Growth
Y0750K47%353K-
Y1910K44%400K+14%
Y21,138K42%478K+20%
Y31,422K40%569K+19%
Y41,778K38%676K+19%
Y52,222K37%822K+22%

Note: DAU/MAU erosion is modeled as new users are typically less engaged than legacy users

Engagement Risk Sensitivity

DAU/MAU at Y3Implied DAURevenue Impact
47% (maintained)668K+$3M vs base
42% (base)597KBase case
37% (eroded)526K-$2.5M vs base
30% (degraded)427K-$6M vs base

2.3 Revenue Model - Existing Business

Ad Revenue Model

Ad Revenue = DAU × Sessions/DAU × Ad loads/Session × CPM/1000
VariableBearBaseBull
DAU at Y3213K569K1,078K
Sessions/DAU/day2.53.03.5
Ad loads/session81012
Days/year365365365
CPM$3.50$4.50$6.00

Ad Revenue by Scenario (Y3)

ScenarioAnnual ImpressionsCPMRevenue
Bear1.56B$3.50$5.5M
Base6.23B$4.50$28.0M
Bull16.3B$6.00$97.9M

Existing Revenue Projection (Base Case)

StreamY0Y1Y2Y3Y4Y5
Programmatic$6.75M$7.5M$9.5M$12.0M$15.0M$19.0M
Direct$6.75M$7.5M$10.0M$14.0M$18.0M$23.0M
Subscriptions$0.75M$1.0M$1.5M$2.0M$2.5M$3.0M
Other$0.75M$1.0M$1.0M$1.0M$1.0M$1.0M
Total Existing$15.0M$17.0M$22.0M$29.0M$36.5M$46.0M

2.4 Revenue Model - Crypto Products

Crypto Adoption Funnel

StageDefinitionBearBaseBull
MAU (Y3)Total users608K1,422K2,395K
AwarenessSee crypto features40%60%80%
↳ Aware243K853K1,916K
InterestExplore features15%30%45%
↳ Interested36K256K862K
ConnectionLink wallet20%35%50%
↳ Connected7.3K90K431K
FundingDeposit funds20%35%50%
↳ Funded1.5K31K216K
ActivationFirst crypto action50%70%85%
↳ Active crypto73022K183K
RetentionMonthly active40%55%70%
Monthly Crypto Users29012K128K

Crypto Product Mix

ProductY1 ShareY2 ShareY3 ShareRevenue/User
Basic trading100%60%40%$50/yr
Perps0%25%35%$300/yr
Prediction markets0%10%15%$150/yr
Prop bets / PvP0%5%10%$200/yr

Blended Crypto ARPU

YearProduct MixBlended ARPU
Y1100% basic$50
Y260/25/10/5$130
Y340/35/15/10$178

Crypto Revenue Projection

MetricY1Y2Y3Y4Y5
Monthly crypto users1K5K12K25K45K
Blended ARPU$50$130$178$200$220
Crypto Revenue$0.05M$0.65M$2.1M$5.0M$9.9M

2.5 Total Revenue Model - Stocktwits

Base Case Revenue Build

StreamY0Y1Y2Y3Y4Y5
Ad Revenue$13.5M$15.0M$19.5M$26.0M$33.0M$42.0M
Subscriptions$0.75M$1.0M$1.5M$2.0M$2.5M$3.0M
Other$0.75M$1.0M$1.0M$1.0M$1.0M$1.0M
Existing Total$15.0M$17.0M$22.0M$29.0M$36.5M$46.0M
Crypto Products$0$0.05M$0.65M$2.1M$5.0M$9.9M
TOTAL REVENUE$15.0M$17.1M$22.7M$31.1M$41.5M$55.9M
YoY Growth-14%33%37%33%35%

Scenario Comparison - Revenue

ScenarioY1Y2Y3Y5
Bear$13M$12M$11M$10M
Base$17M$23M$31M$56M
Bull$22M$38M$65M$140M

2.6 Cost Model - Stocktwits

Transformation Investment Plan

CategoryY1Y2Y3Y4Y5Notes
Restructured Base OpEx$8M$9M$10M$11M$12MPost-turnover
New Leadership$2M$2M$2M$2M$2MCEO + CTO
Product Team$4M$4M$3M$3M$3MEng + design
Marketing$3M$4M$5M$6M$7MGrowth spend
Compliance$1M$1M$1M$1M$1MCrypto products
Transition Costs$2M$0$0$0$0Severance
New Investment Total$12M$11M$11M$12M$13M
TOTAL OPEX$20M$20M$21M$23M$25M

Pro Forma P&L - Base Case

Line ItemY0Y1Y2Y3Y4Y5
Revenue$15.0M$17.1M$22.7M$31.1M$41.5M$55.9M
Gross Margin75%70%72%74%75%76%
Gross Profit$11.3M$12.0M$16.3M$23.0M$31.1M$42.5M
OpEx$13.0M$20.0M$20.0M$21.0M$23.0M$25.0M
EBITDA$-1.7M$-8.0M$-3.7M$2.0M$8.1M$17.5M
EBITDA Margin-11%-47%-16%6%20%31%
D&A$1M$1.5M$2M$2M$2M$2M
EBIT$-2.7M$-9.5M$-5.7M$0$6.1M$15.5M

Note: Negative EBITDA in Y1-Y2 reflects transformation investment. This is expected.

Cumulative Cash Burn (Base Case)

YearEBITDACumulative
Y1-$8.0M-$8.0M
Y2-$3.7M-$11.7M
Y3+$2.0M-$9.7M
Y4+$8.1M-$1.6M
Y5+$17.5M+$15.9M

Total cash requirement: ~$12M beyond initial investment


2.7 Valuation Model - Stocktwits

Comparable Transactions

CompanyYearRevenueMultipleContext
StockTwits (prior round)2021~$10M5xSecondary
eToro2024~$600M3xDown round
Twitter2022$5B6xMusk acquisition
Discord2021~$200M75xExtreme outlier

Multiple Framework:

Revenue ScaleBearBaseBull
<$20M3x4x6x
$20-50M4x6x8x
$50-100M5x7x10x
>$100M6x8x12x

Exit Valuation - Year 3

ScenarioY3 RevenueMultipleEnterprise Value
Bear$11M3x$33M
Base$31M6x$187M
Bull$65M8x$520M

Exit Valuation - Year 5

ScenarioY5 RevenueMultipleEnterprise Value
Bear$10M2x$20M
Base$56M7x$392M
Bull$140M10x$1,400M

2.8 Returns Analysis - Stocktwits

MOIC by Entry Price and Scenario (3-Year Exit)

Entry \ ScenarioBear ($33M)Base ($187M)Bull ($520M)
$50M0.66x3.74x10.40x
$60M0.55x3.12x8.67x
$72M0.46x2.60x7.22x
$80M0.41x2.34x6.50x
$90M0.37x2.08x5.78x

MOIC by Entry Price and Scenario (5-Year Exit)

Entry \ ScenarioBear ($20M)Base ($392M)Bull ($1,400M)
$50M0.40x7.84x28.00x
$60M0.33x6.53x23.33x
$72M0.28x5.44x19.44x
$80M0.25x4.90x17.50x
$90M0.22x4.36x15.56x

IRR Analysis (3-Year Hold)

Entry \ ScenarioBearBaseBull
$50M-13%55%118%
$60M-18%46%105%
$72M-23%38%93%
$80M-26%33%86%
$90M-28%28%79%

IRR Analysis (5-Year Hold)

Entry \ ScenarioBearBaseBull
$50M-17%51%95%
$60M-20%45%88%
$72M-22%40%81%
$80M-24%37%77%
$90M-26%34%73%

Part 3: Sensitivity Analysis

3.1 CoinGecko Tornado Analysis

Variables Ranked by Impact on Y3 Valuation

RankVariableLow ValueBaseHigh ValueLow EVHigh EVSwing
1Wallet Connection Rate1%5%10%$380M$1,050M$670M
2Take Rate (bps)305075$540M$850M$310M
3Exit Multiple6x8x10x$504M$840M$336M
4MAU Retention-20%0%+20%$520M$830M$310M
5Funded Wallet Conversion15%25%40%$550M$810M$260M
6Trades per Trader3815$580M$780M$200M
7Avg Trade Size$75$150$300$590M$770M$180M
8Existing Revenue Growth-10%+5%+15%$620M$720M$100M

Visual Tornado (ASCII)

                         $400M         $672M         $1,000M
                           |             |             |
Wallet Connection   [===========|===========================] $670M swing
Take Rate          [======|=======================] $310M swing
Exit Multiple      [=======|===================] $336M swing
MAU Retention      [======|====================] $310M swing
Funded Conversion  [=====|==================] $260M swing
Trades/Trader      [=====|===============] $200M swing
Avg Trade Size     [=====|==============] $180M swing
Existing Growth    [===|===========] $100M swing
                           |             |             |
                        Bear          Base          Bull

Key Insight

Wallet connection rate dominates. The difference between 1% and 10% connection is $670M in enterprise value. This single variable is 2x more important than any other.


3.2 CoinGecko Two-Variable Sensitivity Tables

Table 1: Entry Price vs. Wallet Connection Rate (MOIC at Y3)

Entry \ Connection1%2%3%5%7%10%
$300M0.9x1.3x1.6x2.2x2.8x3.5x
$350M0.8x1.1x1.4x1.9x2.4x3.0x
$400M0.7x1.0x1.2x1.7x2.1x2.6x
$450M0.6x0.9x1.1x1.5x1.9x2.3x
$500M0.5x0.8x1.0x1.3x1.7x2.1x

Interpretation: At $400M entry, need 3%+ connection rate to break even, 5%+ for 1.5x return.

Table 2: Wallet Connection Rate vs. Take Rate (Y3 Trading Revenue)

Connection \ Take30 bps40 bps50 bps60 bps75 bps
1%$2.5M$3.4M$4.2M$5.1M$6.4M
2%$5.1M$6.8M$8.5M$10.2M$12.7M
3%$7.6M$10.2M$12.7M$15.3M$19.1M
5%$12.7M$17.0M$21.2M$25.5M$31.9M
7%$17.8M$23.8M$29.7M$35.7M$44.6M
10%$25.5M$34.0M$42.5M$51.0M$63.7M

Table 3: Entry Price vs. Exit Multiple (MOIC at Y3, Base Case)

Entry \ Multiple5x6x7x8x10x12x
$300M1.4x1.7x2.0x2.2x2.8x3.4x
$350M1.2x1.4x1.7x1.9x2.4x2.9x
$400M1.1x1.3x1.5x1.7x2.1x2.5x
$450M0.9x1.1x1.3x1.5x1.9x2.2x
$500M0.8x1.0x1.2x1.3x1.7x2.0x

3.3 Stocktwits Tornado Analysis

Variables Ranked by Impact on Y3 Valuation

RankVariableLowBaseHighLow EVHigh EVSwing
1MAU Growth Rate0%25%50%$66M$360M$294M
2Exit Multiple4x6x8x$124M$248M$124M
3DAU/MAU Preservation30%40%47%$140M$230M$90M
4Crypto Adoption Rate2%8%15%$165M$230M$65M
5Ad ARPU Growth-10%0%+15%$170M$210M$40M
6Marketing Efficiency$30 CAC$20$12$175M$205M$30M

Visual Tornado (ASCII)

                         $50M          $187M         $350M
                           |             |             |
MAU Growth Rate    [==========|=============================] $294M swing
Exit Multiple      [========|================] $124M swing
DAU/MAU            [======|==============] $90M swing
Crypto Adoption    [=====|============] $65M swing
Ad ARPU Growth     [====|==========] $40M swing
Marketing CAC      [===|=========] $30M swing
                           |             |             |
                        Bear          Base          Bull

Key Insight

MAU growth rate is by far the most important driver (~$294M swing). If Stocktwits can't solve growth, the deal doesn't work. All other variables are secondary.


3.4 Stocktwits Two-Variable Sensitivity Tables

Table 1: MAU Growth CAGR vs. DAU/MAU (MOIC at Y3)

Growth \ DAU/MAU30%35%40%45%47%
-10% (shrink)0.3x0.4x0.4x0.5x0.5x
0% (flat)0.6x0.7x0.9x1.0x1.1x
15%1.3x1.5x1.8x2.1x2.2x
25%1.8x2.1x2.6x3.0x3.2x
35%2.4x2.9x3.5x4.1x4.4x
50%3.2x3.9x4.7x5.5x5.9x

Interpretation: At flat growth (historical), returns are marginal. Need 15%+ CAGR for acceptable returns.

Table 2: Entry Price vs. MAU Growth (MOIC at Y3)

Entry \ MAU CAGR0%10%20%25%35%
$50M1.0x1.7x2.6x3.2x4.5x
$60M0.8x1.4x2.2x2.7x3.7x
$72M0.7x1.2x1.8x2.2x3.1x
$80M0.6x1.1x1.6x2.0x2.8x
$100M0.5x0.9x1.3x1.6x2.2x

Table 3: MAU Growth vs. Crypto Adoption (Y3 Revenue)

Growth \ Crypto Adopt2%5%8%12%15%
0%$15M$16M$17M$18M$19M
15%$23M$25M$27M$30M$32M
25%$28M$31M$34M$38M$41M
35%$35M$38M$43M$49M$54M
50%$45M$50M$57M$66M$74M

3.5 Breakeven Analysis

CoinGecko: What Rate Gets Us to 1.5x MOIC at $400M Entry?

VariableRequired ValueBase CaseGap
Wallet Connection4.5%5%OK
Take Rate45 bps50 bpsOK
Exit Multiple7.5x8xOK
Combined ThresholdAll three at floorAchievable

Conclusion: Base case assumptions leave reasonable margin for error.

Stocktwits: What Growth Gets Us to 1.5x MOIC at $72M Entry?

VariableRequired ValueBase CaseHistorical
MAU CAGR15%25%0%
DAU/MAU38%40%47%

Conclusion: Requires cracking a growth problem that hasn't been solved in years.


Part 4: Scenario Analysis

4.1 CoinGecko Scenario Matrix

ScenarioProbDescriptionY3 RevMultipleY3 EVMOIC
Disaster10%Crypto winter + execution fail$30M4x$120M0.30x
Bear20%Crypto flat + slow adoption$50M6x$300M0.75x
Base40%Crypto recovery + trading works$84M8x$672M1.68x
Bull20%Strong crypto + high conversion$140M10x$1,400M3.50x
Exceptional10%Everything works$220M14x$3,080M7.70x

Probability-Weighted Expected Value

EV = (0.10 × $120M) + (0.20 × $300M) + (0.40 × $672M) + (0.20 × $1,400M) + (0.10 × $3,080M)
EV = $12M + $60M + $269M + $280M + $308M
EV = $929M

Expected MOIC at $400M entry: 2.32x Expected IRR (3-year): ~32%

Scenario Probability Distribution

Disaster [10%] ████████████████████ $120M
Bear     [20%] ████████████████████████████████████████ $300M
Base     [40%] ████████████████████████████████████████████████████████████████████████████████ $672M
Bull     [20%] ████████████████████████████████████████ $1,400M
Excep.   [10%] ████████████████████ $3,080M

Loss Probability

  • P(MOIC < 1.0x) = P(Disaster) + P(Bear) = 30%
  • P(MOIC < 1.5x) = P(Disaster) + P(Bear) + ~½ P(Base) = 50%

4.2 Stocktwits Scenario Matrix

ScenarioProbDescriptionY3 RevMultipleY3 EVMOIC
Disaster15%Execution fail, user loss$8M2x$16M0.22x
Bear25%No growth, modest crypto$15M3x$45M0.63x
Base35%Moderate growth, crypto works$31M6x$186M2.58x
Bull20%Strong growth + crypto$60M8x$480M6.67x
Exceptional5%Breakout growth$120M12x$1,440M20.00x

Probability-Weighted Expected Value

EV = (0.15 × $16M) + (0.25 × $45M) + (0.35 × $186M) + (0.20 × $480M) + (0.05 × $1,440M)
EV = $2.4M + $11.3M + $65.1M + $96M + $72M
EV = $247M

Expected MOIC at $72M entry: 3.43x Expected IRR (3-year): ~51%

Scenario Probability Distribution

Disaster [15%] ██████████████████████████████ $16M
Bear     [25%] ██████████████████████████████████████████████████ $45M
Base     [35%] ██████████████████████████████████████████████████████████████████████ $186M
Bull     [20%] ████████████████████████████████████████ $480M
Excep.   [5%]  ██████████ $1,440M

Loss Probability

  • P(MOIC < 1.0x) = P(Disaster) + P(Bear) = 40%
  • P(MOIC < 1.5x) = P(Disaster) + P(Bear) = 40%

4.3 Comparative Scenario Analysis

Side-by-Side Comparison

MetricCoinGeckoStocktwitsDifference
Entry Price$400M$72M5.6x more expensive
Expected Value$929M$247M3.8x higher
Expected MOIC2.32x3.43xST 48% better
Expected IRR32%51%ST 19pp better
Loss Probability30%40%CG safer
Breakeven Probability50%40%ST higher floor
Capital at Risk$400M$72MST much lower
Max Loss (×prob)$280M × 10%$56M × 15%$28M vs $8.4M

Risk-Adjusted Returns

MetricCoinGeckoStocktwits
Expected MOIC2.32x3.43x
Std Dev of MOIC~2.3x~5.5x
Sharpe-like ratio0.570.44
Sortino-like ratio0.850.65

Interpretation: CoinGecko has better risk-adjusted returns (more consistent outcomes). Stocktwits has higher expected returns but with much wider variance.

Portfolio View

StrategyCapitalExpected ValueExpected ProfitMOIC
CoinGecko only$400M$929M$529M2.32x
Stocktwits only$72M$247M$175M3.43x
Both$472M$1,176M$704M2.49x
CG + 2× ST$544M$1,423M$879M2.62x

Part 5: Decision Framework

5.1 🚦 Go/No-Go Criteria

CoinGecko: Proceed if ALL TRUE

#CriterionThresholdCurrent Status
1Wallet connection rate achievableUser research shows >5% intent🔴 Not validated
2Traffic source diversifiedGoogle <50% of traffic🔴 Not validated
3Team quality validatedSite visit passes🟡 Pending Jan 26-27
4Entry price reasonable<$450M or earnout structure🟡 TBD
5Legal path clearKey products legal in US🔴 Not validated
6FWDI can fundCapital structure works🔴 Not validated

Gate Passed: 0/6

Stocktwits: Proceed if ALL TRUE

#CriterionThresholdCurrent Status
1CEO/CTO identified and committedNamed candidates before LOI🔴 Not validated
2User crypto interestSurvey shows >15% interest🔴 Not validated
3Regulatory path clearPerps/prediction markets viable🔴 Not validated
4Howard Lindzon alignedSupports full transformation🔴 Not validated
5Milestone structure agreedCapital deployment tied to results🔴 Not validated

Gate Passed: 0/5


5.2 ⛔ Walk-Away Triggers

CoinGecko

TriggerExplanation
⛔ User research shows <3% wallet intentCore thesis fails
⛔ Google traffic >60%Platform risk too high
⛔ Team unable to build trading productNeed to hire externally
⛔ Entry price >$500MReturns unacceptable
⛔ No legal path in USKey market excluded
⛔ Competitive bid >$600MLet bidder win

Stocktwits

TriggerExplanation
⛔ Cannot find CEO/CTOExecution impossible
⛔ User research shows <10% crypto interestCore thesis fails
⛔ Perps/prediction markets illegal for USKey products blocked
⛔ Howard Lindzon demands controlGovernance conflict
⛔ Historical user data shows declining engagementAsset degrading

5.3 Negotiation Strategy

CoinGecko Target Structure

ComponentTargetRationale
Base consideration$300M7.5x revenue
Earnout pool$100M25% of deal
Earnout triggerTrading revenue milestonesDe-risk thesis
Y1 milestone$5M trading revenue = $30M
Y2 milestone$15M trading revenue = $40M
Y3 milestone$30M trading revenue = $30M
Total if all hit$400MSame as ask
Total if miss$300MProtected entry

Stocktwits Target Structure

ComponentTargetRationale
Initial acquisition$40M for 80%Lower base
Primary investment$5M (Tranche 1)Initial runway
Product milestone$5M (Tranche 2)On product launch
Revenue milestone$10M (Tranche 3)On $25M revenue
Total if all hit$60Mvs. $72M ask
Total if stall$45MCapital preserved

5.4 ✅ Recommendation Summary

Primary Recommendation: CoinGecko with Validation

Action: Proceed to validation phase, but ⛔ DO NOT sign LOI until:

  1. ☑️ User survey validates conversion thesis
  2. ☑️ Traffic data confirms diversification
  3. ☑️ Team visit confirms execution capability
  4. ☑️ Legal analysis confirms product viability

If validation passes: Negotiate $300-350M base + $100M earnout

Expected outcome:

  • 🟢 70% probability of proceeding post-validation
  • 🟢 2.3x expected MOIC on risk-adjusted basis

Secondary Recommendation: Stocktwits with Conditions

Action: Parallel-path CEO/CTO search and user research, but ⛔ DO NOT sign LOI until:

  1. ☑️ CEO/CTO candidates locked
  2. ☑️ User interest validated
  3. ☑️ Legal path confirmed
  4. ☑️ Milestone structure agreed

If conditions met: Proceed at $40-50M base + milestone tranches

Expected outcome:

  • 🟡 40% probability of proceeding post-validation
  • 🟢 3.4x expected MOIC but higher variance

Portfolio Strategy

Capital AvailableRecommendation
<$400MStocktwits only (if conditions met)
$400-500MCoinGecko priority, Stocktwits secondary
>$500MBoth, sequenced (CoinGecko first)

Appendix A: Model Assumptions Log

CoinGecko Key Assumptions

AssumptionValueSourceConfidence
Current MAU40MMemoHigh
Current revenue$40MMemoHigh
Revenue mix33/33/33MemoMedium
Wallet connection rate5%EstimateLow
Funded wallet rate25%pump.fun patternLow
Take rate50 bpsIndustryMedium
Team cost$80K avgMalaysia benchmarkMedium
Exit multiple8xComparable transactionsMedium

Stocktwits Key Assumptions

AssumptionValueSourceConfidence
Current MAU750KMemoHigh
Current DAU350KMemoHigh
Current revenue$15MMemoHigh
MAU growth rate25% CAGREstimateLow
DAU/MAU preservation40%EstimateLow
Crypto adoption8% of MAUEstimateLow
CAC$20IndustryMedium
Exit multiple6xComparable transactionsMedium

Appendix B: Validation Plan

User Research Design

CoinGecko Survey (n=1000 MAU):

  1. Do you currently have a funded crypto wallet?
  2. Do you currently have a brokerage account?
  3. Would you trade directly on CoinGecko if available?
  4. What would make you more/less likely to trade on CoinGecko?
  5. How often do you currently trade crypto?

Stocktwits Survey (n=500 MAU):

  1. Are you interested in crypto trading?
  2. Would you use perps/leverage if available?
  3. Would you use prediction markets?
  4. Would you use prop bets/contests?
  5. What features would make you more engaged?

Data Requests

CoinGecko:

  • Traffic source breakdown (last 12 months)
  • MAU by geography
  • Session duration and pages/session
  • API customer list and contract values
  • Historical MAU vs. crypto prices

Stocktwits:

  • MAU trend by month (24 months)
  • Cohort retention analysis
  • Posts per user by cohort
  • Revenue per user by engagement level
  • Prior acquisition/marketing history

Document generated from FWDI - Financial Modeling Plan.md Last updated: January 2026

Other Financial Analysis