Imperial Oil Limited (IMO) 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
Imperial Oil Limited (IMO) Bundle
Simplify Imperial Oil Limited valuation with this customizable DCF Calculator! Featuring real Imperial Oil Limited (IMO) financials and adjustable forecast inputs, you can test scenarios and uncover Imperial Oil Limited (IMO) 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 | 22,336.8 | 14,256.6 | 24,686.0 | 39,710.0 | 35,178.0 | 42,778.9 | 52,022.2 | 63,262.6 | 76,931.9 | 93,554.6 |
| Revenue Growth, % | 0 | -36.17 | 73.16 | 60.86 | -11.41 | 21.61 | 21.61 | 21.61 | 21.61 | 21.61 |
| EBITDA | 2,524.1 | 644.6 | 3,630.1 | 7,759.7 | 5,789.9 | 5,691.8 | 6,921.7 | 8,417.2 | 10,235.9 | 12,447.6 |
| EBITDA, % | 11.3 | 4.52 | 14.7 | 19.54 | 16.46 | 13.31 | 13.31 | 13.31 | 13.31 | 13.31 |
| Depreciation | 1,108.7 | 2,270.9 | 1,371.7 | 1,316.2 | 1,323.1 | 2,868.3 | 3,488.0 | 4,241.7 | 5,158.2 | 6,272.7 |
| Depreciation, % | 4.96 | 15.93 | 5.56 | 3.31 | 3.76 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 |
| EBIT | 1,415.4 | -1,626.3 | 2,258.4 | 6,443.5 | 4,466.8 | 2,823.5 | 3,433.6 | 4,175.5 | 5,077.8 | 6,174.9 |
| EBIT, % | 6.34 | -11.41 | 9.15 | 16.23 | 12.7 | 6.6 | 6.6 | 6.6 | 6.6 | 6.6 |
| Total Cash | 1,192.0 | 534.9 | 1,493.8 | 2,601.1 | 599.5 | 2,001.5 | 2,434.0 | 2,959.9 | 3,599.5 | 4,377.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,872.6 | 1,331.4 | 2,684.4 | 3,274.1 | 3,109.7 | 3,908.4 | 4,752.9 | 5,779.9 | 7,028.8 | 8,547.5 |
| Account Receivables, % | 8.38 | 9.34 | 10.87 | 8.25 | 8.84 | 9.14 | 9.14 | 9.14 | 9.14 | 9.14 |
| Inventories | 1,326.6 | 1,272.5 | 1,242.6 | 1,573.6 | 2,048.2 | 2,539.6 | 3,088.4 | 3,755.7 | 4,567.2 | 5,554.0 |
| Inventories, % | 5.94 | 8.93 | 5.03 | 3.96 | 5.82 | 5.94 | 5.94 | 5.94 | 5.94 | 5.94 |
| Accounts Payable | 2,390.2 | 1,772.0 | 3,098.6 | 3,757.7 | 3,237.4 | 4,649.9 | 5,654.6 | 6,876.4 | 8,362.2 | 10,169.0 |
| Accounts Payable, % | 10.7 | 12.43 | 12.55 | 9.46 | 9.2 | 10.87 | 10.87 | 10.87 | 10.87 | 10.87 |
| Capital Expenditure | -1,135.1 | -602.2 | -768.8 | -1,058.8 | -1,238.5 | -1,592.0 | -1,935.9 | -2,354.2 | -2,862.9 | -3,481.5 |
| Capital Expenditure, % | -5.08 | -4.22 | -3.11 | -2.67 | -3.52 | -3.72 | -3.72 | -3.72 | -3.72 | -3.72 |
| Tax Rate, % | 23.24 | 23.24 | 23.24 | 23.24 | 23.24 | 23.24 | 23.24 | 23.24 | 23.24 | 23.24 |
| EBITAT | 1,521.9 | -1,254.2 | 1,705.3 | 4,986.8 | 3,428.8 | 2,297.1 | 2,793.5 | 3,397.1 | 4,131.1 | 5,023.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 686.6 | 391.6 | 2,311.7 | 4,982.7 | 2,683.0 | 3,695.8 | 3,957.0 | 4,812.0 | 5,851.8 | 7,116.2 |
| WACC, % | 12.15 | 12.07 | 12.06 | 12.07 | 12.07 | 12.08 | 12.08 | 12.08 | 12.08 | 12.08 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 17,596.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 7,259 | |||||||||
| Terminal Value | 71,998 | |||||||||
| Present Terminal Value | 40,705 | |||||||||
| Enterprise Value | 58,302 | |||||||||
| Net Debt | 2,419 | |||||||||
| Equity Value | 55,882 | |||||||||
| Diluted Shares Outstanding, MM | 576 | |||||||||
| Equity Value Per Share | 97.03 |
What You Will Get
- Real Imperial Oil Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Imperial Oil Limited (IMO).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to suit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Imperial Oil's fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to Imperial Oil Limited (IMO).
- Time-Saving and Accurate: Avoid building models from scratch while ensuring precision and flexibility in your evaluations.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as oil prices, production levels, and operating costs.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- Industry-Leading Precision: Leverages Imperial Oil's actual financial data for accurate valuation results.
- Effortless Scenario Analysis: Explore various assumptions and assess different outcomes with ease.
- Efficiency Booster: Streamlines the valuation process, removing the need for intricate model development.
How It Works
- Step 1: Download the prebuilt Excel template featuring Imperial Oil Limited’s (IMO) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including the intrinsic value of Imperial Oil Limited (IMO).
- Step 5: Make well-informed investment decisions or create reports using the generated outputs.
Why Choose This Calculator for Imperial Oil Limited (IMO)?
- Accurate Data: Utilize real Imperial Oil financials for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the oil industry.
- User-Friendly: An intuitive design and clear instructions make it accessible for all users.
Who Should Use Imperial Oil Limited (IMO)?
- Investors: Gain insights into the oil and gas sector with a reliable resource for informed investment decisions.
- Financial Analysts: Streamline your analysis with comprehensive data and tools tailored to the energy market.
- Consultants: Easily modify reports and presentations to meet client needs in the oil industry.
- Energy Sector Enthusiasts: Enhance your knowledge of the oil market dynamics through detailed case studies and reports.
- Educators and Students: Utilize it as a practical reference in energy finance and business courses.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Imperial Oil Limited (IMO) 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 Imperial Oil Limited (IMO).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.