After looking at the results from questions 1. and 2. Seth realizes that a 2% return in a certificate of deposit will never allow him to reach his goal of $1 million in 10 years. Presuming his apartment will indeed be worth $400,000 in 10 years, compute the future value of Seth's $100,000 investment using a 10%, 15%, and 20% return compounded semiannually for 10 years. Will any of these rates of return allow him to accomplish his goal of reaching $1 million by age 55? (Write your answer in this cell.) Show each step taken to obtain your answer. Press ALT + Enter to insert a line break within each cell. P=P(1+r)^n R = (10%/2)/100% = 0.05 = Semiannual % rate expressed as a decimal. Fill in the information from the Case Study in cells D38 - D41, F38 - F41, and H38 - H41 for each of the investment option s. Use Excel's Future Value equation to determine his returns. Which (if any) of these rates allow him to accomplish his goal by age 55