Question

You have just visited your financial planner and decided you want to have $200,000 in your...

You have just visited your financial planner and decided you want to have $200,000 in your newborn daughter's college account by the time she is 18 years old. You feel you can start saving $400 a month right away for this. What rate of return will you need to reach your goal?

choices:

A. 6.91%
B. 8.37%
C. 9.78%
D. 10.91%
E. 11.97%

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer - Option B

A 1 FV 2 NPER 3 PMT 4 Rate 5 Annual rate B $200,000 216 months $400 0.70% monthly 8.37% annual 6B 200000 =18*12 months 1 FV 2 NPER 3 PMT 4 Rate 5 Annual rate 400 =RATE(B2,-B3,,B1) =B4*12 monthly annual

Add a comment
Know the answer?
Add Answer to:
You have just visited your financial planner and decided you want to have $200,000 in your...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT