Flexible Solutions International, Inc. (FSI) 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
Flexible Solutions International, Inc. (FSI) Bundle
Evaluate Flexible Solutions International, Inc.'s (FSI) financial outlook like a professional! This (FSI) DCF Calculator offers pre-filled financial data and full flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
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 | 27.4 | 31.4 | 34.4 | 45.8 | 38.3 | 42.2 | 46.5 | 51.3 | 56.5 | 62.3 |
| Revenue Growth, % | 0 | 14.46 | 9.58 | 33.19 | -16.4 | 10.21 | 10.21 | 10.21 | 10.21 | 10.21 |
| EBITDA | 3.4 | 6.6 | 8.1 | 9.5 | 5.9 | 7.8 | 8.6 | 9.5 | 10.5 | 11.6 |
| EBITDA, % | 12.26 | 21.13 | 23.48 | 20.68 | 15.29 | 18.57 | 18.57 | 18.57 | 18.57 | 18.57 |
| Depreciation | .6 | 1.2 | 1.2 | 1.3 | 1.7 | 1.4 | 1.6 | 1.7 | 1.9 | 2.1 |
| Depreciation, % | 2.26 | 3.77 | 3.58 | 2.9 | 4.54 | 3.41 | 3.41 | 3.41 | 3.41 | 3.41 |
| EBIT | 2.7 | 5.5 | 6.9 | 8.2 | 4.1 | 6.4 | 7.1 | 7.8 | 8.6 | 9.4 |
| EBIT, % | 10 | 17.36 | 19.91 | 17.78 | 10.76 | 15.16 | 15.16 | 15.16 | 15.16 | 15.16 |
| Total Cash | 3.6 | 4.5 | 6.7 | 6.8 | 7.7 | 6.9 | 7.6 | 8.4 | 9.3 | 10.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 4.5 | 5.9 | 7.1 | 9.4 | 9.8 | 8.6 | 9.5 | 10.5 | 11.5 | 12.7 |
| Account Receivables, % | 16.29 | 18.75 | 20.71 | 20.61 | 25.68 | 20.41 | 20.41 | 20.41 | 20.41 | 20.41 |
| Inventories | 9.2 | 8.4 | 9.5 | 14.4 | 11.1 | 12.5 | 13.8 | 15.2 | 16.8 | 18.5 |
| Inventories, % | 33.46 | 26.66 | 27.61 | 31.46 | 29.05 | 29.65 | 29.65 | 29.65 | 29.65 | 29.65 |
| Accounts Payable | .6 | .6 | 1.3 | .9 | 2.0 | 1.3 | 1.4 | 1.5 | 1.7 | 1.9 |
| Accounts Payable, % | 2.32 | 1.78 | 3.73 | 1.91 | 5.18 | 2.98 | 2.98 | 2.98 | 2.98 | 2.98 |
| Capital Expenditure | -1.8 | -1.1 | -.8 | -2.0 | -5.0 | -2.5 | -2.8 | -3.0 | -3.4 | -3.7 |
| Capital Expenditure, % | -6.67 | -3.41 | -2.27 | -4.32 | -13.02 | -5.94 | -5.94 | -5.94 | -5.94 | -5.94 |
| Tax Rate, % | 23.39 | 23.39 | 23.39 | 23.39 | 23.39 | 23.39 | 23.39 | 23.39 | 23.39 | 23.39 |
| EBITAT | 2.3 | 3.1 | 3.6 | 7.3 | 3.2 | 4.6 | 5.0 | 5.6 | 6.1 | 6.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -12.0 | 2.6 | 2.4 | -1.0 | 3.9 | 2.6 | 1.8 | 2.0 | 2.2 | 2.5 |
| WACC, % | 10.11 | 9.88 | 9.83 | 10.17 | 10.06 | 10.01 | 10.01 | 10.01 | 10.01 | 10.01 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 8.5 | |||||||||
| Long Term Growth Rate, % | 1.00 | |||||||||
| Free cash flow (T + 1) | 2 | |||||||||
| Terminal Value | 28 | |||||||||
| Present Terminal Value | 17 | |||||||||
| Enterprise Value | 26 | |||||||||
| Net Debt | 5 | |||||||||
| Equity Value | 21 | |||||||||
| Diluted Shares Outstanding, MM | 12 | |||||||||
| Equity Value Per Share | 1.65 |
What You Will Get
- Real FSI Financial Data: Pre-filled with Flexible Solutions International’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 FSI’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
- Comprehensive Data: Flexible Solutions International’s historical financial records and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Observe the intrinsic value of Flexible Solutions International recalculating instantly.
- Intuitive Visual Outputs: Dashboard graphs showcase valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file containing Flexible Solutions International, Inc. (FSI)'s preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results in Real-Time: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation scenarios.
- 5. Present with Assurance: Deliver professional valuation insights to back your strategic decisions.
Why Choose Flexible Solutions International, Inc. (FSI) Calculator?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses for comprehensive evaluations.
- Adjustable Parameters: Modify the highlighted cells to explore a variety of financial scenarios.
- In-Depth Analysis: Automatically computes FSI’s intrinsic value and Net Present Value for informed decisions.
- Integrated Data: Features historical and projected data for reliable baseline assessments.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors looking for precision.
Who Should Use This Product?
- Individual Investors: Gain insights for making informed decisions about investing in Flexible Solutions International, Inc. (FSI).
- Financial Analysts: Enhance valuation methodologies with comprehensive financial models tailored for FSI.
- Consultants: Provide clients with expert valuation analyses and recommendations related to FSI.
- Business Owners: Learn from FSI's valuation to inform your own business strategies and decisions.
- Finance Students: Explore practical valuation techniques using data and case studies from FSI.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Flexible Solutions International, Inc. (FSI) 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 Flexible Solutions International, Inc. (FSI).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.