|
Liberty TripAdvisor Holdings, Inc. (LTRPA) Valoración de DCF
US | Communication Services | Internet Content & Information | 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
Liberty TripAdvisor Holdings, Inc. (LTRPA) Bundle
Como inversor o analista, esta calculadora DCF (LTRPA) es el recurso perfecto para una valoración precisa. Cargados con datos reales de Liberty TripAdvisor Holdings, Inc., puede ajustar los pronósticos y observar instantáneamente los efectos.
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 | 1,560.0 | 604.0 | 902.0 | 1,492.0 | 1,788.0 | 1,640.7 | 1,505.6 | 1,381.6 | 1,267.8 | 1,163.4 |
| Revenue Growth, % | 0 | -61.28 | 49.34 | 65.41 | 19.84 | -8.24 | -8.24 | -8.24 | -8.24 | -8.24 |
| EBITDA | 59.0 | -805.0 | 205.0 | 255.0 | -813.0 | -334.3 | -306.8 | -281.5 | -258.3 | -237.0 |
| EBITDA, % | 3.78 | -133.28 | 22.73 | 17.09 | -45.47 | -20.37 | -20.37 | -20.37 | -20.37 | -20.37 |
| Depreciation | 169.0 | 168.0 | 150.0 | 97.0 | 87.0 | 218.7 | 200.7 | 184.2 | 169.0 | 155.1 |
| Depreciation, % | 10.83 | 27.81 | 16.63 | 6.5 | 4.87 | 13.33 | 13.33 | 13.33 | 13.33 | 13.33 |
| EBIT | -110.0 | -973.0 | 55.0 | 158.0 | -900.0 | -461.7 | -423.7 | -388.8 | -356.8 | -327.4 |
| EBIT, % | -7.05 | -161.09 | 6.1 | 10.59 | -50.34 | -28.14 | -28.14 | -28.14 | -28.14 | -28.14 |
| Total Cash | 341.0 | 423.0 | 760.0 | 1,053.0 | 1,090.0 | 1,009.7 | 926.5 | 850.2 | 780.2 | 715.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 187.0 | 133.0 | 190.0 | 206.0 | 192.0 | 261.3 | 239.7 | 220.0 | 201.9 | 185.3 |
| Account Receivables, % | 11.99 | 22.02 | 21.06 | 13.81 | 10.74 | 15.92 | 15.92 | 15.92 | 15.92 | 15.92 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accounts Payable | 170.0 | 54.0 | 140.0 | 242.0 | .0 | 169.3 | 155.3 | 142.5 | 130.8 | 120.0 |
| Accounts Payable, % | 10.9 | 8.94 | 15.52 | 16.22 | 0 | 10.32 | 10.32 | 10.32 | 10.32 | 10.32 |
| Capital Expenditure | -83.0 | -55.0 | -54.0 | -56.0 | -63.0 | -90.9 | -83.4 | -76.5 | -70.2 | -64.4 |
| Capital Expenditure, % | -5.32 | -9.11 | -5.99 | -3.75 | -3.52 | -5.54 | -5.54 | -5.54 | -5.54 | -5.54 |
| Tax Rate, % | 70.53 | 70.53 | 70.53 | 70.53 | 70.53 | 70.53 | 70.53 | 70.53 | 70.53 | 70.53 |
| EBITAT | -96.7 | -827.1 | -418.0 | 78.2 | -265.3 | -232.5 | -213.4 | -195.8 | -179.7 | -164.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -27.7 | -776.1 | -293.0 | 205.2 | -469.3 | -4.7 | -88.5 | -81.2 | -74.5 | -68.4 |
| WACC, % | 5.48 | 5.31 | 0.33671 | 3.23 | 2.06 | 3.28 | 3.28 | 3.28 | 3.28 | 3.28 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -284.9 | |||||||||
| Long Term Growth Rate, % | 3.80 | |||||||||
| Free cash flow (T + 1) | -71 | |||||||||
| Terminal Value | 13,725 | |||||||||
| Present Terminal Value | 11,678 | |||||||||
| Enterprise Value | 11,393 | |||||||||
| Net Debt | 37 | |||||||||
| Equity Value | 11,356 | |||||||||
| Diluted Shares Outstanding, MM | 78 | |||||||||
| Equity Value Per Share | 145.59 |
What You Will Get
- Real LTRPA Financials: Access historical and projected data for precise valuation.
- Adjustable Inputs: Customize WACC, tax rates, revenue growth, and capital expenditures.
- Automatic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Liberty TripAdvisor's future performance.
- Clear and Intuitive Design: Designed for professionals while remaining user-friendly for newcomers.
Key Features
- Real-Life LTRPA Data: Pre-filled with Liberty TripAdvisor Holdings' historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures to suit your analysis.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Testing: Create multiple forecast scenarios to evaluate various valuation outcomes.
- User-Friendly Design: Intuitive, structured layout designed for both professionals and beginners.
How It Works
- Download: Get the pre-formatted Excel file containing Liberty TripAdvisor Holdings, Inc.'s (LTRPA) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC as needed.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and assess results immediately.
- Make Decisions: Utilize the valuation insights to inform your investment strategy.
Why Choose This Calculator for Liberty TripAdvisor Holdings, Inc. (LTRPA)?
- Designed for Experts: A sophisticated tool favored by financial analysts, CFOs, and industry consultants.
- Accurate Financial Data: Historical and projected financials for Liberty TripAdvisor preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance to simplify the calculation process.
Who Should Use This Product?
- Investors: Accurately assess Liberty TripAdvisor's fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Easily customize the template for valuation reports tailored to clients.
- Entrepreneurs: Acquire insights into financial modeling practices used by leading companies.
- Educators: Employ it as a teaching resource to illustrate valuation methodologies.
What the Template Contains
- Preloaded LTRPA Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.