A cash flow chart clarifies what your company does with its money in a way that may not be apparent when you look at a spreadsheet page full of numbers. ... How to Create a Summary Chart in Excel.

In this instance, you would now be provided with both companies' free cash flow numbers, Apple's in cell B5, of $73.36 billion, and Alphabet's in cell C5, of $42.84 billion.

Using Excel For Cash Flow . In cells B4 through M4, put one month of the year within each starting with the beginning of the tax year. In A5, type "Opening Balance." ...

Add together all the cash flows you have put in the spreadsheet to calculate a total. Divide the total by the number of historical entries to calculate the mean average cash flow.