Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Caterpillar Inc. logo

Caterpillar Inc.

Sector: Industrials   

Industry: Farm & Construction Equipment

363.52
 
USD
  
0.27
  
(0.07%)
Optionable: Yes  Market Cap: 181,399 M  90-day average vol: 2,364,111

Previous close: 363.25  Open: 363.95  Bid: 364.25  Ask: 365.98
52 week range    
204.04   
   382.01
Peers   
DE / 
CMI / 
CNHI / 
KMTUY / 
ASTE / 
Last updated: Thursday 25th April 2024
68
MarketXLS Rank
65
Value
84
Technical
57
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

CAT Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""21 M1,430 M54 M123 M1,044 M
Accounts payable6,515 M5,023 M4,614 M6,487 M7,051 M5,957 M6,128 M8,154 M8,689 M7,906 M
Accounts receivable7,737 M6,695 M5,981 M7,436 M8,802 M8,568 M7,317 M8,477 M8,856 M9,310 M
Accrued expenses10,487 M8,587 M8,069 M10,173 M11,119 M10,274 M10,332 M12,506 M13,389 M13,513 M
Accumulated depreciation & depletion-14,995 M-15,887 M-16,618 M-17,383 M-16,207 M-16,313 M-16,870 M-16,781 M-16,036 M-15,943 M
Cash and equivalents7,341 M6,460 M7,168 M8,261 M7,857 M8,284 M9,352 M9,254 M7,004 M6,978 M
CashCashEquivalentsAndShortTermInvestments7,341 M6,460 M7,168 M8,261 M7,857 M8,284 M9,352 M9,254 M7,004 M6,978 M
CashEquivalents7,341 M6,460 M7,168 M8,261 M
Common par5,016 M5,238 M5,277 M5,593 M5,827 M5,935 M6,230 M6,398 M6,560 M6,403 M
Common stock equity16,746 M14,809 M13,137 M13,697 M14,039 M14,588 M15,331 M16,484 M15,869 M19,494 M
CommonStock5,016 M5,238 M5,277 M5,593 M5,827 M5,935 M6,230 M6,398 M6,560 M6,403 M
Cost in excess6,694 M6,615 M6,020 M6,200 M6,217 M6,196 M6,394 M6,324 M5,288 M5,308 M
CurrentAccruedExpenses3,548 M3,116 M3,003 M3,220 M3,573 M3,750 M3,642 M3,757 M4,080 M4,958 M
CurrentCapitalLeaseObligation229 M237 M211 M211 M205 M205 M163 M158 M151 M147 M
CurrentDeferredRevenue1,697 M1,146 M1,167 M1,426 M1,243 M1,187 M1,108 M1,087 M1,860 M1,929 M
CurrentDeferredTaxesAssets2,259 M2,442 M1,324 M1,358 M1,669 M2,047 M2,634 M
CurrentDeferredTaxesLiabilities-3,179 M-3,211 M-3,558 M-2,001 M-2,098 M-2,265 M-2,169 M-2,195 M-2,116 M2,180 M
CurrentProvisions18,291 M16,209 M14,382 M15,918 M16,995 M17,140 M
Deferred revenues1,697 M1,146 M1,167 M1,426 M1,243 M1,187 M1,108 M1,087 M1,860 M1,929 M
DeferredFinancingCosts80 M
DividendsPayable424 M448 M452 M466 M495 M567 M562 M595 M620 M649 M
EmployeeBenefits8,963 M8,843 M9,357 M8,365 M7,455 M6,599 M6,872 M5,592 M4,203 M4,098 M
Finished goods6,504 M5,122 M4,576 M4,761 M5,562 M5,598 M6,054 M6,907 M8,138 M8,308 M
Float term debt6,793 M5,877 M6,662 M6,194 M5,830 M9,141 M9,749 M9,746 M9,498 M8,579 M
GoodwillAndOtherIntangibleAssets9,770 M9,436 M8,369 M8,311 M8,114 M7,761 M7,702 M7,366 M6,046 M5,872 M
Gross fixed assets (Plant Property & Equipment)31,572 M31,977 M31,940 M31,538 M29,781 M29,217 M29,271 M28,871 M28,064 M28,623 M
Intangibles3,076 M2,821 M2,349 M2,111 M1,897 M1,565 M1,308 M1,042 M758 M564 M
Inventories12,205 M9,700 M8,614 M10,018 M11,529 M11,266 M11,402 M14,038 M16,270 M16,565 M
Invested capital51,323 M45,855 M42,617 M43,738 M44,869 M32,870 M34,829 M52,263 M34,865 M36,652 M
Leases111 M124 M99 M96 M129 M
LineOfCredit9,162 M6,990 M6,707 M9,932 M9,146 M-10,084 M-11,613 M-8,287 M-7,712 M9,742 M
LongTermCapitalLeaseObligation695 M457 M484 M428 M644 M
LongTermDebtAndCapitalLeaseObligation6,793 M5,877 M6,662 M6,194 M5,830 M26,281 M25,999 M26,033 M9,498 M8,579 M
LongTermProvisions9,493 M8,960 M8,436 M7,929 M8,005 M9,141 M
Minority interest80 M76 M76 M69 M41 M41 M47 M32 M22 M9 M
Net fixed assets (net PP&E)16,577 M16,090 M15,322 M14,155 M13,574 M12,904 M12,401 M12,090 M12,028 M12,680 M
NetOtherUnrealizedGainLoss-97 M-62 M28 M
NetUnrealizedGainLossForeignCurrency-1,487 M-910 M-1,508 M-2,328 M
NetUnrealizedGainLossInvestments20 M54 M20 M-118 M
Non-current deferred income taxes414 M335 M237 M281 M331 M414 M418 M412 M471 M454 M
NonCurrentAccountsReceivable1,364 M1,170 M1,029 M990 M1,161 M1,193 M1,185 M1,204 M1,265 M1,238 M
NonCurrentDeferredRevenue1,680 M1,654 M
NonCurrentDeferredTaxesAssets5,703 M6,059 M7,106 M4,282 M4,045 M4,103 M4,118 M4,480 M4,706 M5,195 M
NonCurrentNoteReceivables14,644 M13,651 M13,556 M13,542 M13,286 M12,651 M12,222 M12,707 M12,013 M12,664 M
NonCurrentPensionAndOtherPostretirementBenefitPlans8,963 M8,843 M9,357 M8,365 M7,455 M6,599 M6,872 M5,592 M4,203 M4,098 M
NotesReceivable9,027 M8,991 M8,522 M8,757 M8,650 M9,336 M9,463 M8,898 M9,013 M9,510 M
Other current assets1,086 M1,211 M1,088 M1,286 M1,796 M1,778 M1,759 M1,886 M1,140 M1,223 M
Other equity adjustments-6,431 M-6,997 M-2,039 M-1,192 M
Other fixed assets16,577 M16,090 M15,322 M14,155 M13,574 M12,904 M12,401 M12,090 M12,028 M12,680 M
Other non-current assets3,537 M1,998 M1,671 M2,027 M2,332 M3,340 M3,827 M4,131 M4,593 M5,257 M
Other non-current liabilities7,930 M3,203 M3,184 M8,889 M3,756 M4,323 M4,358 M4,805 M4,604 M4,675 M
Other receivable7,743 M7,648 M
OtherCurrentBorrowings4,708 M6,967 M7,303 M4,837 M5,723 M5 M10 M9 M3 M4,643 M
OtherCurrentLiabilities4,201 M10,632 M10,234 M4,302 M10,026 M3,784 M3,113 M4,498 M5,003 M5,880 M
OtherEquityInterest54 M20 M
OtherInventories12,205 M9,700 M8,614 M10,018 M11,529 M11,266 M11,402 M14,038 M16,270 M16,565 M
OtherPayable30 M400 M191 M59 M392 M47 M111 M490 M88 M75 M
Payables6,939 M5,471 M5,066 M6,953 M7,546 M6,524 M6,690 M8,749 M9,309 M8,555 M
Prepaid expenses818 M1,662 M1,682 M1,772 M1,765 M1,739 M1,930 M2,788 M2,642 M4,586 M
Raw materials2,986 M2,467 M2,102 M2,802 M4,477 M4,263 M4,021 M5,528 M6,370 M6,492 M
Retained earnings27,456 M27,211 M25,338 M25,109 M28,743 M32,870 M34,279 M37,729 M41,057 M49,430 M
SecuritySoldNotYetRepurchased4,238 M2,025 M3,800 M4,047 M1,130 M2,668 M4,230 M
Short term debt21 M1,430 M54 M123 M1,044 M
Total assets84,681 M78,342 M74,704 M76,962 M78,509 M78,453 M78,324 M82,793 M81,943 M87,476 M
Total current assets37,128 M33,508 M31,967 M36,244 M38,603 M39,193 M39,464 M43,455 M43,785 M46,949 M
Total current liabilities34,676 M36,574 M33,852 M31,819 M39,383 M15,266 M15,983 M18,145 M31,531 M34,728 M
Total equity16,746 M14,809 M13,137 M13,697 M14,039 M14,588 M15,331 M16,484 M15,869 M19,494 M
Total liabilities67,855 M63,457 M61,491 M63,196 M64,429 M63,824 M62,946 M66,277 M66,052 M67,973 M
Total non-current assets47,553 M44,834 M42,737 M40,718 M39,906 M39,260 M38,860 M39,338 M38,158 M40,527 M
Total non-current liabilities33,179 M26,883 M27,639 M31,377 M25,046 M20,063 M20,979 M20,143 M18,305 M17,352 M
TotalEquityGrossMinority16,826 M14,885 M13,213 M13,766 M14,080 M14,629 M15,378 M16,516 M15,891 M19,503 M
TotalEquityGrossMinorityInterest16,826 M14,885 M13,213 M13,766 M14,080 M14,629 M15,378 M16,516 M15,891 M19,503 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest84,681 M78,342 M74,704 M76,962 M78,509 M63,824 M62,946 M82,793 M81,943 M87,476 M
TotalNonCurrentLiabilitiesNetMinorityInteres33,179 M26,883 M27,639 M31,377 M25,046 M20,063 M20,979 M20,143 M18,305 M17,352 M
Treasury stock-15,726 M-17,640 M-17,478 M-17,005 M-20,531 M-24,217 M-25,178 M-27,643 M-31,748 M-36,339 M
UnearnedIncome1,404 M2,489 M2,790 M1,693 M1,439 M1,411 M1,523 M1,840 M2,213 M2,816 M
Work in progress2,455 M1,857 M1,719 M2,254 M1,259 M1,147 M1,052 M1,318 M1,452 M1,411 M
Working capital2,452 M-3,066 M-1,885 M4,425 M-780 M23,927 M23,481 M25,310 M12,254 M12,221 M
ltinv257 M246 M249 M243 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