Live Nation Entertainment, Inc. (LYV) 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
Live Nation Entertainment, Inc. (LYV) Bundle
Looking to determine the intrinsic value of Live Nation Entertainment, Inc.? Our (LYV) DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment strategies.
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 | 11,548.0 | 1,861.2 | 6,268.4 | 16,681.3 | 22,749.1 | 31,421.7 | 43,400.6 | 59,946.2 | 82,799.5 | 114,365.2 |
| Revenue Growth, % | 0 | -83.88 | 236.8 | 166.11 | 36.38 | 38.12 | 38.12 | 38.12 | 38.12 | 38.12 |
| EBITDA | 866.9 | -1,120.4 | 45.3 | 1,207.7 | 1,845.3 | -2,301.2 | -3,178.6 | -4,390.3 | -6,064.0 | -8,375.8 |
| EBITDA, % | 7.51 | -60.2 | 0.72318 | 7.24 | 8.11 | -7.32 | -7.32 | -7.32 | -7.32 | -7.32 |
| Depreciation | 524.3 | 509.4 | 490.7 | 529.0 | 516.8 | 2,839.3 | 3,921.7 | 5,416.8 | 7,481.9 | 10,334.2 |
| Depreciation, % | 4.54 | 27.37 | 7.83 | 3.17 | 2.27 | 9.04 | 9.04 | 9.04 | 9.04 | 9.04 |
| EBIT | 342.6 | -1,629.8 | -445.4 | 678.7 | 1,328.5 | -5,140.5 | -7,100.3 | -9,807.1 | -13,545.9 | -18,710.0 |
| EBIT, % | 2.97 | -87.57 | -7.1 | 4.07 | 5.84 | -16.36 | -16.36 | -16.36 | -16.36 | -16.36 |
| Total Cash | 2,470.4 | 2,537.8 | 4,884.7 | 5,606.5 | 6,231.9 | 16,359.5 | 22,596.2 | 31,210.5 | 43,108.9 | 59,543.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,029.4 | 486.7 | 1,066.6 | 1,465.4 | 2,112.9 | 4,408.7 | 6,089.4 | 8,410.9 | 11,617.4 | 16,046.3 |
| Account Receivables, % | 8.91 | 26.15 | 17.01 | 8.78 | 9.29 | 14.03 | 14.03 | 14.03 | 14.03 | 14.03 |
| Inventories | 16.1 | 22.0 | 33.8 | 38.7 | 45.1 | 144.0 | 198.9 | 274.8 | 379.5 | 524.2 |
| Inventories, % | 0.13947 | 1.18 | 0.53962 | 0.23215 | 0.19843 | 0.45834 | 0.45834 | 0.45834 | 0.45834 | 0.45834 |
| Accounts Payable | 100.2 | 86.4 | 110.6 | 180.1 | 267.5 | 598.8 | 827.0 | 1,142.3 | 1,577.8 | 2,179.3 |
| Accounts Payable, % | 0.86801 | 4.64 | 1.76 | 1.08 | 1.18 | 1.91 | 1.91 | 1.91 | 1.91 | 1.91 |
| Capital Expenditure | -365.8 | -222.6 | -159.8 | -353.3 | -475.3 | -1,375.3 | -1,899.7 | -2,623.9 | -3,624.2 | -5,005.8 |
| Capital Expenditure, % | -3.17 | -11.96 | -2.55 | -2.12 | -2.09 | -4.38 | -4.38 | -4.38 | -4.38 | -4.38 |
| Tax Rate, % | 37.03 | 37.03 | 37.03 | 37.03 | 37.03 | 37.03 | 37.03 | 37.03 | 37.03 | 37.03 |
| EBITAT | 218.8 | -1,604.5 | -443.5 | 549.5 | 836.5 | -4,172.3 | -5,763.0 | -7,960.0 | -10,994.6 | -15,186.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -568.0 | -794.8 | -680.1 | 390.9 | 311.5 | -4,771.8 | -5,248.3 | -7,249.1 | -10,012.6 | -13,829.8 |
| WACC, % | 9.03 | 9.37 | 9.38 | 9.2 | 9.02 | 9.2 | 9.2 | 9.2 | 9.2 | 9.2 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -30,287.0 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | -14,314 | |||||||||
| Terminal Value | -251,182 | |||||||||
| Present Terminal Value | -161,772 | |||||||||
| Enterprise Value | -192,059 | |||||||||
| Net Debt | 2,206 | |||||||||
| Equity Value | -194,265 | |||||||||
| Diluted Shares Outstanding, MM | 231 | |||||||||
| Equity Value Per Share | -841.06 |
What You Will Get
- Real LYV Financial Data: Pre-filled with Live Nation Entertainment’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Live Nation Entertainment’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Ticketing Data: Access detailed historical performance metrics and future sales projections for Live Nation Entertainment, Inc. (LYV).
- Adjustable Revenue Assumptions: Modify highlighted cells for ticket prices, event attendance, and sponsorship revenue.
- Real-Time Analytics: Instant updates to revenue forecasts, profit margins, and event profitability analysis.
- User-Friendly Interface: Intuitive charts and summaries to help visualize your financial insights for Live Nation Entertainment, Inc. (LYV).
- Designed for All Users: A straightforward layout tailored for investors, event organizers, and financial analysts.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Live Nation Entertainment data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Live Nation Entertainment’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator?
- User-Friendly Interface: Perfectly suited for both novice and seasoned users.
- Customizable Inputs: Adjust parameters easily to tailor your financial analysis.
- Real-Time Valuation: Watch Live Nation Entertainment's valuation update instantly as you modify inputs.
- Preloaded Data: Comes with Live Nation's actual financial metrics for immediate assessment.
- Preferred by Experts: Utilized by investors and analysts for informed decision-making.
Who Should Use This Product?
- Event Organizers: Create comprehensive analysis for ticket sales and event profitability.
- Corporate Finance Teams: Evaluate financial scenarios to inform strategic planning within the live entertainment sector.
- Consultants and Advisors: Deliver precise valuation insights for Live Nation Entertainment, Inc. (LYV) to clients.
- Students and Educators: Utilize real-time data for hands-on learning in financial modeling and event management.
- Music and Entertainment Fans: Gain insights into how companies like Live Nation are valued in the entertainment industry.
What the Template Contains
- Pre-Filled Data: Contains Live Nation Entertainment’s historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Evaluate Live Nation’s profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing key valuation results.