Coinbase Financial Model

• Total assets: Approximately $130-150 billion, but this is highly misleading due to customer custodial assets.
• Key asset categories: Customer crypto assets (safeguarded liabilities), Corporate cash and cash equivalents, USDC, and Crypto assets held for investment.
• Goodwill & intangibles: Less than 5% of total assets, stemming from bolt-on acquisitions.
• Working capital profile:
• Days Sales Outstanding (DSO): Very low (under 5 days) as trades settle instantly.
• Days Inventory Outstanding (DIO): Not applicable.
• Days Payable Outstanding (DPO): 15-30 days.
• Net working capital as % of revenue: Structurally negative, providing a slight cash flow benefit as the company grows.
• PP&E: Minimal. Mostly leasehold improvements and computer equipment.
• Right-of-use assets / operating leases: Material but small relative to cash balances, representing global office spaces.

• Capex as % of revenue: 1-2% historically.
• Maintenance capex vs. growth capex: Almost entirely growth capex related to server infrastructure and capitalised software development.
• Major capex programmes underway or planned: Investments in the Base Layer 2 network infrastructure.
• Capitalised software / development costs: Material component of total capex, amortised over 3 years.
• M&A pattern: Bolt-on acquirer focusing on institutional capabilities (e.g., One River Digital Asset Management, Deribit) and infrastructure.
• Typical acquisition multiple paid: Undisclosed, but generally high-growth tech multiples.

• Total debt: Approximately $3.0 billion in long-term debt.
• Debt/EBITDA ratio: Fluctuates wildly with EBITDA. Currently under 1.0x based on 2024 Adjusted EBITDA.
• Credit rating: Non-investment grade (high yield), typically BB- range.
• Key debt instruments: Senior Notes (e.g., 2028 and 2031 maturities) and Convertible Senior Notes.
• Maturity profile: Well-laddered with no immediate near-term liquidity cliffs.
• Interest rate profile: Mostly fixed-rate senior notes with coupons ranging from 3.375% to 3.625%.
• Covenants: Standard high-yield incurrence covenants; no restrictive financial maintenance covenants.
• Share repurchase programme: Active. The company frequently repurchases convertible debt and common stock to offset dilution from stock-based compensation.
• Dividend policy: No dividend. 0% payout ratio.

• Operating cash flow conversion: Highly distorted by changes in custodial funds due to users depositing or withdrawing fiat.
• Free cash flow margin: 20-30% when adjusting for customer custodial funds and adding back stock-based compensation.
• Major non-cash items: Stock-based compensation, unrealised gains or losses on crypto assets held for investment, and depreciation.
• Working capital cash flow impact: Minimal impact on core operations, but massive swings on the statutory cash flow statement due to customer fiat balances.
• Capex intensity: Very low, making the business highly cash generative during bull markets.
• Cash tax rate vs. GAAP effective tax rate: Cash taxes are often lower than GAAP taxes due to the tax deductibility of stock-based compensation upon vesting.

1. Assumptions: Hardcoded inputs for macroeconomic drivers, crypto prices, take rates, and margin profiles.
2. Operating Metrics: Forecasts for Monthly Transacting Users, Trading Volume (Consumer and Institutional), Assets on Platform, and USDC Market Capitalisation.
3. Revenue Schedule: Detailed build of Consumer transaction revenue, Institutional transaction revenue, Stablecoin revenue, Blockchain rewards, Custody fee revenue, and Interest income.
4. Income Statement: GAAP income statement mirroring the 10-K, including the breakout of Transaction expense, Technology and development, Sales and marketing, and General and administrative.
5. Stock-Based Compensation Schedule: Tracks SBC grants, vesting, and the resulting dilution to the share count.
6. Balance Sheet: Assets and liabilities, explicitly separating Corporate Cash from Customer Custodial Funds.
7. Debt Schedule: Tranches of Senior Notes and Convertible Notes, calculating interest expense and tracking maturities.
8. Cash Flow Statement: Indirect method, starting with Net Income, adjusting for non-cash crypto mark-to-market gains, SBC, and stripping out customer fund movements to calculate true Free Cash Flow.
9. DCF Valuation: Unlevered free cash flow calculation, WACC derivation, and terminal value calculation to arrive at an implied share price.

