Williams-Sonoma, Inc. (WSM) DCF Valuation

Williams-Sonoma, Inc. (WSM) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

Williams-Sonoma, Inc. (WSM) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Explore the financial prospects of Williams-Sonoma, Inc. (WSM) with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and expenses to calculate the intrinsic value of Williams-Sonoma, Inc. (WSM) and enhance your investment strategy.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2019		 AY2
2020		 AY3
2021		 AY4
2022		 AY5
2023		 FY1
2024		 FY2
2025		 FY3
2026		 FY4
2027		 FY5
2028
Revenue 5,898.0 6,783.2 8,245.9 8,674.4 7,750.7 8,353.6 9,003.5 9,704.0 10,459.0 11,272.7
Revenue Growth, % 0 15.01 21.56 5.2 -10.65 7.78 7.78 7.78 7.78 7.78
EBITDA 653.6 1,126.5 1,649.2 1,498.4 1,491.3 1,406.8 1,516.3 1,634.2 1,761.4 1,898.4
EBITDA, % 11.08 16.61 20 17.27 19.24 16.84 16.84 16.84 16.84 16.84
Depreciation 403.6 405.0 413.0 445.5 232.6 433.7 467.4 503.8 543.0 585.2
Depreciation, % 6.84 5.97 5.01 5.14 3 5.19 5.19 5.19 5.19 5.19
EBIT 250.1 721.4 1,236.2 1,052.9 1,258.7 973.1 1,048.8 1,130.4 1,218.4 1,313.2
EBIT, % 4.24 10.64 14.99 12.14 16.24 11.65 11.65 11.65 11.65 11.65
Total Cash 432.2 1,200.3 850.3 367.3 1,262.0 933.1 1,005.7 1,084.0 1,168.3 1,259.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 111.7 143.7 131.7 115.7 122.9
Account Receivables, % 1.89 2.12 1.6 1.33 1.59
Inventories 1,100.5 1,006.3 1,246.4 1,456.1 1,246.4 1,361.3 1,467.2 1,581.3 1,704.3 1,836.9
Inventories, % 18.66 14.84 15.11 16.79 16.08 16.3 16.3 16.3 16.3 16.3
Accounts Payable 521.2 543.0 612.5 508.3 607.9 634.4 683.8 737.0 794.3 856.1
Accounts Payable, % 8.84 8 7.43 5.86 7.84 7.59 7.59 7.59 7.59 7.59
Capital Expenditure -186.3 -169.5 -226.5 -354.1 -188.5 -249.2 -268.6 -289.5 -312.1 -336.3
Capital Expenditure, % -3.16 -2.5 -2.75 -4.08 -2.43 -2.98 -2.98 -2.98 -2.98 -2.98
Tax Rate, % 25.41 25.41 25.41 25.41 25.41 25.41 25.41 25.41 25.41 25.41
EBITAT 194.8 549.0 959.5 791.4 938.8 742.2 800.0 862.2 929.3 1,001.6
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -278.9 868.5 987.4 584.8 1,285.0 818.8 931.2 1,003.6 1,081.7 1,165.8
WACC, % 12.23 12.23 12.23 12.23 12.22 12.23 12.23 12.23 12.23 12.23
PV UFCF
SUM PV UFCF 3,515.5
Long Term Growth Rate, % 0.50
Free cash flow (T + 1) 1,172
Terminal Value 9,990
Present Terminal Value 5,612
Enterprise Value 9,127
Net Debt 129
Equity Value 8,998
Diluted Shares Outstanding, MM 131
Equity Value Per Share 68.93

What You Will Get

  • Real WSM Financial Data: Pre-filled with Williams-Sonoma’s historical and projected data for precise analysis.
  • Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
  • Automatic Calculations: See Williams-Sonoma’s intrinsic value update instantly based on your changes.
  • Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
  • User-Friendly Design: Simple structure and clear instructions for all experience levels.

Key Features

  • Comprehensive DCF Analysis: Features detailed unlevered and levered DCF valuation models tailored for Williams-Sonoma, Inc. (WSM).
  • WACC Estimator: Pre-configured Weighted Average Cost of Capital sheet with adjustable parameters for precise calculations.
  • Customizable Forecast Inputs: Easily alter growth projections, capital expenditures, and discount rates to fit your analysis.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Williams-Sonoma, Inc. (WSM).
  • Interactive Dashboard and Visuals: Graphical representations highlight essential valuation metrics for straightforward interpretation.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Williams-Sonoma data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Williams-Sonoma’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for Williams-Sonoma, Inc. (WSM)?

  • Designed for Experts: A sophisticated tool utilized by financial analysts, executives, and investment consultants.
  • Accurate Data: Williams-Sonoma’s historical and forecasted financial information preloaded for precision.
  • Versatile Scenario Analysis: Effortlessly test various forecasts and assumptions.
  • Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
  • User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.

Who Should Use This Product?

  • Investors: Accurately evaluate Williams-Sonoma, Inc.'s (WSM) fair value prior to making investment choices.
  • CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
  • Consultants: Efficiently modify the template for valuation reports tailored to clients.
  • Entrepreneurs: Acquire knowledge on financial modeling techniques employed by leading home goods retailers.
  • Educators: Employ it as a teaching resource to illustrate various valuation methodologies.

What the Template Contains

  • Historical Data: Includes Williams-Sonoma’s past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Williams-Sonoma’s intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of Williams-Sonoma’s financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.