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.