Question

How many monthly payments of $150 would it take to accumulate $5,000 if the payments were...

How many monthly payments of $150 would it take to accumulate $5,000 if the payments were deposited in an account paying 6% compounded monthly?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

No of monthly payments have been calculated using NPER function:-

=NPER(rate,pmt,pv,fv)

=NPER(6%/12,-150,0,5000)

=30.91 months

Add a comment
Know the answer?
Add Answer to:
How many monthly payments of $150 would it take to accumulate $5,000 if the payments were...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 4. Consider an annuity paying $150 every month at 18% compounded monthly. How many payments will...

    4. Consider an annuity paying $150 every month at 18% compounded monthly. How many payments will be necessary and what would be the ballo payment, and fractional payment (as in Example 3.6) to amount to exactly $15,000?

  • Jean receives annuity payments at the end of every six months. If she deposits these payments...

    Jean receives annuity payments at the end of every six months. If she deposits these payments in an account earning interest at 9% compounded monthly, what is the equivalent semi-annually compounded rate of interest? What sum of money must be deposited at the end of every 3 months into an account paying 6% compounded monthly to accumulate to $25,000 in 10 years? Irina deposited $150 in a savings account at the end of each month for 60 months. If the...

  • In order to accumulate enough money for a down payment on a​ house, a couple deposits...

    In order to accumulate enough money for a down payment on a​ house, a couple deposits $435 per month into an account paying 6% compounded monthly. If payments are made at the end of each​ period, how much money will be in the account in 6 ​years?

  • In order to accumulate enough money for a down payment on a house, a couple deposits...

    In order to accumulate enough money for a down payment on a house, a couple deposits $407 per month into an account paying 6% compounded monthly. If payments are made at the end of each period, how much money will be in the account in 5 years? Type the account in the account: $_______

  • Find the time, to the nearest 0.1 year. the time it would take to accumulate $10,000...

    Find the time, to the nearest 0.1 year. the time it would take to accumulate $10,000 by depositing $400 at the end of each month in an account earning 4.25% interest compounded monthly |yr Ndu

  • A) Use Excel to calculate how much would accumulate in a savings account at the end...

    A) Use Excel to calculate how much would accumulate in a savings account at the end of 5 years if the account paid 6% compound interest per year and you deposited $5,000 per year at the end of each year. explain how you calculated your answers. B) Use Excel to recalculate your answer assuming you deposited the $5,000 at the beginning of each year? explain how you calculated your answers

  • del 5629 per month into an account paying In order to accumulate enough money for a...

    del 5629 per month into an account paying In order to accumulate enough money for a down payment on a house, a couple deposits $629 per month into an account paying 3% compounded monthly. If payments are made at the end of each period, how much money will be in the account in 6 years? What is the amount in the account after 6 years? in 6 years $07 Round to the nearest cent as needed.)

  • 1. In order to accumulate enough money for a down payment on a​ house, a couple deposits $507 per month into an account...

    1. In order to accumulate enough money for a down payment on a​ house, a couple deposits $507 per month into an account paying 3% compounded monthly. If payments are made at the end of each​ period, how much money will be in the account in 5 years? 2. A company estimates that it will need $125,000 in 16 years to replace a computer. If it establishes a sinking fund by making fixed monthly payments into an account paying 3.3%...

  • Problem Set 1. A man is paying off a debt of $15,000 with regular payments of...

    Problem Set 1. A man is paying off a debt of $15,000 with regular payments of $300 at the end of each month. Annual interest is 18% compounded monthly. (a) Find the exact amount of time to at least five decimal places that it will take to pay off this loan. (b) Determine the size of the balloon payment to be made to pay off the loan at the time of the last regular payment. (c) Determine the size of...

  • Find the periodic payments PMT necessary to accumulate the given amount in an annuity account. (Assume...

    Find the periodic payments PMT necessary to accumulate the given amount in an annuity account. (Assume end-of-period deposits and compounding at the same intervals as deposits. Round your answer to the nearest cent.)$10,000 in a fund paying 7% per year, with monthly payments for 10 years PMT = $ When I was considering what to do with my $10,000 lottery winnings, my broker suggested that I invest half of it in gold, the value of which was growing by 9%...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT