Stock Analysis on Net
Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

Cash Flow Statement

The cash flow statement provides information about a company’s cash receipts and cash payments during an accounting period, showing how these cash flows link the ending cash balance to the beginning balance shown on the company’s balance sheet.

The cash flow statement consists of three parts: cash flows provided by (used in) operating activities, cash flows provided by (used in) investing activities, and cash flows provided by (used in) financing activities.

Microsoft Corp., consolidated cash flow statement

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended: Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016
Net income 61,271  44,281  39,240  16,571  21,204  16,798 
Asset impairments —  —  —  —  —  630 
Depreciation, amortization, and other 11,686  12,796  11,682  10,261  8,778  6,622 
Stock-based compensation expense 6,118  5,289  4,652  3,940  3,266  2,668 
Net recognized gains on investments and derivatives (1,249) (219) (792) (2,212) (2,073) (223)
Deferred income taxes (150) 11  (6,463) (5,143) (3,296) 332 
Deferral of unearned revenue —  —  —  —  67,711  57,072 
Recognition of unearned revenue —  —  —  —  (57,735) (48,498)
Accounts receivable (6,481) (2,577) (2,812) (3,862) (925) (530)
Inventories (737) 168  597  (465) 50  600 
Other current assets (932) (2,330) (1,718) (952) 1,066  (1,167)
Other long-term assets (3,459) (1,037) (1,834) (285) (539) (41)
Accounts payable 2,798  3,018  232  1,148  81  88 
Unearned revenue 4,633  2,212  4,462  5,922  —  — 
Income taxes (2,309) (3,631) 2,929  18,183  —  — 
Other current liabilities 4,149  1,346  1,419  798  386  (260)
Other long-term liabilities 1,402  1,348  591  (20) 1,533  (766)
Changes in operating assets and liabilities (936) (1,483) 3,866  20,467  1,652  (2,076)
Adjustments to reconcile net income to net cash from operations 15,469  16,394  12,945  27,313  18,303  16,527 
Net cash from operations 76,740  60,675  52,185  43,884  39,507  33,325 
Proceeds from issuance (repayments) of short-term debt, maturities of 90 days or less, net —  —  —  (7,324) (4,963) 7,195 
Proceeds from issuance of debt —  —  —  7,183  44,344  13,884 
Cash premium on debt exchange (1,754) (3,417) —  —  —  — 
Repayments of debt (3,750) (5,518) (4,000) (10,060) (7,922) (2,796)
Common stock issued 1,693  1,343  1,142  1,002  772  668 
Common stock repurchased (27,385) (22,968) (19,543) (10,721) (11,788) (15,969)
Common stock cash dividends paid (16,521) (15,137) (13,811) (12,699) (11,845) (11,006)
Other, net (769) (334) (675) (971) (190) (369)
Net cash from (used in) financing (48,486) (46,031) (36,887) (33,590) 8,408  (8,393)
Additions to property and equipment (20,622) (15,441) (13,925) (11,632) (8,129) (8,343)
Acquisition of companies, net of cash acquired, and purchases of intangible and other assets (8,909) (2,521) (2,388) (888) (25,944) (1,393)
Purchases of investments (62,924) (77,190) (57,697) (137,380) (176,905) (129,758)
Maturities of investments 51,792  66,449  20,043  26,360  28,044  22,054 
Sales of investments 14,008  17,721  38,194  117,577  136,350  93,287 
Other, net (922) (1,241) —  (98) (197) 203 
Net cash used in investing (27,577) (12,223) (15,773) (6,061) (46,781) (23,950)
Effect of foreign exchange rates on cash and cash equivalents (29) (201) (115) 50  19  (67)
Net change in cash and cash equivalents 648  2,220  (590) 4,283  1,153  915 
Cash and cash equivalents, beginning of period 13,576  11,356  11,946  7,663  6,510  5,595 
Cash and cash equivalents, end of period 14,224  13,576  11,356  11,946  7,663  6,510 

Based on: 10-K (filing date: 2021-07-29), 10-K (filing date: 2020-07-31), 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28).

Cash flow statement item Description The company
Net cash from operations Amount of cash inflow (outflow) from operating activities, excluding discontinued operations. Operating activity cash flows include transactions, adjustments, and changes in value not defined as investing or financing activities. Microsoft Corp.’s net cash from operations increased from 2019 to 2020 and from 2020 to 2021.
Net cash from (used in) financing Amount of cash inflow (outflow) of financing activities, excluding discontinued operations. Financing activity cash flows include obtaining resources from owners and providing them with a return on, and a return of, their investment; borrowing money and repaying amounts borrowed, or settling the obligation; and obtaining and paying for other resources obtained from creditors on long-term credit. Microsoft Corp.’s net cash from (used in) financing decreased from 2019 to 2020 and from 2020 to 2021.
Net cash used in investing Amount of cash inflow (outflow) of investing activities, excluding discontinued operations. Investing activity cash flows include making and collecting loans and acquiring and disposing of debt or equity instruments and property, plant, and equipment and other productive assets. Microsoft Corp.’s net cash used in investing increased from 2019 to 2020 but then decreased significantly from 2020 to 2021.