|
Liberty Global PLC (LBTya) DCF Valoración
GB | Communication Services | Telecommunications Services | 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
Liberty Global plc (LBTYA) Bundle
¡Descubra el verdadero valor de Liberty Global PLC (LBTya) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y examine cómo los cambios afectan la valoración de Liberty Global PLC (LBTYA), todo dentro de una sola plantilla de Excel.
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,541.5 | 11,980.1 | 10,311.3 | 7,195.7 | 7,491.4 | 6,812.8 | 6,195.6 | 5,634.3 | 5,123.9 | 4,659.8 |
| Revenue Growth, % | 0 | 3.8 | -13.93 | -30.22 | 4.11 | -9.06 | -9.06 | -9.06 | -9.06 | -9.06 |
| EBITDA | 3,983.2 | 1,726.2 | 3,655.0 | 4,200.9 | -420.5 | 1,868.5 | 1,699.3 | 1,545.3 | 1,405.3 | 1,278.0 |
| EBITDA, % | 34.51 | 14.41 | 35.45 | 58.38 | -5.61 | 27.43 | 27.43 | 27.43 | 27.43 | 27.43 |
| Depreciation | 3,753.3 | 2,340.4 | 2,435.0 | 2,187.4 | 2,315.2 | 1,866.3 | 1,697.3 | 1,543.5 | 1,403.7 | 1,276.5 |
| Depreciation, % | 32.52 | 19.54 | 23.61 | 30.4 | 30.9 | 27.39 | 27.39 | 27.39 | 27.39 | 27.39 |
| EBIT | 229.9 | -614.2 | 1,220.0 | 2,013.5 | -2,735.7 | 2.2 | 2.0 | 1.8 | 1.6 | 1.5 |
| EBIT, % | 1.99 | -5.13 | 11.83 | 27.98 | -36.52 | 0.0321804 | 0.0321804 | 0.0321804 | 0.0321804 | 0.0321804 |
| Total Cash | 8,142.4 | 2,927.4 | 3,180.2 | 4,347.8 | 3,406.4 | 3,157.3 | 2,871.3 | 2,611.2 | 2,374.6 | 2,159.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,424.1 | 1,105.8 | 969.8 | 902.6 | 870.1 | 751.2 | 683.2 | 621.3 | 565.0 | 513.8 |
| Account Receivables, % | 12.34 | 9.23 | 9.41 | 12.54 | 11.61 | 11.03 | 11.03 | 11.03 | 11.03 | 11.03 |
| Inventories | 331.1 | -148.8 | 925.0 | 382.7 | .0 | 216.9 | 197.2 | 179.4 | 163.1 | 148.3 |
| Inventories, % | 2.87 | -1.24 | 8.97 | 5.32 | 0 | 3.18 | 3.18 | 3.18 | 3.18 | 3.18 |
| Accounts Payable | 963.9 | 579.1 | 613.4 | 610.1 | 689.8 | 501.7 | 456.3 | 414.9 | 377.3 | 343.2 |
| Accounts Payable, % | 8.35 | 4.83 | 5.95 | 8.48 | 9.21 | 7.36 | 7.36 | 7.36 | 7.36 | 7.36 |
| Capital Expenditure | -1,243.1 | -1,350.2 | -1,408.0 | -1,303.2 | -1,386.0 | -985.2 | -896.0 | -814.8 | -741.0 | -673.9 |
| Capital Expenditure, % | -10.77 | -11.27 | -13.65 | -18.11 | -18.5 | -14.46 | -14.46 | -14.46 | -14.46 | -14.46 |
| Tax Rate, % | -8.79 | -8.79 | -8.79 | -8.79 | -8.79 | -8.79 | -8.79 | -8.79 | -8.79 | -8.79 |
| EBITAT | 280.2 | -522.7 | 1,170.0 | 1,562.6 | -2,976.3 | 2.0 | 1.8 | 1.7 | 1.5 | 1.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,999.1 | 880.9 | 1,293.5 | 3,053.0 | -1,552.2 | 597.0 | 845.4 | 768.8 | 699.1 | 635.8 |
| WACC, % | 6.33 | 5.73 | 6.16 | 5.43 | 6.33 | 6 | 6 | 6 | 6 | 6 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,990.3 | |||||||||
| Long Term Growth Rate, % | 3.80 | |||||||||
| Free cash flow (T + 1) | 660 | |||||||||
| Terminal Value | 30,049 | |||||||||
| Present Terminal Value | 22,459 | |||||||||
| Enterprise Value | 25,449 | |||||||||
| Net Debt | 16,002 | |||||||||
| Equity Value | 9,447 | |||||||||
| Diluted Shares Outstanding, MM | 426 | |||||||||
| Equity Value Per Share | 22.19 |
What You Will Get
- Editable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Liberty Global plc’s financial data pre-filled to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Liberty Global Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Assumptions: Modify highlighted cells for WACC, growth rates, and profit margins as needed.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to effectively visualize your valuation outcomes.
- Designed for All Skill Levels: A straightforward, intuitive layout tailored for investors, CFOs, and consultants.
How It Works
- Download the Template: Gain immediate access to the Excel-based LBTYA DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh Liberty Global’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation changes.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Liberty Global plc (LBTYA)?
- Accuracy: Utilizes real Liberty Global financials for precise data.
- Flexibility: Tailored for users to experiment and adjust inputs as needed.
- Time-Saving: Eliminate the complexity of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without advanced financial modeling skills.
Who Should Use This Product?
- Finance Students: Understand the intricacies of valuation methods and apply them to real-world data.
- Academics: Utilize advanced financial models in your teaching or research related to Liberty Global plc (LBTYA).
- Investors: Validate your investment hypotheses and examine valuation results for Liberty Global plc (LBTYA).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for Liberty Global plc (LBTYA).
- Small Business Owners: Discover how major public companies like Liberty Global plc (LBTYA) are assessed and valued.
What the Template Contains
- Historical Data: Includes Liberty Global plc’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Liberty Global plc’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Liberty Global plc’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.