Discounted Cash Flow (DCF) Analysis Unlevered

Sealed Air Corporation (SEE)

$40.1

-0.12 (-0.30%)
All numbers are in Millions, Currency in USD
Stock DCF: 66.59 | 40.1 | undervalue

Operating Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 4,791.104,903.205,533.805,641.905,964.516,305.566,666.127,047.297,450.267,876.27
Revenue (%)
EBITDA 674.501,003.801,0861,076.501,092.341,154.801,220.831,290.641,364.441,442.46
EBITDA (%)
EBIT 523.70829.60899.60891.90893.41944.50998.501,055.601,115.961,179.77
EBIT (%)
Depreciation 150.80174.20186.40184.60198.93210.30222.33235.04248.48262.69
Depreciation (%)

Balance Sheet Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Total Cash 262.40548.70561456.10303.10504.08532.90563.38595.59629.65
Total Cash (%)
Account Receivables 669.60681.70732.80696.60576.30796.15841.67889.80940.68994.46
Account Receivables (%)
Inventories 570.30596.70725.70866.30961.70865.95915.46967.811,023.151,081.65
Inventories (%)
Accounts Payable 738.50754.20959.90865.60826.30975.321,031.091,090.051,152.371,218.27
Accounts Payable (%)
Capital Expenditure -189.70-181.10-213.10-237.30-234.25-247.65-261.81-276.78-292.61-309.34
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 40.1
Beta 1.244
Diluted Shares Outstanding 147.40
Cost of Debt
Tax Rate 32.59
After-tax Cost of Debt 3.37%
Risk-Free Rate
Market Risk Premium
Cost of Equity 9.683
Total Debt 4,915.40
Total Equity 5,910.74
Total Capital 10,826.14
Debt Weighting 45.40
Equity Weighting 54.60
Wacc

Build Up Free Cash

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 4,791.104,903.205,533.805,641.905,964.516,305.566,666.127,047.297,450.267,876.27
EBITDA 674.501,003.801,0861,076.501,092.341,154.801,220.831,290.641,364.441,442.46
EBIT 523.70829.60899.60891.90893.41944.50998.501,055.601,115.961,179.77
Tax Rate 28.98%19.69%29.24%32.59%27.62%27.62%27.62%27.62%27.62%27.62%
EBIAT 371.95666.25636.58601.20646.61683.59722.67764807.68853.87
Depreciation 150.80174.20186.40184.60198.93210.30222.33235.04248.48262.69
Accounts Receivable --12.10-51.1036.20120.30-219.85-45.52-48.13-50.88-53.79
Inventories --26.40-129-140.60-95.4095.75-49.52-52.35-55.34-58.50
Accounts Payable -15.70205.70-94.30-39.30149.0255.7758.9662.3365.89
Capital Expenditure -189.70-181.10-213.10-237.30-234.25-247.65-261.81-276.78-292.61-309.34
UFCF 333.05636.55635.48349.80596.88671.16643.92680.74719.67760.82
WACC
PV UFCF 596.88628.31564.32558.50552.74547.04
SUM PV UFCF 2,850.91

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 6.82
Free cash flow (t + 1) 776.03
Terminal Value 16,100.27
Present Value of Terminal Value 11,576.31

Intrinsic Value

Enterprise Value 14,427.23
Net Debt 4,612.30
Equity Value 9,814.93
Shares Outstanding 147.40
Equity Value Per Share 66.59