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
1. You wish to save $3500 at the end of 5 years by depositing in$200 into...
1. You wish to save $3500 at the end of 5 years by depositing in$200 into your savings account today, $400 in 1 year, $600 in 2 years, $800 in 3 years, and $900 in 4 years. What interest rate must you earn to reach to goal? Express your answers as a percentage. (Enter only numbers and decimals in your response. Round to 2 decimal places.) 2. You deposit $100 into your savings account today, $200 in 1 year, $300...
‘The rapid economic growth of China and India in the last twenty years owes much to...
‘The rapid economic growth of China and India in the last twenty years owes much to the size of theirs economies, so their experience cannot be replicated in smaller economies.’ Discuss using relevant literature and data to compare the economic performance of either China or India with one of their smaller neighbours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT