International Flavors & Fragrances Inc. (IFF) 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
International Flavors & Fragrances Inc. (IFF) Bundle
Simplify International Flavors & Fragrances Inc. (IFF) valuation with this customizable DCF Calculator! Featuring real International Flavors & Fragrances Inc. (IFF) financials and adjustable forecast inputs, you can test scenarios and uncover International Flavors & Fragrances Inc. (IFF) fair value in minutes.
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 | 5,140.1 | 5,084.2 | 11,656.0 | 12,440.0 | 11,479.0 | 14,288.9 | 17,786.6 | 22,140.6 | 27,560.3 | 34,306.7 |
| Revenue Growth, % | 0 | -1.09 | 129.26 | 6.73 | -7.73 | 24.48 | 24.48 | 24.48 | 24.48 | 24.48 |
| EBITDA | 1,018.1 | 897.7 | 1,798.0 | -110.0 | -996.0 | 1,238.2 | 1,541.3 | 1,918.6 | 2,388.3 | 2,972.9 |
| EBITDA, % | 19.81 | 17.66 | 15.43 | -0.88424 | -8.68 | 8.67 | 8.67 | 8.67 | 8.67 | 8.67 |
| Depreciation | 323.3 | 325.4 | 1,156.0 | 1,179.0 | 1,142.0 | 1,201.2 | 1,495.3 | 1,861.3 | 2,316.9 | 2,884.1 |
| Depreciation, % | 6.29 | 6.4 | 9.92 | 9.48 | 9.95 | 8.41 | 8.41 | 8.41 | 8.41 | 8.41 |
| EBIT | 694.8 | 572.3 | 642.0 | -1,289.0 | -2,138.0 | 37.0 | 46.1 | 57.3 | 71.4 | 88.9 |
| EBIT, % | 13.52 | 11.26 | 5.51 | -10.36 | -18.63 | 0.25902 | 0.25902 | 0.25902 | 0.25902 | 0.25902 |
| Total Cash | 606.8 | 656.8 | 715.0 | 493.0 | 703.0 | 1,170.2 | 1,456.6 | 1,813.1 | 2,257.0 | 2,809.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,024.0 | 1,121.8 | 2,215.0 | 1,818.0 | 2,091.0 | 2,681.2 | 3,337.5 | 4,154.4 | 5,171.4 | 6,437.3 |
| Account Receivables, % | 19.92 | 22.06 | 19 | 14.61 | 18.22 | 18.76 | 18.76 | 18.76 | 18.76 | 18.76 |
| Inventories | 1,123.1 | 1,131.9 | 2,516.0 | 3,151.0 | 2,477.0 | 3,218.0 | 4,005.7 | 4,986.3 | 6,206.8 | 7,726.2 |
| Inventories, % | 21.85 | 22.26 | 21.59 | 25.33 | 21.58 | 22.52 | 22.52 | 22.52 | 22.52 | 22.52 |
| Accounts Payable | 510.4 | 555.7 | 1,532.0 | 1,418.0 | 1,378.0 | 1,640.5 | 2,042.1 | 2,542.0 | 3,164.2 | 3,938.8 |
| Accounts Payable, % | 9.93 | 10.93 | 13.14 | 11.4 | 12 | 11.48 | 11.48 | 11.48 | 11.48 | 11.48 |
| Capital Expenditure | -242.0 | -191.8 | -397.0 | -506.0 | -503.0 | -581.2 | -723.4 | -900.5 | -1,121.0 | -1,395.4 |
| Capital Expenditure, % | -4.71 | -3.77 | -3.41 | -4.07 | -4.38 | -4.07 | -4.07 | -4.07 | -4.07 | -4.07 |
| Tax Rate, % | -1.87 | -1.87 | -1.87 | -1.87 | -1.87 | -1.87 | -1.87 | -1.87 | -1.87 | -1.87 |
| EBITAT | 568.2 | 473.3 | 486.0 | -1,456.4 | -2,177.9 | 32.6 | 40.6 | 50.5 | 62.8 | 78.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -987.2 | 545.6 | -256.0 | -1,135.4 | -1,177.9 | -416.0 | -230.1 | -286.4 | -356.5 | -443.8 |
| WACC, % | 8.07 | 8.09 | 7.98 | 8.34 | 8.34 | 8.17 | 8.17 | 8.17 | 8.17 | 8.17 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,367.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -453 | |||||||||
| Terminal Value | -7,340 | |||||||||
| Present Terminal Value | -4,957 | |||||||||
| Enterprise Value | -6,325 | |||||||||
| Net Debt | 10,095 | |||||||||
| Equity Value | -16,420 | |||||||||
| Diluted Shares Outstanding, MM | 255 | |||||||||
| Equity Value Per Share | -64.39 |
What You Will Get
- Real IFF Financial Data: Pre-filled with International Flavors & Fragrances Inc.'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 IFF'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 Historical Data: IFF’s past financial statements and pre-filled forecasts.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Results: Observe IFF’s intrinsic value recalculating instantly.
- Visual Data Representation: Dashboard charts showcase valuation results and essential metrics.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file containing International Flavors & Fragrances Inc. (IFF)'s preloaded data.
- 2. Modify Assumptions: Adjust essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Immediately: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation results.
- 5. Present with Confidence: Share professional valuation insights to back your strategic decisions.
Why Choose This Calculator for International Flavors & Fragrances Inc. (IFF)?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to tailor your financial analysis.
- Real-Time Valuation: Instantly observe how changes affect IFF’s valuation.
- Preloaded Data: Comes with IFF’s actual financial figures for immediate insights.
- Relied Upon by Experts: Favored by analysts and investors for making strategic choices.
Who Should Use This Product?
- Food Scientists: Explore flavor development techniques and apply them using real-world data from IFF (IFF).
- Researchers: Integrate innovative flavor and fragrance models into academic studies or projects.
- Product Developers: Validate your product ideas and assess market trends related to IFF (IFF) offerings.
- Marketing Professionals: Enhance your campaigns with insights drawn from IFF (IFF)'s extensive market research.
- Entrepreneurs: Understand how global leaders like IFF (IFF) shape the flavor and fragrance industry.
What the Template Contains
- Preloaded IFF 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.