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

437.11
 
USD
  
-3.26
  
(-0.74%)
Optionable: Yes  Market Cap: 3,340,970 M  90-day average vol: 18,606,178

Previous close: 440.37  Open: 433.1  Bid: 436.32  Ask: 436.8
52 week range    
309.45   
   468.35
Last updated: Monday 22nd July 2024
58
MarketXLS Rank
50
Value
61
Technical
65
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

MSFT Income Statement

Annual
Jun-14Jun-15Jun-16Jun-17Jun-18Jun-19Jun-20Jun-21Jun-22Jun-23
Amortization of intangibles-200 M16,939 M17,872 M35,122 M35,683 M42,026 M43,351 M49,711 M67,524 M67,886 M
Basic EPS from continuing operations2.661.492.122.742.155.115.828.129.79.72
Basic EPS total2.661.492.122.742.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
Depreciation3,400 M4,100 M4,900 M6,100 M7,700 M9,700 M10,700 M9,300 M12,600 M11,000 M
DepreciationAndAmortization3,400 M4,100 M4,900 M6,100 M7,700 M9,700 M10,700 M9,300 M12,600 M11,000 M
Diluted EPS total2.631.482.12.712.135.065.768.059.659.68
Diluted normalized net income/share2.631.482.12.712.135.065.768.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
GainOnSaleOfSecurity883 M1,176 M1,376 M3,064 M3,406 M2,762 M2,680 M2,131 M2,094 M2,994 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
ImpairmentOfCapitalAssets7,498 M630 M55 M54 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 M2,078 M-21 M306 M
Income taxes5,746 M6,314 M2,953 M4,412 M19,903 M4,448 M8,755 M9,831 M10,978 M16,950 M
InterestExpenseNonOperating597 M781 M1,243 M2,222 M2,733 M2,686 M2,591 M2,346 M2,063 M1,968 M
MiscOtherSpecialCharges61 M346 M-431 M876 M1,416 M729 M77 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,328 M43,843 M33,918 M26,101 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
NetNonOperatingInterestIncomeExpense-597 M-781 M-1,243 M-2,222 M-2,733 M-2,686 M-2,591 M-2,346 M-2,063 M-1,968 M
NonRecurringOperationExpense33,038 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)33,629 M25,245 M27,616 M40,901 M49,468 M58,056 M68,423 M85,134 M100,239 M105,140 M
OperatingExpense31,742 M22,359 M30,138 M32,673 M36,949 M39,974 M43,978 M45,940 M52,237 M57,529 M
Other income net27,017 M-346 M431 M-876 M-1,416 M-729 M-77 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
OtherImpairmentOfCapitalAssets27,078 M55 M47 M161 M
OtherOperatingExpenses-566 M-1,091 M-1,086 M-1,277 M-1,445 M-2,106 M-647 M-790 M-1,145 M-1,051 M
PromotionAndAdvertising2,300 M1,900 M1,600 M1,500 M1,600 M1,600 M1,600 M1,500 M1,500 M904 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 M2,078 M-21 M306 M
Revenue per share-200 M16,939 M17,872 M35,226 M35,926 M42,396 M43,962 M50,632 M68,504 M69,238 M
SalariesAndWages-127 M-10,011 M-1,110 M-306 M-823 M-816 M-938 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
Special income/charges20,234 M-7,498 M-630 M-55 M-54 M
Total Income available for interest expense (EBIT)28,417 M19,288 M20,994 M32,123 M39,207 M46,374 M55,627 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,432 M7,432 M7,432 M7,432 M7,432 M7,432 M7,432 M7,432 M7,432 M7,432 M
Total revenues86,833 M93,580 M85,320 M96,571 M110,360 M125,843 M143,015 M168,088 M198,270 M211,915 M
TotalExpenses58,820 M55,397 M62,918 M66,934 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 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