The statement of cash flows on a financial statement sheds a lot of light into the movement of cash in and out of a company and shows how well a company manages its cash position. Free cash flow (FCF) is one of the more important measures derived from a cash flow statement.
Free cash flow is used in fundamental analysis to measure the amount of cash a company generates, after accounting for its capital expenditures. To calculate a company's FCF, one would refer to its balance sheet and subtract its capital expenditures from its total cash flow from operating activities.
Microsoft Excel is a comprehensive and easy to use tool for calculating different formulas and any other computational work in general. Below, see how to calculate free cash flow in Excel as well as how to run comparisons with other companies.
Calculating Free Cash Flow in Excel
For example, according to its cash flow statement for fiscal year-end Sept. 28, 2019, Apple Incorporated reported total cash flow from operating activities of $69.39 billion. Apple reported capital expenditures of $7.60 billion for the same period.
Apple's competitor, Alphabet Incorporated, reported total cash flow from operating activities of $54.53 billion and capital expenditures of $23.55 billion for the period ending Dec. 31, 2019.
To compare the FCFs between Apple and Alphabet in Excel, enter the words "Apple Incorporated" in cell B1 and "Alphabet Incorporated" in cell C1.
Next, enter the date "Sept. 28, 2019" into cell B2. Enter "Total Cash Flow From Operating Activities" into cell A3, "Capital Expenditures" into cell A4 and "Free Cash Flow" into cell A5. Then, enter "=69390000000" into cell B3 and "=7600000000" into cell B4.
To calculate Apple's FCF, enter the formula "=B3-B4" into cell B5. The resulting FCF of Apple is $61.79 billion.
Now, enter the date "Dec. 31, 2019" into cell C2. Enter "=54530000000" into cell C3 and "=23550000000" into cell C4. Next, enter the formula "=C3-C4" into cell C5. The result demonstrates that Alphabet's FCF is $30.98 billion.
In this instance, you would now be provided with both companies' free cash flow number, Apple's in cell B5, of $61.79 billion, and Alphabet's in cell C5, of $30.98 billion. One can also enter the numbers into each cell differently. For example, in cell B3, one wouldn't have to enter all the numerals to get a billion-dollar value. Instead, one could simply enter "=69.39" and in a separate cell clarify that the numbers are in billions. For example, one can note "numbers in billions."
The Bottom Line
Microsoft Excel is an essential tool when working with numbers, as it provides automatic calculations and a simple layout for mathematical work. The formula for free cash flow is a basic one, as it requires only two numbers, both of which can be found easily on a company's financial statement. Once free cash flow is obtained, it helps understand how much available cash a company has for various uses, such as paying dividends or making investments that contribute to the health and growth of the company.