|
Tuniu Corporation (Tour) Valoración de DCF
CN | Consumer Cyclical | Travel Services | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Tuniu Corporation (TOUR) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF (tour)! Utilizando datos reales de Tuniu Corporation y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valorar Tuniu como un inversor experimentado.
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 | 312.5 | 61.7 | 58.4 | 25.2 | 60.5 | 54.0 | 48.3 | 43.2 | 38.6 | 34.5 |
| Revenue Growth, % | 0 | -80.26 | -5.31 | -56.93 | 140.32 | -10.63 | -10.63 | -10.63 | -10.63 | -10.63 |
| EBITDA | -95.3 | -170.2 | -7.9 | -20.2 | -9.0 | -25.9 | -23.1 | -20.7 | -18.5 | -16.5 |
| EBITDA, % | -30.49 | -275.95 | -13.55 | -80.47 | -14.93 | -47.89 | -47.89 | -47.89 | -47.89 | -47.89 |
| Depreciation | 44.2 | 30.6 | 8.7 | 5.2 | 4.1 | 11.5 | 10.3 | 9.2 | 8.2 | 7.3 |
| Depreciation, % | 14.14 | 49.61 | 14.97 | 20.78 | 6.73 | 21.25 | 21.25 | 21.25 | 21.25 | 21.25 |
| EBIT | -139.5 | -200.8 | -16.7 | -25.5 | -13.1 | -31.9 | -28.5 | -25.4 | -22.7 | -20.3 |
| EBIT, % | -44.63 | -325.56 | -28.51 | -101.25 | -21.65 | -58.96 | -58.96 | -58.96 | -58.96 | -58.96 |
| Total Cash | 219.3 | 214.7 | 132.2 | 120.3 | 158.5 | 50.8 | 45.4 | 40.6 | 36.3 | 32.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 109.6 | 39.5 | 17.4 | 4.8 | 7.0 | 17.2 | 15.4 | 13.8 | 12.3 | 11.0 |
| Account Receivables, % | 35.07 | 63.97 | 29.77 | 18.88 | 11.59 | 31.86 | 31.86 | 31.86 | 31.86 | 31.86 |
| Inventories | 44.8 | 6.9 | 16.8 | 6.0 | .0 | 8.5 | 7.6 | 6.8 | 6.0 | 5.4 |
| Inventories, % | 14.34 | 11.23 | 28.75 | 23.99 | 0 | 15.66 | 15.66 | 15.66 | 15.66 | 15.66 |
| Accounts Payable | 183.8 | 99.3 | 53.1 | 36.4 | 43.4 | 45.6 | 40.7 | 36.4 | 32.5 | 29.1 |
| Accounts Payable, % | 58.82 | 161 | 90.88 | 144.74 | 71.86 | 84.31 | 84.31 | 84.31 | 84.31 | 84.31 |
| Capital Expenditure | -16.8 | -3.9 | -2.0 | -.9 | -1.3 | -2.3 | -2.0 | -1.8 | -1.6 | -1.4 |
| Capital Expenditure, % | -5.37 | -6.29 | -3.46 | -3.51 | -2.22 | -4.17 | -4.17 | -4.17 | -4.17 | -4.17 |
| Tax Rate, % | 0.36626 | 0.36626 | 0.36626 | 0.36626 | 0.36626 | 0.36626 | 0.36626 | 0.36626 | 0.36626 | 0.36626 |
| EBITAT | -139.7 | -199.9 | -16.7 | -25.4 | -13.0 | -31.8 | -28.4 | -25.4 | -22.7 | -20.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -82.8 | -149.6 | -44.0 | -14.3 | .5 | -39.1 | -22.3 | -19.9 | -17.8 | -15.9 |
| WACC, % | 10.77 | 10.76 | 10.77 | 10.77 | 10.77 | 10.77 | 10.77 | 10.77 | 10.77 | 10.77 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -89.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -16 | |||||||||
| Terminal Value | -185 | |||||||||
| Present Terminal Value | -111 | |||||||||
| Enterprise Value | -200 | |||||||||
| Net Debt | -22 | |||||||||
| Equity Value | -178 | |||||||||
| Diluted Shares Outstanding, MM | 124 | |||||||||
| Equity Value Per Share | -1.44 |
What You Will Receive
- Adjustable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to generate various scenarios.
- Comprehensive Data: Tuniu Corporation’s financial data pre-loaded to facilitate your analysis.
- Automated DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Tailored and Professional: A refined Excel model that aligns with your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Tuniu Corporation (TOUR).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for accurate assessments.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Tuniu's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Tuniu Corporation (TOUR).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- 1. Download the Template: Obtain and open the Excel file containing Tuniu Corporation's (TOUR) preloaded data.
- 2. Modify Assumptions: Adjust key variables such as growth rates, WACC, and capital expenditures as needed.
- 3. Review Results Instantly: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation possibilities.
- 5. Present with Assurance: Share professional valuation insights to back your strategic decisions.
Why Choose This Calculator for Tuniu Corporation (TOUR)?
- Accurate Data: Utilize real Tuniu Corporation financials for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Ready-made calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the travel sector.
- User-Friendly: Designed with an intuitive interface and step-by-step guidance for users of all levels.
Who Should Use Tuniu Corporation (TOUR)?
- Travel Enthusiasts: Explore a wide range of travel options and packages tailored to your preferences.
- Travel Agents: Utilize Tuniu's platform to streamline booking processes for clients.
- Business Travelers: Access convenient travel solutions and corporate packages for seamless trips.
- Families: Find family-friendly vacation options and activities that cater to all ages.
- Students: Take advantage of special discounts and travel deals designed for educational trips.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Tuniu Corporation (TOUR) 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 Tuniu Corporation (TOUR).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.