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
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?
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?
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?
Jane has been saving $200 in her retirement account each month for the last 20 years...
Jane has been saving $200 in her retirement account each month for the last 20 years and plans to continue contributing $200 each month for the next 20 years. Her account has been earning an 8 percent annual interest rate and she expects to earn the same rate for the next 20 years. Her twin brother, Hal, has not saved anything for the last 20 years. Due to sibling rivalry, he wants to have as much as Jane is expected...
You deposit $300 each month into an account earning 5% interest compounded monthly. a) How much...
You deposit $300 each month into an account earning 5% interest compounded monthly. a) How much will you have in the account in 30 years? $ b) How much total money will you put into the account? $ c) How much total interest will you earn? $
Jane has been saving $200 in her retirement account each month for the last 20 years...
Jane has been saving $200 in her retirement account each month for the last 20 years and plans to continue contributing $200 each month for the next 20 years. Her account has been earning an 8 percent annual interest rate and she expects to earn the same rate for the next 20 years. Her twin brother, Hal, has not saved anything for the last 20 years. Due to sibling rivalry, he wants to have as much as Jane is expected...
You deposit $300 each month into an account earning 2% annual interest compounded monthly A. How...
You deposit $300 each month into an account earning 2% annual interest compounded monthly A. How much money will you have in your account in 35 years? B. How much total money will you put into the account ? C. How much total interest will you earn?
arnold deposits 300 at the end of each month into an account that pays 14.4 compounded...
arnold deposits 300 at the end of each month into an account that pays 14.4 compounded monthly. After he has made 96 payments, arnold’s account contains 53572.25. After he made 240 payments, Arnold’s account contains 412787.15. How much interest did Arnold receive between his 96th payment and his 250th payment