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

322.09
 
USD
  
4.95
  
(1.56%)
Optionable: Yes  Market Cap: 156,675 M  90-day average vol: 2,886,799

Previous close: 317.14  Open: 321.0  Bid: 321.5  Ask: 322.05
52 week range    
204.04   
   334.87
Peers   
DE / 
CMI / 
CNHI / 
KMTUY / 
ASTE / 
Last updated: Friday 23rd February 2024
62
MarketXLS Rank
60
Value
69
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

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

ASTE

0.00791 B34.260.99

CMI

0.025432 B14.5226.54

CNHI

0.008921 B9.914.85

DE

0.0113116 B19.8372.2

GE

0.0032108 B-15.299.9

KMTUY

Financials

CAT Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Amortization of intangibles6,956 M6,694 M6,615 M6,020 M6,200 M6,217 M6,196 M6,394 M6,324 M5,288 M
Basic EPS from continuing operations5.875.993.54-0.111.2710.3910.855.5111.9312.72
Basic EPS total5.875.993.54-0.111.2710.3910.855.5111.9312.72
Basic weighted shares outstanding645 M617 M594 M584 M592 M591 M562 M544 M544 M527 M
Cost of sales40,727 M39,767 M33,546 M28,309 M31,049 M36,997 M36,630 M29,082 M35,513 M41,350 M
Depletion35,513 M
Depreciation3,087 M3,163 M3,046 M3,034 M2,877 M2,766 M2,577 M2,432 M2,352 M2,219 M
Depreciation unreconciled35,513 M
DepreciationAndAmortization3,087 M3,163 M3,046 M3,034 M2,877 M2,766 M2,577 M2,432 M2,352 M2,219 M
DevelopmentExpense36,630 M
Diluted EPS total5.755.883.5-0.111.2610.2610.745.4611.8312.64
Diluted normalized net income/share5.755.883.5-0.111.2610.2610.745.4611.8312.64
Diluted weighted shares outstanding659 M629 M601 M584 M599 M599 M568 M549 M549 M530 M
Dividends paid per share2.322.73.013.083.113.954.124.364.71
Earnings from equity interest-6 M8 M-6 M16 M24 M28 M14 M31 M19 M
EarningsFromEquityInterestNetOfTax-6 M8 M-6 M16 M24 M28 M14 M31 M19 M
GainOnSaleOfSecurity84 M66 M176 M74 M187 M195 M202 M112 M134 M167 M
GainsLossOnDisposalOfDiscontinuedOperations68 M-4 M
GeneralAndAdministrativeExpense5,547 M5,697 M4,951 M4,686 M4,999 M5,478 M5,162 M4,642 M5,365 M5,651 M
Gross operating profit14,929 M15,417 M13,465 M10,228 M45,462 M17,725 M17,170 M12,666 M15,458 M18,077 M
ImpairmentOfCapitalAssets595 M36,997 M29,082 M925 M
Income before tax5,128 M5,083 M3,439 M139 M4,082 M7,822 M7,812 M3,995 M8,204 M8,752 M
Income restructuring and M&A200 M441 M898 M1,019 M1,256 M386 M236 M-271 M-92 M-77 M
Income taxes1,319 M1,380 M916 M192 M3,339 M1,698 M1,746 M1,006 M1,742 M2,067 M
InsuranceAndClaims36,997 M
Interest income2,962 M3,042 M2,864 M2,764 M2,786 M
InterestExpenseNonOperating1,175 M1,103 M943 M1,008 M
InterestExpenseOperating-1,141 M-1,109 M-1,047 M-1,075 M-1,131 M-1,088 M-1,057 M-1,089 M-920 M-959 M
MinorityInterests-14 M-16 M-11 M-8 M-5 M-1000000.0-1000000.0-5 M-4 M1000000.0
MiscOtherSpecialCharges-35 M239 M161 M146 M153 M-67 M-57 M-44 M1,814 M1,291 M
Net income from total operations3,789 M3,695 M2,512 M-67 M754 M6,147 M6,093 M2,998 M6,489 M6,705 M
NetIncomeCommonStockholders3,789 M3,695 M2,512 M-67 M754 M6,147 M6,093 M2,998 M6,489 M6,705 M
NetIncomeContinuousOperations3,789 M3,695 M2,512 M-67 M754 M6,147 M6,093 M2,998 M6,489 M6,705 M
NetIncomeDiscontinuousOperations68 M-4 M
NetNonOperatingInterestIncomeExpense2,962 M3,042 M2,864 M2,764 M2,786 M-1,175 M-1,103 M-943 M-1,008 M
Normalized income3,533 M3,763 M3,586 M2,560 M3,909 M43,562 M6,407 M31,967 M6,389 M49,112 M
Operating income5,628 M5,328 M3,785 M498 M4,460 M8,293 M8,290 M4,553 M6,878 M7,904 M
Operating income before depreciation (EBITDA)7,074 M7,137 M5,438 M2,098 M5,828 M9,500 M10,507 M6,441 M10,579 M11,020 M
OperatingExpense50,028 M49,856 M43,226 M38,039 M41,002 M46,429 M42,214 M7,524 M43,638 M8,683 M
Other income net41 M-247 M-161 M-140 M31,091 M43 M29 M30 M-1,845 M40,040 M
Other special charges453 M856 M746 M
OtherGandA5,547 M5,697 M4,951 M4,686 M4,999 M5,478 M5,162 M4,642 M5,365 M5,651 M
OtherImpairmentOfCapitalAssets18 M
OtherOperatingExpenses254 M1,009 M1,436 M1,306 M1,609 M660 M-1,271 M1,467 M1,074 M1,218 M
OtherWriteDown41,350 M
RentAndLandingFees436 M391 M371 M375 M331 M322 M
Research & development expense2,046 M2,135 M2,119 M1,951 M1,842 M1,850 M38,323 M1,415 M1,686 M1,814 M
ResearchExpense2,046 M2,135 M2,119 M1,951 M1,842 M1,850 M1,693 M1,415 M1,686 M1,814 M
RestructringAndMnAIncome200 M441 M898 M1,019 M1,256 M386 M236 M-271 M-92 M-77 M
Revenue per share6,956 M6,694 M6,615 M6,020 M6,200 M6,217 M6,196 M6,394 M6,324 M5,288 M
SalariesAndWages-73 M-79 M-87 M-61 M-40 M-36 M-35 M-34 M-23 M-32 M
Selling Gen & administrative expense5,547 M5,697 M4,951 M4,686 M4,999 M5,478 M5,162 M4,642 M5,365 M5,651 M
SellingAndMarketingExpense36,630 M29,082 M
Special income/charges-200 M-441 M-1,351 M-595 M-1,256 M-36,997 M-236 M-29,082 M92 M-925 M
Total Income available for interest expense (EBIT)3,987 M3,974 M2,392 M-936 M2,951 M6,734 M7,930 M4,009 M8,227 M8,801 M
Total common shares outstanding638 M606 M582 M586 M598 M576 M550 M545 M536 M516 M
Total net income3,789 M3,695 M2,512 M-67 M754 M6,147 M6,093 M2,998 M6,489 M6,705 M
Total ordinary shares509 M509 M509 M509 M509 M509 M509 M509 M509 M509 M
Total revenues52,694 M52,142 M44,147 M35,773 M45,462 M54,722 M53,800 M41,748 M50,971 M59,427 M
TotalExpenses90,755 M89,623 M76,772 M66,348 M72,105 M83,426 M78,844 M36,606 M79,151 M50,033 M
TotalRevenue55,656 M55,184 M47,011 M38,537 M45,462 M54,722 M53,800 M41,748 M50,971 M59,427 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