Airbnb Financial Model

Platform Revenue

• Segment name: Airbnb operates and reports as a single consolidated segment (Platform Revenue).
• Revenue driver formula: Nights and Experiences Booked x Average Daily Rate (ADR) = Gross Booking Value (GBV). Gross Booking Value x Take Rate = Total Revenue.
• Historical growth rate: 10% to 12% year-over-year revenue growth (FY2024 and FY2025).
• Key growth levers and headwinds: Growth is driven by mobile app adoption (accounting for over 64% of nights booked), international expansion in Latin America and Asia Pacific, and new product offerings like "Reserve Now, Pay Later". Headwinds include regulatory crackdowns in major cities and macroeconomic pressure on consumer discretionary spending.
• Pricing dynamics: Hosts set their own nightly rates, but Airbnb controls the guest and host service fees (the take rate), which it can optimise dynamically.
• Revenue recognition notes: Revenue is recognised over time upon check-in, not at the time of booking. Cash collected at booking is recorded as Unearned Fees (deferred revenue) on the balance sheet.
• Seasonality: The business is highly seasonal. The third quarter (Q3) is historically the strongest for revenue and EBITDA due to peak summer travel check-ins in the Northern Hemisphere. However, cash flow peaks in the first and second quarters (Q1 and Q2) as guests book and pay for their summer travel in advance.

• Total assets: Approximately $25 billion to $30 billion scale.
• Key asset categories: Heavily skewed towards liquidity. Corporate Cash, Cash Equivalents, and Marketable Securities total approximately $11 billion. Funds Held on Behalf of Guests total approximately $7 billion.
• Goodwill & intangibles: Minimal (less than 5% of total assets) as Airbnb relies on organic growth rather than transformational M&A.
• Working capital profile:
• Days Sales Outstanding (DSO): Near zero, as guests pay via credit card at the time of booking.
• Days Inventory Outstanding (DIO): Not applicable.
• Days Payable Outstanding (DPO): High, as Airbnb holds guest funds until check-in.
• Net working capital: Highly negative. Airbnb benefits from a massive negative working capital float. It collects cash at booking and pays hosts after check-in, funding its own growth.
• PP&E: Minimal. Primarily consists of leasehold improvements and computer equipment.
• Right-of-use assets: Material operating lease assets for corporate offices globally.

• Capex as % of revenue: Very low, typically 1% to 2% of revenue.
• Maintenance capex vs. growth capex: Almost entirely growth capex related to capitalised software development and office expansions.
• Major capex programmes underway: Investments in AI infrastructure and data centre capacity.
• Capitalised software: Material component of total capex, amortised through Cost of Revenue.
• M&A pattern: Bolt-on acquirer. Airbnb occasionally acquires small technology teams or niche platforms (for example, HotelTonight or GamePlanner.AI) rather than large competitors.

• Total debt: Approximately $2 billion in convertible senior notes.
• Debt/EBITDA ratio: Near zero on a net debt basis due to the massive $11 billion corporate cash balance.
• Key debt instruments: 0% Convertible Senior Notes due 2026.
• Interest rate profile: Fixed at 0% for the convertible notes, meaning interest expense is minimal, while interest income on cash balances is highly sensitive to macroeconomic rates.
• Share repurchase programme: Highly active. The company routinely repurchases shares (for example, $838 million in Q4 2024) to offset dilution from stock-based compensation.
• Dividend policy: No dividend. Capital is returned entirely through share buybacks.

• Operating cash flow conversion: Consistently greater than 1.0x (OCF / Net Income) due to the upfront collection of cash and high non-cash stock-based compensation.
• Free cash flow margin: Exceptionally high, ranging from 38% to 40% of revenue (for example, $4.6 billion FCF in FY2025).
• Major non-cash items: Stock-based compensation, depreciation and amortisation, and changes in unearned fees.
• Working capital cash flow impact: Acts as a massive source of cash during the first half of the year (booking season) and a use of cash in the third quarter (check-in season).
• Cash tax rate: Expected to drop to the mid-to-high teens percentage in 2026 due to new tax legislation, differing slightly from the GAAP effective rate due to SBC tax benefits.

1. Assumptions: Hardcoded inputs for Nights and Experiences Booked growth, ADR, Take Rate, and operating expense margins.
2. Operating Build: Calculates Gross Booking Value by multiplying Nights Booked by ADR. Calculates Revenue by multiplying GBV by the Take Rate.
3. Income Statement: GAAP P&L mirroring the 10-K (Revenue, Cost of Revenue, Operations and Support, Product Development, Sales and Marketing, General and Administrative).
4. Balance Sheet: Assets (Corporate Cash, Funds Held on Behalf of Guests, Marketable Securities), Liabilities (Funds Payable to Guests, Unearned Fees, Long-Term Debt), and Equity.
5. Cash Flow Statement: Operating Cash Flow (adjusting Net Income for SBC and Unearned Fees), Investing Cash Flow (purchases of marketable securities, capex), and Financing Cash Flow (share repurchases).
6. Working Capital Schedule: Detailed roll-forward of Unearned Fees and Funds Held on Behalf of Guests based on booking lead times.
7. Debt & Interest Schedule: Tracks the convertible notes and calculates interest income generated from both Corporate Cash and Funds Held on Behalf of Guests.
8. DCF Valuation: Unlevered free cash flow calculation, WACC assumptions, terminal value, and implied share price.

1. Gross Booking Value = Nights and Experiences Booked x Average Daily Rate
2. Total Revenue = Gross Booking Value x Take Rate
3. Cost of Revenue = (Payment Processing Fee % x Gross Booking Value) + Fixed Hosting Costs
4. Gross Profit = Total Revenue - Cost of Revenue
5. Unearned Fees (End of Period) = Unearned Fees (Beginning of Period) + New Bookings (GBV) - Revenue Recognised (Stays Completed)
6. Funds Held on Behalf of Guests = Funds Payable to Guests (these two balance sheet lines must always match exactly)
7. Interest Income = (Average Corporate Cash + Average Funds Held on Behalf of Guests) x Average Yield on Cash
8. Adjusted EBITDA = Net Income + Provision for Income Taxes + Interest Expense - Interest Income + D&A + Stock-Based Compensation
9. Free Cash Flow = Net Cash Provided by Operating Activities - Purchases of Property and Equipment
10. Diluted Shares Outstanding = Basic Shares + Dilutive Impact of Options/RSUs - Shares Repurchased

The Operating Build feeds Total Revenue and operating expenses into the Income Statement. Net Income from the Income Statement flows into the top of the Cash Flow Statement. The change in Unearned Fees calculated in the Working Capital Schedule flows into the Cash Flow Statement as a major operating cash flow adjustment. The ending cash balances from the Cash Flow Statement feed the Balance Sheet. The cash balances on the Balance Sheet feed the Debt & Interest Schedule to calculate Interest Income, which flows back into the Income Statement. This creates a circular reference between interest income, net income, cash flow, and cash balances, which requires a circuit breaker toggle.

• Revenue, Gross Booking Value, and Asset balances are entered as positive numbers.
• Expenses (Cost of Revenue, Opex) are entered as positive numbers in their respective build schedules but subtracted in the Income Statement to calculate profit.
• Liabilities and Equity are positive numbers.
• On the Cash Flow Statement, cash inflows are positive and cash outflows (including capex and share repurchases) are negative.

• Misunderstanding the float: Airbnb earns significant interest income on funds held on behalf of guests. Failing to model interest income on this specific liability line will understate earnings.
• Seasonality mismatch: The model must account for the fact that cash is collected in Q1/Q2 but revenue is recognised in Q3. Annual models mask this, but quarterly models will break if bookings and revenue recognition are not decoupled.
• Take rate confusion: The take rate is calculated as Revenue divided by Gross Booking Value. Using net revenue instead of gross revenue will distort the metric.
• Ignoring stock-based compensation: SBC is a massive expense for Airbnb. Excluding it from valuation metrics artificially flatters cash flow and ignores the real cost of shareholder dilution.
• Guest funds imbalance: Funds Held on Behalf of Guests (Asset) must exactly equal Funds Payable to Guests (Liability). If these drift apart in the forecast, the balance sheet will fail.
• Share count dilution: The company buys back stock specifically to offset SBC dilution. The model must link the share repurchase cash outflow to the diluted share count calculation.
• Capitalised software: R&D expenses in the P&L do not represent the full cash cost of engineering, as a portion is capitalised and amortised through Cost of Revenue.
• Foreign exchange impact: Over 50% of Airbnb's revenue is generated outside the US. The model should ideally forecast ADR on a constant-currency basis to avoid distortion from a strong US Dollar.

• Take Rate must remain between 13.0% and 14.5% based on historical pricing power.
• Gross margin should be stable in the 81% to 83% range; flag if it drops below 80%.
• Free Cash Flow margin should be approximately 35% to 40% of revenue.
• Funds Held on Behalf of Guests must exactly equal Funds Payable to Guests in every period.
• Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period.
• Interest income should scale proportionally with the sum of Corporate Cash and Guest Funds.
• Capex as a percentage of revenue should not exceed 3%.
• Adjusted EBITDA margin should remain between 28% and 34%.

• Filings: SEC EDGAR (Airbnb 10-K, 10-Q) and the Airbnb Investor Relations website (shareholder letters).
• Peers for benchmarking: Booking Holdings (BKNG), Expedia Group (EXPE), and Marriott International (MAR).
• Industry data sources: STR (Smith Travel Research) for global ADR and occupancy trends, AirDNA for specific short-term rental market data and host supply metrics.
• Consensus estimates: FactSet or Bloomberg for forward-looking analyst estimates on GBV and Take Rate.

• Airbnb Q4 2025 Shareholder Letter and Earnings Release (investors.airbnb.com)
• Airbnb 2024 Annual Report on Form 10-K (sec.gov)
• Airbnb Q3 2025 Financial Results (investors.airbnb.com)
• GuruFocus: Airbnb Q4 2024 Earnings Report
• TipRanks: Airbnb Q4 2024 Earnings Summary
• Quartr: Airbnb Q4 2025 Earnings Summary & Outlook
• MLQ.ai: Airbnb Q4 2025 Financial Performance Details