Wynn Resorts, Limited (WYNN) 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
Wynn Resorts, Limited (WYNN) Bundle
Explore the financial potential of Wynn Resorts, Limited (WYNN) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Wynn Resorts, Limited (WYNN) and enhance your investment approach.
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 | 6,611.1 | 2,095.9 | 3,763.7 | 3,756.8 | 6,531.9 | 7,919.3 | 9,601.5 | 11,640.9 | 14,113.6 | 17,111.4 |
| Revenue Growth, % | 0 | -68.3 | 79.58 | -0.18171 | 73.87 | 21.24 | 21.24 | 21.24 | 21.24 | 21.24 |
| EBITDA | 1,527.1 | -480.3 | 310.0 | 643.2 | 1,724.2 | 822.6 | 997.3 | 1,209.2 | 1,466.0 | 1,777.4 |
| EBITDA, % | 23.1 | -22.92 | 8.24 | 17.12 | 26.4 | 10.39 | 10.39 | 10.39 | 10.39 | 10.39 |
| Depreciation | 624.9 | 725.5 | 716.0 | 692.3 | 687.3 | 1,457.8 | 1,767.5 | 2,142.9 | 2,598.1 | 3,149.9 |
| Depreciation, % | 9.45 | 34.62 | 19.02 | 18.43 | 10.52 | 18.41 | 18.41 | 18.41 | 18.41 | 18.41 |
| EBIT | 902.2 | -1,205.8 | -406.0 | -49.2 | 1,036.9 | -635.2 | -770.1 | -933.7 | -1,132.1 | -1,372.5 |
| EBIT, % | 13.65 | -57.53 | -10.79 | -1.31 | 15.87 | -8.02 | -8.02 | -8.02 | -8.02 | -8.02 |
| Total Cash | 2,351.9 | 3,482.0 | 2,522.5 | 3,650.4 | 3,724.4 | 5,651.0 | 6,851.3 | 8,306.6 | 10,071.0 | 12,210.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 346.4 | 200.2 | 199.5 | 216.0 | 341.7 | 492.1 | 596.7 | 723.4 | 877.1 | 1,063.4 |
| Account Receivables, % | 5.24 | 9.55 | 5.3 | 5.75 | 5.23 | 6.21 | 6.21 | 6.21 | 6.21 | 6.21 |
| Inventories | 88.5 | 66.3 | 70.0 | 70.1 | 75.6 | 148.6 | 180.2 | 218.5 | 264.9 | 321.1 |
| Inventories, % | 1.34 | 3.16 | 1.86 | 1.87 | 1.16 | 1.88 | 1.88 | 1.88 | 1.88 | 1.88 |
| Accounts Payable | 262.4 | 148.5 | 170.5 | 197.5 | 208.3 | 380.6 | 461.4 | 559.5 | 678.3 | 822.4 |
| Accounts Payable, % | 3.97 | 7.08 | 4.53 | 5.26 | 3.19 | 4.81 | 4.81 | 4.81 | 4.81 | 4.81 |
| Capital Expenditure | -1,069.3 | -290.1 | -346.7 | -352.5 | -507.2 | -892.9 | -1,082.6 | -1,312.5 | -1,591.3 | -1,929.3 |
| Capital Expenditure, % | -16.17 | -13.84 | -9.21 | -9.38 | -7.76 | -11.28 | -11.28 | -11.28 | -11.28 | -11.28 |
| Tax Rate, % | -155.79 | -155.79 | -155.79 | -155.79 | -155.79 | -155.79 | -155.79 | -155.79 | -155.79 | -155.79 |
| EBITAT | 575.4 | -1,592.2 | -406.1 | -49.8 | 2,652.3 | -589.2 | -714.3 | -866.1 | -1,050.0 | -1,273.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -41.5 | -1,102.2 | -17.8 | 300.2 | 2,712.1 | -75.5 | -84.7 | -102.7 | -124.5 | -151.0 |
| WACC, % | 7.58 | 8.74 | 8.74 | 8.74 | 8.74 | 8.51 | 8.51 | 8.51 | 8.51 | 8.51 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -412.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -154 | |||||||||
| Terminal Value | -2,366 | |||||||||
| Present Terminal Value | -1,572 | |||||||||
| Enterprise Value | -1,984 | |||||||||
| Net Debt | 10,538 | |||||||||
| Equity Value | -12,522 | |||||||||
| Diluted Shares Outstanding, MM | 113 | |||||||||
| Equity Value Per Share | -110.96 |
What You Will Get
- Real WYNN Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Wynn Resorts' future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for Wynn Resorts, Limited (WYNN).
- WACC Calculator: Includes a pre-built Weighted Average Cost of Capital sheet with flexible input options.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Wynn Resorts, Limited (WYNN).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based WYNN DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Wynn Resorts' intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Wynn Resorts, Limited (WYNN)?
- User-Friendly Interface: Perfect for both novices and seasoned investors.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Feedback: Watch Wynn's valuation update instantly as you change inputs.
- Preloaded Data: Comes with Wynn's actual financial metrics for swift evaluations.
- Preferred by Experts: A go-to tool for investors and analysts seeking reliable insights.
Who Should Use Wynn Resorts, Limited (WYNN)?
- Investors: Make informed decisions with insights from a leading hospitality and gaming company.
- Financial Analysts: Leverage comprehensive data to evaluate the performance of Wynn Resorts, Limited (WYNN).
- Consultants: Tailor reports and presentations using detailed information about the luxury resort market.
- Hospitality Enthusiasts: Gain a deeper understanding of the industry dynamics through Wynn's innovative approaches.
- Educators and Students: Utilize real-world case studies from Wynn Resorts, Limited (WYNN) in hospitality and finance courses.
What the Template Contains
- Preloaded WYNN 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.