Jenna believes she could easily set aside $3000 of her $45,000 salary. She is considering putting her savings in a stock fund. She just turned 22 and has a long way to go until retirement at age 65, and she considers this risk level reasonable. The fund she is looking at has earned an average of 9% over the past 15 years and could be expected to continue earning this amount, on average. Jenna expects her salary to grow regularly. While there are no guarantees, she believes an increase of 4% a year is reasonable. She plans to save $3000 the first year, and then increase the amount she saves by 4% each year as her salary grows. Unfortunately, prices will also grow due to inflation.

Suppose Jenna assumes there will be 3% inflation every year. In retirement, she will need to increase her withdrawals each year to keep up with inflation. In this case, how much can she withdraw at the end of the first year of her retirement? What amount does this correspond to in today s dollars? (Hint: Build a spreadsheet in which you track the amount in her retirement account each year.) Use excel functions to justify your answers.