Suncor Energy Inc. (SU) DCF Valuation

Suncor Energy Inc. (SU) DCF Valuation
  • ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • ✓ Aucune Expertise N'Est Requise; Facile À Suivre

Suncor Energy Inc. (SU) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Looking to determine the intrinsic value of Suncor Energy Inc.? Our Suncor Energy Inc. (SU) DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment choices.


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 27,671.3 17,118.1 27,161.8 40,491.4 36,236.6 41,590.7 47,736.0 54,789.3 62,884.7 72,176.3
Revenue Growth, % 0 -38.14 58.67 49.07 -10.51 14.78 14.78 14.78 14.78 14.78
EBITDA 7,648.4 1,768.6 8,763.8 15,466.8 12,362.0 11,857.5 13,609.5 15,620.4 17,928.4 20,577.4
EBITDA, % 27.64 10.33 32.27 38.2 34.11 28.51 28.51 28.51 28.51 28.51
Depreciation 5,244.7 5,318.9 4,271.5 6,317.8 4,466.6 7,792.5 8,943.9 10,265.4 11,782.2 13,523.1
Depreciation, % 18.95 31.07 15.73 15.6 12.33 18.74 18.74 18.74 18.74 18.74
EBIT 2,403.7 -3,550.4 4,492.3 9,149.0 7,895.5 4,065.0 4,665.6 5,355.0 6,146.2 7,054.3
EBIT, % 8.69 -20.74 16.54 22.59 21.79 9.77 9.77 9.77 9.77 9.77
Total Cash 1,360.4 1,308.4 1,530.5 1,374.3 1,200.1 2,071.3 2,377.3 2,728.6 3,131.7 3,594.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 2,904.8 2,695.9 3,235.9 4,381.2 4,660.9
Account Receivables, % 10.5 15.75 11.91 10.82 12.86
Inventories 2,610.5 2,510.6 2,852.8 3,510.8 3,723.9 4,454.4 5,112.6 5,868.0 6,735.0 7,730.1
Inventories, % 9.43 14.67 10.5 8.67 10.28 10.71 10.71 10.71 10.71 10.71
Accounts Payable 4,549.9 3,251.2 4,513.8 5,668.8 5,366.1 6,726.2 7,720.1 8,860.7 10,170.0 11,672.6
Accounts Payable, % 16.44 18.99 16.62 14 14.81 16.17 16.17 16.17 16.17 16.17
Capital Expenditure -3,857.8 -2,725.1 -3,161.7 -3,553.8 -4,120.2 -5,128.0 -5,885.7 -6,755.3 -7,753.4 -8,899.1
Capital Expenditure, % -13.94 -15.92 -11.64 -8.78 -11.37 -12.33 -12.33 -12.33 -12.33 -12.33
Tax Rate, % 21.66 21.66 21.66 21.66 21.66 21.66 21.66 21.66 21.66 21.66
EBITAT 2,751.0 -2,515.0 3,322.0 6,742.9 6,185.0 3,226.2 3,702.8 4,250.0 4,877.9 5,598.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 3,172.3 -910.9 4,812.3 8,858.5 5,735.9 6,037.0 6,336.7 7,272.9 8,347.6 9,581.0
WACC, % 10.13 9.86 9.89 9.88 9.93 9.94 9.94 9.94 9.94 9.94
PV UFCF
SUM PV UFCF 27,888.3
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 9,773
Terminal Value 123,122
Present Terminal Value 76,667
Enterprise Value 104,555
Net Debt 9,770
Equity Value 94,785
Diluted Shares Outstanding, MM 1,310
Equity Value Per Share 72.35

What You Will Get

  • Real SU Financials: Includes historical and forecasted data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Dynamic Calculations: Intrinsic value and NPV are computed automatically.
  • Scenario Analysis: Explore various scenarios to assess Suncor’s future performance.
  • User-Friendly Design: Designed for professionals but easy for beginners to navigate.

Key Features

  • Real-Time SU Data: Pre-loaded with Suncor’s historical performance metrics and future projections.
  • Customizable Assumptions: Modify production levels, pricing forecasts, operating costs, and capital investments.
  • Interactive Valuation Model: Automatically recalculates Net Present Value (NPV) and intrinsic value based on user inputs.
  • Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation results.
  • Intuitive Interface: Clean, organized design suitable for both industry professionals and novices.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Suncor Energy data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Suncor Energy’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for Suncor Energy Inc. (SU)?

  • User-Friendly Interface: Tailored for both novices and seasoned professionals.
  • Customizable Inputs: Easily adjust parameters to suit your financial analysis.
  • Real-Time Valuation: Witness immediate updates to Suncor's valuation as you modify inputs.
  • Pre-Loaded Data: Comes equipped with Suncor's actual financial metrics for swift evaluations.
  • Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling Suncor Energy Inc. (SU) stock.
  • Financial Analysts: Streamline valuation processes with ready-to-use financial models for Suncor Energy Inc. (SU).
  • Consultants: Deliver professional valuation insights on Suncor Energy Inc. (SU) to clients quickly and accurately.
  • Business Owners: Understand how large companies like Suncor Energy Inc. (SU) are valued to guide your own strategy.
  • Finance Students: Learn valuation techniques using real-world data and scenarios related to Suncor Energy Inc. (SU).

What the Template Contains

  • Historical Data: Includes Suncor Energy Inc.'s (SU) past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Suncor Energy Inc.'s (SU) intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of Suncor Energy Inc.'s (SU) financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.