Model Architecture
The workbook has nine tabs organized into five functional categories.
The Cover tab is a live-linked dashboard displaying KPIs, trading multiples, the DCF price range, and navigation links. The thesis and the valuation summary are visible before opening anything else — by design.
The Assumptions tab is the single control panel for the entire model. Every forecast-period driver — macro variables, revenue build-ups, operating margin targets, balance sheet mechanics — flows from here. Change one cell and it propagates through all three financial statements, the DCF, and every supporting schedule simultaneously.
The three Financial Statement tabs (Income Statement, Balance Sheet, Cash Flow Statement) span FY2019A through FY2030E and are fully integrated: cash is the balance sheet plug, the cash flow statement reconciles net income to cash, and every major line traces back to Assumptions.
The DCF tab contains the WACC build, unlevered FCFF projections, terminal value under two methods, the equity bridge to per-share value, and two 5x5 sensitivity grids.
The four Supporting tabs are USDC Scenarios (the 3x3 Circle renewal risk matrix), Deribit Acquisition (PPA summary and annual amortization schedule), and Supporting Schedules (five sub-models covering debt, PP&E, share count, working capital, and tax).
Where to Start
The model is designed to be read in a specific sequence that builds analytical context before introducing complexity.
Start with the Cover tab — thesis and valuation range upfront. Move to Assumptions next. This is the engine room, and understanding what drives the forecasts makes every subsequent tab legible. Then work through the Income Statement to see how the eight revenue lines collapse into EBIT and net income, the Balance Sheet to confirm the cash plug and the balance check row, and the Cash Flow Statement to see how OCF, ICF, and FCF connect the first two statements.
Once the three-statement model is clear, the DCF tab follows naturally: WACC inputs, FCFF derivation from the IS, terminal value under both methods, and the equity bridge. From there, the two scenario tabs — USDC Scenarios and Deribit Acquisition — add the risk and acquisition overlays. The Supporting Schedules tab closes the loop on the mechanics underlying the balance sheet and share count.
Assumptions Tab
Macro & Market
The Federal Funds Rate is the single most important exogenous variable in the model. It drives USDC revenue directly — through reserve interest income — and interest income on Coinbase’s cash balance. The modeled FOMC path runs from in FY2025A to by FY2030E, producing a stablecoin revenue profile that peaks in FY2027E and then declines as rates normalize.
Crypto market cap grows from $T to $T across the forecast period — approximately CAGR — serving as the macroeconomic backdrop against which trading volumes and asset balances are sized. ETH staking yield compresses from to as network participation rises from to of total ETH supply. BTC year-end price assumptions range from $K to $K; ETH average price assumptions from $ to $.
Transaction Revenue
Consumer transaction revenue is volume times take rate. Volume grows from $B (FY2026E) to $B (FY2030E); take rate compresses from bps (FY2026E) to bps (FY2030E), reflecting the combined effect of Coinbase One zero-commission waivers and increasing competitive pressure from offshore venues. Institutional volume grows from $B to $B — driven primarily by Deribit integration — at a blended take rate of approximately bps.
Deribit is modeled as a standalone revenue line growing from $M to $M on $-$B in notional volume at -bps, reflecting its options-heavy mix, which commands higher per-notional fees than spot or futures. Other Transaction revenue ($M growing to $M) captures Base sequencer fees and CDP residual revenue not classifiable elsewhere.
Subscription & Services
USDC revenue is built from first principles: on-platform USDC balance ($B growing to $B) multiplied by of reserve yield, plus off-platform USDC ($B growing to $B) multiplied by of reserve yield. The resulting gross revenue line is the most rate-sensitive in the model and the primary subject of the USDC Scenarios tab.
Blockchain rewards revenue is built from ETH custody volume (M to M ETH) multiplied by price and yield — and declines from $M in FY2025A to $M by FY2030E as yield compression outpaces asset appreciation in the base case. Coinbase One ARR grows from $M to $M as the subscriber base expands from M to M at an average revenue per subscriber of $-$ annually. Interest income steps up significantly in FY2026E (Deribit balance sheet addition) then declines as rates fall, ending at $M.
Operating Expense & Margins
Gross margin expands from to as the revenue mix shifts toward higher-margin subscription and services lines. Sales & marketing declines from to of revenue. R&D declines from to . G&A is elevated in FY2026E at to reflect Deribit integration costs, then normalizes to by the terminal year. SBC declines from to of revenue as the post-IPO equity program matures.
Income Statement
The income statement spans FY2019A through FY2030E, with column C frozen for navigation. Historical figures are sourced from standardized filings; all forecast columns link directly to Assumptions.
Total revenue grows from $M (FY2019A) to $B (FY2030E). The composition changes materially: consumer transaction revenue — approximately of revenue in FY2019 — falls to approximately by FY2030E as institutional (), USDC (), subscriptions (), and other revenue lines () absorb an increasing share. This is the diversification thesis made visible in the numbers.
COGS represents - of revenue, with gross margin expanding to in the terminal year. Total operating expense falls from to of revenue. D&A includes three components: PP&E depreciation (from the PP&E schedule), Deribit acquired intangibles amortization ($M/year as detailed in the Deribit tab), and other intangibles. EBIT grows from $B to $B, with margin expanding from approximately to . Below the line: interest expense of $M declining as debt is repaid, and an effective tax rate of from FY2026E forward. The Adjusted EBITDA memo at the bottom of the income statement shows margin expanding from to across the forecast period.
Balance Sheet
Cash is the model’s balance sheet plug. It equals prior-period cash plus the net change from the cash flow statement — no independent assumption. Under this structure, cash grows to $B by FY2030E and the company moves to a deeply net cash position of $B as debt is repaid and operating cash generation accumulates.
Crypto assets receivable and payable are modeled at $-$B gross, netting to approximately zero — consistent with Coinbase’s custodial balance sheet treatment. PP&E is driven by the PP&E schedule. Goodwill is held flat at $B post-Deribit; no additional acquisitions are modeled. Intangibles decline from $B to $B as Deribit acquired intangibles amortize through the forecast period. Debt is modeled by named tranche, declining from $B to $B as tranches mature. Total equity grows from $B to $B.
The Balance Check row confirms model integrity every period. The two pre-IPO periods (FY2019 and FY2020) carry small residual balance check artefacts of $M and $M respectively — both traceable to pre-IPO capitalization treatment in the source data rather than model error, and flagged in the Analyst Notes tab.
Cash Flow Statement
The cash flow statement is the integration layer connecting the income statement to the balance sheet via the cash plug.
Operating cash flow opens with net income, adds back non-cash charges (D&A, SBC, deferred tax), and incorporates working capital changes sourced from the Working Capital schedule. OCF grows from $B to $B across the forecast period, with FCF conversion above x in every year — a reflection of the asset-light nature of Coinbase’s core business.
Investing cash flow consists primarily of capex ($M-$M, modeled at of revenue) and the Deribit-related outflows in FY2025-2026. Financing cash flow includes no new debt issuance post-FY2025, debt repayments ranging from $M (FY2027E) to $B (FY2026E) as tranches mature on their contractual schedules, share buybacks of $B per year, and ESPP proceeds of approximately $M per year. The Levered FCF memo (CFO plus capex) grows from $B to $B.
DCF Model
WACC Build
The WACC is constructed from first principles with sourced inputs.
Risk-free rate: , sourced from the FRED DGS10 10-year Treasury yield as of February 2026. Equity risk premium: , sourced from Damodaran’s implied ERP as of January 2026. Raw beta: x, estimated from a five-year monthly OLS regression of COIN versus the S&P 500. Blume-adjusted beta — applying the standard two-thirds/one-third formula — is x, reflecting mean reversion toward x over time.
Cost of equity under CAPM: ( + ). Cost of debt: , blended from Coinbase’s actual debt tranches ( convertible, convertible, senior, senior). After-tax cost of debt at : . Capital structure: equity ($B market cap) and debt ($B).
The resulting WACC is — high by large-cap standards, and appropriate for a company whose cash flows carry x systematic risk relative to the S&P 500.
FCFF Bridge
Unlevered free cash flow to firm is derived as: GAAP EBIT x ( tax rate) = NOPAT; plus D&A; minus capex; minus change in net working capital.
FY2026E FCFF is unusually low at $M due to a $B working capital outflow associated with Deribit integration. This is a one-time distortion — not a structural signal. FCFF normalizes to $-$B from FY2027E onward.
Terminal Value
Two methods applied in parallel.
-
Method A — Gordon Growth Model: Terminal growth rate of , reflecting an aggressive but defensible assumption for a company exposed to secular crypto adoption tailwinds in a global TAM still in early innings. The rate is above long-run nominal GDP growth — which requires justification — but is calibrated against the trajectory of transaction volume and subscription ARR in the final explicit forecast year. Terminal value: $B; present value: $B.
-
Method B — Exit EV/Adj. EBITDA Multiple: x applied to FY2030E Adjusted EBITDA of $B. Terminal value: $B; present value: $B. The x is calibrated against the peer set: CME Group at -x, ICE at -x, Nasdaq at -x, Robinhood at -x. At x, Coinbase is discounted relative to pure-play exchange peers — appropriate given its higher cash flow volatility and crypto beta.
Terminal value represents of total enterprise value under the Gordon Growth method and under the exit multiple method. Both figures are typical for high-growth, back-loaded cash flow profiles and underscore how sensitive the valuation is to terminal assumptions.
Equity Bridge & Price Targets
Enterprise value equals discounted FCFFs plus the present value of terminal value. Add net cash of $B, divide by M diluted shares.
Gordon Growth method: $ per share (approximately downside to spot). Exit multiple method: $ per share (approximately upside to spot). The $ spot sits near the midpoint — consistent with a market that has partially priced the infrastructure transition but hasn’t fully resolved the renewal and competitive risks.
Sensitivity Tables
Two 5x5 grids let you stress the valuation against changing assumptions. The first crosses WACC (-) against terminal growth rate (-) for the Gordon Growth method. The second crosses WACC (-) against exit multiple (x-x) for the exit multiple method. Base case assumptions are centered in each grid. The grids show how quickly the upside case collapses at higher discount rates — and what the downside case looks like at lower terminal assumptions.
USDC Scenarios Tab
This tab isolates the single largest binary risk in the model: the Circle-Coinbase revenue-sharing agreement renewal, due in 2026. Current terms — confirmed in Circle’s S-1 — entitle Coinbase to of reserve interest on on-platform USDC balances and on off-platform balances.
The tab presents a 3x3 matrix crossing three Federal Funds Rate scenarios (, , ) against three sharing-rate scenarios.
The Base case preserves current terms (/). The Bear case reflects a renegotiation to /. The Stress case reflects a scenario where off-platform sharing drops to zero — pricing in a structure similar to Circle’s disclosed Binance agreement ($M upfront plus monthly distribution fees), where Coinbase receives no flow-through from off-platform balances.
The output range across all nine cells: $M (stress terms, FFR) to $M (base terms, FFR). The model’s base case USDC revenue assumption of approximately $M sits in the upper-left corner of the matrix — a reminder that any combination of rate cuts and renegotiated terms compresses this line significantly. The FY2025A implied yield of ( of the average Fed Funds Rate) provides the sanity check anchor for the yield assumptions applied across scenarios.
Deribit Acquisition Tab
This tab documents the $B acquisition (August 14, 2025) and its balance sheet and income statement consequences.
Total consideration: $M in cash plus approximately million COIN shares at approximately $/share, implying roughly $B in equity consideration. The deal was struck at approximately x revenue on Deribit’s estimated $M FY2024 revenue — a premium consistent with the platform’s options market leadership and open interest depth.
Purchase price allocation is an analyst estimate; official PPA has not been published by Coinbase. The estimated breakdown: goodwill of $M; customer relationships of $M amortized over 8 years ($M/year); technology platform of $M over 6 years ($M/year); trade name of $M over 10 years ($M/year); non-compete agreements of $M over 3 years ($M/year); net working capital step-up of $M; deferred tax liability of −$M. Total annual amortization of acquired intangibles (ARI) is $M per year for FY2026-2028, declining to $M in FY2029-2030 as the non-compete agreements expire, and $M from FY2031 onward as the technology platform intangible rolls off.
This ARI flows directly into the D&A line on the income statement and into the intangibles balance on the balance sheet. It’s a GAAP cost that doesn’t appear in Adjusted EBITDA — meaning the $M step-up from partial-year FY2025 to full-year FY2026 affects GAAP EBIT comparability but not the Adjusted metrics. Any FY2026E EBIT comparison against FY2025 actuals that doesn’t account for this step-up will draw the wrong conclusions about operating leverage.
Supporting Schedules
Five sub-models underpin the balance sheet and cash flow mechanics.
The Debt schedule models each named tranche individually, calculates interest at approximately of beginning-of-period balance, and splits outstanding balance between current and long-term portions based on maturity. Total debt declines from $B to $B as tranches mature through the forecast period.
The PP&E schedule applies a standard roll-forward: beginning balance plus capex (modeled at of revenue, or $M-$M) minus depreciation ( of prior-period net PP&E). Net PP&E grows modestly from $M to $M — consistent with Coinbase’s asset-light model, where infrastructure investment is primarily software and cloud rather than physical assets.
The Shares schedule starts with a basic share count of M and applies $B per year in buybacks at the prevailing share price. Diluted share count includes outstanding RSUs and options under the treasury stock method, declining from M to approximately M as buybacks more than offset new equity awards over the forecast period.
The Working Capital schedule derives accounts receivable from DSO assumptions (declining from to days), accounts payable from DPO assumptions (declining from to days), and accrued liabilities from - of operating expenses. The large working capital jump from $M to $M in FY2026E reflects the Deribit balance sheet reclassification — a one-time integration step that drives the low FY2026E FCFF in the DCF. Not a structural signal.
The Tax schedule calculates the income tax provision as pretax income multiplied by the effective tax rate from FY2026E forward, consistent with Coinbase’s disclosed forward ETR guidance. The deferred tax asset starts at $M and draws down at approximately $M per year as temporary timing differences reverse.
Sources & Data Provenance
Historical financials are sourced from standardized financials (COIN US Equity) and confirmed against Coinbase’s 10-K and 10-Q filings on SEC EDGAR. The Deribit PPA is an analyst estimate; official allocation has not been published. WACC inputs are sourced as follows: risk-free rate from FRED DGS10 (February 2026); equity risk premium from Damodaran’s implied ERP (January 2026); beta from a five-year monthly OLS regression; cost of debt from Coinbase’s publicly filed bond indentures. Macro assumptions are based on the FOMC dot-plot as of February 2026 for the Fed Funds Rate path and analyst estimates for crypto market cap. Peer multiples are sourced from consensus data as of March 2026.
Key Risks & Sensitivity Levers
Seven variables drive the majority of valuation uncertainty in the model.
A bps upward shift in the Fed Funds Rate adds approximately $-$M to annual USDC revenue relative to the base case path. A Circle renewal that renegotiates terms to / removes approximately $-$M per year from the P&L — permanently, depending on the rate path at renewal. A bps compression in the consumer take rate — through Coinbase One adoption, competitive pressure, or mix shift — reduces annual revenue by approximately $M at projected FY2028 volumes.
Terminal value represents - of enterprise value. A ± change in the terminal growth rate moves implied per-share price by approximately $-$. A beta compression from x to x would reduce WACC to approximately , adding $-$ per share to equity value.
Deribit integration execution and SBC dilution intensity are qualitative risks that don’t translate cleanly to a point sensitivity but are flagged throughout the Analyst Notes tab.
Disclaimer
This model is produced for educational and illustrative purposes only. It does not constitute investment advice, a recommendation, or an offer to buy or sell any security. All forward-looking estimates are my own opinion and are subject to significant uncertainty. The model has not been independently audited. Users should conduct their own due diligence and consult a qualified financial advisor before making any investment decision. Cryptocurrency markets are highly volatile and speculative in nature. I may hold positions in the securities discussed.