Question
Pretend that you are planning on retiring in 30 years, and that you decide to open a retirement account and deposit an initial $5,000 in
Pretend that you are planning on retiring in 30 years, and that you decide to open a retirement account and deposit an initial $5,000 in the account every year (Use the end of the year convention). Once you retire, you start making annual withdrawals of $50,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 TMV 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started