14 Feb 2018 PV is one of the most important financial functions in Excel which period or (b) present value of a single cash flow at a specific time in future at constant However, it can be used to calculate present value of annuity due i.e.