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

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.

A cash flow forecast predicts anticipated bank deposits and expenses by line item, by month, for a future year. A historical cash flow recap shows actual figures for a previous period.

Learn financial statement analysis techniques, including horizontal, vertical, and ratio analysis, to assess company ...

Financial calculators include the IRR calculation -- but for a limited number of cash flow events. A spreadsheet will calculate the percentage for any number of future, uneven or even cash flows.