Chewy, Inc. (CHWY) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Chewy, Inc. (CHWY) Bundle
Explore the financial future of Chewy, Inc. (CHWY) with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and costs to calculate the intrinsic value of Chewy, Inc. (CHWY) and inform 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 | 4,846.7 | 7,146.3 | 8,890.8 | 10,098.9 | 11,147.7 | 13,818.4 | 17,129.0 | 21,232.7 | 26,319.5 | 32,625.0 |
| Revenue Growth, % | 0 | 47.44 | 24.41 | 13.59 | 10.39 | 23.96 | 23.96 | 23.96 | 23.96 | 23.96 |
| EBITDA | -222.1 | -54.8 | -17.7 | 138.6 | 161.5 | -75.4 | -93.4 | -115.8 | -143.6 | -178.0 |
| EBITDA, % | -4.58 | -0.76683 | -0.19935 | 1.37 | 1.45 | -0.54549 | -0.54549 | -0.54549 | -0.54549 | -0.54549 |
| Depreciation | 48.9 | 61.7 | 88.0 | 83.4 | 109.7 | 129.1 | 160.0 | 198.3 | 245.8 | 304.7 |
| Depreciation, % | 1.01 | 0.86283 | 0.98942 | 0.82623 | 0.98399 | 0.93408 | 0.93408 | 0.93408 | 0.93408 | 0.93408 |
| EBIT | -270.9 | -116.5 | -105.7 | 55.1 | 51.8 | -204.5 | -253.4 | -314.2 | -389.4 | -482.7 |
| EBIT, % | -5.59 | -1.63 | -1.19 | 0.5458 | 0.46478 | -1.48 | -1.48 | -1.48 | -1.48 | -1.48 |
| Total Cash | 212.1 | 563.3 | 603.1 | 677.4 | 1,134.0 | 992.8 | 1,230.6 | 1,525.5 | 1,890.9 | 2,343.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 81.1 | 100.7 | 123.5 | 127.0 | 154.0 | 196.5 | 243.6 | 302.0 | 374.3 | 464.0 |
| Account Receivables, % | 1.67 | 1.41 | 1.39 | 1.26 | 1.38 | 1.42 | 1.42 | 1.42 | 1.42 | 1.42 |
| Inventories | 317.8 | 513.3 | 560.4 | 675.5 | 719.3 | 917.1 | 1,136.8 | 1,409.2 | 1,746.8 | 2,165.3 |
| Inventories, % | 6.56 | 7.18 | 6.3 | 6.69 | 6.45 | 6.64 | 6.64 | 6.64 | 6.64 | 6.64 |
| Accounts Payable | 683.0 | 778.4 | 883.3 | 1,033.2 | 1,104.9 | 1,521.8 | 1,886.3 | 2,338.2 | 2,898.4 | 3,592.8 |
| Accounts Payable, % | 14.09 | 10.89 | 9.94 | 10.23 | 9.91 | 11.01 | 11.01 | 11.01 | 11.01 | 11.01 |
| Capital Expenditure | -48.6 | -130.7 | -183.2 | -230.3 | -143.3 | -233.8 | -289.8 | -359.2 | -445.3 | -552.0 |
| Capital Expenditure, % | -1 | -1.83 | -2.06 | -2.28 | -1.29 | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 |
| Tax Rate, % | 17.93 | 17.93 | 17.93 | 17.93 | 17.93 | 17.93 | 17.93 | 17.93 | 17.93 | 17.93 |
| EBITAT | -270.6 | -119.0 | -108.0 | 53.0 | 42.5 | -195.5 | -242.3 | -300.4 | -372.4 | -461.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 13.8 | -307.9 | -168.2 | -62.5 | 9.9 | -123.7 | -274.4 | -340.1 | -421.6 | -522.6 |
| WACC, % | 9.3 | 9.3 | 9.3 | 9.29 | 9.27 | 9.29 | 9.29 | 9.29 | 9.29 | 9.29 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,234.0 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | -543 | |||||||||
| Terminal Value | -10,270 | |||||||||
| Present Terminal Value | -6,587 | |||||||||
| Enterprise Value | -7,821 | |||||||||
| Net Debt | -74 | |||||||||
| Equity Value | -7,746 | |||||||||
| Diluted Shares Outstanding, MM | 432 | |||||||||
| Equity Value Per Share | -17.93 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real financials for Chewy, Inc. (CHWY).
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Chewy's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive Chewy Financials: Access reliable pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells for metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates to DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
- Designed for All Users: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the pre-built Excel file containing Chewy, Inc.'s (CHWY) financial data.
- Customize: Modify projections, including sales growth, gross margin %, and discount rate.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and analyze results instantly.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator for Chewy, Inc. (CHWY)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and consultants in the pet industry.
- Accurate Financial Data: Chewy’s historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Investors: Evaluate Chewy’s valuation before making stock transactions.
- CFOs and Financial Analysts: Enhance valuation workflows and assess financial forecasts.
- Startup Founders: Understand the valuation methods used for prominent companies like Chewy.
- Consultants: Provide expert valuation reports to your clients.
- Students and Educators: Utilize real data to practice and instruct on valuation methodologies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Chewy, Inc. (CHWY) 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 Chewy, Inc. (CHWY).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.