The Hershey Company (HSY) 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
The Hershey Company (HSY) Bundle
Evaluate The Hershey Company's financial prospects with expertise! This (HSY) DCF Calculator provides pre-filled financial data and comprehensive flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your forecasts.
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 | 7,986.3 | 8,149.7 | 8,971.3 | 10,419.3 | 11,165.0 | 12,153.8 | 13,230.2 | 14,401.9 | 15,677.3 | 17,065.8 |
| Revenue Growth, % | 0 | 2.05 | 10.08 | 16.14 | 7.16 | 8.86 | 8.86 | 8.86 | 8.86 | 8.86 |
| EBITDA | 1,788.3 | 1,904.4 | 2,198.9 | 2,379.6 | 2,753.2 | 2,862.6 | 3,116.2 | 3,392.1 | 3,692.6 | 4,019.6 |
| EBITDA, % | 22.39 | 23.37 | 24.51 | 22.84 | 24.66 | 23.55 | 23.55 | 23.55 | 23.55 | 23.55 |
| Depreciation | 264.8 | 265.5 | 282.8 | 333.3 | 419.8 | 405.5 | 441.5 | 480.6 | 523.1 | 569.4 |
| Depreciation, % | 3.32 | 3.26 | 3.15 | 3.2 | 3.76 | 3.34 | 3.34 | 3.34 | 3.34 | 3.34 |
| EBIT | 1,523.6 | 1,638.9 | 1,916.1 | 2,046.3 | 2,333.4 | 2,457.1 | 2,674.7 | 2,911.6 | 3,169.5 | 3,450.1 |
| EBIT, % | 19.08 | 20.11 | 21.36 | 19.64 | 20.9 | 20.22 | 20.22 | 20.22 | 20.22 | 20.22 |
| Total Cash | 493.3 | 1,144.0 | 329.3 | 463.9 | 401.9 | 776.3 | 845.0 | 919.9 | 1,001.3 | 1,090.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 568.5 | 615.2 | 671.5 | 711.2 | 823.6 | 883.7 | 962.0 | 1,047.2 | 1,139.9 | 1,240.8 |
| Account Receivables, % | 7.12 | 7.55 | 7.48 | 6.83 | 7.38 | 7.27 | 7.27 | 7.27 | 7.27 | 7.27 |
| Inventories | 815.3 | 964.2 | 988.5 | 1,173.1 | 1,341.0 | 1,369.2 | 1,490.5 | 1,622.4 | 1,766.1 | 1,922.6 |
| Inventories, % | 10.21 | 11.83 | 11.02 | 11.26 | 12.01 | 11.27 | 11.27 | 11.27 | 11.27 | 11.27 |
| Accounts Payable | 550.8 | 580.1 | 692.3 | 970.6 | 1,086.2 | 991.2 | 1,078.9 | 1,174.5 | 1,278.5 | 1,391.7 |
| Accounts Payable, % | 6.9 | 7.12 | 7.72 | 9.32 | 9.73 | 8.16 | 8.16 | 8.16 | 8.16 | 8.16 |
| Capital Expenditure | -318.2 | -441.6 | -495.9 | -519.5 | -771.1 | -652.0 | -709.7 | -772.6 | -841.0 | -915.5 |
| Capital Expenditure, % | -3.98 | -5.42 | -5.53 | -4.99 | -6.91 | -5.36 | -5.36 | -5.36 | -5.36 | -5.36 |
| Tax Rate, % | 14.28 | 14.28 | 14.28 | 14.28 | 14.28 | 14.28 | 14.28 | 14.28 | 14.28 | 14.28 |
| EBITAT | 1,268.6 | 1,401.8 | 1,575.2 | 1,755.7 | 2,000.2 | 2,076.4 | 2,260.3 | 2,460.5 | 2,678.4 | 2,915.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 382.2 | 1,059.2 | 1,393.9 | 1,623.4 | 1,484.3 | 1,646.6 | 1,880.3 | 2,046.8 | 2,228.0 | 2,425.4 |
| WACC, % | 5.9 | 5.91 | 5.89 | 5.91 | 5.91 | 5.9 | 5.9 | 5.9 | 5.9 | 5.9 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 8,546.3 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 2,498 | |||||||||
| Terminal Value | 86,022 | |||||||||
| Present Terminal Value | 64,572 | |||||||||
| Enterprise Value | 73,118 | |||||||||
| Net Debt | 4,724 | |||||||||
| Equity Value | 68,395 | |||||||||
| Diluted Shares Outstanding, MM | 206 | |||||||||
| Equity Value Per Share | 332.74 |
What You Will Receive
- Authentic HSY Financial Data: Pre-loaded with The Hershey Company's historical and forecasted data for accurate analysis.
- Completely Customizable Template: Easily adjust essential inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Observe The Hershey Company's intrinsic value update in real-time as you make adjustments.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Design: Streamlined layout and straightforward instructions suitable for all skill levels.
Key Features
- Customizable Financial Inputs: Adjust essential variables such as sales growth, profit margins, and investment expenditures.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value, and other financial metrics.
- High-Precision Accuracy: Leverages The Hershey Company’s (HSY) actual financial data for reliable valuation results.
- Streamlined Scenario Testing: Easily evaluate various assumptions and analyze comparative results.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Hershey data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Hershey’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for The Hershey Company (HSY)?
- Comprehensive Tool: Combines DCF, WACC, and financial ratio analyses tailored for The Hershey Company (HSY).
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes The Hershey Company’s (HSY) intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on The Hershey Company (HSY).
Who Should Use This Product?
- Investors: Evaluate The Hershey Company's (HSY) valuation prior to making stock trades.
- CFOs and Financial Analysts: Optimize valuation workflows and assess financial forecasts.
- Startup Founders: Understand the valuation methods applied to established companies like The Hershey Company.
- Consultants: Provide detailed valuation reports for your clients based on The Hershey Company's performance.
- Students and Educators: Utilize current data to learn and teach valuation strategies effectively.
What the Template Contains
- Pre-Filled DCF Model: The Hershey Company's financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate The Hershey Company's 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.