Discounted Cash Flow (DCF) Analysis Unlevered
Carnival Corporation & plc (CUK)
$9.62
-0.53 (-5.22%)
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 | 17,510 | 18,881 | 20,825 | 5,594 | 1,908 | 1,331.29 | 928.89 | 648.12 | 452.22 | 315.53 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||
| EBITDA | 4,710 | 5,417 | 5,427 | -7,117 | -5,688 | -915.10 | -638.50 | -445.51 | -310.85 | -216.89 |
| EBITDA (%) | ||||||||||
| EBIT | 2,864 | 3,400 | 3,267 | -9,358 | -7,921 | -1,417.50 | -989.05 | -690.10 | -481.51 | -335.97 |
| EBIT (%) | ||||||||||
| Depreciation | 1,846 | 2,017 | 2,160 | 2,241 | 2,233 | 502.41 | 350.55 | 244.59 | 170.66 | 119.08 |
| 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 | 395 | 982 | 518 | 9,513 | 9,139 | 1,754.60 | 1,224.25 | 854.21 | 596.01 | 415.86 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | - | - | - | - | - | - | - | - | - | - |
| Account Receivables (%) | ||||||||||
| Inventories | 387 | 450 | 427 | 335 | 356 | 83.31 | 58.13 | 40.56 | 28.30 | 19.75 |
| Inventories (%) | ||||||||||
| Accounts Payable | 762 | 730 | 756 | 624 | 797 | 172.47 | 120.34 | 83.96 | 58.59 | 40.88 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -2,944 | -3,749 | -5,429 | -3,620 | -3,607 | -842.70 | -587.98 | -410.26 | -286.25 | -199.73 |
| Capital Expenditure (%) |
Weighted Average Cost Of Capital
| Share price | $ 9.62 |
|---|---|
| Beta | 2.091 |
| Diluted Shares Outstanding | 1,123 |
| Cost of Debt | |
| Tax Rate | 0.22 |
| After-tax Cost of Debt | 4.62% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 12.765 |
| Total Debt | 34,607 |
| Total Equity | 10,803.26 |
| Total Capital | 45,410.26 |
| Debt Weighting | 76.21 |
| Equity Weighting | 23.79 |
| 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 | 17,510 | 18,881 | 20,825 | 5,594 | 1,908 | 1,331.29 | 928.89 | 648.12 | 452.22 | 315.53 |
|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 4,710 | 5,417 | 5,427 | -7,117 | -5,688 | -915.10 | -638.50 | -445.51 | -310.85 | -216.89 |
| EBIT | 2,864 | 3,400 | 3,267 | -9,358 | -7,921 | -1,417.50 | -989.05 | -690.10 | -481.51 | -335.97 |
| Tax Rate | 2.25% | 1.71% | 2.29% | 0.17% | 0.22% | 1.33% | 1.33% | 1.33% | 1.33% | 1.33% |
| EBIAT | 2,799.54 | 3,341.69 | 3,192.26 | -9,342.48 | -7,903.53 | -1,398.68 | -975.92 | -680.93 | -475.12 | -331.51 |
| Depreciation | 1,846 | 2,017 | 2,160 | 2,241 | 2,233 | 502.41 | 350.55 | 244.59 | 170.66 | 119.08 |
| Accounts Receivable | - | - | - | - | - | - | - | - | - | - |
| Inventories | - | -63 | 23 | 92 | -21 | 272.69 | 25.18 | 17.57 | 12.26 | 8.55 |
| Accounts Payable | - | -32 | 26 | -132 | 173 | -624.53 | -52.13 | -36.37 | -25.38 | -17.71 |
| Capital Expenditure | -2,944 | -3,749 | -5,429 | -3,620 | -3,607 | -842.70 | -587.98 | -410.26 | -286.25 | -199.73 |
| UFCF | 1,701.54 | 1,514.69 | -27.74 | -10,761.48 | -9,125.53 | -2,090.82 | -1,240.30 | -865.40 | -603.83 | -421.31 |
| WACC | ||||||||||
| PV UFCF | -1,962.11 | -1,092.29 | -715.21 | -468.31 | -306.64 | |||||
| SUM PV UFCF | -4,544.57 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 6.56 |
| Free cash flow (t + 1) | -429.74 |
| Terminal Value | -9,424.13 |
| Present Value of Terminal Value | -6,859.15 |
Intrinsic Value
| Enterprise Value | -11,403.71 |
|---|---|
| Net Debt | 25,668 |
| Equity Value | -37,071.71 |
| Shares Outstanding | 1,123 |
| Equity Value Per Share | -33.01 |