Therefore, we must finit this i. Find the PV and the FV of an investment that makes the following end-of-year payments. The interest rate is 8%. \begin{tabular}{l|l|l|} \hline Rate = & 8% \\ \hline To find the PV, use the NPV function: PV = \end{tabular} Excel does not have a function for the sum of the future values for a set of uneven payments. Therefore, we must find this FV by some other method. Probably the easiest procedure is to simply compound each payment, then sum them, as is done below. Note that since the payments are received at the end of each year, the first payment is compounded for 2 years, the second for 1 year, and the third for 0 years. An alternative procedure for finding the FV would be to find the PV of the series using the NPV function, then compound that amount, as is done below: Therefore, we must finit this i. Find the PV and the FV of an investment that makes the following end-of-year payments. The interest rate is 8%. \begin{tabular}{l|l|l|} \hline Rate = & 8% \\ \hline To find the PV, use the NPV function: PV = \end{tabular} Excel does not have a function for the sum of the future values for a set of uneven payments. Therefore, we must find this FV by some other method. Probably the easiest procedure is to simply compound each payment, then sum them, as is done below. Note that since the payments are received at the end of each year, the first payment is compounded for 2 years, the second for 1 year, and the third for 0 years. An alternative procedure for finding the FV would be to find the PV of the series using the NPV function, then compound that amount, as is done below