|
Heartland Financial USA, Inc. (HTLF) 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
Heartland Financial USA, Inc. (HTLF) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (HTLF)! Utilizando datos reales de Heartland Financial USA, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valorar Heartland Financial como un inversor experimentado.
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 | 569.4 | 606.9 | 688.9 | 727.5 | 553.3 | 555.7 | 558.2 | 560.6 | 563.1 | 565.6 |
| Revenue Growth, % | 0 | 6.6 | 13.51 | 5.61 | -23.95 | 0.4405 | 0.4405 | 0.4405 | 0.4405 | 0.4405 |
| EBITDA | 214.9 | 201.3 | 302.2 | 292.2 | .0 | 172.2 | 173.0 | 173.7 | 174.5 | 175.3 |
| EBITDA, % | 37.75 | 33.16 | 43.86 | 40.17 | 0 | 30.99 | 30.99 | 30.99 | 30.99 | 30.99 |
| Depreciation | 24.0 | 22.5 | 36.4 | 34.2 | .0 | 19.9 | 20.0 | 20.1 | 20.2 | 20.2 |
| Depreciation, % | 4.21 | 3.7 | 5.28 | 4.71 | 0 | 3.58 | 3.58 | 3.58 | 3.58 | 3.58 |
| EBIT | 190.9 | 178.8 | 265.8 | 258.0 | .0 | 152.3 | 153.0 | 153.7 | 154.3 | 155.0 |
| EBIT, % | 33.54 | 29.46 | 38.58 | 35.46 | 0 | 27.41 | 27.41 | 27.41 | 27.41 | 27.41 |
| Total Cash | 382.3 | 341.0 | 438.5 | 2,112.0 | 323.0 | 383.9 | 385.5 | 387.2 | 388.9 | 390.7 |
| 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 | -8,689.7 | -10,266.4 | -10,325.1 | -11,318.9 | .0 | -444.6 | -446.5 | -448.5 | -450.5 | -452.5 |
| Inventories, % | -1526.23 | -1691.56 | -1498.77 | -1555.76 | 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 | -17.9 | -18.5 | -17.2 | -14.8 | -7.1 | -13.4 | -13.4 | -13.5 | -13.5 | -13.6 |
| Capital Expenditure, % | -3.15 | -3.06 | -2.5 | -2.03 | -1.28 | -2.4 | -2.4 | -2.4 | -2.4 | -2.4 |
| Tax Rate, % | 17.42 | 17.42 | 17.42 | 17.42 | 17.42 | 17.42 | 17.42 | 17.42 | 17.42 | 17.42 |
| EBITAT | 154.7 | 141.8 | 212.3 | 204.4 | .0 | 122.5 | 123.0 | 123.5 | 124.1 | 124.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 8,850.4 | 1,722.4 | 290.3 | 1,217.6 | -11,325.9 | 573.6 | 131.5 | 132.1 | 132.7 | 133.3 |
| WACC, % | 14.19 | 14.03 | 14.08 | 14.02 | 14.34 | 14.13 | 14.13 | 14.13 | 14.13 | 14.13 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 839.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 136 | |||||||||
| Terminal Value | 1,120 | |||||||||
| Present Terminal Value | 578 | |||||||||
| Enterprise Value | 1,418 | |||||||||
| Net Debt | 700 | |||||||||
| Equity Value | 718 | |||||||||
| Diluted Shares Outstanding, MM | 43 | |||||||||
| Equity Value Per Share | 16.78 |
What You Will Get
- Comprehensive HTLF Financial Data: Pre-filled with Heartland Financial USA, Inc.'s historical and projected data for accurate analysis.
- Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch as Heartland's intrinsic value updates in real-time based on your modifications.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for reliable DCF results.
- Intuitive Design: Clear layout and straightforward instructions suitable for all skill levels.
Key Features
- Accurate Financial Data: Gain access to reliable pre-loaded historical data and future forecasts for Heartland Financial USA, Inc. (HTLF).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to help you visualize your valuation insights.
- Designed for All Skill Levels: A straightforward, user-friendly layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the ready-to-use Excel file containing Heartland Financial USA, Inc. (HTLF) financial data.
- Customize: Modify forecasts, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop multiple projections and instantly compare the results.
- Make Decisions: Utilize the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for Heartland Financial USA, Inc. (HTLF)?
- Designed for Industry Experts: A sophisticated tool utilized by financial analysts, CFOs, and consultants.
- Comprehensive Data: Heartland's historical and projected financials are preloaded for enhanced accuracy.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly Interface: Step-by-step guidance simplifies the entire process.
Who Should Use This Product?
- Investors: Evaluate Heartland Financial's (HTLF) performance before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methods and assess financial forecasts.
- Startup Founders: Understand the valuation processes of established financial institutions like Heartland Financial.
- Consultants: Create comprehensive valuation reports for your clients based on Heartland Financial's data.
- Students and Educators: Utilize real-time financial data to teach and practice valuation strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Heartland Financial USA, Inc. (HTLF) 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 Heartland Financial USA, Inc. (HTLF).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.