Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Canadian Natural Resources Limited logo

Canadian Natural Resources Limited

Sector: Energy   

Industry: Oil & Gas E&P

76.32
 
USD
  
0.85
  
(1.13%)
Optionable: Yes  Market Cap: 80,538 M  90-day average vol: 2,891,580

Previous close: 75.47  Open: 76.11  Bid: 75.03  Ask: 77.55
52 week range    
52.66   
   76.56
Peers   
CVE / 
SU / 
OXY / 
IMO / 
CVE-CA / 
PRE-CA / 
Last updated: Friday 29th March 2024
75
MarketXLS Rank
80
Value
69
Technical
78
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Financials

CNQ Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Basic EPS from continuing operations2.083.6-0.58-0.192.042.134.55-0.376.499.64
Basic EPS total2.083.6-0.58-0.192.042.134.55-0.376.499.64
Basic weighted shares outstanding1,089 M1,092 M1,094 M1,100 M1,175 M1,219 M1,191 M1,182 M1,181 M1,135 M
Cost of sales14,141 M15,815 M13,392 M12,439 M15,408 M17,069 M18,045 M17,422 M22,277 M7,232 M
Depletion7,353 M
Depreciation5,724 M
Depreciation unreconciled5,724 M7,353 M
DepreciationAndAmortization5,724 M
Diluted EPS total2.083.58-0.58-0.192.032.124.54-0.376.469.52
Diluted normalized net income/share2.083.58-0.58-0.192.032.124.54-0.376.469.52
Diluted weighted shares outstanding1,091 M1,097 M1,094 M1,100 M1,183 M1,224 M1,193 M1,182 M1,187 M1,149 M
Dividends paid per share0.580.90.920.941.11.341.51.72.04.47
Earnings from equity interest-4 M-8 M-50 M327 M38 M-346 M-293 M400 M
EarningsFromEquityInterestNetOfTax-4 M-8 M-50 M327 M38 M-346 M-293 M400 M
GainOnSaleOfBusiness400 M
GainOnSaleOfPPE289 M137 M739 M250 M379 M452 M
GainOnSaleOfSecurity-133 M497 M-292 M22 M752 M-693 M493 M111 M232 M196 M
GeneralAndAdministrativeExpense470 M433 M344 M700 M453 M179 M567 M309 M880 M380 M
Gross operating profit3,804 M5,486 M-225 M-437 M2,952 M5,213 M6,349 M69 M10,577 M42,298 M
ImpairmentOfCapitalAssets-400 M
Income before tax3,036 M5,163 M-667 M-1,063 M2,873 M3,522 M4,956 M-873 M9,911 M13,704 M
Income restructuring and M&A-379 M-452 M-217 M-478 M
Income taxes766 M1,234 M-30 M-859 M476 M931 M-460 M-438 M2,247 M2,767 M
Interest income1000000.08 M53 M48 M97 M59 M76 M72 M32 M
InterestExpenseNonOperating282 M338 M374 M431 M728 M798 M912 M828 M743 M
InterestExpenseOperating670 M
InterestIncomeOperating121 M
MiscOtherSpecialCharges-36 M-281 M
Net income from total operations2,270 M3,929 M-637 M-204 M2,397 M2,591 M5,416 M-435 M7,664 M10,937 M
NetIncomeCommonStockholders2,270 M3,929 M-637 M-204 M2,397 M2,591 M5,416 M-435 M7,664 M10,937 M
NetIncomeContinuousOperations2,270 M3,929 M-637 M-204 M2,397 M2,591 M5,416 M-435 M7,664 M10,937 M
NetNonOperatingInterestIncomeExpense279 M323 M322 M383 M631 M739 M836 M756 M711 M
NetOperatingInterestIncomeExpense-549 M
Normalized income1,958 M3,658 M-1,436 M-2,172 M1,354 M1,685 M4,496 M-1,528 M6,407 M10,072 M
Operating income3,163 M4,860 M-742 M-1,279 M2,335 M4,848 M5,592 M-445 M9,512 M15,076 M
Operating income before depreciation (EBITDA)8,162 M10,381 M5,190 M4,226 M8,787 M9,481 M11,414 M6,001 M16,378 M21,727 M
OperatingExpense641 M626 M517 M842 M617 M365 M757 M514 M1,065 M27,222 M
Other income net152 M626 M397 M599 M1,169 M-587 M200 M328 M1,110 M85 M
OtherCostofRevenue2,797 M7,232 M
OtherGandA470 M433 M344 M700 M453 M179 M567 M309 M880 M380 M
OtherOperatingExpenses171 M193 M173 M142 M164 M186 M190 M205 M185 M8,712 M
RestructringAndMnAIncome-379 M-452 M-217 M-478 M
SalariesAndWages135 M66 M-46 M355 M134 M-146 M223 M-82 M514 M804 M
Selling Gen & administrative expense470 M433 M344 M700 M453 M179 M567 M309 M880 M10,353 M
SellingAndMarketingExpense6,604 M9,973 M
Special income/charges289 M137 M739 M250 M379 M452 M217 M478 M
Total Income available for interest expense (EBIT)3,318 M5,501 M-293 M-632 M3,601 M4,320 M5,868 M-45 M10,654 M14,374 M
Total common shares outstanding1,087 M1,092 M1,094 M1,108 M1,218 M1,206 M1,183 M1,181 M1,175 M1,185 M
Total net income2,270 M3,929 M-637 M-204 M2,397 M2,591 M5,416 M-435 M7,664 M10,937 M
Total ordinary shares1,071 M1,071 M1,071 M1,071 M1,071 M1,071 M1,071 M1,071 M1,071 M1,071 M
Total revenues17,945 M21,301 M13,167 M12,002 M18,360 M22,282 M24,394 M17,491 M32,854 M49,530 M
TotalExpenses-14,782 M-16,441 M-13,909 M-13,281 M-16,025 M-17,434 M-18,802 M-17,936 M-23,342 M34,454 M
TotalRevenue17,945 M21,301 M13,167 M12,002 M18,360 M22,282 M24,394 M17,491 M32,854 M49,530 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.

We respect your privacy and will never share your email.
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