Financial Statement Analysis Project

Post ID: 3507720

Overview

Goal:

Analyze your assigned publicly traded company’s financial performance by comparing FY2023 vs FY2024 using the company’s 10-K (Annual Report).
Data to Use (Required): the two most recent 10-K filings (https://www.sec.gov/search-filingsLinks to an external site. )

What to Submit (2 files):

Excel (Calculations)
1. Horizontal Analysis for income statement and balance sheet, include:
  - FY2023 value
  - FY2024 value
  - $ Change
  - % Change
2. Vertical Analysis for income statement and balance sheet, include:
  - Income Statement base
  - Balance Sheet base
3. Ratio Calculations (Both years)
  - Calculate required ratios for FY2024 and FY2023 (show formulas or clearly labeled inputs). If a ratio cannot be computed, explain why in your report.
4. Word Report (Interpretation)
  1. Executive Summary (short)
    - Summarizing the company’s background, FY2023→FY2024 performance and key drivers.
  2. Income Statement (Select 5 accounts)
    - Choose five important income statement line items and explain:
      1. what changed
      2. why it changed
      3. what it implies.

Balance Sheet (Select 5 accounts)
- Choose five important balance sheet line items and explain:
  1. what changed
  2. why it changed
  3. what it implies (liquidity/leverage/financial health).

Ratio Analysis (Written explanations required)
- For each ratio, explain whether it improved/worsened and what it means. (Do not submit ratios with numbers only—interpretation is required.)
References
- List your sources (10-K/annual report). Page numbers are encouraged.

Grading Rubric (100 points)

Complete IS + BS for both analyses, correct calculations, clear labels, readable layout.

All required ratios computed for both years; correct formulas; no missing ratios.

Executive summary + 5 IS accounts + 5 BS accounts with explanations + ratio interpretations + clear organization.