|
Telefónica, S.A. (TEF) Valoración de DCF
ES | Communication Services | Telecommunications Services | NYSE
|
- ✓ 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
Telefónica, S.A. (TEF) Bundle
¡Mejore sus opciones de inversión con la calculadora DCF de Telefónica, S.A. (TEF)! Explore los auténticos datos financieros de Telefónica, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo las modificaciones afectan el valor intrínseco de Telefónica, S.A. (TEF).
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 | 50,476.4 | 44,903.6 | 40,943.4 | 41,689.8 | 42,376.7 | 40,640.5 | 38,975.3 | 37,378.4 | 35,846.9 | 34,378.2 |
| Revenue Growth, % | 0 | -11.04 | -8.82 | 1.82 | 1.65 | -4.1 | -4.1 | -4.1 | -4.1 | -4.1 |
| EBITDA | 16,370.3 | 14,405.3 | 23,485.9 | 14,110.3 | 10,776.6 | 14,724.1 | 14,120.8 | 13,542.2 | 12,987.4 | 12,455.2 |
| EBITDA, % | 32.43 | 32.08 | 57.36 | 33.85 | 25.43 | 36.23 | 36.23 | 36.23 | 36.23 | 36.23 |
| Depreciation | 11,031.0 | 9,756.1 | 8,753.3 | 9,169.2 | 9,170.2 | 8,826.5 | 8,464.9 | 8,118.1 | 7,785.4 | 7,466.5 |
| Depreciation, % | 21.85 | 21.73 | 21.38 | 21.99 | 21.64 | 21.72 | 21.72 | 21.72 | 21.72 | 21.72 |
| EBIT | 5,339.3 | 4,649.2 | 14,732.6 | 4,941.1 | 1,606.4 | 5,897.5 | 5,655.9 | 5,424.2 | 5,201.9 | 4,988.8 |
| EBIT, % | 10.58 | 10.35 | 35.98 | 11.85 | 3.79 | 14.51 | 14.51 | 14.51 | 14.51 | 14.51 |
| Total Cash | 9,553.8 | 8,442.6 | 12,941.7 | 10,100.1 | 7,993.3 | 9,138.2 | 8,763.8 | 8,404.7 | 8,060.3 | 7,730.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 8,883.6 | 6,138.9 | 6,805.0 | 7,280.3 | 7,451.3 | 6,741.2 | 6,465.0 | 6,200.1 | 5,946.1 | 5,702.5 |
| Account Receivables, % | 17.6 | 13.67 | 16.62 | 17.46 | 17.58 | 16.59 | 16.59 | 16.59 | 16.59 | 16.59 |
| Inventories | 2,083.8 | 1,790.9 | 1,823.2 | 1,611.6 | 968.4 | 1,521.6 | 1,459.3 | 1,399.5 | 1,342.1 | 1,287.2 |
| Inventories, % | 4.13 | 3.99 | 4.45 | 3.87 | 2.29 | 3.74 | 3.74 | 3.74 | 3.74 | 3.74 |
| Accounts Payable | 8,438.4 | 6,163.9 | 7,278.2 | 7,865.1 | 8,019.4 | 6,991.0 | 6,704.6 | 6,429.9 | 6,166.4 | 5,913.8 |
| Accounts Payable, % | 16.72 | 13.73 | 17.78 | 18.87 | 18.92 | 17.2 | 17.2 | 17.2 | 17.2 | 17.2 |
| Capital Expenditure | -8,766.8 | -7,317.8 | -6,425.5 | -5,741.7 | -6,422.4 | -6,363.2 | -6,102.5 | -5,852.4 | -5,612.7 | -5,382.7 |
| Capital Expenditure, % | -17.37 | -16.3 | -15.69 | -13.77 | -15.16 | -15.66 | -15.66 | -15.66 | -15.66 | -15.66 |
| Tax Rate, % | 39.44 | 39.44 | 39.44 | 39.44 | 39.44 | 39.44 | 39.44 | 39.44 | 39.44 | 39.44 |
| EBITAT | 3,268.8 | 2,847.5 | 9,911.5 | 3,356.9 | 972.8 | 3,753.7 | 3,599.9 | 3,452.4 | 3,310.9 | 3,175.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 3,004.0 | 6,048.8 | 12,655.1 | 7,107.6 | 4,347.1 | 5,345.5 | 6,014.4 | 5,768.0 | 5,531.6 | 5,305.0 |
| WACC, % | 5.18 | 5.18 | 5.44 | 5.47 | 5.15 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 24,046.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 5,411 | |||||||||
| Terminal Value | 164,668 | |||||||||
| Present Terminal Value | 127,279 | |||||||||
| Enterprise Value | 151,326 | |||||||||
| Net Debt | 38,532 | |||||||||
| Equity Value | 112,793 | |||||||||
| Diluted Shares Outstanding, MM | 5,716 | |||||||||
| Equity Value Per Share | 19.73 |
What You Will Get
- Real TEF 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 calculated in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Telefónica's future performance.
- User-Friendly Design: Designed for professionals but easy for beginners to navigate.
Key Features
- 🔍 Real-Life TEF Financials: Pre-filled historical and projected data for Telefónica, S.A.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Telefónica’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Telefónica’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: Gain immediate access to the Excel-based TEF DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Telefónica’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
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 Updates: Observe immediate changes to Telefónica’s valuation as you modify inputs.
- Preloaded Data: Comes equipped with Telefónica’s current financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for assessing portfolio performance with Telefónica, S.A. (TEF).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights to clients focused on Telefónica, S.A. (TEF) investments.
- Students and Educators: Utilize real-world data for hands-on practice and instruction in financial modeling techniques.
- Telecom Enthusiasts: Gain insights into how telecommunications companies like Telefónica, S.A. (TEF) are valued in the financial markets.
What the Template Contains
- Historical Data: Includes Telefónica’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Telefónica’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 Telefónica’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.