|
Grupo Supervielle S.A. (SUPV) Valoración de DCF
AR | Financial Services | Banks - Regional | 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
Grupo Supervielle S.A. (SUPV) Bundle
Ya sea que sea un inversor o analista, esta calculadora DCF (SUPV) es su herramienta esencial para una valoración precisa. Precedido con los datos reales de Grupo Supervielle S.A., puede ajustar los pronósticos y observar los efectos en tiempo real.
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 | 56.1 | 61.4 | 327.9 | 335.0 | 430.6 | 581.5 | 785.5 | 1,060.9 | 1,432.8 | 1,935.2 |
| Revenue Growth, % | 0 | 9.55 | 433.68 | 2.17 | 28.54 | 35.06 | 35.06 | 35.06 | 35.06 | 35.06 |
| EBITDA | .0 | -13.1 | -29.6 | 2.0 | -113.0 | -65.1 | -87.9 | -118.7 | -160.3 | -216.6 |
| EBITDA, % | 0 | -21.28 | -9.02 | 0.58424 | -26.25 | -11.19 | -11.19 | -11.19 | -11.19 | -11.19 |
| Depreciation | 4.0 | -6.2 | -4.5 | 10.4 | -88.5 | -25.3 | -34.1 | -46.1 | -62.3 | -84.1 |
| Depreciation, % | 7.11 | -10.02 | -1.38 | 3.1 | -20.55 | -4.35 | -4.35 | -4.35 | -4.35 | -4.35 |
| EBIT | -4.0 | -6.9 | -25.0 | -8.4 | -24.5 | -39.8 | -53.7 | -72.6 | -98.1 | -132.4 |
| EBIT, % | -7.11 | -11.26 | -7.64 | -2.51 | -5.7 | -6.84 | -6.84 | -6.84 | -6.84 | -6.84 |
| Total Cash | 14.7 | 27.9 | 50.1 | 81.6 | 142.7 | 168.0 | 226.9 | 306.4 | 413.9 | 559.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accounts Payable | 2.9 | 2.0 | 24.5 | 31.7 | 33.9 | 38.7 | 52.3 | 70.6 | 95.4 | 128.9 |
| Accounts Payable, % | 5.2 | 3.27 | 7.46 | 9.47 | 7.88 | 6.66 | 6.66 | 6.66 | 6.66 | 6.66 |
| Capital Expenditure | -2.2 | -7.0 | -29.8 | -25.4 | -24.2 | -43.8 | -59.1 | -79.8 | -107.8 | -145.6 |
| Capital Expenditure, % | -3.99 | -11.34 | -9.08 | -7.6 | -5.62 | -7.53 | -7.53 | -7.53 | -7.53 | -7.53 |
| Tax Rate, % | 40.25 | 40.25 | 40.25 | 40.25 | 40.25 | 40.25 | 40.25 | 40.25 | 40.25 | 40.25 |
| EBITAT | -4.3 | -5.8 | -29.8 | -4.9 | -14.7 | -32.0 | -43.2 | -58.4 | -78.8 | -106.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | .3 | -19.8 | -41.7 | -12.7 | -125.1 | -96.3 | -122.9 | -166.0 | -224.2 | -302.8 |
| WACC, % | 25.27 | 23.12 | 25.27 | 19.73 | 19.92 | 22.66 | 22.66 | 22.66 | 22.66 | 22.66 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -458.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -309 | |||||||||
| Terminal Value | -1,495 | |||||||||
| Present Terminal Value | -538 | |||||||||
| Enterprise Value | -997 | |||||||||
| Net Debt | -221 | |||||||||
| Equity Value | -775 | |||||||||
| Diluted Shares Outstanding, MM | 443 | |||||||||
| Equity Value Per Share | -1.75 |
What You Will Get
- Real SUPV 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 Grupo Supervielle S.A.'s future performance.
- User-Friendly Design: Designed for professionals while remaining accessible to newcomers.
Key Features
- 🔍 Real-Life SUPV Financials: Pre-filled historical and projected data for Grupo Supervielle 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 Grupo Supervielle’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Grupo Supervielle’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 featuring Grupo Supervielle S.A. (SUPV) data.
- Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated results, including Grupo Supervielle S.A.'s intrinsic value.
- Step 5: Make well-informed investment decisions or generate reports based on the outputs.
Why Choose This Calculator for Grupo Supervielle S.A. (SUPV)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio assessments seamlessly.
- Adjustable Parameters: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Grupo Supervielle’s intrinsic value and Net Present Value.
- Ready-to-Use Data: Historical and projected data provide reliable baselines for analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors.
Who Should Use This Product?
- Finance Students: Understand financial modeling and apply concepts using real data from Grupo Supervielle S.A. (SUPV).
- Academics: Integrate industry-standard models into your lectures or research projects related to Grupo Supervielle S.A. (SUPV).
- Investors: Evaluate your investment strategies and analyze the performance metrics of Grupo Supervielle S.A. (SUPV).
- Analysts: Enhance your analysis with a ready-to-use, customizable financial model tailored for Grupo Supervielle S.A. (SUPV).
- Small Business Owners: Learn from the analytical approaches used for large financial institutions like Grupo Supervielle S.A. (SUPV).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Grupo Supervielle S.A. historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Grupo Supervielle S.A. (SUPV).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.