|
Valoración de DCF de la Corporación Internacional de Bancshares (IBOC)
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
International Bancshares Corporation (IBOC) Bundle
¡Simplifique la valoración de International Bancshares Corporation (IBOC) con esta calculadora DCF personalizable! Con Real International International Bancshares Corporation (IBOC) financieras y aportes de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de International Bancshares Corporation (IBOC) en minutos.
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 | 588.6 | 538.5 | 593.6 | 674.8 | 974.1 | 1,119.6 | 1,286.9 | 1,479.1 | 1,700.1 | 1,954.0 |
| Revenue Growth, % | 0 | -8.52 | 10.24 | 13.67 | 44.36 | 14.94 | 14.94 | 14.94 | 14.94 | 14.94 |
| EBITDA | .0 | .0 | 347.4 | 404.5 | 545.5 | 390.6 | 449.0 | 516.1 | 593.2 | 681.8 |
| EBITDA, % | 0 | 0 | 58.52 | 59.94 | 56 | 34.89 | 34.89 | 34.89 | 34.89 | 34.89 |
| Depreciation | 28.3 | 28.3 | 25.0 | 21.8 | 21.9 | 44.3 | 50.9 | 58.5 | 67.2 | 77.2 |
| Depreciation, % | 4.8 | 5.26 | 4.22 | 3.23 | 2.25 | 3.95 | 3.95 | 3.95 | 3.95 | 3.95 |
| EBIT | -28.3 | -28.3 | 322.3 | 382.6 | 523.5 | 346.4 | 398.1 | 457.6 | 526.0 | 604.5 |
| EBIT, % | -4.8 | -5.26 | 54.3 | 56.71 | 53.74 | 30.94 | 30.94 | 30.94 | 30.94 | 30.94 |
| Total Cash | 3,635.7 | 5,078.0 | 7,423.2 | 6,505.5 | 651.1 | 1,045.3 | 1,201.5 | 1,381.0 | 1,587.3 | 1,824.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 36.6 | 37.9 | 30.6 | 45.8 | .0 | 56.4 | 64.8 | 74.5 | 85.7 | 98.5 |
| Account Receivables, % | 6.22 | 7.03 | 5.15 | 6.79 | 0 | 5.04 | 5.04 | 5.04 | 5.04 | 5.04 |
| Inventories | -371.7 | -2,095.6 | -3,280.0 | -2,168.3 | .0 | -813.2 | -934.6 | -1,074.3 | -1,234.7 | -1,419.2 |
| Inventories, % | -63.15 | -389.18 | -552.56 | -321.34 | 0 | -72.63 | -72.63 | -72.63 | -72.63 | -72.63 |
| 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 | -29.6 | -6.7 | -10.4 | -19.2 | -27.5 | -30.7 | -35.3 | -40.5 | -46.6 | -53.5 |
| Capital Expenditure, % | -5.03 | -1.25 | -1.75 | -2.85 | -2.82 | -2.74 | -2.74 | -2.74 | -2.74 | -2.74 |
| Tax Rate, % | 21.35 | 21.35 | 21.35 | 21.35 | 21.35 | 21.35 | 21.35 | 21.35 | 21.35 | 21.35 |
| EBITAT | -22.3 | -22.4 | 253.9 | 300.2 | 411.8 | 272.8 | 313.6 | 360.4 | 414.3 | 476.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 311.4 | 1,721.9 | 1,460.2 | -824.0 | -1,716.3 | 1,043.1 | 442.2 | 508.3 | 584.2 | 671.5 |
| WACC, % | 11.06 | 11.06 | 11.05 | 11.04 | 11.05 | 11.05 | 11.05 | 11.05 | 11.05 | 11.05 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,450.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 685 | |||||||||
| Terminal Value | 7,566 | |||||||||
| Present Terminal Value | 4,479 | |||||||||
| Enterprise Value | 6,930 | |||||||||
| Net Debt | -531 | |||||||||
| Equity Value | 7,462 | |||||||||
| Diluted Shares Outstanding, MM | 62 | |||||||||
| Equity Value Per Share | 119.92 |
What You Will Get
- Pre-Filled Financial Model: International Bancshares Corporation’s (IBOC) actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers specific to (IBOC).
- Instant Calculations: Automatic updates ensure you see results as you make changes for (IBOC).
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation of (IBOC).
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts of (IBOC).
Key Features
- Accurate Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for International Bancshares Corporation (IBOC).
- Adjustable Forecast Inputs: Modify highlighted cells to customize factors such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: Utilize clear charts and summaries to effectively visualize your valuation outcomes.
- Designed for All Users: A straightforward, user-friendly format tailored for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based IBOC DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates International Bancshares Corporation’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to see how they affect valuation outcomes.
- Analyze and Decide: Utilize the results to inform your investment or financial strategies.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Accurate Data: International Bancshares Corporation’s (IBOC) historical and projected financials preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance simplifies the entire process.
Who Should Use This Product?
- Investors: Accurately assess International Bancshares Corporation’s (IBOC) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently customize the template for client valuation reports.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading financial institutions.
- Educators: Employ it as an educational resource to illustrate valuation methods.
What the Template Contains
- Preloaded IBOC 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.