ICF International, Inc. (ICFI) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
ICF International, Inc. (ICFI) Bundle
Whether you’re an investor or analyst, this (ICFI) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from ICF International, Inc., you can adjust forecasts and immediately observe the effects.
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 | 1,478.5 | 1,506.9 | 1,553.0 | 1,780.0 | 1,963.2 | 2,109.9 | 2,267.6 | 2,437.0 | 2,619.1 | 2,814.8 |
Revenue Growth, % | 0 | 1.92 | 3.06 | 14.61 | 10.3 | 7.47 | 7.47 | 7.47 | 7.47 | 7.47 |
EBITDA | 127.4 | 122.0 | 150.8 | 157.2 | 200.7 | 191.9 | 206.3 | 221.7 | 238.3 | 256.1 |
EBITDA, % | 8.62 | 8.1 | 9.71 | 8.83 | 10.22 | 9.1 | 9.1 | 9.1 | 9.1 | 9.1 |
Depreciation | 26.9 | 31.4 | 32.0 | 49.9 | 60.7 | 50.1 | 53.8 | 57.8 | 62.2 | 66.8 |
Depreciation, % | 1.82 | 2.09 | 2.06 | 2.8 | 3.09 | 2.37 | 2.37 | 2.37 | 2.37 | 2.37 |
EBIT | 100.5 | 90.6 | 118.8 | 107.3 | 140.0 | 141.9 | 152.5 | 163.9 | 176.1 | 189.3 |
EBIT, % | 6.8 | 6.01 | 7.65 | 6.03 | 7.13 | 6.72 | 6.72 | 6.72 | 6.72 | 6.72 |
Total Cash | 6.5 | 13.8 | 8.3 | 11.3 | 9.4 | 12.7 | 13.6 | 14.6 | 15.7 | 16.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 410.8 | 368.2 | 386.4 | 413.0 | 409.7 | 511.3 | 549.5 | 590.6 | 634.7 | 682.2 |
Account Receivables, % | 27.79 | 24.43 | 24.88 | 23.21 | 20.87 | 24.23 | 24.23 | 24.23 | 24.23 | 24.23 |
Inventories | .0 | 68.1 | 12.2 | 1.7 | .0 | 22.8 | 24.5 | 26.3 | 28.3 | 30.4 |
Inventories, % | 0.0000000676 | 4.52 | 0.7842 | 0.09612554 | 0 | 1.08 | 1.08 | 1.08 | 1.08 | 1.08 |
Accounts Payable | 134.6 | 91.4 | 105.7 | 135.8 | 134.5 | 153.8 | 165.3 | 177.6 | 190.9 | 205.2 |
Accounts Payable, % | 9.1 | 6.06 | 6.8 | 7.63 | 6.85 | 7.29 | 7.29 | 7.29 | 7.29 | 7.29 |
Capital Expenditure | -26.9 | -17.7 | -19.9 | -24.5 | -22.3 | -28.6 | -30.8 | -33.1 | -35.6 | -38.2 |
Capital Expenditure, % | -1.82 | -1.17 | -1.28 | -1.38 | -1.14 | -1.36 | -1.36 | -1.36 | -1.36 | -1.36 |
Tax Rate, % | 14.43 | 14.43 | 14.43 | 14.43 | 14.43 | 14.43 | 14.43 | 14.43 | 14.43 | 14.43 |
EBITAT | 76.8 | 66.7 | 84.5 | 82.1 | 119.8 | 108.7 | 116.8 | 125.6 | 135.0 | 145.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -199.4 | 11.7 | 148.6 | 121.4 | 162.0 | 25.0 | 111.4 | 119.8 | 128.7 | 138.3 |
WACC, % | 6.75 | 6.71 | 6.68 | 6.75 | 6.87 | 6.75 | 6.75 | 6.75 | 6.75 | 6.75 |
PV UFCF | ||||||||||
SUM PV UFCF | 418.5 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | 143 | |||||||||
Terminal Value | 4,403 | |||||||||
Present Terminal Value | 3,176 | |||||||||
Enterprise Value | 3,594 | |||||||||
Net Debt | 636 | |||||||||
Equity Value | 2,958 | |||||||||
Diluted Shares Outstanding, MM | 19 | |||||||||
Equity Value Per Share | 155.73 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled financials for ICF International, Inc. (ICFI).
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Quickly observe the effect of your inputs on ICF International's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and simplicity, complete with step-by-step instructions.
Key Features
- 🔍 Real-Life ICFI Financials: Pre-filled historical and projected data for ICF International, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate ICF International’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize ICF International’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Model: Download and open the Excel template featuring ICF International, Inc. (ICFI) data.
- 2. Adjust Key Inputs: Modify essential parameters such as revenue projections, discount rates, and operating expenses.
- 3. Analyze Results Quickly: The DCF model automatically computes intrinsic value and net present value (NPV).
- 4. Explore Different Scenarios: Evaluate various forecasts to understand potential valuation variations.
- 5. Present with Assurance: Deliver expert valuation analyses to enhance your strategic decisions.
Why Choose This Calculator for ICF International, Inc. (ICFI)?
- User-Friendly Interface: Crafted for both novices and seasoned professionals.
- Customizable Parameters: Adjust inputs effortlessly to suit your financial analysis.
- Real-Time Feedback: Monitor immediate updates to ICFI's valuation as you change inputs.
- Preconfigured Data: Comes with ICFI's actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making educated choices.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and dependable valuation models for analyzing ICF International, Inc. (ICFI) portfolios.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Offer clients precise valuation insights related to ICF International, Inc. (ICFI) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Industry Analysts: Gain insights into how companies like ICF International, Inc. (ICFI) are valued in the marketplace.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for ICF International, Inc. (ICFI).
- Real-World Data: ICFI’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into ICFI's performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to ICFI.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results related to ICF International, Inc. (ICFI).