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

jeff jeffy answered 1 year ago

Next > < Previous

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.

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?

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

suppose you want to have 700,000 for retirement in 35 years. your account earns 9% interest....

suppose you want to have 700,000 for retirement in 35 years. your account earns 9% interest. a how much would you need to deposit in the account each month? b how much interest will you earn

You invest $10,000 today into a retirement account. You expect to earn 11 percent, compounded monthly,...

You invest $10,000 today into a retirement account. You expect to earn 11 percent, compounded monthly, on your money for the next 25 years. After that, you want to be more conservative, so only expect to earn 7 percent, compounded semi-annually. 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 the account? A. $443,908 B. $397,062 C. $441,387 D. $483,928 E. $433,590

Subjects