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
Get step-by-step solutions from verified subject matter experts
