Hilton Grand Vacations Inc. (HGV) 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
Hilton Grand Vacations Inc. (HGV) Bundle
Evaluate Hilton Grand Vacations Inc. (HGV) financial outlook like an expert! This (HGV) DCF Calculator provides you with pre-populated financial data and the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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,838.0 | 894.0 | 2,335.0 | 3,835.0 | 3,978.0 | 5,137.7 | 6,635.4 | 8,569.8 | 11,068.0 | 14,294.6 |
| Revenue Growth, % | 0 | -51.36 | 161.19 | 64.24 | 3.73 | 29.15 | 29.15 | 29.15 | 29.15 | 29.15 |
| EBITDA | 367.0 | -192.0 | 624.0 | 954.0 | 840.0 | 731.7 | 945.0 | 1,220.5 | 1,576.2 | 2,035.8 |
| EBITDA, % | 19.97 | -21.48 | 26.72 | 24.88 | 21.12 | 14.24 | 14.24 | 14.24 | 14.24 | 14.24 |
| Depreciation | 51.0 | 45.0 | 126.0 | 244.0 | 213.0 | 256.1 | 330.7 | 427.1 | 551.7 | 712.5 |
| Depreciation, % | 2.77 | 5.03 | 5.4 | 6.36 | 5.35 | 4.98 | 4.98 | 4.98 | 4.98 | 4.98 |
| EBIT | 316.0 | -237.0 | 498.0 | 710.0 | 627.0 | 475.6 | 614.2 | 793.3 | 1,024.6 | 1,323.3 |
| EBIT, % | 17.19 | -26.51 | 21.33 | 18.51 | 15.76 | 9.26 | 9.26 | 9.26 | 9.26 | 9.26 |
| Total Cash | 67.0 | 428.0 | 432.0 | 223.0 | 589.0 | 931.4 | 1,202.9 | 1,553.6 | 2,006.5 | 2,591.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,330.0 | 56.0 | 200.0 | 329.0 | 2,620.0 | 1,660.8 | 2,145.0 | 2,770.3 | 3,577.9 | 4,620.9 |
| Account Receivables, % | 72.36 | 6.26 | 8.57 | 8.58 | 65.86 | 32.33 | 32.33 | 32.33 | 32.33 | 32.33 |
| Inventories | 558.0 | 702.0 | 1,240.0 | 1,159.0 | 1,400.0 | 2,336.6 | 3,017.8 | 3,897.6 | 5,033.8 | 6,501.3 |
| Inventories, % | 30.36 | 78.52 | 53.1 | 30.22 | 35.19 | 45.48 | 45.48 | 45.48 | 45.48 | 45.48 |
| Accounts Payable | 24.0 | 20.0 | 63.0 | 83.0 | 144.0 | 123.6 | 159.6 | 206.1 | 266.2 | 343.8 |
| Accounts Payable, % | 1.31 | 2.24 | 2.7 | 2.16 | 3.62 | 2.41 | 2.41 | 2.41 | 2.41 | 2.41 |
| Capital Expenditure | -63.0 | -31.0 | -39.0 | -97.0 | -75.0 | -133.4 | -172.3 | -222.5 | -287.3 | -371.1 |
| Capital Expenditure, % | -3.43 | -3.47 | -1.67 | -2.53 | -1.89 | -2.6 | -2.6 | -2.6 | -2.6 | -2.6 |
| Tax Rate, % | 30.29 | 30.29 | 30.29 | 30.29 | 30.29 | 30.29 | 30.29 | 30.29 | 30.29 | 30.29 |
| EBITAT | 250.0 | -170.1 | 325.8 | 519.6 | 437.1 | 341.7 | 441.3 | 570.0 | 736.1 | 950.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,626.0 | 969.9 | -226.2 | 638.6 | -1,895.9 | 466.5 | -529.5 | -683.9 | -883.3 | -1,140.8 |
| WACC, % | 8.21 | 8.04 | 7.9 | 8.07 | 7.99 | 8.04 | 8.04 | 8.04 | 8.04 | 8.04 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,987.3 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | -1,175 | |||||||||
| Terminal Value | -23,303 | |||||||||
| Present Terminal Value | -15,828 | |||||||||
| Enterprise Value | -17,816 | |||||||||
| Net Debt | 4,004 | |||||||||
| Equity Value | -21,820 | |||||||||
| Diluted Shares Outstanding, MM | 112 | |||||||||
| Equity Value Per Share | -195.52 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real HGV financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Hilton Grand Vacations' 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 instructions.
Key Features
- Comprehensive Data: Hilton Grand Vacations Inc.’s (HGV) historical financial statements and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Insights: Watch Hilton’s (HGV) intrinsic value update instantly as you modify inputs.
- Intuitive Visuals: Dashboard graphs illustrate valuation outcomes and essential metrics clearly.
- Designed for Precision: A specialized tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Hilton Grand Vacations Inc. (HGV) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Hilton Grand Vacations Inc. (HGV)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Hilton Grand Vacations Inc. (HGV)?
- Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses all in one convenient package.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes the intrinsic value and Net Present Value for Hilton Grand Vacations Inc. (HGV).
- Preloaded Data: Access to historical and forecasted data for reliable starting points.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focused on Hilton Grand Vacations Inc. (HGV).
Who Should Use This Product?
- Individual Vacationers: Make informed decisions about purchasing or investing in Hilton Grand Vacations (HGV) offerings.
- Travel Advisors: Enhance client recommendations with comprehensive insights into HGV's vacation options.
- Real Estate Investors: Analyze the vacation ownership market and leverage HGV's data for investment strategies.
- Hospitality Professionals: Gain a deeper understanding of the vacation ownership industry through HGV's business model.
- Tourism Students: Explore the dynamics of vacation ownership and hospitality management with real-world case studies from HGV.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring in-depth valuation calculations.
- Real-World Data: Hilton Grand Vacations Inc. (HGV)’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis covering profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.