Seneca Foods Corp (SENEB) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Seneca Foods Corporation (SENEB) Bundle
Evaluate Seneca Foods Corp's (SENEB) financial outlook like an expert! This (SENEB) DCF Calculator provides you with pre-filled financial data and the complete flexibility to modify revenue growth, WACC, margins, and other essential 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 | 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 |
Benefits of Using Our Model
- Flexible Input Options: Easily adjust key assumptions (growth %, margins, WACC) to explore various scenarios.
- Ready-to-Use Financial Data: Seneca Foods Corp’s financial information pre-loaded to kickstart your analysis.
- Instant DCF Calculations: The template automatically computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional Design: A sleek Excel model that can be tailored to meet your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, affirming strategies, and enhancing efficiency.
Key Features
- Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for Seneca Foods Corp (SENEB).
- WACC Estimator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Seneca Foods Corp (SENEB).
- User-Friendly Dashboard and Charts: Visual representations of essential valuation metrics for straightforward analysis.
How It Operates
- Step 1: Download the Excel file.
- Step 2: Examine the pre-filled data for Seneca Foods Corp (SENEB), including historical and forecasted figures.
- Step 3: Modify key assumptions (highlighted in yellow) based on your insights.
- Step 4: Observe automatic recalculations reflecting Seneca Foods Corp’s (SENEB) intrinsic value.
- Step 5: Utilize the results for your investment strategies or reporting needs.
Why Choose This Calculator for Seneca Foods Corp (SENEB)?
- Precision: Utilizes accurate financial data from Seneca Foods to ensure reliability.
- Versatility: Allows users to easily adjust and explore different input scenarios.
- Efficiency: Eliminate the need to construct a discounted cash flow model from the ground up.
- High-Quality: Crafted with the expertise and standards expected at the CFO level.
- Intuitive Design: Simple to navigate, suitable for users without extensive financial modeling skills.
Who Can Benefit from This Product?
- Individual Investors: Gain insights to make informed decisions regarding buying or selling Seneca Foods Corp (SENEB) stock.
- Financial Analysts: Enhance valuation tasks with pre-built financial models tailored for the food industry.
- Consultants: Provide clients with accurate and timely valuation insights related to Seneca Foods Corp (SENEB).
- Business Owners: Learn how large food companies like Seneca Foods Corp (SENEB) are valued to inform your own business strategies.
- Finance Students: Explore valuation methodologies using real market data and practical case studies involving Seneca Foods Corp (SENEB).
Contents of the Template
- Operating and Balance Sheet Data: Pre-filled historical data and forecasts for Seneca Foods Corp (SENEB), including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models displaying intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded annual and quarterly financial statements to aid in analysis.
- Key Ratios: Contains profitability, leverage, and efficiency ratios specific to Seneca Foods Corp (SENEB).
- Dashboard and Charts: Visual summaries of valuation outputs and assumptions for easy analysis of results.