Trip.com Group Limited (TCOM) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Trip.com Group Limited (TCOM) Bundle
Discover the true potential of Trip.com Group Limited (TCOM) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect Trip.com Group Limited (TCOM) valuation – all within a single Excel template.
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 | 4,886.6 | 2,509.5 | 2,743.3 | 2,745.5 | 6,098.3 | 7,024.5 | 8,091.4 | 9,320.4 | 10,736.0 | 12,366.6 |
| Revenue Growth, % | 0 | -48.65 | 9.32 | 0.07990811 | 122.12 | 15.19 | 15.19 | 15.19 | 15.19 | 15.19 |
| EBITDA | 840.3 | 67.3 | 149.9 | 12.1 | 1,663.0 | 745.3 | 858.5 | 988.9 | 1,139.1 | 1,312.1 |
| EBITDA, % | 17.2 | 2.68 | 5.46 | 0.43914 | 27.27 | 10.61 | 10.61 | 10.61 | 10.61 | 10.61 |
| Depreciation | 198.7 | 214.6 | 193.6 | 176.9 | 111.5 | 392.6 | 452.2 | 520.9 | 600.0 | 691.1 |
| Depreciation, % | 4.07 | 8.55 | 7.06 | 6.44 | 1.83 | 5.59 | 5.59 | 5.59 | 5.59 | 5.59 |
| EBIT | 641.6 | -147.3 | -43.7 | -164.8 | 1,551.5 | 352.7 | 406.3 | 468.0 | 539.1 | 621.0 |
| EBIT, % | 13.13 | -5.87 | -1.59 | -6 | 25.44 | 5.02 | 5.02 | 5.02 | 5.02 | 5.02 |
| Total Cash | 5,888.8 | 6,060.6 | 6,954.8 | 6,032.8 | 8,130.1 | 7,024.5 | 8,091.4 | 9,320.4 | 10,736.0 | 12,366.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,407.4 | 763.7 | 851.5 | 959.6 | 1,929.4 | 2,203.8 | 2,538.5 | 2,924.0 | 3,368.1 | 3,879.7 |
| Account Receivables, % | 28.8 | 30.43 | 31.04 | 34.95 | 31.64 | 31.37 | 31.37 | 31.37 | 31.37 | 31.37 |
| Inventories | 249.9 | .0 | .0 | .0 | .0 | 71.8 | 82.8 | 95.3 | 109.8 | 126.5 |
| Inventories, % | 5.11 | 0 | 0 | 0 | 0 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 |
| Accounts Payable | 1,714.4 | 650.4 | 843.6 | 1,058.4 | 2,255.0 | 2,350.1 | 2,707.0 | 3,118.2 | 3,591.8 | 4,137.3 |
| Accounts Payable, % | 35.08 | 25.92 | 30.75 | 38.55 | 36.98 | 33.46 | 33.46 | 33.46 | 33.46 | 33.46 |
| Capital Expenditure | -114.3 | -72.9 | -78.2 | -68.2 | -83.0 | -167.8 | -193.2 | -222.6 | -256.4 | -295.3 |
| Capital Expenditure, % | -2.34 | -2.9 | -2.85 | -2.49 | -1.36 | -2.39 | -2.39 | -2.39 | -2.39 | -2.39 |
| Tax Rate, % | 7.13 | 7.13 | 7.13 | 7.13 | 7.13 | 7.13 | 7.13 | 7.13 | 7.13 | 7.13 |
| EBITAT | 495.0 | -190.0 | -68.8 | -122.2 | 1,440.8 | 313.3 | 360.9 | 415.7 | 478.8 | 551.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 636.6 | -218.7 | 152.0 | 93.2 | 1,696.2 | 286.9 | 631.2 | 727.0 | 837.5 | 964.7 |
| WACC, % | 5.96 | 6.08 | 6.08 | 5.94 | 6.04 | 6.02 | 6.02 | 6.02 | 6.02 | 6.02 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,825.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 984 | |||||||||
| Terminal Value | 24,482 | |||||||||
| Present Terminal Value | 18,278 | |||||||||
| Enterprise Value | 21,104 | |||||||||
| Net Debt | 545 | |||||||||
| Equity Value | 20,558 | |||||||||
| Diluted Shares Outstanding, MM | 671 | |||||||||
| Equity Value Per Share | 30.64 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled real TCOM financials.
- Actual Data Insights: Historical performance data and forward-looking projections (highlighted in the yellow cells).
- Adjustable Forecasts: Modify key assumptions such as revenue growth, EBITDA %, and WACC as needed.
- Instant Calculations: Quickly observe how your inputs affect Trip.com Group Limited’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Centric Layout: Organized for simplicity and ease of navigation, complete with step-by-step guidance.
Key Features
- Customizable Travel Parameters: Adjust essential metrics such as booking growth, commission rates, and marketing expenditures.
- Instant DCF Valuation: Quickly determines intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Leverages Trip.com Group Limited's (TCOM) actual financial data for dependable valuation results.
- Simplified Scenario Analysis: Easily evaluate various assumptions and analyze different outcomes.
- Efficiency Booster: Streamlines the valuation process, removing the need for intricate model creation from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Trip.com Group Limited (TCOM) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Trip.com Group Limited’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Trip.com Group Limited (TCOM)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for TCOM.
- Flexible Parameters: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Trip.com’s intrinsic value and Net Present Value.
- Ready-to-Use Data: Includes historical and projected data for reliable analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focusing on TCOM.
Who Should Use This Product?
- Investors: Evaluate Trip.com Group Limited’s (TCOM) valuation before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts for TCOM.
- Startup Founders: Understand the valuation strategies of leading travel companies like Trip.com Group Limited (TCOM).
- Consultants: Provide detailed valuation analyses and reports for clients considering TCOM.
- Students and Educators: Utilize real-time data from Trip.com Group Limited (TCOM) to teach and practice valuation skills.
What the Template Contains
- Pre-Filled Data: Includes Trip.com Group Limited’s (TCOM) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Trip.com Group Limited’s (TCOM) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.