1. For a review of Goal Seek, refer to Chapter 10. Without considering the random variability, extend the worksheet to 20 years. Confirm that by using the consta annual salary growth rate and the constant annual port growth rate, Tom can expect to have a 20-year portfolio $772,722. What would Tom's annual investment rate ha increase to in order for his portfolio to reach a 20-year, $1,000,000 goal? (Hint: Use Goal Seek.)