|
Telefonaktiebolaget LM Ericsson (Publ) (Eric) DCF Valoración
SE | Technology | Communication Equipment | 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
Telefonaktiebolaget LM Ericsson (publ) (ERIC) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF (ERIC)! Utilizando datos reales de Ericsson y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y evaluar Telefonaktiebolaget LM Ericsson (Publ) como 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 | 20,652.0 | 21,122.3 | 21,115.3 | 24,681.2 | 23,936.3 | 24,900.6 | 25,903.7 | 26,947.3 | 28,032.8 | 29,162.1 |
| Revenue Growth, % | 0 | 2.28 | -0.03270364 | 16.89 | -3.02 | 4.03 | 4.03 | 4.03 | 4.03 | 4.03 |
| EBITDA | 1,739.1 | 3,346.2 | 3,537.6 | 3,321.9 | 2,541.0 | 3,241.6 | 3,372.2 | 3,508.1 | 3,649.4 | 3,796.4 |
| EBITDA, % | 8.42 | 15.84 | 16.75 | 13.46 | 10.62 | 13.02 | 13.02 | 13.02 | 13.02 | 13.02 |
| Depreciation | 643.5 | 642.8 | 646.7 | 777.7 | 1,014.1 | 827.2 | 860.5 | 895.1 | 931.2 | 968.7 |
| Depreciation, % | 3.12 | 3.04 | 3.06 | 3.15 | 4.24 | 3.32 | 3.32 | 3.32 | 3.32 | 3.32 |
| EBIT | 1,095.6 | 2,703.4 | 2,890.9 | 2,544.2 | 1,526.9 | 2,414.5 | 2,511.7 | 2,612.9 | 2,718.2 | 2,827.7 |
| EBIT, % | 5.31 | 12.8 | 13.69 | 10.31 | 6.38 | 9.7 | 9.7 | 9.7 | 9.7 | 9.7 |
| Total Cash | 4,711.6 | 4,583.8 | 6,088.1 | 4,279.6 | 4,069.6 | 5,363.1 | 5,579.1 | 5,803.9 | 6,037.7 | 6,280.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 5,156.6 | 5,021.9 | 5,328.4 | 5,745.3 | 5,070.3 | 5,898.5 | 6,136.1 | 6,383.3 | 6,640.4 | 6,907.9 |
| Account Receivables, % | 24.97 | 23.78 | 25.23 | 23.28 | 21.18 | 23.69 | 23.69 | 23.69 | 23.69 | 23.69 |
| Inventories | 2,805.2 | 2,553.8 | 3,196.1 | 4,167.0 | 3,290.4 | 3,557.8 | 3,701.1 | 3,850.2 | 4,005.3 | 4,166.7 |
| Inventories, % | 13.58 | 12.09 | 15.14 | 16.88 | 13.75 | 14.29 | 14.29 | 14.29 | 14.29 | 14.29 |
| Accounts Payable | 2,763.4 | 2,907.4 | 3,243.4 | 3,493.6 | 2,523.9 | 3,346.9 | 3,481.7 | 3,622.0 | 3,767.9 | 3,919.7 |
| Accounts Payable, % | 13.38 | 13.76 | 15.36 | 14.15 | 10.54 | 13.44 | 13.44 | 13.44 | 13.44 | 13.44 |
| Capital Expenditure | -605.6 | -482.6 | -420.4 | -563.3 | -299.7 | -535.0 | -556.5 | -579.0 | -602.3 | -626.5 |
| Capital Expenditure, % | -2.93 | -2.28 | -1.99 | -2.28 | -1.25 | -2.15 | -2.15 | -2.15 | -2.15 | -2.15 |
| Tax Rate, % | -13.41 | -13.41 | -13.41 | -13.41 | -13.41 | -13.41 | -13.41 | -13.41 | -13.41 | -13.41 |
| EBITAT | 278.0 | 1,736.9 | 2,242.9 | 1,935.8 | 1,731.6 | 1,657.7 | 1,724.5 | 1,794.0 | 1,866.3 | 1,941.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -4,882.6 | 2,427.2 | 1,856.4 | 1,012.6 | 3,028.0 | 1,677.3 | 1,782.3 | 1,854.1 | 1,928.8 | 2,006.5 |
| WACC, % | 5.25 | 5.62 | 5.74 | 5.73 | 5.95 | 5.66 | 5.66 | 5.66 | 5.66 | 5.66 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 7,827.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 2,047 | |||||||||
| Terminal Value | 55,978 | |||||||||
| Present Terminal Value | 42,515 | |||||||||
| Enterprise Value | 50,343 | |||||||||
| Net Debt | 1,739 | |||||||||
| Equity Value | 48,603 | |||||||||
| Diluted Shares Outstanding, MM | 3,330 | |||||||||
| Equity Value Per Share | 14.60 |
What You Will Get
- Flexible Forecast Inputs: Quickly adjust key assumptions (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Market Data: Ericsson’s financial data pre-loaded to facilitate your analysis.
- Instant DCF Calculations: The template automatically computes Net Present Value (NPV) and intrinsic value for you.
- Tailored and Professional Design: A refined Excel model that caters to your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, verifying strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life ERIC Financials: Pre-filled historical and projected data for Telefonaktiebolaget LM Ericsson (publ).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Ericsson’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Ericsson’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template containing Telefonaktiebolaget LM Ericsson’s (ERIC) data.
- Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Immediately see the recalculated results, including Telefonaktiebolaget LM Ericsson’s (ERIC) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create reports.
Why Choose This Calculator?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Adjustments: Witness immediate updates to Telefonaktiebolaget LM Ericsson’s valuation as you change inputs.
- Preloaded Data: Comes with Telefonaktiebolaget LM Ericsson's actual financial figures for fast evaluation.
- Preferred by Experts: Valued by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio assessment.
- Corporate Finance Teams: Evaluate valuation scenarios to inform internal decision-making strategies.
- Consultants and Advisors: Deliver precise valuation insights for Telefonaktiebolaget LM Ericsson (ERIC).
- Students and Educators: Utilize real-world data to practice and instruct on financial modeling techniques.
- Tech Enthusiasts: Gain insights into how technology companies like Telefonaktiebolaget LM Ericsson (ERIC) are valued in the marketplace.
What the Template Contains
- Pre-Filled Data: Includes Telefonaktiebolaget LM Ericsson’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 Telefonaktiebolaget LM Ericsson’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.