|
Valoración de DCF de Hancock Whitney Corporation (HWC)
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
Hancock Whitney Corporation (HWC) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF (HWC)! Utilizando datos reales de Hancock Whitney Corporation y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y evaluar (HWC) al igual que 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 | 1,211.1 | 1,267.0 | 1,297.6 | 1,381.5 | 1,321.2 | 1,351.3 | 1,382.2 | 1,413.7 | 1,446.0 | 1,479.0 |
| Revenue Growth, % | 0 | 4.61 | 2.42 | 6.47 | -4.37 | 2.28 | 2.28 | 2.28 | 2.28 | 2.28 |
| EBITDA | 444.5 | -74.7 | 613.8 | 704.8 | 536.4 | 458.7 | 469.2 | 479.9 | 490.8 | 502.1 |
| EBITDA, % | 36.7 | -5.9 | 47.31 | 51.02 | 40.6 | 33.95 | 33.95 | 33.95 | 33.95 | 33.95 |
| Depreciation | 51.7 | 50.0 | 45.8 | 45.6 | 46.3 | 50.1 | 51.3 | 52.5 | 53.7 | 54.9 |
| Depreciation, % | 4.27 | 3.95 | 3.53 | 3.3 | 3.5 | 3.71 | 3.71 | 3.71 | 3.71 | 3.71 |
| EBIT | 392.7 | -124.7 | 568.1 | 659.2 | 490.1 | 408.6 | 417.9 | 427.4 | 437.2 | 447.2 |
| EBIT, % | 32.43 | -9.85 | 43.78 | 47.72 | 37.1 | 30.23 | 30.23 | 30.23 | 30.23 | 30.23 |
| Total Cash | 652.3 | 3,193.4 | 8,062.0 | 6,443.8 | 5,476.4 | 1,226.6 | 1,254.6 | 1,283.3 | 1,312.5 | 1,342.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 92.0 | .0 | .0 | .0 | 214.9 | 64.5 | 66.0 | 67.5 | 69.0 | 70.6 |
| Account Receivables, % | 7.6 | 0 | 0 | 0 | 16.27 | 4.77 | 4.77 | 4.77 | 4.77 | 4.77 |
| Inventories | -705.3 | -2,019.1 | -4,380.6 | -1,102.1 | .0 | -913.5 | -934.4 | -955.7 | -977.5 | -999.8 |
| Inventories, % | -58.23 | -159.36 | -337.6 | -79.77 | 0 | -67.6 | -67.6 | -67.6 | -67.6 | -67.6 |
| Accounts Payable | 10.2 | 4.3 | 3.1 | 9.9 | 45.0 | 15.0 | 15.3 | 15.7 | 16.0 | 16.4 |
| Accounts Payable, % | 0.84219 | 0.34058 | 0.23914 | 0.71915 | 3.41 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
| Capital Expenditure | -42.7 | -37.9 | -23.5 | -29.1 | -25.0 | -33.3 | -34.1 | -34.9 | -35.7 | -36.5 |
| Capital Expenditure, % | -3.53 | -2.99 | -1.81 | -2.11 | -1.89 | -2.47 | -2.47 | -2.47 | -2.47 | -2.47 |
| Tax Rate, % | 19.9 | 19.9 | 19.9 | 19.9 | 19.9 | 19.9 | 19.9 | 19.9 | 19.9 | 19.9 |
| EBITAT | 327.4 | -45.2 | 463.2 | 524.1 | 392.6 | 294.8 | 301.5 | 308.4 | 315.4 | 322.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 959.8 | 1,367.0 | 2,845.8 | -2,731.2 | -868.1 | 1,345.5 | 338.4 | 346.1 | 354.0 | 362.1 |
| WACC, % | 14.87 | 10.93 | 14.72 | 14.55 | 14.6 | 13.93 | 13.93 | 13.93 | 13.93 | 13.93 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,074.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 369 | |||||||||
| Terminal Value | 3,095 | |||||||||
| Present Terminal Value | 1,612 | |||||||||
| Enterprise Value | 3,686 | |||||||||
| Net Debt | 329 | |||||||||
| Equity Value | 3,357 | |||||||||
| Diluted Shares Outstanding, MM | 86 | |||||||||
| Equity Value Per Share | 38.85 |
What You Will Get
- Real HWC Financial Data: Pre-filled with Hancock Whitney Corporation’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 Hancock Whitney Corporation’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
- Customizable Financial Inputs: Adjust essential metrics such as loan growth, interest income, and operating expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- High-Precision Accuracy: Leverages Hancock Whitney Corporation’s (HWC) actual financial data for reliable valuation results.
- Effortless Scenario Testing: Easily evaluate various assumptions and analyze their impacts.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Hancock Whitney Corporation (HWC) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Hancock Whitney Corporation's (HWC) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Hancock Whitney Corporation (HWC)?
- Precise Information: Utilize real Hancock Whitney financial data for trustworthy valuation outcomes.
- Flexible Options: Modify essential variables like growth rates, WACC, and tax rates to align with your forecasts.
- Efficiency Boost: Ready-made calculations save you the hassle of starting from the ground up.
- Expert-Level Tool: Tailored for investors, analysts, and financial consultants.
- Easy to Use: User-friendly design and straightforward instructions ensure accessibility for all users.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Hancock Whitney Corporation (HWC) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Hancock Whitney Corporation (HWC).
- Consultants: Deliver professional valuation insights on Hancock Whitney Corporation (HWC) to clients quickly and accurately.
- Business Owners: Understand how companies like Hancock Whitney Corporation (HWC) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Hancock Whitney Corporation (HWC).
What the Hancock Whitney Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Hancock Whitney Corporation (HWC).
- Real-World Data: Historical and projected financials for Hancock Whitney preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Hancock Whitney.
- Dashboard with Visual Outputs: Engaging charts and tables to present clear, actionable results.