Question

In: Finance

You are borrowing $5,710 to buy a car. The terms of the loan call for monthly...

You are borrowing $5,710 to buy a car. The terms of the loan call for monthly payments for 5 years at a 6.50 percent interest compounded monthly. What is the amount of each payment?

Solutions

Expert Solution

The amount of each payment is calculated using the PMT function as follows:-

=pmt(rate,nper,pv)

=PMT(6.5%/12,5*12,5710)

=111.72


Related Solutions

You are borrowing $26,750 to buy a car. The terms of the loan call for monthly...
You are borrowing $26,750 to buy a car. The terms of the loan call for monthly payments for five years at 6.50 percent interest. What is the amount of each payment? A. $498.17 B. $504.97 C. $523.39 D. $533.93 E. $566.84
You are borrowing $200,000 to buy a house. The terms of the mortgage call for monthly...
You are borrowing $200,000 to buy a house. The terms of the mortgage call for monthly payments for 30 years at 6% interest. What is the amount of each monthly payment? A. $1171.91 B. $1199.10 C. $1161.14 D. $1230.15
You took a loan to buy a new car. The monthly interest rate on the loan...
You took a loan to buy a new car. The monthly interest rate on the loan is 1.5% and you have to pay $240 every month for 60 months 1)What is the Present value of the Cash flows if its an ordinary annuity? 2)What is the future value of cash flows if its an ordinary annuity? 3)What is the present value of the cash flows if its an annuity due? 4)What is the future value of cash flows if its...
You borrow $210,000 to purchase a home. The terms of the loan call for monthly payments...
You borrow $210,000 to purchase a home. The terms of the loan call for monthly payments over 30 years at a mortgage rate of 4.50 percent. What percentage of your first 60 months' total payments go toward interest? A. 82 percent B. 66 percent C. 71 percent D. 59 percent
You took out a loan to buy a new car. The monthly interest rate on the...
You took out a loan to buy a new car. The monthly interest rate on the loan is 1%. You have to pay $270 every month for 60 months. Attempt 1/5 for 8 pts. Part 1 What is the present value of the cash flows if it's an ordinary annuity? Attempt 1/5 for 8 pts. Part 2 What is the future value of the cash flows if it's an ordinary annuity? Attempt 1/5 for 10 pts. Part 3 What is...
You buy a car for $40,000. You agree to a 72-month loan with a monthly interest...
You buy a car for $40,000. You agree to a 72-month loan with a monthly interest rate of 0.35 percent. a. What is your required monthly payment? b. What is the total amount interest payment over this period?
You just borrowed $50,000 to buy a car. You will pay back this loan with monthly...
You just borrowed $50,000 to buy a car. You will pay back this loan with monthly payments of $1,610 for 4 years. What is the APR (annual percentage rate) on this loan? What is the effective annual rate associated with an 8% nominal annual rate (r = 0.08) when interest is compounded (1) annually: (2) semiannually: (3) quarterly: (4)monthly: You negotiate a great deal and your bank agrees to lend you money for 30 years at 4% APR (annual percentage...
You buy a car for $38,000. You agree to a 60-month loan with a monthly interest...
You buy a car for $38,000. You agree to a 60-month loan with a monthly interest rate of 0.55 percent. What is your required monthly payment? Multiple Choice $745.29 $764.07 None of these choices are correct. $634.24 $605.54
​You wish to buy a car worth $27,500. The terms of the loan call for a weekly payment for 6 years at 7.5 percent rate of interest.
You wish to buy a car worth $27,500. The terms of the loan call for a weekly payment for 6 years at 7.5 percent rate of interest. If you decide to go ahead in purchasing this car what will be the amount of each payment?
You are borrowing $26,000 to buy a car. You have a choice of a 36 month...
You are borrowing $26,000 to buy a car. You have a choice of a 36 month loan at an annual interest rate of 4.1 percent or a 60 month loan where the annual interest rate is 0.5 percent higher. If you select the 60 month loan instead of the 36 month loan, how much more total dollars of interest will you pay over the life of the loan?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT