Entravision Communications Corporation (EVC) 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
Entravision Communications Corporation (EVC) Bundle
Designed for accuracy, our (EVC) DCF Calculator enables you to evaluate Entravision Communications Corporation's valuation using real-world financial data, offering complete flexibility to modify all essential 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 | 273.6 | 344.0 | 760.2 | 956.2 | 1,106.9 | 1,073.3 | 1,040.7 | 1,009.1 | 978.4 | 948.7 |
| Revenue Growth, % | 0 | 25.75 | 120.97 | 25.79 | 15.76 | -3.04 | -3.04 | -3.04 | -3.04 | -3.04 |
| EBITDA | 19.5 | 26.2 | 83.8 | 68.8 | 26.9 | 76.0 | 73.7 | 71.4 | 69.3 | 67.2 |
| EBITDA, % | 7.13 | 7.61 | 11.03 | 7.19 | 2.43 | 7.08 | 7.08 | 7.08 | 7.08 | 7.08 |
| Depreciation | 17.2 | 17.8 | 22.9 | 26.2 | 28.0 | 42.3 | 41.0 | 39.8 | 38.6 | 37.4 |
| Depreciation, % | 6.27 | 5.17 | 3.01 | 2.74 | 2.53 | 3.94 | 3.94 | 3.94 | 3.94 | 3.94 |
| EBIT | 2.4 | 8.4 | 60.9 | 42.6 | -1.1 | 33.6 | 32.6 | 31.6 | 30.7 | 29.7 |
| EBIT, % | 0.86375 | 2.44 | 8.01 | 4.46 | -0.09757279 | 3.13 | 3.13 | 3.13 | 3.13 | 3.13 |
| Total Cash | 124.8 | 147.2 | 185.1 | 155.2 | 118.9 | 299.9 | 290.8 | 282.0 | 273.4 | 265.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 71.4 | 142.0 | 201.7 | 224.7 | 235.8 | 297.8 | 288.7 | 280.0 | 271.5 | 263.2 |
| Account Receivables, % | 26.1 | 41.28 | 26.54 | 23.5 | 21.31 | 27.74 | 27.74 | 27.74 | 27.74 | 27.74 |
| Inventories | .0 | -2.5 | .0 | .8 | .0 | -1.4 | -1.3 | -1.3 | -1.2 | -1.2 |
| Inventories, % | 0.000000366 | -0.71622 | 0 | 0.07874847 | 0 | -0.1275 | -0.1275 | -0.1275 | -0.1275 | -0.1275 |
| Accounts Payable | 11.5 | 49.7 | 58.8 | 75.2 | 108.2 | 94.5 | 91.6 | 88.8 | 86.2 | 83.5 |
| Accounts Payable, % | 4.2 | 14.45 | 7.73 | 7.86 | 9.78 | 8.8 | 8.8 | 8.8 | 8.8 | 8.8 |
| Capital Expenditure | -27.6 | -9.2 | -5.8 | -11.5 | -27.3 | -36.9 | -35.8 | -34.7 | -33.6 | -32.6 |
| Capital Expenditure, % | -10.08 | -2.68 | -0.76546 | -1.2 | -2.47 | -3.44 | -3.44 | -3.44 | -3.44 | -3.44 |
| Tax Rate, % | 15.97 | 15.97 | 15.97 | 15.97 | 15.97 | 15.97 | 15.97 | 15.97 | 15.97 | 15.97 |
| EBITAT | 4.1 | -97.7 | 33.1 | 24.3 | -.9 | 19.9 | 19.3 | 18.7 | 18.1 | 17.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -66.3 | -119.1 | -2.9 | 31.7 | 22.4 | -49.0 | 30.7 | 29.7 | 28.8 | 28.0 |
| WACC, % | 7.7 | 4.01 | 6.02 | 6.12 | 7.11 | 6.19 | 6.19 | 6.19 | 6.19 | 6.19 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 49.3 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 29 | |||||||||
| Terminal Value | 1,075 | |||||||||
| Present Terminal Value | 796 | |||||||||
| Enterprise Value | 845 | |||||||||
| Net Debt | 157 | |||||||||
| Equity Value | 689 | |||||||||
| Diluted Shares Outstanding, MM | 88 | |||||||||
| Equity Value Per Share | 7.84 |
What You Will Get
- Real EVC Financial Data: Pre-filled with Entravision’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 Entravision’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 Financial Data: Entravision’s historical financial statements and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Witness Entravision’s intrinsic value update instantly.
- Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file containing Entravision Communications Corporation’s (EVC) preloaded data.
- 2. Adjust Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures to reflect your analysis.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate different forecasts to assess various valuation outcomes for Entravision Communications Corporation (EVC).
- 5. Present with Assurance: Deliver professional valuation insights to bolster your decision-making process.
Why Choose the Entravision Communications Corporation (EVC) Calculator?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for EVC.
- Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Entravision’s intrinsic value and Net Present Value.
- Preloaded Information: Access to historical and projected data for reliable starting points.
- Professional Standard: Perfect for financial analysts, investors, and business advisors focusing on EVC.
Who Should Use This Product?
- Media Investors: Develop comprehensive and accurate valuation models for Entravision Communications Corporation (EVC) analysis.
- Corporate Strategy Teams: Evaluate valuation scenarios to inform business decisions and strategies.
- Financial Consultants: Deliver precise valuation insights for clients interested in Entravision Communications Corporation (EVC).
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Media Industry Analysts: Gain insights into how media companies like Entravision Communications Corporation (EVC) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: Entravision Communications Corporation’s (EVC) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital tailored for (EVC).
- Financial Ratios: Assess Entravision’s (EVC) profitability, leverage, and operational efficiency.
- Editable Inputs: Modify assumptions such as growth rates, margins, and CAPEX to suit your analysis.
- Financial Statements: Annual and quarterly reports to facilitate comprehensive evaluation.
- Interactive Dashboard: Effortlessly visualize key valuation metrics and outcomes for (EVC).