|
Banco Santander, S.A. (SAN) DCF Valoración
ES | Financial Services | Banks - Diversified | 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
Banco Santander, S.A. (SAN) Bundle
¡Descubra el verdadero valor de Banco Santander, S.A. (SAN) con nuestra calculadora DCF avanzada! Ajuste los supuestos críticos, explore varios escenarios y evalúe cómo los cambios afectan a Banco Santander, S.A. (SAN) Valoración, todo dentro de una plantilla de Excel integral.
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 | 54,541.9 | 48,798.1 | 50,459.7 | 56,516.2 | 46,659.0 | 45,193.4 | 43,773.8 | 42,398.8 | 41,067.0 | 39,777.0 |
| Revenue Growth, % | 0 | -10.53 | 3.41 | 12 | -17.44 | -3.14 | -3.14 | -3.14 | -3.14 | -3.14 |
| EBITDA | 15,865.7 | .0 | 17,586.8 | .0 | .0 | 5,779.5 | 5,598.0 | 5,422.1 | 5,251.8 | 5,086.9 |
| EBITDA, % | 29.09 | 0 | 34.85 | 0 | 0 | 12.79 | 12.79 | 12.79 | 12.79 | 12.79 |
| Depreciation | 3,128.3 | 2,929.2 | 2,872.9 | 3,111.6 | 3,319.1 | 2,716.2 | 2,630.9 | 2,548.3 | 2,468.2 | 2,390.7 |
| Depreciation, % | 5.74 | 6 | 5.69 | 5.51 | 7.11 | 6.01 | 6.01 | 6.01 | 6.01 | 6.01 |
| EBIT | 12,737.4 | -2,929.2 | 14,713.9 | -3,111.6 | -3,319.1 | 3,063.3 | 2,967.1 | 2,873.9 | 2,783.6 | 2,696.2 |
| EBIT, % | 23.35 | -6 | 29.16 | -5.51 | -7.11 | 6.78 | 6.78 | 6.78 | 6.78 | 6.78 |
| Total Cash | 105,354.9 | 160,365.9 | 219,627.9 | 232,537.3 | 229,690.4 | 45,193.4 | 43,773.8 | 42,398.8 | 41,067.0 | 39,777.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | 11,073.7 | 2,145.2 | 2,077.8 | 2,012.5 | 1,949.3 | 1,888.1 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 23.73 | 4.75 | 4.75 | 4.75 | 4.75 | 4.75 |
| Inventories | -240,103.2 | -298,572.9 | -338,814.8 | -381,937.9 | .0 | -36,154.7 | -35,019.1 | -33,919.1 | -32,853.6 | -31,821.6 |
| Inventories, % | -440.22 | -611.85 | -671.46 | -675.8 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | 1,931.6 | 2,082.8 | 2,501.8 | 3,153.3 | 3,465.0 | 2,329.6 | 2,256.4 | 2,185.5 | 2,116.9 | 2,050.4 |
| Accounts Payable, % | 3.54 | 4.27 | 4.96 | 5.58 | 7.43 | 5.15 | 5.15 | 5.15 | 5.15 | 5.15 |
| Capital Expenditure | -14,743.0 | -8,881.5 | -11,886.8 | -11,299.9 | -14,221.8 | -10,779.8 | -10,441.2 | -10,113.2 | -9,795.5 | -9,487.8 |
| Capital Expenditure, % | -27.03 | -18.2 | -23.56 | -19.99 | -30.48 | -23.85 | -23.85 | -23.85 | -23.85 | -23.85 |
| Tax Rate, % | 32.71 | 32.71 | 32.71 | 32.71 | 32.71 | 32.71 | 32.71 | 32.71 | 32.71 | 32.71 |
| EBITAT | 6,616.0 | -10,875.9 | 8,217.2 | -1,959.8 | -2,233.6 | 2,071.2 | 2,006.1 | 1,943.1 | 1,882.1 | 1,823.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 237,036.1 | 41,792.7 | 39,864.2 | 33,626.5 | -405,836.2 | 37,955.5 | -6,945.6 | -6,727.4 | -6,516.1 | -6,311.4 |
| WACC, % | 10.41 | 18.23 | 11.05 | 12.21 | 12.91 | 12.96 | 12.96 | 12.96 | 12.96 | 12.96 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 16,057.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -6,438 | |||||||||
| Terminal Value | -58,715 | |||||||||
| Present Terminal Value | -31,919 | |||||||||
| Enterprise Value | -15,861 | |||||||||
| Net Debt | 66,803 | |||||||||
| Equity Value | -82,664 | |||||||||
| Diluted Shares Outstanding, MM | 16,247 | |||||||||
| Equity Value Per Share | -5.09 |
What You Will Get
- Real SAN Financial Data: Pre-filled with Banco Santander’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 Banco Santander’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
- Comprehensive Historical Data: Banco Santander’s (SAN) extensive financial records and pre-populated projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and net interest margins.
- Real-Time Calculations: Observe Banco Santander’s intrinsic value update instantly.
- Intuitive Visualizations: Interactive dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A reliable resource for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file containing Banco Santander, S.A.'s (SAN) financial data.
- 2. Adjust Assumptions: Modify critical inputs such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Instantly: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to investigate different valuation results.
- 5. Present with Assurance: Deliver professional valuation analyses to back your strategic decisions.
Why Choose This Calculator for Banco Santander, S.A. (SAN)?
- Accurate Data: Up-to-date Banco Santander financials provide trustworthy valuation insights.
- Customizable: Tailor essential inputs such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
- User-Friendly: An intuitive design and clear instructions ensure accessibility for every user.
Who Should Use This Product?
- Investors: Accurately assess Banco Santander’s fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis related to Banco Santander (SAN).
- Consultants: Efficiently modify the template for valuation reports tailored to clients interested in Banco Santander (SAN).
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading banks like Banco Santander (SAN).
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to Banco Santander (SAN).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Banco Santander, S.A. (SAN).
- Real-World Data: Banco Santander’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis covering profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Visualizations including charts and tables for clear, actionable results.