LyondellBasell Industries N.V. (LYB) 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
LyondellBasell Industries N.V. (LYB) Bundle
Engineered for accuracy, our [LYB] DCF Calculator empowers you to evaluate LyondellBasell Industries N.V. valuation using real-world financial data, offering complete flexibility to modify all essential parameters for improved projections.
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 | 34,727.0 | 27,753.0 | 46,173.0 | 50,451.0 | 41,107.0 | 44,912.8 | 49,070.9 | 53,614.1 | 58,577.8 | 64,001.1 |
| Revenue Growth, % | 0 | -20.08 | 66.37 | 9.27 | -18.52 | 9.26 | 9.26 | 9.26 | 9.26 | 9.26 |
| EBITDA | 5,807.0 | 3,613.0 | 8,938.0 | 6,103.0 | 4,724.0 | 6,529.1 | 7,133.6 | 7,794.1 | 8,515.7 | 9,304.1 |
| EBITDA, % | 16.72 | 13.02 | 19.36 | 12.1 | 11.49 | 14.54 | 14.54 | 14.54 | 14.54 | 14.54 |
| Depreciation | 1,312.0 | 1,385.0 | 1,393.0 | 1,267.0 | 1,534.0 | 1,619.4 | 1,769.3 | 1,933.2 | 2,112.1 | 2,307.7 |
| Depreciation, % | 3.78 | 4.99 | 3.02 | 2.51 | 3.73 | 3.61 | 3.61 | 3.61 | 3.61 | 3.61 |
| EBIT | 4,495.0 | 2,228.0 | 7,545.0 | 4,836.0 | 3,190.0 | 4,909.7 | 5,364.3 | 5,860.9 | 6,403.5 | 6,996.4 |
| EBIT, % | 12.94 | 8.03 | 16.34 | 9.59 | 7.76 | 10.93 | 10.93 | 10.93 | 10.93 | 10.93 |
| Total Cash | 1,054.0 | 2,465.0 | 1,481.0 | 2,151.0 | 3,428.0 | 2,490.6 | 2,721.2 | 2,973.1 | 3,248.4 | 3,549.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3,102.0 | 3,441.0 | 4,808.0 | 3,593.0 | 3,989.0 | 4,362.8 | 4,766.7 | 5,208.1 | 5,690.2 | 6,217.1 |
| Account Receivables, % | 8.93 | 12.4 | 10.41 | 7.12 | 9.7 | 9.71 | 9.71 | 9.71 | 9.71 | 9.71 |
| Inventories | 4,588.0 | 4,344.0 | 4,901.0 | 4,804.0 | 4,765.0 | 5,442.7 | 5,946.6 | 6,497.2 | 7,098.7 | 7,755.9 |
| Inventories, % | 13.21 | 15.65 | 10.61 | 9.52 | 11.59 | 12.12 | 12.12 | 12.12 | 12.12 | 12.12 |
| Accounts Payable | 2,928.0 | 2,948.0 | 4,291.0 | 3,583.0 | 3,815.0 | 4,017.9 | 4,389.9 | 4,796.3 | 5,240.3 | 5,725.5 |
| Accounts Payable, % | 8.43 | 10.62 | 9.29 | 7.1 | 9.28 | 8.95 | 8.95 | 8.95 | 8.95 | 8.95 |
| Capital Expenditure | -2,694.0 | -1,947.0 | -1,959.0 | -1,890.0 | -1,531.0 | -2,379.2 | -2,599.4 | -2,840.1 | -3,103.0 | -3,390.3 |
| Capital Expenditure, % | -7.76 | -7.02 | -4.24 | -3.75 | -3.72 | -5.3 | -5.3 | -5.3 | -5.3 | -5.3 |
| Tax Rate, % | 19.53 | 19.53 | 19.53 | 19.53 | 19.53 | 19.53 | 19.53 | 19.53 | 19.53 | 19.53 |
| EBITAT | 3,760.6 | 2,282.7 | 6,237.5 | 3,930.8 | 2,567.1 | 4,203.6 | 4,592.7 | 5,017.9 | 5,482.5 | 5,990.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -2,383.4 | 1,645.7 | 5,090.5 | 3,911.8 | 2,445.1 | 2,595.1 | 3,226.8 | 3,525.6 | 3,852.0 | 4,208.6 |
| WACC, % | 7.54 | 7.8 | 7.53 | 7.51 | 7.49 | 7.57 | 7.57 | 7.57 | 7.57 | 7.57 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 13,830.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 4,293 | |||||||||
| Terminal Value | 77,007 | |||||||||
| Present Terminal Value | 53,454 | |||||||||
| Enterprise Value | 67,285 | |||||||||
| Net Debt | 9,611 | |||||||||
| Equity Value | 57,674 | |||||||||
| Diluted Shares Outstanding, MM | 326 | |||||||||
| Equity Value Per Share | 176.91 |
What You Will Get
- Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to create various scenarios.
- Real-World Data: LyondellBasell's financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- Customizable Financial Inputs: Adjust essential variables such as production capacity, operating margins, and capital investments.
- Instant DCF Valuation: Automatically computes intrinsic value, net present value (NPV), and other key metrics in real-time.
- High-Precision Accuracy: Leverages LyondellBasell’s actual financial data for authentic valuation results.
- Streamlined Scenario Analysis: Effortlessly evaluate various assumptions and analyze their impacts.
- Efficiency Booster: Remove the hassle of creating intricate valuation models from the ground up.
How It Works
- 1. Access the Template: Download and open the Excel file containing LyondellBasell's preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation possibilities.
- 5. Present with Assurance: Share professional valuation insights to bolster your decision-making.
Why Choose LyondellBasell Industries N.V. (LYB)?
- Industry Leader: LyondellBasell is a top player in the global chemical and plastics industry.
- Innovative Solutions: The company is committed to developing sustainable and innovative products.
- Strong Financial Performance: Consistent revenue growth and robust profitability metrics.
- Global Reach: Operations in multiple countries ensure a diverse market presence.
- Expertise You Can Trust: A team of professionals dedicated to excellence in every aspect of the business.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio assessments of LyondellBasell Industries (LYB).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in LyondellBasell Industries (LYB) stock.
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Industry Analysts: Gain insights into how companies like LyondellBasell Industries (LYB) are valued in the chemical sector.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled LyondellBasell 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 LyondellBasell Industries N.V. (LYB).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.