Red Rock Resorts, Inc. (RRR) DCF Valuation

Red Rock Resorts, Inc. (RRR) DCF Valuation
  • Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • Pré-Construídos Para Uso Rápido E Eficiente
  • Não É Necessária Experiência; Fácil De Seguir

Red Rock Resorts, Inc. (RRR) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Enhance your investment strategies with the Red Rock Resorts, Inc. (RRR) DCF Calculator! Explore authentic financial data, adjust growth predictions and expenses, and instantly observe how these modifications affect the intrinsic value of Red Rock Resorts, Inc. (RRR).


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,856.5 1,182.4 1,617.9 1,663.8 1,724.1 1,754.2 1,784.8 1,815.9 1,847.6 1,879.8
Revenue Growth, % 0 -36.31 36.83 2.84 3.62 1.74 1.74 1.74 1.74 1.74
EBITDA 489.9 300.8 718.3 722.0 694.3 631.1 642.1 653.3 664.7 676.3
EBITDA, % 26.39 25.44 44.4 43.4 40.27 35.98 35.98 35.98 35.98 35.98
Depreciation 222.2 231.4 157.8 128.4 132.5 198.9 202.4 205.9 209.5 213.1
Depreciation, % 11.97 19.57 9.75 7.72 7.69 11.34 11.34 11.34 11.34 11.34
EBIT 267.7 69.4 560.5 593.7 561.8 432.2 439.8 447.4 455.2 463.2
EBIT, % 14.42 5.87 34.65 35.68 32.58 24.64 24.64 24.64 24.64 24.64
Total Cash 128.8 121.2 275.3 117.3 137.6 172.7 175.7 178.8 181.9 185.1
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 56.7 35.1 36.7 43.6 76.4
Account Receivables, % 3.05 2.97 2.27 2.62 4.43
Inventories 17.8 13.1 11.7 13.2 15.3 15.7 15.9 16.2 16.5 16.8
Inventories, % 0.95689 1.11 0.72526 0.79331 0.88482 0.89328 0.89328 0.89328 0.89328 0.89328
Accounts Payable 34.0 11.2 17.5 11.4 25.4 21.1 21.5 21.8 22.2 22.6
Accounts Payable, % 1.83 0.94787 1.08 0.68404 1.47 1.2 1.2 1.2 1.2 1.2
Capital Expenditure -410.6 -58.5 -65.9 -561.3 -701.6 -370.4 -376.9 -383.4 -390.1 -396.9
Capital Expenditure, % -22.12 -4.95 -4.08 -33.74 -40.7 -21.12 -21.12 -21.12 -21.12 -21.12
Tax Rate, % 53.78 53.78 53.78 53.78 53.78 53.78 53.78 53.78 53.78 53.78
EBITAT 212.9 200.4 696.5 532.9 259.7 359.2 365.5 371.8 378.3 384.9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -16.0 376.7 794.4 85.5 -330.2 205.6 190.1 193.4 196.8 200.3
WACC, % 10.1 10.56 10.56 10.33 9.36 10.18 10.18 10.18 10.18 10.18
PV UFCF
SUM PV UFCF 744.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 204
Terminal Value 2,496
Present Terminal Value 1,537
Enterprise Value 2,282
Net Debt 3,196
Equity Value -914
Diluted Shares Outstanding, MM 103
Equity Value Per Share -8.86

What You Will Get

  • Pre-Filled Financial Model: Red Rock Resorts, Inc. (RRR) data facilitates accurate DCF valuation.
  • Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential variables.
  • Instant Calculations: Real-time updates ensure you see outcomes as you make adjustments.
  • Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
  • Customizable and Reusable: Designed for adaptability, allowing for repeated use in comprehensive forecasts.

Key Features

  • Comprehensive Financial Data: Red Rock Resorts, Inc. (RRR) offers extensive historical financial statements and pre-filled projections.
  • Customizable Variables: Modify WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
  • Real-Time Valuation: Instantly view Red Rock Resorts, Inc. (RRR) intrinsic value updates as you adjust inputs.
  • Intuitive Visualizations: User-friendly dashboard charts showcase valuation outcomes and essential metrics.
  • Designed for Precision: A reliable resource tailored for analysts, investors, and finance professionals.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Red Rock Resorts, Inc. (RRR) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Red Rock Resorts, Inc. (RRR)’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for Red Rock Resorts, Inc. (RRR)?

  • User-Friendly Interface: Tailored for both novices and seasoned professionals.
  • Customizable Inputs: Easily adjust parameters to suit your financial analysis.
  • Real-Time Feedback: Observe immediate changes to Red Rock Resorts’ valuation as you modify inputs.
  • Instant Access: Comes preloaded with Red Rock Resorts’ latest financial data for swift evaluations.
  • Industry Approved: Favored by investors and analysts for making well-informed choices.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling Red Rock Resorts, Inc. (RRR) stock.
  • Financial Analysts: Streamline valuation processes with ready-to-use financial models for Red Rock Resorts, Inc. (RRR).
  • Consultants: Deliver professional valuation insights on Red Rock Resorts, Inc. (RRR) to clients quickly and accurately.
  • Business Owners: Understand how companies like Red Rock Resorts, Inc. (RRR) are valued to guide your own strategy.
  • Finance Students: Learn valuation techniques using real-world data and scenarios related to Red Rock Resorts, Inc. (RRR).

What the Template Contains

  • Pre-Filled DCF Model: Red Rock Resorts, Inc. (RRR)’s financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate Red Rock Resorts, Inc. (RRR)’s profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.