Question

Suppose ​$117 is deposited at the end of every month into an account earning 8.7 %...

Suppose ​$117 is deposited at the end of every month into an account earning 8.7 % per annum compounded semi-annually. If the balance in the account is to be $14,400, how many deposits are​ needed?

The number of deposits needed is__

Homework Answers

Answer #1

The number of deposits needed is 43.4

To calculate number of periods, we use NPER function in excel

=NPER (rate, pmt, pv, (FV), [type])

rate: Interest rate per period, as it is semiannual we divide by 2
pmt: amount paid each period, as it is a cash outflow it is denoted by - sign
pv - present value

fv, future value, which is the balance at the end of the period
type - [optional] When the payment is end of period, by default option is 0.

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
Ali deposited $1,400 at the end of every month into an RRSP for 8 years. The...
Ali deposited $1,400 at the end of every month into an RRSP for 8 years. The interest rate earned was 4.75% compounded semi-annually for the first 4 years and changed to 5.00% compounded monthly for the next 4 years. What was the accumulated value of the RRSP at the end of 8 years?
David deposited $500 at the end of every month into an RRSP for 8 years. The...
David deposited $500 at the end of every month into an RRSP for 8 years. The interest rate earned was 4.75% compounded semi-annually for the first 2 years and changed to 5.00% compounded monthly for the next 6 years. What was the accumulated value of the RRSP at the end of 8 years?
Sophie deposited $1,300 at the end of every month into an RRSP for 9 years. The...
Sophie deposited $1,300 at the end of every month into an RRSP for 9 years. The interest rate earned was 4.50% compounded semi-annually for the first 3 years and changed to 4.75% compounded monthly for the next 6 years. What was the accumulated value of the RRSP at the end of 9 years? ( Pls give me solution too ) thank you <3
How much will be in an account at the end of five years the amount deposited...
How much will be in an account at the end of five years the amount deposited today is $10,000 and interest is 8% per year, compounded semi-annually?
For the past 6 years Charlene Miller has made deposits of $300 at the end of...
For the past 6 years Charlene Miller has made deposits of $300 at the end of every 6 months, earning interest at 5% compounded semi-annually. If she leaves the accumulated balance in an account earning 6% compounded quarterly, what will the balance be in Charlene’s account at the end of another 10 years?
For 20 years Jenny deposits $500 at the end of each month in an account earning...
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...
Richard deposit $800 at end of every 3 months in an rrsp that is earning 5.10%...
Richard deposit $800 at end of every 3 months in an rrsp that is earning 5.10% compounded semi annually. for the RRSP to accumlate to $33000? calculate how many deposit will he have to make and long he will have to make these deposit?
John won a lottery that will pay him $500,000 at the end of each of the...
John won a lottery that will pay him $500,000 at the end of each of the next twenty years. Assuming an appropriate interest rate is 8% compounded annually, what is the present value of this amount? Assume ABC Company deposits $90,000 with First National Bank in an account earning interest at 6% per annum, compounded semi-annually. How much will ABC have in the account after five years if interest is reinvested? Lucy and Fred want to begin saving for their...
Suppose you invest $140 a month for 5 years into an account earning 6% compounded monthly....
Suppose you invest $140 a month for 5 years into an account earning 6% compounded monthly. After 5 years, you leave the money, without making additional deposits, in the account for another 26 years. How much will you have in the end?
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....