A couple borrows $1 Million to buy a car. The loan agreement specifies that monthly payments are to be made for four years. The annual interest rate is 12 percent. Determine the monthly payment ?
1
Expert's answer
2018-03-10T06:39:07-0500
We use financial functions of Excel: For example: PMT (12%/12; 4*12; 1,000,000) = $26 333.84, Where 12% is annual interest rate, 12%/12 is monthly interest rate, 4*12 is number of months, 1,000,000 is credit. So, monthly payment is $26 333.84
Comments
Leave a comment