John B. Sanfilippo & Son, Inc. (JBSS) 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
John B. Sanfilippo & Son, Inc. (JBSS) Bundle
Simplify John B. Sanfilippo & Son, Inc. (JBSS) valuation with this customizable DCF Calculator! Featuring real John B. Sanfilippo & Son, Inc. (JBSS) financials and adjustable forecast inputs, you can test scenarios and uncover John B. Sanfilippo & Son, Inc. (JBSS) fair value in minutes.
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 | 880.1 | 858.5 | 955.9 | 999.7 | 1,066.8 | 1,066.9 | 1,067.0 | 1,067.0 | 1,067.1 | 1,067.2 |
Revenue Growth, % | 0 | -2.46 | 11.34 | 4.58 | 6.71 | 0.00826809 | 0.00826809 | 0.00826809 | 0.00826809 | 0.00826809 |
EBITDA | 92.7 | 99.6 | 99.6 | 108.0 | 109.1 | 114.3 | 114.3 | 114.3 | 114.3 | 114.3 |
EBITDA, % | 10.53 | 11.6 | 10.42 | 10.81 | 10.23 | 10.71 | 10.71 | 10.71 | 10.71 | 10.71 |
Depreciation | 17.9 | 18.3 | 18.3 | 20.5 | 26.6 | 22.7 | 22.7 | 22.7 | 22.7 | 22.7 |
Depreciation, % | 2.04 | 2.13 | 1.91 | 2.05 | 2.49 | 2.13 | 2.13 | 2.13 | 2.13 | 2.13 |
EBIT | 74.7 | 81.3 | 81.3 | 87.5 | 82.5 | 91.6 | 91.6 | 91.6 | 91.7 | 91.7 |
EBIT, % | 8.49 | 9.47 | 8.5 | 8.75 | 7.73 | 8.59 | 8.59 | 8.59 | 8.59 | 8.59 |
Total Cash | 1.5 | .7 | .4 | 1.9 | .5 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 57.0 | 66.4 | 69.6 | 72.7 | 85.0 | 78.4 | 78.4 | 78.4 | 78.4 | 78.4 |
Account Receivables, % | 6.47 | 7.74 | 7.28 | 7.28 | 7.96 | 7.35 | 7.35 | 7.35 | 7.35 | 7.35 |
Inventories | 172.1 | 148.0 | 204.9 | 172.9 | 196.6 | 200.5 | 200.5 | 200.5 | 200.5 | 200.5 |
Inventories, % | 19.55 | 17.24 | 21.43 | 17.3 | 18.43 | 18.79 | 18.79 | 18.79 | 18.79 | 18.79 |
Accounts Payable | 36.3 | 48.9 | 47.7 | 42.7 | 53.4 | 51.4 | 51.4 | 51.4 | 51.4 | 51.4 |
Accounts Payable, % | 4.13 | 5.69 | 4.99 | 4.27 | 5.01 | 4.82 | 4.82 | 4.82 | 4.82 | 4.82 |
Capital Expenditure | -15.0 | -25.2 | -17.8 | -20.7 | -28.3 | -24.0 | -24.0 | -24.0 | -24.0 | -24.0 |
Capital Expenditure, % | -1.71 | -2.93 | -1.86 | -2.07 | -2.65 | -2.24 | -2.24 | -2.24 | -2.24 | -2.24 |
Tax Rate, % | 24.63 | 24.63 | 24.63 | 24.63 | 24.63 | 24.63 | 24.63 | 24.63 | 24.63 | 24.63 |
EBITAT | 55.6 | 60.8 | 61.5 | 64.4 | 62.2 | 68.5 | 68.5 | 68.5 | 68.5 | 68.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -134.2 | 81.1 | .8 | 88.0 | 35.4 | 67.9 | 67.2 | 67.2 | 67.2 | 67.3 |
WACC, % | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 |
PV UFCF | ||||||||||
SUM PV UFCF | 289.4 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | 70 | |||||||||
Terminal Value | 3,886 | |||||||||
Present Terminal Value | 3,003 | |||||||||
Enterprise Value | 3,293 | |||||||||
Net Debt | 55 | |||||||||
Equity Value | 3,237 | |||||||||
Diluted Shares Outstanding, MM | 12 | |||||||||
Equity Value Per Share | 277.00 |
What You Will Get
- Real JBSS 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 JBSS’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
- Real-Life JBSS Data: Pre-filled with John B. Sanfilippo & Son, Inc.'s historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures to suit your analysis.
- Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your adjusted inputs.
- Scenario Testing: Develop various forecasting scenarios to evaluate different valuation results.
- User-Friendly Design: Intuitive, organized, and crafted for both professionals and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based JBSS DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional factors.
- Instant Calculations: The model automatically calculates the intrinsic value of John B. Sanfilippo & Son, Inc. (JBSS).
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis decisions.
Why Choose JBSS?
- Quality Products: Our commitment to excellence ensures top-notch products for our customers.
- Industry Expertise: Decades of experience in the nut and snack industry guarantee reliable service.
- Sustainable Practices: We prioritize environmentally friendly processes in our operations.
- Customer-Centric Approach: Our team is dedicated to understanding and meeting your unique needs.
- Proven Track Record: Trusted by retailers and consumers alike, JBSS stands for quality and integrity.
Who Should Use John B. Sanfilippo & Son, Inc. (JBSS)?
- Investors: Gain insights and make informed decisions with a leading player in the nut industry.
- Financial Analysts: Analyze market trends and performance metrics of a well-established company.
- Consultants: Utilize JBSS's data for impactful client recommendations and strategic planning.
- Food Industry Enthusiasts: Explore the dynamics of the nut market and its growth potential.
- Educators and Students: Incorporate JBSS as a case study in finance and business courses.
What the Template Contains
- Historical Data: Includes John B. Sanfilippo & Son, Inc.'s (JBSS) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate John B. Sanfilippo & Son, Inc.'s (JBSS) 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 John B. Sanfilippo & Son, Inc.'s (JBSS) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.