|
Union Bankshares, Inc. (UNB) Valoración de DCF
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
Union Bankshares, Inc. (UNB) Bundle
¡Descubra el verdadero potencial de Union Bankshares, Inc. (UNB) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los diferentes cambios afectan a Union Bankshares, Inc. (UNB) Valoración, todo dentro de una plantilla de Excel integral.
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 | 40.7 | 47.6 | 48.7 | 48.4 | 48.2 | 50.5 | 52.8 | 55.2 | 57.7 | 60.3 |
| Revenue Growth, % | 0 | 16.94 | 2.24 | -0.5342 | -0.34083 | 4.58 | 4.58 | 4.58 | 4.58 | 4.58 |
| EBITDA | 14.2 | 17.3 | 17.7 | 17.0 | 14.5 | 17.4 | 18.2 | 19.1 | 20.0 | 20.9 |
| EBITDA, % | 34.92 | 36.31 | 36.39 | 35.22 | 30.09 | 34.59 | 34.59 | 34.59 | 34.59 | 34.59 |
| Depreciation | 1.7 | 2.1 | 1.9 | 1.8 | 1.6 | 2.0 | 2.1 | 2.2 | 2.3 | 2.4 |
| Depreciation, % | 4.27 | 4.33 | 3.9 | 3.72 | 3.4 | 3.92 | 3.92 | 3.92 | 3.92 | 3.92 |
| EBIT | 12.5 | 15.2 | 15.8 | 15.2 | 12.9 | 15.5 | 16.2 | 16.9 | 17.7 | 18.5 |
| EBIT, % | 30.65 | 31.98 | 32.5 | 31.49 | 26.69 | 30.66 | 30.66 | 30.66 | 30.66 | 30.66 |
| Total Cash | 99.4 | 123.9 | 285.7 | 271.2 | 327.2 | 50.5 | 52.8 | 55.2 | 57.7 | 60.3 |
| 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 | -60.4 | -139.6 | -82.4 | .0 | .0 | -30.3 | -31.7 | -33.1 | -34.6 | -36.2 |
| Inventories, % | -148.37 | -293.34 | -169.23 | 0 | 0 | -60 | -60 | -60 | -60 | -60 |
| Accounts Payable | 9.9 | 11.2 | 9.8 | 13.2 | .0 | 9.6 | 10.0 | 10.5 | 11.0 | 11.5 |
| Accounts Payable, % | 24.26 | 23.57 | 20.09 | 27.17 | 0 | 19.02 | 19.02 | 19.02 | 19.02 | 19.02 |
| Capital Expenditure | -6.4 | -1.0 | -3.5 | -.7 | -1.9 | -3.1 | -3.2 | -3.4 | -3.5 | -3.7 |
| Capital Expenditure, % | -15.76 | -2.12 | -7.21 | -1.37 | -4.03 | -6.1 | -6.1 | -6.1 | -6.1 | -6.1 |
| Tax Rate, % | 12.58 | 12.58 | 12.58 | 12.58 | 12.58 | 12.58 | 12.58 | 12.58 | 12.58 | 12.58 |
| EBITAT | 10.6 | 12.8 | 13.2 | 12.6 | 11.3 | 13.1 | 13.7 | 14.3 | 15.0 | 15.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 76.2 | 94.5 | -47.2 | -65.2 | -2.2 | 51.9 | 14.4 | 15.0 | 15.7 | 16.4 |
| WACC, % | 12.59 | 12.48 | 12.41 | 12.36 | 12.78 | 12.53 | 12.53 | 12.53 | 12.53 | 12.53 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 86.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 17 | |||||||||
| Terminal Value | 159 | |||||||||
| Present Terminal Value | 88 | |||||||||
| Enterprise Value | 175 | |||||||||
| Net Debt | 63 | |||||||||
| Equity Value | 112 | |||||||||
| Diluted Shares Outstanding, MM | 5 | |||||||||
| Equity Value Per Share | 24.74 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real UNB financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Union Bankshares, Inc.'s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Union Bankshares, Inc. (UNB).
- WACC Tool: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to Union Bankshares, Inc. (UNB).
- Customizable Forecast Assumptions: Adjust growth projections, capital investments, and discount rates as needed for Union Bankshares, Inc. (UNB).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Union Bankshares, Inc. (UNB).
- Interactive Dashboard and Charts: Visual representations of key valuation metrics for straightforward analysis of Union Bankshares, Inc. (UNB).
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Union Bankshares, Inc. (UNB) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Union Bankshares, Inc. (UNB)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Union Bankshares, Inc. (UNB)?
- Accuracy: Utilizes real Union Bankshares financial data for precise calculations.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminates the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and attention to detail expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Finance Students: Explore financial modeling techniques and apply them to real-world data for Union Bankshares, Inc. (UNB).
- Academics: Integrate advanced valuation models into your studies or research projects focused on Union Bankshares, Inc. (UNB).
- Investors: Validate your investment strategies and assess valuation scenarios for Union Bankshares, Inc. (UNB).
- Analysts: Enhance your efficiency with a customizable DCF model specifically designed for Union Bankshares, Inc. (UNB).
- Small Business Owners: Understand the analytical frameworks used for evaluating larger financial institutions like Union Bankshares, Inc. (UNB).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Union Bankshares, Inc. (UNB) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Union Bankshares, Inc. (UNB).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.