Question: Enter the values from the problem into the appropriate yellow cells and then solve for the variables in the associated blue cells. Round your answers

Enter the values from the problem into the appropriate yellow cells and then solve for the variables in the associated blue cells. Round your answers to two places after the decimal point. (1) If you want to have $300 in 8 years and you can earn an annual return of 6%, how much must you invest today? Be sure to use cell references and make sure that your answer appears as a positive value. (2) If you make a one-time deposit today of $1000 and you can earn 9% per year, how much would you have in your account after 12 years? Be sure to use cell references and remember that deposits from you are outflows. (3) If your investment of $1,254 declined to $435 in 6 years, what compounded annual rate of return would you have earned? Be sure to use cell references and to convert your answer to a percent rounded to two places after the decimal point. (4) If you can earn 5% per year, precisely how many years would it take for your investment of $450 to turn into $1,200? Be sure to use cell references and display your answer rounded to two places after the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!