Question

In: Advanced Math

I presently have $10,000 in the bank. At the beginning of each of the next 20...

I presently have $10,000 in the bank. At the beginning of each of the next 20 years, I will invest $4,000, and I expect to earn 6% interest per year. After 20 years I pay $15,000 in closeout fees on on the investment. At the end of the investment and fees how much money will I have? (answer $108,900).

I was given the answer from the professor I just need to know how to calculate this answer on Excel with formulas.

Solutions

Expert Solution

As per the information given in the question.

Initial amount in the bank = $ 10,000

Yearly investment = $ 4,000 (for 20 years 4000$ each year)

Interest rate gained on investment = 6%

I am attaching the total investment and interest gained on it in an image:

here our total investment in 20 years = $ 80,000

Interest gained on it at the rate of 6% = $ 50,400

closeout fee at the end of 20 years = $ 15,000

hence,

dollars

formula for calculating interest is =

where I is Investment per year, R is the interest rate on investment,, n is the number of years for the investment is done.

Hope the solution is as per the requirement. If there remains any confusion, I am available to sort that out.


Related Solutions

Victor invests 300 into a bank account at the beginning of each year for 20 years....
Victor invests 300 into a bank account at the beginning of each year for 20 years. The account pays out interest at the end of every year at an annual effective interest rate of i% . The interest is reinvested at an annual effective rate of i / 2 %. The yield rate on the entire investment over the 20 year period, if he would only make deposits of 300 due is 8% annual effective. Determine i.
9. INPUT INTO TEMPLATE: I hope to have $10,000 of retirement savings in the bank by...
9. INPUT INTO TEMPLATE: I hope to have $10,000 of retirement savings in the bank by age 30. I hope to earn $34,320 per year when I’m 30. I hope to earn $38,480 per year when I’m 40. I hope to earn $42,640 per year when I’m 50. I hope to earn $46,800 per year when I’m 60. 10. I PROMISE that I WILL SAVE 15% of that salary each year, and I expect to retire at age 65. I...
If I have an investment that generates 1.5 MM during the next 20 years and We...
If I have an investment that generates 1.5 MM during the next 20 years and We know that inflation for the expected period is 5.7% on average. To what amount equivalent of constant annual payments equals those payments in a 12% annual plan with continuous compounding?
Lauren plans to deposit $5000 into a bank account at the beginning of next month and...
Lauren plans to deposit $5000 into a bank account at the beginning of next month and $200/month into the same account at the end of that month and at the end of each subsequent month for the next 5 years. If her bank pays interest at the rate of 3%/year compounded monthly, how much will Lauren have in her account at the end of 5 years? (Assume that no withdrawals are made during the 5-year period)
Lauren plans to deposit $9000 into a bank account at the beginning of next month and...
Lauren plans to deposit $9000 into a bank account at the beginning of next month and $150/month into the same account at the end of that month and at the end of each subsequent month for the next 4 years. If her bank pays interest at a rate of 5%/year compounded monthly, how much will Lauren have in her account at the end of 4 years? (Assume she makes no withdrawals during the 4-year period. Round your answer to the...
1. You have won the lottery and will receive $20,000 each year for the next 20...
1. You have won the lottery and will receive $20,000 each year for the next 20 years! A financial services company has offered you an upfront payment of $200,000 for the entire income stream. If you estimate the time value of money for you is 5%, would you accept the offer? Explain. 2. A family spends $45,000 on living expenses. If inflation averages 3% over the next 5 years, how much would the family need to spend after 5 years...
9. You have won the lottery and will receive $20,000 each year for the next 20...
9. You have won the lottery and will receive $20,000 each year for the next 20 years! A financial services company has offered you an upfront payment of $200,000 for the entire income stream. If you estimate the time value of money for you is 5%, would you accept the offer? Explain.
You are 20 years old now and you will save $10,000 annually for the next 30...
You are 20 years old now and you will save $10,000 annually for the next 30 years and the interest rate is 9%. How much money you will have when you are 50 years old? A. $1,363,075.39 B. $899,937.73 C. $1,112,577.83 D. $998,181.47 What is the PV of $2,000 to be received in 10 years at an interest rate of 8%? A. $980.25 B. $926.39 C. $783.12 D. $1,000
deposit $10,000 per year into an account at the end of each of the next 4...
deposit $10,000 per year into an account at the end of each of the next 4 years, and $15,000 into the account each year for the following 6 years. How much money will you have in the account at the end of the 10th year? Assume that we earn 10 percent nominal interest compounded annually on our investments. A. $76,319.18 B. $197,972.30 C. $130,000.00 D. $89,174.29 E. Something Else
Erin currently has $44,000 in an account. She will deposit $10,000 every other year beginning next...
Erin currently has $44,000 in an account. She will deposit $10,000 every other year beginning next year and ending nine years from today. She will have $_____ in her account 10 years from today. Assume the account pays 5% per annum.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT