Las Vegas Sands Financial Model

• Total assets: Approximately $21 billion to $23 billion.
• Key asset categories: Property and Equipment, net (PP&E) makes up the vast majority of assets, representing the physical integrated resorts. Cash and cash equivalents are also material (typically $3.0 billion to $3.6 billion).
• Working capital profile:
• Days Sales Outstanding (DSO): 10-15 days (receivables are primarily casino credit markers).
• Days Payable Outstanding (DPO): 30-45 days.
• Net working capital: Typically negative. The company collects cash upfront from mass gaming and hotel guests while delaying payments to suppliers, providing a structural cash flow advantage.
• PP&E: Consists of land rights, buildings, and leasehold improvements. Useful lives for buildings are typically 15 to 50 years.

• Capex as % of revenue: Highly variable depending on the development cycle, typically ranging from 5% to 15%.
• Maintenance vs. growth capex: Maintenance capex runs at approximately $300 million to $400 million annually. The remainder is growth capex.
• Major capex programmes: The $1 billion-plus suite renovation programme at Marina Bay Sands and the multi-billion dollar Phase II expansion of The Londoner Macao.
• M&A pattern: LVS is an organic developer rather than an acquirer. It builds integrated resorts from the ground up or expands existing footprints.

• Total debt: Approximately $15.6 billion to $15.9 billion.
• Debt/EBITDA ratio: Target leverage is typically 3.0x to 4.0x, though it spiked during the pandemic.
• Key debt instruments: Senior unsecured notes issued by LVS and Sands China Ltd, supported by revolving credit facilities.
• Interest rate profile: Weighted average borrowing cost is approximately 4.6%, with a mix of fixed-rate bonds and floating-rate bank debt.
• Share repurchase programme: Highly active. The company repurchased $500 million of stock in Q4 2025 alone and regularly buys shares of its Sands China Ltd subsidiary to increase its ownership stake (currently around 74.8%).
• Dividend policy: The company pays a recurring quarterly dividend (recently raised to $0.30 per share in early 2026).

• Operating cash flow conversion: Very strong. OCF frequently exceeds Net Income due to massive depreciation add-backs.
• Free cash flow margin: Typically 15% to 25% during steady-state operations, though depressed during heavy construction phases.
• Major non-cash items: Depreciation and amortisation, stock-based compensation, and amortisation of deferred financing costs.
• Cash tax rate: The effective tax rate is typically 15% to 19%, benefiting from a zero percent tax rate on Macao gaming profits (which are subject to the separate 39% gross gaming tax instead of corporate income tax) and a concessionary rate in Singapore.

1. Cover: Company details, ticker, current share price, and model instructions.
2. Assumptions: All hardcoded drivers, macroeconomic inputs, and tax rates.
3. Macao_Op: Detailed build of The Venetian, The Londoner, The Parisian, The Plaza, and Sands Macao. Includes table counts, slot counts, drop, handle, and win percentages.
4. Singapore_Op: Detailed build of Marina Bay Sands. Includes VIP rolling chip, mass drop, ADR, and occupancy.
5. Consolidated_Rev: Aggregation of Macao and Singapore revenues into the five reported segments (Casino, Rooms, F&B, Mall, Convention/Other).
6. Income_Statement: GAAP income statement down to Net Income Attributable to LVS (deducting Non-Controlling Interests).
7. Balance_Sheet: Standard asset, liability, and equity line items.
8. Cash_Flow: Indirect method starting from Net Income, detailing OCF, CFI, and CFF.
9. Debt_Schedule: Tranche-by-tranche debt build, interest expense calculation, and mandatory amortisation.
10. PPE_and_Capex: Waterfall of maintenance and growth capex, driving depreciation.
11. DCF: Unlevered free cash flow calculation, WACC build, and terminal value.

1. VIP Casino Revenue = Rolling Chip Volume x Rolling Chip Win Percentage
2. Mass Casino Revenue = Non-Rolling Chip Drop x Non-Rolling Chip Win Percentage
3. Slot Revenue = Slot Handle x Slot Hold Percentage
4. Total Casino Revenue = VIP Casino Revenue + Mass Casino Revenue + Slot Revenue
5. Rooms Revenue = Total Available Rooms x Occupancy Percentage x Average Daily Rate (ADR)
6. Macao Casino Expense = Macao Casino Revenue x Macao Effective Gaming Tax Rate (approx. 39%) + Direct Departmental Costs
7. Adjusted Property EBITDA = Total Net Revenues - Departmental Expenses - Property-level SG&A
8. Consolidated Adjusted Property EBITDA = Macao Adjusted Property EBITDA + Singapore Adjusted Property EBITDA
9. Operating Income = Consolidated Adjusted Property EBITDA - Corporate Expense - Pre-opening Expense - Depreciation and Amortisation
10. Net Income Attributable to Non-Controlling Interests = Sands China Ltd Net Income x (1 - LVS Ownership Percentage)

