Question: Problem3 You plan to start saving this year. The plan is to save $5,000 per year. But you want to decide on an annual interest
| Problem3 | ||||||||||
| You plan to start saving this year. The plan is to save $5,000 per year. | ||||||||||
| But you want to decide on an annual interest rate that is between 4% and 6% (with 0.5% increment), | ||||||||||
| and what you wll have in your saving account from 10-15 years (with 1 year increment) | ||||||||||
| Use FV() function to calculate how much you will have in your savings account. | ||||||||||
| Then use Data Tables to evaluate different scenarios | ||||||||||
| Hint: List the year and Interest rate values in the designated area | ||||||||||
| Years | ||||||||||
| $0.00 | ||||||||||
| Annual Interest Rate | ||||||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
