#3 and #4. Microsoft.

Group project*: Please refer to the Form 10k 2020 annual report of Microsoft. You can print the annual report from the internet. Please perform the following and perform the following. Please attach the financial statements that you used 1 2 Refer to the Management Discussion & Analysis section and write a one page summary describing the highlights of the year. Prepare a horizontal analysis of the 2020 and 2019 Income Statement/Statement of Operations in Excel (This must be your original work and not a report downloaded from the internet). Prepare a vertical analysis of the 2020 and 2019 Balance Sheet. (This must be your original work and not a report downloaded from the internet). 3 4 Refer to the statement of cash flows and indicate in one sentence, the net cash provided/used by Investing activities. 5 Refer to the Statement of cash flows and indicate in one sentence, how much was the net cash provided/used by operating activities. Which method does the company use to prepare the Operating activities section of the statement of cash flows. (one sentence answer..... Direct or Indirect) 7 How many shares of common stock are outstanding at year-end(Refer to the Balance Sheet). (one sentence answer) 8 Compute the following ratios for 2020 and the previous year(2019) and comment on whether the ratios improved or got worse during the current year a. Current Ratio b. Debt Ratio C. Days sales in Inventory d. Profit Margin Ratio Group project*: Please refer to the Form 10k 2020 annual report of Microsoft. You can print the annual report from the internet. Please perform the following and perform the following. Please attach the financial statements that you used 1 2 Refer to the Management Discussion & Analysis section and write a one page summary describing the highlights of the year. Prepare a horizontal analysis of the 2020 and 2019 Income Statement/Statement of Operations in Excel (This must be your original work and not a report downloaded from the internet). Prepare a vertical analysis of the 2020 and 2019 Balance Sheet. (This must be your original work and not a report downloaded from the internet). 3 4 Refer to the statement of cash flows and indicate in one sentence, the net cash provided/used by Investing activities. 5 Refer to the Statement of cash flows and indicate in one sentence, how much was the net cash provided/used by operating activities. Which method does the company use to prepare the Operating activities section of the statement of cash flows. (one sentence answer..... Direct or Indirect) 7 How many shares of common stock are outstanding at year-end(Refer to the Balance Sheet). (one sentence answer) 8 Compute the following ratios for 2020 and the previous year(2019) and comment on whether the ratios improved or got worse during the current year a. Current Ratio b. Debt Ratio C. Days sales in Inventory d. Profit Margin Ratio