Lesson 6 of 6

Pull a company into your spreadsheet

Step 3 of 6

Worked example

Microsoft, fiscal years 2024 to 2026. Microsoft's fiscal year ends on 30 June, so FY2026 is the year ended 30 Jun 2026. All figures come from the FY2026 10-K (filed 29 Jul 2026), which shows all three years. Checked against the SEC's XBRL data on 20 Nov 2026. $ in millions.

Copied from the Interactive Data pages:

$ millions FY2024 FY2025 FY2026
Revenue 245,122 281,724 331,839
Gross margin 171,008 193,893 225,465
Operating income 109,433 128,528 155,237
Net income 88,136 101,832 133,749
Operating cash flow 118,548 136,162 182,935
Capex 44,477 64,551 115,948

Two naming notes. Microsoft calls gross profit "Gross margin". Capex appears in the cash flow statement as "Additions to property and equipment", shown as a negative number. Type it in as positive and subtract it in your formulas.

Then your own rows, with formulas. Say the years sit in row 1, the six lines above in rows 2–7 (revenue in row 2, capex in row 7), FY2024 in column B and FY2025 in column C:

Revenue growth     = C2/B2 - 1
Operating margin   = C4/C2        (operating income ÷ revenue)
Free cash flow     = C6 - C7      (operating cash flow − capex)

Results:

FY2024 FY2025 FY2026
Revenue growth — 14.9% 17.8%
Operating margin 44.6% 45.6% 46.8%
Free cash flow ($M) 74,071 71,611 66,987

The story jumps out once it's laid out. Revenue grew 35% over two years and operating cash flow 54%. Yet free cash flow fell each year. Why? Capex rose from $44.5B to $115.9B, about 2.6 times, as Microsoft built data centres for cloud and AI (you met this in Module 3's capex lesson). On the income statement that spending shows up only slowly, as depreciation spread over years. In the sheet it's obvious in three rows.