Question

Question 10 of 13 a. How much money do you need to invest to receive $2,300 at the end of each month for 15 months if you can
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a) Amount of money needed to be invested is calcualed using the PV function:-

=PV(rate,nper,pmt)

=PV(5%/12,15,-2300)

=33376.65

b)

Monthly payments at 20 months:-

=PMT(rate,nper,pv)

=PMT(5%/12,20,-33376.65)

=1742.81

Difference =2300-1742.81=557.19

Add a comment
Know the answer?
Add Answer to:
Question 10 of 13 a. How much money do you need to invest to receive $2,300...
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