Question

In: Finance

You are 25 years old and plan to retire 35 year from today. You expect that...

You are 25 years old and plan to retire 35 year from today. You expect that you will live 30 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 $1,000,000 left in the account at the time of your expected death (65 years from now). You plan to accumulate the retirement fund by making equal annual deposits at the end of each year for the next 35 years. You expect that you will be able to earn 12% per year on your deposits. However, you only expect to earn 6% per year on your investment after you retire since you will choose to place the money in less risky investments. What equal annual deposits must you make each year to reach your retirement goal?

Solutions

Expert Solution

I have mentioned all known data in following time line :

To get equal installments we need to understand how much money is required at the end of 60 years . to calculate that I will use Excel .

To calculate present value at the end of year 60 of annuity payments of $150000 for 30 years at the beginning of the year and $100000 in account

Use excel function as follows

This will give us PV = $2362718.28

To calculate installments we need to make sure after 35 years we have $2362718.28 amount , thus it become Future value FV = $2362718.28.

Using excel formula as show below we get following result:

Thus we get annual installment as $ 5473 .

Note : Kindly ignore the currency sign.


Related Solutions

You are 25 years old and plan to retire 35 year from today. You expect that...
You are 25 years old and plan to retire 35 year from today. You expect that you will live 30 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 $1,000,000 left in the account at the time of your expected death (65 years from now). You plan to accumulate the retirement fund by making equal annual...
You plan to retire 35 years from now. You expect that you will live 25 years...
You plan to retire 35 years from now. You expect that you will live 25 years after retiring. You want to have enough money upon reaching retirement age to withdraw $180,000 from the account at the beginning of each year you expect to live, and yet still have $2,500,000 left in the account at the time of your expected death (60 years from now). You plan to accumulate the retirement fund by making equal annual deposits at the end of...
You are 35 years old today and are considering your retirement needs. You expect to retire...
You are 35 years old today and are considering your retirement needs. You expect to retire at age 65, and your actuarial tables suggest that you will live to be 100. You want to move to the Bahamas when you retire. You estimate that it will cost $300,000 to make the move (on your 65th birthday) and that your living expenses will be $30,000 a year (starting at the end of year 66 and continuing through the end of year...
19. You are currently 43 years old and expect to retire in 25 years, and then...
19. You are currently 43 years old and expect to retire in 25 years, and then you expect to live for another 20 years after retirement. Your current labor income is about $60,000. Assuming you have no savings, how much do you need to save from this point until retirement in order to replace 75% of your current income during retirement? (Assume no increase in wage and that your rate of interest will exceed inflation by 3%) (4 pts) 20....
Assume you are 32 years old and plan to retire in 35 years at age 67....
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 year (that increases with inflation). [Remember this is...
Assume that you are 30 years old today and expect to retire when you reach age...
Assume that you are 30 years old today and expect to retire when you reach age 65. If you were to retire today, you would like a fixed (pretax) income of $60,000 per year (in addition to Social Security) for a period of 15 years (your approximate life expectancy at age 65). However, you realize that price inflation will erode the purchasing power of the dollar over the next 35 years and you want to adjust your desired retirement income...
Assume you are now 25 years old. You plan to retire when you are 65 years...
Assume you are now 25 years old. You plan to retire when you are 65 years old. You think you will live until you are 80 years. a.) If the rate of return during your working years (a.k.a. the "savings period") is 8% and you plan to save $2,000 per year, how much will you have saved up by retirement age? b.) If the rate of return during your retirement is 6% on the amount of savings you have accumulated,...
you plan to retire in 35 years. during each year of retirement, you want to have...
you plan to retire in 35 years. during each year of retirement, you want to have an amount of money with the same prchaning powe that $50,000 has today. inflation is expected to be 3% per year form now. A. how much money do you need in the first year of retiment (35 years from todya)? round to the nearest dollar. B.  Ignore your answer to “a” and assume you need $125,000 in the first year of retirement. Call it CF1....
You plan to retire 10 years from today. Your current utility bills are $3,457 per year....
You plan to retire 10 years from today. Your current utility bills are $3,457 per year. How much will your utility bills be when you retire if utility costs are rising at 4.91% per year?
Assume that you plan to retire in 35 years and that you estimate you will need...
Assume that you plan to retire in 35 years and that you estimate you will need an income of $100,000 at the beginning of each year for 30 years, following your retirement. You also plan to donate $1,000,000 to the Georgia Southern University College of Business to endow a scholarship in the name of your favorite finance professor. You will make this endowment exactly 5 years after you retire. Assume that you will earn 11.00 percent during your working years...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT