Discounted Cash Flow (DCF) Analysis Unlevered

Cameco Corporation (CCJ)

$26.17

-0.07 (-0.27%)
All numbers are in Millions, Currency in USD
Stock DCF: 11.02 | 26.17 | overvalue

Operating Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 2,091.661,862.931,800.071,474.981,8681,841.271,814.931,788.961,763.361,738.13
Revenue (%)
EBITDA 464.71494.75226.90147.35331.33328.14323.45318.82314.26309.76
EBITDA (%)
EBIT 136.7421918.24-43.07153.9590.6989.4088.1286.8685.61
EBIT (%)
Depreciation 327.97275.75208.66190.42177.38237.45234.05230.70227.40224.15
Depreciation (%)

Balance Sheet Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 1,102.551,062.43943.371,332.352,042.851,332.491,313.421,294.631,276.111,257.85
Total Cash (%)
Account Receivables 423.17338.28231.88304.34217.18307.61303.21298.87294.59290.37
Account Receivables (%)
Inventories 557406.27769.80504.86822.61624.07615.14606.34597.67589.11
Inventories (%)
Accounts Payable 124.39100.41137.19213.38249.96172.36169.90167.47165.07162.71
Accounts Payable (%)
Capital Expenditure -55.36-75.21-77.46-98.78-143.45-93.40-92.07-90.75-89.45-88.17
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 26.17
Beta 0.949
Diluted Shares Outstanding 407.13
Cost of Debt
Tax Rate -5.41
After-tax Cost of Debt 6.92%
Risk-Free Rate
Market Risk Premium
Cost of Equity 7.974
Total Debt 997
Total Equity 10,654.72
Total Capital 11,651.72
Debt Weighting 8.56
Equity Weighting 91.44
Wacc

Build Up Free Cash

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 2,091.661,862.931,800.071,474.981,8681,841.271,814.931,788.961,763.361,738.13
EBITDA 464.71494.75226.90147.35331.33328.14323.45318.82314.26309.76
EBIT 136.7421918.24-43.07153.9590.6989.4088.1286.8685.61
Tax Rate -316.55%45.19%-34.50%1.23%-5.41%-62.01%-62.01%-62.01%-62.01%-62.01%
EBIAT 569.57120.0324.53-42.54162.28146.93144.83142.76140.71138.70
Depreciation 327.97275.75208.66190.42177.38237.45234.05230.70227.40224.15
Accounts Receivable -84.90106.40-72.4687.16-90.434.404.344.284.22
Inventories -150.73-363.52264.93-317.75198.548.938.808.688.55
Accounts Payable --23.9836.7876.1936.59-77.60-2.47-2.43-2.40-2.36
Capital Expenditure -55.36-75.21-77.46-98.78-143.45-93.40-92.07-90.75-89.45-88.17
UFCF 842.18532.21-64.61317.762.20321.48297.67293.42289.22285.08
WACC
PV UFCF 298255.78233.70213.53195.10
SUM PV UFCF 1,196.11

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 7.88
Free cash flow (t + 1) 290.78
Terminal Value 4,945.24
Present Value of Terminal Value 3,384.41

Intrinsic Value

Enterprise Value 4,580.52
Net Debt 92.33
Equity Value 4,488.19
Shares Outstanding 407.13
Equity Value Per Share 11.02