How to calculate free cash flow in Google Sheets from SEC filings
Free cash flow is the cash a business brings in from its operations after paying for buildings, equipment and other long-term assets. The usual calculation is:
Free cash flow = operating cash flow - capital spending
Where the two numbers are
Both are on the cash flow statement in the 10-K. Operating cash flow is "net cash provided by operating activities". Capital spending is usually "payments for acquisition of property, plant and equipment", shown as a negative number because it is cash going out.
| Apple fiscal 2026 | $ millions |
|---|---|
| Operating cash flow | 145,097 |
| Capital spending | 9,041 |
| Free cash flow | 136,056 |
In Google Sheets
With AsFiled, put the ticker in B1 and the year in B2:
=FILING(B1, "operating cash flow", B2) - FILING(B1, "capex", B2)
AsFiled returns capital spending as a positive amount, so the subtraction works as written. Put years across a row and copy the formula along it to get a ten-year history. The free cash flow template does this and adds dividends, buybacks and free cash flow margin.
Some companies, such as banks, don't report a capital spending line. For them the result is n/a rather than a guess.
Try it without writing anything
Our free Google Sheets templates already contain these formulas. Make a copy, type a ticker, and the numbers fill in.
Free templates · Guides · AsFiled Pro · Terms · Privacy · Refunds · Support
AsFiled is made by Eagle Eye Insights LLC. Numbers come from companies' own filings with the U.S. Securities and Exchange Commission; AsFiled is not affiliated with the SEC.