Question

In: Finance

You wish to have $10 million in your retirement account at the end of 40 years....

You wish to have $10 million in your retirement account at the end of 40 years. You can invest at an annual return of 10 percent per year. a) How much should you deposit every year over the next 40 years to meet your goal? b) How much can you withdraw per year for 30 years after retirement? c) How much can you withdraw for 30 years after retirement if you wish to leave your family with a lump sum of $1 million at the end of those 30 years?

Solutions

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -


Related Solutions

If you wish to have $800 in a savings account at the end of 4 years,...
If you wish to have $800 in a savings account at the end of 4 years, and 5% interest will be paid annually, how much should you put into the savings account now?
You are planning your retirement in 10 years. You currently have $164,000 in a bond account...
You are planning your retirement in 10 years. You currently have $164,000 in a bond account and $604,000 in a stock account. You plan to add $7,600 per year at the end of each of the next 10 years to your bond account. The stock account will earn a return of 10.5 percent and the bond account will earn a return of 7 percent. When you retire, you plan to withdraw an equal amount for each of the next 21...
You are planning your retirement in 10 years. You currently have $120,000 in a bond account...
You are planning your retirement in 10 years. You currently have $120,000 in a bond account and $500,000 in a stock account. You plan to add $5,000 per year at the end of each of the next 10 years to your bond account. The stock account will earn a return of 10.5 percent and the bond account will earn a return of 7 percent. When you retire, you plan to withdraw an equal amount for each of the next 25...
You are planning on saving for retirement. You wish to retire in 40 years, and you...
You are planning on saving for retirement. You wish to retire in 40 years, and you would like to withdraw an annual sum each year to live on starting 40 years from today - You have determined that you will need $100,000 to live on (in today’s dollars) - You estimate inflation (cost of living) to be 3% - Your estimated rate of return pre-retirement is 10%; in retirement 7% Assume your life expectancy once retired is another 20 years....
You decide to start a retirement account and plan to work the next 40 years. If...
You decide to start a retirement account and plan to work the next 40 years. If you make monthly payments of $100 into a mutual fund that expects to average returns of 12% over this period, then how much will you have when you retire? Make sure to show your work--the equation you are using
You have been saving $100/month for the last 10 years in a retirement account that earns...
You have been saving $100/month for the last 10 years in a retirement account that earns 1% interest monthly. (a) How much money do you have in your retirement account today? (25 points) (b) If you STOP making contributions to your retirement account, but leave the amount you currently have in it to continue earning interest at 1% per month, how much money will you have in your retirement account when you retire in 30 years? (20 points) (c) You...
You want to retire 35 years from today with $2.5 million in your Individual Retirement Account...
You want to retire 35 years from today with $2.5 million in your Individual Retirement Account (IRA). You currently have 100,000.00 saved in your IRA which is earning 9.00% annually. What amount would you need to save and deposit at the beginning of each quarter to achieve your retirement goal? Note that you are making the deposits quarterly, not annually.
You wish to have $200,000 at the end of twenty years. In the last five years,...
You wish to have $200,000 at the end of twenty years. In the last five years, you withdraw $1,000 annually at a rate of 3.8% compounded quarterly. During the middle ten years, you contribute $500 monthly at a rate of 2.8% compounded semi-annually. Given this information, determine the initial deposit that has to be made at the start of the first five years at a rate of 4% compounded monthly.
You wish to have $250,000 at the end of twenty years. In the last five years,...
You wish to have $250,000 at the end of twenty years. In the last five years, you withdraw $1,000 annually at a rate of 3.8% compounded quarterly. During the middle ten years, you contribute $500 monthly at a rate of 2.8% compounded semi-annually. Given this information, determine the initial deposit that has to be made at the start of the first five years at a rate of 4% compounded monthly?
Assume that you have 40 years until retirement and have just started your first job. Once...
Assume that you have 40 years until retirement and have just started your first job. Once you retire, you anticipate that you will live for 30 additional years. Assume that you will require $100,000 per year to support yourself in retirement. All investments that you make will go into and stay an account that returns 7.8% per year (however much you have at retirement will sit that account and continue to accrue interest on the remaining balance. How much will...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT