WSM · NYQ · Consumer Cyclical
Williams-Sonoma, Inc.
Also onShortfallConsensus DriftCrosscheck
Implied value per share
USD 126.36
Market price
USD 259.45
Implied upside
-51.3%
10-year forecast · Perpetuity growth terminal value · Mid-year discounting · Base case · Price 2026-11-02 · Accounts to 2026-01-31
Value Per Share
Same forecast, different terminal treatment. Percentages vs price.
Forecast Cashflows
Reporting currency (USD). Outflows negative.
| Line | FY27 | FY28 | FY29 | FY30 | FY31 | FY32 | FY33 | FY34 | FY35 | FY36 | CAGR |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | USD 8.3bn | USD 8.7bn | USD 9.1bn | USD 9.5bn | USD 9.9bn | USD 10.3bn | USD 10.7bn | USD 11.0bn | USD 11.4bn | USD 11.6bn | +3.9% |
| EBIT | USD 1.4bn | USD 1.5bn | USD 1.6bn | USD 1.7bn | USD 1.7bn | USD 1.8bn | USD 1.9bn | USD 1.9bn | USD 2.0bn | USD 2.0bn | +3.9% |
| NOPAT | USD 1.1bn | USD 1.2bn | USD 1.3bn | USD 1.3bn | USD 1.4bn | USD 1.4bn | USD 1.5bn | USD 1.5bn | USD 1.6bn | USD 1.6bn | +3.9% |
| Add depreciation & amortisation | USD 236.0m | USD 248.4m | USD 260.6m | USD 272.4m | USD 283.9m | USD 294.9m | USD 305.3m | USD 315.0m | USD 324.0m | USD 332.1m | +3.9% |
| Less capital expenditure | USD -262.8m | USD -279.7m | USD -296.7m | USD -313.7m | USD -330.5m | USD -347.1m | USD -363.2m | USD -378.7m | USD -393.6m | USD -407.7m | +5.0% |
| Capex, % of revenue | 3.2% | 3.2% | 3.2% | 3.3% | 3.3% | 3.4% | 3.4% | 3.4% | 3.5% | 3.5% | - |
| Less increase in working capital | USD -52.5m | USD -49.0m | USD -48.2m | USD -47.1m | USD -45.5m | USD -43.6m | USD -41.2m | USD -38.5m | USD -35.5m | USD -32.1m | -5.3% |
| Free cashflow to firm | USD 1.1bn | USD 1.1bn | USD 1.2bn | USD 1.2bn | USD 1.3bn | USD 1.3bn | USD 1.4bn | USD 1.4bn | USD 1.5bn | USD 1.5bn | +3.9% |
| Discount factor | 0.9522 | 0.8635 | 0.7830 | 0.7100 | 0.6438 | 0.5837 | 0.5293 | 0.4800 | 0.4352 | 0.3946 | - |
| Present value | USD 1.0bn | USD 969.8m | USD 922.3m | USD 874.4m | USD 826.2m | USD 778.2m | USD 730.5m | USD 683.5m | USD 637.4m | USD 592.5m | - |
| Present Value Of The Forecast | USD 8.0bn | ||||||||||
Discount Rate
Source shown per component. All overridable above.
| Risk-free rate | 4.89% | US 10-year Treasury (^TNX), 2026-11-02 |
| Equity risk premium | 4.23% | Damodaran, January 2026 |
| Beta | 1.328 | Reported 1.490, pulled toward 1.0 (Blume) |
| Cost of equity | 10.51% | Risk-free + beta x equity risk premium |
| Cost of debt | 6.89% | Assumed: risk-free + 200bp (interest expense not reported) |
| Market capitalisation | USD 30.6bn | 95.4% of capital |
| Total debt | USD 1.5bn | 4.6% of capital, book value as a proxy |
| Tax rate | 21.0% | Effective, capped at statutory |
| WACC | 10.28% | E/V x Re + D/V x Rd x (1 - t) |
Terminal Value
Perpetuity growth is intrinsic. The exit multiple defaults to the company's current EV/EBITDA, so it answers a different question - what the shares are worth if today's rating holds and EBITDA grows as forecast.
Perpetuity growth at 2.50%
50% of EV
- Forecast FCFF, final year
- USD 1.5bn
- Capex at depreciation, working capital in reinvestment
- USD 1.6bn
- Less reinvestment at g/ROIC (4.7% of NOPAT)
- USD -75.6m
- Capitalised
- USD 1.5bn
- ROIC (reported)
- 53.2%
- Terminal value, undiscounted
- USD 20.2bn
- Terminal value, discounted
- USD 8.0bn
- Enterprise value
- USD 16.0bn
- Less net debt
- USD 437.1m
- Equity value
- USD 15.6bn
Exit at 18.8x EBITDA
69% of EV
- Terminal value, undiscounted
- USD 44.6bn
- Terminal value, discounted
- USD 17.6bn
- Enterprise value
- USD 25.6bn
- Less net debt
- USD 437.1m
- Equity value
- USD 25.2bn
Spread between methods: 47%.
Sensitivity
Value per share (USD) by discount rate and long-run growth.
| Long-run growth | |||||
|---|---|---|---|---|---|
| Discount rate | 1.50% | 2.00% | 2.50% | 3.00% | 3.50% |
| 8.28% | 157.24 | 163.55 | 171.00 | 179.91 | 190.74 |
| 9.28% | 136.28 | 140.50 | 145.38 | 151.07 | 157.79 |
| 10.28% | 120.14 | 123.05 | 126.36 | 130.16 | 134.56 |
| 11.28% | 107.33 | 109.38 | 111.70 | 114.32 | 117.30 |
| 12.28% | 96.92 | 98.40 | 100.04 | 101.89 | 103.97 |
Outlined: this model. Green text: above today's price of 259.45. Shading: distance from this model's own value.
Priced In
What each input would have to be to justify the current price, one at a time.
| Input | Actual | Model | Implied | Gap |
|---|---|---|---|---|
| Revenue growth, a year | -3.5% | 4.1% | 13.3% | |
| EBIT margin | 18.5% | 17.5% | 35.0% | |
| Discount rate | - | 10.3% | 6.3% |
Live formulas, not pasted numbers - edit a driver and the workbook reprices.
Yahoo Finance and RBA data. General information, not advice. Methodology.