Question

- For 20 years Jenny deposits $500 at the end of each month in an
account earning 4.5% per year compounded monthly.
**How much**will she have in the account in 20 years?**How much**interest did she earn in this 20 year period?- for the next 25 years Jenny neither deposits nor withdraws any
money while the account continues to earn 4.5% per year compounded
monthly.
**How much**does Jenny have in the account after these 25 years?**How much**interest did she earn in this 25 year period?**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.)?

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

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 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 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 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 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% 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% 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 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 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 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?

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 2 minutes ago

asked 15 minutes ago

asked 23 minutes ago

asked 26 minutes ago

asked 31 minutes ago

asked 32 minutes ago

asked 58 minutes ago

asked 59 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago