|
First United Corporation (FUNC) 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
First United Corporation (FUNC) Bundle
¡Mejore sus estrategias de inversión con la calculadora (FUNC) DCF! Utilice datos financieros reales de First United Corporation, ajuste las proyecciones y gastos de crecimiento, y visualice instantáneamente cómo estas modificaciones afectan el valor intrínseco de (FUNC).
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 | 63.2 | 67.1 | 73.7 | 75.7 | 69.7 | 71.6 | 73.6 | 75.6 | 77.6 | 79.7 |
| Revenue Growth, % | 0 | 6.25 | 9.74 | 2.75 | -7.88 | 2.71 | 2.71 | 2.71 | 2.71 | 2.71 |
| EBITDA | 19.9 | 21.3 | 29.7 | 36.8 | .0 | 21.8 | 22.4 | 23.0 | 23.6 | 24.3 |
| EBITDA, % | 31.43 | 31.8 | 40.37 | 48.66 | 0 | 30.45 | 30.45 | 30.45 | 30.45 | 30.45 |
| Depreciation | 3.4 | 3.6 | 3.4 | 3.6 | 4.9 | 3.9 | 4.0 | 4.1 | 4.2 | 4.3 |
| Depreciation, % | 5.37 | 5.29 | 4.66 | 4.82 | 7.05 | 5.44 | 5.44 | 5.44 | 5.44 | 5.44 |
| EBIT | 16.5 | 17.8 | 26.3 | 33.2 | -4.9 | 17.9 | 18.4 | 18.9 | 19.4 | 19.9 |
| EBIT, % | 26.06 | 26.5 | 35.72 | 43.84 | -7.05 | 25.01 | 25.01 | 25.01 | 25.01 | 25.01 |
| Total Cash | 181.3 | 376.3 | 402.5 | 200.2 | 145.5 | 71.6 | 73.6 | 75.6 | 77.6 | 79.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | 19.6 | .0 | 35.6 | 7.5 | 12.5 | 12.8 | 13.2 | 13.5 | 13.9 |
| Account Receivables, % | 0 | 29.23 | 0 | 47.08 | 10.74 | 17.41 | 17.41 | 17.41 | 17.41 | 17.41 |
| Inventories | -58.2 | -165.1 | -125.0 | -85.1 | .0 | -56.2 | -57.7 | -59.3 | -60.9 | -62.5 |
| Inventories, % | -92.16 | -245.91 | -169.72 | -112.44 | 0 | -78.43 | -78.43 | -78.43 | -78.43 | -78.43 |
| Accounts Payable | 20.2 | 16.7 | 15.8 | .2 | .6 | 11.4 | 11.7 | 12.0 | 12.3 | 12.7 |
| Accounts Payable, % | 32.03 | 24.95 | 21.43 | 0.19952 | 0.87781 | 15.9 | 15.9 | 15.9 | 15.9 | 15.9 |
| Capital Expenditure | -4.0 | -1.6 | -1.1 | -3.6 | -.4 | -2.2 | -2.3 | -2.3 | -2.4 | -2.5 |
| Capital Expenditure, % | -6.29 | -2.39 | -1.53 | -4.72 | -0.50632 | -3.09 | -3.09 | -3.09 | -3.09 | -3.09 |
| Tax Rate, % | 22.67 | 22.67 | 22.67 | 22.67 | 22.67 | 22.67 | 22.67 | 22.67 | 22.67 | 22.67 |
| EBITAT | 13.1 | 13.4 | 19.8 | 25.0 | -3.8 | 13.7 | 14.1 | 14.5 | 14.9 | 15.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 91.0 | 99.1 | .7 | -66.1 | -55.7 | 77.4 | 17.3 | 17.8 | 18.3 | 18.8 |
| WACC, % | 11.12 | 10.81 | 10.79 | 10.82 | 10.95 | 10.9 | 10.9 | 10.9 | 10.9 | 10.9 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 120.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 19 | |||||||||
| Terminal Value | 215 | |||||||||
| Present Terminal Value | 128 | |||||||||
| Enterprise Value | 248 | |||||||||
| Net Debt | 63 | |||||||||
| Equity Value | 186 | |||||||||
| Diluted Shares Outstanding, MM | 7 | |||||||||
| Equity Value Per Share | 27.71 |
What You Will Get
- Real First United Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for First United Corporation (FUNC).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis needs.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on First United Corporation’s (FUNC) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to First United Corporation (FUNC).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for First United Corporation (FUNC).
Key Features
- Comprehensive Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for First United Corporation (FUNC).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to help visualize your valuation outcomes.
- Suitable for All Skill Levels: Designed with a straightforward layout for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based FUNC DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates First United Corporation’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation changes.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose First United Corporation (FUNC)?
- Streamlined Processes: Eliminate the hassle of manual calculations – our tools are ready for immediate use.
- Enhanced Accuracy: Dependable financial metrics and methodologies minimize valuation discrepancies.
- Completely Customizable: Adjust the model to align with your specific assumptions and forecasts.
- User-Friendly Design: Intuitive visuals and outputs facilitate straightforward analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize accuracy and functionality.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio evaluation of First United Corporation (FUNC).
- Corporate Finance Teams: Examine valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in First United Corporation (FUNC) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Banking and Finance Enthusiasts: Gain insights into how financial institutions like First United Corporation (FUNC) are valued within the market.
What the Template Contains
- Pre-Filled Data: Contains First United Corporation’s historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Assess First United Corporation’s profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visual summaries with charts and tables highlighting key valuation outcomes.