Prepare a summary analysis of the Statement of Cash Flows for all three years presented (common-size...

  

Transcribed Image Text:

Prepare a summary analysis of the Statement of Cash Flows for all three years presented (common-size cash flow statement). b. Analyze the cash flows for all three years based on your summary analysis. Potential questions to answer in your discussion: what percentage of cash inflows supplied by operations; what are the other significant items in cash inflows; is there a change in the percentage of operations in cash inflows from 2020 to 2022 (is this change good or bad for the company); which items constitute the biggest portion of cash outflows. (In millions) Year Ended June 30, Operations Net income Adjustments to reconcile net income to net cash from operations: Depreciation, amortization, and other Stock-based compensation expense Net recognized gains on investments and derivatives Deferred income taxes Changes in operating assets and liabilities: Accounts receivable Inventories Other current assets Other long-term assets Accounts payable Unearned revenue Income taxes Other current liabilities Other long-term liabilities Net cash from operations Financing Cash premium on debt exchange Repayments of debt. Common stock issued Common stock repurchased Common stock cash dividends paid Other, net Net cash used in financing Investing Additions to property and equipment Acquisition of companies, net of cash acquired, and purchases of intangible and other assets Purchases of investments Maturities of investments Sales of investments Other, net Net cash used in investing Effect of foreign exchange rates on cash and cash equivalents Net change in cash and cash equivalents Cash and cash equivalents, beginning of period Cash and cash equivalents, end of period Common size-Balance sheet Common-size Income Statement Gach 2022 72,738 14,460 7,502 -409 -5,702 2,344 825 89,035 2021 -6,834 -6,481 -1,123 -737 -709 -932 -2,805 -3,459 2,943 2,798 5,109 4,633 696 -2,309 4,149 0 -9,023 1,841 61,271 44,281 11,686 6,118 -1,249 -150 14,224 13,931 -1,754 -3,750 1,693 -32,696 -27,385 -18,135 -16,521 -863 -769 -58,876 -48,486 1,402 76,740 -23,886 -20,622 -22,038 -8,909 -26,456 -62,924 16,451 51,792 28,443 14,008 -2,825 -922 -30,311 -27,577 -141 -29 -293 648 13,576 14,224 2020 12,796 5,289 -219 11 -2,577 168 -2,330 -1,037 3,018 2,212 -3,631 1,346 1,348 60,675 -3,417 -5,518 1,343 -22,968 -15,137 -334 -46,031 -15,441 -2,521 -77,190 66,449 17,721 -1,241 -12,223 -201 2,220 11,356 13,576 Prepare a summary analysis of the Statement of Cash Flows for all three years presented (common-size cash flow statement). b. Analyze the cash flows for all three years based on your summary analysis. Potential questions to answer in your discussion: what percentage of cash inflows supplied by operations; what are the other significant items in cash inflows; is there a change in the percentage of operations in cash inflows from 2020 to 2022 (is this change good or bad for the company); which items constitute the biggest portion of cash outflows. (In millions) Year Ended June 30, Operations Net income Adjustments to reconcile net income to net cash from operations: Depreciation, amortization, and other Stock-based compensation expense Net recognized gains on investments and derivatives Deferred income taxes Changes in operating assets and liabilities: Accounts receivable Inventories Other current assets Other long-term assets Accounts payable Unearned revenue Income taxes Other current liabilities Other long-term liabilities Net cash from operations Financing Cash premium on debt exchange Repayments of debt. Common stock issued Common stock repurchased Common stock cash dividends paid Other, net Net cash used in financing Investing Additions to property and equipment Acquisition of companies, net of cash acquired, and purchases of intangible and other assets Purchases of investments Maturities of investments Sales of investments Other, net Net cash used in investing Effect of foreign exchange rates on cash and cash equivalents Net change in cash and cash equivalents Cash and cash equivalents, beginning of period Cash and cash equivalents, end of period Common size-Balance sheet Common-size Income Statement Gach 2022 72,738 14,460 7,502 -409 -5,702 2,344 825 89,035 2021 -6,834 -6,481 -1,123 -737 -709 -932 -2,805 -3,459 2,943 2,798 5,109 4,633 696 -2,309 4,149 0 -9,023 1,841 61,271 44,281 11,686 6,118 -1,249 -150 14,224 13,931 -1,754 -3,750 1,693 -32,696 -27,385 -18,135 -16,521 -863 -769 -58,876 -48,486 1,402 76,740 -23,886 -20,622 -22,038 -8,909 -26,456 -62,924 16,451 51,792 28,443 14,008 -2,825 -922 -30,311 -27,577 -141 -29 -293 648 13,576 14,224 2020 12,796 5,289 -219 11 -2,577 168 -2,330 -1,037 3,018 2,212 -3,631 1,346 1,348 60,675 -3,417 -5,518 1,343 -22,968 -15,137 -334 -46,031 -15,441 -2,521 -77,190 66,449 17,721 -1,241 -12,223 -201 2,220 11,356 13,576