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.14
 
USD
  
-5.40
  
(-1.70%)
Optionable: Yes  Market Cap: 2,441,792 M  90-day average vol: 24,616,717

Previous close: 317.54  Open: 315.13  Bid: 312.04  Ask: 312.14
52 week range    
213.43   
   366.78
Peers   
ORCL / 
IBM / 
GOOGL / 
HPQ / 
CSCO / 
AAPL / 
Last updated: Wednesday 27th September 2023
60
MarketXLS Rank
70
Value
53
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

MSFT Balance Sheet

Annual
Jun-14Jun-15Jun-16Jun-17Jun-18Jun-19Jun-20Jun-21Jun-22Jun-23
"""debtc"""2,000 M7,484 M12,904 M10,121 M3,998 M5,516 M3,749 M8,072 M2,749 M5,247 M
Accounts payable7,432 M6,591 M6,898 M7,390 M8,617 M9,382 M12,530 M15,163 M19,000 M18,095 M
Accounts receivable19,544 M17,908 M18,277 M22,431 M26,481 M29,524 M32,011 M38,043 M44,261 M48,688 M
Accrued expenses13,011 M12,293 M12,742 M13,927 M16,841 M21,877 M22,534 M27,394 M33,728 M33,256 M
Accumulated depreciation & depletion-14,793 M-17,606 M-19,800 M-24,179 M-29,223 M-35,330 M-43,197 M-51,351 M-59,660 M-68,251 M
Building & improvements8,867 M10,800 M12,393 M16,284 M20,604 M26,288 M33,995 M43,928 M55,014 M68,465 M
Cash and equivalents8,669 M5,595 M6,510 M7,663 M11,946 M11,356 M13,576 M14,224 M13,931 M34,704 M
CashCashEquivalentsAndShortTermInvestments85,709 M96,526 M113,240 M132,981 M133,768 M133,819 M136,527 M130,334 M104,757 M111,262 M
CashEquivalents8,669 M5,595 M6,510 M7,663 M11,946 M11,356 M13,576 M14,224 M
CommercialPaper2,000 M5,000 M12,900 M9,100 M
Common par68,366 M68,465 M68,178 M69,315 M71,223 M78,520 M80,552 M83,111 M86,939 M93,718 M
Common stock equity89,784 M80,083 M71,997 M87,711 M82,718 M102,330 M118,304 M141,988 M166,542 M206,223 M
CommonStock68,366 M68,465 M68,178 M69,315 M71,223 M78,520 M80,552 M83,111 M86,939 M93,718 M
Cost in excess20,127 M16,939 M17,872 M35,122 M35,683 M42,026 M43,351 M49,711 M67,524 M67,886 M
CurrentAccruedExpenses4,797 M5,096 M5,264 M5,819 M6,103 M6,830 M7,874 M10,057 M10,661 M11,009 M
CurrentCapitalLeaseObligation2,538 M4,301 M6,574 M9,496 M12,541 M14,902 M20,634 M
CurrentDeferredRevenue23,150 M23,223 M27,468 M24,013 M28,905 M32,676 M36,000 M41,525 M45,538 M50,901 M
CurrentDeferredTaxesAssets2,890 M3,150 M3,149 M4,443 M4,309 M12,479 M14,961 M17,167 M22,559 M29,911 M
CurrentDeferredTaxesLiabilities1,941 M1,280 M1,257 M5,760 M828 M7,303 M6,201 M6,983 M13,285 M19,730 M
Deferred revenues25,091 M23,223 M27,468 M24,013 M28,905 M32,676 M36,000 M41,525 M45,538 M50,901 M
Deposits558 M92 M294 M97 M
DividendsPayable2,307 M2,475 M2,800 M3,003 M12,916 M14,101 M15,483 M16,871 M-18,550 M-20,233 M
Finished goods1,450 M1,600 M1,481 M1,239 M1,953 M1,611 M1,112 M1,367 M2,516 M1,768 M
Float term debt20,645 M27,808 M40,557 M76,073 M72,242 M66,662 M59,578 M50,074 M55,511 M52,866 M
GoodwillAndOtherIntangibleAssets27,108 M21,774 M21,605 M45,228 M43,736 M49,776 M50,389 M57,511 M78,822 M77,252 M
Gross fixed assets (Plant Property & Equipment)27,804 M32,337 M38,156 M54,468 M65,369 M79,186 M96,101 M122,154 M147,206 M178,238 M
IncomeTaxPayable782 M606 M580 M718 M2,121 M5,665 M2,130 M2,174 M4,067 M4,152 M
Intangibles6,981 M4,835 M3,733 M10,106 M8,053 M7,750 M7,038 M7,800 M11,298 M9,366 M
InterestPayable597 M781 M1,243 M2,222 M2,733 M2,686 M2,591 M2,346 M-2,063 M-1,968 M
Inventories2,660 M2,902 M2,251 M2,181 M2,662 M2,063 M1,895 M2,636 M3,742 M2,500 M
Invested capital110,429 M107,891 M112,554 M163,784 M154,960 M168,992 M177,882 M192,062 M269,085 M301,079 M
Land & improvements3,560 M3,577 M3,659 M5,064 M4,735 M5,316 M5,487 M6,884 M4,734 M5,683 M
Leases865 M2,700 M7,819 M8,537 M
LongTermCapitalLeaseObligation5,372 M5,568 M6,188 M7,671 M9,629 M11,489 M12,728 M
LongTermDebtAndCapitalLeaseObligation20,645 M27,808 M40,557 M81,445 M77,810 M72,850 M67,249 M59,703 M58,521 M54,718 M
Machinery furniture & equipment3,406 M3,579 M3,889 M4,044 M4,457 M4,840 M4,782 M5,344 M5,860 M6,246 M
Net fixed assets (net PP&E)13,011 M14,731 M18,356 M30,289 M36,146 M43,856 M52,904 M70,803 M87,546 M109,987 M
NetOtherUnrealizedGainLoss131 M313 M302 M423 M1,257 M
Non-current deferred income taxes2,728 M1,295 M1,476 M5,734 M541 M233 M204 M198 M230 M433 M
NonCurrentAccountsReceivable1,700 M1,800 M2,200 M2,700 M3,400 M3,800 M4,500 M
NonCurrentAccruedExpenses10,510 M12,100 M11,800 M13,485 M30,265 M29,612 M29,432 M27,190 M26,069 M25,560 M
NonCurrentDeferredLiabilities4,736 M3,390 M7,917 M8,377 M4,356 M4,763 M3,384 M2,814 M3,100 M3,345 M
NonCurrentDeferredRevenue2,008 M2,095 M6,441 M2,643 M3,815 M4,530 M3,180 M2,616 M2,870 M2,912 M
NonCurrentDeferredTaxesAssets3,793 M5,415 M7,878 M7,753 M7,495 M15,693 M15,716 M17,936 M23,571 M30,850 M
Number of employees221000.0221000.0221000.0221000.0221000.0221000.0221000.0221000.0221000.0221000.0
Other current assets4,392 M5,461 M5,892 M5,103 M6,751 M10,146 M11,482 M13,393 M16,924 M21,807 M
Other equity adjustments3,708 M2,522 M1,537 M627 M-2,187 M-340 M3,186 M1,822 M
Other fixed assets87,546 M109,987 M
Other non-current assets3,422 M3,117 M3,416 M6,076 M7,442 M14,723 M13,138 M15,075 M21,897 M30,601 M
Other non-current liabilities11,594 M13,544 M13,640 M3,549 M5,211 M7,581 M10,632 M13,427 M15,526 M17,981 M
Other receivable96,571 M110,360 M125,843 M143,015 M168,088 M198,270 M211,915 M
OtherCurrentBorrowings2,000 M4,985 M12,904 M9,072 M
OtherCurrentLiabilities6,906 M6,555 M5,949 M7,684 M8,744 M9,351 M10,027 M11,666 M13,067 M14,745 M
OtherInventories3,742 M2,500 M
Payables8,214 M7,197 M7,478 M8,108 M10,738 M15,047 M14,660 M17,337 M23,067 M22,247 M
Raw materials944 M1,100 M612 M797 M655 M399 M700 M1,190 M1,144 M709 M
RecievablesAdjustmentsAllowances-411 M-788 M-633 M-650 M
Retained earnings17,710 M9,096 M2,282 M17,769 M13,682 M24,150 M34,566 M57,055 M79,603 M112,505 M
SecuritySoldNotYetRepurchased92 M294 M
Short term debt2,000 M7,484 M12,904 M10,121 M3,998 M5,516 M3,749 M8,072 M2,749 M5,247 M
Total assets172,384 M174,472 M193,468 M250,312 M258,848 M286,556 M301,311 M333,779 M364,840 M411,976 M
Total current assets114,246 M122,797 M139,660 M162,696 M169,662 M175,552 M181,915 M184,406 M169,684 M184,257 M
Total current liabilities45,625 M49,555 M59,063 M55,745 M58,488 M69,420 M72,310 M88,657 M95,082 M104,149 M
Total equity89,784 M80,083 M71,997 M87,711 M82,718 M102,330 M118,304 M141,988 M166,542 M206,223 M
Total liabilities82,600 M94,389 M121,471 M162,601 M176,130 M184,226 M183,007 M191,791 M198,298 M205,753 M
Total non-current assets58,138 M51,675 M53,808 M87,616 M89,186 M111,004 M119,396 M149,373 M195,156 M227,719 M
Total non-current liabilities37,533 M44,834 M62,408 M106,856 M117,642 M114,806 M110,697 M103,134 M103,216 M101,604 M
TotalEquityGrossMinority89,784 M80,083 M71,997 M87,711 M82,718 M102,330 M118,304 M141,988 M166,542 M206,223 M
TotalEquityGrossMinorityInterest89,784 M80,083 M71,997 M87,711 M82,718 M102,330 M118,304 M141,988 M166,542 M206,223 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest172,384 M174,472 M193,468 M250,312 M258,848 M286,556 M301,311 M333,779 M364,840 M411,976 M
TotalNonCurrentLiabilitiesNetMinorityInteres37,533 M44,834 M62,408 M106,856 M117,642 M114,806 M110,697 M103,134 M103,216 M101,604 M
TotalTaxPayable782 M606 M580 M718 M2,121 M5,665 M2,130 M2,174 M4,067 M4,152 M
UnearnedPremiums392 M715 M658 M603 M554 M511 M-471 M-438 M
Work in progress266 M202 M158 M145 M54 M53 M83 M79 M82 M23 M
Working capital68,621 M73,242 M80,597 M106,951 M111,174 M106,132 M109,605 M95,749 M74,602 M80,108 M
ltinv14,597 M12,053 M10,431 M6,023 M1,862 M2,649 M2,965 M5,984 M6,891 M9,879 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