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

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

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

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 56 seconds ago

asked 56 seconds ago

asked 2 minutes ago

asked 2 minutes ago

asked 2 minutes ago

asked 2 minutes ago

asked 4 minutes ago

asked 6 minutes ago

asked 7 minutes ago

asked 7 minutes ago

asked 9 minutes ago

asked 9 minutes ago