Microsoft Corporation Comparative Financial Statements

Income Statement for Years Ended June 30, 2021, 2022, 2023

• Revenue: $168,088, $198,270, $211,926
• Cost of Revenue: $58,365, $68,464, $72,837
• Gross Profit: $109,723, $129,806, $139,089
• Operating Expenses: $69,916, $79,890, $85,297
• Operating Income: $39,807, $49,916, $53,792
• Interest Expense: $2,081, $2,197, $2,318
• Income Before Tax: $37,726, $47,719, $51,474
• Income Tax Expense: $5,456, $7,158, $7,937
• Net Income: $32,270, $40,561, $43,537

Balance Sheet as of June 30, 2021, 2022, 2023

• Assets
  • Current Assets: $176,223, $189,857, $205,473
  • Property and Equipment, Net: $45,976, $48,623, $52,709
  • Intangible Assets: $23,728, $25,670, $26,932
  • Total Assets: $245,927, $264,150, $285,114
• Liabilities and Equity
  • Current Liabilities: $82,146, $87,195, $92,834
  • Long-Term Debt: $60,424, $64,372, $69,257
  • Shareholders' Equity: $103,357, $112,583, $123,023
  • Total Liabilities and Equity: $245,927, $264,150, $285,114

Requirements

1. Compute the gross profit margin for each year.
2. Determine the operating income as a percentage of revenue for each year.
3. Calculate the interest coverage ratio for each year.
4. Assess the current ratio for each year.