Liberty TripAdvisor Holdings, Inc. (LTRPB) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Liberty TripAdvisor Holdings, Inc. (LTRPB) Bundle
Looking to assess the intrinsic value of Liberty TripAdvisor Holdings, Inc.? Our (LTRPB) DCF Calculator integrates real-world data with comprehensive customization features, allowing you to adjust forecasts and enhance your investment choices.
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 LTRPB Financials: Access to both historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Liberty TripAdvisor's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive DCF Model: Features detailed unlevered and levered DCF valuation frameworks tailored for Liberty TripAdvisor Holdings, Inc. (LTRPB).
- WACC Analysis Tool: Includes a pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Inputs: Easily adjust growth projections, capital investments, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and operational efficiency ratios specific to Liberty TripAdvisor Holdings, Inc. (LTRPB).
- Interactive Dashboard and Visuals: Graphical representations summarize essential valuation metrics for straightforward interpretation.
How It Works
- Download the Template: Gain immediate access to the Excel-based LTRPB DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Liberty TripAdvisor's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Liberty TripAdvisor Holdings, Inc. (LTRPB)?
- User-Friendly Interface: Tailored for both novice users and seasoned analysts.
- Customizable Inputs: Adjust parameters easily to suit your financial assessments.
- Real-Time Valuation Updates: Monitor immediate changes to Liberty TripAdvisor's valuation as you tweak inputs.
- Pre-Loaded Data: Comes equipped with Liberty TripAdvisor's latest financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and financial analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Assess Liberty TripAdvisor Holdings, Inc.'s (LTRPB) performance before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and evaluate financial forecasts for LTRPB.
- Startup Founders: Understand the valuation strategies of established companies like Liberty TripAdvisor.
- Consultants: Create detailed valuation reports for clients involving LTRPB.
- Students and Educators: Utilize real-time data to learn and teach valuation practices related to LTRPB.
What the Template Contains
- Historical Data: Includes Liberty TripAdvisor Holdings, Inc.’s (LTRPB) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Liberty TripAdvisor’s (LTRPB) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Liberty TripAdvisor’s (LTRPB) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.