Petco Health and Wellness Company, Inc. (WOOF) DCF Valuation

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

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

TOTAL:

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
Account Receivables, % 0.7107 0.85011 0.95775 0.82141 0.7093
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.