Discounted Cash Flow (DCF) Analysis Levered
Hasbro, Inc. (HAS)
$60.44
+0.37 (+0.62%)
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 | 4,579.65 | 4,720.23 | 5,465.44 | 6,420.40 | 5,856.70 | 6,260.08 | 6,691.25 | 7,152.11 | 7,644.72 | 8,171.25 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | 646 | 653.06 | 976.34 | 817.90 | 372.90 | 812.70 | 868.67 | 928.50 | 992.46 | 1,060.81 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -140.43 | -133.64 | -125.75 | -132.70 | -174.20 | -165.76 | -177.18 | -189.38 | -202.43 | -216.37 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | 505.57 | 519.43 | 850.59 | 685.20 | 198.70 | 646.94 | 691.50 | 739.12 | 790.03 | 844.44 |
Weighted Average Cost Of Capital
Share price | $ 60.44 |
---|---|
Beta | 0.721 |
Diluted Shares Outstanding | 138.90 |
Cost of Debt | |
Tax Rate | 22.18 |
After-tax Cost of Debt | 3.32% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 7.101 |
Total Debt | 4,006.40 |
Total Equity | 8,395.12 |
Total Capital | 12,401.52 |
Debt Weighting | 32.31 |
Equity Weighting | 67.69 |
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 | 4,579.65 | 4,720.23 | 5,465.44 | 6,420.40 | 5,856.70 | 6,260.08 | 6,691.25 | 7,152.11 | 7,644.72 | 8,171.25 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | 646 | 653.06 | 976.34 | 817.90 | 372.90 | 812.70 | 868.67 | 928.50 | 992.46 | 1,060.81 |
Capital Expenditure | -140.43 | -133.64 | -125.75 | -132.70 | -174.20 | -165.76 | -177.18 | -189.38 | -202.43 | -216.37 |
Free Cash Flow | 505.57 | 519.43 | 850.59 | 685.20 | 198.70 | 646.94 | 691.50 | 739.12 | 790.03 | 844.44 |
WACC | ||||||||||
PV LFCF | 611.01 | 616.82 | 622.69 | 628.62 | 634.60 | |||||
SUM PV LFCF | 3,113.75 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 5.88 |
Free cash flow (t + 1) | 861.33 |
Terminal Value | 22,199.32 |
Present Value of Terminal Value | 16,682.84 |
Intrinsic Value
Enterprise Value | 19,796.59 |
---|---|
Net Debt | 3,507.80 |
Equity Value | 16,288.79 |
Shares Outstanding | 138.90 |
Equity Value Per Share | 117.27 |