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

358.32
 
USD
  
-1.56
  
(-0.43%)
Optionable: Yes  Market Cap: 179,716 M  90-day average vol: 2,408,370

Previous close: 359.88  Open: 362.65  Bid: 357.86  Ask: 358.5
52 week range    
204.04   
   382.01
Peers   
DE / 
CMI / 
CNHI / 
KMTUY / 
ASTE / 
Last updated: Thursday 18th April 2024
61
MarketXLS Rank
65
Value
61
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 Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Amortization of intangibles6,694 M6,615 M6,020 M6,200 M6,217 M6,196 M6,394 M6,324 M5,288 M5,308 M
Basic EPS from continuing operations5.993.54-0.111.2710.3910.855.5111.9312.7220.24
Basic EPS total5.993.54-0.111.2710.3910.855.5111.9312.7220.24
Basic weighted shares outstanding617 M594 M584 M592 M591 M562 M544 M544 M527 M511 M
CommissionExpenses41,350 M
Cost of sales39,767 M33,546 M28,309 M31,049 M36,997 M36,630 M29,082 M35,513 M41,350 M42,767 M
Depreciation3,163 M3,046 M3,034 M2,877 M2,766 M2,577 M2,432 M2,352 M2,219 M2,144 M
Depreciation unreconciled42,767 M
DepreciationAndAmortization3,163 M3,046 M3,034 M2,877 M2,766 M2,577 M2,432 M2,352 M2,219 M42,767 M
DevelopmentExpense36,630 M
Diluted EPS total5.883.5-0.111.2610.2610.745.4611.8312.6420.12
Diluted normalized net income/share5.883.5-0.111.2610.2610.745.4611.8312.6420.12
Diluted weighted shares outstanding629 M601 M584 M599 M599 M568 M549 M549 M530 M514 M
Dividends paid per share2.73.013.083.113.954.124.364.715.1
Earnings from equity interest8 M-6 M16 M24 M28 M14 M31 M19 M63 M
EarningsFromEquityInterestNetOfTax8 M-6 M16 M24 M28 M14 M31 M19 M63 M
GainOnSaleOfBusiness-586 M
GainOnSaleOfSecurity66 M176 M74 M187 M195 M202 M112 M134 M167 M494 M
GainsLossOnDisposalOfDiscontinuedOperations-4 M
GeneralAndAdministrativeExpense5,697 M4,951 M4,686 M4,999 M5,478 M5,162 M4,642 M5,365 M5,651 M6,371 M
Gross operating profit15,417 M13,465 M10,228 M45,462 M17,725 M17,170 M12,666 M15,458 M18,077 M24,293 M
ImpairmentOfCapitalAssets595 M36,997 M29,082 M925 M
Income before tax5,083 M3,439 M139 M4,082 M7,822 M7,812 M3,995 M8,204 M8,752 M13,050 M
Income restructuring and M&A441 M898 M1,019 M1,256 M386 M236 M-271 M-92 M-77 M-74 M
Income taxes1,380 M916 M192 M3,339 M1,698 M1,746 M1,006 M1,742 M2,067 M2,781 M
InsuranceAndClaims36,997 M
Interest income3,042 M2,864 M2,764 M2,786 M
InterestExpenseNonOperating1,175 M1,103 M943 M1,008 M1,541 M
InterestExpenseOperating-1,109 M-1,047 M-1,075 M-1,131 M-1,088 M-1,057 M-1,089 M-920 M41,350 M-1,711 M
MarketingExpense35,513 M
MinorityInterests-16 M-11 M-8 M-5 M-1000000.0-1000000.0-5 M-4 M1000000.03 M
MiscOtherSpecialCharges239 M161 M146 M153 M-67 M-57 M-44 M1,814 M1,291 M595 M
Net income from total operations3,695 M2,512 M-67 M754 M6,147 M6,093 M2,998 M6,489 M6,705 M10,335 M
NetIncomeCommonStockholders3,695 M2,512 M-67 M754 M6,147 M6,093 M2,998 M6,489 M6,705 M10,335 M
NetIncomeContinuousOperations3,695 M2,512 M-67 M754 M6,147 M6,093 M2,998 M6,489 M6,705 M10,335 M
NetIncomeDiscontinuousOperations-4 M
NetNonOperatingInterestIncomeExpense3,042 M2,864 M2,764 M2,786 M-1,175 M-1,103 M-943 M-1,008 M-1,541 M
Normalized income3,763 M3,586 M2,560 M3,909 M43,562 M6,407 M31,967 M10,822 M
Operating income5,328 M3,785 M498 M4,460 M8,293 M8,290 M4,553 M6,878 M7,904 M12,966 M
Operating income before depreciation (EBITDA)7,137 M5,438 M2,098 M5,828 M9,500 M10,507 M6,441 M10,579 M53,329 M15,024 M
OperatingExpense49,856 M43,226 M38,039 M41,002 M46,429 M42,214 M7,524 M43,638 M8,683 M53,064 M
Other income net-247 M-161 M-140 M31,091 M43 M29 M30 M-1,845 M-1,310 M-658 M
Other special charges453 M856 M746 M
OtherGandA5,697 M4,951 M4,686 M4,999 M5,478 M5,162 M4,642 M5,365 M5,651 M6,371 M
OtherImpairmentOfCapitalAssets18 M
OtherOperatingExpenses1,009 M1,436 M1,306 M1,609 M660 M-1,271 M1,467 M1,074 M1,218 M1,818 M
RentAndLandingFees391 M371 M375 M331 M322 M
Research & development expense2,135 M2,119 M1,951 M1,842 M1,850 M38,323 M1,415 M1,686 M1,814 M2,108 M
ResearchExpense2,135 M2,119 M1,951 M1,842 M1,850 M1,693 M1,415 M1,686 M1,814 M2,108 M
RestructringAndMnAIncome441 M898 M1,019 M1,256 M386 M236 M-271 M-92 M-77 M-74 M
Revenue per share6,694 M6,615 M6,020 M6,200 M6,217 M6,196 M6,394 M6,324 M5,288 M42,767 M
SalariesAndWages-79 M-87 M-61 M-40 M-36 M-35 M-34 M-23 M-32 M-33 M
Selling Gen & administrative expense5,697 M4,951 M4,686 M4,999 M5,478 M5,162 M4,642 M40,878 M5,651 M6,371 M
SellingAndMarketingExpense36,630 M29,082 M35,513 M41,350 M
Special income/charges-441 M-1,351 M-595 M-1,256 M-36,997 M-236 M-29,082 M92 M-925 M74 M
Total Income available for interest expense (EBIT)3,974 M2,392 M-936 M2,951 M6,734 M7,930 M4,009 M8,227 M51,110 M12,880 M
Total common shares outstanding606 M582 M586 M598 M576 M550 M545 M536 M516 M499 M
Total net income3,695 M2,512 M-67 M754 M6,147 M6,093 M2,998 M6,489 M6,705 M10,335 M
Total ordinary shares499 M499 M499 M499 M499 M499 M499 M499 M499 M499 M
Total revenues52,142 M44,147 M35,773 M45,462 M54,722 M53,800 M41,748 M50,971 M59,427 M67,060 M
TotalExpenses89,623 M76,772 M66,348 M72,105 M83,426 M78,844 M36,606 M79,151 M50,033 M95,831 M
TotalRevenue55,184 M47,011 M38,537 M45,462 M54,722 M53,800 M41,748 M50,971 M59,427 M67,060 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