I thought I had already posted this spreadsheet, but it looks like I missed it. The sheet uses both formulas and Excel functions to calculate the present value, future value and also shows how to calculate the APR and APY on a cash flow, give either the present or future value. This sheet is very close to the one called “No XNFV Excel Function?“, that showed present and future value calculations, given the dates of each cash flow. This post sheet however, assumes the cash flows are periodic, such as annually, quarterly, monthly, etc..
As is the case in all my workbooks, the input cells are yellow. I don’t think it needs more explanation. Leave a reply if you need more.
Download workbook “PV_FV_Periodic CashFlows” from:
Downloads Written in Excel 2013