Park Hotels & Resorts Inc. (PK) 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
Park Hotels & Resorts Inc. (PK) Bundle
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 | 167.1 | 201.1 | 242.0 | 291.2 | 350.4 |
Account Receivables, % | 6.33 | 3.05 | 7.05 | 5.16 | 4.15 | 5.15 | 5.15 | 5.15 | 5.15 | 5.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
- Step 1: Download the Excel file for Park Hotels & Resorts Inc. (PK).
- Step 2: Review the pre-filled financial data and forecasts for Park Hotels & Resorts Inc. (PK).
- Step 3: Adjust key inputs such as occupancy rates, average daily rates, and operating expenses (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- 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.