Question

Uncle Fred recently died and left $280,000 to his 45-year-old favorite niece. She immediately spent $80,000 on a town home but decided to invest the balance for her retirement at age 65. What rate of return must she earn on her investment over the next 20 years to permit her to withdraw $75,000 at the end of each year through age 80 if her funds earn 10 percent annually during retirement

Answer 1

Answer:

6.06%

Explanation:

The computation of the rate of return is shown below:

Given that

NPER = 20 years

PV = ($280,000 - $80,000) = $200,000

PMT = $0

FV = $75,000 × PVIFA factor at 10% for 21 years

= $75,000 × 8.6487

= $648,652.50

The following formula should be applied

= RATE(NPER;PMT;-PV;FV;TYPE)

The present value comes in negative

After applying the above formula, the rate of return is 6.06%