Liberty TripAdvisor Holdings, Inc. (LTRPA) DCF Valuation

Liberty TripAdvisor Holdings, Inc. (LTRPA) 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

Liberty TripAdvisor Holdings, Inc. (LTRPA) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

As an investor or analyst, this (LTRPA) DCF Calculator is the perfect resource for accurate valuation. Loaded with real data from Liberty TripAdvisor Holdings, Inc., you can adjust forecasts and instantly observe the effects.


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
Account Receivables, % 11.99 22.02 21.06 13.81 10.74
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.

No products were found matching.