Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

CNQ Stock Forecast, Price Targets, Chart, Dividends & Analysis

Canadian Natural Resources Limited logo

Canadian Natural Resources Limited

Sector: Energy   

Industry: Oil & Gas E&P

29.58
 
USD
  
0.07
  
(0.24%)
Previous close: 29.51  Open: 29.31  Bid: 29.58  Ask: 30.05
52 week range    
29.23   
   41.29
Mkt Cap: 65,343 M  Avg Vol (90 Days): 5,124,968
Peers   
CVE / 
SU / 
OXY / 
IMO / 
CVE-CA / 
PRE-CA / 
Last updated: Sunday 22nd December 2024

Stock Rankings

54
MarketXLS Rank
100
Value
15
Technical
47
Quality
How are these ranks calculated?
Search for a stock

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

CVE

0.035327 B10.6314.42

CVE-CA

IMO

0.027934 B10.3761.73

OXY

0.018744 B12.1747.13

PRE-CA

SU

0.047245 B8.2834.5

SU-CA

Financials

CNQ Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Basic EPS from continuing operations3.6-0.58-0.192.042.134.55-0.376.4957.847.54
Basic EPS total3.6-0.58-0.192.042.134.55-0.376.4957.847.54
Basic weighted shares outstanding1,092 M1,094 M1,100 M1,175 M1,219 M1,191 M1,182 M1,181 M6,810 M1,091 M
Cost of sales15,815 M13,392 M12,439 M15,408 M17,069 M18,045 M17,422 M22,277 M43,392 M29,062 M
Depletion44,118 M6,413 M
Depreciation5,724 M
Depreciation unreconciled5,724 M44,118 M6,413 M
DepreciationAndAmortization5,724 M
Diluted EPS total3.58-0.58-0.192.032.124.54-0.376.4657.127.47
Diluted normalized net income/share3.58-0.58-0.192.032.124.54-0.376.4657.127.47
Diluted weighted shares outstanding1,097 M1,094 M1,100 M1,183 M1,224 M1,193 M1,182 M1,187 M6,895 M1,102 M
Dividends paid per share0.450.460.470.550.670.750.851.01.553.7
Earnings from equity interest-8 M-50 M327 M38 M-346 M-293 M400 M
EarningsFromEquityInterestNetOfTax-8 M-50 M327 M38 M-346 M-293 M400 M
GainOnSaleOfBusiness400 M
GainOnSaleOfPPE137 M739 M250 M379 M452 M
GainOnSaleOfSecurity497 M-292 M22 M752 M-693 M493 M111 M232 M1,176 M56 M
GeneralAndAdministrativeExpense433 M344 M700 M453 M179 M567 M309 M880 M2,490 M452 M
Gross operating profit5,486 M-225 M-437 M2,952 M5,213 M6,349 M69 M10,577 M253,788 M11,773 M
ImpairmentOfCapitalAssets-400 M
Income before tax5,163 M-667 M-1,063 M2,873 M3,522 M4,956 M-873 M9,911 M89,628 M10,165 M
Income restructuring and M&A-379 M-452 M-217 M-478 M
Income taxes1,234 M-30 M-859 M476 M931 M-460 M-438 M2,247 M18,270 M1,932 M
Interest income8 M53 M48 M97 M59 M76 M72 M32 M-726 M55 M
InterestExpenseNonOperating338 M374 M431 M728 M798 M912 M828 M743 M4,020 M691 M
InterestExpenseOperating4,020 M
MiscOtherSpecialCharges-36 M-1,476 M-364 M
Net income from total operations3,929 M-637 M-204 M2,397 M2,591 M5,416 M-435 M7,664 M71,358 M8,233 M
NetIncomeCommonStockholders3,929 M-637 M-204 M2,397 M2,591 M5,416 M-435 M7,664 M71,358 M8,233 M
NetIncomeContinuousOperations3,929 M-637 M-204 M2,397 M2,591 M5,416 M-435 M7,664 M71,358 M8,233 M
NetNonOperatingInterestIncomeExpense323 M322 M383 M631 M739 M836 M756 M711 M-4,746 M-636 M
NetOperatingInterestIncomeExpense-4,020 M
Normalized income3,658 M-1,436 M-2,172 M1,354 M1,685 M4,496 M-1,528 M6,407 M65,877 M7,471 M
Operating income4,860 M-742 M-1,279 M2,335 M4,848 M5,592 M-445 M9,512 M90,246 M10,464 M
Operating income before depreciation (EBITDA)10,381 M5,190 M4,226 M8,787 M9,481 M11,414 M6,001 M16,378 M137,766 M17,269 M
OperatingExpense626 M517 M842 M617 M365 M757 M514 M1,065 M163,542 M1,309 M
Other income net626 M397 M599 M1,169 M-587 M200 M328 M1,110 M300 M337 M
OtherCostofRevenue2,797 M43,392 M4,867 M
OtherGandA433 M344 M700 M453 M179 M567 M309 M880 M2,490 M452 M
OtherOperatingExpenses193 M173 M142 M164 M186 M190 M205 M185 M52,272 M8,480 M
RestructringAndMnAIncome-379 M-452 M-217 M-478 M
SalariesAndWages66 M-46 M355 M134 M-146 M223 M-82 M514 M4,824 M491 M
Selling Gen & administrative expense433 M344 M700 M453 M179 M567 M309 M880 M62,328 M9,754 M
SellingAndMarketingExpense6,604 M59,838 M9,302 M
Special income/charges137 M739 M250 M379 M452 M217 M478 M
Total Income available for interest expense (EBIT)5,501 M-293 M-632 M3,601 M4,320 M5,868 M-45 M10,654 M93,648 M10,856 M
Total common shares outstanding1,092 M1,094 M1,108 M1,218 M1,206 M1,183 M1,181 M1,175 M1,185 M
Total net income3,929 M-637 M-204 M2,397 M2,591 M5,416 M-435 M7,664 M71,358 M8,233 M
Total ordinary shares2,135 M2,135 M2,135 M2,135 M2,135 M2,135 M2,135 M2,135 M2,135 M2,135 M
Total revenues21,301 M13,167 M12,002 M18,360 M22,282 M24,394 M17,491 M32,854 M297,180 M40,835 M
TotalExpenses-16,441 M-13,909 M-13,281 M-16,025 M-17,434 M-18,802 M-17,936 M-23,342 M206,934 M30,371 M
TotalRevenue21,301 M13,167 M12,002 M18,360 M22,282 M24,394 M17,491 M32,854 M297,180 M40,835 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University