Future Value of Annuity

You can use the PV function to get the value in todays dollars of a series of future payments assuming periodic constant payments…