Question

In: Finance

You would like to have $5 million dollars when you retire at age 65. You are 25 years old and you want to make your first savings payment immediately.

You would like to have $5 million dollars when you retire at age 65. You are 25 years old and you want to make your first savings payment immediately. You have not saved any money for your retirement as of yet. Assume interest rate is 7%, how much money must you set aside per year until and including your 65th birthday? How do I do this in excel?

Solutions

Expert Solution

When first savings would be made immediately than the current would be counted as the investment year.

Therefore total years of investments = 41 years

Annual Annuity required to achieve the retirement corpse = P*r/((1+r)^t - 1)

= 5,000,000*0.07/(10.7^41 -1)

= $23,298.12228

in excel just input this: "=PMT(7%,41,,5000000)"


Related Solutions

You would like to have $5 million dollars when you retire at age 65. You are 25 years old and you want to make your first savings payment immediately.
You would like to have $5 million dollars when you retire at age 65. You are 25 years old and you want to make your first savings payment immediately. You have not saved any money for your retirement as of yet. Assume interest rate is 7%, how much money must you set aside per year until and including your 65th birthday?
You would like to have $5 million dollars when you retire at age 65. You are...
You would like to have $5 million dollars when you retire at age 65. You are 25 years old and you want to make your first savings payment immediately. You have not saved any money for your retirement as of yet. Assume interest rate is 7%, how much money must you set aside per year until and including your 65th birthday?
You are now 25 years old. You would like to retire when you are 65 years old.
You are now 25 years old. You would like to retire when you are 65 years old. You want to receive starting at 65 an annual income of $150,000 per year until you are 95. How much money must you have in your retirement account when you are 65? Assume you can earn 4% per annum.
You are 30 years old and want to retire at the age of age 65 and...
You are 30 years old and want to retire at the age of age 65 and expect to live another 25 years. On the day you retire, you want to have $900,000 in your retirement savings account. a) If you invest monthly starting one month from today and your investment earns 6.0 percent per year, How much money do you need to invest every month until you retire? b) You're retired with $900,000 and you have 25 more years. You...
A client, 35 years old, who would like to retire at age 65 (30 years from...
A client, 35 years old, who would like to retire at age 65 (30 years from today). Her goal is to have enough in her retirement account to provide an income of $75,000 a year, starting a year after retirement or year 31, for 25 years thereafter. She had a late start on saving for retirement, with a current balance of $10,000. To catch up, she is now committed to saving $5,000 a year, with the first contribution a year...
You want to have $3 million in real dollars in an account when you retire in 30 years
You want to have $3 million in real dollars in an account when you retire in 30 years. The nominal return on your investment is 13 percent and the inflation rate is 3.7 percent. What real amount must you deposit each year to achieve your goal? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Deposit amount = _______ 
You are 40 years old and want to retire at age 65. Each​ year, starting one...
You are 40 years old and want to retire at age 65. Each​ year, starting one year from​ now, you will deposit an equal amount into an investment account that pays 4% interest. The last deposit will be on your 65th birthday. On your 65th birthday, you will switch the accumulated savings into a safer bank account that pays only 4.2​% interest. You will withdraw your annual income of $110,000 at the end of that year​ (on your 66th ​birthday)...
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 are 20 years old and you want to retire when you have saves$1 million....
You are 20 years old and you want to retire when you have saves $1 million. You have inherited $250,000 and will not add any other savings to that amount. The money will be conservatively invested at 6% per annum. At what age will you be able to retire a millionaire?
You want to have $2.5 million in real dollars in an account when you retire in...
You want to have $2.5 million in real dollars in an account when you retire in 40 years. The nominal return on your investment is 10.3 percent and the inflation rate is 3.7 percent.   What real amount must you deposit each year to achieve your goal? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT