Question

For 20 years Jenny deposits $500 at the end of each month in an account earning...

  1. For 20 years Jenny deposits $500 at the end of each month in an account earning 4.5% per year compounded monthly.
    1. How much will she have in the account in 20 years?
    2. How much interest did she earn in this 20 year period?
    3. for the next 25 years Jenny neither deposits nor withdraws any money while the account continues to earn 4.5% per year compounded monthly.
      1. How much does Jenny have in the account after these 25 years?
      2. How much interest did she earn in this 25 year period?
      3. What equal amounts would she have had to deposit in the account at the end of each month for all 45 years in order to achieve the same result as in a.)?

Homework Answers

Answer #1

1. a.The formula is FV function in EXCEL

It si compounded monthly,

=FV(rate,nper,pmt,fv,0)

=FV((4.5%/12),240,-500,0,0)

FV=$194,062.18

The amount becomes $192,062.18 in 20 years

b. deposits made in 20 years=240*500=$120,000

Interest earned in 20 years=$194,062.18-$120,000=$74,062.18

c. In next 25 years, the amount becomes=$194.062.18*(1+(4.5%/12))^(25*12)

=$194.062.18*(3.073743)=$596,497.18

2.a. If it is for 25 years,

then FV=((4.5%/12),300,-500,0,0)

FV=$276,499

b.Deposits made=$500*300=$150,000

Interest earned=$276,499-$150,000=$126,499

c. To earn $276,499 in 45 years, we should make monthly deposits. We can find using PMT function in EXCEL

=PMT(rate,nper,pv,fv,type)

nper=45*12=540

pv=0

fv=$276,499

=PMT((4.5%/12),540,0,276499,0)

PMT=$158.36

He has to deposit $158.36 in every month for next 45 years to accumulate $276,499

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
If Jackson deposits $50 at the end of each month in a savings account earning interest...
If Jackson deposits $50 at the end of each month in a savings account earning interest at a rate of 3%/year compounded monthly, how much will he have on deposit in his savings account at the end of 3 years, assuming he makes no withdrawals during that period? (Round your answer to the nearest cent.)
1) You deposit $500 each month into an account earning 3% interest compounded monthly. a) How...
1) You deposit $500 each month into an account earning 3% interest compounded monthly. a) How much will you have in the account in 25 years? b) How much total money will you put into the account? c) How much total interest will you earn? 2) Suppose you invest $190 a month for 6 years into an account earning 7% compounded monthly. After 6 years, you leave the money, without making additional deposits, in the account for another 21 years....
suppose you invest $190 at the end of each month for 5 years into an account...
suppose you invest $190 at the end of each month for 5 years into an account earning 7% annual interest compounded monthly. After 5 years, you leave the money, without making additional deposits, in the account for another 21 years. How much will you have in the end?
You deposit $500 each month into an account earning 4% interest compounded monthly. How much will...
You deposit $500 each month into an account earning 4% interest compounded monthly. How much will you have in the account in 30 years? How much total money will you put into the account? How much total intrest will you earn?
. I saved $3,500 per six month period for seven years into my savings account earning...
. I saved $3,500 per six month period for seven years into my savings account earning 2% compounded annually. After the seven years, I stopped making contributions, but left the money in the bank for another five years, at 2.4% compounded annually. How much do I have in my account at the end of this twelve year period?         b) How much interest did I earn over the 12 year period? Calculate using ba 2 plus calculator
A person deposits $45 at the end of each month in an account which earns 12.5%...
A person deposits $45 at the end of each month in an account which earns 12.5% compounded monthly for 29 years. The person then stops making the deposits, but allows the money to remain in the bank earning the same interest for 15 more years. a. Find the value of this account at the end of 44 years. $   b. State the total amount of interest earned on this account.
A person deposits $275 at the end of each month in an account which earns 9.5%...
A person deposits $275 at the end of each month in an account which earns 9.5% compounded monthly for 29 years. The person then stops making the deposits, but allows the money to remain in the bank earning the same interest for 6 more years. a. Find the value of this account at the end of 35 years. $   b. State the total amount of interest earned on this account. $
You deposit $2000 in an account earning 3% interest compounded monthly How much will you have...
You deposit $2000 in an account earning 3% interest compounded monthly How much will you have in the account in 20 years? How much interest will you earn? You deposit $10,000 in an account earning 4% interest compounded monthly. How much will you have in the account in 25 years? How much interest will you earn?
6. You deposit $400 each month into an account earning 5% interest compounded monthly. a) How...
6. You deposit $400 each month into an account earning 5% interest compounded monthly. a) How much will you have in the account in 35 years? b) How much total money will you put into the account? c) How much total interest will you earn? 7. Suppose you want to have $500,000 for retirement in 25 years. Your account earns 7% interest. a) How much would you need to deposit in the account each month? b) How much interest will...
You want to make equal deposits at the end of each month for 10 years into...
You want to make equal deposits at the end of each month for 10 years into an account with annual interest rate 8% compounded monthly, and then withdraw $200 at the end of each month for the following 15 years, ending with a zero balance. How much do your monthly deposits need to be?