Warby Parker Inc. (WRBY) DCF Valuation

Warby Parker Inc. (WRBY) DCF Valuation
  • ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
  • ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
  • ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
  • ✓ No Se Necesita Experiencia; Fáciles De Seguir

Warby Parker Inc. (WRBY) 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:

Simplify Warby Parker Inc. (WRBY) valuation with this customizable DCF Calculator! Featuring real Warby Parker Inc. (WRBY) financials and adjustable forecast inputs, you can test scenarios and uncover Warby Parker Inc. (WRBY) fair value in minutes.


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 370.5 393.7 540.8 598.1 669.8 780.6 909.8 1,060.5 1,236.0 1,440.6
Revenue Growth, % 0 6.28 37.36 10.6 11.98 16.55 16.55 16.55 16.55 16.55
EBITDA 12.9 -37.3 -121.7 -78.0 -30.2 -71.9 -83.8 -97.7 -113.8 -132.7
EBITDA, % 3.47 -9.46 -22.5 -13.05 -4.51 -9.21 -9.21 -9.21 -9.21 -9.21
Depreciation 14.5 18.4 22.0 31.9 38.6 37.0 43.2 50.3 58.7 68.4
Depreciation, % 3.92 4.67 4.06 5.33 5.76 4.75 4.75 4.75 4.75 4.75
EBIT -1.7 -55.6 -143.7 -109.9 -68.8 -109.0 -127.0 -148.0 -172.5 -201.1
EBIT, % -0.4489 -14.13 -26.56 -18.37 -10.27 -13.96 -13.96 -13.96 -13.96 -13.96
Total Cash 55.4 314.1 256.4 208.6 216.9 326.9 381.1 444.1 517.6 603.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 1.1 .6 1.0 1.4 1.8
Account Receivables, % 0.30178 0.15265 0.18343 0.23992 0.26562
Inventories 28.4 38.5 57.1 68.8 62.2 76.2 88.8 103.5 120.6 140.6
Inventories, % 7.68 9.77 10.56 11.51 9.29 9.76 9.76 9.76 9.76 9.76
Accounts Payable 37.3 40.8 30.9 20.8 22.5 51.5 60.0 69.9 81.5 95.0
Accounts Payable, % 10.07 10.36 5.71 3.48 3.35 6.59 6.59 6.59 6.59 6.59
Capital Expenditure -32.6 -20.1 -48.5 -60.2 -53.7 -63.9 -74.5 -86.9 -101.2 -118.0
Capital Expenditure, % -8.81 -5.1 -8.97 -10.06 -8.01 -8.19 -8.19 -8.19 -8.19 -8.19
Tax Rate, % -0.68989 -0.68989 -0.68989 -0.68989 -0.68989 -0.68989 -0.68989 -0.68989 -0.68989 -0.68989
EBITAT 346.7 -55.8 -143.9 -110.4 -69.2 -87.2 -101.6 -118.4 -138.0 -160.8
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 336.3 -63.5 -199.4 -161.0 -76.4 -99.0 -137.3 -160.0 -186.5 -217.4
WACC, % 12.23 12.49 12.49 12.49 12.49 12.43 12.43 12.43 12.43 12.43
PV UFCF
SUM PV UFCF -547.0
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -222
Terminal Value -2,125
Present Terminal Value -1,183
Enterprise Value -1,730
Net Debt -42
Equity Value -1,687
Diluted Shares Outstanding, MM 117
Equity Value Per Share -14.37

What You Will Get

  • Real WRBY Financial Data: Pre-filled with Warby Parker’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 Warby Parker’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 Data: Warby Parker’s historical financial statements and pre-filled projections.
  • Customizable Variables: Modify WACC, tax rates, revenue growth, and EBITDA margins.
  • Real-Time Insights: Observe Warby Parker’s intrinsic value update instantly.
  • Visual Data Representation: Dashboard graphs illustrate valuation outcomes and essential metrics.
  • Designed for Precision: A professional tool tailored for analysts, investors, and finance professionals.

How It Works

  1. Download the Template: Gain immediate access to the Excel-based WRBY DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells to set growth rates, WACC, margins, and additional parameters.
  3. Instant Calculations: The model automatically recalculates Warby Parker’s intrinsic value.
  4. Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
  5. Analyze and Decide: Leverage the results to inform your investment or financial analysis.

Why Choose This Calculator for Warby Parker Inc. (WRBY)?

  • Accuracy: Utilizes real Warby Parker financials for precise data.
  • Flexibility: Tailored for users to easily adjust and experiment with inputs.
  • Time-Saving: Avoid the complexities of creating a financial model from the ground up.
  • Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
  • User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.

Who Should Use This Product?

  • Investors: Evaluate Warby Parker’s valuation before making stock transactions.
  • CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
  • Startup Founders: Understand how leading eyewear companies like Warby Parker are valued.
  • Consultants: Provide expert valuation reports for clients in the retail sector.
  • Students and Educators: Utilize real-world data to learn and teach valuation strategies.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Warby Parker historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for Warby Parker Inc. (WRBY).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.