Ovintiv Inc. (OVV) 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
Ovintiv Inc. (OVV) Bundle
Explore the financial future of Ovintiv Inc. (OVV) with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and costs to calculate the intrinsic value of Ovintiv Inc. (OVV) and refine your investment strategy.
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 | 6,726.0 | 6,087.0 | 8,658.0 | 12,464.0 | 10,661.0 | 12,319.6 | 14,236.3 | 16,451.1 | 19,010.5 | 21,968.1 |
| Revenue Growth, % | 0 | -9.5 | 42.24 | 43.96 | -14.47 | 15.56 | 15.56 | 15.56 | 15.56 | 15.56 |
| EBITDA | 2,749.0 | -3,496.0 | 2,791.0 | 5,002.0 | 4,709.0 | 2,463.3 | 2,846.5 | 3,289.4 | 3,801.2 | 4,392.5 |
| EBITDA, % | 40.87 | -57.43 | 32.24 | 40.13 | 44.17 | 20 | 20 | 20 | 20 | 20 |
| Depreciation | 2,052.0 | 1,863.0 | 1,212.0 | 1,131.0 | 1,844.0 | 2,500.5 | 2,889.5 | 3,339.0 | 3,858.5 | 4,458.8 |
| Depreciation, % | 30.51 | 30.61 | 14 | 9.07 | 17.3 | 20.3 | 20.3 | 20.3 | 20.3 | 20.3 |
| EBIT | 697.0 | -5,359.0 | 1,579.0 | 3,871.0 | 2,865.0 | -37.2 | -43.0 | -49.6 | -57.4 | -66.3 |
| EBIT, % | 10.36 | -88.04 | 18.24 | 31.06 | 26.87 | -0.30175 | -0.30175 | -0.30175 | -0.30175 | -0.30175 |
| Total Cash | 190.0 | 10.0 | 195.0 | 5.0 | 3.0 | 130.8 | 151.2 | 174.7 | 201.9 | 233.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,146.0 | 867.0 | 1,296.0 | 1,529.0 | 1,345.0 | 1,752.7 | 2,025.4 | 2,340.5 | 2,704.6 | 3,125.4 |
| Account Receivables, % | 17.04 | 14.24 | 14.97 | 12.27 | 12.62 | 14.23 | 14.23 | 14.23 | 14.23 | 14.23 |
| Inventories | 7.0 | 23.0 | 9.0 | .0 | .0 | 14.4 | 16.7 | 19.3 | 22.3 | 25.7 |
| Inventories, % | 0.10407 | 0.37785 | 0.10395 | 0 | 0 | 0.11718 | 0.11718 | 0.11718 | 0.11718 | 0.11718 |
| Accounts Payable | 348.0 | 306.0 | 328.0 | 436.0 | 586.0 | 566.3 | 654.4 | 756.2 | 873.9 | 1,009.8 |
| Accounts Payable, % | 5.17 | 5.03 | 3.79 | 3.5 | 5.5 | 4.6 | 4.6 | 4.6 | 4.6 | 4.6 |
| Capital Expenditure | -2,626.0 | -1,736.0 | -1,519.0 | -1,831.0 | -2,744.0 | -3,093.1 | -3,574.3 | -4,130.4 | -4,773.0 | -5,515.6 |
| Capital Expenditure, % | -39.04 | -28.52 | -17.54 | -14.69 | -25.74 | -25.11 | -25.11 | -25.11 | -25.11 | -25.11 |
| Tax Rate, % | 16.93 | 16.93 | 16.93 | 16.93 | 16.93 | 16.93 | 16.93 | 16.93 | 16.93 | 16.93 |
| EBITAT | 517.8 | -5,702.2 | 1,804.6 | 3,954.7 | 2,379.9 | -34.0 | -39.3 | -45.4 | -52.5 | -60.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -861.2 | -5,354.2 | 1,104.6 | 3,138.7 | 1,813.9 | -1,068.4 | -910.9 | -1,052.6 | -1,216.4 | -1,405.7 |
| WACC, % | 11.78 | 12.32 | 12.32 | 12.32 | 11.97 | 12.15 | 12.15 | 12.15 | 12.15 | 12.15 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -3,984.9 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | -1,413 | |||||||||
| Terminal Value | -12,131 | |||||||||
| Present Terminal Value | -6,839 | |||||||||
| Enterprise Value | -10,824 | |||||||||
| Net Debt | 6,680 | |||||||||
| Equity Value | -17,504 | |||||||||
| Diluted Shares Outstanding, MM | 264 | |||||||||
| Equity Value Per Share | -66.33 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real OVV financials.
- Real-World Data: Historical data and forward-looking estimates (as illustrated in the highlighted cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Ovintiv Inc.’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive OVV Data: Pre-loaded with Ovintiv Inc.'s historical performance metrics and future projections.
- Customizable Financial Inputs: Tailor revenue growth rates, profit margins, discount rates, tax percentages, and capital investments.
- Interactive Valuation Model: Real-time adjustments to Net Present Value (NPV) and intrinsic value based on your specified parameters.
- Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- Intuitive Interface: Designed with clarity and ease of use for both seasoned professionals and newcomers.
How It Works
- 1. Access the Template: Download and open the Excel file containing Ovintiv Inc.'s (OVV) preloaded financial data.
- 2. Adjust Key Inputs: Modify essential assumptions such as production growth rates, discount rates, and capital investments.
- 3. Analyze Results in Real-Time: The DCF model automatically computes the intrinsic value and net present value (NPV).
- 4. Explore Different Scenarios: Evaluate various forecasts to understand potential valuation variations.
- 5. Present with Assurance: Deliver expert valuation analyses to inform your strategic decisions.
Why Choose This Calculator for Ovintiv Inc. (OVV)?
- All-in-One Solution: Features DCF, WACC, and comprehensive financial ratio analyses tailored for Ovintiv Inc. (OVV).
- Flexible Parameters: Modify the highlighted cells to explore different financial scenarios for Ovintiv Inc. (OVV).
- In-Depth Analysis: Automatically computes Ovintiv Inc. (OVV)'s intrinsic value and Net Present Value.
- Data-Rich Environment: Comes with historical and projected data to provide reliable benchmarks.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focusing on Ovintiv Inc. (OVV).
Who Should Use Ovintiv Inc. (OVV)?
- Investors: Make informed investment choices with comprehensive insights into Ovintiv Inc.'s performance.
- Financial Analysts: Streamline your analysis with detailed reports and data on Ovintiv Inc. (OVV).
- Consultants: Efficiently tailor presentations and reports featuring Ovintiv Inc. (OVV) for your clients.
- Energy Sector Enthusiasts: Enhance your knowledge of the oil and gas industry through Ovintiv Inc.'s operational strategies.
- Educators and Students: Utilize Ovintiv Inc. (OVV) as a case study for discussions in energy finance courses.
What the Template Contains
- Preloaded OVV Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.