|
Farmer Bros. Co. (granja) Valoración de DCF
US | Consumer Defensive | Packaged Foods | 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
Farmer Bros. Co. (FARM) Bundle
Diseñada para la precisión, nuestra calculadora DCF (agrícola) le permite evaluar la valoración de Farmer Bros. Co. utilizando datos financieros integrales y ofrece una flexibilidad completa para modificar todos los parámetros esenciales para mejorar las proyecciones.
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 | 501.3 | 397.9 | 469.2 | 340.0 | 341.1 | 315.6 | 292.0 | 270.1 | 249.9 | 231.2 |
| Revenue Growth, % | 0 | -20.64 | 17.93 | -27.54 | 0.33239 | -7.48 | -7.48 | -7.48 | -7.48 | -7.48 |
| EBITDA | 2.3 | 16.3 | 18.5 | -3.9 | 15.6 | 7.5 | 6.9 | 6.4 | 5.9 | 5.5 |
| EBITDA, % | 0.46019 | 4.09 | 3.95 | -1.16 | 4.56 | 2.38 | 2.38 | 2.38 | 2.38 | 2.38 |
| Depreciation | 29.9 | 30.0 | 23.8 | 22.2 | 11.6 | 18.0 | 16.6 | 15.4 | 14.2 | 13.2 |
| Depreciation, % | 5.96 | 7.54 | 5.07 | 6.52 | 3.4 | 5.7 | 5.7 | 5.7 | 5.7 | 5.7 |
| EBIT | -27.6 | -13.7 | -5.3 | -26.1 | 4.0 | -10.5 | -9.7 | -9.0 | -8.3 | -7.7 |
| EBIT, % | -5.5 | -3.45 | -1.13 | -7.68 | 1.17 | -3.32 | -3.32 | -3.32 | -3.32 | -3.32 |
| Total Cash | 60.0 | 10.3 | 9.8 | 5.2 | 5.8 | 12.6 | 11.6 | 10.7 | 9.9 | 9.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 41.7 | 40.3 | 46.9 | 45.1 | 35.1 | 32.8 | 30.4 | 28.1 | 26.0 | 24.1 |
| Account Receivables, % | 8.32 | 10.13 | 10 | 13.27 | 10.3 | 10.41 | 10.41 | 10.41 | 10.41 | 10.41 |
| Inventories | 67.4 | 76.8 | 99.6 | 49.3 | 57.2 | 53.8 | 49.8 | 46.1 | 42.6 | 39.4 |
| Inventories, % | 13.45 | 19.3 | 21.23 | 14.49 | 16.78 | 17.05 | 17.05 | 17.05 | 17.05 | 17.05 |
| Accounts Payable | 37.0 | 45.7 | 52.9 | 60.1 | 48.5 | 39.1 | 36.2 | 33.5 | 31.0 | 28.7 |
| Accounts Payable, % | 7.38 | 11.49 | 11.27 | 17.67 | 14.21 | 12.4 | 12.4 | 12.4 | 12.4 | 12.4 |
| Capital Expenditure | -17.6 | -15.1 | -15.2 | -15.0 | -13.8 | -12.0 | -11.1 | -10.3 | -9.5 | -8.8 |
| Capital Expenditure, % | -3.5 | -3.8 | -3.23 | -4.42 | -4.06 | -3.8 | -3.8 | -3.8 | -3.8 | -3.8 |
| Tax Rate, % | -0.3626 | -0.3626 | -0.3626 | -0.3626 | -0.3626 | -0.3626 | -0.3626 | -0.3626 | -0.3626 | -0.3626 |
| EBITAT | -27.4 | -20.4 | -5.2 | -60.2 | 4.0 | -10.4 | -9.6 | -8.9 | -8.3 | -7.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -87.2 | -4.8 | -18.8 | 6.3 | -7.8 | -8.0 | -.6 | -.5 | -.5 | -.4 |
| WACC, % | 13.02 | 13.06 | 12.9 | 13.06 | 13.06 | 13.02 | 13.02 | 13.02 | 13.02 | 13.02 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -8.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | -4 | |||||||||
| Present Terminal Value | -2 | |||||||||
| Enterprise Value | -11 | |||||||||
| Net Debt | 54 | |||||||||
| Equity Value | -64 | |||||||||
| Diluted Shares Outstanding, MM | 21 | |||||||||
| Equity Value Per Share | -3.08 |
What You Will Get
- Real Farmer Bros. 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 Farmer Bros. Co.'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
- Comprehensive Data: Farmer Bros. Co. (FARM) historical financial statements and pre-filled forecasts.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: View the intrinsic value of Farmer Bros. Co. (FARM) recalculating instantly.
- Intuitive Visualizations: Dashboard charts present valuation results and essential metrics clearly.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based FARM DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Farmer Bros. Co.'s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial assessment.
Why Choose Farmer Bros. Co. (FARM)?
- Quality Products: Our commitment to excellence ensures top-notch coffee and tea offerings.
- Innovative Solutions: We leverage cutting-edge technology to enhance your beverage experience.
- Customer-Centric Approach: Tailored services and support to meet the unique needs of your business.
- Proven Track Record: Trusted by thousands of clients for our reliability and consistency.
- Sustainable Practices: We prioritize environmentally friendly methods in our sourcing and operations.
Who Should Use This Product?
- Investors: Accurately estimate Farmer Bros. Co.’s (FARM) fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Farmer Bros. Co. (FARM).
- Consultants: Easily customize the template for valuation reports tailored to clients focused on Farmer Bros. Co. (FARM).
- Entrepreneurs: Discover financial modeling techniques employed by industry leaders, including Farmer Bros. Co. (FARM).
- Educators: Implement it as a teaching resource to illustrate valuation methodologies relevant to Farmer Bros. Co. (FARM).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Farmer Bros. Co. (FARM).
- Real-World Data: Historical and projected financials for Farmer Bros. Co. (FARM) preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns to provide deeper insights into Farmer Bros. Co. (FARM).
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Farmer Bros. Co. (FARM).
- Dashboard with Visual Outputs: Charts and tables designed to present clear, actionable results for Farmer Bros. Co. (FARM).