One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.

Excel for the web supports all three ranking functions. If you’re unfamiliar with Excel’s three ranking functions, consider reading How to calculate rank in an Excel sheet.

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.