You need $23,956 at the end of nine years, and your only investment outlet is a 7 percent long-term certificate of deposit (compounded annually). With the certificate of deposit, you make an initial investment at the beginning of the first year.

a. What single payment could be made at the beginning of the first year to achieve this objective?

b. What amount could you pay at the end of each year annually for nine years to achieve this same objective?

NEED EXCEL FORMULAS