|
HF Foods Group Inc. (HFFG) Valoración de DCF
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
HF Foods Group Inc. (HFFG) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (HFFG)! Utilizando datos reales de HF Foods Group Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valor (HFFG) como un inversor experimentado.
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 | 388.2 | 566.8 | 796.9 | 1,170.5 | 1,148.5 | 1,213.4 | 1,282.0 | 1,354.5 | 1,431.1 | 1,512.1 |
Revenue Growth, % | 0 | 46.03 | 40.59 | 46.88 | -1.88 | 5.65 | 5.65 | 5.65 | 5.65 | 5.65 |
EBITDA | 14.8 | -322.7 | 52.8 | 36.8 | 34.8 | -97.8 | -103.4 | -109.2 | -115.4 | -121.9 |
EBITDA, % | 3.82 | -56.94 | 6.63 | 3.15 | 3.03 | -8.06 | -8.06 | -8.06 | -8.06 | -8.06 |
Depreciation | 5.1 | 20.9 | 21.4 | 29.4 | 25.9 | 30.2 | 31.9 | 33.7 | 35.6 | 37.6 |
Depreciation, % | 1.31 | 3.68 | 2.69 | 2.51 | 2.26 | 2.49 | 2.49 | 2.49 | 2.49 | 2.49 |
EBIT | 9.8 | -343.6 | 31.4 | 7.5 | 8.9 | -128.0 | -135.3 | -142.9 | -151.0 | -159.5 |
EBIT, % | 2.51 | -60.62 | 3.94 | 0.63744 | 0.77118 | -10.55 | -10.55 | -10.55 | -10.55 | -10.55 |
Total Cash | 14.5 | 9.6 | 14.8 | 24.3 | 15.2 | 26.0 | 27.4 | 29.0 | 30.6 | 32.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 54.2 | 26.1 | 36.5 | 44.4 | 47.8 | 75.5 | 79.8 | 84.3 | 89.1 | 94.1 |
Account Receivables, % | 13.97 | 4.61 | 4.58 | 3.79 | 4.16 | 6.22 | 6.22 | 6.22 | 6.22 | 6.22 |
Inventories | 77.5 | 58.5 | 102.7 | 120.3 | 105.6 | 152.1 | 160.7 | 169.8 | 179.4 | 189.5 |
Inventories, % | 19.97 | 10.33 | 12.89 | 10.28 | 9.2 | 12.53 | 12.53 | 12.53 | 12.53 | 12.53 |
Accounts Payable | 44.2 | 29.6 | 59.7 | 57.0 | 52.0 | 81.3 | 85.9 | 90.8 | 95.9 | 101.3 |
Accounts Payable, % | 11.39 | 5.23 | 7.49 | 4.87 | 4.53 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 |
Capital Expenditure | -4.8 | -.7 | -2.2 | -6.3 | -3.5 | -6.0 | -6.4 | -6.7 | -7.1 | -7.5 |
Capital Expenditure, % | -1.25 | -0.11727 | -0.2767 | -0.53714 | -0.30597 | -0.49659 | -0.49659 | -0.49659 | -0.49659 | -0.49659 |
Tax Rate, % | 17.05 | 17.05 | 17.05 | 17.05 | 17.05 | 17.05 | 17.05 | 17.05 | 17.05 | 17.05 |
EBITAT | 6.5 | -338.8 | 25.5 | 438.3 | 7.3 | -109.9 | -116.1 | -122.7 | -129.6 | -137.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -80.8 | -286.1 | 20.2 | 433.3 | 36.0 | -130.6 | -98.9 | -104.4 | -110.4 | -116.6 |
WACC, % | 7.26 | 8.24 | 7.7 | 8.28 | 7.76 | 7.85 | 7.85 | 7.85 | 7.85 | 7.85 |
PV UFCF | ||||||||||
SUM PV UFCF | -450.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -119 | |||||||||
Terminal Value | -2,033 | |||||||||
Present Terminal Value | -1,393 | |||||||||
Enterprise Value | -1,844 | |||||||||
Net Debt | 188 | |||||||||
Equity Value | -2,032 | |||||||||
Diluted Shares Outstanding, MM | 54 | |||||||||
Equity Value Per Share | -37.71 |
What You Will Get
- Real HFFG Financial Data: Pre-filled with HF Foods Group Inc.’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 HF Foods Group Inc.’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
- Customizable Financial Inputs: Adjust vital metrics such as sales growth, operating margin, and capital investment.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- High-Precision Results: Leverages HF Foods Group Inc.’s (HFFG) actual financial data for accurate valuation results.
- Effortless Scenario Simulation: Easily explore various assumptions and analyze resulting impacts.
- Efficiency Booster: Avoid the hassle of creating intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file for HF Foods Group Inc. (HFFG).
- Step 2: Review the pre-filled financial data and forecasts for HF Foods Group Inc. (HFFG).
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for HF Foods Group Inc. (HFFG)?
- Accurate Data: Utilize real HF Foods Group financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the food industry.
- User-Friendly: With an intuitive design and clear instructions, it's accessible for all users.
Who Should Use This Product?
- Investors: Accurately estimate HF Foods Group Inc.'s (HFFG) fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to HF Foods Group Inc. (HFFG).
- Consultants: Quickly adapt the template for valuation reports tailored to HF Foods Group Inc. (HFFG) clients.
- Entrepreneurs: Gain insights into financial modeling practices employed by leading companies like HF Foods Group Inc. (HFFG).
- Educators: Use it as a teaching tool to illustrate valuation methodologies relevant to HF Foods Group Inc. (HFFG).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled HF Foods Group Inc. (HFFG) 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 HF Foods Group Inc. (HFFG).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.