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

75.47
 
USD
  
0.37
  
(0.49%)
Optionable: Yes  Market Cap: 80,538 M  90-day average vol: 2,885,413

Previous close: 75.1  Open: 74.75  Bid: 73.85  Ask: 76.26
52 week range    
52.66   
   75.99
Peers   
CVE / 
SU / 
OXY / 
IMO / 
CVE-CA / 
PRE-CA / 
Last updated: Thursday 28th March 2024
83
MarketXLS Rank
80
Value
92
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 Balance Sheet

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""1,444 M980 M1,729 M1,812 M1,877 M1,141 M2,624 M1,532 M1,000 M1,777 M
Accounts payable637 M564 M571 M595 M775 M779 M816 M667 M803 M1,341 M
Accounts receivable1,427 M1,889 M1,277 M1,434 M2,397 M1,148 M2,465 M2,190 M3,111 M3,555 M
Accrued expenses3,515 M3,843 M2,660 M2,817 M3,372 M3,286 M3,427 M3,013 M5,474 M6,874 M
Accumulated depreciation & depletion-36,061 M-41,036 M-46,950 M-50,916 M-54,579 M-59,263 M-61,746 M-66,143 M-70,682 M-77,548 M
Building & improvements395 M585 M589 M
Cash and equivalents16 M25 M69 M17 M137 M101 M139 M184 M744 M920 M
CashCashEquivalentsAndShortTermInvestments16 M25 M1,043 M930 M1,030 M625 M629 M489 M1,053 M1,411 M
CommercialPaper532 M580 M692 M336 M625 M141 M329 M544 M
Common par3,854 M4,432 M4,541 M4,671 M9,109 M9,323 M9,533 M9,606 M10,168 M10,294 M
Common stock equity25,772 M28,891 M27,381 M26,267 M31,653 M31,974 M34,991 M32,380 M36,945 M38,175 M
CommonStock3,854 M4,432 M4,541 M4,671 M9,109 M9,323 M9,533 M9,606 M10,168 M10,294 M
CurrentAccruedExpenses2,519 M3,279 M2,089 M2,222 M2,597 M2,356 M2,611 M2,346 M3,064 M4,209 M
CurrentCapitalLeaseObligation233 M189 M185 M
FinancialAssets204 M373 M
Finished goods342 M332 M186 M263 M285 M297 M468 M390 M535 M
Float term debt8,217 M13,022 M15,065 M14,993 M20,581 M19,482 M18,591 M20,110 M13,694 M11,041 M
Gross fixed assets (Plant Property & Equipment)85,157 M97,073 M101,011 M104,208 M122,381 M126,459 M134,157 M135,976 M140,840 M146,080 M
IncomeTaxPayable359 M151 M1,607 M1,324 M
Inventories632 M665 M525 M689 M894 M955 M1,152 M1,060 M1,548 M1,815 M
Invested capital33,989 M41,913 M42,446 M41,260 M52,234 M51,456 M53,582 M52,490 M50,639 M49,216 M
Leases1,447 M
LongTermCapitalLeaseObligation1,809 M1,501 M1,399 M
LongTermDebtAndCapitalLeaseObligation8,217 M13,022 M15,065 M14,993 M20,581 M19,482 M20,400 M21,611 M13,694 M11,041 M
Machinery furniture & equipment1,166 M1,073 M47,732 M
MineralProperties85,157 M97,073 M101,011 M103,813 M122,381 M126,459 M132,368 M133,846 M138,824 M96,365 M
Net fixed assets (net PP&E)49,096 M56,037 M54,061 M53,292 M67,802 M67,196 M72,411 M69,833 M70,158 M68,532 M
NetOtherUnrealizedGainLoss209 M
Non-current deferred income taxes8,183 M8,970 M9,344 M9,073 M10,975 M11,451 M10,539 M10,144 M10,220 M10,114 M
NonCurrentAccountsReceivable510 M591 M
NonCurrentDeferredLiabilities8,183 M8,970 M9,344 M9,073 M10,975 M11,451 M10,539 M10,144 M10,220 M10,114 M
Number of employees9735.09735.09735.09735.09735.09735.09735.09735.09735.09735.0
Other current assets510 M375 M283 M79 M116 M54 M82 M35 M
Other equity adjustments42 M51 M75 M70 M-68 M122 M34 M8 M-1000000.0209 M
Other fixed assets85,157 M97,073 M101,011 M104,208 M122,381 M126,459 M134,157 M379 M354 M536 M
Other non-current assets136 M674 M1,155 M1,020 M162 M1,343 M1,223 M1,082 M565 M553 M
Other non-current liabilities4,348 M4,175 M2,890 M3,223 M4,397 M3,890 M5,554 M6,063 M8,384 M8,161 M
OtherCurrentBorrowings912 M400 M1,037 M1,812 M1,252 M1,000 M2,062 M1,343 M1,000 M
OtherCurrentLiabilities275 M319 M206 M463 M1,012 M335 M586 M533 M948 M
OtherInventories611 M
Payables996 M564 M571 M595 M775 M930 M816 M667 M2,410 M2,665 M
Prepaid expenses141 M172 M162 M149 M175 M176 M174 M231 M195 M215 M
Raw materials290 M333 M339 M426 M609 M658 M684 M670 M1,013 M1,204 M
Retained earnings21,876 M24,408 M22,765 M21,526 M22,612 M22,529 M25,424 M22,766 M26,778 M27,672 M
Short term debt1,444 M980 M1,729 M1,812 M1,877 M1,141 M2,391 M1,343 M1,000 M1,777 M
TaxesReceivable228 M677 M851 M322 M13 M309 M
Total assets51,754 M60,200 M59,275 M58,648 M73,867 M71,559 M78,121 M75,276 M76,665 M76,142 M
Total current assets2,216 M3,489 M4,059 M4,336 M4,897 M3,020 M4,487 M4,361 M5,942 M7,057 M
Total current liabilities5,234 M5,142 M4,595 M5,092 M6,261 M4,762 M6,637 M5,078 M7,422 M8,651 M
Total equity25,772 M28,891 M27,381 M26,267 M31,653 M31,974 M34,991 M32,380 M36,945 M38,175 M
Total liabilities25,982 M31,309 M31,894 M32,381 M42,214 M39,585 M43,130 M42,896 M39,720 M37,967 M
Total non-current assets49,538 M56,711 M55,216 M54,312 M68,970 M68,539 M73,634 M70,915 M70,723 M69,085 M
Total non-current liabilities20,748 M26,167 M27,299 M27,289 M35,953 M34,823 M36,493 M37,818 M32,298 M29,316 M
TotalEquityGrossMinority25,772 M28,891 M27,381 M26,267 M31,653 M31,974 M34,991 M32,380 M36,945 M38,175 M
TotalEquityGrossMinorityInterest25,772 M28,891 M27,381 M26,267 M31,653 M31,974 M34,991 M32,380 M36,945 M38,175 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest51,754 M60,200 M59,275 M58,648 M73,867 M71,559 M78,121 M75,276 M76,665 M76,142 M
TotalNonCurrentLiabilitiesNetMinorityInteres20,748 M26,167 M27,299 M27,289 M35,953 M34,823 M36,493 M37,818 M32,298 M29,316 M
TotalTaxPayable359 M151 M1,607 M1,324 M
UnrealizedGainLoss209 M
Working capital-3,018 M-1,653 M-536 M-756 M-1,364 M-1,742 M-2,150 M-717 M-1,480 M-1,594 M
ltinv306 M292 M287 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