|
Marriott International, Inc. (MAR) DCF Valoración
US | Consumer Cyclical | Travel Lodging | NASDAQ
|
- ✓ 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
Marriott International, Inc. (MAR) Bundle
¡Simplifique la valoración de Marriott International, Inc. (MAR) con esta calculadora DCF personalizable! Con Real Marriott International, Inc. (MAR) financieras y aportes de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Marriott International, Inc. (MAR) en minutos.
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 | 20,972.0 | 10,571.0 | 13,857.0 | 20,773.0 | 23,713.0 | 26,413.5 | 29,421.5 | 32,772.2 | 36,504.3 | 40,661.6 |
| Revenue Growth, % | 0 | -49.59 | 31.09 | 49.91 | 14.15 | 11.39 | 11.39 | 11.39 | 11.39 | 11.39 |
| EBITDA | 2,396.0 | 457.0 | 1,895.0 | 3,722.0 | 4,220.0 | 3,441.0 | 3,832.9 | 4,269.4 | 4,755.6 | 5,297.1 |
| EBITDA, % | 11.42 | 4.32 | 13.68 | 17.92 | 17.8 | 13.03 | 13.03 | 13.03 | 13.03 | 13.03 |
| Depreciation | 18,913.0 | 10,111.0 | 12,037.0 | 17,216.0 | 277.0 | 18,845.6 | 20,991.8 | 23,382.4 | 26,045.2 | 29,011.3 |
| Depreciation, % | 90.18 | 95.65 | 86.87 | 82.88 | 1.17 | 71.35 | 71.35 | 71.35 | 71.35 | 71.35 |
| EBIT | -16,517.0 | -9,654.0 | -10,142.0 | -13,494.0 | 3,943.0 | -15,404.6 | -17,158.9 | -19,113.0 | -21,289.7 | -23,714.2 |
| EBIT, % | -78.76 | -91.33 | -73.19 | -64.96 | 16.63 | -58.32 | -58.32 | -58.32 | -58.32 | -58.32 |
| Total Cash | 225.0 | 877.0 | 1,393.0 | 507.0 | 338.0 | 1,230.2 | 1,370.3 | 1,526.4 | 1,700.2 | 1,893.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2,395.0 | 1,768.0 | 1,982.0 | 2,571.0 | 2,712.0 | 3,500.4 | 3,899.0 | 4,343.1 | 4,837.7 | 5,388.6 |
| Account Receivables, % | 11.42 | 16.73 | 14.3 | 12.38 | 11.44 | 13.25 | 13.25 | 13.25 | 13.25 | 13.25 |
| Inventories | 3,244.0 | 2,984.0 | 3,770.0 | .0 | .0 | 3,745.6 | 4,172.1 | 4,647.3 | 5,176.5 | 5,766.0 |
| Inventories, % | 15.47 | 28.23 | 27.21 | 0 | 0 | 14.18 | 14.18 | 14.18 | 14.18 | 14.18 |
| Accounts Payable | 720.0 | 527.0 | 726.0 | 746.0 | 738.0 | 1,075.6 | 1,198.1 | 1,334.6 | 1,486.5 | 1,655.8 |
| Accounts Payable, % | 3.43 | 4.99 | 5.24 | 3.59 | 3.11 | 4.07 | 4.07 | 4.07 | 4.07 | 4.07 |
| Capital Expenditure | -653.0 | -135.0 | -183.0 | -332.0 | -452.0 | -486.8 | -542.3 | -604.0 | -672.8 | -749.5 |
| Capital Expenditure, % | -3.11 | -1.28 | -1.32 | -1.6 | -1.91 | -1.84 | -1.84 | -1.84 | -1.84 | -1.84 |
| Tax Rate, % | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 |
| EBITAT | -13,149.6 | -5,531.4 | -9,445.8 | -10,218.0 | 3,598.7 | -12,232.3 | -13,625.3 | -15,177.0 | -16,905.4 | -18,830.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 191.4 | 5,138.6 | 1,607.2 | 9,867.0 | 3,274.7 | 1,930.1 | 6,121.5 | 6,818.6 | 7,595.1 | 8,460.1 |
| WACC, % | 10.85 | 10.72 | 10.92 | 10.82 | 10.91 | 10.85 | 10.85 | 10.85 | 10.85 | 10.85 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 21,816.9 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 8,714 | |||||||||
| Terminal Value | 111,071 | |||||||||
| Present Terminal Value | 66,376 | |||||||||
| Enterprise Value | 88,193 | |||||||||
| Net Debt | 12,422 | |||||||||
| Equity Value | 75,771 | |||||||||
| Diluted Shares Outstanding, MM | 303 | |||||||||
| Equity Value Per Share | 250.15 |
What You Will Get
- Real Marriott Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Marriott’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Marriott International, Inc. (MAR).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with customizable parameters.
- Adjustable Forecast Assumptions: Alter growth rates, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Marriott International, Inc. (MAR).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Marriott data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Marriott’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator?
- Accuracy: Utilizes real Marriott financials to ensure precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the complexity of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Hotel Investors: Develop comprehensive and accurate valuation models for assessing hotel portfolios.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the hospitality sector.
- Consultants and Advisors: Offer clients precise valuation insights for Marriott International, Inc. (MAR) stock.
- Students and Educators: Utilize real-world data to enhance learning and teaching in financial modeling.
- Travel Industry Enthusiasts: Gain insights into how hospitality companies like Marriott are valued in the marketplace.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Marriott International, Inc. (MAR).
- Real-World Data: Marriott’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into Marriott's performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to the hospitality industry.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for decision-making.