Microsoft Excel LibreOffice Calc

Microsoft Corp. (NASDAQ:MSFT)


Balance Sheet: Assets
Quarterly Data

Beginner level

The balance sheet provides creditors, investors, and analysts with information on company’s resources (assets) and its sources of capital (its equity and liabilities). It normally also provides information about the future earnings capacity of a company’s assets as well as an indication of cash flows that may come from receivables and inventories.

Assets are resources controlled by the company as a result of past events and from which future economic benefits are expected to flow to the entity.

Microsoft Corp., consolidated balance sheet: assets (quarterly data)

US$ in millions

Microsoft Excel LibreOffice Calc
Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013
Cash and cash equivalents 11,710  8,864  13,117  11,356  11,212  6,638  15,137  11,946  9,221  12,859  6,884  7,663  6,713  8,468  13,928  6,510  7,170  7,185  5,431  5,595  7,414  6,426  6,302  8,669  11,572  10,059  4,023 
Short-term investments 125,916  125,389  123,519  122,463  120,406  121,024  120,743  121,822  123,049  129,921  131,587  125,318  119,305  114,313  123,004  106,730  98,382  95,455  93,924  90,931  88,024  83,823  82,891  77,040  76,853  73,885  76,649 
Cash, cash equivalents, and short-term investments 137,626  134,253  136,636  133,819  131,618  127,662  135,880  133,768  132,270  142,780  138,471  132,981  126,018  122,781  136,932  113,240  105,552  102,640  99,355  96,526  95,438  90,249  89,193  85,709  88,425  83,944  80,672 
Accounts receivable, net of allowance for doubtful accounts 22,699  23,525  19,087  29,524  19,269  19,680  17,390  26,481  17,208  18,428  14,561  19,792  12,882  14,343  11,129  18,277  12,247  14,507  11,444  17,908  12,427  16,186  12,887  19,544  13,497  15,986  11,007 
Inventories 1,644  1,823  2,622  2,063  1,951  1,961  3,614  2,662  2,084  2,003  3,211  2,181  1,979  1,961  3,122  2,251  2,450  2,702  3,816  2,902  2,469  2,053  3,141  2,660  1,920  1,594  2,613 
Deferred income taxes —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  1,574  1,618  1,447  1,915  1,688  1,701  1,784  1,941  1,424  1,328  1,258 
Other current assets 8,536  7,473  7,551  10,146  7,049  7,571  7,311  6,751  5,097  4,422  4,788  4,897  5,434  5,864  6,726  5,892  6,598  6,345  5,594  5,461  6,376  6,173  5,434  4,392  3,740  4,018  3,900 
Current assets 170,505  167,074  165,896  175,552  159,887  156,874  164,195  169,662  156,659  167,633  161,031  159,851  146,313  144,949  157,909  139,660  128,421  127,812  121,656  124,712  118,398  116,362  112,439  114,246  109,006  106,870  99,450 
Property and equipment, net of accumulated depreciation 41,221  40,522  38,409  36,477  33,648  32,717  31,430  29,460  27,929  26,304  24,809  23,734  21,962  21,379  19,224  18,356  16,831  15,789  15,046  14,731  14,375  13,607  13,229  13,011  11,771  11,567  10,774 
Operating lease right-of-use assets 8,448  8,439  7,890  7,379  7,121  6,806  6,734  6,686  6,859  6,749  6,844  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Equity investments 2,660  2,755  2,684  2,649  2,403  2,274  2,034  1,862  2,818  3,961  5,343  6,023  7,381  8,912  10,486  10,431  11,315  11,514  11,438  12,053  12,019  12,665  13,943  14,597  14,792  14,607  11,995 
Goodwill 42,064  42,248  42,113  42,026  41,861  41,577  35,855  35,683  35,582  35,355  35,389  35,122  34,668  34,524  17,907  17,872  17,948  17,436  17,142  16,939  21,728  21,855  20,081  20,127  14,751  14,680  14,667 
Intangible assets, net 6,855  7,126  7,508  7,750  8,103  8,482  7,579  8,053  8,544  9,034  9,598  10,106  10,547  11,001  3,522  3,733  4,459  4,619  4,745  4,835  6,963  7,299  6,693  6,981  2,901  2,945  2,982 
Other long-term assets 13,696  14,630  14,455  14,723  10,258  10,129  9,792  7,442  7,106  6,967  6,083  6,250  4,146  3,845  3,476  3,642  2,895  2,928  2,869  2,953  3,200  3,060  3,271  3,422  2,898  2,874  2,480 
Long-term assets 114,944  115,720  113,059  111,004  103,394  101,985  93,424  89,186  88,838  88,370  88,066  81,235  78,704  79,661  54,615  54,034  53,448  52,286  51,240  51,511  58,285  58,486  57,217  58,138  47,113  46,673  42,898 
Total assets 285,449  282,794  278,955  286,556  263,281  258,859  257,619  258,848  245,497  256,003  249,097  241,086  225,017  224,610  212,524  193,694  181,869  180,098  172,896  176,223  176,683  174,848  169,656  172,384  156,119  153,543  142,348 

