|
Valoración de DCF de Flushing Financial Corporation (FFIC)
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
Flushing Financial Corporation (FFIC) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF (FFIC)! Utilizando datos de corporaciones financieras de Flushing Authentic Flushing y supuestos personalizables, esta herramienta le permite pronosticar, analizar y valor (FFIC) como un inversor experimentado.
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 | 171.4 | 206.2 | 251.7 | 253.6 | 191.2 | 200.1 | 209.3 | 219.0 | 229.2 | 239.8 |
Revenue Growth, % | 0 | 20.3 | 22.04 | 0.78242 | -24.6 | 4.63 | 4.63 | 4.63 | 4.63 | 4.63 |
EBITDA | 59.3 | 51.4 | 115.7 | 110.8 | 45.8 | 69.3 | 72.5 | 75.8 | 79.3 | 83.0 |
EBITDA, % | 34.57 | 24.92 | 45.98 | 43.68 | 23.95 | 34.62 | 34.62 | 34.62 | 34.62 | 34.62 |
Depreciation | 5.9 | 6.2 | 6.4 | 5.9 | 6.0 | 5.8 | 6.1 | 6.3 | 6.6 | 6.9 |
Depreciation, % | 3.46 | 3.01 | 2.55 | 2.34 | 3.12 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 |
EBIT | 53.3 | 45.2 | 109.3 | 104.9 | 39.8 | 63.5 | 66.4 | 69.5 | 72.7 | 76.1 |
EBIT, % | 31.11 | 21.91 | 43.42 | 41.34 | 20.83 | 31.72 | 31.72 | 31.72 | 31.72 | 31.72 |
Total Cash | 822.3 | 805.4 | 859.0 | 887.1 | 874.8 | 200.1 | 209.3 | 219.0 | 229.2 | 239.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 25.7 | 44.0 | 38.7 | 45.0 | 59.0 | 40.2 | 42.0 | 44.0 | 46.0 | 48.1 |
Account Receivables, % | 15.01 | 21.36 | 15.38 | 17.76 | 30.86 | 20.07 | 20.07 | 20.07 | 20.07 | 20.07 |
Inventories | -75.7 | -201.4 | -120.4 | -196.8 | .0 | -107.0 | -111.9 | -117.1 | -122.5 | -128.2 |
Inventories, % | -44.19 | -97.68 | -47.85 | -77.6 | 0 | -53.46 | -53.46 | -53.46 | -53.46 | -53.46 |
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 | -4.2 | -2.5 | -3.7 | -4.3 | -5.5 | -3.9 | -4.1 | -4.3 | -4.5 | -4.7 |
Capital Expenditure, % | -2.46 | -1.22 | -1.46 | -1.71 | -2.87 | -1.94 | -1.94 | -1.94 | -1.94 | -1.94 |
Tax Rate, % | 28.04 | 28.04 | 28.04 | 28.04 | 28.04 | 28.04 | 28.04 | 28.04 | 28.04 | 28.04 |
EBITAT | 41.3 | 34.7 | 81.8 | 76.9 | 28.7 | 47.5 | 49.7 | 52.0 | 54.4 | 56.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 93.0 | 145.7 | 8.9 | 148.6 | -181.6 | 175.3 | 54.8 | 57.3 | 60.0 | 62.8 |
WACC, % | 4.95 | 4.93 | 4.87 | 4.83 | 4.78 | 4.87 | 4.87 | 4.87 | 4.87 | 4.87 |
PV UFCF | ||||||||||
SUM PV UFCF | 365.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 64 | |||||||||
Terminal Value | 2,229 | |||||||||
Present Terminal Value | 1,757 | |||||||||
Enterprise Value | 2,123 | |||||||||
Net Debt | 758 | |||||||||
Equity Value | 1,365 | |||||||||
Diluted Shares Outstanding, MM | 30 | |||||||||
Equity Value Per Share | 45.62 |
What You Will Get
- Real Flushing Financial Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Flushing Financial Corporation (FFIC).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Flushing Financial Corporation (FFIC).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Flushing Financial Corporation’s (FFIC) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Flushing Financial Corporation (FFIC).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Flushing Financial Corporation (FFIC).
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as loan growth, interest rates, and operating expenses.
- Instant Valuation Metrics: Quickly computes intrinsic value, net present value (NPV), and additional financial outputs.
- High-Precision Estimates: Leverages Flushing Financial Corporation’s (FFIC) actual financial data for accurate valuation results.
- Effortless Scenario Testing: Easily evaluate various financial scenarios and analyze results side by side.
- Efficiency Booster: Streamlines the valuation process, removing the need for intricate model creation.
How It Works
- Step 1: Download the prebuilt Excel template featuring Flushing Financial Corporation’s (FFIC) 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 observe recalculated results, including Flushing Financial Corporation’s (FFIC) intrinsic value.
- Step 5: Make informed investment decisions or create reports using the generated outputs.
Why Choose This Calculator for Flushing Financial Corporation (FFIC)?
- Accurate Data: Up-to-date Flushing Financial Corporation financials provide dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with 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 consultants in the financial sector.
- User-Friendly: Simple design and clear instructions make it accessible for users of all levels.
Who Should Use This Product?
- Investors: Accurately assess Flushing Financial Corporation’s (FFIC) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial analysis and reporting at Flushing Financial Corporation (FFIC).
- Consultants: Efficiently customize the template for valuation reports tailored to clients involving Flushing Financial Corporation (FFIC).
- Entrepreneurs: Acquire knowledge of financial modeling practices employed by leading financial institutions like Flushing Financial Corporation (FFIC).
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to Flushing Financial Corporation (FFIC).
What the Template Contains
- Historical Data: Includes Flushing Financial Corporation’s (FFIC) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Flushing Financial Corporation’s (FFIC) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital specific to Flushing Financial Corporation (FFIC).
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions tailored for Flushing Financial Corporation (FFIC).
- Quarterly and Annual Statements: A complete breakdown of Flushing Financial Corporation’s (FFIC) financials.
- Interactive Dashboard: Visualize valuation results and projections for Flushing Financial Corporation (FFIC) dynamically.