|
Generations Bancorp NY, Inc. (GBNY) DCF Valuation
US | Financial Services | Banks - Regional | NASDAQ
|
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Generations Bancorp NY, Inc. (GBNY) Bundle
Looking to determine the intrinsic value of Generations Bancorp NY, Inc. (GBNY)? Our (GBNY) DCF Calculator integrates real-world data with extensive customization features, enabling you to adjust forecasts and enhance your investment strategies.
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 | 10.9 | 12.5 | 12.6 | 11.4 | 9.5 | 9.2 | 8.9 | 8.7 | 8.4 | 8.2 |
| Revenue Growth, % | 0 | 14.71 | 0.92845 | -9.7 | -17 | -2.77 | -2.77 | -2.77 | -2.77 | -2.77 |
| EBITDA | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| EBITDA, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Depreciation | 1.1 | 1.1 | 1.1 | 1.0 | 1.0 | .9 | .9 | .8 | .8 | .8 |
| Depreciation, % | 10.42 | 8.93 | 8.66 | 8.85 | 10.77 | 9.53 | 9.53 | 9.53 | 9.53 | 9.53 |
| EBIT | -1.1 | -1.1 | -1.1 | -1.0 | -1.0 | -.9 | -.9 | -.8 | -.8 | -.8 |
| EBIT, % | -10.42 | -8.93 | -8.66 | -8.85 | -10.77 | -9.53 | -9.53 | -9.53 | -9.53 | -9.53 |
| Total Cash | 44.1 | 44.8 | 58.6 | 37.0 | 45.8 | 9.2 | 8.9 | 8.7 | 8.4 | 8.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | 305.2 | 2.5 | 2.3 | 2.3 | 2.2 | 2.1 | 2.1 |
| Account Receivables, % | 0 | 0 | 0 | 2680.11 | 26.25 | 25.25 | 25.25 | 25.25 | 25.25 | 25.25 |
| Inventories | -14.7 | -28.1 | -22.9 | 294.6 | .0 | -3.7 | -3.6 | -3.5 | -3.4 | -3.3 |
| Inventories, % | -135.26 | -224.54 | -181.78 | 2586.81 | 0 | -40 | -40 | -40 | -40 | -40 |
| Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Capital Expenditure | -.8 | -.2 | -.4 | -.5 | -.4 | -.4 | -.4 | -.4 | -.3 | -.3 |
| Capital Expenditure, % | -7.43 | -1.85 | -3.37 | -4.05 | -3.88 | -4.12 | -4.12 | -4.12 | -4.12 | -4.12 |
| Tax Rate, % | 21.34 | 21.34 | 21.34 | 21.34 | 21.34 | 21.34 | 21.34 | 21.34 | 21.34 | 21.34 |
| EBITAT | 1.5 | -1.2 | -.9 | -.8 | -.8 | -.6 | -.6 | -.6 | -.6 | -.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 16.5 | 13.0 | -5.4 | -623.0 | 597.1 | 3.7 | -.1 | -.1 | -.1 | -.1 |
| WACC, % | 3.83 | 17.13 | 14.91 | 14.93 | 14.29 | 13.02 | 13.02 | 13.02 | 13.02 | 13.02 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | -1 | |||||||||
| Present Terminal Value | -1 | |||||||||
| Enterprise Value | 2 | |||||||||
| Net Debt | 5 | |||||||||
| Equity Value | -2 | |||||||||
| Diluted Shares Outstanding, MM | 2 | |||||||||
| Equity Value Per Share | -1.10 |
What You Will Get
- Real GBNY Financial Data: Pre-filled with Generations Bancorp NY, Inc.’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 Generations Bancorp NY, Inc.’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 Generations Bancorp NY, Inc. (GBNY).
- WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable inputs specific to GBNY.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates according to GBNY's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to Generations Bancorp NY, Inc. (GBNY).
- Interactive Dashboard and Charts: Visual representations of key valuation metrics facilitate straightforward analysis for GBNY.
How It Works
- Step 1: Download the Excel file for Generations Bancorp NY, Inc. (GBNY).
- Step 2: Review GBNY's pre-filled financial data and forecasts.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment choices.
Why Choose This Calculator for Generations Bancorp NY, Inc. (GBNY)?
- Accuracy: Utilizes real financial data from Generations Bancorp for precise calculations.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminates the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and attention to detail expected at the CFO level.
- User-Friendly: Designed for simplicity, making it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Evaluate Generations Bancorp NY, Inc. (GBNY) for informed stock trading decisions.
- CFOs and Financial Analysts: Optimize valuation methods and assess financial forecasts for GBNY.
- Startup Founders: Understand the valuation processes of established financial institutions like GBNY.
- Consultants: Create detailed valuation reports for clients interested in GBNY.
- Students and Educators: Utilize real market data to learn and teach valuation strategies involving GBNY.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Generations Bancorp NY, Inc. (GBNY) 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 Generations Bancorp NY, Inc. (GBNY).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.