O-I Glass, Inc. (OI) 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
O-I Glass, Inc. (OI) Bundle
Enhance your investment strategies with the O-I Glass, Inc. (OI) DCF Calculator! Review authentic financial data for O-I Glass, adjust growth projections and expenses, and observe how these modifications affect the intrinsic value of O-I Glass, Inc. (OI) 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 | 6,691.0 | 6,091.0 | 6,357.0 | 6,856.0 | 7,105.0 | 7,227.2 | 7,351.6 | 7,478.0 | 7,606.7 | 7,737.5 |
| Revenue Growth, % | 0 | -8.97 | 4.37 | 7.85 | 3.63 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 |
| EBITDA | 494.0 | 1,031.0 | 949.0 | 1,439.0 | 892.0 | 1,052.0 | 1,070.1 | 1,088.5 | 1,107.3 | 1,126.3 |
| EBITDA, % | 7.38 | 16.93 | 14.93 | 20.99 | 12.55 | 14.56 | 14.56 | 14.56 | 14.56 | 14.56 |
| Depreciation | 444.0 | 414.0 | 401.0 | 395.0 | 483.0 | 466.9 | 474.9 | 483.1 | 491.4 | 499.8 |
| Depreciation, % | 6.64 | 6.8 | 6.31 | 5.76 | 6.8 | 6.46 | 6.46 | 6.46 | 6.46 | 6.46 |
| EBIT | 50.0 | 617.0 | 548.0 | 1,044.0 | 409.0 | 585.1 | 595.2 | 605.4 | 615.9 | 626.5 |
| EBIT, % | 0.74727 | 10.13 | 8.62 | 15.23 | 5.76 | 8.1 | 8.1 | 8.1 | 8.1 | 8.1 |
| Total Cash | 551.0 | 563.0 | 725.0 | 773.0 | 913.0 | 766.2 | 779.4 | 792.8 | 806.4 | 820.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 621.0 | 623.0 | 692.0 | 760.0 | 671.0 | 736.1 | 748.7 | 761.6 | 774.7 | 788.1 |
| Account Receivables, % | 9.28 | 10.23 | 10.89 | 11.09 | 9.44 | 10.18 | 10.18 | 10.18 | 10.18 | 10.18 |
| Inventories | 1,045.0 | 841.0 | 816.0 | 848.0 | 1,071.0 | 1,007.5 | 1,024.9 | 1,042.5 | 1,060.4 | 1,078.7 |
| Inventories, % | 15.62 | 13.81 | 12.84 | 12.37 | 15.07 | 13.94 | 13.94 | 13.94 | 13.94 | 13.94 |
| Accounts Payable | 1,276.0 | 1,126.0 | 1,210.0 | 1,355.0 | 1,437.0 | 1,396.0 | 1,420.0 | 1,444.5 | 1,469.3 | 1,494.6 |
| Accounts Payable, % | 19.07 | 18.49 | 19.03 | 19.76 | 20.23 | 19.32 | 19.32 | 19.32 | 19.32 | 19.32 |
| Capital Expenditure | -426.0 | -311.0 | -398.0 | -539.0 | -688.0 | -509.9 | -518.7 | -527.6 | -536.7 | -545.9 |
| Capital Expenditure, % | -6.37 | -5.11 | -6.26 | -7.86 | -9.68 | -7.06 | -7.06 | -7.06 | -7.06 | -7.06 |
| Tax Rate, % | 253.73 | 253.73 | 253.73 | 253.73 | 253.73 | 253.73 | 253.73 | 253.73 | 253.73 | 253.73 |
| EBITAT | 72.6 | 435.2 | 245.9 | 757.4 | -628.8 | 337.0 | 342.8 | 348.7 | 354.7 | 360.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -299.4 | 590.2 | 288.9 | 658.4 | -885.8 | 251.3 | 293.0 | 298.1 | 303.2 | 308.4 |
| WACC, % | 7.44 | 5.95 | 4.66 | 6.05 | 2.39 | 5.3 | 5.3 | 5.3 | 5.3 | 5.3 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,243.1 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 310 | |||||||||
| Terminal Value | 6,460 | |||||||||
| Present Terminal Value | 4,990 | |||||||||
| Enterprise Value | 6,233 | |||||||||
| Net Debt | 4,261 | |||||||||
| Equity Value | 1,972 | |||||||||
| Diluted Shares Outstanding, MM | 155 | |||||||||
| Equity Value Per Share | 12.75 |
What You Will Receive
- Authentic O-I Glass Financial Data: Pre-loaded with historical and forecasted data for accurate analysis.
- Completely Customizable Template: Easily adjust key metrics such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch O-I Glass’s intrinsic value update in real-time as you make adjustments.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Design: Straightforward layout and clear guidance suitable for all skill levels.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for O-I Glass, Inc. (OI).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with customizable inputs for precise analysis.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit O-I Glass, Inc. (OI) projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for O-I Glass, Inc. (OI).
- Visual Dashboard and Charts: Provides visual outputs that summarize key valuation metrics for straightforward analysis.
How It Works
- Download the Template: Get instant access to the Excel-based O-I Glass, Inc. (OI) DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and other key factors.
- Instant Calculations: The model automatically updates O-I Glass, Inc.'s (OI) intrinsic value.
- Test Scenarios: Simulate various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose O-I Glass, Inc. (OI)?
- Innovative Solutions: Benefit from cutting-edge glass manufacturing technologies tailored for modern needs.
- Environmental Commitment: O-I Glass prioritizes sustainability, ensuring eco-friendly practices in production.
- Global Expertise: With a presence in multiple countries, O-I Glass brings a wealth of industry knowledge.
- Quality Assurance: Rigorous quality control processes guarantee top-notch products for all customers.
- Customer-Centric Approach: Focused on building strong partnerships and meeting client needs effectively.
Who Should Use O-I Glass, Inc. (OI)?
- Glass Industry Students: Understand manufacturing processes and apply them to real-world scenarios.
- Researchers: Utilize industry-specific models for studies and analysis in the glass sector.
- Investors: Evaluate your investment strategies and assess the market performance of O-I Glass, Inc. (OI).
- Market Analysts: Enhance your analysis with a customizable financial model tailored for the glass industry.
- Entrepreneurs: Discover how large manufacturers like O-I Glass, Inc. (OI) operate and strategize.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled O-I Glass, Inc. (OI) 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 O-I Glass, Inc. (OI).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.