Question

You feel that you will need $2.2 million in your retirement account and when you reach that amount, you plan to retire. You feel you can earn an APR of 10.2 percent compounded monthly and plan to save $305 per month until you reach your goal. How many years will it be until you reach your goal and retire

Answer 1

Answer: 40.7 years

Explanation:

You can use Excel to sold for this using the NPER function.

Rate = 10.2% / 12 months = 0.85%

Payment is $305 per month

Present value is $0

Future value is $2,200,000

Number of periods = 488.1979353

In years this is:

= 488.1979353 / 12

= 40.7 years