Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate all the ratios listed in the last image. begin{tabular}{|c|c|c|} hline begin{tabular}{l} BALANCE SHEETS (In millions) June 30 , end{tabular} & 2022 & 2021

image text in transcribed
image text in transcribed
image text in transcribed
Calculate all the ratios listed in the last image.
\begin{tabular}{|c|c|c|} \hline \begin{tabular}{l} BALANCE SHEETS (In millions) \\ June 30 , \end{tabular} & 2022 & 2021 \\ \hline \multicolumn{3}{|l|}{\begin{tabular}{l} June 30 , \\ Assets \end{tabular}} \\ \hline \multicolumn{3}{|l|}{\begin{tabular}{l} Assets \\ Current assets: \end{tabular}} \\ \hline Cash and cash equivalents & 13,931s & 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 & & \\ \hline \multicolumn{3}{|l|}{ Liabilities and stockholders' equity } \\ \hline \multicolumn{3}{|l|}{\begin{tabular}{l} Liabulities and stockholders equity \\ Current liabilities: \end{tabular}} \\ \hline Accounts payable & 19,000 & 15,163 \\ \hline Current portion of long-term debt & 2,749 & 8,072 \\ \hline Accrued compensation & 10,661 & 10,057 \\ \hline Other current lisbilities & 62,672 & 55,365 \\ \hline Total current liabilities & 95,082 & 88,657 \\ \hline Long-term debt & 47,032 & 50,074 \\ \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} H31 A B c (b) E 1 MICROSOFTS FINANCIAL STATEMENTS 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17) 18 19 20 21 22 Ratio Analysis using Excel \begin{tabular}{|l|r|} \hline Calculate the folowing ratios for Microsoft: & \multicolumn{1}{|c|}{2022} \\ \hline Current Ratio = Current Assets/Current Liabilities & \\ \hline Inventory Turnover = COGS/Average Inventories & \\ \hline Total Asset turnover = Sales/Average total assets & \\ \hline Operating Profit Margin = EBIT/Sales & \\ \hline Return on Total Assets (ROA) = EBIT/Average Assets & \\ \hline Return on Equity (ROE) = Net Income/Average Stockholder's Equity & \\ \hline Tax Burden Ratio = Net Income/Pretax Profit & \\ \hline Interest Burden Ratio = Pretax Profit/EBIT & \\ \hline Leverage Ratio = Average Assets/Average Equity & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Sector Accounting Auditing And Control In South Eastern Europe

Authors: Vesna Vašiček, Gorana Roje

1st Edition

303003352X, 978-3030033521

More Books

Students also viewed these Accounting questions

Question

=+ Is the document persuasive?

Answered: 1 week ago

Question

Explain the forces that influence how people handle conflict

Answered: 1 week ago