|
Valoración de DCF de Franklin Financial Services Corporation (FRAF)
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
Franklin Financial Services Corporation (FRAF) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (FRAF)! Utilizando datos reales de Franklin Financial Services Corporation y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valor (FRAF) 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 | 56.5 | 56.0 | 61.1 | 65.4 | 65.8 | 68.4 | 71.1 | 73.9 | 76.8 | 79.8 |
| Revenue Growth, % | 0 | -0.99611 | 9.15 | 7.09 | 0.54427 | 3.95 | 3.95 | 3.95 | 3.95 | 3.95 |
| EBITDA | 20.4 | 14.4 | 24.2 | 18.9 | .0 | 17.8 | 18.5 | 19.3 | 20.0 | 20.8 |
| EBITDA, % | 36.03 | 25.71 | 39.65 | 28.94 | 0 | 26.07 | 26.07 | 26.07 | 26.07 | 26.07 |
| Depreciation | 1.3 | 1.2 | 1.1 | 1.4 | .0 | 1.1 | 1.2 | 1.2 | 1.3 | 1.3 |
| Depreciation, % | 2.23 | 2.2 | 1.86 | 2.11 | 0 | 1.68 | 1.68 | 1.68 | 1.68 | 1.68 |
| EBIT | 19.1 | 13.2 | 23.1 | 17.6 | .0 | 16.7 | 17.3 | 18.0 | 18.7 | 19.5 |
| EBIT, % | 33.8 | 23.51 | 37.79 | 26.83 | 0 | 24.39 | 24.39 | 24.39 | 24.39 | 24.39 |
| Total Cash | 280.0 | 466.8 | 715.5 | 565.7 | 492.0 | 68.4 | 71.1 | 73.9 | 76.8 | 79.8 |
| 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 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Capital Expenditure | -1.7 | -.5 | -8.8 | -12.2 | -.5 | -5.1 | -5.4 | -5.6 | -5.8 | -6.0 |
| Capital Expenditure, % | -2.93 | -0.86495 | -14.42 | -18.68 | -0.75877 | -7.53 | -7.53 | -7.53 | -7.53 | -7.53 |
| Tax Rate, % | 13.68 | 13.68 | 13.68 | 13.68 | 13.68 | 13.68 | 13.68 | 13.68 | 13.68 | 13.68 |
| EBITAT | 16.2 | 12.9 | 19.7 | 15.0 | .0 | 14.7 | 15.2 | 15.8 | 16.5 | 17.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 15.8 | 13.6 | 12.0 | 4.1 | -.5 | 10.7 | 11.1 | 11.5 | 12.0 | 12.5 |
| WACC, % | 9.53 | 10.59 | 9.56 | 9.58 | 9.65 | 9.78 | 9.78 | 9.78 | 9.78 | 9.78 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 43.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 13 | |||||||||
| Terminal Value | 163 | |||||||||
| Present Terminal Value | 102 | |||||||||
| Enterprise Value | 146 | |||||||||
| Net Debt | 125 | |||||||||
| Equity Value | 21 | |||||||||
| Diluted Shares Outstanding, MM | 4 | |||||||||
| Equity Value Per Share | 4.77 |
What You Will Receive
- Pre-Filled Financial Model: Utilize Franklin Financial Services Corporation's (FRAF) actual data for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential variables.
- Real-Time Calculations: Automatic updates provide immediate insights as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, allowing for repeated application in detailed forecasts.
Key Features
- Comprehensive Historical Data: Franklin Financial Services Corporation’s (FRAF) complete financial statements and past performance metrics.
- Customizable Parameters: Modify WACC, tax rates, revenue growth projections, and EBITDA margins as needed.
- Real-Time Valuation: Instantly observe the recalculation of Franklin Financial's (FRAF) intrinsic value.
- Intuitive Visualizations: Engaging dashboard charts present valuation outcomes and essential metrics.
- Designed for Precision: A sophisticated tool tailored for analysts, investors, and finance professionals.
How It Works
- Download: Obtain the pre-configured Excel file containing Franklin Financial Services Corporation’s (FRAF) financial data.
- Customize: Modify forecasts, such as revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make changes.
- Test Scenarios: Develop various projections and immediately compare the results.
- Make Decisions: Leverage the valuation findings to inform your investment approach.
Why Choose This Calculator for Franklin Financial Services Corporation (FRAF)?
- Designed for Experts: A sophisticated tool tailored for financial analysts, CFOs, and industry consultants.
- Accurate Financial Data: Historical and projected financials for Franklin Financial Services preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Instantly calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Clear, step-by-step guidance makes the process straightforward.
Who Should Use Franklin Financial Services Corporation (FRAF)?
- Investors: Gain insights into your investment choices with our expert financial analysis tools.
- Financial Analysts: Enhance your efficiency with our customizable financial modeling templates.
- Consultants: Seamlessly tailor our resources for impactful client presentations and reports.
- Finance Enthusiasts: Expand your knowledge of financial strategies through practical examples.
- Educators and Students: Utilize our tools as valuable resources for finance education and training.
What the Franklin Financial Services Corporation (FRAF) Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for (FRAF).
- Real-World Data: Franklin Financial Services Corporation’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to evaluate different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into (FRAF).
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics specific to (FRAF).
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results pertaining to (FRAF).