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 -

jeff jeffy answered 1 year ago

Next > < Previous

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 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 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 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...

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...

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?

Suppose you save $2.5 million in your retirement account by the time you are 65. Your...

Suppose you save $2.5 million in your retirement account by the time you are 65. Your retirement account earns a return of 5.5% annually. How much can you withdraw from your account if you want your retirement account to last forever?

You want to have $1,000,000 in your retirement account 30 years from today. Your opportunity cost...

You want to have $1,000,000 in your retirement account 30 years from today. Your opportunity cost of capital is an APR of 7% with annual compounding. How much do you need to save each year if you limit yourself to 20 annual payments in years 11-30?

Subjects