|
Occidental Petroleum Corporation (OXY) DCF Valuation
US | Energy | Oil & Gas Exploration & Production | 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
Occidental Petroleum Corporation (OXY) Bundle
Evaluate Occidental Petroleum Corporation's (OXY) financial future like an expert! This (OXY) DCF Calculator provides pre-filled financial data along with the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your 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 | 20,393.0 | 17,809.0 | 25,956.0 | 36,634.0 | 28,257.0 | 31,884.3 | 35,977.3 | 40,595.7 | 45,806.9 | 51,687.1 |
| Revenue Growth, % | 0 | -12.67 | 45.75 | 41.14 | -22.87 | 12.84 | 12.84 | 12.84 | 12.84 | 12.84 |
| EBITDA | 7,649.0 | -6,137.0 | 13,891.0 | 22,073.0 | 14,538.0 | 10,730.2 | 12,107.6 | 13,661.8 | 15,415.6 | 17,394.5 |
| EBITDA, % | 37.51 | -34.46 | 53.52 | 60.25 | 51.45 | 33.65 | 33.65 | 33.65 | 33.65 | 33.65 |
| Depreciation | 6,229.0 | 8,144.0 | 8,572.0 | 7,010.0 | 6,865.0 | 9,739.4 | 10,989.6 | 12,400.3 | 13,992.1 | 15,788.3 |
| Depreciation, % | 30.54 | 45.73 | 33.03 | 19.14 | 24.29 | 30.55 | 30.55 | 30.55 | 30.55 | 30.55 |
| EBIT | 1,420.0 | -14,281.0 | 5,319.0 | 15,063.0 | 7,673.0 | 990.8 | 1,118.0 | 1,261.5 | 1,423.5 | 1,606.2 |
| EBIT, % | 6.96 | -80.19 | 20.49 | 41.12 | 27.15 | 3.11 | 3.11 | 3.11 | 3.11 | 3.11 |
| Total Cash | 3,032.0 | 2,008.0 | 2,764.0 | 984.0 | 1,426.0 | 2,839.3 | 3,203.7 | 3,615.0 | 4,079.0 | 4,602.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 4,233.0 | 2,115.0 | 4,208.0 | 4,281.0 | 3,195.0 | 4,581.0 | 5,169.1 | 5,832.6 | 6,581.3 | 7,426.2 |
| Account Receivables, % | 20.76 | 11.88 | 16.21 | 11.69 | 11.31 | 14.37 | 14.37 | 14.37 | 14.37 | 14.37 |
| Inventories | 1,447.0 | 1,898.0 | 1,846.0 | 2,059.0 | 2,022.0 | 2,400.3 | 2,708.5 | 3,056.2 | 3,448.5 | 3,891.1 |
| Inventories, % | 7.1 | 10.66 | 7.11 | 5.62 | 7.16 | 7.53 | 7.53 | 7.53 | 7.53 | 7.53 |
| Accounts Payable | 4,910.0 | 2,987.0 | 3,899.0 | 4,029.0 | 3,646.0 | 5,086.9 | 5,740.0 | 6,476.8 | 7,308.2 | 8,246.3 |
| Accounts Payable, % | 24.08 | 16.77 | 15.02 | 11 | 12.9 | 15.95 | 15.95 | 15.95 | 15.95 | 15.95 |
| Capital Expenditure | -6,637.0 | -3,054.0 | -2,773.0 | -4,350.0 | -6,245.0 | -6,016.7 | -6,789.1 | -7,660.6 | -8,644.0 | -9,753.6 |
| Capital Expenditure, % | -32.55 | -17.15 | -10.68 | -11.87 | -22.1 | -18.87 | -18.87 | -18.87 | -18.87 | -18.87 |
| Tax Rate, % | 26.96 | 26.96 | 26.96 | 26.96 | 26.96 | 26.96 | 26.96 | 26.96 | 26.96 | 26.96 |
| EBITAT | -3,870.6 | -12,305.9 | 3,333.5 | 14,195.5 | 5,604.7 | 626.4 | 706.9 | 797.6 | 900.0 | 1,015.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -5,048.6 | -7,471.9 | 8,003.5 | 16,699.5 | 6,964.7 | 4,025.7 | 4,664.2 | 5,262.9 | 5,938.5 | 6,700.8 |
| WACC, % | 8.31 | 9.52 | 9.19 | 9.63 | 9.34 | 9.2 | 9.2 | 9.2 | 9.2 | 9.2 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 20,132.2 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 6,734 | |||||||||
| Terminal Value | 77,423 | |||||||||
| Present Terminal Value | 49,865 | |||||||||
| Enterprise Value | 69,997 | |||||||||
| Net Debt | 19,485 | |||||||||
| Equity Value | 50,512 | |||||||||
| Diluted Shares Outstanding, MM | 961 | |||||||||
| Equity Value Per Share | 52.57 |
What You Will Get
- Real OXY Financials: Access historical and projected data for precise valuation.
- Adjustable Inputs: Customize WACC, tax rates, revenue growth, and capital expenditures.
- Automatic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Occidental Petroleum’s future performance.
- Clear and Intuitive Design: Designed for professionals while remaining user-friendly for beginners.
Key Features
- Pre-Loaded Data: Occidental Petroleum's historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: View Occidental Petroleum's intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts illustrate valuation results and key metrics effectively.
- Built for Accuracy: A professional tool tailored for analysts, investors, and finance experts.
How It Works
- Download the Template: Gain immediate access to the Excel-based OXY DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Occidental Petroleum’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for Occidental Petroleum Corporation (OXY)?
- User-Friendly Interface: Tailored for both novices and seasoned investors.
- Customizable Inputs: Easily adjust parameters to suit your financial evaluation.
- Real-Time Feedback: Observe immediate changes to Occidental Petroleum's valuation as you tweak inputs.
- Preloaded Data: Comes with Occidental Petroleum's actual financial metrics for swift assessments.
- Relied Upon by Experts: Favored by analysts and investors for making strategic decisions.
Who Should Use Occidental Petroleum Corporation (OXY)?
- Investors: Gain insights into energy market dynamics with a reliable analysis of Occidental Petroleum Corporation (OXY).
- Financial Analysts: Streamline your research with comprehensive reports and data on Occidental Petroleum Corporation (OXY).
- Consultants: Easily tailor presentations and recommendations based on Occidental Petroleum Corporation (OXY) for your clients.
- Energy Sector Enthusiasts: Enhance your knowledge of the oil and gas industry through in-depth studies of Occidental Petroleum Corporation (OXY).
- Educators and Students: Utilize real-world case studies of Occidental Petroleum Corporation (OXY) in finance and energy courses.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Occidental Petroleum Corporation (OXY) 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 Occidental Petroleum Corporation (OXY).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.