|
IHeartMedia, Inc. (IHRT) Valoración de DCF
US | Communication Services | Broadcasting | NASDAQ
|
- ✓ 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
iHeartMedia, Inc. (IHRT) Bundle
¡Agilice su análisis y aumente la precisión con nuestra calculadora DCF IHeartMedia, Inc. (IHRT)! Utilizando datos reales de iHeartMedia y supuestos personalizables, esta herramienta le permite pronosticar, analizar y evaluar iHeartMedia como un inversor experimentado.
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 | 3,683.5 | 2,948.2 | 3,558.3 | 3,912.3 | 3,751.0 | 3,812.5 | 3,875.0 | 3,938.5 | 4,003.1 | 4,068.7 |
Revenue Growth, % | 0 | -19.96 | 20.69 | 9.95 | -4.12 | 1.64 | 1.64 | 1.64 | 1.64 | 1.64 |
EBITDA | 904.9 | 411.0 | 708.8 | 837.3 | 601.7 | 731.0 | 743.0 | 755.2 | 767.6 | 780.2 |
EBITDA, % | 24.57 | 13.94 | 19.92 | 21.4 | 16.04 | 19.17 | 19.17 | 19.17 | 19.17 | 19.17 |
Depreciation | 302.5 | 402.9 | 469.4 | 445.7 | 428.5 | 441.4 | 448.6 | 456.0 | 463.4 | 471.0 |
Depreciation, % | 8.21 | 13.67 | 13.19 | 11.39 | 11.42 | 11.58 | 11.58 | 11.58 | 11.58 | 11.58 |
EBIT | 602.5 | 8.1 | 239.4 | 391.7 | 173.3 | 289.7 | 294.4 | 299.2 | 304.2 | 309.1 |
EBIT, % | 16.36 | 0.27522 | 6.73 | 10.01 | 4.62 | 7.6 | 7.6 | 7.6 | 7.6 | 7.6 |
Total Cash | 400.3 | 720.7 | 352.1 | 336.2 | 346.4 | 480.6 | 488.5 | 496.5 | 504.7 | 512.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 928.7 | 813.8 | 1,030.4 | 1,037.8 | 1,041.2 | 1,037.5 | 1,054.5 | 1,071.8 | 1,089.3 | 1,107.2 |
Account Receivables, % | 25.21 | 27.6 | 28.96 | 26.53 | 27.76 | 27.21 | 27.21 | 27.21 | 27.21 | 27.21 |
Inventories | .5 | 1.2 | 3.2 | 79.1 | .0 | 16.5 | 16.8 | 17.0 | 17.3 | 17.6 |
Inventories, % | 0.01376398 | 0.03910837 | 0.08863684 | 2.02 | 0 | 0.43277 | 0.43277 | 0.43277 | 0.43277 | 0.43277 |
Accounts Payable | 87.4 | 149.3 | 206.0 | 240.5 | 236.2 | 195.7 | 198.9 | 202.2 | 205.5 | 208.9 |
Accounts Payable, % | 2.37 | 5.07 | 5.79 | 6.15 | 6.3 | 5.13 | 5.13 | 5.13 | 5.13 | 5.13 |
Capital Expenditure | -112.2 | -85.2 | -183.4 | -161.0 | -102.7 | -136.8 | -139.0 | -141.3 | -143.6 | -146.0 |
Capital Expenditure, % | -3.05 | -2.89 | -5.15 | -4.11 | -2.74 | -3.59 | -3.59 | -3.59 | -3.59 | -3.59 |
Tax Rate, % | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 |
EBITAT | 591.1 | 7.4 | 252.8 | 398.8 | 164.3 | 280.5 | 285.1 | 289.8 | 294.5 | 299.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -60.4 | 501.3 | 377.0 | 634.6 | 561.6 | 531.9 | 580.6 | 590.1 | 599.8 | 609.6 |
WACC, % | 6.6 | 6.17 | 6.71 | 6.71 | 6.39 | 6.52 | 6.52 | 6.52 | 6.52 | 6.52 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,409.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 622 | |||||||||
Terminal Value | 13,763 | |||||||||
Present Terminal Value | 10,037 | |||||||||
Enterprise Value | 12,447 | |||||||||
Net Debt | 5,705 | |||||||||
Equity Value | 6,742 | |||||||||
Diluted Shares Outstanding, MM | 149 | |||||||||
Equity Value Per Share | 45.17 |
What You Will Get
- Real IHRT Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess iHeartMedia’s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Data: iHeartMedia’s historical financial reports and pre-populated projections.
- Customizable Variables: Modify WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
- Real-Time Insights: Observe iHeartMedia’s intrinsic value recalibrating instantly.
- Intuitive Visualizations: Dashboard charts illustrate valuation outcomes and essential metrics.
- Engineered for Precision: A professional-grade tool tailored for analysts, investors, and finance specialists.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review iHeartMedia's pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions regarding iHeartMedia, Inc. (IHRT).
Why Choose This Calculator for iHeartMedia, Inc. (IHRT)?
- Accurate Data: Access to real iHeartMedia financials guarantees dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the media industry.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use iHeartMedia, Inc. (IHRT)?
- Media Students: Explore advertising strategies and audience analytics using real-world data.
- Researchers: Integrate industry-specific models into your studies or publications.
- Advertisers: Evaluate your marketing assumptions and measure campaign effectiveness for iHeartMedia.
- Market Analysts: Enhance your analysis with a tailored, ready-to-use media valuation model.
- Entrepreneurs: Understand how major media companies like iHeartMedia are assessed in the market.
What the Template Contains
- Preloaded IHRT Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.