Question

Ingrid wants to buy a ​$20,000 car in 7 years. How much money must she deposit...

Ingrid wants to buy a ​$20,000 car in 7 years. How much money must she deposit at the end of each quarter in an account paying ​5.1% compounded quarterly so that she will have enough to pay for her​ car?

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

The amount of deposit can be calculated with the help of PMT function of Excel:

Inputs required:

FV = 20000

PV = 0

Nper = 7 years * 4 quarters = 28 quarters

Rate = 5.10%/4 per quarter

Type = 0 (since this is an ordinary annuity)

=PMT(5.1%/4,28,0,-20000,0)

= $598.85

Quarterly payment = 598.85  

Add a comment
Know the answer?
Add Answer to:
Ingrid wants to buy a ​$20,000 car in 7 years. How much money must she deposit...
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
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
ADVERTISEMENT