|
First Savings Financial Group, Inc. (FSFG) Valoración de DCF
US | Financial Services | Banks - Regional | 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
First Savings Financial Group, Inc. (FSFG) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (FSFG)! Utilizando datos reales de First Savings Financial Group, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, evaluar y evaluar (FSFG) al igual que un inversor experimentado.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 180.5 | 177.6 | 111.9 | 86.9 | 133.9 | 131.6 | 129.4 | 127.1 | 125.0 | 122.8 |
| Revenue Growth, % | 0 | -1.61 | -37.01 | -22.31 | 54.07 | -1.71 | -1.71 | -1.71 | -1.71 | -1.71 |
| EBITDA | 48.6 | 40.8 | .0 | 10.4 | .0 | 16.3 | 16.0 | 15.7 | 15.4 | 15.2 |
| EBITDA, % | 26.92 | 22.95 | 0 | 11.92 | 0 | 12.36 | 12.36 | 12.36 | 12.36 | 12.36 |
| Depreciation | 1.8 | 2.2 | 2.3 | 2.3 | .0 | 1.8 | 1.8 | 1.8 | 1.8 | 1.7 |
| Depreciation, % | 0.99162 | 1.26 | 2.09 | 2.67 | 0 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
| EBIT | 46.8 | 38.5 | -2.3 | 8.0 | .0 | 14.4 | 14.2 | 13.9 | 13.7 | 13.5 |
| EBIT, % | 25.93 | 21.69 | -2.09 | 9.25 | 0 | 10.96 | 10.96 | 10.96 | 10.96 | 10.96 |
| Total Cash | 235.7 | 240.1 | 359.8 | 30.8 | 52.1 | 98.6 | 96.9 | 95.2 | 93.6 | 92.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | 8.3 | .0 | .0 | 2.0 | 1.9 | 1.9 | 1.9 | 1.8 |
| Account Receivables, % | 0 | 0 | 7.45 | 0 | 0 | 1.49 | 1.49 | 1.49 | 1.49 | 1.49 |
| Inventories | -44.9 | -43.6 | .0 | .0 | .0 | -13.0 | -12.8 | -12.6 | -12.4 | -12.1 |
| Inventories, % | -24.86 | -24.56 | 0 | 0 | 0 | -9.88 | -9.88 | -9.88 | -9.88 | -9.88 |
| Accounts Payable | .7 | .3 | 1.3 | 8.9 | .0 | 3.1 | 3.1 | 3.0 | 3.0 | 2.9 |
| Accounts Payable, % | 0.37837 | 0.14526 | 1.16 | 10.27 | 0 | 2.39 | 2.39 | 2.39 | 2.39 | 2.39 |
| Capital Expenditure | -7.3 | -5.6 | -.8 | -3.0 | -.7 | -3.1 | -3.1 | -3.0 | -3.0 | -2.9 |
| Capital Expenditure, % | -4.05 | -3.18 | -0.74634 | -3.4 | -0.51079 | -2.38 | -2.38 | -2.38 | -2.38 | -2.38 |
| Tax Rate, % | 6.97 | 6.97 | 6.97 | 6.97 | 6.97 | 6.97 | 6.97 | 6.97 | 6.97 | 6.97 |
| EBITAT | 33.4 | 28.5 | -1.9 | 8.0 | .0 | 12.1 | 11.9 | 11.7 | 11.5 | 11.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 73.4 | 23.4 | -51.3 | 23.4 | -9.6 | 25.0 | 10.4 | 10.2 | 10.0 | 9.9 |
| WACC, % | 11.3 | 11.62 | 12.56 | 14.76 | 13.93 | 12.83 | 12.83 | 12.83 | 12.83 | 12.83 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 49.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 10 | |||||||||
| Terminal Value | 93 | |||||||||
| Present Terminal Value | 51 | |||||||||
| Enterprise Value | 100 | |||||||||
| Net Debt | -52 | |||||||||
| Equity Value | 152 | |||||||||
| Diluted Shares Outstanding, MM | 7 | |||||||||
| Equity Value Per Share | 22.26 |
What You Will Get
- Real FSFG Financial Data: Pre-filled with First Savings Financial Group’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 First Savings Financial Group’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 DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for First Savings Financial Group, Inc. (FSFG).
- WACC Calculator: Comes with a pre-built Weighted Average Cost of Capital sheet that allows for customizable inputs specific to FSFG.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit FSFG's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to First Savings Financial Group, Inc. (FSFG).
- Interactive Dashboard and Charts: Visual representations summarize key valuation metrics for straightforward analysis of FSFG.
How It Works
- Download the Template: Get immediate access to the Excel-based FSFG Valuation Model.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, profit margins, and more.
- Instant Calculations: The model automatically recalculates First Savings Financial Group's intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation variations.
- Analyze and Decide: Utilize the findings to inform your investment or financial decisions.
Why Choose This Calculator for First Savings Financial Group, Inc. (FSFG)?
- Designed for Experts: A sophisticated tool tailored for financial analysts, CFOs, and investment consultants.
- Accurate Financial Data: FSFG’s historical and projected financials are preloaded for reliable analysis.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Instantly calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance makes the process straightforward and efficient.
Who Should Use This Product?
- Investors: Accurately assess the fair value of First Savings Financial Group, Inc. (FSFG) before making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently modify the template for valuation reports tailored to clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading financial institutions.
- Educators: Implement it as a teaching resource to illustrate various valuation methodologies.
What the Template Contains
- Pre-Filled DCF Model: First Savings Financial Group, Inc.'s (FSFG) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to FSFG.
- Financial Ratios: Assess FSFG's profitability, leverage, and efficiency metrics.
- Editable Inputs: Adjust assumptions such as growth rates, margins, and CAPEX to align with your analysis.
- Financial Statements: Comprehensive annual and quarterly reports to facilitate in-depth evaluation.
- Interactive Dashboard: Visualize key valuation metrics and results for FSFG effortlessly.