|
Valoración DCF de Amerant Bancorp Inc. (AMTB)
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
Amerant Bancorp Inc. (AMTB) Bundle
¡Mejore su estrategia de inversión con la calculadora DCF (AMTB)! Explore los datos financieros reales de Amerant Bancorp Inc., ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estos cambios afectan el valor intrínseco de (AMTB).
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 | 271.1 | 263.1 | 205.1 | 266.7 | 328.9 | 352.2 | 377.2 | 403.9 | 432.6 | 463.2 |
Revenue Growth, % | 0 | -2.95 | -22.03 | 29.99 | 23.34 | 7.09 | 7.09 | 7.09 | 7.09 | 7.09 |
EBITDA | 81.8 | .0 | 151.3 | 84.5 | .0 | 95.5 | 102.3 | 109.6 | 117.3 | 125.6 |
EBITDA, % | 30.18 | 0 | 73.75 | 31.68 | 0 | 27.12 | 27.12 | 27.12 | 27.12 | 27.12 |
Depreciation | 7.1 | 9.4 | 7.3 | 5.9 | 6.8 | 9.9 | 10.6 | 11.3 | 12.1 | 13.0 |
Depreciation, % | 2.62 | 3.57 | 3.54 | 2.21 | 2.08 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 |
EBIT | 74.7 | -9.4 | 144.0 | 78.6 | -6.8 | 85.7 | 91.7 | 98.2 | 105.2 | 112.7 |
EBIT, % | 27.57 | -3.57 | 70.21 | 29.47 | -2.08 | 24.32 | 24.32 | 24.32 | 24.32 | 24.32 |
Total Cash | 1,690.1 | 1,439.5 | 1,449.5 | 1,306.1 | 53.3 | 293.2 | 314.0 | 336.2 | 360.1 | 385.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | 233.6 | .0 | .0 | 70.4 | 75.4 | 80.8 | 86.5 | 92.6 |
Account Receivables, % | 0 | 0 | 113.89 | 0 | 0 | 20 | 20 | 20 | 20 | 20 |
Inventories | -121.3 | -214.4 | -274.2 | -290.6 | .0 | -229.8 | -246.1 | -263.6 | -282.2 | -302.3 |
Inventories, % | -44.76 | -81.49 | -133.67 | -108.98 | 0 | -65.25 | -65.25 | -65.25 | -65.25 | -65.25 |
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 | -14.3 | -5.6 | -6.6 | -10.6 | -10.9 | -12.6 | -13.5 | -14.5 | -15.5 | -16.6 |
Capital Expenditure, % | -5.26 | -2.12 | -3.21 | -3.99 | -3.32 | -3.58 | -3.58 | -3.58 | -3.58 | -3.58 |
Tax Rate, % | 21.39 | 21.39 | 21.39 | 21.39 | 21.39 | 21.39 | 21.39 | 21.39 | 21.39 | 21.39 |
EBITAT | 59.9 | -3.7 | 101.0 | 58.0 | -5.4 | 58.7 | 62.8 | 67.3 | 72.0 | 77.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 174.1 | 93.1 | -72.1 | 303.2 | -300.1 | 215.3 | 71.2 | 76.2 | 81.6 | 87.4 |
WACC, % | 14.74 | 9.37 | 13.4 | 13.88 | 14.53 | 13.18 | 13.18 | 13.18 | 13.18 | 13.18 |
PV UFCF | ||||||||||
SUM PV UFCF | 395.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 89 | |||||||||
Terminal Value | 797 | |||||||||
Present Terminal Value | 429 | |||||||||
Enterprise Value | 824 | |||||||||
Net Debt | 625 | |||||||||
Equity Value | 199 | |||||||||
Diluted Shares Outstanding, MM | 34 | |||||||||
Equity Value Per Share | 5.91 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Amerant Bancorp Inc.’s (AMTB) financial data pre-loaded to accelerate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model tailored to fit your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for Amerant Bancorp Inc. (AMTB).
- 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 evaluations.
- User-Friendly Dashboard: Clear charts and summaries designed to help you visualize your valuation outcomes.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Operates
- Download: Obtain the pre-formatted Excel file containing Amerant Bancorp Inc.'s (AMTB) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and analyze results immediately.
- Make Decisions: Leverage the valuation findings to inform your investment approach.
Why Choose This Calculator for Amerant Bancorp Inc. (AMTB)?
- Accuracy: Utilizes real Amerant financial data for precise calculations.
- Flexibility: Allows users to easily adjust and experiment with various inputs.
- Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and detail expected at the CFO level.
- User-Friendly: Intuitive interface suitable for users without extensive financial modeling skills.
Who Should Use This Product?
- Finance Students: Discover financial modeling techniques and apply them using real data from Amerant Bancorp Inc. (AMTB).
- Academics: Integrate advanced financial models into your curriculum or research focused on Amerant Bancorp Inc. (AMTB).
- Investors: Evaluate your investment strategies and assess valuation scenarios for Amerant Bancorp Inc. (AMTB).
- Analysts: Enhance your analysis with a ready-to-use, customizable DCF model tailored for Amerant Bancorp Inc. (AMTB).
- Small Business Owners: Understand the evaluation methods used for large public companies like Amerant Bancorp Inc. (AMTB).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Amerant Bancorp Inc. (AMTB).
- Real-World Data: Amerant Bancorp Inc.’s historical and projected financials 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 metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for decision-making.