Retirement Plan
Now that you have a house, it’s time for you to plan for retirement. Your plan is to take a certain amount from your salary at the end of each year and invest it in a 401(K) mutual fund. Then when you get sick of your job and want to retire, you will have a fund that you can withdraw from each year to live on.
Let’s assume you want to retire at age 60 and your life expectancy is 90.
Suppose that your 401(K) mutual fund yields an interest rate of 6.6% APR compounded annually. Determine for yourself how much money you want to invest in the 401(K) each year. This is the payment that you will make at the end of each year. Also determine at what age you want to start paying into the 401(K) investment plan. Finally, determine how much money you will need to withdraw from the fund each year to live on when you are retired. An example could be to invest $2000 each year starting at age 21 and withdraw $20,000 each year during retirement.
What must you invest each year during the accumulation phase (now until retirement) so that you will have just enough money to live on during retirement, the payout phase?
We will answer this question by creating an Excel spreadsheet that keeps track of how much money is in your 401(K) during the accumulation phase and during the payout phase (during retirement).
Age – Keeps track of your age.
Payment – Keeps track of how much you invest in the 401(K) at the end of each year. This value will stay constant until the age when you retire. Assume that you make your first payment at the end of year 1.
Interest – Keeps track of how much interest is earned during each year. Since you make your annual payments at the end of the year, the interest earned during the first year will be $0.
Balance – Keeps track of the account balance in the 401(K) at the end of the year.
Age – Keeps track of your age -starting with the retirement age. Assume that your first withdrawal takes place at the end of the last year that you worked.
Withdrawal – Keeps track of how much you take out of the 401(K) at the end of each year. This value will stay constant until the stated life expectancy age.
Interest – Keeps track of how much interest is earned during each year. Since you already calculated the interest earned during your last year of work, you do not need to add any interest for the first row of this spreadsheet.
Balance – Keeps track of the account balance in the 401(K) at the end of the year.
Hi, guys, i am stuck at this question, kindly help me; kindly show your answer in excel
Retirement Plan Now that you have a house, it’s time for you to plan for retirement....
QUESTION 5 You would like to plan for your retirement. You have gathered or assumed the following information: You just turned 30 years of age, and currently have zero savings. You plan to work until you turn 50 years old, at which time you would like to retire. During retirement, assume that you will have no sources of income other than what you can earn on the money that you have saved up for retirement. For the...
You are planning for a very early retirement. You would like to retire at age 40 and have enough money saved to be able to draw $240,000 per year for the next 30 years (based on family history you think you'll live to age 70 You plan to save for retirement by making 10 equal annual installments from age 30 to age 40 into a fairly risky investment fund that you expect will earn 14% per ar. You will leave...
Your retirement plan: You hope to retire at age 62, and according to actuarial tables, you expect to live for 20 more years. You know of an investment option that will yield 4% annually compounded continuously, and you plan to withdraw $50,000 per year in retirement, for 20 years. How much money will you need to have in the account at the beginning of retirement so that you can withdraw $50,000/year for 20 years? Begin your solution with letting R(t)...
You are planning to invest $2,000 in an account earning 10% per year for retirement. a. If you put the $2,000 in an account at age 23, and withdraw it 41 years later, how much will you have? b. If you wait 10 years before making the deposit, so that it stays in the account for only 31 years, how much will you have at the end? a. If you put the $2,000 in an account at age 23, and...
FOCUS ON SHOWING CORRECT TIMELINE! THANKS Problem: Assume you are 32 years old and plan to retire in 35 years at age 67. You are currently earning $75,000/ year and expect average annual salary increases of 4.0%year over the next 35 years. You have $0 saved for retirement. You are trying to determine how much money to save (invest) each year in your 401(k) Plan to fund your retirement in order to pay yourself 70% of your final salary each...
You are trying to decide how much to save for retirement. Assume you plan to save $5,000 per year with the first investment made one year from now. You think you can earn 5.0% per year on your investments and you plan to retire in 27 years, immediately after making your last S5,000 investment. a. How much will you have in your retirement account on the day you retire? b. If, instead of investing S5,000 per year, you wanted to...
Question 18 (3.5 points) You plan to retire 33 years from now. You expect that you will live 29 years after retiring. You want to have enough money upon reaching retirement age to withdraw $150,000 from the account at the beginning of each year you expect to live, and yet still have $2,300,000 left in the account at the time of your expected death (62 years from now). You plan to accumulate the retirement fund by making equal annual deposits...
Prepare your retirement plan as followed: A) Time periods: Estimate how long you have to save and how long you will live after stop working by stating how old you are now ( I am 24) , when you will retire( 60) , and how long you will live(80). (e.g. you are 35 years old, plan to retire at the age of 60 and expected to live until 80, which suggests 25 years of saving period and 20 years of...
You are planning your retirement in 10 years. You currently have $166,000 in a bond account and $606,000 in a stock account. You plan to add $7,400 per year at the end of each of the next 10 years to your bond account. The stock account will earn a return of 11 percent and the bond account will earn a return of 7.5 percent. When you retire, you plan to withdraw an equal amount for each of the next 24...
You are 25 years old, having just started working. You are considering a retirement plan for a retirement at the age of 65. You want to be able to withdraw $76,000 from your savings account on each birthday for 20 years following your retirement at the age of 65. Your first withdrawal will be on your 66th birthday. To achieve your goal, you intend to make equal annual deposits in a pension scheme which offers 7% interest per year. According...