|
Essa Bancorp, Inc. (ESSA) DCF Valoración
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
ESSA Bancorp, Inc. (ESSA) Bundle
¡Descubra el verdadero potencial de Essa Bancorp, Inc. (ESSA) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los diferentes factores afectan la valoración de ESSA, todo dentro de una plantilla de Excel conveniente.
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 | 61.5 | 64.4 | 68.2 | 69.3 | 67.8 | 69.6 | 71.3 | 73.2 | 75.0 | 76.9 |
Revenue Growth, % | 0 | 4.76 | 5.95 | 1.59 | -2.1 | 2.55 | 2.55 | 2.55 | 2.55 | 2.55 |
EBITDA | 19.8 | 22.1 | 27.2 | 25.2 | .0 | 19.9 | 20.4 | 20.9 | 21.4 | 22.0 |
EBITDA, % | 32.23 | 34.3 | 39.85 | 36.34 | 0 | 28.54 | 28.54 | 28.54 | 28.54 | 28.54 |
Depreciation | 2.2 | 2.2 | 2.2 | 2.1 | .0 | 1.8 | 1.9 | 1.9 | 2.0 | 2.0 |
Depreciation, % | 3.6 | 3.4 | 3.2 | 3.05 | 0 | 2.65 | 2.65 | 2.65 | 2.65 | 2.65 |
EBIT | 17.6 | 19.9 | 25.0 | 23.1 | .0 | 18.0 | 18.5 | 18.9 | 19.4 | 19.9 |
EBIT, % | 28.63 | 30.9 | 36.65 | 33.29 | 0 | 25.9 | 25.9 | 25.9 | 25.9 | 25.9 |
Total Cash | 368.4 | 399.5 | 236.6 | 419.5 | 254.6 | 69.6 | 71.3 | 73.2 | 75.0 | 76.9 |
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 | -1,574.4 | -1,500.3 | -1,463.7 | -1,769.2 | .0 | -55.7 | -57.1 | -58.5 | -60.0 | -61.6 |
Inventories, % | -2561.53 | -2330.07 | -2145.76 | -2553.05 | 0 | -80 | -80 | -80 | -80 | -80 |
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.1 | -.4 | -.6 | -1.0 | -.2 | -.7 | -.7 | -.7 | -.7 | -.8 |
Capital Expenditure, % | -1.72 | -0.6228 | -0.83705 | -1.38 | -0.32575 | -0.97636 | -0.97636 | -0.97636 | -0.97636 | -0.97636 |
Tax Rate, % | 18.94 | 18.94 | 18.94 | 18.94 | 18.94 | 18.94 | 18.94 | 18.94 | 18.94 | 18.94 |
EBITAT | 14.4 | 16.4 | 20.1 | 18.6 | .0 | 14.6 | 15.0 | 15.4 | 15.8 | 16.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 1,589.9 | -55.9 | -14.8 | 325.2 | -1,769.5 | 71.5 | 17.6 | 18.1 | 18.5 | 19.0 |
WACC, % | 4.65 | 4.67 | 4.61 | 4.61 | 4.63 | 4.63 | 4.63 | 4.63 | 4.63 | 4.63 |
PV UFCF | ||||||||||
SUM PV UFCF | 130.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 19 | |||||||||
Terminal Value | 736 | |||||||||
Present Terminal Value | 587 | |||||||||
Enterprise Value | 718 | |||||||||
Net Debt | 241 | |||||||||
Equity Value | 476 | |||||||||
Diluted Shares Outstanding, MM | 10 | |||||||||
Equity Value Per Share | 49.96 |
What You Will Get
- Real ESSA Financial Data: Pre-filled with ESSA Bancorp'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 ESSA'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
- Customizable Financial Inputs: Adjust essential metrics such as loan growth, net interest margin, and operating expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Leverages ESSA Bancorp’s actual financial data for credible valuation results.
- Effortless Scenario Analysis: Explore various assumptions and evaluate results with ease.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template featuring ESSA Bancorp, Inc.'s (ESSA) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including the intrinsic value of ESSA Bancorp, Inc. (ESSA).
- Step 5: Make well-informed investment choices or create reports based on the outputs.
Why Choose This Calculator for ESSA Bancorp, Inc. (ESSA)?
- Designed for Financial Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Accurate Financial Data: ESSA’s historical and projected financials are preloaded for precision.
- Dynamic Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance simplifies the entire calculation process.
Who Should Use This Product?
- Investors: Evaluate ESSA Bancorp, Inc.’s (ESSA) valuation prior to making investment decisions.
- CFOs and Financial Analysts: Optimize valuation workflows and assess financial forecasts.
- Startup Founders: Understand the valuation methodologies applied to established companies like ESSA Bancorp, Inc.
- Consultants: Provide comprehensive valuation reports for your clientele.
- Students and Educators: Utilize real-time data to learn and teach valuation strategies.
What the Template Contains
- Historical Data: Includes ESSA Bancorp, Inc.'s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate ESSA's intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of ESSA Bancorp, Inc.'s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.