the plans:

Could you please do the converts in excel and show the formulas please?

d. (10%) Convert the PV at 66 you just found to PV at 62 PV at 62 Write your answer here e. (10%) Convert the PV at 70 you just found to PV at 62 PV at 62 Write your answer here f. (10%) Based on your findings above, which plan you should choos Write your answer here years old a) Collect at 62 Monthly payment = $3006 Term = 30 years = 30x12 months = 360 months interest rate = 0.25% per month= 0.0025 fu= $3000 (1.0025360-D] $1,748,210-65 0.0025 collect at 66 old years Monthly payment - $4000 312 months 0.0025 interest sate= fu= $4000 0-0025 [1.0025312_1] = $1,886,959.84 & collect at 70 70 years old 48oo Monthly payment Terms = 22 years = 264 months interect 0.0025 $4800 (1.0025264 $1,791,742.93 D-0025 rate =