FGI Industries Ltd. (FGI) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
FGI Industries Ltd. (FGI) Bundle
Discover FGI Industries Ltd.'s (FGI) true potential with our professional-grade DCF Calculator! Customize essential assumptions, explore various scenarios, and evaluate how adjustments affect FGI's valuation – all within a single Excel template.
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 | 126.3 | 134.8 | 181.9 | 161.7 | 117.2 | 118.1 | 119.1 | 120.0 | 120.9 | 121.8 |
Revenue Growth, % | 0 | 6.77 | 34.94 | -11.12 | -27.5 | 0.77333 | 0.77333 | 0.77333 | 0.77333 | 0.77333 |
EBITDA | 3.0 | 6.5 | 8.0 | 5.3 | 4.2 | 4.3 | 4.4 | 4.4 | 4.5 | 4.5 |
EBITDA, % | 2.37 | 4.81 | 4.4 | 3.28 | 3.54 | 3.68 | 3.68 | 3.68 | 3.68 | 3.68 |
Depreciation | .5 | .6 | .3 | .2 | 2.0 | .7 | .7 | .7 | .7 | .7 |
Depreciation, % | 0.41584 | 0.41594 | 0.15778 | 0.13521 | 1.72 | 0.56912 | 0.56912 | 0.56912 | 0.56912 | 0.56912 |
EBIT | 2.5 | 5.9 | 7.7 | 5.1 | 2.1 | 3.7 | 3.7 | 3.7 | 3.8 | 3.8 |
EBIT, % | 1.95 | 4.39 | 4.25 | 3.15 | 1.82 | 3.11 | 3.11 | 3.11 | 3.11 | 3.11 |
Total Cash | 2.4 | 4.0 | 3.9 | 10.1 | 7.8 | 4.7 | 4.7 | 4.8 | 4.8 | 4.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 15.7 | 17.3 | 26.4 | 14.3 | 16.2 | 14.7 | 14.9 | 15.0 | 15.1 | 15.2 |
Account Receivables, % | 12.41 | 12.86 | 14.48 | 8.84 | 13.81 | 12.48 | 12.48 | 12.48 | 12.48 | 12.48 |
Inventories | 9.3 | 8.3 | 21.3 | 13.3 | 9.9 | 9.9 | 10.0 | 10.1 | 10.1 | 10.2 |
Inventories, % | 7.36 | 6.16 | 11.69 | 8.22 | 8.46 | 8.38 | 8.38 | 8.38 | 8.38 | 8.38 |
Accounts Payable | 16.7 | 19.5 | 30.8 | 14.8 | 15.3 | 15.8 | 15.9 | 16.0 | 16.2 | 16.3 |
Accounts Payable, % | 13.22 | 14.47 | 16.92 | 9.17 | 13.02 | 13.36 | 13.36 | 13.36 | 13.36 | 13.36 |
Capital Expenditure | -.2 | -.1 | -.1 | -1.1 | -.9 | -.4 | -.4 | -.4 | -.4 | -.4 |
Capital Expenditure, % | -0.18519 | -0.05676282 | -0.03178962 | -0.65807 | -0.80399 | -0.34716 | -0.34716 | -0.34716 | -0.34716 | -0.34716 |
Tax Rate, % | 47.14 | 47.14 | 47.14 | 47.14 | 47.14 | 47.14 | 47.14 | 47.14 | 47.14 | 47.14 |
EBITAT | 2.0 | 5.1 | 6.9 | 4.1 | 1.1 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -6.0 | 7.7 | -3.6 | 7.3 | 4.1 | 5.1 | 3.1 | 3.1 | 3.1 | 3.1 |
WACC, % | 5.41 | 5.62 | 5.73 | 5.46 | 4.54 | 5.35 | 5.35 | 5.35 | 5.35 | 5.35 |
PV UFCF | ||||||||||
SUM PV UFCF | 15.2 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 3 | |||||||||
Terminal Value | 65 | |||||||||
Present Terminal Value | 50 | |||||||||
Enterprise Value | 65 | |||||||||
Net Debt | 14 | |||||||||
Equity Value | 51 | |||||||||
Diluted Shares Outstanding, MM | 10 | |||||||||
Equity Value Per Share | 5.19 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real FGI financial data.
- Authentic Data: Historical performance metrics and forward-looking projections (highlighted in the yellow cells).
- Forecast Adaptability: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect FGI’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Comprehensive Data: FGI Industries Ltd.’s (FGI) historical financial records and pre-filled projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Insights: Watch FGI’s intrinsic value update instantly as you adjust inputs.
- Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file for FGI Industries Ltd. (FGI).
- Step 2: Review pre-entered FGI data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for FGI’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for FGI Industries Ltd. (FGI)?
- Reliable Data: Utilize authentic FGI financials for trustworthy valuation outcomes.
- Flexible Customization: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Efficient: Built-in calculations save you the hassle of starting from the ground up.
- Professional-Quality Tool: Tailored for investors, analysts, and consultants in the industry.
- Easy to Use: User-friendly design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Investors: Evaluate FGI Industries Ltd. (FGI) for informed stock trading decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of established companies like FGI Industries Ltd. (FGI).
- Consultants: Create comprehensive valuation reports to support client needs.
- Students and Educators: Utilize real-time data to enhance learning and application of valuation principles.
What the FGI Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for FGI Industries Ltd. (FGI).
- Real-World Data: FGI’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into FGI's performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to FGI.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results regarding FGI's financial health.