Seneca Foods Corporation (SENEA) 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
Seneca Foods Corporation (SENEA) Bundle
Looking to assess the intrinsic value of Seneca Foods Corporation? Our (SENEA) DCF Calculator integrates real-world data with comprehensive customization options, allowing you to refine your forecasts and enhance your investment strategy.
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 | 1,335.8 | 1,467.6 | 1,385.3 | 1,509.4 | 1,458.6 | 1,494.5 | 1,531.4 | 1,569.1 | 1,607.7 | 1,647.4 |
Revenue Growth, % | 0 | 9.87 | -5.61 | 8.96 | -3.36 | 2.46 | 2.46 | 2.46 | 2.46 | 2.46 |
EBITDA | 95.8 | 179.6 | 110.3 | 69.7 | 161.2 | 128.7 | 131.8 | 135.1 | 138.4 | 141.8 |
EBITDA, % | 7.17 | 12.24 | 7.96 | 4.62 | 11.05 | 8.61 | 8.61 | 8.61 | 8.61 | 8.61 |
Depreciation | 30.9 | 32.4 | 36.5 | 40.9 | 43.5 | 38.4 | 39.4 | 40.3 | 41.3 | 42.3 |
Depreciation, % | 2.32 | 2.21 | 2.64 | 2.71 | 2.98 | 2.57 | 2.57 | 2.57 | 2.57 | 2.57 |
EBIT | 64.9 | 147.2 | 73.8 | 28.8 | 117.7 | 90.2 | 92.5 | 94.8 | 97.1 | 99.5 |
EBIT, % | 4.86 | 10.03 | 5.33 | 1.91 | 8.07 | 6.04 | 6.04 | 6.04 | 6.04 | 6.04 |
Total Cash | 10.7 | 59.8 | 10.9 | 12.3 | 4.5 | 20.3 | 20.8 | 21.3 | 21.8 | 22.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 121.8 | 101.5 | 119.2 | 104.7 | 80.2 | 110.8 | 113.5 | 116.3 | 119.2 | 122.1 |
Account Receivables, % | 9.12 | 6.92 | 8.6 | 6.94 | 5.5 | 7.41 | 7.41 | 7.41 | 7.41 | 7.41 |
Inventories | 411.6 | 343.1 | 410.3 | 708.8 | 872.7 | 569.7 | 583.8 | 598.2 | 612.9 | 628.0 |
Inventories, % | 30.82 | 23.38 | 29.62 | 46.96 | 59.83 | 38.12 | 38.12 | 38.12 | 38.12 | 38.12 |
Accounts Payable | 71.2 | 74.1 | 87.6 | 69.2 | 40.3 | 71.9 | 73.7 | 75.5 | 77.3 | 79.2 |
Accounts Payable, % | 5.33 | 5.05 | 6.32 | 4.59 | 2.76 | 4.81 | 4.81 | 4.81 | 4.81 | 4.81 |
Capital Expenditure | -65.7 | -71.4 | -53.4 | -70.6 | -36.6 | -62.3 | -63.8 | -65.4 | -67.0 | -68.6 |
Capital Expenditure, % | -4.92 | -4.87 | -3.85 | -4.68 | -2.51 | -4.17 | -4.17 | -4.17 | -4.17 | -4.17 |
Tax Rate, % | 23.71 | 23.71 | 23.71 | 23.71 | 23.71 | 23.71 | 23.71 | 23.71 | 23.71 | 23.71 |
EBITAT | 51.7 | 116.0 | 51.5 | 21.0 | 89.8 | 68.2 | 69.8 | 71.6 | 73.3 | 75.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -445.2 | 168.6 | -36.7 | -311.0 | -71.6 | 348.2 | 30.4 | 31.2 | 31.9 | 32.7 |
WACC, % | 4.93 | 4.91 | 4.65 | 4.74 | 4.84 | 4.81 | 4.81 | 4.81 | 4.81 | 4.81 |
PV UFCF | ||||||||||
SUM PV UFCF | 439.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 33 | |||||||||
Terminal Value | 1,186 | |||||||||
Present Terminal Value | 938 | |||||||||
Enterprise Value | 1,377 | |||||||||
Net Debt | 646 | |||||||||
Equity Value | 731 | |||||||||
Diluted Shares Outstanding, MM | 7 | |||||||||
Equity Value Per Share | 98.94 |
What You Will Get
- Real SENEA Financial Data: Pre-filled with Seneca Foods Corporation’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 Seneca Foods Corporation’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
- Comprehensive Historical Data: Seneca Foods Corporation’s past financial statements and pre-filled projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Observe the intrinsic value of Seneca Foods Corporation recalculating instantly.
- Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Seneca Foods data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Seneca Foods’ intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Seneca Foods Corporation (SENEA)?
- Designed for Industry Experts: A specialized tool utilized by food industry analysts, financial officers, and consultants.
- Accurate Financial Insights: Seneca Foods’ historical and projected financial data preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth calculation process.
Who Should Use This Product?
- Investors: Accurately assess Seneca Foods Corporation’s (SENEA) fair value before making investment choices.
- CFOs: Utilize a high-quality DCF model for financial reporting and analysis related to Seneca Foods Corporation (SENEA).
- Consultants: Easily modify the template for valuation reports tailored to clients interested in Seneca Foods Corporation (SENEA).
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading food companies like Seneca Foods Corporation (SENEA).
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to the food industry, including Seneca Foods Corporation (SENEA).
What the Template Contains
- Historical Data: Includes Seneca Foods Corporation’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Seneca Foods Corporation’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 Seneca Foods Corporation’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.