|
Manchester United Plc (Manu) DCF Valoración
GB | Communication Services | Entertainment | NYSE
|
- ✓ 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
Manchester United plc (MANU) Bundle
¡Simplifique la valoración de Manchester United PLC (Manu) con esta calculadora DCF personalizable! Con el Real Manchester United PLC (Manu) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Manchester United PLC (MANU) en minutos.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 639.2 | 620.4 | 732.3 | 814.2 | 830.9 | 889.8 | 952.8 | 1,020.3 | 1,092.6 | 1,170.0 |
| Revenue Growth, % | 0 | -2.93 | 18.03 | 11.18 | 2.06 | 7.08 | 7.08 | 7.08 | 7.08 | 7.08 |
| EBITDA | 179.4 | 119.7 | 101.2 | 198.3 | 161.7 | 186.8 | 200.1 | 214.2 | 229.4 | 245.7 |
| EBITDA, % | 28.06 | 19.29 | 13.83 | 24.35 | 19.45 | 21 | 21 | 21 | 21 | 21 |
| Depreciation | 177.7 | 175.0 | 208.2 | 234.2 | 259.5 | 257.0 | 275.2 | 294.7 | 315.6 | 338.0 |
| Depreciation, % | 27.8 | 28.2 | 28.43 | 28.77 | 31.23 | 28.88 | 28.88 | 28.88 | 28.88 | 28.88 |
| EBIT | 1.7 | -55.3 | -106.9 | -36.0 | -97.8 | -70.2 | -75.2 | -80.5 | -86.2 | -92.3 |
| EBIT, % | 0.26403 | -8.92 | -14.6 | -4.42 | -11.77 | -7.89 | -7.89 | -7.89 | -7.89 | -7.89 |
| Total Cash | 64.7 | 138.9 | 152.2 | 95.5 | 92.4 | 135.5 | 145.1 | 155.4 | 166.4 | 178.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 203.4 | 114.2 | 107.3 | 112.7 | 99.8 | 161.5 | 172.9 | 185.1 | 198.3 | 212.3 |
| Account Receivables, % | 31.81 | 18.4 | 14.65 | 13.84 | 12.02 | 18.14 | 18.14 | 18.14 | 18.14 | 18.14 |
| Inventories | 2.7 | 2.6 | 2.8 | 4.0 | 4.4 | 4.0 | 4.3 | 4.6 | 4.9 | 5.3 |
| Inventories, % | 0.42943 | 0.42095 | 0.37723 | 0.48812 | 0.53539 | 0.45023 | 0.45023 | 0.45023 | 0.45023 | 0.45023 |
| Accounts Payable | 133.0 | 96.2 | 115.0 | 178.4 | 207.8 | 176.0 | 188.5 | 201.9 | 216.2 | 231.5 |
| Accounts Payable, % | 20.81 | 15.51 | 15.7 | 21.91 | 25 | 19.79 | 19.79 | 19.79 | 19.79 | 19.79 |
| Capital Expenditure | -303.7 | -181.4 | -155.4 | -215.7 | -261.5 | -277.5 | -297.1 | -318.2 | -340.7 | -364.9 |
| Capital Expenditure, % | -47.51 | -29.23 | -21.22 | -26.49 | -31.47 | -31.18 | -31.18 | -31.18 | -31.18 | -31.18 |
| Tax Rate, % | 13.44 | 13.44 | 13.44 | 13.44 | 13.44 | 13.44 | 13.44 | 13.44 | 13.44 | 13.44 |
| EBITAT | 1.9 | -212.3 | -82.5 | -31.7 | -84.7 | -63.4 | -67.9 | -72.7 | -77.9 | -83.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -197.2 | -166.1 | -4.3 | 43.7 | -44.9 | -176.8 | -89.1 | -95.4 | -102.1 | -109.4 |
| WACC, % | 8.02 | 8.02 | 7.59 | 7.79 | 7.76 | 7.83 | 7.83 | 7.83 | 7.83 | 7.83 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -467.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -112 | |||||||||
| Terminal Value | -1,912 | |||||||||
| Present Terminal Value | -1,312 | |||||||||
| Enterprise Value | -1,779 | |||||||||
| Net Debt | 605 | |||||||||
| Equity Value | -2,384 | |||||||||
| Diluted Shares Outstanding, MM | 166 | |||||||||
| Equity Value Per Share | -14.37 |
What You Will Get
- Real MANU Financial Data: Pre-filled with Manchester United’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 Manchester United’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
- Real-Life MANU Data: Pre-filled with Manchester United’s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Manchester United's pre-filled financial data and forecasts.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify assumptions.
- Step 5: Analyze the outputs and leverage the results for investment decisions regarding Manchester United plc (MANU).
Why Choose This Calculator?
- Accurate Data: Real Manchester United plc (MANU) financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to match your projections.
- Time-Saving: Pre-built calculations eliminate the need to start from scratch.
- Professional-Grade Tool: Designed for investors, analysts, and consultants.
- User-Friendly: Intuitive layout and step-by-step instructions make it easy for all users.
Who Should Use This Product?
- Investors: Make informed decisions with a comprehensive analysis tool for Manchester United plc (MANU).
- Financial Analysts: Streamline your workflow with a customizable financial model tailored for Manchester United plc (MANU).
- Consultants: Effortlessly modify the template for impactful client presentations or reports on Manchester United plc (MANU).
- Sports Finance Enthusiasts: Enhance your knowledge of sports valuation techniques through real-world applications with Manchester United plc (MANU).
- Educators and Students: Utilize it as a hands-on learning resource in finance and sports management courses focusing on Manchester United plc (MANU).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Manchester United 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 Manchester United plc (MANU).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.