1. Consumer Transaction Revenue = Consumer Trading Volume * Consumer Take Rate
2. Institutional Transaction Revenue = Institutional Trading Volume * Institutional Take Rate
3. Stablecoin Revenue = Average USDC on Platform * Average US Treasury Yield * Coinbase Revenue Share Percentage
4. Blockchain Rewards = Total Staked Assets * Average Network Staking Yield * Coinbase Commission Margin
5. Custody Fee Revenue = Average Assets Under Custody * Blended Custody Fee Rate
6. Interest Income = Average Corporate Fiat Balances * Short-Term Interest Rate
7. Total Net Revenue = Consumer Transaction Revenue + Institutional Transaction Revenue + Stablecoin Revenue + Blockchain Rewards + Custody Fee Revenue + Interest Income + Other Revenue
8. Transaction Expense = Total Trading Volume * Blended Network Routing Fee Rate
9. Gross Profit = Total Net Revenue - Transaction Expense
10. Adjusted EBITDA = Net Income + Provision for Income Taxes + Depreciation and Amortisation + Interest Expense + Stock-Based Compensation - Unrealised Gains on Crypto Assets
11. Diluted Shares Outstanding = Basic Shares Outstanding + Net Dilution from Stock-Based Compensation + Dilution from Convertible Notes (if in the money)

The Assumptions sheet feeds the Operating Metrics sheet to project volumes and asset prices. The Operating Metrics sheet drives the Revenue Schedule. The Revenue Schedule feeds the top line of the Income Statement. The Income Statement generates Net Income, which flows to the top of the Cash Flow Statement and feeds Retained Earnings on the Balance Sheet. The Debt Schedule calculates interest expense, which flows back to the Income Statement, creating a minor circularity that must be managed with a toggle switch. The Cash Flow Statement determines the ending corporate cash balance, which flows to the Balance Sheet and drives Interest Income on the Revenue Schedule.

• Revenue and volume metrics are entered and displayed as positive numbers.
• Expenses on the Income Statement (Transaction expense, Technology and development, etc.) should be entered as positive numbers and subtracted in the Gross Profit and Operating Income formulas.
• On the Cash Flow Statement, cash inflows are positive and cash outflows are negative.
• Debt paydowns and share repurchases are negative on the Cash Flow Statement.

• Failing to separate corporate cash from customer custodial funds will completely distort enterprise value and working capital calculations.
• Using statutory operating cash flow without adjusting for the massive swings in customer fiat deposits will result in meaningless free cash flow metrics.
• Forgetting to back out unrealised mark-to-market gains on crypto assets from Adjusted EBITDA will artificially inflate operating performance.
• Applying a single blended take rate instead of splitting Consumer and Institutional volume will break the revenue forecast, as Consumer take rates are magnitudes higher.
• Ignoring the dilution from stock-based compensation will result in an artificially high per-share valuation.
• Confusing Interest Income (earned on corporate cash) with Stablecoin Revenue (earned on USDC reserves) will lead to double-counting rate sensitivity.
• Modelling stablecoin revenue without accounting for the Federal Reserve interest rate cycle will cause massive forecast errors.
• Failing to account for the convertible debt dilution using the treasury stock method will understate the fully diluted share count.

• Total Assets must equal Total Liabilities + Equity in every forecasted period.
• Consumer Take Rate should remain between 1.00% and 1.50%; flag if it drops below 1.00% as this implies severe fee compression.
• Institutional Take Rate should remain between 0.01% and 0.05%.
• Adjusted EBITDA margin should remain positive and typically between 20% and 50% during normal market conditions.
• Stock-Based Compensation as a percentage of revenue should not exceed 25% without a warning flag.
• The effective tax rate should be modelled between 15% and 25%, adjusting for non-deductible executive compensation.
• Debt/EBITDA should remain below 3.0x to align with the company's historical conservative leverage profile.
• Unlevered Free Cash Flow conversion (UFCF / Adjusted EBITDA) should be between 60% and 80%.

• Filings: SEC EDGAR for Coinbase Global, Inc. (COIN) 10-K and 10-Q filings. Investor Relations page for quarterly Shareholder Letters.
• Peers for Benchmarking: Robinhood Markets (HOOD), Interactive Brokers (IBKR), CME Group (CME), and Block, Inc. (SQ).
• Industry Data: CoinGecko or CoinMarketCap for global crypto trading volumes and asset prices. Glassnode for onchain metrics and staking participation rates.
• Consensus Estimates: Visible Alpha or Bloomberg for consensus trading volume and MTU estimates.
• Proprietary Data: DefiLlama for Total Value Locked (TVL) on the Base network and global stablecoin market capitalisation trends.

• Coinbase Global, Inc. Form 10-K for the fiscal year ended December 31, 2024 (filed February 2025).
• Coinbase Q4 2024 Shareholder Letter (published February 13, 2025).
• S&P Global Market Intelligence reports on Coinbase revenue diversification (November 2025).
• Talos State of the Network: Coinbase Earnings Outlook (late 2025 estimates).
• SEC EDGAR database (https://www.sec.gov/edgar/searchedgar/companysearch).