163k views
5 votes
Your parents will retire in 26 years. They currently have $220,000 saved, and they think they will need $1,950,000 at retirement. What annual interest rate must they earn to reach their goal, assuming they don't save any additional funds? Round your answer to two decimal places.

User Phate
by
5.6k points

1 Answer

1 vote

Answer:

Annual rate of interest is 9%

Step-by-step explanation:

The annual rate of interest is computed using the excel formula of Rate as:

=Rate(nper,pmt,pv,fv,type)

where

nper is number of years which is 26 years

Pmt is monthly payment which is 0

pv is present value which is -$220,000

fv is future value which is $1,950,000

type is 0

So, putting the values above:

=Rate(26,0,-220000,1950000,0)

=9%

Therefore, the rate of interest is 9%

User Carsten Kuckuk
by
6.0k points