Objective:

Using the most recent annual financial statements $(10-$K$)$ of Microsoft Corporation, perform the

following calculations. The financial statements can be accessed here: Microsoft SEC Filings.

Instructions:

$1.$ Download the $10-$K Form: Obtain the most recent annual financial statement $($Excel

version$)$ from the provided link.

$2.$ Locate the relevant financial statements within the downloaded worksheet.

$3.$ Perform the Following Calculations:

a$)$ Return on Assets $($ROA$)$:

b$)$ Net Profit Margin:

c$)$ Asset Turnover Ratio:

d$)$ Current Ratio:

e$)$ Debt to Equity Ratio:

$4.$ Submit Your Work:

o Calculate the above ratios using the values from the financial statements.

o Enter all formulas and calculated values in the Income statement tab of the excel

sheet.

o Save and submit the Excel worksheet with all necessary formulas included.