|
Valoración de DCF de Imperial Oil Limited (OMI)
CA | Energy | Oil & Gas Integrated | AMEX
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Imperial Oil Limited (IMO) Bundle
¡Simplifique la valoración limitada del aceite Imperial con esta calculadora DCF personalizable! Con el Real Imperial Oil Limited (IMO) financieros y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Imperial Oil Limited (IMO) en minutos.
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.