Freshpet, Inc. (FRPT) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Freshpet, Inc. (FRPT) Bundle
Evaluate Freshpet, Inc.'s (FRPT) financial outlook like an expert! This (FRPT) DCF Calculator provides you with pre-filled financial data and the flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your predictions.
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 | 245.9 | 318.8 | 425.5 | 595.3 | 766.9 | 1,019.7 | 1,355.9 | 1,802.9 | 2,397.2 | 3,187.5 |
Revenue Growth, % | 0 | 29.66 | 33.47 | 39.92 | 28.82 | 32.97 | 32.97 | 32.97 | 32.97 | 32.97 |
EBITDA | 15.7 | 19.2 | 7.1 | -14.3 | 41.1 | 34.7 | 46.2 | 61.4 | 81.7 | 108.6 |
EBITDA, % | 6.38 | 6.03 | 1.68 | -2.41 | 5.36 | 3.41 | 3.41 | 3.41 | 3.41 | 3.41 |
Depreciation | 15.9 | 21.1 | 31.8 | 35.9 | 58.5 | 69.8 | 92.9 | 123.5 | 164.2 | 218.3 |
Depreciation, % | 6.48 | 6.63 | 7.47 | 6.03 | 7.63 | 6.85 | 6.85 | 6.85 | 6.85 | 6.85 |
EBIT | -.2 | -1.9 | -24.7 | -50.3 | -17.4 | -35.1 | -46.7 | -62.1 | -82.5 | -109.7 |
EBIT, % | -0.10075 | -0.59945 | -5.79 | -8.44 | -2.27 | -3.44 | -3.44 | -3.44 | -3.44 | -3.44 |
Total Cash | 9.5 | 67.2 | 72.8 | 132.7 | 296.9 | 210.2 | 279.5 | 371.6 | 494.1 | 657.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 18.6 | 18.4 | 34.8 | 57.6 | 56.8 | 78.7 | 104.6 | 139.1 | 185.0 | 246.0 |
Account Receivables, % | 7.56 | 5.78 | 8.17 | 9.67 | 7.4 | 7.72 | 7.72 | 7.72 | 7.72 | 7.72 |
Inventories | 12.5 | 19.1 | 35.6 | 58.3 | 63.2 | 76.5 | 101.7 | 135.2 | 179.8 | 239.0 |
Inventories, % | 5.1 | 6 | 8.36 | 9.79 | 8.25 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 |
Accounts Payable | 18.7 | 16.5 | 42.6 | 55.1 | 36.1 | 74.9 | 99.6 | 132.4 | 176.1 | 234.1 |
Accounts Payable, % | 7.59 | 5.16 | 10.01 | 9.25 | 4.71 | 7.35 | 7.35 | 7.35 | 7.35 | 7.35 |
Capital Expenditure | -70.6 | -134.6 | -322.1 | -230.1 | -239.1 | -441.5 | -587.0 | -780.5 | -1,037.8 | -1,380.0 |
Capital Expenditure, % | -28.73 | -42.21 | -75.7 | -38.65 | -31.18 | -43.29 | -43.29 | -43.29 | -43.29 | -43.29 |
Tax Rate, % | -6.66 | -6.66 | -6.66 | -6.66 | -6.66 | -6.66 | -6.66 | -6.66 | -6.66 | -6.66 |
EBITAT | -.3 | -2.0 | -24.8 | -50.5 | -18.6 | -35.1 | -46.7 | -62.1 | -82.5 | -109.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -67.4 | -124.0 | -321.7 | -277.7 | -222.3 | -403.1 | -567.3 | -754.3 | -1,002.9 | -1,333.6 |
WACC, % | 10.64 | 10.64 | 10.64 | 10.64 | 10.64 | 10.64 | 10.64 | 10.64 | 10.64 | 10.64 |
PV UFCF | ||||||||||
SUM PV UFCF | -2,858.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -1,360 | |||||||||
Terminal Value | -15,748 | |||||||||
Present Terminal Value | -9,500 | |||||||||
Enterprise Value | -12,358 | |||||||||
Net Debt | 128 | |||||||||
Equity Value | -12,486 | |||||||||
Diluted Shares Outstanding, MM | 48 | |||||||||
Equity Value Per Share | -259.25 |
What You Will Get
- Pre-Filled Financial Model: Freshpet’s actual data allows for accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other critical drivers.
- Instant Calculations: Real-time updates ensure you see results as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for flexibility, enabling repeated use for comprehensive forecasts.
Key Features
- Pre-Loaded Data: Freshpet’s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Customize WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: View Freshpet’s intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts present valuation results and key metrics.
- Built for Accuracy: A professional tool tailored for analysts, investors, and finance experts.
How It Works
- Download: Get the pre-built Excel file featuring Freshpet, Inc.'s (FRPT) financial data.
- Customize: Modify projections, including sales growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and evaluate outcomes immediately.
- Make Decisions: Utilize the valuation findings to shape your investment approach.
Why Choose Freshpet, Inc. (FRPT)?
- Quality Ingredients: We use fresh, real meat and vegetables in our pet food.
- Health Benefits: Our recipes are designed to promote the well-being of your pets.
- Eco-Friendly Practices: Committed to sustainable sourcing and environmentally friendly packaging.
- Convenient Options: Easily accessible products that fit seamlessly into your pet care routine.
- Endorsed by Pet Owners: Trusted by thousands of satisfied customers who prioritize their pets' health.
Who Should Use Freshpet, Inc. (FRPT)?
- Pet Owners: Make informed decisions about purchasing Freshpet products for their pets' health and nutrition.
- Market Analysts: Enhance market research with comprehensive insights into the pet food industry.
- Retailers: Gain valuable information to optimize inventory and sales strategies for Freshpet offerings.
- Investors: Assess the growth potential of Freshpet, Inc. (FRPT) to inform investment choices.
- Students of Business: Explore case studies and market dynamics within the pet food sector using Freshpet as a key example.
What the Template Contains
- Pre-Filled Data: Includes Freshpet, Inc.'s historical financial performance and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations tailored for Freshpet, Inc. (FRPT).
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs specific to Freshpet, Inc. (FRPT).
- Key Financial Ratios: Analyze Freshpet, Inc.'s profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
- Clear Dashboard: Visual representations and tables summarizing key valuation outcomes for Freshpet, Inc. (FRPT).