# Williams-Sonoma (WSM) Financial Model Free Excel 3-statement financial model and company analysis for Williams-Sonoma. - Canonical: https://finamodel.com/companies/williams-sonoma - Industry: Retail - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/WSM.xlsx ## Model Purpose This model evaluates Williams-Sonoma, Inc.'s equity valuation and cash flow generation capacity to determine if the company can sustain its high operating margins, fund aggressive share repurchase programmes, and maintain dividend growth amidst a volatile macroeconomic environment and housing market headwinds. ## Company Overview Williams-Sonoma, Inc. is an omni-channel specialty retailer of high-quality products for the home. The company designs, sources, and sells furniture, homewares, and decorative accessories through its e-commerce platforms, direct-mail catalogues, and retail stores. Business segments (based on FY2024 revenue contribution): * Pottery Barn (~39.4%) * West Elm (~23.9%) * Williams Sonoma (~16.9%) * Pottery Barn Kids and Teen (~14.4%) * Other (Rejuvenation, Mark and Graham, B2B, International Franchise) (~5.4%) Key geographies: Primarily the United States, with international operations and franchise agreements in Canada, Australia, the UK, and the Middle East. Business model type: Omni-channel retail with a highly profitable, asset-light e-commerce engine (historically driving over 65% of total revenues) complemented by a strategic physical store fleet. Competitive position: A market leader in premium home furnishings, competing with RH, Wayfair, Crate & Barrel, and Arhaus. Recent major events: Fiscal 2024 (ended 2 February 2025) included a 53rd week which contributed 150 basis points to revenue growth. The company has aggressively expanded its B2B division and positioned Rejuvenation as its next billion-dollar brand. ## Revenue Deep Dive For EACH revenue segment: * **Pottery Barn** * Revenue driver formula: E-commerce Traffic x Conversion Rate x Average Order Value (AOV) + Retail Square Footage x Sales per Square Foot. * Historical growth rate: Ranged from -5% to +15% over the last 3 years (declined slightly in FY2024 to $3.04 billion due to furniture hesitancy). * Key growth levers and headwinds: Macroeconomic housing turnover, interest rates, and success of new aesthetic collections. * Pricing dynamics: Premium pricing with a focus on full-price selling and reduced promotional activity. * Revenue recognition notes: Recognised upon delivery to the customer. * Seasonality: Highly seasonal, peaking in Q4 (holiday season). * **West Elm** * Revenue driver formula: Omni-channel Customer Count x Annual Spend per Customer. * Historical growth rate: Highly volatile, ranging from -8% to +18% (FY2024 revenue of $1.84 billion). * Key growth levers and headwinds: Millennial household formation, urban apartment turnover, and lighting/hardware category expansion. * Pricing dynamics: Mid-to-premium tier, highly sensitive to macroeconomic shocks. * Revenue recognition notes: Deferred revenue held for custom furniture orders until delivery. * Seasonality: Strong Q4, though slightly less holiday-dependent than the Williams Sonoma brand. * **Williams Sonoma** * Revenue driver formula: Active Customers x Transaction Frequency x AOV. * Historical growth rate: Low single digits (FY2024 revenue of $1.30 billion). * Key growth levers and headwinds: Kitchenware replacement cycles, holiday hosting trends, and exclusive brand collaborations. * Pricing dynamics: Premium, highly resilient customer base. * Revenue recognition notes: Standard delivery recognition. * Seasonality: Massive Q4 spike due to holiday gifting and entertaining. * **Pottery Barn Kids and Teen** * Revenue driver formula: Target Demographic Population x Market Penetration x AOV. * Historical growth rate: Flat to low single digits (FY2024 revenue of $1.11 billion). * Key growth levers and headwinds: Birth rates, back-to-school seasons, and dorm room furnishing trends. * Pricing dynamics: Premium pricing for juvenile furniture. * Revenue recognition notes: Standard delivery recognition. * Seasonality: Peaks in Q3 (back-to-school) and Q4 (holidays). * **Other (Rejuvenation, Mark and Graham, B2B, Franchise)** * Revenue driver formula: B2B Contract Volume + Franchise Royalties + Emerging Brand Sales. * Historical growth rate: Double-digit growth (FY2024 revenue of $421 million). * Key growth levers and headwinds: Corporate office remodels, hospitality contracts, and Rejuvenation store expansion. * Pricing dynamics: Contractual pricing for B2B, premium spot pricing for retail. * Revenue recognition notes: Franchise revenue recognised as royalties based on partner sales. * Seasonality: Less seasonal due to B2B project timelines. ## Cost Structure ### Variable Costs / COGS * Line-by-line breakdown: Merchandise costs, inbound freight, outbound shipping fees, inventory shrinkage, and occupancy costs (rent, depreciation, and common area maintenance for stores and distribution centres). * Gross margin range: 42.0% to 47.3% (hit 47.3% in Q4 FY2024). * Key input costs and commodity exposures: Ocean freight rates, raw materials (wood, cotton), and Asian manufacturing labour costs. * How COGS scales with revenue: Merchandise and shipping are highly variable. Occupancy costs are fixed, creating operating leverage when comparable sales are positive and deleverage when negative. ### Operating Expenses * R&D: Not explicitly reported (product design costs sit in SG&A). * SG&A: Breakdown includes employment costs, advertising (primarily digital marketing and catalogue costs), and general corporate expenses. * Depreciation & Amortisation: Sits partially in COGS (supply chain and stores) and partially in SG&A (corporate IT). * Stock-Based Compensation: Typically 0.5% to 1.0% of revenue. * Restructuring / one-time charges: Infrequent, though occasional supply chain optimisation charges occur. ### Margin Profile * Gross margin: 42% to 47% (expanding due to full-price selling and supply chain efficiencies). * EBITDA margin: 18% to 22%. * Operating margin: 16% to 18.6% (record 18.6% in FY2024). * Net margin: 11% to 13%. * Margin trend: Expanding significantly over the last 5 years due to a structural shift towards e-commerce, reduced promotions, and B2B growth. ## Balance Sheet Structure * Total assets: Approximately $4.5 billion to $5.0 billion. * Key asset categories: Cash and cash equivalents, Merchandise inventories, Operating lease right-of-use assets, and Property and equipment. * Goodwill & intangibles as % of total assets: Very low (under 5%), as the company builds brands organically rather than through acquisitions. * Working capital profile: * Days Sales Outstanding (DSO): 5 to 10 days (mostly credit card receivables). * Days Inventory Outstanding (DIO): 100 to 130 days (furniture requires long lead times). * Days Payable Outstanding (DPO): 50 to 70 days. * Net working capital as % of revenue: Typically low or slightly negative. * Is working capital positive or negative? The company frequently operates with negative working capital, funding operations through deferred revenue (customer deposits for custom furniture) and high payables. * PP&E: Primarily distribution centre equipment, store build-outs, and corporate IT infrastructure. * Right-of-use assets / operating leases: Highly material, typically exceeding $1.0 billion due to the physical retail fleet. ## Capital Expenditure & Investment * Capex as % of revenue: 2.5% to 3.5% (FY2024 capex was $222 million on $7.71 billion revenue). * Maintenance capex vs. growth capex: Approximately 40% maintenance (store refreshes) and 60% growth (technology, e-commerce platforms, and supply chain automation). * Major capex programmes underway: Expanding the Rejuvenation store footprint and upgrading regional distribution hubs to reduce out-of-market shipments. * Capitalised software / development costs: Material component of capex due to the proprietary e-commerce technology stack. * M&A pattern: Organic grower. The company rarely acquires (Rejuvenation was a rare historical bolt-on). ## Debt & Capital Structure * Total debt: Effectively zero long-term traditional debt. The balance sheet liabilities are dominated by operating lease obligations. * Debt/EBITDA ratio: Near 0.0x (excluding operating leases). * Credit rating: Investment grade profile, though often unrated due to lack of bond issuance. * Key debt instruments: An unsecured revolving credit facility used primarily for seasonal working capital needs (often undrawn at year-end). * Maturity profile: N/A for traditional debt. * Interest rate profile: Minimal interest expense. * Covenants: Standard fixed charge coverage ratios tied to the revolver. * Share repurchase programme: Highly active. The company repurchased $807 million in stock in FY2024 and has a new $1 billion authorisation. * Dividend policy: Consistent grower. Paid $280 million in FY2024. The quarterly dividend was recently increased by 16% to $0.66 per share ($2.64 annualised). ## Cash Flow Characteristics * Operating cash flow conversion: Extremely strong, typically 1.2x to 1.5x Net Income ($1.4 billion OCF in FY2024). * Free cash flow margin: 12% to 15% of revenue. * Major non-cash items: Depreciation, stock-based compensation, and operating lease amortisation. * Working capital cash flow impact: Customer deposits (deferred revenue) act as a major source of cash during periods of growing order backlogs. * Capex intensity: Low (under 3.5% of revenue), allowing for massive free cash flow generation. * Cash tax rate vs. GAAP effective tax rate: Cash taxes closely track the GAAP effective tax rate of approximately 24% to 26%. ## Sheet Structure 1. **Assumptions**: Hardcoded drivers for macroeconomic inputs, segment growth rates, margin profiles, tax rates, and capital return policies. 2. **Revenue & Comps**: Detailed build of revenue by the five reported segments (Pottery Barn, West Elm, Williams Sonoma, PB Kids and Teen, Other). Includes adjustments for 52 vs 53-week years. 3. **Income Statement**: Consolidated P&L mirroring the 10-K. Crucially, occupancy costs must be modelled within Cost of Goods Sold, not SG&A. 4. **Balance Sheet**: Standard asset and liability line items, highlighting Merchandise Inventories, Deferred Revenue (Customer Deposits), and Operating Lease Right-of-Use Assets. 5. **Cash Flow Statement**: Indirect method starting from Net Income, adjusting for D&A, lease expenses, and working capital changes (specifically calling out deferred revenue). 6. **Working Capital & Capex**: Schedules for DSO, DIO, DPO, and a PP&E roll-forward split by technology, supply chain, and store investments. 7. **Lease Schedule**: Roll-forward of operating lease assets and liabilities, calculating the implied interest and amortisation components. 8. **Shareholders Equity & Returns**: Tracks retained earnings, the $1 billion share repurchase authorisation depletion, and dividend payouts. 9. **DCF Valuation**: Unlevered free cash flow calculation, WACC derivation, and terminal value using a perpetual growth method. ## Key Financial Relationships 1. `Pottery Barn Revenue = Prior Year Pottery Barn Revenue * (1 + Pottery Barn Comp Growth)` 2. `Total Net Revenues = Sum of (Pottery Barn, West Elm, Williams Sonoma, PB Kids and Teen, Other Revenues)` 3. `Cost of Goods Sold = Merchandise Costs + Outbound Shipping + Occupancy Costs` 4. `Occupancy Costs = Fixed Store Rent + Store/DC Depreciation` 5. `Gross Profit = Total Net Revenues - Cost of Goods Sold` 6. `Gross Margin % = Gross Profit / Total Net Revenues` 7. `SG&A Expense = Total Net Revenues * SG&A Margin % (historically 25% to 28%)` 8. `Operating Income = Gross Profit - SG&A Expense` 9. `Ending Inventory = Prior Year Ending Inventory + Purchases - Merchandise COGS` 10. `Deferred Revenue (Customer Deposits) = Total Net Revenues * (Historical Deferred Revenue as % of Sales)` 11. `Free Cash Flow = Cash from Operations - Capital Expenditures` 12. `Shares Outstanding = Prior Period Shares - (Share Repurchase Spend / Average Share Price)` ## Cross-Sheet Dependencies * The **Assumptions** sheet feeds segment growth rates into the **Revenue & Comps** sheet. * The **Revenue & Comps** sheet drives the top line of the **Income Statement**. * The **Income Statement** generates Net Income, which flows to the top of the **Cash Flow Statement** and into Retained Earnings on the **Balance Sheet**. * Revenue figures drive working capital balances (Inventory, Receivables, Deferred Revenue) on the **Working Capital** sheet, which calculate the changes in working capital for the **Cash Flow Statement**. * The **Shareholders Equity & Returns** sheet calculates share repurchases and dividends, reducing cash on the **Balance Sheet** and updating the share count for EPS calculations on the **Income Statement**. * Circularity risk: Interest income on cash balances depends on the ending cash balance, which depends on Net Income, which includes interest income. A toggle switch for interest income circularity is required. ## Sign Convention * Revenues and income items are positive. * Expenses (COGS, SG&A, Interest, Taxes) are negative on the Income Statement. * Assets, Liabilities, and Equity balances are positive on the Balance Sheet. * On the Cash Flow Statement, cash inflows (e.g., Net Income, increases in payables) are positive, and cash outflows (e.g., Capex, share repurchases, dividends, increases in inventory) are negative. ## Things Most Likely to Go Wrong 1. "Fiscal 2024 contained 53 weeks, inflating revenue by 150 bps. The model must normalise FY2024 base revenue before applying FY2025 growth rates to avoid overestimating future sales." 2. "Occupancy costs are reported inside COGS. Moving rent or store depreciation to SG&A will artificially inflate Gross Margin and ruin comparability with historical filings." 3. "Shipping fees received from customers are classified as Revenue, while the actual cost to ship is in COGS. Do not net these against each other." 4. "Deferred revenue is a massive working capital driver. It represents cash collected for custom furniture before delivery. If revenue growth accelerates, deferred revenue must increase, acting as a cash source." 5. "The company operates with minimal traditional debt. Do not model a standard debt paydown schedule; focus instead on operating lease liabilities." 6. "Share repurchases are a primary use of cash. Failing to model the depletion of the $1 billion authorisation will result in an artificially bloated cash balance and understated EPS." 7. "Foreign currency translation is generally immaterial, but international franchise revenue in the 'Other' segment has different margin profiles than owned retail." 8. "Return on Invested Capital (ROIC) is exceptionally high (54% in FY2024). The model must accurately capture the low capital intensity of the e-commerce business to replicate this." ## Validation Checks 1. "Gross margin must remain between 42.0% and 47.5%. Flag if the model projects margins outside this historical band." 2. "Operating margin should stabilise between 16.0% and 19.0%. A result above 20% implies unrealistic permanent cost structure shifts." 3. "Capex as a % of revenue must be between 2.5% and 4.0%. The company is asset-light; flag if capex exceeds 5%." 4. "ROIC should consistently exceed 40%. Flag if it drops below 30% without a corresponding massive drop in operating profit." 5. "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every forecasted period." 6. "Free Cash Flow conversion (FCF / Net Income) should be near or above 1.0x. Flag if the model shows poor cash conversion." 7. "The effective tax rate should remain between 24% and 26% based on US statutory rates and historical performance." 8. "Dividend payout ratio should remain between 15% and 25% of Net Income, reflecting the stated policy of consistent dividend growth." ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Pottery Barn Revenue Growth | 1.5 | % | Assumes slight recovery from FY24 furniture hesitancy | | West Elm Revenue Growth | 2.0 | % | Rebound in urban/millennial housing turnover | | Williams Sonoma Revenue Growth | 2.5 | % | Steady growth driven by kitchenware replacement cycles | | PB Kids and Teen Revenue Growth | 1.5 | % | Stable demographic trends | | Other Segment Revenue Growth | 8.0 | % | Continued aggressive expansion of Rejuvenation and B2B | | Gross Margin | 46.0 | % | Blended rate reflecting full-price selling and supply chain efficiencies | | SG&A Margin | 27.5 | % | Reflects elevated digital marketing and performance-based compensation | | Effective Tax Rate | 24.5 | % | Historical average GAAP tax rate | | Days Sales Outstanding (DSO) | 7 | Days | Primarily credit card receivables | | Days Inventory Outstanding (DIO) | 115 | Days | Long lead times for custom furniture | | Days Payable Outstanding (DPO) | 60 | Days | Standard vendor terms | | Capex as % of Revenue | 3.0 | % | Consistent with FY24 spend of $222M on $7.71B revenue | | Annual Share Repurchases | 800 | $ Millions | Matches FY24 aggressive buyback levels | | Annual Dividend per Share | 2.64 | $ | Based on Q4 FY24 declared quarterly dividend of $0.66 | | WACC | 9.5 | % | Reflects consumer discretionary risk profile and zero-debt capital structure | | Terminal Growth Rate | 2.0 | % | Long-term GDP and inflation alignment | ## Data Sources & Benchmarks * **Filings**: SEC EDGAR (Williams-Sonoma, Inc. 10-K, 10-Q, 8-K), WSM Investor Relations website. * **Key Peers**: RH (RH), Wayfair (W), Arhaus (ARHS), Ethan Allen (ETD). * **Industry Data**: US Census Bureau (Retail Sales for Furniture and Home Furnishings Stores), National Association of Realtors (Existing Home Sales data). * **Consensus Estimates**: FactSet or Bloomberg for forward-looking revenue and EPS estimates. * **Proprietary Data**: SimilarWeb for e-commerce traffic trends across the brand portfolio; credit card panel data for real-time consumer spending shifts. ## Sources * Williams-Sonoma, Inc. Q4 2024 Earnings Release (19 March 2025) - https://ir.williams-sonomainc.com * Williams-Sonoma, Inc. FY2024 Annual Report on Form 10-K - https://www.sec.gov * Williams-Sonoma, Inc. Q4 2024 Earnings Call Transcript (Seeking Alpha / The Motley Fool) * Williams-Sonoma, Inc. FY2023 Annual Report on Form 10-K - https://www.sec.gov --- ## Frequently asked questions ### What is Williams-Sonoma, Inc. and what products does it sell? Williams-Sonoma, Inc. is an omni-channel specialty retailer offering high-quality products for the home. The company designs, sources, and sells furniture, homewares, and decorative accessories through its e-commerce platforms, direct-mail catalogues, and retail stores. Its key brands include Pottery Barn, West Elm, and Williams Sonoma. ### How does Williams-Sonoma generate revenue across its different brands? Williams-Sonoma generates revenue through an omni-channel approach, leveraging its e-commerce engine, direct-mail catalogues, and physical retail stores. For example, Pottery Barn's revenue is driven by e-commerce traffic, conversion rates, average order value, and retail square footage sales. West Elm's revenue is primarily based on omni-channel customer count and annual spend per customer. ### What is Williams-Sonoma's typical capital expenditure as a percentage of revenue, and what does it primarily invest in? Williams-Sonoma's capital expenditure typically ranges from 2.5% to 3.5% of revenue, with FY2024 capex at $222 million on $7.71 billion revenue. Approximately 60% of this capex is allocated to growth initiatives such as technology, e-commerce platforms, and supply chain automation. The company also invests in expanding its Rejuvenation store footprint and upgrading regional distribution hubs. ### What are the key assumptions used in the Williams-Sonoma financial model regarding revenue growth and operating expenses? The Williams-Sonoma financial model assumes a revenue growth rate of approximately 7.07%. For operating expenses, key assumptions include Cost of Goods Sold at about 59.16% of revenue and Selling, General, and Administrative expenses at around 26.39% of revenue. Depreciation and Amortization is assumed to be about 2.76% of revenue. ### What is the primary purpose of the Williams-Sonoma financial model? The primary purpose of the Williams-Sonoma financial model is to evaluate the company's equity valuation and its capacity to generate cash flow. It aims to determine if Williams-Sonoma can sustain its high operating margins, fund aggressive share repurchase programs, and maintain dividend growth. This analysis considers a volatile macroeconomic environment and housing market headwinds. ### Can I download an Excel financial model for Williams-Sonoma, and what is its forecast horizon? Yes, an Excel financial model for Williams-Sonoma (WSM) is available for download. This model provides a forecast horizon spanning from Fiscal Year 2026 through Fiscal Year 2030. [Interactive forecast calculator](https://finamodel.com/companies/williams-sonoma/forecast)