Block Financial Model

• Total assets: Approximately $30 billion to $35 billion.
• Key asset categories: Cash and cash equivalents, Customer funds (Cash App balances), Settlement assets (funds in transit), Loans held for sale (Square Loans), and Bitcoin investments.
• Goodwill & intangibles: Represents over 35% of total assets, primarily stemming from the $29 billion Afterpay acquisition.
• Working capital profile:
• Days Sales Outstanding (DSO): 3-5 days (very fast settlement).
• Days Inventory Outstanding (DIO): 15-20 days (hardware only).
• Days Payable Outstanding (DPO): 10-15 days.
• Net working capital as % of revenue: Structurally negative.
• Working capital dynamic: Block benefits from a negative working capital float, holding customer funds and settlement payables which provide a source of zero-cost funding.
• PP&E: Minimal (less than 5% of assets), consisting mostly of data centre equipment and leasehold improvements.
• Right-of-use assets: Material but not a primary driver of enterprise value, representing leased office space globally.

• Capex as % of revenue: Very low, typically 1-2% of net revenue.
• Maintenance capex vs. growth capex: 80% growth (internal-use software and server infrastructure) and 20% maintenance.
• Major capex programmes underway or planned: Investments in AI infrastructure and data centres to support the 2026 shift to AI-native product development.
• Capitalised software / development costs: Material component of total capex, capitalised under GAAP and amortised over 3 years.
• M&A pattern: Historically transformational (Afterpay) with occasional bolt-ons (TIDAL, Verse). Currently focused on organic growth and integration rather than new large-scale M&A.
• Typical acquisition multiple paid: Afterpay was acquired at a peak multiple (approx. 20x forward revenue), resulting in significant goodwill.

• Total debt: Approximately $5.1 billion.
• Debt/EBITDA ratio: Gross leverage is approximately 1.5x Adjusted EBITDA.
• Credit rating: Non-investment grade (BB range), though metrics are improving.
• Key debt instruments: A mix of Senior Notes and Convertible Senior Notes.
• Maturity profile: Staggered maturities with significant convertible tranches due between 2026 and 2031.
• Interest rate profile: Predominantly fixed rate via the convertible and senior notes, resulting in a low weighted average cash interest cost.
• Covenants: Standard incurrence covenants on the senior notes; no restrictive financial maintenance covenants.
• Share repurchase programme: Highly active. Block repurchased $2.3 billion in 2025 and has a $5.3 billion remaining authorisation for 2026 and beyond.
• Dividend policy: No dividend policy. All capital is returned via buybacks or reinvested.

• Operating cash flow conversion: OCF to Net Income is typically greater than 2.0x due to massive non-cash add-backs (SBC, D&A) and working capital float.
• Free cash flow margin: FCF to Gross Profit is a more relevant metric, typically running at 15-20%.
• Major non-cash items: Stock-based compensation, depreciation and amortisation, and mark-to-market remeasurement of Bitcoin holdings.
• Working capital cash flow impact: Growth in Cash App balances and Square GPV creates a positive source of cash flow as customer payables grow faster than settlement assets.
• Capex intensity: Very low, allowing for high conversion of Adjusted EBITDA to Free Cash Flow.
• Cash tax rate vs. GAAP effective tax rate: Cash taxes are minimal due to historical net operating losses and tax deductions from stock-based compensation, differing significantly from the GAAP statutory rate.

1. Assumptions: Hardcoded inputs for macro drivers, segment growth rates, take rates, margin targets, and share repurchase volumes.
2. Dashboard: Executive summary displaying consolidated Gross Profit, Adjusted Operating Income, Rule of 40 metric, and implied share price.
3. Square Revenue & GP: Build-up of Square GPV, Transaction Revenue, Subscription & Services Revenue, Hardware Revenue, and associated COGS to calculate Square Gross Profit.
4. Cash App Revenue & GP: Build-up of Monthly Actives, Inflows per Active, Monetisation Rate, Bitcoin Revenue, and associated COGS to calculate Cash App Gross Profit.
5. Operating Expenses: Detailed schedules for Product Development, Sales & Marketing, General & Administrative, and Restructuring charges, including SBC breakouts.
6. Income Statement: GAAP Income Statement with a bridge to Non-GAAP metrics (Adjusted EBITDA and Adjusted Operating Income).
7. Balance Sheet: Assets (including Customer Funds and Bitcoin investments), Liabilities (including Customer Payables), and Equity.
8. Cash Flow Statement: Operating, Investing, and Financing cash flows, highlighting the impact of customer fund movements.
9. Debt & Interest Schedule: Tranche-by-tranche breakdown of Senior and Convertible Notes, calculating interest expense and tracking maturities.
10. Working Capital Schedule: Calculation of settlement assets, customer payables, and loans held for sale based on revenue and GPV drivers.
11. DCF Valuation: Unlevered free cash flow build, WACC calculation, terminal value, and equity bridge (including convertible debt dilution).

