# ExxonMobil (XOM) Financial Model Free Excel 3-statement financial model and company analysis for ExxonMobil. - Canonical: https://finamodel.com/companies/exxonmobil - Industry: Oil and Gas - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/XOM.xlsx ## Model Purpose This model forecasts integrated cash flows under various commodity price scenarios to evaluate dividend sustainability, share repurchase capacity, and overall equity valuation for an integrated energy major. ## Company Overview ExxonMobil is a multinational integrated oil and gas corporation that explores for, produces, and refines crude oil and natural gas, while also manufacturing petroleum products and basic petrochemicals. The business is divided into four primary segments: Upstream (approximately 70% of earnings in a mid-cycle price environment), Energy Products (15%), Chemical Products (10%), and Specialty Products (5%). Key geographies include the United States (Permian Basin, Gulf Coast), Guyana, and Brazil, alongside a massive global refining and chemical footprint. The business model is highly asset-heavy and cyclical, relying on large-scale capital investments to extract and process hydrocarbons. ExxonMobil holds a top-tier competitive position globally, ranking alongside Chevron, Shell, and TotalEnergies as a supermajor. Recent major events include the $59.5 billion all-stock acquisition of Pioneer Natural Resources (closed May 2024) which significantly expanded its Permian footprint, and the $4.9 billion acquisition of Denbury (closed late 2023) to bolster its low-carbon and carbon capture capabilities. ## Revenue Deep Dive ### Upstream - **Segment name**: Upstream - **Revenue driver formula**: (Liquids Production x Realised Liquids Price) + (Natural Gas Production x Realised Gas Price) - **Historical growth rate**: Highly volatile based on commodity prices; production volume CAGR has been relatively flat historically but is stepping up 10-15% post-Pioneer acquisition. - **Key growth levers and headwinds**: Production growth in Guyana and the Permian Basin; natural field decline rates; OPEC+ quotas; geopolitical supply disruptions. - **Pricing dynamics**: Spot pricing linked to global benchmarks (Brent, WTI, Henry Hub, TTF) adjusted for local differentials. - **Revenue recognition notes**: Recognised when control of the product transfers to the customer at the delivery point. - **Seasonality**: Minimal seasonality in production, though severe weather (Gulf Coast hurricanes) can cause temporary shut-ins. ### Energy Products - **Segment name**: Energy Products - **Revenue driver formula**: Refinery Throughput x Realised Refining Margin - **Historical growth rate**: Flat to declining volumes; revenue fluctuates wildly with crack spreads. - **Key growth levers and headwinds**: Global refining capacity additions, EV penetration reducing motor fuel demand, turnaround schedules. - **Pricing dynamics**: Highly competitive spot market driven by regional crack spreads (e.g., US Gulf Coast 3-2-1 crack spread). - **Revenue recognition notes**: Recognised upon delivery of fuels to wholesale or retail channels. - **Seasonality**: Higher gasoline demand in the Northern Hemisphere summer driving season; higher heating oil demand in winter. ### Chemical Products - **Segment name**: Chemical Products - **Revenue driver formula**: Sales Volume x Realised Chemical Margin - **Historical growth rate**: 2-4% volume CAGR, tracking global GDP growth. - **Key growth levers and headwinds**: Global economic growth, packaging demand, oversupply of global steam cracker capacity. - **Pricing dynamics**: Cyclical pricing based on feedstock costs (ethane, naphtha) versus end-product prices (polyethylene, polypropylene). - **Revenue recognition notes**: Standard point-of-sale recognition. - **Seasonality**: Generally tracks broader macroeconomic cycles rather than seasonal patterns. ### Specialty Products - **Segment name**: Specialty Products - **Revenue driver formula**: Sales Volume x Realised Margin per Tonne - **Historical growth rate**: 1-3% volume CAGR. - **Key growth levers and headwinds**: Industrial activity, automotive manufacturing, shift to synthetic lubricants. - **Pricing dynamics**: More stable, premium pricing compared to commodity fuels and chemicals. - **Revenue recognition notes**: Standard point-of-sale recognition. - **Seasonality**: Minimal. ## Cost Structure ### Variable Costs / COGS - **Line-by-line breakdown**: Crude oil and product purchases (massive for the refining segment), production and manufacturing expenses, production taxes, exploration expenses. - **Gross margin range**: 25% to 35%, heavily dependent on the absolute price of crude oil and refining crack spreads. - **Key input costs and commodity exposures**: Crude oil (as a feedstock for Energy Products), natural gas (as fuel for refineries and feedstock for chemicals), electricity. - **How COGS scales with revenue**: Crude purchases scale linearly with refining throughput and oil prices; upstream production costs have a high fixed component, creating immense operating leverage when oil prices rise. ### Operating Expenses - **R&D**: Approximately 0.3% of revenue; covers proprietary catalyst development, carbon capture tech, and seismic imaging. - **SG&A**: Approximately 3-4% of revenue; covers corporate overhead, marketing, and IT. - **Depreciation & Amortisation**: Massive non-cash expense, typically $18 billion to $22 billion annually; driven by unit-of-production method for upstream assets. - **Stock-Based Compensation**: Less than 0.5% of revenue; not a major driver compared to tech companies. - **Restructuring / one-time charges**: Infrequent, though asset impairments occur during severe commodity price crashes (e.g., 2020). ### Margin Profile - **Gross margin**: 25-35%. - **EBITDA margin**: 15-25% (highly cyclical). - **Operating margin**: 10-20%. - **Net margin**: 8-15%. - **Margin trend**: Expanding during commodity upcycles and compressing during downcycles. The Pioneer acquisition lowers the average cost of supply, structurally improving upstream margins. ## Balance Sheet Structure - **Total assets**: Approximately $370 billion to $400 billion. - **Key asset categories**: Property, Plant and Equipment (PP&E) makes up over 60% of total assets. - **Goodwill & intangibles**: Historically low, but increased significantly following the $59.5 billion Pioneer acquisition. - **Working capital profile**: - **Days Sales Outstanding (DSO)**: 25 to 35 days. - **Days Inventory Outstanding (DIO)**: 30 to 40 days. - **Days Payable Outstanding (DPO)**: 40 to 50 days. - **Net working capital as % of revenue**: Typically negative or near zero. - **Is working capital positive or negative?**: Often slightly negative, providing a small source of cash, though large swings occur with commodity price volatility. - **PP&E**: Consists of oil and gas properties, refineries, chemical plants. Upstream PP&E is depleted using the unit-of-production method. - **Right-of-use assets / operating leases**: Material but manageable, typically $4 billion to $6 billion. ## Capital Expenditure & Investment - **Capex as % of revenue**: 6-8% (revenue is massive, so absolute dollars are a better metric). - **Maintenance capex vs. growth capex**: Approximately 40% maintenance, 60% growth. - **Major capex programmes underway or planned**: Total annual capex guidance of $22 billion to $27 billion. Key projects include Guyana offshore developments, Permian Basin drilling, and low-carbon initiatives (lithium, carbon capture). - **Capitalised software / development costs**: Immaterial. - **M&A pattern**: Infrequent but transformational when they occur (XTO Energy in 2010, Pioneer in 2024). - **Typical acquisition multiple paid**: Typically 5x to 7x EV/EBITDA based on mid-cycle commodity prices. ## Debt & Capital Structure - **Total debt**: Approximately $40 billion to $45 billion. - **Debt/EBITDA ratio**: Typically 0.5x to 1.0x (very conservative). - **Credit rating**: AA- (S&P), Aa2 (Moody's). - **Key debt instruments**: Long-term unsecured bonds, commercial paper for short-term liquidity. - **Maturity profile**: Well-laddered over 30 years. - **Interest rate profile**: Predominantly fixed-rate bonds; weighted average cost of debt is approximately 3.5% to 4.5%. - **Covenants**: Minimal restrictive financial covenants due to high credit rating. - **Share repurchase programme**: Highly active; currently executing a $20 billion annual repurchase programme. - **Dividend policy**: Progressive dividend policy; yield is typically 3.0% to 4.0%, with a payout ratio of 30% to 50% of free cash flow. ## Cash Flow Characteristics - **Operating cash flow conversion**: OCF is typically 1.3x to 1.6x Net Income due to massive D&A add-backs. - **Free cash flow margin**: 8-12% (highly dependent on commodity prices). - **Major non-cash items**: Depreciation, depletion, and amortisation (DD&A); deferred income taxes. - **Working capital cash flow impact**: Can swing by billions of dollars in a single quarter if oil prices spike or crash, but neutralises over the long term. - **Capex intensity**: Extremely high absolute capex ($22 billion to $27 billion annually). - **Cash tax rate vs. GAAP effective tax rate**: Cash taxes often lag GAAP taxes due to accelerated depreciation for tax purposes on large capital projects. ## Sheet Structure 1. **Cover**: Company name, ticker, model purpose, and contact details. 2. **Assumptions**: Hardcoded drivers for macro variables (Brent, WTI, Henry Hub, refining margins) and corporate assumptions (tax rate, share count). 3. **Upstream**: Production volumes by liquid/gas, realised pricing, revenue, and production costs. 4. **Downstream & Chemicals**: Energy Products, Chemical Products, and Specialty Products volumes, margins, and operating profits. 5. **Income Statement**: Consolidated revenue, COGS, SG&A, D&A, interest, taxes, and net income. 6. **Balance Sheet**: Assets (cash, receivables, inventory, PP&E), liabilities (payables, debt, ARO, deferred taxes), and equity. 7. **Cash Flow Statement**: OCF (starting from net income), CFI (capex, acquisitions), and CFF (debt issuance/repayment, dividends, buybacks). 8. **Debt Schedule**: Roll-forward of commercial paper and long-term debt, interest expense calculation. 9. **PP&E & Depreciation**: Roll-forward of gross PP&E, capex additions, retirements, and DD&A calculation. 10. **DCF Valuation**: Unlevered free cash flow calculation, WACC, terminal value, and implied share price. ## Key Financial Relationships 1. Upstream Liquids Revenue = Liquids Production (kboe/d) x 365 x Realised Liquids Price ($/bbl). 2. Upstream Gas Revenue = Natural Gas Production (mcf/d) x 365 x Realised Gas Price ($/mcf). 3. Total Upstream Revenue = Upstream Liquids Revenue + Upstream Gas Revenue. 4. Energy Products Revenue = Refinery Throughput (kbd) x 365 x Realised Product Price ($/bbl). 5. Energy Products Earnings = Refinery Throughput (kbd) x 365 x Realised Refining Margin ($/bbl) - Operating Costs. 6. Chemical Products Earnings = Sales Volume (kt) x Realised Chemical Margin ($/t) - Operating Costs. 7. Total COGS = Crude Purchases + Production and Manufacturing Expenses + Exploration Expenses. 8. DD&A Expense = (Current Year Production / Total Proved Reserves) x Net Book Value of Upstream PP&E (simplified unit-of-production). 9. Free Cash Flow = Cash Flow from Operations - Additions to PP&E (Capex). 10. Ending Share Count = Beginning Share Count - (Share Repurchase Amount / Average Share Price). 11. Dividends Paid = Annual Dividend per Share x Average Shares Outstanding. ## Cross-Sheet Dependencies - The **Assumptions** sheet dictates commodity prices, which feed directly into the **Upstream** and **Downstream & Chemicals** sheets to calculate segment revenues and earnings. - Segment revenues and earnings aggregate into the **Income Statement**. - Net Income and DD&A from the **Income Statement** flow into the **Cash Flow Statement** to calculate Operating Cash Flow. - Capex from the **Assumptions** sheet flows into the **PP&E & Depreciation** sheet and the **Cash Flow Statement**. - The **Cash Flow Statement** determines the net change in cash, which feeds the Cash line on the **Balance Sheet**. - The **Debt Schedule** calculates interest expense, which flows back to the **Income Statement**, creating a minor circularity that must be managed with a circuit breaker or iterative calculation. ## Sign Convention - Revenues, production volumes, and commodity prices are entered as positive numbers. - Expenses (COGS, SG&A, D&A, Interest Expense, Taxes) are entered as positive numbers and subtracted in subtotals. - On the Cash Flow Statement, cash inflows are positive and cash outflows (capex, dividends, debt repayment) are negative. - On the Balance Sheet, all asset, liability, and equity balances are positive. ## Things Most Likely to Go Wrong - Failing to account for the Pioneer Natural Resources acquisition in historical comparisons; 2024 and 2025 production volumes will be significantly higher than 2023. - Disconnecting crude purchase costs from crude prices; if Brent rises, Upstream revenue rises, but Energy Products COGS must also rise proportionally. - Overestimating refining margins; crack spreads revert to the mean quickly, so projecting peak margins into perpetuity will overvalue the company. - Ignoring the unit-of-production depreciation method; DD&A must scale with production volumes, not just as a straight percentage of revenue. - Mismodelling the share count; ExxonMobil is buying back $20 billion in stock annually, which significantly impacts per-share valuation metrics over a 5-year forecast. - Double-counting intersegment revenues; Upstream sells crude to Energy Products, which must be eliminated in consolidation. - Forgetting Asset Retirement Obligations (ARO); this is a massive liability that requires accretion expense on the income statement. - Misaligning cash taxes with GAAP taxes; accelerated depreciation creates large deferred tax liabilities that must be modelled correctly to capture near-term cash flow benefits. ## Validation Checks - Total Upstream production should be in the 4.0 to 4.5 million boe/d range post-Pioneer acquisition. - Consolidated Capex must remain within management's stated guidance of $22 billion to $27 billion annually. - The Balance Sheet must balance perfectly in every forecast period (Total Assets = Total Liabilities + Equity). - Debt/EBITDA should remain below 1.5x even in downside commodity scenarios, reflecting the company's conservative balance sheet. - OCF/Net Income conversion should consistently track above 1.2x due to heavy DD&A add-backs. - Dividend payout ratio should be checked against Free Cash Flow; if dividends exceed FCF, the model must show debt increasing or cash decreasing to fund the shortfall. - Intersegment eliminations must net to zero on the consolidated income statement. ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Brent Crude Price | 75.00 | $/bbl | Mid-cycle long-term assumption based on recent futures curves. | | WTI Crude Price | 71.00 | $/bbl | Standard historical discount to Brent. | | Henry Hub Gas Price | 2.75 | $/mmbtu | Mid-cycle US natural gas assumption. | | Upstream Production | 4,300 | kboe/d | Reflects base production plus full integration of Pioneer volumes. | | Energy Products Throughput | 4,000 | kbd | Historical average refinery utilisation. | | Consolidated Capex | 24,000 | $ Millions | Midpoint of management's $22B-$27B guidance range. | | Effective Tax Rate | 23.0 | % | Historical average effective tax rate. | | Annual Share Repurchases | 20,000 | $ Millions | Management's stated annual buyback target post-Pioneer. | | Dividend per Share | 3.80 | $ | Current annualised run-rate with modest assumed growth. | | WACC | 8.5 | % | Standard discount rate for integrated energy majors. | | Terminal Growth Rate | 1.0 | % | Conservative long-term growth reflecting energy transition risks. | ## Data Sources & Benchmarks - **Filings**: ExxonMobil Investor Relations website, SEC EDGAR (10-K, 10-Q, 8-K). - **Peers for Benchmarking**: Chevron (CVX), Shell (SHEL), TotalEnergies (TTE), BP (BP). - **Industry Data**: US Energy Information Administration (EIA) for crude and product inventory data, Baker Hughes rig count, S&P Global Platts for crack spreads. - **Consensus Estimates**: Bloomberg or FactSet for consensus commodity price decks and production estimates. ## Sources - ExxonMobil 2024 and 2023 Form 10-K filings. - ExxonMobil Corporate Plan Update and Investor Day presentations (2024/2025). - SEC Form 8-K filings regarding the Pioneer Natural Resources and Denbury acquisitions. - EIA Short-Term Energy Outlook (STEO) for baseline commodity price assumptions. ## Frequently asked questions ### What is ExxonMobil's primary business model and how does it generate revenue? ExxonMobil is a multinational integrated oil and gas corporation that explores for, produces, and refines crude oil and natural gas, while also manufacturing petroleum products and basic petrochemicals. Its revenue is generated through the sale of these products across its four primary segments: Upstream, Energy Products, Chemical Products, and Specialty Products. ### What are the main segments contributing to ExxonMobil's earnings? ExxonMobil's earnings are primarily driven by its Upstream segment, which accounts for approximately 70% of earnings in a mid-cycle price environment. The Energy Products segment contributes 15%, Chemical Products 10%, and Specialty Products 5%, showcasing its diversified integrated structure. ### What is ExxonMobil's capital expenditure strategy and what are its key investment areas? ExxonMobil's capital expenditure typically represents 6-8% of its massive revenue, with annual guidance between $22 billion and $27 billion. Approximately 60% of this capex is allocated to growth projects, focusing on Guyana offshore developments, Permian Basin drilling, and low-carbon initiatives like carbon capture. ### What are some key financial assumptions used in the ExxonMobil financial model? The ExxonMobil financial model uses a revenue growth assumption of approximately 7.76% and forecasts COGS as 55% of revenue. Other important assumptions include SGA at about 3.75% of revenue, DA at 10.36% of revenue, and a tax rate of approximately 25.09%. ### How does the financial model evaluate ExxonMobil's equity valuation and dividend sustainability? The financial model forecasts integrated cash flows under various commodity price scenarios to evaluate dividend sustainability, share repurchase capacity, and overall equity valuation for ExxonMobil. This helps assess the company's ability to generate returns for shareholders and maintain its financial health. ### Is an Excel financial model available for download to analyze ExxonMobil's forecasts? Yes, an Excel financial model for ExxonMobil is available for download. This model provides forecasts for the period FY2026–FY2030, allowing users to analyze integrated cash flows and various financial assumptions for the company. [Interactive forecast calculator](https://finamodel.com/companies/exxonmobil/forecast)