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

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

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

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

TM Income Statement

Annual
Mar-14Mar-15Mar-16Mar-17Mar-18Mar-19Mar-20Mar-21Mar-22Mar-23
AccretionOnPreferredStock-3,638 M-4,849 M-4,849 M-4,969 M-6,217 M
Basic EPS from continuing operations575.3688.02741.36605.47842.0650.55735.61803.23205.23179.47
Basic EPS total575.3688.02741.36605.47842.0650.55735.61803.23205.23179.47
Basic weighted shares outstanding3,169 M3,159 M3,111 M3,008 M2,947 M2,872 M2,799 M2,795 M14,126 M13,658 M
Cost of sales19,988,245 M20,916,362 M21,456,086 M21,543,035 M23,889,153 M24,781,785 M24,485,351 M22,382,220 M25,407,834 M30,841,282 M
Depreciation-1,250,853 M-1,409,075 M-1,625,837 M-1,610,950 M-1,734,033 M-1,792,375 M-1,595,347 M-1,644,290 M-1,821,880 M-2,039,904 M
Depreciation unreconciled-1,595,347 M-1,644,290 M-1,821,880 M-2,039,904 M
DepreciationAndAmortization-1,250,853 M-1,409,075 M-1,625,837 M-1,610,950 M-1,734,033 M-1,792,375 M-1,595,347 M-1,644,290 M-1,821,880 M-2,039,904 M
Diluted EPS total574.92687.66735.36599.22832.78645.11729.5794.67205.23179.47
Diluted normalized net income/share574.92687.66735.36599.22832.78645.11729.5794.67205.23179.47
Diluted weighted shares outstanding3,171 M3,160 M3,145 M3,056 M2,995 M2,919 M2,846 M2,795 M14,126 M13,658 M
Dividends paid per share165.0200.0210.0210.0220.0220.0220.0
Earnings from equity interest318,376 M308,545 M329,099 M362,060 M470,083 M360,066 M310,247 M351,029 M560,346 M3,094,381 M
EarningsFromEquityInterestNetOfTax318,376 M308,545 M329,099 M362,060 M470,083 M360,066 M310,247 M351,029 M560,346 M3,094,381 M
GainOnSaleOfBusiness2,418,202 M1,637,582 M2,362,384 M3,544,240 M
GainOnSaleOfPPE-28,657 M-31,625 M-33,329 M-30,673 M-35,289 M-35,902 M-56,913 M
GainOnSaleOfSecurity25,099 M17,912 M9,500 M61,038 M7,684 M-339,472 M-20,082 M2,850,110 M
GeneralAndAdministrativeExpense2,598,660 M2,642,281 M2,943,682 M2,868,485 M3,090,495 M2,976,351 M2,981,965 M2,634,625 M2,975,977 M3,587,990 M
Gross operating profit4,324,399 M4,696,474 M5,093,025 M4,270,461 M5,490,357 M5,443,896 M5,381,196 M4,832,374 M5,971,673 M6,313,016 M
ImpairmentOfCapitalAssets-47,190 M
Income before tax2,759,456 M3,201,373 M3,312,480 M2,193,825 M3,090,512 M2,645,531 M4,829,083 M5,177,616 M6,840,641 M6,120,051 M
Income restructuring and M&A-2,678,691 M-3,357,568 M-4,059,216 M-3,541,437 M-3,598,707 M-3,738,887 M-3,603,232 M
Income taxes767,808 M893,469 M878,269 M628,900 M504,406 M659,944 M681,817 M649,976 M1,115,918 M1,175,765 M
Interest income1,379,267 M1,621,685 M1,854,007 M1,783,697 M1,959,234 M305,846 M435,229 M334,760 M379,350 M
InterestExpenseNonOperating832,524 M948,185 M1,184,782 M1,220,654 M27,586 M28,078 M-524,309 M-471,505 M-410,197 M-651,979 M
InterestExpenseOperating-506,307 M-459,181 M-418,043 M-593,216 M
InterestIncomeOperating798,458 M776,748 M835,739 M1,516,404 M
MinorityInterests-168,529 M-134,566 M-121,517 M-95,876 M-92,123 M-102,714 M74,985 M37,118 M24,504 M41,650 M
MiscOtherSpecialCharges118,338 M76,995 M170,386 M195,205 M225,489 M-166,402 M618,801 M2,245,261 M1,012,798 M1,403,311 M
Net income from total operations1,823,119 M2,173,338 M2,312,694 M1,926,985 M2,493,983 M1,882,873 M4,222,251 M4,564,758 M5,749,227 M4,985,936 M
NetIncomeCommonStockholders1,823,119 M2,173,338 M2,312,694 M1,831,109 M2,493,983 M1,882,873 M4,222,251 M4,564,758 M5,749,227 M4,985,936 M
NetIncomeContinuousOperations1,823,119 M2,173,338 M2,312,694 M1,926,985 M2,493,983 M1,882,873 M4,222,251 M4,564,758 M5,749,227 M4,985,936 M
NetIncomeDiscontinuousOperations80,567 M90,236 M92,147 M76,143 M81,440 M137,293 M
NetNonOperatingInterestIncomeExpense546,743 M673,500 M669,225 M563,043 M-27,586 M-28,078 M258,691 M387,692 M290,763 M254,237 M
Operating income1,725,739 M2,054,193 M2,149,343 M1,401,976 M2,399,862 M2,467,545 M2,318,624 M2,178,492 M2,923,235 M2,646,917 M
Operating income before depreciation (EBITDA)4,842,833 M5,558,633 M6,123,099 M5,025,429 M4,852,131 M4,465,984 M5,393,814 M5,891,220 M7,834,281 M6,914,760 M
OperatingExpense2,598,660 M2,642,281 M2,943,682 M2,868,485 M3,090,495 M2,976,351 M3,062,572 M2,653,882 M3,048,438 M3,666,099 M
Other income net-436,714 M-385,540 M-499,485 M-557,265 M-695,572 M-193,664 M-2,346,387 M-2,596,290 M-3,410,456 M-3,094,381 M
OtherGandA2,598,660 M2,642,281 M2,943,682 M2,868,485 M3,090,495 M2,976,351 M2,981,965 M2,634,625 M2,975,977 M3,587,990 M
OtherImpairmentOfCapitalAssets-6,197 M
OtherOperatingExpenses-310 M-593 M-1,001 M-8,187 M-612 M-1,212 M80,607 M19,257 M72,461 M78,109 M
OtherWriteOff-84,310 M-102,948 M-99,550 M-96,444 M-91,698 M-98,352 M
OtherunderPreferredStockDividend-3,638 M-4,849 M-4,849 M-4,969 M-6,217 M
PreferredStockDividends-3,638 M-4,849 M-4,849 M-4,969 M-6,217 M
PromotionAndAdvertising-419,409 M-435,150 M-489,036 M-448,780 M-509,653 M-490,093 M-470,849 M
ProvisionForGainLossOnDisposal80,567 M90,236 M92,147 M76,143 M81,440 M137,293 M
RentAndLandingFees-94,613 M-98,479 M-101,932 M-92,321 M-112,934 M-115,503 M
Research & development expense-910,517 M-1,004,547 M-1,055,672 M-1,037,528 M-1,064,269 M-1,048,882 M-1,096,019 M-1,084,721 M-1,091,675 M-1,224,564 M
ResearchExpense-910,517 M-1,004,547 M-1,055,672 M-1,037,528 M-1,064,269 M-1,048,882 M-1,096,019 M-1,084,721 M-1,091,675 M-1,224,564 M
RestructringAndMnAIncome-2,678,691 M-3,357,568 M-4,059,216 M-3,541,437 M-3,598,707 M-3,738,887 M-3,603,232 M
Revenue per share-14,676 M
SalariesAndWages-3,403,555 M-3,281,292 M-3,550,882 M-3,985,518 M
Selling Gen & administrative expense2,598,660 M2,642,281 M2,943,682 M2,868,485 M3,090,495 M2,976,351 M2,981,965 M2,634,625 M2,975,977 M3,587,990 M
SellingAndMarketingExpense-419,409 M-435,150 M-489,036 M-448,780 M-509,653 M-490,093 M-470,849 M
Special income/charges2,725,881 M3,357,568 M4,059,216 M3,541,437 M3,598,707 M3,738,887 M3,603,232 M
Total Income available for interest expense (EBIT)3,591,980 M4,149,558 M4,497,262 M3,414,479 M3,118,098 M2,673,609 M3,798,467 M4,246,930 M6,012,401 M4,874,856 M
Total common shares outstanding3,170 M3,147 M3,038 M2,975 M2,910 M283 M2,766 M2,796 M13,778 M13,565 M
Total net income1,823,119 M2,173,338 M2,312,694 M1,926,985 M2,493,983 M1,882,873 M4,222,251 M4,564,758 M5,749,227 M4,985,936 M
Total ordinary shares1,378 M1,378 M1,378 M1,378 M1,378 M1,378 M1,378 M1,378 M1,378 M1,378 M
Total revenues24,312,644 M25,612,836 M26,549,111 M25,813,496 M29,379,510 M30,225,681 M29,866,547 M27,214,594 M31,379,507 M37,154,298 M
TotalExpenses22,586,905 M23,558,643 M24,399,768 M24,411,520 M26,979,648 M27,758,136 M27,547,923 M25,036,102 M28,456,272 M34,507,381 M
TotalRevenue24,312,644 M25,612,836 M26,549,111 M27,597,193 M29,379,510 M30,225,681 M29,866,547 M27,214,594 M31,379,507 M37,154,298 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