PENN Entertainment, Inc. (PENN) DCF Valuation

PENN Entertainment, Inc. (PENN) 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

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

Designed for accuracy, our (PENN) DCF Calculator empowers you to assess PENN Entertainment, Inc. valuation using real-world financial data and offers complete flexibility to modify all essential parameters for improved 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 5,301.4 3,578.7 5,905.0 6,401.7 6,362.9 7,004.2 7,710.1 8,487.2 9,342.6 10,284.2
Revenue Growth, % 0 -32.5 65 8.41 -0.60609 10.08 10.08 10.08 10.08 10.08
EBITDA 1,035.9 196.9 1,446.4 1,629.6 400.2 1,138.6 1,253.4 1,379.7 1,518.8 1,671.8
EBITDA, % 19.54 5.5 24.49 25.46 6.29 16.26 16.26 16.26 16.26 16.26
Depreciation 514.6 487.0 505.3 655.0 435.1 685.6 754.7 830.8 914.5 1,006.7
Depreciation, % 9.71 13.61 8.56 10.23 6.84 9.79 9.79 9.79 9.79 9.79
EBIT 521.3 -290.1 941.1 974.6 -34.9 453.0 498.7 548.9 604.3 665.2
EBIT, % 9.83 -8.11 15.94 15.22 -0.54849 6.47 6.47 6.47 6.47 6.47
Total Cash 437.4 1,853.8 1,863.9 1,624.0 1,071.8 1,874.7 2,063.7 2,271.7 2,500.6 2,752.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 88.7 96.4 195.0 246.4 319.0
Account Receivables, % 1.67 2.69 3.3 3.85 5.01
Inventories 76.7 103.5 132.3 106.1 .0 115.4 127.0 139.8 153.9 169.4
Inventories, % 1.45 2.89 2.24 1.66 0 1.65 1.65 1.65 1.65 1.65
Accounts Payable 40.3 33.2 53.3 40.1 36.6 53.1 58.5 64.4 70.9 78.0
Accounts Payable, % 0.76018 0.92771 0.90262 0.6264 0.57521 0.75842 0.75842 0.75842 0.75842 0.75842
Capital Expenditure -202.3 -141.8 -268.3 -272.4 -360.0 -311.5 -342.9 -377.4 -415.5 -457.3
Capital Expenditure, % -3.82 -3.96 -4.54 -4.26 -5.66 -4.45 -4.45 -4.45 -4.45 -4.45
Tax Rate, % 1.92 1.92 1.92 1.92 1.92 1.92 1.92 1.92 1.92 1.92
EBITAT 265.8 -232.7 734.6 1,234.8 -34.2 369.1 406.3 447.2 492.3 541.9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 453.0 70.9 864.3 1,579.0 70.9 731.7 788.5 867.9 955.4 1,051.7
WACC, % 4.65 5.69 5.61 6.4 6.33 5.73 5.73 5.73 5.73 5.73
PV UFCF
SUM PV UFCF 3,691.9
Long Term Growth Rate, % 0.50
Free cash flow (T + 1) 1,057
Terminal Value 20,194
Present Terminal Value 15,281
Enterprise Value 18,973
Net Debt 10,470
Equity Value 8,503
Diluted Shares Outstanding, MM 152
Equity Value Per Share 55.90

What You Will Get

  • Real PENN Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on PENN Entertainment’s fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.

Key Features

  • 🔍 Real-Life PENN Financials: Pre-filled historical and projected data for PENN Entertainment, Inc. (PENN).
  • ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Built-in formulas calculate PENN’s intrinsic value using the Discounted Cash Flow method.
  • ⚡ Instant Results: Visualize PENN’s valuation instantly after making changes.
  • Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.

How It Works

  1. Download the Template: Get instant access to the Excel-based PENN DCF Calculator.
  2. Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
  3. Instant Calculations: The model automatically updates PENN Entertainment’s intrinsic value.
  4. Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
  5. Analyze and Decide: Use the results to guide your investment or financial analysis.

Why Choose PENN Entertainment, Inc. (PENN)?

  • Time Efficiency: Skip the hassle of complex models – our solutions are ready for immediate use.
  • Enhanced Precision: Access to accurate financial data and methodologies minimizes valuation errors.
  • Completely Customizable: Adapt the tools to align with your unique assumptions and forecasts.
  • User-Friendly: Intuitive visuals and outputs simplify result interpretation.
  • Endorsed by Industry Leaders: Crafted for professionals prioritizing accuracy and functionality.

Who Should Use This Product?

  • Finance Students: Master valuation methods and practice with real-time data for PENN Entertainment, Inc. (PENN).
  • Academics: Utilize industry-standard models for your teaching or research involving PENN.
  • Investors: Validate your investment strategies and evaluate the valuation metrics for PENN stock.
  • Analysts: Enhance your analysis process with a ready-to-use, adaptable DCF model tailored for PENN.
  • Small Business Owners: Discover how major public companies like PENN are evaluated in the market.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled PENN Entertainment historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for PENN Entertainment, Inc. (PENN).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.