Central Garden & Pet Company (CENT) DCF Valuation
- ✓ 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
Central Garden & Pet Company (CENT) Bundle
Discover the true value of Central Garden & Pet Company (CENT) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and examine how different factors influence Central Garden & Pet Company's valuation – all within one Excel template.
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 | 2,695.5 | 3,303.7 | 3,338.6 | 3,310.1 | 3,200.5 | 3,356.1 | 3,519.3 | 3,690.5 | 3,870.0 | 4,058.2 |
Revenue Growth, % | 0 | 22.56 | 1.06 | -0.8538 | -3.31 | 4.86 | 4.86 | 4.86 | 4.86 | 4.86 |
EBITDA | 253.3 | 329.2 | 341.0 | 307.2 | 290.8 | 321.8 | 337.4 | 353.9 | 371.1 | 389.1 |
EBITDA, % | 9.4 | 9.97 | 10.21 | 9.28 | 9.08 | 9.59 | 9.59 | 9.59 | 9.59 | 9.59 |
Depreciation | 90.4 | 115.8 | 129.6 | 87.7 | 90.8 | 108.9 | 114.2 | 119.8 | 125.6 | 131.7 |
Depreciation, % | 3.35 | 3.5 | 3.88 | 2.65 | 2.84 | 3.25 | 3.25 | 3.25 | 3.25 | 3.25 |
EBIT | 163.0 | 213.5 | 211.4 | 219.5 | 200.0 | 212.9 | 223.2 | 234.1 | 245.5 | 257.4 |
EBIT, % | 6.05 | 6.46 | 6.33 | 6.63 | 6.25 | 6.34 | 6.34 | 6.34 | 6.34 | 6.34 |
Total Cash | 652.7 | 426.4 | 177.4 | 488.7 | 753.6 | 542.0 | 568.4 | 596.0 | 625.0 | 655.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 391.8 | 385.4 | 376.8 | 332.9 | 326.2 | 387.5 | 406.4 | 426.1 | 446.9 | 468.6 |
Account Receivables, % | 14.53 | 11.67 | 11.29 | 10.06 | 10.19 | 11.55 | 11.55 | 11.55 | 11.55 | 11.55 |
Inventories | 439.6 | 685.2 | 938.0 | 838.2 | 757.9 | 766.2 | 803.5 | 842.5 | 883.5 | 926.5 |
Inventories, % | 16.31 | 20.74 | 28.1 | 25.32 | 23.68 | 22.83 | 22.83 | 22.83 | 22.83 | 22.83 |
Accounts Payable | 205.2 | 245.5 | 215.7 | 190.9 | 212.6 | 227.7 | 238.7 | 250.3 | 262.5 | 275.3 |
Accounts Payable, % | 7.61 | 7.43 | 6.46 | 5.77 | 6.64 | 6.78 | 6.78 | 6.78 | 6.78 | 6.78 |
Capital Expenditure | -43.1 | -80.3 | -115.2 | -54.0 | -43.1 | -70.2 | -73.6 | -77.2 | -80.9 | -84.9 |
Capital Expenditure, % | -1.6 | -2.43 | -3.45 | -1.63 | -1.35 | -2.09 | -2.09 | -2.09 | -2.09 | -2.09 |
Tax Rate, % | 23.47 | 23.47 | 23.47 | 23.47 | 23.47 | 23.47 | 23.47 | 23.47 | 23.47 | 23.47 |
EBITAT | 127.9 | 166.3 | 161.7 | 169.7 | 153.0 | 164.7 | 172.7 | 181.1 | 189.9 | 199.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -450.9 | 2.8 | -97.9 | 322.4 | 309.3 | 148.9 | 168.2 | 176.4 | 185.0 | 194.0 |
WACC, % | 6.24 | 6.23 | 6.21 | 6.23 | 6.21 | 6.23 | 6.23 | 6.23 | 6.23 | 6.23 |
PV UFCF | ||||||||||
SUM PV UFCF | 725.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 198 | |||||||||
Terminal Value | 4,683 | |||||||||
Present Terminal Value | 3,463 | |||||||||
Enterprise Value | 4,188 | |||||||||
Net Debt | 667 | |||||||||
Equity Value | 3,521 | |||||||||
Diluted Shares Outstanding, MM | 67 | |||||||||
Equity Value Per Share | 52.66 |
What You Will Receive
- Adjustable Forecast Inputs: Modify key assumptions (growth %, margins, WACC) effortlessly to explore various scenarios.
- Real-World Data: Central Garden & Pet Company's (CENT) financial information pre-loaded to facilitate your analysis.
- Automated DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically for your convenience.
- Customizable and Professional: A sleek Excel model tailored to meet your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation frameworks tailored for Central Garden & Pet Company (CENT).
- WACC Calculator: A pre-configured Weighted Average Cost of Capital sheet with adjustable parameters for precise calculations.
- Customizable Forecast Assumptions: Easily adjust growth projections, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Central Garden & Pet Company (CENT).
- Interactive Dashboard and Charts: Visual representations that highlight key valuation metrics for straightforward interpretation.
How It Works
- Download the Template: Gain immediate access to the Excel-based CENT DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Central Garden & Pet Company’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial strategy.
Why Choose This Calculator for Central Garden & Pet Company (CENT)?
- Accurate Data: Up-to-date Central Garden & Pet financials guarantee trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations streamline your process, so you don’t have to start from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the industry.
- User-Friendly: Clear layout and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Central Garden & Pet Company (CENT) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Central Garden & Pet Company (CENT).
- Consultants: Deliver professional valuation insights on Central Garden & Pet Company (CENT) to clients quickly and accurately.
- Business Owners: Understand how companies like Central Garden & Pet Company (CENT) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Central Garden & Pet Company (CENT).
What the Template Contains
- Pre-Filled DCF Model: Central Garden & Pet Company’s (CENT) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Central Garden & Pet Company’s (CENT) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.