|
Ingevity Corporation (NGVT) DCF Valuation
US | Basic Materials | Chemicals - Specialty | NYSE
|
- ✓ 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
Ingevity Corporation (NGVT) Bundle
Explore Ingevity Corporation's (NGVT) financial future with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine Ingevity Corporation's (NGVT) intrinsic value and enhance your investment strategy.
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,292.9 | 1,216.1 | 1,391.5 | 1,668.3 | 1,692.1 | 1,818.2 | 1,953.6 | 2,099.2 | 2,255.6 | 2,423.6 |
| Revenue Growth, % | 0 | -5.94 | 14.42 | 19.89 | 1.43 | 7.45 | 7.45 | 7.45 | 7.45 | 7.45 |
| EBITDA | 412.9 | 397.8 | 337.2 | 456.3 | 224.6 | 470.9 | 506.0 | 543.7 | 584.2 | 627.7 |
| EBITDA, % | 31.94 | 32.71 | 24.23 | 27.35 | 13.27 | 25.9 | 25.9 | 25.9 | 25.9 | 25.9 |
| Depreciation | 85.0 | 118.2 | 127.2 | 124.9 | 122.8 | 146.1 | 157.0 | 168.7 | 181.3 | 194.8 |
| Depreciation, % | 6.57 | 9.72 | 9.14 | 7.49 | 7.26 | 8.04 | 8.04 | 8.04 | 8.04 | 8.04 |
| EBIT | 327.9 | 279.6 | 210.0 | 331.4 | 101.8 | 324.8 | 349.0 | 375.0 | 403.0 | 433.0 |
| EBIT, % | 25.36 | 22.99 | 15.09 | 19.86 | 6.02 | 17.87 | 17.87 | 17.87 | 17.87 | 17.87 |
| Total Cash | 56.5 | 257.7 | 275.4 | 76.7 | 95.9 | 202.2 | 217.3 | 233.5 | 250.9 | 269.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 156.2 | 166.7 | 167.0 | 249.3 | 211.0 | 237.1 | 254.8 | 273.7 | 294.1 | 316.1 |
| Account Receivables, % | 12.08 | 13.71 | 12 | 14.94 | 12.47 | 13.04 | 13.04 | 13.04 | 13.04 | 13.04 |
| Inventories | 212.5 | 189.0 | 241.2 | 335.0 | 308.8 | 318.7 | 342.4 | 367.9 | 395.4 | 424.8 |
| Inventories, % | 16.44 | 15.54 | 17.33 | 20.08 | 18.25 | 17.53 | 17.53 | 17.53 | 17.53 | 17.53 |
| Accounts Payable | 99.1 | 104.2 | 125.8 | 174.8 | 158.4 | 164.0 | 176.3 | 189.4 | 203.5 | 218.7 |
| Accounts Payable, % | 7.66 | 8.57 | 9.04 | 10.48 | 9.36 | 9.02 | 9.02 | 9.02 | 9.02 | 9.02 |
| Capital Expenditure | -114.8 | -105.9 | -103.8 | -142.5 | -109.8 | -145.7 | -156.6 | -168.3 | -180.8 | -194.3 |
| Capital Expenditure, % | -8.88 | -8.71 | -7.46 | -8.54 | -6.49 | -8.02 | -8.02 | -8.02 | -8.02 | -8.02 |
| Tax Rate, % | 46.53 | 46.53 | 46.53 | 46.53 | 46.53 | 46.53 | 46.53 | 46.53 | 46.53 | 46.53 |
| EBITAT | 264.3 | 215.7 | 152.3 | 260.1 | 54.4 | 235.3 | 252.9 | 271.7 | 292.0 | 313.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -35.1 | 246.1 | 144.8 | 115.4 | 115.5 | 205.4 | 224.1 | 240.8 | 258.7 | 278.0 |
| WACC, % | 8.41 | 8.3 | 8.16 | 8.34 | 7.57 | 8.15 | 8.15 | 8.15 | 8.15 | 8.15 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 948.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 284 | |||||||||
| Terminal Value | 4,608 | |||||||||
| Present Terminal Value | 3,114 | |||||||||
| Enterprise Value | 4,063 | |||||||||
| Net Debt | 1,439 | |||||||||
| Equity Value | 2,624 | |||||||||
| Diluted Shares Outstanding, MM | 36 | |||||||||
| Equity Value Per Share | 71.90 |
What You Will Receive
- Adjustable Forecast Parameters: Modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Data: Ingevity Corporation’s (NGVT) financial information pre-loaded to facilitate your analysis.
- Instant DCF Calculations: The model automatically computes Net Present Value (NPV) and intrinsic value for your convenience.
- Tailored and Professional Design: A refined Excel template that meets your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating forecasts, confirming strategies, and optimizing your time.
Key Features
- Accurate Ingevity Financials: Gain access to reliable pre-loaded historical data and future forecasts.
- Tailorable Forecast Assumptions: Modify highlighted cells such as WACC, growth rates, and profit margins.
- Automatic Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries for clear visualization of your valuation findings.
- Designed for All Users: An easy-to-navigate layout suitable for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Ingevity Corporation's (NGVT) preloaded data.
- 2. Modify Key Assumptions: Adjust essential inputs such as growth rates, WACC, and capital expenditures.
- 3. Instant Results: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Different Scenarios: Evaluate various forecasts to understand potential valuation results.
- 5. Present with Assurance: Share professional valuation analyses to back your strategic decisions.
Why Choose This Calculator for Ingevity Corporation (NGVT)?
- Comprehensive Tool: Combines DCF, WACC, and financial ratio analyses tailored for Ingevity Corporation (NGVT).
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes Ingevity’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on Ingevity Corporation (NGVT).
Who Should Use This Product?
- Investors: Evaluate Ingevity Corporation’s (NGVT) valuation before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies employed by established firms like Ingevity Corporation.
- Consultants: Provide comprehensive valuation analyses and reports for clients involving Ingevity Corporation.
- Students and Educators: Utilize real-time data to study and instruct on valuation practices related to Ingevity Corporation.
What the Template Contains
- Preloaded NGVT Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.