you need $24,456 at the end of 10 years, and your only investment outlet is an 8% long-term certificate of deposit (compound annually). with the certificate of deposit, you make an initial investment at the beginning of the year.
using the MS excel PV function
a) what single payment could be made at the beginning of the first year to achieve this objective
b) what amount could pay at the end of each year annually for 10 years to achieve this same objective