Question

In: Finance

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.

Solutions

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -


Related Solutions

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?
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 wish to have an investment that will bring about $20 000 in five years, and...
You wish to have an investment that will bring about $20 000 in five years, and the rate of return is 8% per annum. Required: a. In term of time value of money, what is the amount of $20,000 represent? b. How much do you need to invest now if the rate is compounded annually (to the nearest dollar)? c. If you have $20,000 now and put the sum into a bank account that pays 5% per year. How much...
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...
1. Suppose that over the last twenty-five years a country's nominal GDP grew to three times...
1. Suppose that over the last twenty-five years a country's nominal GDP grew to three times its former size. In the meantime, population grew by 40 percent and prices rose by 100 percent. What happened to real GDP per person? a. It more than doubled. b. It increased, but it less than doubled. c. it was unchanged. d. It decreased. the answer is b 2. Suppose an increase in the price of rubber coincides with an advance in the technology...
Rock band The Rolling Stones have played scores of concerts in the last twenty years. For...
Rock band The Rolling Stones have played scores of concerts in the last twenty years. For 30 randomly selected Rolling Stones concerts, the mean gross earnings is 2.65 million dollars. Part a) Assuming a population standard deviation gross earnings of 0.47 million dollars, obtain a 99% confidence interval for the mean gross earnings of all Rolling Stones concerts (in millions). Please carry at least three decimal places in intermediate steps. Give your answer to the nearest 3 decimal places. confidence...
Rock band The Rolling Stones have played scores of concerts in the last twenty years. For...
Rock band The Rolling Stones have played scores of concerts in the last twenty years. For 30 randomly selected Rolling Stones concerts, the mean gross earnings is 2.19 million dollars. Part a) Assuming a population standard deviation gross earnings of 0.48 million dollars, obtain a 99% confidence interval for the mean gross earnings of all Rolling Stones concerts (in millions). Please carry at least three decimal places in intermediate steps. Give your answer to the nearest 3 decimal places. Confidence...
The history of the internet Trade barrier changes in the last twenty years
The history of the internet Trade barrier changes in the last twenty years
You wish to retire in 18 years , at which time , you want to have...
You wish to retire in 18 years , at which time , you want to have accumulated enough money to receive an annuity of $500 monthly for 20 years of retirement. During the period before retirement you can earn 4% annually,while after retirement you can earn 6 percent on your money. What monthly contributions to the retirement fund will allow you to receive the 500 dollars annuity?
If you invest $200 at the end of each month for five years and you earn...
If you invest $200 at the end of each month for five years and you earn 9% interest compounded monthly, how much will you have accumulated at the end of the fifth year?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT