About 15 minutes, easiest on a laptop. Use Google Sheets or Excel.
- Open Microsoft's 10-K list on EDGAR.
- On the top row (the 10-K filed 2026-07-29), click Interactive Data.
- In the menu on the left, open Financial Statements, then INCOME STATEMENTS.
- Select the table from the title to the last row, copy it and paste it into a new tab. Do the same for CASH FLOWS STATEMENTS. (On a phone, type the six numbers in instead.)
- Tidy up: keep the six rows in the table above and delete the rest. The SEC table runs newest first (Jun. 30, 2026, then 2025, then 2024). Reorder the columns so B is FY2024, C is FY2025 and D is FY2026. Check: B2 should be 245,122.
- Add the three formula rows in column C and drag them right to D. Check: revenue growth in C should be 14.9%. If you see −15.1%, your years are still newest-first.
If a paste lands in one long column, try "paste special → values only", or paste into a blank tab first and copy the rows across.
Optional stretch, about 15 minutes: make the statements check each other. From BALANCE SHEETS in the same menu, add four rows for FY2025 (column C) and FY2026 (column D): cash and cash equivalents, total assets, total liabilities and total stockholders' equity. Add a fifth row, "Net change in cash and cash equivalents", from the cash flow statement. This balance sheet has only two dates, so leave FY2024 blank. Then add two check rows:
Balance check (C and D): = total assets − (total liabilities + equity)
Cash check (D only): = (cash FY2026 − cash FY2025) − net change in cash FY2026
Show answers
Steps 5–6: your results should match the results table above.
Stretch ($ millions):
FY2025 FY2026
Cash 30,242 20,935
Total assets 619,003 758,376
Total liabilities 275,524 315,989
Total equity 343,479 442,387
Net change in cash 11,927 −9,307
Balance check: 619,003 − (275,524 + 343,479) = 0
758,376 − (315,989 + 442,387) = 0
Cash check: (20,935 − 30,242) − (−9,307) = 0
Both checks are zero, so the statements tie. If a company's cash check is a little off, look for restricted cash (lesson 04): a note explains the gap.
That's the end of Module 4. You can now read each statement, trace how they link, and pull any US company's numbers into your own sheet.
Next lesson: A tour of SEC EDGAR, the first lesson of Module 5, Reading 10-Ks, 10-Qs and earnings calls.