Park Hotels & Resorts Inc. (PK) DCF Valuation

Park Hotels & Resorts Inc. (PK) DCF Valuation
  • 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

Park Hotels & Resorts Inc. (PK) 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:

Enhance your investment strategies with the Park Hotels & Resorts Inc. (PK) DCF Calculator! Utilize accurate financial data, adjust growth projections and expenses, and instantly observe how these alterations affect the intrinsic value of Park Hotels & Resorts Inc. (PK).


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 2,844.0 852.0 1,362.0 2,501.0 2,698.0 3,246.5 3,906.5 4,700.7 5,656.4 6,806.4
Revenue Growth, % 0 -70.04 59.86 83.63 7.88 20.33 20.33 20.33 20.33 20.33
EBITDA 709.0 -939.0 89.0 573.0 598.0 -152.3 -183.3 -220.6 -265.4 -319.4
EBITDA, % 24.93 -110.21 6.53 22.91 22.16 -4.69 -4.69 -4.69 -4.69 -4.69
Depreciation 2,452.0 1,416.0 1,527.0 2,218.0 287.0 2,503.3 3,012.2 3,624.6 4,361.5 5,248.2
Depreciation, % 86.22 166.2 112.11 88.68 10.64 77.11 77.11 77.11 77.11 77.11
EBIT -1,743.0 -2,355.0 -1,438.0 -1,645.0 311.0 -2,048.8 -2,465.3 -2,966.5 -3,569.6 -4,295.3
EBIT, % -61.29 -276.41 -105.58 -65.77 11.53 -63.11 -63.11 -63.11 -63.11 -63.11
Total Cash 346.0 951.0 688.0 906.0 717.0 1,464.1 1,761.7 2,119.9 2,550.8 3,069.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 180.0 26.0 96.0 129.0 112.0
Account Receivables, % 6.33 3.05 7.05 5.16 4.15
Inventories 764.0 1,076.0 969.0 .0 701.0 1,454.4 1,750.1 2,105.8 2,534.0 3,049.1
Inventories, % 26.86 126.29 71.15 0 25.98 44.8 44.8 44.8 44.8 44.8
Accounts Payable 217.0 147.0 156.0 220.0 210.0 343.6 413.4 497.5 598.6 720.4
Accounts Payable, % 7.63 17.25 11.45 8.8 7.78 10.58 10.58 10.58 10.58 10.58
Capital Expenditure -240.0 -86.0 -54.0 -168.0 -285.0 -258.3 -310.8 -374.0 -450.0 -541.5
Capital Expenditure, % -8.44 -10.09 -3.96 -6.72 -10.56 -7.96 -7.96 -7.96 -7.96 -7.96
Tax Rate, % 32.64 32.64 32.64 32.64 32.64 32.64 32.64 32.64 32.64 32.64
EBITAT -1,519.5 -2,345.3 -1,444.4 -1,540.4 209.5 -1,834.7 -2,207.8 -2,656.6 -3,196.7 -3,846.6
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -34.5 -1,243.3 74.6 1,509.6 -482.5 -264.6 233.9 281.4 338.7 407.5
WACC, % 8.44 8.83 8.84 8.64 7.81 8.51 8.51 8.51 8.51 8.51
PV UFCF
SUM PV UFCF 690.2
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) 424
Terminal Value 9,392
Present Terminal Value 6,242
Enterprise Value 6,933
Net Debt 3,996
Equity Value 2,937
Diluted Shares Outstanding, MM 215
Equity Value Per Share 13.66

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real Park Hotels & Resorts Inc. (PK) financials.
  • Real-World Data: Historical data and forward-looking estimates (as indicated in the highlighted cells).
  • Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Instantly observe how your inputs affect Park Hotels & Resorts Inc. (PK)’s valuation.
  • Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step guidance.

Key Features

  • Comprehensive Data: Park Hotels & Resorts Inc.'s historical financial statements and pre-filled projections.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Real-Time Insights: View Park Hotels & Resorts Inc.'s intrinsic value recalculating instantly.
  • Intuitive Visuals: Dashboard graphs illustrate valuation outcomes and essential metrics.
  • Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.

How It Works

  1. Step 1: Download the Excel file for Park Hotels & Resorts Inc. (PK).
  2. Step 2: Review the pre-filled financial data and forecasts for Park Hotels & Resorts Inc. (PK).
  3. Step 3: Adjust key inputs such as occupancy rates, average daily rates, and operating expenses (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you modify your assumptions.
  5. Step 5: Evaluate the outputs and leverage the results for your investment strategies.

Why Choose This Calculator for Park Hotels & Resorts Inc. (PK)?

  • All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for the hospitality sector.
  • Flexible Inputs: Modify the highlighted cells to explore different investment scenarios.
  • In-Depth Analysis: Automatically computes Park Hotels & Resorts Inc.'s intrinsic value and Net Present Value.
  • Preloaded Information: Historical and projected data provide a solid foundation for analysis.
  • Expert-Level Tool: Perfect for financial analysts, investors, and hospitality consultants.

Who Should Use This Product?

  • Hospitality Students: Explore industry-specific financial models and apply them to real-world scenarios.
  • Researchers: Utilize advanced valuation techniques in your studies related to the hospitality sector.
  • Investors: Evaluate your investment strategies and assess the performance of Park Hotels & Resorts Inc. (PK).
  • Financial Analysts: Enhance your analysis with a tailored, user-friendly DCF model for hotel valuations.
  • Entrepreneurs: Understand the financial metrics and valuation methods used for major hotel chains like Park Hotels & Resorts Inc. (PK).

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Park Hotels & Resorts Inc. (PK) 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 Park Hotels & Resorts Inc. (PK).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.