Using the income statement and balance sheet, calculate all the ratios for year 2022 as listed on the last image.

A B C E MICROSOFTS FINANCIAL STATEMENTS INCOME STATEMENTS (In millions) Year Ended June 30. 2022 2021 Revenue: Product Service and other Total revenue \$ 72,732 S 71,074 6 7 8 9 Cost of revenue: 10 11 Product Service and other 125538 97014168088 12 Total cost of revenue Gross margin Research and development Sales and marketing 198270 18219 13 14 15 16 17 18 19 \begin{tabular}{|lrr|} \hline General and administrative & 21825 & 20117 \\ \hline Operating income & 5900 & 5107 \\ \hline Other income, net & 83383 & 69916 \\ \hline Income before income taxes & 333 & 1186 \\ \hline Income taxes & 83716 & 71102 \\ \hline Net income & 10978 & 9831 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \begin{tabular}{l} BALANCE SHEETS (In millions) \\ June 30 , \end{tabular} & 2022 & 2021 \\ \hline \multirow{2}{*}{\multicolumn{3}{|c|}{\begin{tabular}{l} June 30, \\ Assets \\ \end{tabular}}} \\ \hline \begin{tabular}{l} Assets \\ Current assets: \end{tabular} & & \\ \hline Cash and cash equivalents & 13,931$ & 14,224 \\ \hline Short-term investments & 90,826 & 116,110 \\ \hline Aceounts receivable & 44,261 & 38,043 \\ \hline Inventories & 3,742 & 2,636 \\ \hline Other current assets & 16,924 & 13,393 \\ \hline Total current assets & 169,684 & 184,406 \\ \hline Net Property and equipment & 74,398 & 59,715 \\ \hline Equity investments & 6.891 & 5,984 \\ \hline Goodwill & 67,524 & 49.711 \\ \hline Intangible assets, net & 11,298 & 7,800 \\ \hline Other long-term assets & 35,045 & 26,163 \\ \hline Total assets & 364,840 & 333,779 \\ \hline \multirow{2}{*}{\multicolumn{3}{|c|}{ Liabilities and stockholders' equity }} \\ \hline & & \\ \hline Current liabilities: & 19,000 & 15,163 \\ \hline \begin{tabular}{l} Accounts payable \\ Current portion of long-term debt \end{tabular} & 2,749 & 8,072 \\ \hline Accrued compensation & 10,661 & 10,057 \\ \hline Other current liabilities & 62,672 & 55,365 \\ \hline Total current liabilities & 95,082 & 88,657 \\ \hline Long-term debt & 47,032 & 50,07 \\ \hline Other long-term liabilities & 56,184 & 53,060 \\ \hline Total liabilitics & 198,298 & 191,791 \\ \hline & & \\ \hline \multicolumn{3}{|l|}{ Stockbolders' equity: } \\ \hline Common stock - shares outstanding 7,464 and 7,519 & 86,939 & 83,111 \\ \hline Retained earnings & 84,281 & 57,055 \\ \hline Comprehensive income (loss) & (4,678) & 1,822 \\ \hline Total stockholders' equity & 166,542 & 141,988 \\ \hline Total liabilities and stockholders' equity & 364,840 & 333,779 \\ \hline \end{tabular} Ratio Analysis using Excel Calculate the folowing ratios for Microsoft: 2022 Current Ratio = Current Assets/Current Liabilities 1.78 Inventory Turnover = COGS/Average Inventories Total Asset turnover = Sales/Average total assets Operating Profit Margin = EBIT/Sales Return on Total Assets (ROA)= EBIT/Average Assets Return on Equity (ROE) = Net Income/Average Stockholder's Equity Tax Burden Ratio = Net Income/Pretax Profit Interest Burden Ratio = Pretax Profit/EBIT Leverage Ratio = Average Assets/Average Equity A B C E MICROSOFTS FINANCIAL STATEMENTS INCOME STATEMENTS (In millions) Year Ended June 30. 2022 2021 Revenue: Product Service and other Total revenue \$ 72,732 S 71,074 6 7 8 9 Cost of revenue: 10 11 Product Service and other 125538 97014168088 12 Total cost of revenue Gross margin Research and development Sales and marketing 198270 18219 13 14 15 16 17 18 19 \begin{tabular}{|lrr|} \hline General and administrative & 21825 & 20117 \\ \hline Operating income & 5900 & 5107 \\ \hline Other income, net & 83383 & 69916 \\ \hline Income before income taxes & 333 & 1186 \\ \hline Income taxes & 83716 & 71102 \\ \hline Net income & 10978 & 9831 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \begin{tabular}{l} BALANCE SHEETS (In millions) \\ June 30 , \end{tabular} & 2022 & 2021 \\ \hline \multirow{2}{*}{\multicolumn{3}{|c|}{\begin{tabular}{l} June 30, \\ Assets \\ \end{tabular}}} \\ \hline \begin{tabular}{l} Assets \\ Current assets: \end{tabular} & & \\ \hline Cash and cash equivalents & 13,931$ & 14,224 \\ \hline Short-term investments & 90,826 & 116,110 \\ \hline Aceounts receivable & 44,261 & 38,043 \\ \hline Inventories & 3,742 & 2,636 \\ \hline Other current assets & 16,924 & 13,393 \\ \hline Total current assets & 169,684 & 184,406 \\ \hline Net Property and equipment & 74,398 & 59,715 \\ \hline Equity investments & 6.891 & 5,984 \\ \hline Goodwill & 67,524 & 49.711 \\ \hline Intangible assets, net & 11,298 & 7,800 \\ \hline Other long-term assets & 35,045 & 26,163 \\ \hline Total assets & 364,840 & 333,779 \\ \hline \multirow{2}{*}{\multicolumn{3}{|c|}{ Liabilities and stockholders' equity }} \\ \hline & & \\ \hline Current liabilities: & 19,000 & 15,163 \\ \hline \begin{tabular}{l} Accounts payable \\ Current portion of long-term debt \end{tabular} & 2,749 & 8,072 \\ \hline Accrued compensation & 10,661 & 10,057 \\ \hline Other current liabilities & 62,672 & 55,365 \\ \hline Total current liabilities & 95,082 & 88,657 \\ \hline Long-term debt & 47,032 & 50,07 \\ \hline Other long-term liabilities & 56,184 & 53,060 \\ \hline Total liabilitics & 198,298 & 191,791 \\ \hline & & \\ \hline \multicolumn{3}{|l|}{ Stockbolders' equity: } \\ \hline Common stock - shares outstanding 7,464 and 7,519 & 86,939 & 83,111 \\ \hline Retained earnings & 84,281 & 57,055 \\ \hline Comprehensive income (loss) & (4,678) & 1,822 \\ \hline Total stockholders' equity & 166,542 & 141,988 \\ \hline Total liabilities and stockholders' equity & 364,840 & 333,779 \\ \hline \end{tabular} Ratio Analysis using Excel Calculate the folowing ratios for Microsoft: 2022 Current Ratio = Current Assets/Current Liabilities 1.78 Inventory Turnover = COGS/Average Inventories Total Asset turnover = Sales/Average total assets Operating Profit Margin = EBIT/Sales Return on Total Assets (ROA)= EBIT/Average Assets Return on Equity (ROE) = Net Income/Average Stockholder's Equity Tax Burden Ratio = Net Income/Pretax Profit Interest Burden Ratio = Pretax Profit/EBIT Leverage Ratio = Average Assets/Average Equity