1. Square Transaction Revenue = Square GPV x Square Transaction Take Rate
2. Square Gross Profit = Total Square Revenue - Square COGS (Interchange, Assessment, and Hardware Costs)
3. Cash App Inflows = Cash App Monthly Transacting Actives x Average Inflows per Active
4. Cash App Gross Profit = Cash App Inflows x Cash App Monetisation Rate
5. Bitcoin Gross Profit = Bitcoin Revenue x Bitcoin Gross Margin (historically ~2%)
6. Consolidated Gross Profit = Square Gross Profit + Cash App Gross Profit + Corporate/Other Gross Profit
7. Adjusted EBITDA = GAAP Net Income + Interest Expense + Income Tax Expense + D&A + SBC + Restructuring Charges - Bitcoin Remeasurement Gains/Losses
8. Adjusted Operating Income = Adjusted EBITDA - Depreciation & Amortisation
9. Rule of 40 Metric = Consolidated Gross Profit YoY Growth % + Adjusted Operating Income Margin %
10. Diluted Shares Outstanding = Basic Shares + Dilutive impact of RSUs + Dilutive impact of Convertible Notes (using the if-converted method)
11. Free Cash Flow = Operating Cash Flow - Purchases of Property and Equipment - Capitalised Software Development Costs
12. Ending Cash Balance = Beginning Cash Balance + Free Cash Flow + Net Debt Issuance - Share Repurchases

The Assumptions sheet is the foundation, feeding drivers directly into the Square Revenue & GP and Cash App Revenue & GP sheets. These revenue sheets feed the top line of the Income Statement and dictate the volume-driven balances in the Working Capital Schedule (such as settlement assets and customer payables). The Operating Expenses sheet feeds the Income Statement and provides the SBC and D&A add-backs required for the Cash Flow Statement. The Debt & Interest Schedule feeds interest expense into the Income Statement and debt balances into the Balance Sheet. The Income Statement generates Net Income, which starts the Cash Flow Statement. Finally, the Cash Flow Statement calculates the ending cash balance, which links to the Balance Sheet to ensure it balances. A potential circularity exists between interest income, cash balances, and debt paydown; this should be broken using a beginning-balance toggle for interest calculations.

• Revenue and Gross Profit: Entered and displayed as positive numbers.
• Expenses (COGS, Opex, Interest, Taxes): Entered as positive numbers in their respective build schedules, but subtracted in the Income Statement formulas.
• Cash Flow: Cash inflows (e.g., net income, depreciation add-back, debt issuance) are positive. Cash outflows (e.g., capex, share repurchases, debt repayment, working capital increases) are negative.
• Balance Sheet: Assets are positive. Liabilities and Equity are positive. The check formula (Assets - Liabilities - Equity) must equal zero.

1. Focusing on Total Revenue instead of Gross Profit: Block manages and guides its business entirely on Gross Profit. Bitcoin revenue artificially inflates total revenue, making consolidated revenue growth and margin metrics meaningless.
2. Mishandling Bitcoin Remeasurement: GAAP net income includes mark-to-market gains and losses on Block's corporate Bitcoin holdings. These must be explicitly backed out to calculate Adjusted EBITDA.
3. Customer Funds Distortion: Cash App balances and Square settlement funds gross up both Assets and Liabilities. Changes in these balances swing Operating Cash Flow wildly but do not reflect the core free cash flow of the business.
4. SBC Exclusion Trap: Stock-based compensation is massive. Valuing the company on Adjusted EBITDA without treating SBC as a real economic cost will severely overstate the company's intrinsic value.
5. Hardware Margin Errors: Square hardware is sold at a loss to acquire customers. The model must reflect hardware gross margins as structurally negative.
6. Restructuring Charge Treatment: The $450 million to $500 million restructuring charge in Q1 2026 must be modelled as a one-time add-back to non-GAAP metrics, but it represents a real cash outflow that must hit the Cash Flow Statement.
7. Convertible Debt Dilution: Failing to account for the dilutive impact of the convertible notes if the share price exceeds the conversion price will understate the fully diluted share count.
8. Afterpay Allocation: BNPL revenue from Afterpay is split 50/50 between the Square and Cash App segments in reported financials. The model must maintain this allocation if forecasting BNPL separately.

1. "Consolidated Gross Profit Growth should be in the 17-24% range based on 2025/2026 trends; flag if outside this band."
2. "Cash App Gross Profit must represent >60% of total Gross Profit."
3. "Bitcoin Gross Margin should remain between 1.5% and 2.5%; flag if the model implies higher profitability on crypto trading."
4. "Adjusted Operating Income Margin should reach the management target of 26% by 2026."
5. "Rule of 40 Check: Gross Profit Growth % + Adjusted Operating Income Margin % should exceed 40%."
6. "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
7. "Share count must decline year-over-year: The $2.3 billion annual share repurchase programme should more than offset SBC dilution."
8. "Hardware Gross Margin must be negative (typically -30% to -40%)."

• Filings: SEC EDGAR for Block, Inc. (SQ) 10-K, 10-Q, and 8-K filings.
• Investor Relations: investors.block.xyz for the Q4 2025 Shareholder Letter, Investor Day presentations, and financial supplement spreadsheets.
• Key Peers for Benchmarking: PayPal Holdings (PYPL), Toast Inc. (TOST), Fiserv (FI), Adyen (ADYEN), and Stripe (private).
• Consensus Estimates: FactSet or Bloomberg for forward Gross Profit and Adjusted EBITDA estimates.
• Alternative Data: SensorTower or Data.ai for Cash App download and active user trends; SimilarWeb for Square merchant portal traffic.

• Block, Inc. Q4 2025 Earnings Release and Shareholder Letter (February 2026).
• Block, Inc. 2024 Annual Report on Form 10-K.
• Block, Inc. 2025 Investor Day Presentation.
• Zacks Investment Research: "Block Stock Soars as Q4 Earnings Meet Estimates" (February 2026).
• Investing.com: "Block Q4 2025 slides: gross profit growth accelerates to 24%" (February 2026).