Lesson 6 of 6

Pull a company into your spreadsheet

Step 4 of 6

Do it yourself

Small and practical. Do it now while it is fresh.

About 15 minutes, easiest on a laptop. Use Google Sheets or Excel.

  1. Open Microsoft's 10-K list on EDGAR.
  2. On the top row (the 10-K filed 2026-07-29), click Interactive Data.
  3. In the menu on the left, open Financial Statements, then INCOME STATEMENTS.
  4. 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.)
  5. 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.
  6. 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.