Question

In: Finance

You just made your first $18,500 contribution to your retirement account. Assuming you earn 9% and...

You just made your first $18,500 contribution to your retirement account. Assuming you earn 9% and make no additional contributions, what will your account be worth when you retire in 45 years? Using Excel Functions

Solutions

Expert Solution

The Future Value of the retirement amount has been calculated with two functions in excel and the future value of the due amount at retirement will be equal to $ 894,054.793

Below are the excel worksheet showing calculations:-


The following is the Formula Sheet of the above calculated excel worksheet:-



Related Solutions

You have just made your first $5,700 contribution to your retirement account. Assuming you earn an...
You have just made your first $5,700 contribution to your retirement account. Assuming you earn an 13 percent rate of return and make no additional contributions, your retirement account will be worth $592,728 when you retire in 38 years. What will your account be worth at retirement if you had waited 7 years before making the $5,700 contribution? (Round time value factors to 6 decimal places and final answer to the nearest dollar amount)
You have just made your first $5,000 contribution to your individual retirement account.
Calculating Future Value:  You have just made your first $5,000 contribution to your individual retirement account. Assuming  you earn a 10.1 percent rate of return and make no additional contributions, what will your account be worth when your retire in 45 years? What if you wait 10 years before contributing?
You are starting to save for retirement and just made your first $1,000 contribution to your...
You are starting to save for retirement and just made your first $1,000 contribution to your retirement account. Assume you earn an 8% rate of return and make no additional contributions. What will your account be worth when you retire in 30 years?
Assume you can earn 9% per year on your investments. If you invest $100,000 for retirement...
Assume you can earn 9% per year on your investments. If you invest $100,000 for retirement at age 30, how much will you have 35 years later for retirement? (Answer: $2,041,397) If you wait until age 40 to invest the $100,000, how much will you have 25 years later for retirement? (Answer: $862,308) Why is the difference so large?
You invest $1,190,000 into a retirement account and earn 9.00% per year, compounded monthly. At retirement...
You invest $1,190,000 into a retirement account and earn 9.00% per year, compounded monthly. At retirement your account balance is $5,430,000. Over how many years did you make this investment? PLEASE ANSWER WITH EXCEL
You need $500,000 in 11 years. Assuming you earn 9% on your investments, how much must...
You need $500,000 in 11 years. Assuming you earn 9% on your investments, how much must you invest each year? Show calculations.
First, I want you to think about your retirement portfolio, and make a contribution to discussion...
First, I want you to think about your retirement portfolio, and make a contribution to discussion based on the following questions: Is it easy or difficult to estimate the risk of your overall portfolio? Have you calculated the standard deviation of your investment portfolio? Without giving details of your exact allocation, do you own now more stocks than bonds? How frequent do you adjust (rebalance) your portfolio? If you were going to make some changes now, do you think you...
You have $400,000 saved for retirement. Your account earns 9%interest. How much will you be...
You have $400,000 saved for retirement. Your account earns 9% interest. How much will you be able to pull out each month, if you want to be able to take withdrawals for 20 years?
On January 1, 2016, you deposited $5,300 in a savings account. The account will earn 9...
On January 1, 2016, you deposited $5,300 in a savings account. The account will earn 9 percent annual compound interest, which will be added to the fund balance at the end of each year. Required: 1. What will be the balance in the savings account at the end of 7 years? (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1.) (Use appropriate factor(s) from the tables provided. Round your final answers...
A) You invest RM10,000 today into retirement account. You expect to earn 11% compounded monthly, on...
A) You invest RM10,000 today into retirement account. You expect to earn 11% compounded monthly, on your money for the next 25 years. After that, you want to be more conservative, so only expect to earn 7%, compounded semiannually. How much money will you have in your account when you retire 40 years from now, assuming that this is the only deposit you make into account? B) Assume that you just won the Open Golf Championship. Your prize can be...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT