Discounted Cash Flow (DCF) Analysis Levered
Weyerhaeuser Company (WY)
$30.51
-0.52 (-1.68%)
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 | 7,476 | 6,554 | 7,532 | 10,201 | 10,184 | 11,147.87 | 12,202.97 | 13,357.92 | 14,622.19 | 16,006.11 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | 1,112 | 966 | 1,529 | 3,159 | 2,832 | 2,423.31 | 2,652.66 | 2,903.73 | 3,178.55 | 3,479.39 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -427 | -384 | -706 | -590 | -763 | -762.96 | -835.17 | -914.21 | -1,000.74 | -1,095.45 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | 685 | 582 | 823 | 2,569 | 2,069 | 1,660.35 | 1,817.50 | 1,989.51 | 2,177.81 | 2,383.93 |
Weighted Average Cost Of Capital
Share price | $ 30.51 |
---|---|
Beta | 1.537 |
Diluted Shares Outstanding | 742.95 |
Cost of Debt | |
Tax Rate | 18.44 |
After-tax Cost of Debt | 4.36% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 11.850 |
Total Debt | 5,053 |
Total Equity | 22,667.50 |
Total Capital | 27,720.50 |
Debt Weighting | 18.23 |
Equity Weighting | 81.77 |
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 | 7,476 | 6,554 | 7,532 | 10,201 | 10,184 | 11,147.87 | 12,202.97 | 13,357.92 | 14,622.19 | 16,006.11 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | 1,112 | 966 | 1,529 | 3,159 | 2,832 | 2,423.31 | 2,652.66 | 2,903.73 | 3,178.55 | 3,479.39 |
Capital Expenditure | -427 | -384 | -706 | -590 | -763 | -762.96 | -835.17 | -914.21 | -1,000.74 | -1,095.45 |
Free Cash Flow | 685 | 582 | 823 | 2,569 | 2,069 | 1,660.35 | 1,817.50 | 1,989.51 | 2,177.81 | 2,383.93 |
WACC | ||||||||||
PV LFCF | 1,502.85 | 1,489.04 | 1,475.35 | 1,461.79 | 1,448.36 | |||||
SUM PV LFCF | 7,377.39 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 10.48 |
Free cash flow (t + 1) | 2,431.61 |
Terminal Value | 28,674.66 |
Present Value of Terminal Value | 17,421.27 |
Intrinsic Value
Enterprise Value | 24,798.67 |
---|---|
Net Debt | 3,472 |
Equity Value | 21,326.67 |
Shares Outstanding | 742.95 |
Equity Value Per Share | 28.71 |