Booking Holdings Inc. (BKNG) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Booking Holdings Inc. (BKNG) Bundle
Explore the financial potential of Booking Holdings Inc. (BKNG) with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and expenses to calculate the intrinsic value of Booking Holdings Inc. (BKNG) and inform your investment decisions.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 15,066.0 | 6,796.0 | 10,958.0 | 17,090.0 | 21,365.0 | 26,029.2 | 31,711.6 | 38,634.6 | 47,068.8 | 57,344.4 |
| Revenue Growth, % | 0 | -54.89 | 61.24 | 55.96 | 25.01 | 21.83 | 21.83 | 21.83 | 21.83 | 21.83 |
| EBITDA | 6,865.0 | 1,565.0 | 2,398.0 | 4,921.0 | 7,043.0 | 7,925.2 | 9,655.4 | 11,763.3 | 14,331.3 | 17,460.0 |
| EBITDA, % | 45.57 | 23.03 | 21.88 | 28.79 | 32.97 | 30.45 | 30.45 | 30.45 | 30.45 | 30.45 |
| Depreciation | 641.0 | 642.0 | 599.0 | 607.0 | 665.0 | 1,344.8 | 1,638.3 | 1,996.0 | 2,431.8 | 2,962.6 |
| Depreciation, % | 4.25 | 9.45 | 5.47 | 3.55 | 3.11 | 5.17 | 5.17 | 5.17 | 5.17 | 5.17 |
| EBIT | 6,224.0 | 923.0 | 1,799.0 | 4,314.0 | 6,378.0 | 6,580.5 | 8,017.1 | 9,767.3 | 11,899.5 | 14,497.3 |
| EBIT, % | 41.31 | 13.58 | 16.42 | 25.24 | 29.85 | 25.28 | 25.28 | 25.28 | 25.28 | 25.28 |
| Total Cash | 7,310.0 | 11,063.0 | 11,152.0 | 12,396.0 | 12,683.0 | 19,803.9 | 24,127.3 | 29,394.5 | 35,811.6 | 43,629.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,680.0 | 529.0 | 1,358.0 | 2,229.0 | 3,253.0 | 3,102.5 | 3,779.8 | 4,604.9 | 5,610.3 | 6,835.0 |
| Account Receivables, % | 11.15 | 7.78 | 12.39 | 13.04 | 15.23 | 11.92 | 11.92 | 11.92 | 11.92 | 11.92 |
| Inventories | .0 | 337.0 | 404.0 | 477.0 | -644.0 | 438.5 | 534.2 | 650.8 | 792.9 | 966.0 |
| Inventories, % | 0 | 4.96 | 3.69 | 2.79 | -3.01 | 1.68 | 1.68 | 1.68 | 1.68 | 1.68 |
| Accounts Payable | 1,239.0 | 735.0 | 1,586.0 | 2,507.0 | 3,480.0 | 3,356.2 | 4,088.9 | 4,981.6 | 6,069.1 | 7,394.0 |
| Accounts Payable, % | 8.22 | 10.82 | 14.47 | 14.67 | 16.29 | 12.89 | 12.89 | 12.89 | 12.89 | 12.89 |
| Capital Expenditure | -368.0 | -286.0 | -304.0 | -368.0 | -345.0 | -686.8 | -836.8 | -1,019.4 | -1,242.0 | -1,513.1 |
| Capital Expenditure, % | -2.44 | -4.21 | -2.77 | -2.15 | -1.61 | -2.64 | -2.64 | -2.64 | -2.64 | -2.64 |
| Tax Rate, % | 21.75 | 21.75 | 21.75 | 21.75 | 21.75 | 21.75 | 21.75 | 21.75 | 21.75 | 21.75 |
| EBITAT | 5,082.2 | 96.0 | 1,430.6 | 3,362.8 | 4,990.9 | 4,314.0 | 5,255.7 | 6,403.1 | 7,801.0 | 9,504.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 4,914.2 | 762.0 | 1,680.6 | 3,578.8 | 6,380.9 | 3,916.2 | 6,017.0 | 7,330.6 | 8,930.9 | 10,880.6 |
| WACC, % | 10.53 | 10.21 | 10.52 | 10.51 | 10.51 | 10.45 | 10.45 | 10.45 | 10.45 | 10.45 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 26,535.7 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 11,316 | |||||||||
| Terminal Value | 175,320 | |||||||||
| Present Terminal Value | 106,639 | |||||||||
| Enterprise Value | 133,175 | |||||||||
| Net Debt | 2,868 | |||||||||
| Equity Value | 130,307 | |||||||||
| Diluted Shares Outstanding, MM | 37 | |||||||||
| Equity Value Per Share | 3,567.11 |
What You Will Get
- Real Booking Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Booking Holdings Inc. (BKNG).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to suit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Booking Holdings Inc.'s (BKNG) fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections tailored to Booking Holdings Inc. (BKNG).
- Time-Saving and Accurate: Avoid the hassle of building models from scratch while ensuring precision and flexibility.
Key Features
- Customizable Booking Parameters: Adjust essential metrics such as booking growth, revenue per booking, and marketing expenditures.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Leverages Booking Holdings Inc.'s actual financial data for credible valuation results.
- Effortless Scenario Analysis: Evaluate various assumptions and easily compare results.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template with Booking Holdings Inc.'s (BKNG) data included.
- Step 2: Explore the pre-filled sheets and understand the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Booking Holdings Inc.'s (BKNG) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Booking Holdings Inc. (BKNG)?
- Accurate Data: Up-to-date Booking Holdings financials guarantee dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations save you the hassle of starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the travel industry.
- User-Friendly: Simple design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Investors: Evaluate Booking Holdings Inc.'s (BKNG) valuation prior to making investment decisions.
- CFOs and Financial Analysts: Enhance valuation workflows and assess financial forecasts.
- Startup Founders: Discover how leading travel companies like Booking Holdings Inc. are appraised.
- Consultants: Provide comprehensive valuation reports for clients in the travel sector.
- Students and Educators: Utilize actual market data to learn and teach valuation methodologies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Booking Holdings Inc. (BKNG) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Booking Holdings Inc. (BKNG).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.