Petco Health and Wellness Company, Inc. (WOOF) 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
Petco Health and Wellness Company, Inc. (WOOF) Bundle
Streamline your analysis and improve precision with our [WOOF] DCF Calculator! Utilizing real-time Petco data and customizable assumptions, this tool empowers you to forecast, analyze, and evaluate Petco Health and Wellness Company, Inc. like a seasoned investor.
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,434.5 | 4,920.2 | 5,807.1 | 6,036.0 | 6,255.3 | 6,826.9 | 7,450.8 | 8,131.6 | 8,874.7 | 9,685.7 |
Revenue Growth, % | 0 | 10.95 | 18.03 | 3.94 | 3.63 | 9.14 | 9.14 | 9.14 | 9.14 | 9.14 |
EBITDA | 316.8 | 383.8 | 464.2 | 407.8 | -971.8 | 193.3 | 211.0 | 230.2 | 251.3 | 274.3 |
EBITDA, % | 7.14 | 7.8 | 7.99 | 6.76 | -15.54 | 2.83 | 2.83 | 2.83 | 2.83 | 2.83 |
Depreciation | 173.5 | 174.8 | 172.4 | 193.8 | 200.8 | 230.2 | 251.2 | 274.2 | 299.2 | 326.5 |
Depreciation, % | 3.91 | 3.55 | 2.97 | 3.21 | 3.21 | 3.37 | 3.37 | 3.37 | 3.37 | 3.37 |
EBIT | 143.3 | 208.9 | 291.8 | 213.9 | -1,172.6 | -36.9 | -40.2 | -43.9 | -47.9 | -52.3 |
EBIT, % | 3.23 | 4.25 | 5.02 | 3.54 | -18.75 | -0.53995 | -0.53995 | -0.53995 | -0.53995 | -0.53995 |
Total Cash | 148.8 | 111.4 | 211.6 | 201.9 | 125.4 | 199.5 | 217.8 | 237.7 | 259.4 | 283.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 31.5 | 41.8 | 55.6 | 49.6 | 44.4 | 55.3 | 60.3 | 65.9 | 71.9 | 78.4 |
Account Receivables, % | 0.7107 | 0.85011 | 0.95775 | 0.82141 | 0.7093 | 0.80985 | 0.80985 | 0.80985 | 0.80985 | 0.80985 |
Inventories | 479.0 | 538.7 | 675.1 | 652.4 | 684.5 | 752.7 | 821.5 | 896.5 | 978.5 | 1,067.9 |
Inventories, % | 10.8 | 10.95 | 11.63 | 10.81 | 10.94 | 11.03 | 11.03 | 11.03 | 11.03 | 11.03 |
Accounts Payable | 240.8 | 240.6 | 404.0 | 304.4 | 360.6 | 383.5 | 418.5 | 456.8 | 498.5 | 544.1 |
Accounts Payable, % | 5.43 | 4.89 | 6.96 | 5.04 | 5.77 | 5.62 | 5.62 | 5.62 | 5.62 | 5.62 |
Capital Expenditure | -157.4 | -159.6 | -239.1 | -278.0 | -225.6 | -261.1 | -284.9 | -311.0 | -339.4 | -370.4 |
Capital Expenditure, % | -3.55 | -3.24 | -4.12 | -4.61 | -3.61 | -3.82 | -3.82 | -3.82 | -3.82 | -3.82 |
Tax Rate, % | 3.31 | 3.31 | 3.31 | 3.31 | 3.31 | 3.31 | 3.31 | 3.31 | 3.31 | 3.31 |
EBITAT | 107.3 | 192.4 | 237.0 | 173.0 | -1,133.8 | -31.4 | -34.3 | -37.4 | -40.8 | -44.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -146.2 | 137.4 | 183.5 | 17.9 | -1,129.2 | -118.6 | -106.8 | -116.5 | -127.2 | -138.8 |
WACC, % | 6.34 | 6.97 | 6.58 | 6.56 | 7.14 | 6.72 | 6.72 | 6.72 | 6.72 | 6.72 |
PV UFCF | ||||||||||
SUM PV UFCF | -499.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -142 | |||||||||
Terminal Value | -3,000 | |||||||||
Present Terminal Value | -2,167 | |||||||||
Enterprise Value | -2,667 | |||||||||
Net Debt | 2,902 | |||||||||
Equity Value | -5,569 | |||||||||
Diluted Shares Outstanding, MM | 268 | |||||||||
Equity Value Per Share | -20.81 |
What You Will Get
- Real WOOF Financial Data: Pre-filled with Petco'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 Petco'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
- 🔍 Real-Life WOOF Financials: Pre-filled historical and projected data for Petco Health and Wellness Company, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Petco’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Petco’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Get the ready-to-use Excel file featuring Petco Health and Wellness Company, Inc. (WOOF) financial data.
- Customize: Tailor your forecasts, including revenue growth, EBITDA %, and WACC.
- Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and compare results instantly.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose Petco's Services?
- Save Time: Our platform eliminates the need for lengthy setup – it’s ready for immediate use.
- Enhance Accuracy: Access to reliable pet health data and insights minimizes errors in care decisions.
- Fully Customizable: Adjust services to meet the unique needs of your pets and preferences.
- Easy to Understand: Intuitive interfaces and clear information make navigation simple.
- Trusted by Pet Owners: Developed for those who prioritize their pets' health and well-being.
Who Should Use This Product?
- Investors: Evaluate Petco's valuation before making stock transactions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of leading public companies like Petco.
- Consultants: Create comprehensive valuation reports for clients in the pet industry.
- Students and Educators: Utilize current data to practice and instruct on valuation methods.
What the Template Contains
- Pre-Filled Data: Includes Petco’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Petco’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.