MY QUESTION IS IN THE PICTURE MESSAGD AND PLEASE SOLVE IN AN EXCEL FILE

Plan for distribution or withdrawal period: Desired Annual Annuity = Years = Assumed earnings rate = Plan for contribution or cumulation period: Years = Assumed earnings rate = First determine the accumulation that is required to fund the retirement annuity: This amount is the PV of the annuity. RATE = NPER = PMT = Solve for PV using the PV function 12,000 25 10% 25 25 12000 ($ 108,924.48) Now determine the contributions required to cumulate to $108,924: The desired accumulation is FV of an annuity RATE = NPER = Solve for PMT using the PMT function PMT = 8% 20 ($108,924.48) $2,380.24