Question: Question 4 (based on Chapter 4) Assume that you are planning on retiring in 30 years, and that you decide to open a retirement account

Question 4 (based on Chapter 4) Assume that you are planning on retiring in 30 years, and that you decide to open a retirement account and deposit $5,000 in the account every year (as in the previous problem, use the end of the year convention). Once you retire, you start making annual withdrawals of $40,000 from the account (again, use the end of the year convention). Assuming the account is earning 6% rate of interest, how many years will it take, after you retire, before the funds in your account are completely exhausted? Please provide a written answer in a text box at the bottom of your Excel sheet. Use Excel time value of money functions to solve the problem. (Hint: this problem needs to be modeled as two parts.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!