Question

2. Dave’s dad is saving money for his retirement. In the last five years; he invests...

2. Dave’s dad is saving money for his retirement. In the last five years; he invests $1,800 every 6 months in a mutual fund that pays 8% compounded semi-annually. Now, the rate drops to 5.8% compounded quarterly and he wants to deposit $1,200 every quarter for another five years. How much money will he has at the end of ten years?

Homework Answers

Answer #1

First we have to find the future value for first case and can be found using FV function in EXCEL

=FV(rate,nper,pmt,pv,type)

Here the compounding is semi-annual

rate=8%/2=4%

nper=2*5=10

pmt=1800

pv=0

=FV(4%,10,-1800,0,0)

FV=$21,611

Now we have to find the future value for the second case in the same way

Here the quarterly compounding takes place

rate=5.8%/4=1.45%

nper=4*5=20

pmt=1200

pv=0

=FV(1.45%,20,-1200,0,0)

FV=$27,612.2

Now add both the furure values to find the end of 10 years value=$21611+$27612.2=$49,223.2

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
After graduating​ college, Jon finds a job and decides to start saving for retirement. He deposits...
After graduating​ college, Jon finds a job and decides to start saving for retirement. He deposits 1180 at the end of each month into a retirement account that pays 5.8​% interest compounded monthly. After 5​ years, he moves the investment to a mutual fund which pays 7.3​% compounded monthly and increases his monthly deposit to 2000. Find the amount Jon will have on deposit 5 years after that​ (10 years after​ graduation).
You wish to have $400,000 at the end of twenty-five years. In the last ten years,...
You wish to have $400,000 at the end of twenty-five years. In the last ten years, you contribute $1,000 semi-annually at a rate of 5.8% compounded monthly. During the middle ten years, you withdraw $750 quarterly at a rate of 4.5% compounded 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.
Marvin the Martian is thinking about retirement. He wants to be able to withdraw $5,450 from...
Marvin the Martian is thinking about retirement. He wants to be able to withdraw $5,450 from his retirement account every quarter for the next 15 years. If his bank pays a nominal annual rate of 6.25% compounded weekly, how much money does Marvin the Martian need to deposit in his retirement account today to be able to complete each quarterly withdrawal for the next 15 years?
Chris needs to buy a new stove in 5 years. He starts to deposit money quarterly,...
Chris needs to buy a new stove in 5 years. He starts to deposit money quarterly, with the first saving in 3 month. If his investment earns 5% APR compounded semi-annually, how much he should invest every three month to buy a $2000 stove in 5 years? (Round your answer to two decimals.)
Deryl is saving money for his retirement. Beginning one month from now, he will begin depositing...
Deryl is saving money for his retirement. Beginning one month from now, he will begin depositing a fixed amount into a retirement account that will earn 12% compounded monthly. He will make 360 such deposits. Then, one month after making his final deposit, he will start withdrawing $8,000 monthly for 25 years. The fund will continue to earn 12% companded mon hly How large should Deryl's monthly deposits be to achieve his retirement goal? A. $190 B. $214 C. $200...
Daryl wishes to save money to provide for his retirement. He is now 30 years old...
Daryl wishes to save money to provide for his retirement. He is now 30 years old and will be retiring at age 64. Beginning one month from now, he will begin depositing a fixed amount into a retirement savings account that will earn 12% compounded monthly. Then one year after making his final deposit, he will withdraw $100,000 annually for 25 years. In addition, and after he passes away (assuming he lives 25 years after retirement) he wishes to leave...
Daryl wishes to save money to provide for his retirement. He is now 30 years old...
Daryl wishes to save money to provide for his retirement. He is now 30 years old and will be retiring at age 64. Beginning one month from now, he will begin depositing a fixed amount into a retirement savings account that will earn 12% compounded monthly. Then one year after making his final deposit, he will withdraw $100,000 annually for 25 years. In addition, and after he passes away (assuming he lives 25 years after retirement) he wishes to leave...
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. The answer is $9,056.65. However, I don't know how they...
Someone who is saving for his retirement plans to deposit $100 every month, starting one month...
Someone who is saving for his retirement plans to deposit $100 every month, starting one month from now, into an investment account. If the account pays interest at 8% per year, compounded quarterly, what is the total she will have at the end of 15 years? Construct a cash flow diagram
Problem (5 marks) Daryl wishes to save money to provide for his retirement. He is now...
Problem Daryl wishes to save money to provide for his retirement. He is now 30 years old and will be retiring at age 64. Beginning one month from now, he will begin depositing a fixed amount into a retirement savings account that will earn 12% compounded monthly. Then one year after making his final deposit, he will withdraw $100,000 annually for 25 years. In addition, and after he passes away (assuming he lives 25 years after retirement) he wishes to...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT