# Booking Holdings (BKNG) Financial Model Free Excel 3-statement financial model and company analysis for Booking Holdings. - Canonical: https://finamodel.com/companies/booking-holdings - Industry: Travel - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/BKNG.xlsx ## Model Purpose This model evaluates the equity valuation and free cash flow generation of Booking Holdings, specifically focusing on how the ongoing strategic shift from the Agency model to the Merchant model impacts working capital dynamics, take rates, and overall profitability. ## Company Overview - Booking Holdings is the world's leading provider of online travel and related services, connecting consumers with travel service providers for accommodation, flights, and rental cars. - **Business Segments:** The company reports revenue across three categories: Merchant (~55-60%), Agency (~35-40%), and Advertising & Other (~5-10%). - **Key Geographies:** Highly exposed to Europe (where Booking.com dominates) and Asia (Agoda), with a smaller but growing presence in the US (Priceline). - **Business Model:** Asset-light online marketplace. The company is actively transitioning from an "Agency" model (where the hotel processes the payment and pays Booking a commission) to a "Merchant" model (where Booking processes the payment, creating a massive negative working capital advantage). - **Competitive Position:** The dominant global Online Travel Agency (OTA), competing primarily with Expedia Group, Airbnb, and Google Travel. - **Recent Major Events:** A major Transformation Program announced in late 2024/2025 targeting $550 million in annual run-rate savings by the end of 2026. Additionally, the Board approved a 25-for-1 stock split effective April 2, 2026. ## Revenue Deep Dive ### Merchant Revenues - **Segment Name:** Merchant revenues - **Revenue Driver Formula:** `Merchant Gross Bookings x Merchant Take Rate` - **Historical Growth Rate:** 15-25% CAGR (growing faster than total revenue due to the strategic shift from Agency). - **Key Growth Levers:** Expansion of Booking.com's payment platform, growth in flight bookings (which are primarily merchant), and alternative accommodations. - **Pricing Dynamics:** Take rates are generally stable but can fluctuate based on the mix of flights (lower take rate) vs. accommodations (higher take rate). - **Revenue Recognition:** Recognised when the traveller's stay occurs, though cash is often collected at the time of booking, creating significant deferred merchant bookings. - **Seasonality:** Highly seasonal. Q3 (European summer) generates the highest gross bookings and revenue; Q1 is typically the lowest for revenue but high for cash collection (summer bookings made in advance). ### Agency Revenues - **Segment Name:** Agency revenues - **Revenue Driver Formula:** `Agency Gross Bookings x Agency Take Rate` - **Historical Growth Rate:** Flat to slightly declining (as volume shifts to Merchant). - **Key Growth Levers:** Legacy European hotel relationships that prefer to handle their own payment processing. - **Pricing Dynamics:** Commission rates are typically 15-20% of the booking value. - **Revenue Recognition:** Recognised when the stay occurs. Cash is collected *after* the stay when the hotel pays the commission invoice. ### Advertising and Other Revenues - **Segment Name:** Advertising and other revenues - **Revenue Driver Formula:** `Clicks/Referrals x Cost Per Click (KAYAK) + Restaurant Seated Diners x Fee (OpenTable)` - **Historical Growth Rate:** Low single digits (mature businesses). - **Key Growth Levers:** Metasearch traffic (KAYAK) and dining reservations (OpenTable). ## Cost Structure ### Variable Costs / COGS - **Cost of Revenues:** Primarily consists of payment processing fees (which grow linearly with Merchant Gross Bookings), customer service expenses, and data centre costs. - **Gross Margin Range:** 80-85% (historically higher, but compressing slightly as the Merchant model incurs payment processing fees that the Agency model did not). - **Key Input Costs:** Credit card interchange fees and cloud computing costs. ### Operating Expenses - **Performance Marketing:** The largest expense line (typically 30-35% of revenue). Highly variable. Driven by ROI targets on Google, Meta, and affiliate networks. - **Brand Marketing:** TV, online video, and out-of-home advertising (typically 8-10% of revenue). - **Personnel:** Headcount-driven costs for engineering, sales, and corporate staff. Expected to see leverage due to the $550M Transformation Program. - **Information Technology:** Software licences, outsourced development, and cybersecurity. - **Depreciation & Amortisation:** Relatively low (asset-light model), mostly amortisation of acquired intangibles and capitalised software. ### Margin Profile - **EBITDA Margin:** Adjusted EBITDA margin runs at 35-37% (36.9% in FY2025). - **Operating Margin:** 28-32%. - **Net Margin:** 20-25% (20.1% in FY2025). - **Margin Trend:** Expanding slightly due to cost discipline and the Transformation Program, though offset by the lower gross margin of the Merchant business. ## Balance Sheet Structure - **Total Assets:** ~$25-30 billion. - **Key Asset Categories:** Cash and short-term investments (massive balance), Accounts Receivable (from Agency commissions), and Goodwill/Intangibles (from historical acquisitions like KAYAK, OpenTable, Agoda). - **Working Capital Profile:** - **DSO:** 30-40 days (driven by Agency receivables). - **DPO:** 60-80 days (driven by Merchant payables to hotels). - **Net Working Capital:** Deeply negative. This is a core feature of the business. As Merchant bookings grow, BKNG collects cash upfront and pays hotels later, generating float. - **PP&E:** Minimal. Mostly leasehold improvements for offices and data centre equipment. ## Capital Expenditure & Investment - **Capex as % of Revenue:** Very low, typically 1.5% - 2.5%. - **Maintenance vs. Growth:** Almost entirely growth/IT infrastructure (capitalised software development). - **M&A Pattern:** Historically a transformational acquirer (Active Hotels, Bookings B.V., Agoda), but recently focused on bolt-ons (e.g., flight tech, B2B distribution) or organic growth. ## Debt & Capital Structure - **Total Debt:** ~$12-15 billion, primarily senior notes and convertible bonds. - **Net Debt:** Often negative or near zero due to massive cash balances. - **Debt/EBITDA Ratio:** ~1.0x - 1.5x (very conservative). - **Credit Rating:** Investment grade (A- / A3). - **Share Repurchase Programme:** Extremely active. Repurchased $2.1 billion in Q4 2025 alone, with $21.8 billion remaining on the authorisation. This aggressively shrinks the share count every year. - **Dividend Policy:** Initiated a dividend recently; yields <1% but growing. ## Cash Flow Characteristics - **OCF Conversion:** Operating Cash Flow consistently exceeds Net Income (often 120-150% conversion) due to the positive cash flow impact of deferred merchant bookings and stock-based compensation. - **Free Cash Flow Margin:** Exceptional. Typically 30-35% of revenue ($9.1B FCF on $26.9B revenue in FY2025, a 33.8% margin). - **Working Capital Impact:** A major source of cash during growth phases. If bookings decline, this reverses and becomes a massive use of cash (as seen during the 2020 pandemic). - **Capex Intensity:** Negligible, allowing almost all OCF to convert to FCF. ## Sheet Structure 1. **Assumptions:** Hardcoded drivers for room nights, ADR, take rates, marketing efficiency, and margin targets. 2. **Operating Metrics:** Calculates Room Nights, Gross Bookings (split by Merchant and Agency), and implied Take Rates. 3. **Income Statement:** Revenue split by Merchant, Agency, and Advertising. Expenses split by Cost of Revenues, Performance Marketing, Brand Marketing, Personnel, IT, and G&A. 4. **Balance Sheet:** Highlights Cash, Accounts Receivable, Deferred Merchant Bookings (Liability), and Accounts Payable. 5. **Cash Flow Statement:** Bridges Net Income to OCF (highlighting the NWC benefit) and deducts Capex to reach FCF. 6. **Working Capital Schedule:** Projects AR based on Agency Revenue, and Deferred Bookings/AP based on Merchant Gross Bookings. 7. **Debt & Interest Schedule:** Tracks senior notes, convertible debt, interest expense, and interest income on cash balances. 8. **Shareholders' Equity:** Tracks retained earnings, dividend payouts, and the massive share repurchase programme. 9. **DCF Valuation:** Unlevered free cash flow projection, WACC calculation, and terminal value. ## Key Financial Relationships 1. `Total Gross Bookings = Room Nights x Average Daily Rate (ADR)` 2. `Merchant Revenue = Merchant Gross Bookings x Merchant Take Rate` 3. `Agency Revenue = Agency Gross Bookings x Agency Take Rate` 4. `Total Revenue = Merchant Revenue + Agency Revenue + Advertising & Other Revenue` 5. `Cost of Revenues = Total Revenue x Cost of Revenues %` (Note: heavily influenced by Merchant mix due to payment processing). 6. `Performance Marketing Expense = Total Gross Bookings x Performance Marketing ROI Factor` (or as a % of Total Revenue). 7. `Adjusted EBITDA = Net Income + Taxes + Interest Expense - Interest Income + D&A + Stock-Based Compensation + Restructuring Charges` 8. `Deferred Merchant Bookings (Liability) = Merchant Gross Bookings x (Average Days to Stay / 365)` 9. `Free Cash Flow = Cash Provided by Operating Activities - Capital Expenditures` 10. `Ending Share Count = Beginning Share Count - (Share Repurchase $ / Average Share Price)` ## Cross-Sheet Dependencies - **Operating Metrics** feeds the **Income Statement** (Gross Bookings drive Revenue) and the **Working Capital Schedule** (Merchant Gross Bookings drive Deferred Merchant Bookings). - **Income Statement** generates Net Income, which feeds the top of the **Cash Flow Statement** and Retained Earnings on the **Balance Sheet**. - **Working Capital Schedule** calculates the change in NWC, which is the most critical bridge item on the **Cash Flow Statement**. - **Cash Flow Statement** generates ending cash, which feeds the **Balance Sheet** and calculates Interest Income on the **Debt & Interest Schedule**. - **Shareholders' Equity** calculates the reduced share count, which feeds the EPS calculation on the **Income Statement** and the per-share valuation on the **DCF Valuation**. ## Sign Convention - All inputs on the Assumptions sheet should be entered as positive numbers (e.g., 35% for margin, 15% for tax rate). - On the Income Statement, Revenues are positive. Expenses should be displayed as negative numbers (or positive numbers with a clear subtraction in the gross margin / operating income formulas). - On the Cash Flow Statement, cash inflows (e.g., increase in payables) are positive, and cash outflows (e.g., capex, share repurchases, increase in receivables) are negative. ## Things Most Likely to Go Wrong 1. **Ignoring the Stock Split:** The Board approved a 25-for-1 stock split effective April 2, 2026. The model must clearly state whether it is operating on a pre-split or post-split basis for per-share metrics to avoid a 25x valuation error. 2. **Mismodelling Working Capital:** Treating working capital as a standard % of revenue will break the model. NWC is driven by *Merchant Gross Bookings*, not total revenue. 3. **Agency vs. Merchant Mix:** Failing to shift the mix toward Merchant will understate Cost of Revenues (payment fees) and understate the cash flow benefit of deferred bookings. 4. **Performance Marketing Deleverage:** Assuming performance marketing scales linearly with revenue ignores the reality that marginal customer acquisition costs typically rise over time. 5. **Interest Income:** BKNG holds massive cash balances. Ignoring interest income will significantly understate Net Income and EPS. 6. **Stock-Based Compensation:** SBC is a real dilution cost. Excluding it from valuation while using Adjusted EBITDA will overvalue the equity. 7. **Seasonality in NWC:** If building a quarterly model, Q1 and Q2 generate massive cash inflows (bookings made), while Q3 sees cash outflows (stays occur and hotels are paid). Annual models smooth this out, but quarterly models will break if seasonality is ignored. 8. **Share Count Reduction:** BKNG buys back billions in stock annually. Holding the share count flat will severely understate future EPS. ## Validation Checks 1. "Adjusted EBITDA margin should be in the 35-37% range; flag if outside this band." 2. "Free Cash Flow conversion (FCF / Net Income) should be >120% due to negative working capital dynamics." 3. "Total Take Rate (Total Revenue / Total Gross Bookings) should remain between 14.0% and 15.0%." 4. "Merchant Revenue must be >50% of Total Revenue and growing as a percentage of the mix." 5. "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period." 6. "Capex as a % of revenue should not exceed 3.0%." 7. "Performance Marketing should be the largest single operating expense line item." ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Total Room Nights (FY25) | 1,235 | Millions | Actual reported figure for FY2025. | | Room Night Growth Rate | 8.0 | % | Actual YoY growth rate achieved in FY2025. | | Average Gross Booking per Room Night | 150.68 | $ | Implied from FY25 Gross Bookings ($186.1B) / Room Nights (1,235M). | | Merchant % of Gross Bookings | 58.0 | % | Reflects the ongoing strategic shift toward the merchant model. | | Implied Total Take Rate | 14.45 | % | FY25 Revenue ($26.9B) / FY25 Gross Bookings ($186.1B). | | Cost of Revenues % of Revenue | 16.0 | % | Blended rate; increasing slightly as Merchant mix (payment processing) grows. | | Performance Marketing % of Gross Bookings | 4.5 | % | Standard efficiency ratio for customer acquisition via search/metasearch. | | Brand Marketing % of Revenue | 8.5 | % | Historical average for brand campaigns. | | Adjusted EBITDA Margin | 36.9 | % | Actual reported Adjusted EBITDA margin for FY2025. | | Effective Tax Rate | 19.0 | % | Typical blended rate given the Netherlands (Booking.com) tax structure. | | Capex as % of Revenue | 2.0 | % | Asset-light business model; primarily capitalised software. | | Annual Share Repurchases | 8,000 | $ Millions | Run-rate based on $2.1B repurchased in Q4 2025 and $21.8B remaining auth. | | Pre-Split Shares Outstanding | 31.67 | Millions | Actual share count as of February 2026 (Note: 25-for-1 split in April 2026). | | WACC | 8.5 | % | Standard discount rate for a mature, highly profitable, large-cap tech/travel firm. | | Terminal FCF Growth Rate | 2.5 | % | Aligns with long-term global GDP and travel industry growth. | ## Data Sources & Benchmarks - **SEC Filings:** Available on the SEC EDGAR database (search ticker: BKNG). - **Investor Relations:** ir.bookingholdings.com for earnings presentations, prepared remarks, and the "Factsheet". - **Key Peers for Benchmarking:** Expedia Group (EXPE), Airbnb (ABNB), Trip.com Group (TCOM). - **Industry Data Sources:** UNWTO (World Tourism Organization) for global travel trends, STR (CoStar) for hotel occupancy and ADR data. - **Proprietary Data:** SimilarWeb (for tracking web traffic share between Booking.com and Expedia), credit card panel data (for real-time gross bookings tracking). ## Sources - Booking Holdings Q4 and Full Year 2025 Earnings Release (SEC Form 8-K, Feb 18, 2026): https://www.sec.gov/ - Booking Holdings 2025 Annual Report (Form 10-K): https://www.sec.gov/ - Booking Holdings Investor Relations Website: https://ir.bookingholdings.com/ - Macrotrends Historical Revenue Data (BKNG): https://www.macrotrends.net/ --- ## Frequently asked questions ### What is Booking Holdings and what services does it provide? Booking Holdings is the world's leading provider of online travel and related services. It connects consumers with travel service providers for accommodation, flights, and rental cars, operating an asset-light online marketplace. ### How does Booking Holdings generate its revenue across its business segments? Booking Holdings generates revenue primarily through its Merchant (~55-60%), Agency (~35-40%), and Advertising & Other (~5-10%) segments. The company's active transition from an Agency to a Merchant model significantly impacts its revenue recognition and working capital. ### How does Booking Holdings' strategic shift to the Merchant model affect its working capital? The shift to the Merchant model is creating a massive negative working capital advantage for Booking Holdings. This occurs because Booking collects cash upfront from customers and pays hotels later, generating significant float. ### What is Booking Holdings' capital expenditure strategy and how does it relate to revenue? Booking Holdings maintains a very low capital expenditure as a percentage of revenue, typically between 1.5% and 2.5%. This capex is almost entirely for growth and IT infrastructure, including capitalized software development, rather than maintenance. ### What are the key considerations for valuing Booking Holdings using a financial model? Key considerations for valuing Booking Holdings include its free cash flow generation and the impact of its strategic shift from the Agency to the Merchant model. This transition significantly influences working capital dynamics, take rates, and overall profitability, which are crucial for equity valuation. ### Can I download an Excel financial model for Booking Holdings to analyze its valuation? Yes, a downloadable Excel financial model is available for Booking Holdings (BKNG) that evaluates its equity valuation and free cash flow generation. The model specifically focuses on the impact of the ongoing strategic shift on working capital and profitability. [Interactive forecast calculator](https://finamodel.com/companies/booking-holdings/forecast)