Based on: 10-Q (filing date: 2020-04-29), 10-Q (filing date: 2020-01-29), 10-Q (filing date: 2019-10-23), 10-K (filing date: 2019-08-01), 10-Q (filing date: 2019-04-24), 10-Q (filing date: 2019-01-30), 10-Q (filing date: 2018-10-24), 10-K (filing date: 2018-08-03), 10-Q (filing date: 2018-04-26), 10-Q (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-K (filing date: 2017-08-02), 10-Q (filing date: 2017-04-27), 10-Q (filing date: 2017-01-26), 10-Q (filing date: 2016-10-20), 10-K (filing date: 2016-07-28), 10-Q (filing date: 2016-04-21), 10-Q (filing date: 2016-01-28), 10-Q (filing date: 2015-10-22), 10-K (filing date: 2015-07-31), 10-Q (filing date: 2015-04-23), 10-Q (filing date: 2015-01-26), 10-Q (filing date: 2014-10-23), 10-K (filing date: 2014-07-31), 10-Q (filing date: 2014-04-24), 10-Q (filing date: 2014-01-23), 10-Q (filing date: 2013-10-24).


Assets: Selected Items

Balance sheet item Description The company
Current assets Sum of the carrying amounts as of the balance sheet date of all assets that are expected to be realized in cash, sold, or consumed within one year (or the normal operating cycle, if longer). Assets are probable future economic benefits obtained or controlled by an entity as a result of past transactions or events. Microsoft Corp.’s current assets increased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Property and equipment, net of accumulated depreciation Amount after accumulated depreciation, depletion and amortization of physical assets used in the normal conduct of business to produce goods and services and not intended for resale. Examples include, but are not limited to, land, buildings, machinery and equipment, office equipment, and furniture and fixtures. Microsoft Corp.’s property and equipment, net of accumulated depreciation increased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Long-term assets Sum of the carrying amounts as of the balance sheet date of all assets that are expected to be realized in cash, sold or consumed after one year or beyond the normal operating cycle, if longer. Microsoft Corp.’s long-term assets increased from Q1 2020 to Q2 2020 but then slightly decreased from Q2 2020 to Q3 2020.
Total assets Sum of the carrying amounts as of the balance sheet date of all assets that are recognized. Assets are probable future economic benefits obtained or controlled by an entity as a result of past transactions or events. Microsoft Corp.’s total assets increased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Current Assets: Selected Items

Balance sheet item Description The company
Cash and cash equivalents Amount of currency on hand as well as demand deposits with banks or financial institutions. Includes other kinds of accounts that have the general characteristics of demand deposits. Also includes short-term, highly liquid investments that are both readily convertible to known amounts of cash and so near their maturity that they present insignificant risk of changes in value because of changes in interest rates. Excludes cash and cash equivalents within disposal group and discontinued operation. Microsoft Corp.’s cash and cash equivalents decreased from Q1 2020 to Q2 2020 but then increased from Q2 2020 to Q3 2020 not reaching Q1 2020 level.
Short-term investments Amount of investments including trading securities, available-for-sale securities, held-to-maturity securities, and short-term investments classified as other and current. Microsoft Corp.’s short-term investments increased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Accounts receivable, net of allowance for doubtful accounts Amount due from customers or clients, within one year of the balance sheet date (or the normal operating cycle, whichever is longer), for goods or services (including trade receivables) that have been delivered or sold in the normal course of business, reduced to the estimated net realizable fair value by an allowance established by the entity of the amount it deems uncertain of collection. Microsoft Corp.’s accounts receivable, net of allowance for doubtful accounts increased from Q1 2020 to Q2 2020 but then slightly decreased from Q2 2020 to Q3 2020.
Inventories Amount after valuation and LIFO reserves of inventory expected to be sold, or consumed within one year or operating cycle, if longer. Microsoft Corp.’s inventories decreased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.