Playa Hotels & Resorts N.V. (PLYA) DCF Valuation

Playa Hotels & Resorts N.V. (PLYA) DCF Valuation

US | Consumer Cyclical | Gambling, Resorts & Casinos | NASDAQ
Playa Hotels & Resorts N.V. (PLYA) 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

Playa Hotels & Resorts N.V. (PLYA) Bundle

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

TOTAL:

Gain insight into your Playa Hotels & Resorts N.V. (PLYA) valuation analysis using our cutting-edge DCF Calculator! This Excel template comes preloaded with real (PLYA) data, enabling you to adjust forecasts and assumptions to accurately determine the intrinsic value of Playa Hotels & Resorts N.V.


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 636.5 273.2 534.6 856.3 977.5 1,253.5 1,607.4 2,061.3 2,643.3 3,389.7
Revenue Growth, % 0 -57.08 95.7 60.16 14.16 28.24 28.24 28.24 28.24 28.24
EBITDA 133.1 -98.8 57.3 207.9 258.0 115.7 148.3 190.2 243.9 312.7
EBITDA, % 20.92 -36.18 10.71 24.28 26.4 9.23 9.23 9.23 9.23 9.23
Depreciation 601.9 382.5 524.0 697.2 81.8 958.6 1,229.2 1,576.3 2,021.4 2,592.1
Depreciation, % 94.56 140.01 98 81.42 8.37 76.47 76.47 76.47 76.47 76.47
EBIT -468.8 -481.3 -466.7 -489.2 176.2 -752.2 -964.6 -1,237.0 -1,586.3 -2,034.1
EBIT, % -73.65 -176.18 -87.29 -57.14 18.03 -60.01 -60.01 -60.01 -60.01 -60.01
Total Cash 20.9 146.9 270.1 283.9 272.5 422.7 542.1 695.2 891.5 1,143.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 76.7 29.2 53.4 105.9 90.4
Account Receivables, % 12.04 10.67 9.99 12.37 9.25
Inventories 16.6 13.8 18.1 20.0 20.0 38.7 49.6 63.6 81.6 104.6
Inventories, % 2.62 5.06 3.38 2.34 2.04 3.09 3.09 3.09 3.09 3.09
Accounts Payable 52.9 31.4 23.8 28.4 25.9 75.8 97.2 124.7 159.9 205.1
Accounts Payable, % 8.31 11.5 4.46 3.32 2.65 6.05 6.05 6.05 6.05 6.05
Capital Expenditure -212.5 -37.4 -17.6 -29.2 -46.2 -146.7 -188.1 -241.2 -309.3 -396.6
Capital Expenditure, % -33.39 -13.68 -3.3 -3.41 -4.72 -11.7 -11.7 -11.7 -11.7 -11.7
Tax Rate, % 17.87 17.87 17.87 17.87 17.87 17.87 17.87 17.87 17.87 17.87
EBITAT -94.7 -462.0 -431.1 -542.4 144.7 -587.8 -753.7 -966.6 -1,239.5 -1,589.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 254.3 -88.0 39.1 75.7 193.5 209.5 259.4 332.7 426.6 547.1
WACC, % 8.38 11.18 11.05 11.33 10.67 10.52 10.52 10.52 10.52 10.52
PV UFCF
SUM PV UFCF 1,266.0
Long Term Growth Rate, % 3.50
Free cash flow (T + 1) 566
Terminal Value 8,061
Present Terminal Value 4,888
Enterprise Value 6,154
Net Debt 798
Equity Value 5,356
Diluted Shares Outstanding, MM 150
Equity Value Per Share 35.63

What You Will Get

  • Pre-Filled Financial Model: Playa Hotels & Resorts N.V.'s actual data allows for accurate DCF valuation.
  • Full Forecast Control: Modify occupancy rates, average daily rates, and other critical metrics.
  • Instant Calculations: Real-time updates ensure you see outcomes as you adjust inputs.
  • Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
  • Customizable and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.

Key Features

  • Comprehensive Data: Playa Hotels & Resorts N.V.'s historical financial statements and pre-filled projections.
  • Customizable Variables: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
  • Real-Time Insights: Monitor Playa Hotels & Resorts N.V.'s intrinsic value as it updates instantly.
  • Visual Performance Metrics: Interactive dashboard charts showcase valuation outcomes and essential metrics.
  • Designed for Precision: A sophisticated tool tailored for analysts, investors, and finance professionals.

How It Works

  1. Download the Template: Gain immediate access to the Excel-based PLYA DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
  3. Instant Calculations: The model automatically recalculates Playa Hotels & Resorts' intrinsic value.
  4. Test Scenarios: Experiment with various assumptions to assess potential valuation changes.
  5. Analyze and Decide: Utilize the results to inform your investment or financial analysis.

Why Choose This Calculator for Playa Hotels & Resorts N.V. (PLYA)?

  • User-Friendly Interface: Tailored for both novice and experienced users.
  • Customizable Inputs: Adjust parameters easily to suit your financial analysis.
  • Real-Time Valuation: Observe immediate updates to Playa's valuation as you change inputs.
  • Preloaded Data: Comes with Playa's actual financial information for swift evaluations.
  • Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.

Who Should Use This Product?

  • Investors: Accurately assess Playa Hotels & Resorts N.V.'s (PLYA) fair value before making investment decisions.
  • CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to the hospitality sector.
  • Consultants: Easily customize the template for valuation reports tailored to clients in the tourism industry.
  • Entrepreneurs: Acquire insights into financial modeling practices employed by leading hotel chains.
  • Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to the hospitality market.

What the Template Contains

  • Preloaded PLYA 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.