Lindsay is 25 years old and has a new job in web development. Lindsay wants to make sure she is financially sound in 30 years, so she plans to invest the same amount into a retirement account at the end of every year for the next 30 years.
(a) Construct a data table in Excel that will show Lindsay the balance of her retirement account for various levels of annual investment and return. If Lindsay invests $12,000 at return of 6%, what would be the balance at the end of 20th year in the account?