Use Goal Seek to determine two separate changes that can be made to the Education Savings plan
Fantastic news! We've Found the answer you've been seeking!
Question:
Use Goal Seek to determine two separate changes that can be made to the Education Savings plan to increase the future value to $150,000. (Below is the data/problem worked)
Annual Salary | $73,500 |
Percent Invested | 5.00% |
Annual Return | 4.50% |
Years | 18 |
Monthly Contribution | $306.25 |
Future Value | $101,634.58 |
Related Book For
Essentials of Business Analytics
ISBN: 978-1285187273
1st edition
Authors: Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson, Dennis Sweeney, Thomas Williams
Posted Date: