question 31 It is time to buy a new car. You worked hard and want to buy an expe
ID: 2736049 • Letter: Q
Question
question 31
It is time to buy a new car. You worked hard and want to buy an expensive car (Porsche Cayenne) for $100,000. Porsche dealership will gladly finance your new purchase. However, the only way for you to be financed is to show them that you have 20% of the money needed. As soon as you have that much money in your account, the dealership will finance your new vehicle. You start saving for 52 months with the APR of 7.5%, $875 every month. That account of yours compounds interest monthly. What is the difference between the 20% that Porsche requires you to have and the amount that will actually be in your account at the end of 52 months?Explanation / Answer
we use fv formuale in excel to find it
=fv(rate,nper,pmt,pv,type)
rate=7.5%/12 (since monthly)
nper=52
pmt=875
type=0
=FV(7.5%/12,52,875,,0)=$53,568.41
amount needed at end of 52 months= 20% * car value
=20%*100,000=$20,000
difference=53,568.41-20,000
=$33,568.41
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.