Understanding STDEV 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.

So what is a cash flow projection and how is it done? Most financial software packages provide some form of cash flow modeling and excel spreadsheets will also work.

Calculating free cash flow is useful for investors and lenders to evaluate the success of a company. To create an Excel spreadsheet to calculate operating cash flow, first merge the first row of ...