Lesson 6 of 6

Pull a company into your spreadsheet

Step 5 of 6

Check yourself

Answer in your head first, then tap to reveal.

1. Which statements show three years in a 10-K, and which shows only two dates?

Show answer

The income statement and cash flow statement show three years. The balance sheet shows two dates, so for a third you need last year's 10-K.

2. A tutorial tells you to click "View Excel Document" on EDGAR. Why might that fail?

Show answer

Recent filings no longer include the Excel file. Microsoft's FY2025 and FY2026 10-Ks have none. Copy the tables from the Interactive Data pages instead.

3. Microsoft's FY2026 operating cash flow was $182,935M and capex $115,948M. What was free cash flow?

Show answer

182,935 − 115,948 = $66,987M, about $67.0B.

4. Why keep reported numbers separate from your own calculated rows?

Show answer

So you can always check your sheet against the filing, and so a typo in a formula never overwrites a real number.