The Assumptions sheet feeds the operating drivers in Macao_Op and Singapore_Op. These property-level sheets calculate revenue and departmental expenses, which aggregate into Consolidated_Rev. The consolidated revenues and expenses flow into the Income_Statement to calculate Operating Income. The PPE_and_Capex sheet calculates D&A, which feeds both the Income_Statement and the Cash_Flow statement. The Debt_Schedule uses cash flow available for debt service from the Cash_Flow statement to calculate ending debt balances and interest expense, creating a circular reference that must be managed with an interest toggle. Finally, the Income_Statement calculates Net Income, which flows to Retained Earnings on the Balance_Sheet and the top line of the Cash_Flow statement.

• All revenues, volumes, and pricing metrics (ADR, Drop, Handle) are entered and calculated as positive numbers.
• All expenses (COGS, SG&A, Interest, Taxes) are entered as positive numbers in their respective schedules but subtracted in the Income Statement and cash flow calculations.
• Capital expenditures are entered as positive numbers in the Capex schedule but subtracted in the Cash Flow from Investing section.
• Debt paydowns are negative in the Cash Flow from Financing section; debt issuances are positive.

• Gaming Tax Misclassification: LVS reports gaming taxes within "Casino Expenses" rather than as a separate line item below revenue. Failing to model this correctly will drastically overstate gross margins.
• Non-Controlling Interest (NCI) Omission: LVS only owns approximately 74.8% of Sands China Ltd. The model must deduct the ~25.2% of Sands China's net income that belongs to minority shareholders before arriving at Net Income Attributable to LVS.
• Hold Percentage Volatility: Applying a flat historical average to future win percentages ignores the massive quarter-to-quarter volatility inherent in VIP baccarat. The model should include a toggle for "normalised hold" versus "actual hold".
• Promotional Allowances: Retail value of complimentary rooms and food is included in gross revenue but deducted as promotional allowances. The model must track net revenue to avoid double-counting.
• Suite Conversion Impact: The ongoing renovations at MBS and The Londoner reduce total room count but increase ADR. Modelling a flat room count will result in inaccurate capacity constraints.
• Capitalised Interest: During major construction phases, a portion of interest expense is capitalised into PP&E rather than expensed on the income statement.
• Currency Translation: Macao results are generated in Patacas (MOP) and Hong Kong Dollars (HKD), while Singapore uses the Singapore Dollar (SGD). The model must account for constant-currency adjustments if projecting historical growth rates forward.
• Share Count Reduction: LVS aggressively buys back stock. Failing to project a declining share count will artificially depress future EPS calculations.

• "Macao Casino Expense should be at least 39% of Macao Casino Revenue; flag if it drops below this statutory tax floor."
• "Consolidated Adjusted Property EBITDA margin should remain between 35% and 42%; flag if outside this band."
• "Marina Bay Sands Occupancy should not exceed 100% of available room nights."
• "Net Income Attributable to NCI must equal approximately 25% of Sands China Ltd Net Income."
• "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
• "Effective income tax rate should remain between 15% and 19% due to the Macao tax exemption on gaming profits."
• "Debt/EBITDA should remain below 4.5x; flag if leverage exceeds this threshold."

• Filings: SEC EDGAR (10-K, 10-Q, 8-K) and the Las Vegas Sands Investor Relations website.
• Subsidiary Filings: Sands China Ltd (HKEX: 1928) interim and annual reports for granular Macao data.
• Key Peers: Wynn Resorts (WYNN), MGM Resorts International (MGM), Melco Resorts & Entertainment (MLCO), Galaxy Entertainment Group (HKEX: 0027).
• Industry Data: Macao Gaming Inspection and Coordination Bureau (DICJ) for monthly gross gaming revenue (GGR) data; Singapore Tourism Board for visitor arrival statistics.
• Consensus Estimates: Bloomberg or FactSet for forward-looking EBITDA and EPS estimates.

• Las Vegas Sands Corp. Form 10-K for the fiscal year ended December 31, 2024 (filed February 2025).
• Las Vegas Sands Corp. Q4 2025 Earnings Release and Presentation (January 28, 2026).
• Las Vegas Sands Corp. Q2 2025 Earnings Transcript (July 2025).
• Macao Gaming Inspection and Coordination Bureau (DICJ) historical revenue reports.