Question

Trace plans to retire in 3 years with \$518,000 in his account. If he receives payments...

Trace plans to retire in 3 years with \$518,000 in his account. If he receives payments of \$123,400 per year and he receives his first \$123,400 payment in 3 years and his last \$123,400 payment in 7 years, then what is the expected annual return for his account? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098.

Homework Answers

Answer #1

Using excel Rate function to derive the rate as in image attached.

Nper = 5 (Years 3 to 7)

PV = -518000

PMT = 123400

Type = Beginning of period

Find Rate as 9.60%

Answer = 0.0960

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

ADVERTISEMENT