Information Services Group, Inc. (III) 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
Information Services Group, Inc. (III) Bundle
Whether you’re an investor or analyst, this (III) DCF Calculator is your go-to resource for accurate valuation. Preloaded with Information Services Group, Inc. real data, you can adjust forecasts and observe the effects in real time.
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 | 265.8 | 249.1 | 277.8 | 286.3 | 291.1 | 298.3 | 305.7 | 313.4 | 321.2 | 329.2 |
| Revenue Growth, % | 0 | -6.26 | 11.52 | 3.04 | 1.67 | 2.49 | 2.49 | 2.49 | 2.49 | 2.49 |
| EBITDA | 20.1 | 18.6 | 30.6 | 35.0 | 21.2 | 27.2 | 27.9 | 28.6 | 29.3 | 30.0 |
| EBITDA, % | 7.57 | 7.45 | 11.01 | 12.24 | 7.29 | 9.11 | 9.11 | 9.11 | 9.11 | 9.11 |
| Depreciation | 6.7 | 6.2 | 5.3 | 5.4 | 6.3 | 6.5 | 6.7 | 6.9 | 7.0 | 7.2 |
| Depreciation, % | 2.52 | 2.49 | 1.92 | 1.88 | 2.15 | 2.19 | 2.19 | 2.19 | 2.19 | 2.19 |
| EBIT | 13.4 | 12.4 | 25.3 | 29.7 | 15.0 | 20.7 | 21.2 | 21.7 | 22.2 | 22.8 |
| EBIT, % | 5.05 | 4.97 | 9.09 | 10.37 | 5.14 | 6.92 | 6.92 | 6.92 | 6.92 | 6.92 |
| Total Cash | 18.2 | 43.7 | 47.5 | 30.6 | 22.6 | 35.8 | 36.7 | 37.6 | 38.5 | 39.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 77.1 | 67.5 | 64.3 | 80.2 | 82.1 | 80.8 | 82.8 | 84.9 | 87.0 | 89.2 |
| Account Receivables, % | 29 | 27.08 | 23.16 | 28.01 | 28.21 | 27.09 | 27.09 | 27.09 | 27.09 | 27.09 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0.000000401 | 0.00000036 | 0.000000349 | 0 | 0.000000222 | 0.000000222 | 0.000000222 | 0.000000222 | 0.000000222 |
| Accounts Payable | 8.9 | 11.2 | 16.2 | 15.9 | 11.3 | 13.8 | 14.1 | 14.5 | 14.8 | 15.2 |
| Accounts Payable, % | 3.33 | 4.49 | 5.82 | 5.56 | 3.88 | 4.62 | 4.62 | 4.62 | 4.62 | 4.62 |
| Capital Expenditure | -1.9 | -1.2 | -2.3 | -3.4 | -3.4 | -2.6 | -2.7 | -2.8 | -2.8 | -2.9 |
| Capital Expenditure, % | -0.7232 | -0.47405 | -0.83504 | -1.2 | -1.18 | -0.88151 | -0.88151 | -0.88151 | -0.88151 | -0.88151 |
| Tax Rate, % | 29.76 | 29.76 | 29.76 | 29.76 | 29.76 | 29.76 | 29.76 | 29.76 | 29.76 | 29.76 |
| EBITAT | 6.3 | 5.8 | 17.0 | 21.9 | 10.5 | 12.6 | 12.9 | 13.2 | 13.6 | 13.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -57.1 | 22.7 | 28.1 | 7.8 | 6.8 | 20.3 | 15.2 | 15.6 | 16.0 | 16.4 |
| WACC, % | 7.08 | 7.09 | 7.58 | 7.74 | 7.65 | 7.43 | 7.43 | 7.43 | 7.43 | 7.43 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 68.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 17 | |||||||||
| Terminal Value | 308 | |||||||||
| Present Terminal Value | 216 | |||||||||
| Enterprise Value | 284 | |||||||||
| Net Debt | 64 | |||||||||
| Equity Value | 219 | |||||||||
| Diluted Shares Outstanding, MM | 50 | |||||||||
| Equity Value Per Share | 4.37 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to generate various scenarios.
- Real-World Data: Information Services Group, Inc. (III)’s financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and saving valuable time.
Key Features
- Comprehensive Historical Data: Information Services Group, Inc.'s (III) past financial statements along with pre-filled projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
- Real-Time Calculations: Instantly view the intrinsic value of Information Services Group, Inc. (III) as it updates dynamically.
- Intuitive Visualizations: Dashboard graphs illustrate valuation results and essential metrics for easy interpretation.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based III DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Information Services Group, Inc.'s intrinsic value.
- Test Scenarios: Explore various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for Information Services Group, Inc. (III)?
- Designed for Experts: A sophisticated tool utilized by market analysts, CFOs, and industry consultants.
- Accurate Data: Historical and forecasted financials for Information Services Group, Inc. (III) are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Utilize Information Services Group, Inc. (III)?
- Market Researchers: Access comprehensive data analytics to enhance your market studies.
- Consultants: Leverage industry insights to improve client recommendations and strategies.
- Investors: Evaluate investment opportunities and assess the performance of Information Services Group, Inc. (III).
- Corporate Executives: Utilize benchmarking tools to gauge your company's performance against industry standards.
- Students: Explore case studies and real-world applications of information services in your academic projects.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Information Services Group, Inc. (III) 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 Information Services Group, Inc. (III).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.