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

421.43
 
USD
  
-0.22
  
(-0.05%)
Optionable: Yes  Market Cap: 3,133,043 M  90-day average vol: 22,803,568

Previous close: 421.65  Open: 424.44  Bid: 421.46  Ask: 421.61
52 week range    
275.37   
   430.82
Peers   
ORCL / 
IBM / 
GOOGL / 
HPQ / 
CSCO / 
AAPL / 
Last updated: Thursday 28th March 2024
53
MarketXLS Rank
40
Value
61
Technical
60
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 expenses8,214 M7,197 M7,478 M8,108 M10,738 M15,047 M14,660 M17,337 M23,067 M22,247 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 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 M-4,217 M-4,406 M-9,929 M-3,481 M7,303 M-8,760 M-10,184 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
DividendsPayable-2,307 M-2,475 M-2,800 M-3,003 M-12,916 M-14,101 M-15,483 M-16,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 M81,445 M77,810 M72,850 M67,249 M59,703 M58,521 M54,718 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
InterestPayable-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
Inventories2,660 M2,902 M2,251 M2,181 M2,662 M2,063 M1,895 M2,636 M3,742 M2,500 M
Invested capital131,074 M135,699 M153,111 M245,229 M232,770 M241,842 M245,131 M251,765 M272,095 M302,931 M
Land & improvements541 M769 M824 M1,107 M1,254 M1,540 M1,823 M3,660 M4,734 M5,683 M
Leases3,560 M3,577 M3,659 M5,064 M4,735 M5,316 M5,487 M6,884 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
NetOtherUnrealizedGainLoss-131 M-313 M-302 M-423 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 M431 M-2,187 M-340 M3,186 M1,822 M
Other fixed assets13,011 M14,731 M18,356 M30,289 M36,146 M43,856 M52,904 M70,803 M87,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
OtherCurrentLiabilities11,703 M11,651 M11,213 M13,503 M14,847 M16,181 M17,901 M21,723 M23,728 M25,754 M
OtherInventories2,660 M2,902 M2,251 M2,181 M2,662 M2,063 M1,895 M2,636 M3,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-301 M-335 M-426 M-345 M-377 M-411 M-788 M-751 M-633 M-650 M
Retained earnings21,418 M11,618 M3,819 M18,396 M11,495 M23,810 M37,752 M58,877 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 assets170,443 M174,472 M193,468 M250,312 M258,848 M286,556 M301,311 M333,779 M364,840 M411,976 M
Total current assets112,305 M122,797 M139,660 M162,696 M169,662 M175,552 M181,915 M184,406 M169,684 M184,257 M
Total current liabilities47,008 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 liabilities84,541 M94,389 M121,471 M162,601 M176,130 M184,226 M183,007 M191,791 M198,298 M412,000 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
TotalLiabilitiesAndTotalEquityGrossMinorityInterest174,325 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 M-603 M-554 M-511 M-471 M-438 M
Work in progress266 M202 M158 M145 M54 M53 M83 M79 M82 M23 M
Working capital65,297 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 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