Question

Dong Wang wants to retire when he has saved $1,500,000. He can make 30 payments of $15,000 each, with each payment made at the beginning of the year. What would be the interest rate required to help him achieve his goal

Answer 1

Answer: 6.94%

Explanation:

You can use an Excel worksheet to solve for this:

Number of periods = 30

Payment = 15,000 (should be a negative number)

Present value = 0

Future value = 1,500,000

Type = 1 (this shows that it is an annuity due because payments are at the beginning of the year).

Rate = 6.94%