Lindsay is 25 years old and has a new job in web development. Lindsay wants to make sure that they are financially sound in 30 years. So, Lindsay plans to invest the same amount into a retirement account at the end of every year for the next 30 years. Note that because Lindsay invests at the end of the year, there is no interest earned on the contribution for the year in which Lindsay contributes.

(a)

Construct a spreadsheet model that will calculate Lindsay's retirement savings given a fixed annual amount saved and a fixed annual interest rate of return. If Lindsay invests $15,000 at an annual return of 11%, how much will be in the retirement account (in dollars) at the end of 30 years? (Round your answer to the nearest dollar.)

$ _____

(b)

Develop a 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% in increments of 1%. Using the table, what are the minimum annual investments Lindsay must contribute (in dollars) for annual rates ranging from 7% to 9% to accrue a final value of $1,300,000 after 30 years? (Round your answers up to the nearest thousand dollars.)

Annual Return	Minimum Annual Investment
7%	$ _____
8%	$ _____
9%	$ _____