Liberty Global plc (LBTYK) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Liberty Global plc (LBTYK) Bundle
Designed for accuracy, our (LBTYK) DCF Calculator allows you to evaluate Liberty Global plc's valuation using real-world financial data, offering complete flexibility to modify all essential parameters for improved 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 | 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.36 | 5.77 | 6.2 | 5.48 | 6.36 | 6.04 | 6.04 | 6.04 | 6.04 | 6.04 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,007.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 649 | |||||||||
| Terminal Value | 16,080 | |||||||||
| Present Terminal Value | 11,996 | |||||||||
| Enterprise Value | 15,003 | |||||||||
| Net Debt | 16,002 | |||||||||
| Equity Value | -999 | |||||||||
| Diluted Shares Outstanding, MM | 426 | |||||||||
| Equity Value Per Share | -2.35 |
What You Will Receive
- Authentic LBTYK Financial Data: Pre-filled with Liberty Global’s historical and forecasted data for accurate analysis.
- Completely Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Witness Liberty Global’s intrinsic value refresh immediately based on your modifications.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Design: Straightforward layout and clear guidance suitable for all skill levels.
Key Features
- 🔍 Real-Life LBTYK Financials: Pre-filled historical and projected data for Liberty Global plc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Liberty Global’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Liberty Global’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Get instant access to the Excel-based LBTYK DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates Liberty Global's intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator for Liberty Global plc (LBTYK)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for Liberty Global plc.
- Flexible Inputs: Modify the highlighted cells to explore different investment scenarios.
- In-Depth Analysis: Automatically determines Liberty Global’s intrinsic value and Net Present Value.
- Data-Rich Environment: Utilizes historical and projected data for precise calculations.
- High-Caliber Tool: Perfect for financial analysts, investors, and business advisors focused on Liberty Global plc.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing Liberty Global plc (LBTYK) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding Liberty Global plc (LBTYK) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Telecom Industry Analysts: Gain insights into how telecom companies like Liberty Global plc (LBTYK) are valued in the market.
What the Template Contains
- Pre-Filled Data: Includes Liberty Global plc’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Liberty Global plc’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.