|
Liberty Latin America Ltd. (Lilak) DCF Valoración
BM | 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 Latin America Ltd. (LILAK) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (Lilak)! Equipado con datos reales de Liberty Latin America Ltd. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y evaluar (lilak) como lo haría un inversor experimentado.
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 | 3,867.0 | 3,764.6 | 4,799.0 | 4,815.1 | 4,511.1 | 4,723.7 | 4,946.3 | 5,179.4 | 5,423.5 | 5,679.1 |
| Revenue Growth, % | 0 | -2.65 | 27.48 | 0.33549 | -6.31 | 4.71 | 4.71 | 4.71 | 4.71 | 4.71 |
| EBITDA | 1,089.6 | 620.4 | 1,177.6 | 1,344.4 | 1,547.6 | 1,241.6 | 1,300.1 | 1,361.4 | 1,425.5 | 1,492.7 |
| EBITDA, % | 28.18 | 16.48 | 24.54 | 27.92 | 34.31 | 26.28 | 26.28 | 26.28 | 26.28 | 26.28 |
| Depreciation | 871.0 | 918.7 | 964.7 | 910.7 | 1,008.3 | 1,023.1 | 1,071.3 | 1,121.8 | 1,174.7 | 1,230.0 |
| Depreciation, % | 22.52 | 24.4 | 20.1 | 18.91 | 22.35 | 21.66 | 21.66 | 21.66 | 21.66 | 21.66 |
| EBIT | 218.6 | -298.3 | 212.9 | 433.7 | 539.3 | 218.5 | 228.8 | 239.6 | 250.9 | 262.7 |
| EBIT, % | 5.65 | -7.92 | 4.44 | 9.01 | 11.95 | 4.63 | 4.63 | 4.63 | 4.63 | 4.63 |
| Total Cash | 1,183.8 | 894.2 | 956.7 | 781.0 | 988.6 | 1,062.2 | 1,112.3 | 1,164.7 | 1,219.6 | 1,277.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 585.2 | 636.1 | 705.0 | 802.6 | 903.3 | 788.0 | 825.2 | 864.1 | 904.8 | 947.4 |
| Account Receivables, % | 15.13 | 16.9 | 14.69 | 16.67 | 20.02 | 16.68 | 16.68 | 16.68 | 16.68 | 16.68 |
| Inventories | 58.9 | 62.6 | 67.7 | 65.1 | .0 | 56.2 | 58.8 | 61.6 | 64.5 | 67.6 |
| Inventories, % | 1.52 | 1.66 | 1.41 | 1.35 | 0 | 1.19 | 1.19 | 1.19 | 1.19 | 1.19 |
| Accounts Payable | 346.6 | 425.3 | 398.0 | 525.1 | 424.4 | 461.7 | 483.4 | 506.2 | 530.1 | 555.0 |
| Accounts Payable, % | 8.96 | 11.3 | 8.29 | 10.91 | 9.41 | 9.77 | 9.77 | 9.77 | 9.77 | 9.77 |
| Capital Expenditure | -589.1 | -565.8 | -736.3 | -660.1 | -585.0 | -682.9 | -715.1 | -748.8 | -784.1 | -821.0 |
| Capital Expenditure, % | -15.23 | -15.03 | -15.34 | -13.71 | -12.97 | -14.46 | -14.46 | -14.46 | -14.46 | -14.46 |
| Tax Rate, % | -17.95 | -17.95 | -17.95 | -17.95 | -17.95 | -17.95 | -17.95 | -17.95 | -17.95 | -17.95 |
| EBITAT | 142.1 | -287.9 | 347.1 | 758.8 | 636.1 | 201.7 | 211.2 | 221.1 | 231.6 | 242.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 126.5 | 89.1 | 474.2 | 1,041.5 | 923.1 | 638.2 | 549.4 | 575.3 | 602.4 | 630.8 |
| WACC, % | 5.44 | 7.41 | 7.63 | 7.63 | 7.63 | 7.15 | 7.15 | 7.15 | 7.15 | 7.15 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,445.5 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 656 | |||||||||
| Terminal Value | 20,835 | |||||||||
| Present Terminal Value | 14,752 | |||||||||
| Enterprise Value | 17,197 | |||||||||
| Net Debt | 7,276 | |||||||||
| Equity Value | 9,922 | |||||||||
| Diluted Shares Outstanding, MM | 210 | |||||||||
| Equity Value Per Share | 47.25 |
What You Will Get
- Real LILAK Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Liberty Latin America's future performance.
- User-Friendly Design: Designed for professionals while remaining accessible for newcomers.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as subscriber growth, ARPU, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional metrics on demand.
- High-Precision Accuracy: Leverages Liberty Latin America's actual financial data for dependable valuation results.
- Effortless Scenario Analysis: Evaluate various assumptions and analyze results with ease.
- Efficiency Booster: Streamline the valuation process without the hassle of constructing intricate models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Liberty Latin America Ltd. (LILAK) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Liberty Latin America Ltd.'s (LILAK) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Liberty Latin America Ltd. (LILAK)?
- Accurate Data: Real Liberty Latin America 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?
- Finance Students: Explore valuation methodologies and apply them with real-world data specific to Liberty Latin America Ltd. (LILAK).
- Academics: Integrate advanced financial models into your research or educational programs focused on telecommunications.
- Investors: Validate your investment hypotheses and evaluate valuation scenarios for Liberty Latin America Ltd. (LILAK).
- Analysts: Enhance your analytical processes with a ready-to-use, adaptable DCF model tailored for Liberty Latin America Ltd. (LILAK).
- Small Business Owners: Understand the analytical frameworks used for assessing large telecom companies like Liberty Latin America Ltd. (LILAK).
What the Template Contains
- Pre-Filled DCF Model: Liberty Latin America Ltd.’s (LILAK) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Liberty Latin America Ltd.’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.