Discounted Cash Flow (DCF) Analysis Unlevered

The J. M. Smucker Company (SJM)

$154.69

+3.60 (+2.38%)
All numbers are in Millions, Currency in USD
Stock DCF: 487.68 | 154.69 | undervalue

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 7,357.107,8387,8018,002.707,998.908,170.938,346.658,526.168,709.538,896.84
Revenue (%)
EBITDA 1,448.201,355.801,662.401,801.501,463.801,619.531,654.361,689.941,726.291,763.41
EBITDA (%)
EBIT 1,035.10909.501,215.901,3491,004.701,154.991,179.831,205.201,231.121,257.60
EBIT (%)
Depreciation 413.10446.30446.50452.50459.10464.54474.53484.74495.16505.81
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 192.60101.30391.10334.30169.90248.81254.16259.62265.21270.91
Total Cash (%)
Account Receivables 385.60503.80551.40533.70524.70522.38533.62545.09556.81568.79
Account Receivables (%)
Inventories 854.40910.30895.30959.901,089.30985.691,006.891,028.541,050.661,073.26
Inventories (%)
Accounts Payable 512.105917821,034.101,193.30855.75874.15892.95912.16931.77
Accounts Payable (%)
Capital Expenditure -321.90-359.80-269.30-306.70-417.50-350.86-358.40-366.11-373.98-382.03
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 154.69
Beta 0.214
Diluted Shares Outstanding 108.40
Cost of Debt
Tax Rate 25.14
After-tax Cost of Debt 2.61%
Risk-Free Rate
Market Risk Premium
Cost of Equity 4.388
Total Debt 4,606.90
Total Equity 16,768.40
Total Capital 21,375.30
Debt Weighting 21.55
Equity Weighting 78.45
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 7,357.107,8387,8018,002.707,998.908,170.938,346.658,526.168,709.538,896.84
EBITDA 1,448.201,355.801,662.401,801.501,463.801,619.531,654.361,689.941,726.291,763.41
EBIT 1,035.10909.501,215.901,3491,004.701,154.991,179.831,205.201,231.121,257.60
Tax Rate -55.47%26.68%24.08%25.22%25.14%9.13%9.13%9.13%9.13%9.13%
EBIAT 1,609.27666.83923.151,008.73752.161,049.541,072.121,095.171,118.731,142.79
Depreciation 413.10446.30446.50452.50459.10464.54474.53484.74495.16505.81
Accounts Receivable --118.20-47.6017.7092.32-11.23-11.48-11.72-11.98
Inventories --55.9015-64.60-129.40103.61-21.20-21.65-22.12-22.60
Accounts Payable -78.90191252.10159.20-337.5518.4018.8019.2019.62
Capital Expenditure -321.90-359.80-269.30-306.70-417.50-350.86-358.40-366.11-373.98-382.03
UFCF 1,700.47658.131,258.751,359.73832.56931.611,174.221,199.471,225.271,251.62
WACC
PV UFCF 895.691,085.421,066.021,046.961,028.24
SUM PV UFCF 5,122.33

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 4.01
Free cash flow (t + 1) 1,276.65
Terminal Value 63,514.86
Present Value of Terminal Value 52,179.50

Intrinsic Value

Enterprise Value 57,301.82
Net Debt 4,437
Equity Value 52,864.82
Shares Outstanding 108.40
Equity Value Per Share 487.68