Liberty Global plc (LBTYB) 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
Liberty Global plc (LBTYB) Bundle
Looking to assess the intrinsic value of Liberty Global plc? Our (LBTYB) DCF Calculator integrates real-world data with comprehensive customization features, allowing you to refine your forecasts and make more informed investment choices.
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 | 894.3 | 755.6 | 687.2 | 624.9 | 568.3 | 516.8 |
| Account Receivables, % | 12.34 | 9.23 | 9.41 | 12.54 | 11.94 | 11.09 | 11.09 | 11.09 | 11.09 | 11.09 |
| 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,576.4 | 616.8 | 845.8 | 769.1 | 699.5 | 636.1 |
| WACC, % | 6.35 | 5.76 | 6.19 | 5.46 | 6.35 | 6.02 | 6.02 | 6.02 | 6.02 | 6.02 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,008.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 649 | |||||||||
| Terminal Value | 16,127 | |||||||||
| Present Terminal Value | 12,038 | |||||||||
| Enterprise Value | 15,046 | |||||||||
| Net Debt | 16,002 | |||||||||
| Equity Value | -956 | |||||||||
| Diluted Shares Outstanding, MM | 426 | |||||||||
| Equity Value Per Share | -2.25 |
What You Will Get
- Real LBTYB Financial Data: Pre-filled with Liberty Global'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 Liberty Global'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
- Accurate Financial Data: Gain access to reliable pre-loaded historical figures and future estimates for Liberty Global plc (LBTYB).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Utilize clear charts and summaries to effectively visualize your valuation findings.
- Designed for All Skill Levels: A straightforward, intuitive layout catering to investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based LBTYB DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Liberty Global's intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator?
- Accurate Data: Real Liberty Global plc (LBTYB) 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: Accurately estimate Liberty Global plc’s fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis.
- Consultants: Quickly adapt the template for valuation reports for clients.
- Entrepreneurs: Gain insights into financial modeling used by leading telecommunications companies.
- Educators: Use it as a teaching tool to demonstrate valuation methodologies.
What the Template Contains
- Preloaded LBTYB 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.