PV and FV of Periodic Cash Flows

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

Don Pistulka
Don Pistulka

Retired Credit Union CFO - Finance
Background: over 40 years in investments, asset/Liability management, banking, securities trader.
Worked for: California Credit Union, WesCorp, CalFed S&L, Crocker Bank, Carroll McEntee, Federal Home Loan Bank Board (D.C.), Western Asset Management, Security Pacific National Bank.

1 Comment

Leave a Reply

Your email address will not be published. Required fields are marked *