Home Bancshares, Inc. (Conway, AR) (HOMB) DCF Valuation
- ✓ 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
Home Bancshares, Inc. (Conway, AR) (HOMB) Bundle
Whether you’re an investor or analyst, this (HOMB) DCF Calculator is your go-to resource for accurate valuation. Preloaded with real data from Home Bancshares, Inc. (Conway, AR), you can adjust forecasts and observe the effects in real-time.
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 | 662.7 | 684.6 | 699.8 | 918.9 | 978.3 | 1,084.1 | 1,201.5 | 1,331.5 | 1,475.6 | 1,635.3 |
| Revenue Growth, % | 0 | 3.29 | 2.22 | 31.31 | 6.46 | 10.82 | 10.82 | 10.82 | 10.82 | 10.82 |
| EBITDA | 405.0 | 297.8 | 436.3 | 426.4 | 542.8 | 582.9 | 646.0 | 715.9 | 793.4 | 879.3 |
| EBITDA, % | 61.12 | 43.5 | 62.34 | 46.41 | 55.49 | 53.77 | 53.77 | 53.77 | 53.77 | 53.77 |
| Depreciation | 19.4 | 20.1 | 19.5 | 31.9 | 30.9 | 33.1 | 36.7 | 40.7 | 45.1 | 50.0 |
| Depreciation, % | 2.93 | 2.93 | 2.78 | 3.47 | 3.16 | 3.06 | 3.06 | 3.06 | 3.06 | 3.06 |
| EBIT | 385.6 | 277.7 | 416.8 | 394.6 | 511.9 | 549.8 | 609.3 | 675.3 | 748.3 | 829.3 |
| EBIT, % | 58.19 | 40.57 | 59.56 | 42.94 | 52.33 | 50.72 | 50.72 | 50.72 | 50.72 | 50.72 |
| Total Cash | 2,574.4 | 3,737.6 | 6,770.1 | 4,766.4 | 3,734.2 | 1,084.1 | 1,201.5 | 1,331.5 | 1,475.6 | 1,635.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 | -544.8 | -1,328.7 | -3,698.7 | -828.5 | .0 | -807.4 | -894.8 | -991.6 | -1,098.9 | -1,217.9 |
| Inventories, % | -82.21 | -194.1 | -528.55 | -90.17 | 0 | -74.48 | -74.48 | -74.48 | -74.48 | -74.48 |
| Accounts Payable | 102.4 | 128.0 | 113.9 | 196.9 | 194.7 | 198.9 | 220.5 | 244.3 | 270.8 | 300.1 |
| Accounts Payable, % | 15.45 | 18.7 | 16.27 | 21.43 | 19.9 | 18.35 | 18.35 | 18.35 | 18.35 | 18.35 |
| Capital Expenditure | -14.9 | -11.5 | -10.3 | -9.0 | -8.6 | -15.7 | -17.4 | -19.3 | -21.4 | -23.7 |
| Capital Expenditure, % | -2.25 | -1.69 | -1.47 | -0.98119 | -0.874 | -1.45 | -1.45 | -1.45 | -1.45 | -1.45 |
| Tax Rate, % | 23.24 | 23.24 | 23.24 | 23.24 | 23.24 | 23.24 | 23.24 | 23.24 | 23.24 | 23.24 |
| EBITAT | 289.5 | 214.4 | 319.0 | 305.3 | 392.9 | 421.1 | 466.7 | 517.2 | 573.2 | 635.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 941.3 | 1,032.5 | 2,684.0 | -2,459.0 | -415.5 | 1,250.2 | 594.9 | 659.3 | 730.6 | 809.7 |
| WACC, % | 10.67 | 10.77 | 10.74 | 10.78 | 10.75 | 10.74 | 10.74 | 10.74 | 10.74 | 10.74 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,071.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 826 | |||||||||
| Terminal Value | 9,444 | |||||||||
| Present Terminal Value | 5,670 | |||||||||
| Enterprise Value | 8,741 | |||||||||
| Net Debt | 741 | |||||||||
| Equity Value | 8,000 | |||||||||
| Diluted Shares Outstanding, MM | 203 | |||||||||
| Equity Value Per Share | 39.45 |
What You Will Get
- Real HOMB Financial Data: Pre-filled with Home Bancshares, Inc.’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 Home Bancshares, Inc.’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
- Accurate Home Bancshares Financials: Access reliable pre-loaded historical data and future projections for HOMB.
- Customizable Forecast Assumptions: Modify highlighted cells for metrics like WACC, growth rates, and profit margins.
- Dynamic Calculations: Automatic updates to DCF, Net Present Value (NPV), and cash flow assessments.
- Visual Dashboard: Intuitive charts and summaries to help visualize your valuation outcomes.
- For Professionals and Beginners: A user-friendly design tailored for investors, CFOs, and financial consultants.
How It Works
- 1. Open the Template: Download and open the Excel file featuring Home Bancshares, Inc. (Conway, AR) (HOMB) preloaded data.
- 2. Edit Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Test Scenarios: Evaluate various forecasts to investigate different valuation results.
- 5. Use with Confidence: Deliver professional valuation insights to enhance your decision-making process.
Why Choose This Calculator?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Feedback: Instantly view changes to Home Bancshares, Inc.'s (HOMB) valuation as you modify inputs.
- Preloaded Data: Comes equipped with Home Bancshares, Inc.'s (HOMB) actual financial figures for immediate analysis.
- Preferred by Experts: Widely utilized by investors and analysts for making well-informed decisions.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Home Bancshares, Inc. (HOMB) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Home Bancshares, Inc. (HOMB).
- Consultants: Deliver professional valuation insights for Home Bancshares, Inc. (HOMB) to clients quickly and accurately.
- Business Owners: Understand how banks like Home Bancshares, Inc. (HOMB) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Home Bancshares, Inc. (HOMB).
What the Template Contains
- Preloaded HOMB Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.