Wynn Resorts Financial Model
Travel Company Financials Example (Free Excel Download)
Wynn Resorts, Limited is a developer and operator of high-end luxury integrated resorts featuring casino gaming, premium accommodation, and extensive food, beverage, and entertainment amenities.
professionals from Deloitte
Used by professionals from






About this model
This model provides a comprehensive equity valuation and credit analysis framework to evaluate Wynn Resorts' cash flow generation, assess its highly leveraged siloed capital structure, and forecast the earnings impact of its upcoming Wynn Al Marjan Island development in the UAE.
Wynn Resorts, Limited is a developer and operator of high-end luxury integrated resorts featuring casino gaming, premium accommodation, and extensive food, beverage, and entertainment amenities. The company operates primarily in two of the world's largest gaming markets: Macau and Las Vegas, catering heavily to premium mass and VIP customers.
Business segments by approximate 2025 revenue contribution:
- Las Vegas Operations (Wynn Las Vegas and Encore): 38%
- Wynn Palace (Cotai Strip, Macau): 33%
- Wynn Macau (Macau Peninsula): 20%
- Encore Boston Harbor (Massachusetts): 9%
The business model is highly asset-heavy, requiring massive upfront capital expenditure to build luxury integrated resorts, followed by high operating leverage where incremental gaming and room revenues drop straight to the bottom line. Wynn's competitive position is anchored by its luxury brand positioning, consistently commanding the highest Average Daily Rates (ADR) in Las Vegas and maintaining a strong premium mass market share in Macau. Recent major events include the ongoing construction of Wynn Al Marjan Island in the UAE (a 40% equity joint venture expected to open in Q1 2027) and a post-pandemic normalisation of Macau operations throughout 2024 and 2025.
The downloadable Wynn Resorts financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsWynn Resorts financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $3.76B | $3.76B | $6.53B | $7.13B | $7.14B |
| Total operating expenses | $4.16B | $3.86B | $5.69B | $6.00B | $6.02B |
| Operating income | -$394.5M | -$100.7M | $840.2M | $1.13B | $1.12B |
| Net income | -$755.8M | -$423.9M | $730.0M | $501.1M | $327.3M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Wynn Resorts
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Wynn Resorts reports revenue across four main product lines within each of its geographic segments.
Casino Revenue
- Driver formula: (Table Games Drop x Table Games Win %) + (Slot Machine Handle x Slot Machine Win %)
- Historical growth rate: Highly volatile due to Macau's regulatory changes and pandemic recovery; stabilising at 3-5% CAGR post-2024.
- Key levers and headwinds: VIP turnover is structurally lower following Macau's junket crackdown, shifting the focus to the higher-margin premium mass segment. Table hold percentages create significant quarter-to-quarter earnings volatility.
- Pricing dynamics: Minimum bets dictate volume; win percentage is mathematically fixed over the long term but fluctuates wildly in the short term (e.g., Las Vegas table win ranges from 22% to 26%).
- Revenue recognition: Recognised daily based on net win (gaming drop minus payouts).
- Seasonality: Las Vegas peaks during major events (Formula 1, Super Bowl, major conventions in Q1 and Q4); Macau peaks around Chinese New Year (Q1) and Golden Week (Q4).
Rooms Revenue
- Driver formula: Available Rooms x Occupancy % x Average Daily Rate (ADR)
- Historical growth rate: 4-6% CAGR driven by aggressive ADR pricing power in Las Vegas.
- Key levers and headwinds: Convention calendar strength, room renovation downtime (which temporarily removes inventory), and macroeconomic impacts on leisure travel.
- Pricing dynamics: Yield-managed daily; highly dynamic spot pricing.
- Revenue recognition: Recognised over the duration of the guest's stay.
Food and Beverage (F&B) Revenue
- Driver formula: Number of Covers x Average Check
- Historical growth rate: 5-7% CAGR, tracking closely with room occupancy and inflation.
- Key levers and headwinds: Nightlife and dayclub performance in Las Vegas are massive drivers of high-margin F&B revenue.
- Pricing dynamics: Premium pricing power due to captive audience and luxury positioning.
Entertainment, Retail and Other
- Driver formula: Leased Retail Square Footage x Rent per Sq Ft + Show Ticket Volumes x Average Ticket Price
- Historical growth rate: 2-4% CAGR.
- Key levers and headwinds: Luxury retail sales in Macau and Las Vegas; tenant turnover.
Cost Structure
Variable Costs / COGS
- Casino Expenses: Includes gaming taxes (heavily weighted to Macau where the effective tax rate is approximately 39% of gross gaming revenue), casino payroll, and complimentary items (comps) provided to premium players.
- Rooms, F&B, and Entertainment Expenses: Direct labour, cost of food and beverage, laundry, and operating supplies.
- Gross margin range: Wynn does not report a traditional gross margin. Instead, it focuses on departmental margins. Casino margins in Macau are structurally lower (around 15-20%) due to high gaming taxes, whereas Las Vegas casino margins are higher. Room margins typically run at 65-70%.
Operating Expenses
- General and Administrative (G&A): Includes corporate overhead, property-level management, marketing, and utilities. Highly fixed, creating significant operating leverage.
- Provision for Credit Losses: Specific to casino receivables (markers issued to high-rollers). Typically 1-2% of casino revenues but can spike if VIP collections deteriorate.
- Pre-opening Expenses: Costs incurred for new developments (currently elevated due to UAE project preparations).
- Depreciation & Amortisation: Massive expense due to the asset-heavy nature of integrated resorts. Typically runs at 10-12% of total revenue.
Margin Profile
- Adjusted Property EBITDAR Margin: The primary profitability metric for gaming companies. Consolidated margins range from 30% to 33%.
- Segment Margins (2025 actuals): Las Vegas runs at approximately 35%, Macau operations at 28%, and Boston at 27%.
- Margin trend: Stable to slightly compressing in Macau due to the shift away from VIP towards mass, offset by record ADR-driven margin expansion in Las Vegas.
Balance Sheet Structure
- Total assets: Approximately $14 billion.
- Key asset categories: Property, Plant and Equipment (PP&E) dominates the balance sheet, representing the physical resort assets. Cash and cash equivalents are also held at high levels for liquidity.
- Goodwill & intangibles: Minimal relative to total assets, as Wynn builds organically rather than acquiring.
- Working capital profile:
- Days Sales Outstanding (DSO): 10-15 days (mostly casino receivables from premium players).
- Days Payable Outstanding (DPO): 30-40 days.
- Net working capital: Structurally negative. Customers pay cash upfront or via credit card for rooms and F&B, while suppliers are paid on 30-day terms. This negative working capital is a source of cash.
- PP&E: Buildings, land, and leasehold improvements. Useful lives range from 10 to 40 years for buildings.
- Right-of-use assets: Material due to land concessions in Macau and ground leases.
Capital Expenditure & Investment
- Capex as % of revenue: 4-6% for maintenance; spikes significantly during development cycles.
- Maintenance vs. growth capex: Maintenance capex runs at approximately $250-300 million annually for room refreshes and slot machine replacements.
- Major capex programmes: The Wynn Al Marjan Island project in the UAE. Wynn holds a 40% equity interest. By the end of 2025, Wynn had contributed $914.2 million in cash to this joint venture.
- M&A pattern: Organic developer. Wynn rarely acquires existing properties, preferring to design and build bespoke luxury resorts.
Debt & Capital Structure
- Total debt: $10.55 billion as of December 31, 2025.
- Debt/EBITDAR ratio: Approximately 4.7x (based on 2025 EBITDAR of $2.22 billion).
- Key debt instruments: The debt is strictly siloed. It comprises $5.79 billion of Macau-related debt, $3.28 billion of Wynn Resorts Finance (WRF) debt, $876.6 million of Wynn Las Vegas debt, and $598.4 million of retail joint venture debt.
- Maturity profile: Staggered, with constant refinancing activity required to manage the massive principal balances.
- Interest rate profile: A mix of fixed-rate senior notes and floating-rate credit facilities.
- Covenants: Maintenance covenants on revolving credit facilities, primarily tied to maximum leverage ratios and minimum interest coverage within each specific borrowing silo.
- Dividend policy: Reinstated post-pandemic. Currently paying $0.25 per share quarterly ($1.00 annualised), representing a yield of approximately 1-2% depending on share price.
Cash Flow Characteristics
- Operating cash flow conversion: Strong. OCF regularly exceeds Net Income due to massive non-cash D&A charges.
- Free cash flow margin: 10-15% during non-development years, but currently depressed due to heavy equity contributions to the UAE joint venture.
- Major non-cash items: Depreciation, amortisation of land concessions in Macau, and stock-based compensation.
- Working capital cash flow impact: Generally a source of cash as revenues grow, due to the negative working capital dynamic.
- Capex intensity: Extremely high. The luxury standard requires constant reinvestment in room product and casino floor technology.
Sheet Structure
- Assumptions: Hardcoded drivers for macroeconomic inputs, segment-level casino hold percentages, ADRs, occupancy, and corporate tax rates.
- Summary Dashboard: Consolidated outputs, target valuation, and key credit metrics (Debt/EBITDAR, Interest Coverage).
- Revenue Build - Las Vegas: Granular build of Casino, Rooms, F&B, and Entertainment revenues.
- Revenue Build - Macau (Palace & Peninsula): Granular build separating VIP turnover and Mass market drop, plus non-gaming revenues.
- Revenue Build - Boston: Regional casino revenue build.
- Operating Costs & EBITDAR: Departmental expenses, G&A, and calculation of Adjusted Property EBITDAR by segment.
- Income Statement: Consolidated GAAP income statement from Net Revenues down to Net Income Attributable to Wynn Resorts.
- Balance Sheet: Assets, Liabilities, and Equity. Must include specific lines for Casino Receivables and Outstanding Chips/Tokens.
- Cash Flow Statement: Indirect method starting from Net Income, adjusting for D&A, working capital changes, and breaking out UAE joint venture equity contributions in investing cash flows.
- Debt Schedule: Siloed debt tranches (Macau, WRF, Las Vegas) with respective interest rates and mandatory amortisation.
- DCF Valuation: Unlevered free cash flow build, WACC calculation, and terminal value based on EV/EBITDAR multiples.
Key Financial Relationships
- `Las Vegas Casino Revenue = (Table Games Drop * Table Win %) + (Slot Handle * Slot Win %)`
- `Macau Casino Revenue = (VIP Turnover * VIP Win %) + (Mass Market Drop * Mass Win %) + (Slot Handle * Slot Win %)`
- `Rooms Revenue (Per Property) = Available Rooms * Occupancy % * ADR`
- `F&B Revenue (Per Property) = Total Rooms Occupied * F&B Spend Per Occupied Room`
- `Departmental Expenses = Segment Revenue * Historical Departmental Expense Margin`
- `Adjusted Property EBITDAR = Total Operating Revenues - Departmental Expenses - G&A - Provision for Credit Losses`
- `Consolidated EBITDA = Sum of Segment Adjusted Property EBITDAR - Corporate Expenses`
- `Interest Expense = (Average Macau Debt * Macau Interest Rate) + (Average US Debt * US Interest Rate)`
- `UAE JV Investment Balance = Prior Period Balance + Current Period Equity Contributions + (Share of JV Net Income/Loss)`
- `Net Working Capital = (Receivables + Inventories) - (Accounts Payable + Customer Deposits + Outstanding Chips)`
Cross-Sheet Dependencies
- The Revenue Build sheets feed directly into the Operating Costs & EBITDAR sheet to calculate property-level margins.
- The Operating Costs & EBITDAR sheet feeds the top half of the Income Statement.
- The Debt Schedule calculates interest expense, which feeds the Income Statement. This creates a circular reference if excess cash is used to pay down revolving credit facilities, as interest expense impacts net income, which impacts cash generated, which impacts the debt balance.
- The Cash Flow Statement pulls Net Income from the Income Statement, D&A from the Operating Costs sheet, and Capex/JV contributions from the Assumptions sheet.
- The ending cash balance from the Cash Flow Statement feeds the Balance Sheet.
Sign Convention
- Income Statement: Revenues are positive. All expenses (COGS, SG&A, Interest, Taxes) are negative. Net Income is the sum of these items.
- Balance Sheet: Assets are positive. Liabilities and Equity are positive. Total Assets must equal Total Liabilities plus Equity.
- Cash Flow Statement: Cash inflows (e.g., Net Income, depreciation add-back, increase in payables) are positive. Cash outflows (e.g., capex, debt repayment, dividends, increase in receivables) are negative.
Things Most Likely to Go Wrong
- Siloed Debt Miscalculation: Wynn cannot freely move cash from Macau to the US to pay US debt without declaring dividends from the Macau subsidiary (which incurs withholding taxes). Modelling debt as a single consolidated pool will overstate liquidity.
- Table Hold Volatility: Assuming a flat table win percentage ignores reality. Las Vegas table hold fluctuates between 22% and 26%. A 200 basis point swing in hold percentage drops straight to EBITDAR, causing massive earnings misses or beats.
- UAE Joint Venture Accounting: Wynn Al Marjan Island is a 40% equity method investment. Its future revenues will not be consolidated into Wynn's top line. The model must capture the cash outflows as equity contributions and eventually capture the 40% share of net income below the operating line.
- Gaming Tax Underestimation: Macau gaming taxes are exceptionally high (~39% of gross gaming revenue). Applying a blended corporate tax rate to Macau casino revenues will drastically overstate profitability.
- Outstanding Chips Liability: The balance sheet must account for outstanding chips and tokens as a liability. If casino drop increases, this liability usually increases, providing a small working capital benefit.
- Macau Land Concessions: Macau properties operate on land concessions that expire and must be renewed. Amortisation of these concessions is a real non-cash expense that must be modelled separately from standard building depreciation.
- Pre-opening Expenses: These are excluded from Adjusted Property EBITDAR but hit GAAP Net Income. Failing to forecast these during the UAE build-up will overstate Net Income.
- Minority Interest: Wynn Macau, Limited is publicly traded in Hong Kong. Wynn Resorts owns approximately 72%. The model must deduct net income attributable to non-controlling interests to arrive at Net Income Attributable to Wynn Resorts.
Validation Checks
- "Consolidated Adjusted Property EBITDAR margin should be in the 30-33% range; flag if outside this band."
- "Las Vegas table games win percentage must be constrained between 22% and 26% based on historical statistical norms."
- "Macau VIP win percentage should be modelled between 3.1% and 3.4% per company guidance."
- "Total Debt / Adjusted Property EBITDAR should remain between 4.0x and 5.5x; flag if leverage exceeds 6.0x."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every forecasted period."
- "Dividend payout must not exceed Free Cash Flow to Equity after mandatory debt amortisation and UAE equity contributions."
- "Macau gaming taxes must equal approximately 39% of Macau Gross Gaming Revenue."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Las Vegas Table Games Win % | 24.0 | % | Midpoint of management's expected normal range (22-26%). |
| Macau VIP Table Games Win % | 3.25 | % | Midpoint of management's expected normal range (3.1-3.4%). |
| Macau Mass Table Games Win % | 21.0 | % | Aligns with recent historical actuals (17-22% range in 2024/2025). |
| Las Vegas ADR Growth | 2.0 | % | Conservative growth following record pricing power in 2024/2025. |
| Las Vegas Occupancy | 86.5 | % | Consistent with historical Las Vegas Strip averages. |
| Consolidated EBITDAR Margin | 31.1 | % | Based on FY2025 actuals ($2.22B EBITDAR on $7.14B Revenue). |
| Maintenance Capex | 300 | $ Millions | Historical run-rate for property upkeep and slot replacement. |
| UAE JV Equity Contributions | 250 | $ Millions/Yr | Estimated annual cash outflow to fund the 40% stake through 2027 opening. |
| Total Debt Balance (Starting) | 10,550 | $ Millions | Actual reported total debt as of December 31, 2025. |
| Blended Interest Rate | 6.5 | % | Estimated weighted average cost of debt across US and Macau silos. |
| Effective Tax Rate (US) | 21.0 | % | US statutory corporate tax rate. |
| Macau Gaming Tax Rate | 39.0 | % | Statutory requirement in Macau on gross gaming revenue. |
| Annual Dividend Per Share | 1.00 | $ | Based on declared $0.25 quarterly dividend in Q1 2026. |
| Share Count (Diluted) | 106.4 | Millions | Actual outstanding shares as of early 2026. |
| WACC | 9.5 | % | Reflects high leverage and Macau geopolitical risk premium. |
| Terminal EV/EBITDAR Multiple | 9.0 | x | Historical average trading multiple for premium gaming operators. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (10-K, 10-Q, 8-K) and Wynn Resorts Investor Relations website for quarterly earnings presentations.
- Industry Data: Nevada Gaming Control Board (monthly gaming revenue reports for the Las Vegas Strip), Macau Gaming Inspection and Coordination Bureau (DICJ) for monthly Macau gross gaming revenue.
- Key Peers: Las Vegas Sands (LVS), MGM Resorts International (MGM), Melco Resorts & Entertainment (MLCO).
- Macro Data: Las Vegas Convention and Visitors Authority (LVCVA) for visitor volume and city-wide occupancy trends.
Sources
Do more with the Wynn Resorts model
Frequently asked
What does Wynn Resorts do?+
Wynn Resorts, Limited develops and operates high-end luxury integrated resorts featuring casino gaming, premium accommodation, and extensive food, beverage, and entertainment amenities. The company operates primarily in major gaming markets such as Macau and Las Vegas, catering heavily to premium mass and VIP customers.
How does Wynn Resorts generate its revenue?+
Wynn Resorts generates revenue across four main product lines within its geographic segments, with casino revenue being a primary driver based on table games drop and slot machine handle. Rooms revenue is also significant, determined by available rooms, occupancy percentage, and Average Daily Rate (ADR).
What are the key capital expenditure assumptions for Wynn Resorts in a financial model?+
Capital expenditure for Wynn Resorts is typically assumed to be 4-6% of revenue for maintenance, but it spikes significantly during new development cycles. A major growth capex program is the Wynn Al Marjan Island project in the UAE, where Wynn holds a 40% equity interest.
What are the main balance sheet components for a Wynn Resorts valuation?+
Property, Plant and Equipment (PP&E) dominates Wynn Resorts' balance sheet, representing the physical resort assets. Cash and cash equivalents are also held at high levels for liquidity, and right-of-use assets are material due to land concessions and ground leases.
Can I download a financial model for Wynn Resorts?+
Yes, a comprehensive Excel financial model for Wynn Resorts is available for download. This model provides an equity valuation and credit analysis framework to evaluate cash flow generation and assess its capital structure.
What is Wynn Resorts' competitive advantage in the luxury resort market?+
Wynn Resorts' competitive position is anchored by its luxury brand positioning, consistently commanding the highest Average Daily Rates (ADR) in Las Vegas. The company also maintains a strong premium mass market share in Macau, catering to high-end clientele.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Travel Company Financial Models
Browse another company in the same sector.

Airbnb
Airbnb operates a global two-sided marketplace that connects hosts offering accommodations and experiences with guests seeking unique travel stays.

Booking Holdings
Booking Holdings is the world's leading provider of online travel and related services, connecting consumers with travel service providers for accommodation, flights, and rental cars.

Carnival
Carnival Corporation & plc is the world's largest leisure travel and cruise company, operating a portfolio of global brands including Carnival Cruise Line, Princess Cruises, Holland America Line, Seabourn, Costa Cruises, AIDA Cruises, Cunard, and P&O Cruises.

Expedia Group
Expedia Group is a leading global online travel agency (OTA) that provides travel products and services to leisure and corporate travellers.

Hilton Worldwide
Hilton Worldwide Holdings Inc.

Las Vegas Sands
Las Vegas Sands (LVS) is a leading global developer and operator of integrated resorts, featuring premium accommodations, world-class gaming, retail malls, conventions, and entertainment.

Marriott International
Marriott International is the world's largest hotel company, operating, franchising, and licensing over 9,300 properties and 1.7 million rooms across more than 30 brands globally.

MGM Resorts
MGM Resorts International is a global gaming and entertainment company operating integrated casino, hotel, and entertainment resorts.
Explore more Consumer financial model templates.



