Essentials of Business Analytics 1st Edition by Jeffrey Camm,James Cochran,Michael Fry,Jeffrey Ohlmann ,David Anderson

Exercise 11

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. Construct a data table that will show Lindsay the balance of her retirement account for various levels of annual investment and return. Develop the two-way table for annual investment amounts of $5,000 to $20,000 in increments of $1,000 and for returns of 0 to 12 percent in increments of 1 percent. Note that because Lindsay invests at the end of the year, there is no interest earned on that year's contribution for the year in which she contributes.