Discounted Cash Flow (DCF) Analysis Levered
International Bancshares Corporatio... (IBOC)
$44.74
-1.50 (-3.24%)
All numbers are in Millions, Currency in USD
Free Cash Flow
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 578.20 | 588.60 | 538.47 | 593.60 | 674.76 | 703.76 | 734.01 | 765.56 | 798.47 | 832.79 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | 229.85 | 311.56 | 305.13 | 291.68 | 387.94 | 360.30 | 375.79 | 391.94 | 408.79 | 426.36 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -21.39 | -29.59 | -6.73 | -10.39 | -19.21 | -20.51 | -21.40 | -22.31 | -23.27 | -24.27 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | 208.45 | 281.98 | 298.41 | 281.29 | 368.73 | 339.79 | 354.40 | 369.63 | 385.52 | 402.09 |
Weighted Average Cost Of Capital
Share price | $ 44.74 |
---|---|
Beta | 1.010 |
Diluted Shares Outstanding | 62.81 |
Cost of Debt | |
Tax Rate | 21.54 |
After-tax Cost of Debt | 20.57% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 8.461 |
Total Debt | 145.59 |
Total Equity | 2,810.13 |
Total Capital | 2,955.72 |
Debt Weighting | 4.93 |
Equity Weighting | 95.07 |
Wacc |
Build Up Free Cash Flow
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 578.20 | 588.60 | 538.47 | 593.60 | 674.76 | 703.76 | 734.01 | 765.56 | 798.47 | 832.79 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | 229.85 | 311.56 | 305.13 | 291.68 | 387.94 | 360.30 | 375.79 | 391.94 | 408.79 | 426.36 |
Capital Expenditure | -21.39 | -29.59 | -6.73 | -10.39 | -19.21 | -20.51 | -21.40 | -22.31 | -23.27 | -24.27 |
Free Cash Flow | 208.45 | 281.98 | 298.41 | 281.29 | 368.73 | 339.79 | 354.40 | 369.63 | 385.52 | 402.09 |
WACC | ||||||||||
PV LFCF | 311.56 | 297.96 | 284.95 | 272.51 | 260.61 | |||||
SUM PV LFCF | 1,427.59 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 9.06 |
Free cash flow (t + 1) | 410.13 |
Terminal Value | 5,809.18 |
Present Value of Terminal Value | 3,765.20 |
Intrinsic Value
Enterprise Value | 5,192.79 |
---|---|
Net Debt | -1,942.14 |
Equity Value | 7,134.92 |
Shares Outstanding | 62.81 |
Equity Value Per Share | 113.59 |