Guides

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 flow145,097
Capital spending9,041
Free cash flow136,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.

See the templates

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.