DCF Tool

WSM

Williams-Sonoma, Inc. – All Other Home Furnishings Stores
founded in 1956, williams-sonoma, inc. is the premier specialty retailer of high-quality products for the kitchen and home in the united states. our family of brands are williams-sonoma, pottery barn, pottery barn kids, pbteen, west elm, williams-sonoma home, rejuvenation, and mark and graham. these brands are among the best known and most respected in the industry. we offer beautifully-designed, stylish and functional products for every area of the home, including the kitchen, living room, bedroom, home office, closet, laundry room and even outdoor spaces. we've seen some big changes since our first brick-and-mortar store opened more than half of a century ago. what hasn't changed is our passion for high-quality products, functional design, outstanding customer service, and enhancing the lives of our customers and the communities where we operate. today, we're a multi-brand, multi-channel, global enterprise supported by state-of-the-art technology and some of the most talented teams i
Analysis Results
Intrinsic Value $850.79
Latest Price $157.18
Relative Value 82% undervalued
Thoughts on this result? Let us know.
Ad
Cash Flow (Billions)
Analysis Parameters
%
%
%
New Ticker
Ad
Analysis Details
Growth Rate Projection

An exponential growth model was fit to the past cash flow data, giving more weight to more recent years. This model determined a growth rate estimate of 36.5%.

Weighted Average Cost of Capital (WACC)

The calculated WACC is 10.4%. This value is used as the default discount rate.

Value of Future Flows

Assuming a growth rate of 36.5%, the cash flows for the next 5 years are projected.

The present value of each year's flow is adjusted to present value using the discount rate.

Year Future flow (billion) Present value (billion)
2024 1.78 1.61
2025 2.43 2.0
2026 3.32 2.47
2027 4.54 3.06
2028 6.19 3.78
Terminal Value

Assuming a growth rate after the projection years of 2.0%, the terminal value of the company would be 75.4 billion. This corresponds to a present value of 41.7 billion.

Intrinsic Value Per Share

The total present value of the projected cash flows is 12.9 billion. Adding in the terminal value gives a total present value of 54.6 billion.

There are presently 64.1 million outstanding shares, so the intrinsic value per share is 850.79.

Financial Statements

The following data was to determine the past cash flows.

Current Assets 2,036,080,000
Current Cash 367,344,000
Current Liabilities 1,636,451,000
Current Debt 0
Non-Cash Working Capital (NCWC) 32,285,000
Change in NCWC 330,415,000
EBIT 1,498,422,000
Tax Provision 372,778,000
Depreciation and Amortization 214,153,000
Capital Expenditure -354,117,000
Unlevered Free Cash Flow 1,316,656,396
Current Assets 2,323,894,000
Current Cash 850,338,000
Current Liabilities 1,771,686,000
Current Debt 0
Non-Cash Working Capital (NCWC) -298,130,000
Change in NCWC -16,223,000
EBIT 1,453,116,000
Tax Provision 324,914,000
Depreciation and Amortization 196,087,000
Capital Expenditure -226,517,000
Unlevered Free Cash Flow 1,081,131,453
Current Assets 2,467,080,000
Current Cash 1,200,337,000
Current Liabilities 1,848,000,000
Current Debt 299,350,000
Non-Cash Working Capital (NCWC) -281,907,000
Change in NCWC -295,643,000
EBIT 910,697,000
Tax Provision 213,752,000
Depreciation and Amortization 188,655,000
Capital Expenditure -169,513,000
Unlevered Free Cash Flow 416,565,251
Current Assets 1,755,635,000
Current Cash 432,162,000
Current Liabilities 1,609,555,000
Current Debt 299,818,000
Non-Cash Working Capital (NCWC) 13,736,000
Change in NCWC -266,841,000
EBIT 465,874,000
Tax Provision 100,959,000
Depreciation and Amortization 187,759,000
Capital Expenditure -186,276,000
Unlevered Free Cash Flow 97,601,313
Current Assets 1,694,343,000
Current Cash 338,954,000
Current Liabilities 1,074,812,000
Current Debt 0
Non-Cash Working Capital (NCWC) 280,577,000
Change in NCWC 42,091,000
EBIT 435,953,000
Tax Provision 95,563,000
Depreciation and Amortization 188,808,000
Capital Expenditure -190,102,000
Unlevered Free Cash Flow 379,694,047
Current Assets 1,636,445,000
Current Cash 390,136,000
Current Liabilities 1,007,823,000
Current Debt 0
Non-Cash Working Capital (NCWC) 238,486,000
Change in NCWC 46,275,000
EBIT 453,811,000
Tax Provision 192,894,000
Depreciation and Amortization 183,077,000
Capital Expenditure -189,712,000
Unlevered Free Cash Flow 299,972,058
Current Assets 1,367,180,000
Current Cash 213,713,000
Current Liabilities 961,256,000
Current Debt 0
Non-Cash Working Capital (NCWC) 192,211,000
Change in NCWC 46,185,000
EBIT 472,599,000
Tax Provision 166,524,000
Depreciation and Amortization 173,195,000
Capital Expenditure -197,414,000
Unlevered Free Cash Flow 327,798,224
Current Assets 1,336,100,000
Current Cash 193,647,000
Current Liabilities 996,427,000
Current Debt 0
Non-Cash Working Capital (NCWC) 146,026,000
Change in NCWC -148,990,000
EBIT 488,634,000
Tax Provision 177,939,000
Depreciation and Amortization 167,760,000
Capital Expenditure -202,935,000
Unlevered Free Cash Flow 126,301,380
Current Assets 1,391,923,000
Current Cash 222,927,000
Current Liabilities 875,948,000
Current Debt 1,968,000
Non-Cash Working Capital (NCWC) 295,016,000
Change in NCWC 65,345,000
EBIT 502,265,000
Tax Provision 193,349,000
Depreciation and Amortization 162,273,000
Capital Expenditure -204,800,000
Unlevered Free Cash Flow 331,710,129
Current Assets 1,419,103,000
Current Cash 330,121,000
Current Liabilities 861,096,000
Current Debt 1,785,000
Non-Cash Working Capital (NCWC) 229,671,000
Change in NCWC -7,143,000
EBIT 452,098,000
Tax Provision 173,780,000
Depreciation and Amortization 149,795,000
Capital Expenditure -193,953,000
Unlevered Free Cash Flow 227,241,191
Current Assets 1,316,772,000
Current Cash 424,555,000
Current Liabilities 657,127,000
Current Debt 1,724,000
Non-Cash Working Capital (NCWC) 236,814,000
Change in NCWC 33,209,000
EBIT 409,163,000
Tax Provision 153,226,000
Depreciation and Amortization 134,453,000
Capital Expenditure -205,404,000
Unlevered Free Cash Flow 218,491,393

This analysis is provided for informational purposes only and does not constitute financial or investing advice. For more information on the advantages and limitations of DCF analysis see background. This information is provided on an "as is" basis. No warranty, expressed or implied, is made regarding accuracy, adequacy, completeness, legality, reliability or usefulness of any information. By using this site you agree that under no circumstances shall Valuation Tools LLC be held liable for any loss or damage caused by information obtained from this website including any articles, data, videos, its social media accounts, or any other materials.