Golden Entertainment, Inc. (GDEN) DCF Valuation

Golden Entertainment, Inc. (GDEN) DCF Valuation
  • ✓ 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

Golden Entertainment, Inc. (GDEN) 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:

Engineered for accuracy, our GDEN DCF Calculator enables you to evaluate Golden Entertainment, Inc. valuation using real-world financial data and offers complete flexibility to modify all key parameters for enhanced projections.


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 973.4 694.2 1,096.5 1,121.7 1,053.1 1,120.2 1,191.5 1,267.3 1,348.0 1,433.8
Revenue Growth, % 0 -28.69 57.97 2.3 -6.11 6.37 6.37 6.37 6.37 6.37
EBITDA 149.4 57.0 331.8 249.0 486.9 273.9 291.3 309.8 329.6 350.5
EBITDA, % 15.35 8.21 30.25 22.2 46.23 24.45 24.45 24.45 24.45 24.45
Depreciation 116.6 124.4 108.4 101.1 88.9 128.2 136.4 145.1 154.3 164.1
Depreciation, % 11.98 17.93 9.88 9.01 8.44 11.45 11.45 11.45 11.45 11.45
EBIT 32.8 -67.4 223.4 147.9 398.0 145.6 154.9 164.8 175.2 186.4
EBIT, % 3.37 -9.72 20.37 13.19 37.79 13 13 13 13 13
Total Cash 111.7 103.6 220.5 136.9 157.6 165.0 175.5 186.7 198.6 211.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 16.2 13.7 18.7 20.5 17.0
Account Receivables, % 1.67 1.97 1.71 1.83 1.61
Inventories 8.2 5.6 6.6 8.1 8.1 8.4 9.0 9.5 10.1 10.8
Inventories, % 0.8462 0.81235 0.60527 0.72362 0.76884 0.75126 0.75126 0.75126 0.75126 0.75126
Accounts Payable 30.1 20.2 19.1 25.2 18.7 26.4 28.0 29.8 31.7 33.7
Accounts Payable, % 3.1 2.91 1.74 2.24 1.78 2.35 2.35 2.35 2.35 2.35
Capital Expenditure -107.3 -36.5 -29.3 -51.4 -85.9 -71.0 -75.5 -80.3 -85.4 -90.9
Capital Expenditure, % -11.02 -5.26 -2.67 -4.58 -8.15 -6.34 -6.34 -6.34 -6.34 -6.34
Tax Rate, % 22.96 22.96 22.96 22.96 22.96 22.96 22.96 22.96 22.96 22.96
EBITAT 31.3 -67.5 222.8 147.0 306.6 137.4 146.1 155.4 165.3 175.8
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 46.3 15.6 294.8 199.5 306.8 199.2 206.9 220.1 234.1 249.0
WACC, % 12.04 12.21 12.2 12.19 11.34 12 12 12 12 12
PV UFCF
SUM PV UFCF 789.6
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 256
Terminal Value 2,851
Present Terminal Value 1,618
Enterprise Value 2,407
Net Debt 601
Equity Value 1,807
Diluted Shares Outstanding, MM 31
Equity Value Per Share 58.70

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real GDEN financials.
  • Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
  • Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Instantly visualize the effects of your inputs on Golden Entertainment’s valuation.
  • Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.

Key Features

  • Real-Life GDEN Data: Pre-filled with Golden Entertainment’s historical financials and future projections.
  • Fully Customizable Inputs: Modify revenue growth, margins, WACC, tax rates, and capital expenditures to fit your analysis.
  • Dynamic Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your customized inputs.
  • Scenario Testing: Develop multiple forecast scenarios to explore various valuation results.
  • User-Friendly Design: Intuitive and structured, suitable for both professionals and newcomers.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review Golden Entertainment, Inc.'s pre-filled financial data and forecasts.
  3. Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Watch the DCF model update instantly as you tweak assumptions.
  5. Step 5: Analyze the outputs and use the results for investment decisions.

Why Choose This Calculator for Golden Entertainment, Inc. (GDEN)?

  • User-Friendly Interface: Perfectly crafted for both novice and seasoned users.
  • Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
  • Real-Time Valuation: Monitor immediate updates on Golden Entertainment's valuation as you tweak inputs.
  • Preloaded Financials: Comes equipped with Golden Entertainment’s actual financial metrics for swift evaluations.
  • Preferred by Experts: Widely utilized by investors and analysts for making well-informed choices.

Who Should Use This Product?

  • Investors: Evaluate Golden Entertainment's valuation prior to making stock transactions.
  • CFOs and Financial Analysts: Enhance valuation workflows and assess financial forecasts.
  • Startup Founders: Understand the valuation methods applied to established companies like Golden Entertainment.
  • Consultants: Create detailed valuation reports for clients in the gaming and entertainment sector.
  • Students and Educators: Utilize real-time data to practice and instruct on valuation strategies.

What the Template Contains

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

No products were found matching.