|
La primera valoración de DCF de Bancorp, Inc. (FNLC)
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
The First Bancorp, Inc. (FNLC) Bundle
¡Simplifique la primera valoración de Bancorp, Inc. (FNLC) con esta calculadora DCF personalizable! Con Real The First Bancorp, Inc. (FNLC) financieras y entradas de pronóstico ajustable, puede probar escenarios y descubrir el primer valor razonable de Bancorp, Inc. (FNLC) en minutos.
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 | 66.7 | 78.0 | 85.7 | 93.0 | 79.5 | 83.6 | 87.9 | 92.5 | 97.3 | 102.4 |
Revenue Growth, % | 0 | 16.9 | 9.92 | 8.58 | -14.6 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 |
EBITDA | 30.1 | 29.7 | 40.5 | 47.1 | 36.1 | 37.9 | 39.9 | 41.9 | 44.1 | 46.4 |
EBITDA, % | 45.08 | 38.14 | 47.28 | 50.66 | 45.49 | 45.33 | 45.33 | 45.33 | 45.33 | 45.33 |
Depreciation | 2.0 | 2.3 | 2.1 | 2.1 | 2.1 | 2.2 | 2.3 | 2.4 | 2.6 | 2.7 |
Depreciation, % | 2.97 | 2.9 | 2.46 | 2.21 | 2.68 | 2.65 | 2.65 | 2.65 | 2.65 | 2.65 |
EBIT | 28.1 | 27.5 | 38.4 | 45.1 | 34.0 | 35.7 | 37.5 | 39.5 | 41.5 | 43.7 |
EBIT, % | 42.11 | 35.24 | 44.82 | 48.45 | 42.81 | 42.68 | 42.68 | 42.68 | 42.68 | 42.68 |
Total Cash | 386.3 | 395.7 | 407.9 | 310.9 | 311.1 | 83.6 | 87.9 | 92.5 | 97.3 | 102.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | 11.9 | 2.5 | 2.6 | 2.8 | 2.9 | 3.1 |
Account Receivables, % | 0 | 0 | 0 | 0 | 14.97 | 2.99 | 2.99 | 2.99 | 2.99 | 2.99 |
Inventories | -33.2 | -92.6 | -94.9 | -36.3 | .0 | -48.3 | -50.8 | -53.4 | -56.2 | -59.1 |
Inventories, % | -49.77 | -118.75 | -110.7 | -38.96 | 0 | -57.75 | -57.75 | -57.75 | -57.75 | -57.75 |
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.6 | -2.5 | -3.8 | -1.4 | -2.6 | -2.5 | -2.6 | -2.7 | -2.9 | -3.0 |
Capital Expenditure, % | -2.36 | -3.26 | -4.38 | -1.51 | -3.32 | -2.97 | -2.97 | -2.97 | -2.97 | -2.97 |
Tax Rate, % | 17.32 | 17.32 | 17.32 | 17.32 | 17.32 | 17.32 | 17.32 | 17.32 | 17.32 | 17.32 |
EBITAT | 23.7 | 23.1 | 31.7 | 37.1 | 28.1 | 29.7 | 31.2 | 32.9 | 34.6 | 36.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 57.3 | 82.2 | 32.4 | -20.9 | -20.5 | 87.1 | 33.3 | 35.1 | 36.9 | 38.8 |
WACC, % | 23.19 | 23.14 | 22.84 | 22.78 | 22.86 | 22.96 | 22.96 | 22.96 | 22.96 | 22.96 |
PV UFCF | ||||||||||
SUM PV UFCF | 141.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 40 | |||||||||
Terminal Value | 189 | |||||||||
Present Terminal Value | 67 | |||||||||
Enterprise Value | 209 | |||||||||
Net Debt | -15 | |||||||||
Equity Value | 224 | |||||||||
Diluted Shares Outstanding, MM | 11 | |||||||||
Equity Value Per Share | 20.23 |
What You Will Receive
- Authentic FNLC Data: Preloaded financials – including revenue and EBIT – derived from actual and projected metrics.
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Immediate Valuation Adjustments: Automatic recalculations to assess the effects of changes on FNLC’s fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and in-depth forecasts.
- Efficient and Precise: Avoid the hassle of building models from the ground up while ensuring accuracy and adaptability.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as loan growth, interest margins, and operating expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics with ease.
- High-Precision Accuracy: Leverages The First Bancorp, Inc.'s (FNLC) actual financial data for credible valuation results.
- Effortless Scenario Analysis: Explore various assumptions and effortlessly compare the results.
- Efficiency Boost: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- 1. Access the Template: Download and open the Excel file featuring The First Bancorp, Inc.'s (FNLC) preloaded financial data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
- 3. View Results in Real-Time: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Different Scenarios: Analyze various forecasts to evaluate different valuation results.
- 5. Present with Assurance: Deliver professional valuation insights to bolster your decision-making process.
Why Choose The First Bancorp, Inc. (FNLC)?
- Save Time: Instantly access comprehensive financial tools without starting from scratch.
- Enhance Accuracy: Utilize reliable data and formulas to minimize valuation errors.
- Fully Customizable: Adjust the model to align with your unique assumptions and forecasts.
- Easy to Understand: Intuitive charts and outputs simplify the analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize precision and ease of use.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions regarding investments in The First Bancorp, Inc. (FNLC).
- Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for FNLC.
- Consultants: Provide clients with accurate and timely valuation analyses of The First Bancorp, Inc. (FNLC).
- Business Owners: Learn how the valuation of banks like FNLC can inform your own business strategies.
- Finance Students: Explore real-world valuation methods using data from The First Bancorp, Inc. (FNLC).
What the Template Contains
- Pre-Filled DCF Model: The First Bancorp, Inc.'s (FNLC) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to FNLC.
- Financial Ratios: Evaluate The First Bancorp, Inc.'s (FNLC) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios for FNLC.
- Financial Statements: Annual and quarterly reports for The First Bancorp, Inc. (FNLC) to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results for FNLC.