Microsoft Corporation
MSFT
NGS
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
Last updated: Wednesday 27th September 2023
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started todaySearch for a stock
🎉 Exciting news! 🎉
You are invited to join our Discord Channel.
Interact, learn, and grow with experts in the markets!
Join our DiscordFinancials
MSFT Balance Sheet
Annual
| Jun-14 | Jun-15 | Jun-16 | Jun-17 | Jun-18 | Jun-19 | Jun-20 | Jun-21 | Jun-22 | Jun-23 | |
|---|---|---|---|---|---|---|---|---|---|---|
| """debtc""" | 2,000 M | 7,484 M | 12,904 M | 10,121 M | 3,998 M | 5,516 M | 3,749 M | 8,072 M | 2,749 M | 5,247 M |
| Accounts payable | 7,432 M | 6,591 M | 6,898 M | 7,390 M | 8,617 M | 9,382 M | 12,530 M | 15,163 M | 19,000 M | 18,095 M |
| Accounts receivable | 19,544 M | 17,908 M | 18,277 M | 22,431 M | 26,481 M | 29,524 M | 32,011 M | 38,043 M | 44,261 M | 48,688 M |
| Accrued expenses | 13,011 M | 12,293 M | 12,742 M | 13,927 M | 16,841 M | 21,877 M | 22,534 M | 27,394 M | 33,728 M | 33,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 & improvements | 8,867 M | 10,800 M | 12,393 M | 16,284 M | 20,604 M | 26,288 M | 33,995 M | 43,928 M | 55,014 M | 68,465 M |
| Cash and equivalents | 8,669 M | 5,595 M | 6,510 M | 7,663 M | 11,946 M | 11,356 M | 13,576 M | 14,224 M | 13,931 M | 34,704 M |
| CashCashEquivalentsAndShortTermInvestments | 85,709 M | 96,526 M | 113,240 M | 132,981 M | 133,768 M | 133,819 M | 136,527 M | 130,334 M | 104,757 M | 111,262 M |
| CashEquivalents | 8,669 M | 5,595 M | 6,510 M | 7,663 M | 11,946 M | 11,356 M | 13,576 M | 14,224 M | ||
| CommercialPaper | 2,000 M | 5,000 M | 12,900 M | 9,100 M | ||||||
| Common par | 68,366 M | 68,465 M | 68,178 M | 69,315 M | 71,223 M | 78,520 M | 80,552 M | 83,111 M | 86,939 M | 93,718 M |
| Common stock equity | 89,784 M | 80,083 M | 71,997 M | 87,711 M | 82,718 M | 102,330 M | 118,304 M | 141,988 M | 166,542 M | 206,223 M |
| CommonStock | 68,366 M | 68,465 M | 68,178 M | 69,315 M | 71,223 M | 78,520 M | 80,552 M | 83,111 M | 86,939 M | 93,718 M |
| Cost in excess | 20,127 M | 16,939 M | 17,872 M | 35,122 M | 35,683 M | 42,026 M | 43,351 M | 49,711 M | 67,524 M | 67,886 M |
| CurrentAccruedExpenses | 4,797 M | 5,096 M | 5,264 M | 5,819 M | 6,103 M | 6,830 M | 7,874 M | 10,057 M | 10,661 M | 11,009 M |
| CurrentCapitalLeaseObligation | 2,538 M | 4,301 M | 6,574 M | 9,496 M | 12,541 M | 14,902 M | 20,634 M | |||
| CurrentDeferredRevenue | 23,150 M | 23,223 M | 27,468 M | 24,013 M | 28,905 M | 32,676 M | 36,000 M | 41,525 M | 45,538 M | 50,901 M |
| CurrentDeferredTaxesAssets | 2,890 M | 3,150 M | 3,149 M | 4,443 M | 4,309 M | 12,479 M | 14,961 M | 17,167 M | 22,559 M | 29,911 M |
| CurrentDeferredTaxesLiabilities | 1,941 M | 1,280 M | 1,257 M | 5,760 M | 828 M | 7,303 M | 6,201 M | 6,983 M | 13,285 M | 19,730 M |
| Deferred revenues | 25,091 M | 23,223 M | 27,468 M | 24,013 M | 28,905 M | 32,676 M | 36,000 M | 41,525 M | 45,538 M | 50,901 M |
| Deposits | 558 M | 92 M | 294 M | 97 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 goods | 1,450 M | 1,600 M | 1,481 M | 1,239 M | 1,953 M | 1,611 M | 1,112 M | 1,367 M | 2,516 M | 1,768 M |
| Float term debt | 20,645 M | 27,808 M | 40,557 M | 76,073 M | 72,242 M | 66,662 M | 59,578 M | 50,074 M | 55,511 M | 52,866 M |
| GoodwillAndOtherIntangibleAssets | 27,108 M | 21,774 M | 21,605 M | 45,228 M | 43,736 M | 49,776 M | 50,389 M | 57,511 M | 78,822 M | 77,252 M |
| Gross fixed assets (Plant Property & Equipment) | 27,804 M | 32,337 M | 38,156 M | 54,468 M | 65,369 M | 79,186 M | 96,101 M | 122,154 M | 147,206 M | 178,238 M |
| IncomeTaxPayable | 782 M | 606 M | 580 M | 718 M | 2,121 M | 5,665 M | 2,130 M | 2,174 M | 4,067 M | 4,152 M |
| Intangibles | 6,981 M | 4,835 M | 3,733 M | 10,106 M | 8,053 M | 7,750 M | 7,038 M | 7,800 M | 11,298 M | 9,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 |
| Inventories | 2,660 M | 2,902 M | 2,251 M | 2,181 M | 2,662 M | 2,063 M | 1,895 M | 2,636 M | 3,742 M | 2,500 M |
| Invested capital | 110,429 M | 107,891 M | 112,554 M | 163,784 M | 154,960 M | 168,992 M | 177,882 M | 192,062 M | 269,085 M | 301,079 M |
| Land & improvements | 3,560 M | 3,577 M | 3,659 M | 5,064 M | 4,735 M | 5,316 M | 5,487 M | 6,884 M | 4,734 M | 5,683 M |
| Leases | 865 M | 2,700 M | 7,819 M | 8,537 M | ||||||
| LongTermCapitalLeaseObligation | 5,372 M | 5,568 M | 6,188 M | 7,671 M | 9,629 M | 11,489 M | 12,728 M | |||
| LongTermDebtAndCapitalLeaseObligation | 20,645 M | 27,808 M | 40,557 M | 81,445 M | 77,810 M | 72,850 M | 67,249 M | 59,703 M | 58,521 M | 54,718 M |
| Machinery furniture & equipment | 3,406 M | 3,579 M | 3,889 M | 4,044 M | 4,457 M | 4,840 M | 4,782 M | 5,344 M | 5,860 M | 6,246 M |
| Net fixed assets (net PP&E) | 13,011 M | 14,731 M | 18,356 M | 30,289 M | 36,146 M | 43,856 M | 52,904 M | 70,803 M | 87,546 M | 109,987 M |
| NetOtherUnrealizedGainLoss | 131 M | 313 M | 302 M | 423 M | 1,257 M | |||||
| Non-current deferred income taxes | 2,728 M | 1,295 M | 1,476 M | 5,734 M | 541 M | 233 M | 204 M | 198 M | 230 M | 433 M |
| NonCurrentAccountsReceivable | 1,700 M | 1,800 M | 2,200 M | 2,700 M | 3,400 M | 3,800 M | 4,500 M | |||
| NonCurrentAccruedExpenses | 10,510 M | 12,100 M | 11,800 M | 13,485 M | 30,265 M | 29,612 M | 29,432 M | 27,190 M | 26,069 M | 25,560 M |
| NonCurrentDeferredLiabilities | 4,736 M | 3,390 M | 7,917 M | 8,377 M | 4,356 M | 4,763 M | 3,384 M | 2,814 M | 3,100 M | 3,345 M |
| NonCurrentDeferredRevenue | 2,008 M | 2,095 M | 6,441 M | 2,643 M | 3,815 M | 4,530 M | 3,180 M | 2,616 M | 2,870 M | 2,912 M |
| NonCurrentDeferredTaxesAssets | 3,793 M | 5,415 M | 7,878 M | 7,753 M | 7,495 M | 15,693 M | 15,716 M | 17,936 M | 23,571 M | 30,850 M |
| Number of employees | 221000.0 | 221000.0 | 221000.0 | 221000.0 | 221000.0 | 221000.0 | 221000.0 | 221000.0 | 221000.0 | 221000.0 |
| Other current assets | 4,392 M | 5,461 M | 5,892 M | 5,103 M | 6,751 M | 10,146 M | 11,482 M | 13,393 M | 16,924 M | 21,807 M |
| Other equity adjustments | 3,708 M | 2,522 M | 1,537 M | 627 M | -2,187 M | -340 M | 3,186 M | 1,822 M | ||
| Other fixed assets | 87,546 M | 109,987 M | ||||||||
| Other non-current assets | 3,422 M | 3,117 M | 3,416 M | 6,076 M | 7,442 M | 14,723 M | 13,138 M | 15,075 M | 21,897 M | 30,601 M |
| Other non-current liabilities | 11,594 M | 13,544 M | 13,640 M | 3,549 M | 5,211 M | 7,581 M | 10,632 M | 13,427 M | 15,526 M | 17,981 M |
| Other receivable | 96,571 M | 110,360 M | 125,843 M | 143,015 M | 168,088 M | 198,270 M | 211,915 M | |||
| OtherCurrentBorrowings | 2,000 M | 4,985 M | 12,904 M | 9,072 M | ||||||
| OtherCurrentLiabilities | 6,906 M | 6,555 M | 5,949 M | 7,684 M | 8,744 M | 9,351 M | 10,027 M | 11,666 M | 13,067 M | 14,745 M |
| OtherInventories | 3,742 M | 2,500 M | ||||||||
| Payables | 8,214 M | 7,197 M | 7,478 M | 8,108 M | 10,738 M | 15,047 M | 14,660 M | 17,337 M | 23,067 M | 22,247 M |
| Raw materials | 944 M | 1,100 M | 612 M | 797 M | 655 M | 399 M | 700 M | 1,190 M | 1,144 M | 709 M |
| RecievablesAdjustmentsAllowances | -411 M | -788 M | -633 M | -650 M | ||||||
| Retained earnings | 17,710 M | 9,096 M | 2,282 M | 17,769 M | 13,682 M | 24,150 M | 34,566 M | 57,055 M | 79,603 M | 112,505 M |
| SecuritySoldNotYetRepurchased | 92 M | 294 M | ||||||||
| Short term debt | 2,000 M | 7,484 M | 12,904 M | 10,121 M | 3,998 M | 5,516 M | 3,749 M | 8,072 M | 2,749 M | 5,247 M |
| Total assets | 172,384 M | 174,472 M | 193,468 M | 250,312 M | 258,848 M | 286,556 M | 301,311 M | 333,779 M | 364,840 M | 411,976 M |
| Total current assets | 114,246 M | 122,797 M | 139,660 M | 162,696 M | 169,662 M | 175,552 M | 181,915 M | 184,406 M | 169,684 M | 184,257 M |
| Total current liabilities | 45,625 M | 49,555 M | 59,063 M | 55,745 M | 58,488 M | 69,420 M | 72,310 M | 88,657 M | 95,082 M | 104,149 M |
| Total equity | 89,784 M | 80,083 M | 71,997 M | 87,711 M | 82,718 M | 102,330 M | 118,304 M | 141,988 M | 166,542 M | 206,223 M |
| Total liabilities | 82,600 M | 94,389 M | 121,471 M | 162,601 M | 176,130 M | 184,226 M | 183,007 M | 191,791 M | 198,298 M | 205,753 M |
| Total non-current assets | 58,138 M | 51,675 M | 53,808 M | 87,616 M | 89,186 M | 111,004 M | 119,396 M | 149,373 M | 195,156 M | 227,719 M |
| Total non-current liabilities | 37,533 M | 44,834 M | 62,408 M | 106,856 M | 117,642 M | 114,806 M | 110,697 M | 103,134 M | 103,216 M | 101,604 M |
| TotalEquityGrossMinority | 89,784 M | 80,083 M | 71,997 M | 87,711 M | 82,718 M | 102,330 M | 118,304 M | 141,988 M | 166,542 M | 206,223 M |
| TotalEquityGrossMinorityInterest | 89,784 M | 80,083 M | 71,997 M | 87,711 M | 82,718 M | 102,330 M | 118,304 M | 141,988 M | 166,542 M | 206,223 M |
| TotalLiabilitiesAndTotalEquityGrossMinorityInterest | 172,384 M | 174,472 M | 193,468 M | 250,312 M | 258,848 M | 286,556 M | 301,311 M | 333,779 M | 364,840 M | 411,976 M |
| TotalNonCurrentLiabilitiesNetMinorityInteres | 37,533 M | 44,834 M | 62,408 M | 106,856 M | 117,642 M | 114,806 M | 110,697 M | 103,134 M | 103,216 M | 101,604 M |
| TotalTaxPayable | 782 M | 606 M | 580 M | 718 M | 2,121 M | 5,665 M | 2,130 M | 2,174 M | 4,067 M | 4,152 M |
| UnearnedPremiums | 392 M | 715 M | 658 M | 603 M | 554 M | 511 M | -471 M | -438 M | ||
| Work in progress | 266 M | 202 M | 158 M | 145 M | 54 M | 53 M | 83 M | 79 M | 82 M | 23 M |
| Working capital | 68,621 M | 73,242 M | 80,597 M | 106,951 M | 111,174 M | 106,132 M | 109,605 M | 95,749 M | 74,602 M | 80,108 M |
| ltinv | 14,597 M | 12,053 M | 10,431 M | 6,023 M | 1,862 M | 2,649 M | 2,965 M | 5,984 M | 6,891 M | 9,879 M |
Call: 1-877-778-8358
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
Get started today