Si. Find the PV and FV of an investment that makes the following end-of-year payments. The interest rate is 8%. Year Payment 100 200 400 ht Rate = 8% To find the PV, use the NPV function: PV = 7 Excel does not have a function for the sum of the future values for a set of uneven payments. 3 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 ipayments are received at the end of each year, the first payment is compounded for 2 years, Year X Payment 100 200 400 Interna (1+1)^(Nt) 1.17 1.08 1.00 FV 116.64 216.00 400.00 2 Sum = An alternative procedure for finding the FV would be to find the PV of the series using the NPV 1 function, then compound that amount, as is done below: PV = FV of PV =