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

Microsoft Corporation

Sector: Technology   

Industry: Software - Infrastructure

312.79
 
USD
  
0.65
  
(0.21%)
Optionable: Yes  Market Cap: 2,319,126 M  90-day average vol: 24,653,417

Previous close: 312.14  Open: 312.3  Bid: 313.63  Ask: 313.79
52 week range    
213.43   
   366.78
Peers   
ORCL / 
IBM / 
GOOGL / 
HPQ / 
CSCO / 
AAPL / 
Last updated: Thursday 28th September 2023
52
MarketXLS Rank
70
Value
30
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 ($)

AAPL

0.00513,027 B29171.66

CSCO

0.0268234 B20.755.17

GOOGL

1,827 B26.12784.02

HPQ

0.026741 B6.937.49

IBM

0.047899 B21137.24

ORCL

0.0159216 B23.680.74

SAP

Financials

MSFT Income Statement

Annual
Jun-14Jun-15Jun-16Jun-17Jun-18Jun-19Jun-20Jun-21Jun-22Jun-23
Amortization-845 M-1,300 M-978 M-1,804 M-2,443 M-2,270 M-2,211 M2,521 M2,980 M3,852 M
Amortization of intangibles-845 M-1,300 M-978 M-1,700 M-2,200 M-1,900 M-1,600 M1,600 M2,000 M2,500 M
Basic EPS from continuing operations8.129.79.72
Basic EPS total2.661.492.123.292.155.115.828.129.79.72
Basic weighted shares outstanding8,299 M8,177 M7,925 M7,746 M7,700 M7,673 M7,610 M7,547 M7,496 M7,446 M
Cost of sales27,078 M33,038 M32,780 M34,261 M38,353 M42,910 M46,078 M52,232 M62,650 M65,863 M
Depreciation-3,400 M-4,100 M-4,900 M-6,100 M-7,700 M-9,700 M-10,700 M9,300 M12,600 M11,000 M
DepreciationAndAmortization-3,400 M-4,100 M-4,900 M-6,100 M-7,700 M-9,700 M-10,700 M9,300 M12,600 M11,000 M
Diluted EPS total2.631.482.13.252.135.065.768.059.659.68
Diluted normalized net income/share8.059.659.68
Diluted weighted shares outstanding8,399 M8,254 M8,013 M7,832 M7,794 M7,753 M7,683 M7,608 M7,540 M7,472 M
Dividends paid per share1.121.241.441.561.681.842.042.242.482.72
GainOnSaleOfSecurity776 M1,176 M1,376 M3,064 M2,399 M648 M187 M1,232 M461 M260 M
GeneralAndAdministrativeExpense4,677 M4,611 M4,563 M4,481 M4,754 M4,885 M5,111 M5,107 M5,900 M7,575 M
Gross operating profit59,755 M60,542 M52,540 M62,310 M72,007 M82,933 M96,937 M115,856 M135,620 M146,052 M
ImpairmentOfCapitalAssets-7,498 M-630 M-55 M-54 M
Income before tax27,820 M18,507 M19,751 M29,901 M36,474 M43,688 M53,036 M71,102 M83,716 M89,311 M
Income restructuring and M&A-20,234 M-2,078 M-501 M-306 M
Income taxes5,746 M6,314 M2,953 M4,412 M19,903 M4,448 M8,755 M9,831 M10,978 M16,950 M
Interest income61 M346 M-431 M876 M1,416 M729 M77 M
InterestExpenseNonOperating-597 M-781 M-1,243 M-2,222 M-2,733 M-2,686 M-2,591 M2,346 M2,063 M1,968 M
InterestExpenseOperating-509 M-620 M-1,100 M-1,600 M-2,400 M-2,400 M-2,400 M
MiscOtherSpecialCharges93 M-267 M-195 M-251 M-59 M-57 M-40 M1,186 M333 M788 M
Net income from total operations22,074 M12,193 M16,798 M25,489 M16,571 M39,240 M44,281 M61,271 M72,738 M72,361 M
NetIncomeCommonStockholders22,074 M12,193 M16,798 M25,489 M16,571 M39,240 M44,281 M61,271 M72,738 M72,361 M
NetIncomeContinuousOperations22,074 M12,193 M16,798 M25,489 M16,571 M39,240 M44,281 M61,271 M72,738 M72,361 M
NetNonOperatingInterestIncomeExpense61 M346 M-431 M876 M1,416 M729 M77 M-215 M31 M1,026 M
Normalized income70,556 M
Operating income27,759 M18,161 M20,182 M29,025 M35,058 M42,959 M52,959 M69,916 M83,383 M88,523 M
Operating income before depreciation (EBITDA)31,926 M23,063 M24,030 M34,857 M41,602 M50,284 M60,841 M85,134 M100,239 M105,140 M
OperatingExpense31,996 M42,381 M32,358 M33,285 M36,949 M39,974 M43,978 M45,940 M52,237 M57,529 M
Other income net-97,117 M-909 M-1,181 M-2,868 M-2,340 M-1,070 M-377 M-1,186 M-333 M-788 M
OtherGandA4,677 M4,611 M4,563 M4,481 M4,754 M4,885 M5,111 M5,107 M5,900 M7,575 M
OtherImpairmentOfCapitalAssets-55 M-47 M-161 M
OtherOperatingExpenses-31,996 M-1,091 M-1,086 M-1,412 M-1,585 M-2,106 M-2,043 M-790 M-1,145 M-1,051 M
PromotionAndAdvertising-2,300 M-1,900 M-1,600 M-1,500 M-1,600 M-1,600 M-1,600 M1,500 M1,500 M904 M
RentAndLandingFees4,677 M4,611 M4,563 M4,481 M4,754 M4,885 M5,111 M
Research & development expense11,381 M12,046 M11,988 M13,037 M14,726 M16,876 M19,269 M20,716 M24,512 M27,195 M
ResearchExpense11,381 M12,046 M11,988 M13,037 M14,726 M16,876 M19,269 M20,716 M24,512 M27,195 M
RestructringAndMnAIncome-20,234 M-2,078 M-501 M-306 M
SalariesAndWages127 M10,011 M1,110 M306 M-3,940 M-4,652 M-5,289 M-1,065 M-1,293 M-1,651 M
Selling Gen & administrative expense20,488 M20,324 M19,260 M19,942 M22,223 M23,098 M24,709 M25,224 M27,725 M30,334 M
SellingAndMarketingExpense15,811 M15,713 M14,697 M15,461 M17,469 M18,213 M19,598 M20,117 M21,825 M22,759 M
SellingExpense15,811 M15,713 M14,697 M15,461 M17,469 M18,213 M19,598 M
Special income/charges20,234 M7,498 M630 M55 M54 M
Total Income available for interest expense (EBIT)26,714 M17,106 M17,408 M26,079 M31,341 M38,602 M48,045 M73,448 M85,779 M91,279 M
Total common shares outstanding8,240 M7,998 M7,793 M7,702 M7,668 M7,635 M7,568 M7,515 M7,458 M7,430 M
Total net income22,074 M12,193 M16,798 M25,489 M16,571 M39,240 M44,281 M61,271 M72,738 M72,361 M
Total ordinary shares7,430 M7,430 M7,430 M7,430 M7,430 M7,430 M7,430 M7,430 M7,430 M7,430 M
Total revenues86,833 M93,580 M85,320 M96,571 M110,360 M125,843 M143,015 M168,088 M198,270 M211,915 M
TotalExpenses59,074 M75,419 M65,138 M67,546 M75,302 M82,884 M90,056 M98,172 M114,887 M123,392 M
TotalRevenue86,833 M93,580 M85,320 M96,571 M110,360 M125,843 M143,015 M168,088 M198,270 M211,915 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and Templates.
Get started today