In trying to apply my knowledge in the real world, I am trying to create a realistic retirement schedule. However, I am running into difficulties using both a financial calculator as well as our equations from class in doing this.

I am trying to do the following: plan a retirement schedule between the ages of 25 and 70, in which I would deposit 20% of my income each year. The income starts at 80,000 with an annual growth rate of 4% and, to be realistic, assuming an interest rate of 2.5%. I will assume for simplicity that I receive my first salary ($80,000) when I turn 25, and my last salary when I turn 70. As soon as I receive a salary, I will save 20% of it.

I would like to know (1) how much I will have in my retirement account when I turn 70, immediately after the last deposit, and (2) what single deposit made on my 25^th birthday would give the same account balance when I turn 70.

However, this raises issues, as if I try to use the equation for the present value of a growing annuity with a 4% growth rate and 2.5% discount rate, r-g will yield a negative number. Also, I could not find online how to do this on my HP 10bII+ financial calculator and I don't want to manually enter 46 payments.

Do you know how I could overcome this obstacle?

All the best,

Jimmy

Unfortunately, I forgot to reply Jimmys email and I would like to get back to him as soon as possible. I want to answer Jimmys questions using the formulas we learned in class (not the calculator or Excel). You may use the calculator or Excel for calculations, but I want to send Jimmy the formula solution. Can you help me draft a response?

1. (3 points) Start by drawing the timeline, showing the first three and the last two deposits, ie the deposits at t = 25, 26, 27, 69 and 70 (the amount of each deposit and how you calculated it).
2. (3 points) Briefly comment on Jimmys concern that if I try to use the equation for the present value of a growing annuity with a 4% growth rate and 2.5% discount rate, r-g will yield a negative number. (3 sentences at most)
3. (5 points) How much will Jimmy have in his retirement account when he turns 70, immediately after the last deposit?
4. (5 points) What single deposit made on Jimmys 25^th birthday would give the same account balance when he turns 70?