|
PetMed Express, Inc. (PETS) DCF Valuation
US | Healthcare | Medical - Pharmaceuticals | NASDAQ
|
- ✓ 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
PetMed Express, Inc. (PETS) Bundle
Evaluate the financial outlook of PetMed Express, Inc. (PETS) like an expert! This (PETS) DCF Calculator provides pre-filled financial data along with the flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 284.1 | 309.2 | 273.4 | 256.9 | 281.1 | 281.5 | 281.9 | 282.4 | 282.8 | 283.3 |
| Revenue Growth, % | 0 | 8.83 | -11.58 | -6.06 | 9.42 | 0.15528 | 0.15528 | 0.15528 | 0.15528 | 0.15528 |
| EBITDA | 33.2 | 40.0 | 28.4 | 2.1 | -1.1 | 20.0 | 20.0 | 20.0 | 20.1 | 20.1 |
| EBITDA, % | 11.7 | 12.94 | 10.4 | 0.8238 | -0.3935 | 7.09 | 7.09 | 7.09 | 7.09 | 7.09 |
| Depreciation | 2.3 | 2.4 | 2.7 | 3.5 | 7.1 | 3.6 | 3.6 | 3.7 | 3.7 | 3.7 |
| Depreciation, % | 0.79437 | 0.78489 | 1 | 1.38 | 2.51 | 1.29 | 1.29 | 1.29 | 1.29 | 1.29 |
| EBIT | 31.0 | 37.6 | 25.7 | -1.4 | -8.2 | 16.3 | 16.4 | 16.4 | 16.4 | 16.4 |
| EBIT, % | 10.9 | 12.16 | 9.4 | -0.55673 | -2.9 | 5.8 | 5.8 | 5.8 | 5.8 | 5.8 |
| Total Cash | 103.8 | 118.7 | 111.1 | 104.1 | 55.3 | 98.9 | 99.1 | 99.2 | 99.4 | 99.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3.8 | 2.6 | 1.9 | 1.7 | 3.3 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 |
| Account Receivables, % | 1.35 | 0.83663 | 0.69966 | 0.67742 | 1.17 | 0.94687 | 0.94687 | 0.94687 | 0.94687 | 0.94687 |
| Inventories | 17.9 | 34.4 | 32.5 | 19.0 | 28.6 | 26.4 | 26.4 | 26.5 | 26.5 | 26.5 |
| Inventories, % | 6.29 | 11.13 | 11.87 | 7.41 | 10.16 | 9.37 | 9.37 | 9.37 | 9.37 | 9.37 |
| Accounts Payable | 19.7 | 39.5 | 27.5 | 25.2 | 37.0 | 29.7 | 29.7 | 29.8 | 29.8 | 29.9 |
| Accounts Payable, % | 6.92 | 12.79 | 10.06 | 9.81 | 13.17 | 10.55 | 10.55 | 10.55 | 10.55 | 10.55 |
| Capital Expenditure | -2.3 | -2.4 | -1.8 | -5.3 | -4.5 | -3.3 | -3.3 | -3.3 | -3.3 | -3.3 |
| Capital Expenditure, % | -0.81337 | -0.78651 | -0.64078 | -2.05 | -1.6 | -1.18 | -1.18 | -1.18 | -1.18 | -1.18 |
| Tax Rate, % | -18.99 | -18.99 | -18.99 | -18.99 | -18.99 | -18.99 | -18.99 | -18.99 | -18.99 | -18.99 |
| EBITAT | 23.6 | 22.9 | 17.8 | -.2 | -9.7 | 10.5 | 10.5 | 10.5 | 10.5 | 10.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 21.5 | 27.5 | 9.4 | 9.4 | -6.4 | 6.3 | 10.8 | 10.8 | 10.9 | 10.9 |
| WACC, % | 7.58 | 7.57 | 7.58 | 7.55 | 7.6 | 7.58 | 7.58 | 7.58 | 7.58 | 7.58 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 39.6 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 11 | |||||||||
| Terminal Value | 276 | |||||||||
| Present Terminal Value | 192 | |||||||||
| Enterprise Value | 231 | |||||||||
| Net Debt | -54 | |||||||||
| Equity Value | 285 | |||||||||
| Diluted Shares Outstanding, MM | 20 | |||||||||
| Equity Value Per Share | 13.98 |
What You Will Get
- Real PetMed Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for PetMed Express, Inc. (PETS).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on PetMed Express, Inc.'s (PETS) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to PetMed Express, Inc. (PETS).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for PetMed Express, Inc. (PETS).
Key Features
- Comprehensive PETS Data: Pre-filled with PetMed Express's historical performance metrics and future growth estimates.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, discount rates, tax implications, and capital expenditures.
- Dynamic Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Testing: Develop various forecasting scenarios to evaluate different valuation results.
- User-Friendly Design: Intuitive, organized, and suitable for both seasoned professionals and newcomers.
How It Works
- 1. Open the Template: Download and open the Excel file containing PetMed Express, Inc.'s (PETS) preloaded data.
- 2. Edit Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Test Scenarios: Evaluate multiple forecasts to explore various valuation outcomes.
- 5. Use with Confidence: Deliver professional valuation insights to enhance your decision-making.
Why Choose PetMed Express, Inc. (PETS)?
- Convenient Access: Easily order pet medications and supplies online from the comfort of your home.
- Expert Support: Our knowledgeable team is available to assist with any questions or concerns.
- Wide Selection: A comprehensive range of products for all your pet's health needs.
- Competitive Pricing: Affordable options to ensure your pets receive the care they deserve.
- Trusted by Pet Owners: A reliable choice for pet medication and wellness, endorsed by satisfied customers.
Who Should Use This Product?
- Veterinary Students: Explore pet healthcare management and apply your knowledge with real-world data.
- Researchers: Utilize industry-specific models for studies related to pet health and wellness.
- Pet Owners: Assess your pet's healthcare options and analyze the services offered by PetMed Express, Inc. (PETS).
- Market Analysts: Enhance your analysis with a customizable model focused on the pet health market.
- Entrepreneurs: Learn from the strategies of established companies like PetMed Express, Inc. (PETS) to inform your own business decisions.
What the Template Contains
- Historical Data: Includes PetMed Express’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate PetMed Express’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 PetMed Express’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.