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

CNQ Stock Annual Balance Sheet. Download in Excel

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,135,636
Peers   
CVE / 
SU / 
OXY / 
IMO / 
CVE-CA / 
PRE-CA / 
Last updated: Monday 23rd December 2024

Stock Rankings

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

Financials

CNQ Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable564 M571 M595 M775 M779 M816 M667 M803 M8,046 M1,418 M
Accounts receivable1,889 M1,277 M1,434 M2,397 M1,148 M2,465 M2,190 M3,111 M21,330 M3,189 M
Accrued expenses3,843 M2,660 M2,817 M3,372 M3,286 M3,427 M3,013 M5,474 M41,244 M4,952 M
Accumulated depreciation & depletion-41,036 M-46,950 M-50,916 M-54,579 M-59,263 M-61,746 M-66,143 M-70,682 M-465,288 M-82,342 M
Building & improvements395 M585 M589 M
Cash and equivalents25 M69 M17 M137 M101 M139 M184 M744 M5,520 M877 M
CashCashEquivalentsAndShortTermInvestments25 M1,043 M930 M1,030 M625 M629 M489 M1,053 M8,466 M1,402 M
CommercialPaper580 M692 M336 M625 M141 M329 M544 M
Common par4,432 M4,541 M4,671 M9,109 M9,323 M9,533 M9,606 M10,168 M61,764 M10,712 M
Common stock equity28,891 M27,381 M26,267 M31,653 M31,974 M34,991 M32,380 M36,945 M229,050 M39,832 M
CommonStock4,432 M4,541 M4,671 M9,109 M9,323 M9,533 M9,606 M10,168 M61,764 M10,712 M
CurrentAccruedExpenses3,279 M2,089 M2,222 M2,597 M2,356 M2,611 M2,346 M3,064 M25,254 M3,534 M
CurrentCapitalLeaseObligation233 M189 M185 M
FinancialAssets204 M373 M
Finished goods332 M186 M263 M285 M297 M468 M390 M535 M
Float term debt13,022 M15,065 M14,993 M20,581 M19,482 M18,591 M20,110 M13,694 M66,246 M9,819 M
Gross fixed assets (Plant Property & Equipment)97,073 M101,011 M104,208 M122,381 M126,459 M134,157 M135,976 M140,840 M863,124 M148,381 M
IncomeTaxPayable151 M1,607 M7,944 M
Inventories665 M525 M689 M894 M955 M1,152 M1,060 M1,548 M10,890 M2,034 M
Invested capital41,913 M42,446 M41,260 M52,234 M51,456 M53,582 M52,490 M50,639 M295,296 M49,651 M
Leases8,682 M1,458 M
LongTermCapitalLeaseObligation1,809 M1,501 M1,399 M
LongTermDebtAndCapitalLeaseObligation13,022 M15,065 M14,993 M20,581 M19,482 M20,400 M21,611 M13,694 M66,246 M9,819 M
Machinery furniture & equipment1,166 M1,073 M286,392 M49,375 M
MineralProperties97,073 M101,011 M103,813 M122,381 M126,459 M132,368 M133,846 M138,824 M564,834 M96,982 M
Net fixed assets (net PP&E)56,037 M54,061 M53,292 M67,802 M67,196 M72,411 M69,833 M70,158 M397,836 M66,039 M
NetOtherUnrealizedGainLoss1,254 M172 M
Non-current deferred income taxes8,970 M9,344 M9,073 M10,975 M11,451 M10,539 M10,144 M10,220 M60,684 M10,183 M
NonCurrentAccountsReceivable510 M591 M
NonCurrentDeferredLiabilities8,970 M9,344 M9,073 M10,975 M11,451 M10,539 M10,144 M10,220 M60,684 M10,183 M
Other current assets510 M375 M283 M79 M116 M54 M82 M35 M
Other equity adjustments51 M75 M70 M-68 M122 M34 M8 M-1000000.01,254 M172 M
Other fixed assets97,073 M101,011 M104,208 M122,381 M126,459 M134,157 M379 M354 M3,216 M566 M
Other non-current assets674 M1,155 M1,020 M162 M1,343 M1,223 M1,082 M565 M3,318 M541 M
Other non-current liabilities4,175 M2,890 M3,223 M4,397 M3,890 M5,554 M6,063 M8,384 M48,966 M8,686 M
OtherCurrentBorrowings400 M1,037 M1,812 M1,252 M1,000 M2,062 M1,343 M1,000 M
OtherCurrentLiabilities319 M206 M463 M1,012 M335 M586 M533 M948 M
OtherInventories3,666 M546 M
Payables564 M571 M595 M775 M930 M816 M667 M2,410 M15,990 M1,418 M
Prepaid expenses172 M162 M149 M175 M176 M174 M231 M195 M1,290 M471 M
Raw materials333 M339 M426 M609 M658 M684 M670 M1,013 M7,224 M1,488 M
Retained earnings24,408 M22,765 M21,526 M22,612 M22,529 M25,424 M22,766 M26,778 M166,032 M28,948 M
Short term debt980 M1,729 M1,812 M1,877 M1,141 M2,391 M1,343 M1,000 M10,662 M2,483 M
TaxesReceivable228 M677 M851 M322 M13 M309 M
Total assets60,200 M59,275 M58,648 M73,867 M71,559 M78,121 M75,276 M76,665 M443,496 M73,747 M
Total current assets3,489 M4,059 M4,336 M4,897 M3,020 M4,487 M4,361 M5,942 M42,342 M7,167 M
Total current liabilities5,142 M4,595 M5,092 M6,261 M4,762 M6,637 M5,078 M7,422 M51,906 M7,435 M
Total equity28,891 M27,381 M26,267 M31,653 M31,974 M34,991 M32,380 M36,945 M229,050 M39,832 M
Total liabilities31,309 M31,894 M32,381 M42,214 M39,585 M43,130 M42,896 M39,720 M227,802 M36,123 M
Total non-current assets56,711 M55,216 M54,312 M68,970 M68,539 M73,634 M70,915 M70,723 M401,154 M66,580 M
Total non-current liabilities26,167 M27,299 M27,289 M35,953 M34,823 M36,493 M37,818 M32,298 M175,896 M28,688 M
TotalEquityGrossMinority28,891 M27,381 M26,267 M31,653 M31,974 M34,991 M32,380 M36,945 M229,050 M39,832 M
TotalEquityGrossMinorityInterest28,891 M27,381 M26,267 M31,653 M31,974 M34,991 M32,380 M36,945 M229,050 M39,832 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest60,200 M59,275 M58,648 M73,867 M71,559 M78,121 M75,276 M76,665 M456,852 M75,955 M
TotalNonCurrentLiabilitiesNetMinorityInteres26,167 M27,299 M27,289 M35,953 M34,823 M36,493 M37,818 M32,298 M175,896 M28,688 M
TotalTaxPayable151 M1,607 M7,944 M
UnrealizedGainLoss1,254 M172 M
Working capital-1,653 M-536 M-756 M-1,364 M-1,742 M-2,150 M-717 M-1,480 M-9,564 M-268 M
debtc980 M1,729 M1,812 M1,877 M1,141 M2,624 M1,532 M1,000 M10,662 M2,483 M
ltinv292 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.

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