Discounted Cash Flow (DCF) Analysis Unlevered
Itaú Corpbanca (ITCB)
$3.51
-0.05 (-1.40%)
All numbers are in Millions, Currency in USD
Operating Data
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
Revenue | 1,056,518 | 1,221,953 | 1,222,555.99 | 1,010,627.99 | 1,303,790.99 | 1,393,038.85 | 1,488,395.95 | 1,590,280.49 | 1,699,139.30 | 1,815,449.76 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
EBITDA | 960,141.99 | 1,176,861 | 1,161,925.01 | -114,313 | 1,201,819.01 | 1,011,614.11 | 1,080,861.71 | 1,154,849.48 | 1,233,901.91 | 1,318,365.68 |
EBITDA (%) | ||||||||||
EBIT | 878,296.99 | 1,090,044 | 1,034,759.01 | -240,757 | 1,100,236.01 | 884,691.88 | 945,251.32 | 1,009,956.21 | 1,079,090.32 | 1,152,956.83 |
EBIT (%) | ||||||||||
Depreciation | 81,845.01 | 86,817 | 127,166 | 126,444 | 101,583 | 126,922.24 | 135,610.39 | 144,893.27 | 154,811.59 | 165,408.84 |
Depreciation (%) |
Balance Sheet Data
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
Total Cash | 3,784,525 | 3,963,492 | 4,839,875.99 | 7,233,163 | 7,572,338 | 6,616,794.77 | 7,069,731.45 | 7,553,672.80 | 8,070,741.19 | 8,623,204.25 |
---|---|---|---|---|---|---|---|---|---|---|
Total Cash (%) | ||||||||||
Account Receivables | 1,646,609 | 1,495,267 | 1,457,437 | 1,359,581 | 1,388,647 | 1,778,822.69 | 1,900,587.70 | 2,030,687.83 | 2,169,693.65 | 2,318,214.78 |
Account Receivables (%) | ||||||||||
Inventories | - | - | - | - | - | - | - | - | - | - |
Inventories (%) | ||||||||||
Accounts Payable | 348,036 | 393,575 | 523,070 | 335,285 | 459,426 | 491,322.14 | 524,954.41 | 560,888.89 | 599,283.18 | 640,305.66 |
Accounts Payable (%) | ||||||||||
Capital Expenditure | -87,155 | -82,952 | -65,716 | -67,675 | -46,170 | -85,394.91 | -91,240.41 | -97,486.05 | -104,159.23 | -111,289.19 |
Capital Expenditure (%) |
Weighted Average Cost Of Capital
Share price | $ 3.51 |
---|---|
Beta | 0.771 |
Diluted Shares Outstanding | 79.87 |
Cost of Debt | |
Tax Rate | 30.23 |
After-tax Cost of Debt | 4.19% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 7.245 |
Total Debt | 11,839,242 |
Total Equity | 280.33 |
Total Capital | 11,839,522.33 |
Debt Weighting | 100.00 |
Equity Weighting | 0.00 |
Wacc |
Build Up Free Cash
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
Revenue | 1,056,518 | 1,221,953 | 1,222,555.99 | 1,010,627.99 | 1,303,790.99 | 1,393,038.85 | 1,488,395.95 | 1,590,280.49 | 1,699,139.30 | 1,815,449.76 |
---|---|---|---|---|---|---|---|---|---|---|
EBITDA | 960,141.99 | 1,176,861 | 1,161,925.01 | -114,313 | 1,201,819.01 | 1,011,614.11 | 1,080,861.71 | 1,154,849.48 | 1,233,901.91 | 1,318,365.68 |
EBIT | 878,296.99 | 1,090,044 | 1,034,759.01 | -240,757 | 1,100,236.01 | 884,691.88 | 945,251.32 | 1,009,956.21 | 1,079,090.32 | 1,152,956.83 |
Tax Rate | -581.34% | 26.75% | 34.05% | 14.08% | 30.23% | -95.25% | -95.25% | -95.25% | -95.25% | -95.25% |
EBIAT | 5,984,225.45 | 798,409.36 | 682,439.70 | -206,849 | 767,645.04 | 1,727,322.64 | 1,845,562.33 | 1,971,895.84 | 2,106,877.19 | 2,251,098.37 |
Depreciation | 81,845.01 | 86,817 | 127,166 | 126,444 | 101,583 | 126,922.24 | 135,610.39 | 144,893.27 | 154,811.59 | 165,408.84 |
Accounts Receivable | - | 151,341.99 | 37,830.01 | 97,856 | -29,066 | -390,175.69 | -121,765 | -130,100.13 | -139,005.82 | -148,521.13 |
Inventories | - | - | - | - | - | - | - | - | - | - |
Accounts Payable | - | 45,539 | 129,494.99 | -187,784.99 | 124,140.99 | 31,896.14 | 33,632.27 | 35,934.48 | 38,394.29 | 41,022.48 |
Capital Expenditure | -87,155 | -82,952 | -65,716 | -67,675 | -46,170 | -85,394.91 | -91,240.41 | -97,486.05 | -104,159.23 | -111,289.19 |
UFCF | 5,978,915.45 | 999,155.35 | 911,214.69 | -238,008.99 | 918,133.03 | 1,410,570.42 | 1,801,799.58 | 1,925,137.41 | 2,056,918.03 | 2,197,719.37 |
WACC | ||||||||||
PV UFCF | 1,353,844.34 | 1,659,794.82 | 1,702,094.30 | 1,745,471.78 | 1,789,954.73 | |||||
SUM PV UFCF | 8,251,159.97 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 4.19 |
Free cash flow (t + 1) | 2,241,673.76 |
Terminal Value | 102,359,532.47 |
Present Value of Terminal Value | 83,367,754.39 |
Intrinsic Value
Enterprise Value | 91,618,914.36 |
---|---|
Net Debt | 7,927,354 |
Equity Value | 83,691,560.36 |
Shares Outstanding | 79.87 |
Equity Value Per Share | 1,047,882.26 |