Cenovus Energy Inc. (CVE) 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
Cenovus Energy Inc. (CVE) Bundle
Designed for accuracy, our (CVE) DCF Calculator enables you to assess the valuation of Cenovus Energy Inc. using real-world financial data, along with complete flexibility to modify all essential parameters for improved 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 | 14,821.2 | 9,433.5 | 33,879.8 | 49,812.2 | 36,234.9 | 43,791.6 | 52,924.1 | 63,961.2 | 77,300.1 | 93,420.7 |
| Revenue Growth, % | 0 | -36.35 | 259.14 | 47.03 | -27.26 | 20.85 | 20.85 | 20.85 | 20.85 | 20.85 |
| EBITDA | 2,827.8 | 534.5 | 5,692.3 | 10,644.8 | 7,209.6 | 7,253.0 | 8,765.6 | 10,593.6 | 12,802.9 | 15,472.9 |
| EBITDA, % | 19.08 | 5.67 | 16.8 | 21.37 | 19.9 | 16.56 | 16.56 | 16.56 | 16.56 | 16.56 |
| Depreciation | 1,578.4 | 1,744.3 | 3,138.0 | 3,149.8 | 3,209.5 | 4,693.0 | 5,671.7 | 6,854.5 | 8,283.9 | 10,011.5 |
| Depreciation, % | 10.65 | 18.49 | 9.26 | 6.32 | 8.86 | 10.72 | 10.72 | 10.72 | 10.72 | 10.72 |
| EBIT | 1,249.4 | -1,209.8 | 2,554.3 | 7,494.9 | 4,000.1 | 2,560.1 | 3,094.0 | 3,739.2 | 4,519.0 | 5,461.4 |
| EBIT, % | 8.43 | -12.82 | 7.54 | 15.05 | 11.04 | 5.85 | 5.85 | 5.85 | 5.85 | 5.85 |
| Total Cash | 129.1 | 262.4 | 1,994.2 | 3,140.1 | 1,545.8 | 1,761.1 | 2,128.4 | 2,572.3 | 3,108.7 | 3,757.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,049.5 | 963.4 | 1,935.2 | 2,096.2 | 2,227.4 | 2,921.8 | 3,531.2 | 4,267.6 | 5,157.6 | 6,233.2 |
| Account Receivables, % | 7.08 | 10.21 | 5.71 | 4.21 | 6.15 | 6.67 | 6.67 | 6.67 | 6.67 | 6.67 |
| Inventories | 1,063.4 | 755.9 | 2,720.2 | 2,993.0 | 2,797.2 | 3,235.7 | 3,910.5 | 4,726.0 | 5,711.6 | 6,902.8 |
| Inventories, % | 7.17 | 8.01 | 8.03 | 6.01 | 7.72 | 7.39 | 7.39 | 7.39 | 7.39 | 7.39 |
| Accounts Payable | 662.2 | 422.0 | 1,772.7 | 1,618.0 | 746.2 | 1,706.2 | 2,062.0 | 2,492.1 | 3,011.8 | 3,639.9 |
| Accounts Payable, % | 4.47 | 4.47 | 5.23 | 3.25 | 2.06 | 3.9 | 3.9 | 3.9 | 3.9 | 3.9 |
| Capital Expenditure | -821.1 | -596.2 | -1,779.0 | -2,608.4 | -2,983.3 | -2,678.4 | -3,236.9 | -3,912.0 | -4,727.8 | -5,713.8 |
| Capital Expenditure, % | -5.54 | -6.32 | -5.25 | -5.24 | -8.23 | -6.12 | -6.12 | -6.12 | -6.12 | -6.12 |
| Tax Rate, % | 18.47 | 18.47 | 18.47 | 18.47 | 18.47 | 18.47 | 18.47 | 18.47 | 18.47 | 18.47 |
| EBITAT | 1,962.2 | -891.1 | 1,140.2 | 5,536.8 | 3,261.2 | 1,913.4 | 2,312.4 | 2,794.6 | 3,377.4 | 4,081.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,268.8 | 410.4 | 913.9 | 5,489.6 | 2,680.2 | 3,755.1 | 3,818.8 | 4,615.2 | 5,577.7 | 6,740.9 |
| WACC, % | 14.95 | 14.57 | 14.16 | 14.58 | 14.69 | 14.59 | 14.59 | 14.59 | 14.59 | 14.59 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 15,899.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 6,876 | |||||||||
| Terminal Value | 54,618 | |||||||||
| Present Terminal Value | 27,646 | |||||||||
| Enterprise Value | 43,546 | |||||||||
| Net Debt | 5,357 | |||||||||
| Equity Value | 38,188 | |||||||||
| Diluted Shares Outstanding, MM | 1,925 | |||||||||
| Equity Value Per Share | 19.83 |
What You Will Receive
- Adjustable Forecast Inputs: Modify key assumptions (growth %, margins, WACC) effortlessly to explore various scenarios.
- Industry-Specific Data: Cenovus Energy Inc.’s financial data pre-loaded to facilitate your analysis.
- Automatic DCF Calculations: The template computes Net Present Value (NPV) and intrinsic value automatically for you.
- Professional and Customizable: A refined Excel model tailored to meet your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and optimizing your time.
Key Features
- Comprehensive Financial Data: Gain access to precise pre-loaded historical figures and future estimates for Cenovus Energy Inc. (CVE).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic recalculations for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
- Designed for All Users: An intuitive layout tailored for investors, CFOs, and consultants, regardless of experience level.
How It Works
- Download the Template: Gain immediate access to the Excel-based CVE DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Cenovus Energy's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation fluctuations.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for Cenovus Energy Inc. (CVE)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and energy consultants.
- Comprehensive Data: Cenovus’s historical and projected financials preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance simplifies the calculation process.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing investments in Cenovus Energy Inc. (CVE).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in Cenovus Energy Inc. (CVE) stock.
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Energy Sector Enthusiasts: Gain insights into how energy companies like Cenovus Energy Inc. (CVE) are valued in the market.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Cenovus Energy Inc. (CVE).
- Real-World Data: Cenovus’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Cenovus Energy Inc. (CVE).
- Dashboard with Visual Outputs: Visualizations and tables providing clear, actionable results for decision-making.