|
Valoración de DCF de SpartanNash Company (SPTN)
US | Consumer Defensive | Food Distribution | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
SpartanNash Company (SPTN) Bundle
¡Simplifique la valoración de SpartanNash Company (SPTN) con esta calculadora DCF personalizable! Con las finanzas de Real SpartanNash Company (SPTN) y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de la Compañía SpartanNash (SPTN) en minutos.
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 | 8,536.1 | 9,348.5 | 8,931.0 | 9,643.1 | 7,484.0 | 7,308.8 | 7,137.7 | 6,970.6 | 6,807.4 | 6,648.0 |
| Revenue Growth, % | 0 | 9.52 | -4.47 | 7.97 | -22.39 | -2.34 | -2.34 | -2.34 | -2.34 | -2.34 |
| EBITDA | 52.9 | 128.6 | 116.1 | 70.9 | 83.2 | 75.2 | 73.4 | 71.7 | 70.0 | 68.4 |
| EBITDA, % | 0.62018 | 1.38 | 1.3 | 0.73476 | 1.11 | 1.03 | 1.03 | 1.03 | 1.03 | 1.03 |
| Depreciation | 90.6 | 89.9 | 92.7 | 94.2 | .2 | 59.1 | 57.7 | 56.3 | 55.0 | 53.7 |
| Depreciation, % | 1.06 | 0.9614 | 1.04 | 0.97666 | 0.00224338 | 0.80794 | 0.80794 | 0.80794 | 0.80794 | 0.80794 |
| EBIT | -37.7 | 38.7 | 23.4 | -23.3 | 83.0 | 16.1 | 15.7 | 15.4 | 15.0 | 14.7 |
| EBIT, % | -0.44116 | 0.41424 | 0.26191 | -0.24189 | 1.11 | 0.22043 | 0.22043 | 0.22043 | 0.22043 | 0.22043 |
| Total Cash | 24.2 | 19.9 | 10.7 | 29.1 | 18.0 | 16.9 | 16.5 | 16.1 | 15.8 | 15.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 345.3 | 357.6 | 361.7 | 404.0 | 421.9 | 317.9 | 310.4 | 303.2 | 296.1 | 289.1 |
| Account Receivables, % | 4.05 | 3.82 | 4.05 | 4.19 | 5.64 | 4.35 | 4.35 | 4.35 | 4.35 | 4.35 |
| Inventories | 537.2 | 541.8 | 522.3 | 571.1 | 575.2 | 461.1 | 450.3 | 439.8 | 429.5 | 419.4 |
| Inventories, % | 6.29 | 5.8 | 5.85 | 5.92 | 7.69 | 6.31 | 6.31 | 6.31 | 6.31 | 6.31 |
| Accounts Payable | 405.4 | 464.8 | 447.5 | 487.2 | 473.4 | 381.7 | 372.7 | 364.0 | 355.5 | 347.1 |
| Accounts Payable, % | 4.75 | 4.97 | 5.01 | 5.05 | 6.33 | 5.22 | 5.22 | 5.22 | 5.22 | 5.22 |
| Capital Expenditure | -74.8 | -67.3 | -79.4 | -97.3 | .0 | -51.1 | -49.9 | -48.7 | -47.6 | -46.5 |
| Capital Expenditure, % | -0.87646 | -0.71988 | -0.88934 | -1.01 | 0 | -0.6989 | -0.6989 | -0.6989 | -0.6989 | -0.6989 |
| Tax Rate, % | 24.4 | 24.4 | 24.4 | 24.4 | 24.4 | 24.4 | 24.4 | 24.4 | 24.4 | 24.4 |
| EBITAT | -60.5 | 34.4 | 17.5 | -17.2 | 62.8 | 13.3 | 13.0 | 12.7 | 12.4 | 12.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -521.9 | 99.6 | 28.8 | -71.6 | 27.1 | 147.6 | 30.1 | 29.4 | 28.7 | 28.0 |
| WACC, % | 5.27 | 4.98 | 4.62 | 4.59 | 4.64 | 4.82 | 4.82 | 4.82 | 4.82 | 4.82 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 239.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 29 | |||||||||
| Terminal Value | 1,013 | |||||||||
| Present Terminal Value | 800 | |||||||||
| Enterprise Value | 1,040 | |||||||||
| Net Debt | 848 | |||||||||
| Equity Value | 192 | |||||||||
| Diluted Shares Outstanding, MM | 35 | |||||||||
| Equity Value Per Share | 5.50 |
What You Will Get
- Real SpartanNash Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on SpartanNash's fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Customizable Financial Metrics: Adjust essential variables such as revenue growth, operating margin, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value (NPV), and other key metrics.
- High Precision Analysis: Leverages SpartanNash's actual financial data for accurate valuation results.
- Effortless Scenario Testing: Easily explore various assumptions and assess different outcomes.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Download: Obtain the comprehensive Excel file featuring SpartanNash Company’s (SPTN) financial data.
- Customize: Tailor your forecasts, including revenue growth, EBITDA %, and WACC as per your analysis.
- Update Automatically: Enjoy real-time updates for intrinsic value and NPV calculations.
- Test Scenarios: Develop various projections and instantly compare different outcomes.
- Make Decisions: Leverage the valuation results to inform your investment strategy.
Why Choose SpartanNash Company (SPTN)?
- Streamline Your Operations: Our solutions are ready to implement, saving you time and effort.
- Enhance Accuracy: Dependable data and methodologies minimize errors in your assessments.
- Completely Customizable: Adjust our offerings to fit your specific needs and forecasts.
- User-Friendly: Intuitive interfaces and clear visuals simplify the analysis process.
- Endorsed by Industry Leaders: Crafted for professionals who prioritize accuracy and efficiency.
Who Should Use This Product?
- Finance Students: Explore market strategies and apply them to real-world data using SpartanNash Company (SPTN).
- Academics: Integrate industry-specific models into your lectures or research focused on SpartanNash Company (SPTN).
- Investors: Evaluate your investment strategies and analyze the financial performance of SpartanNash Company (SPTN).
- Analysts: Enhance your analysis process with a tailored, efficient DCF model for SpartanNash Company (SPTN).
- Small Business Owners: Understand how large corporations like SpartanNash Company (SPTN) are evaluated in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled SpartanNash Company (SPTN) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for SpartanNash Company (SPTN).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.