sylvain wants to have $5000 in 15 years. right now he has $2000. find the compound interest rate (accurate to the nearest tenth)he needs by using the spreadsheet chart you created in the lesson.

a. change the principal of the investment to 2000.

b.Guess an interest rate, and enter it into the spreadsheet
in Other Math Topics by

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

1 Answer

I don’t have the charts the question refers to, but here’s how you work out the answer.

Your principal is $2000 and you want to grow it to $5000 in 15 years. So the growth you want is 5000/2000=2.5. To find the interest rate that would give you the amount you want you need to take the 15th root of 2.5, assuming interest is compounded annually—just once a year. You will need a calculator to do this. It comes to about 1.063. Now subtract 1, to get 0.063 then multiply by 100, to get 6.3%. That’s the compound interest rate you need.

The chart above shows interest rates on the horizontal axis up to about 9%. The curves are colour-coded according to the number of years: red=5 yrs, blue=10 yrs, green=15 yrs, purple=20 yrs, black=25 yrs. You want the green curve. And the growth value is 5000/2000=2.5. You can see that when growth=2.5 on the green line, the corresponding rate is about 6.3%.

by Top Rated User (642k points)

Related questions

Welcome to, where students, teachers and math enthusiasts can ask and answer any math question. Get help and answers to any math problem including algebra, trigonometry, geometry, calculus, trigonometry, fractions, solving expression, simplifying expressions and more. Get answers to math questions. Help is always 100% free!
82,892 questions
87,494 answers
3,936 users