Answer:
with a life expectancy of 20 years the annuity will yield: 0.21% per month
Step-by-step explanation:
We will calcualte the monthly interest rate of an annuity of 375 for 20 years which PV is 71,000
C 375
time 240 (20 years x 12 months a year)
PV $71,000.00
We can solve for rate using excel goal seek:
we write any number value on cell A1
then on any other cell we write:
=PV(A1,240,375)
then we will use goal seek and define:
this cell, with the value of 71,000 changing A1
rate = 0.002053645 = 0.21% per month