Hi, How do we calculate the interest and payments of car loan? Any help please. Thanks Saziz
S saziz May 2, 2006 #1 Hi, How do we calculate the interest and payments of car loan? Any help please. Thanks Saziz
R renegan May 2, 2006 #2 To find payments: =PMT(Monthly Interest,Number of months to pay, Loan Amount,0,1) Assuming you start the payment at the beg of first month. To find the interest: =RATE(Number of months to pay,-Monthly payment,Loan Amount,0,1)
To find payments: =PMT(Monthly Interest,Number of months to pay, Loan Amount,0,1) Assuming you start the payment at the beg of first month. To find the interest: =RATE(Number of months to pay,-Monthly payment,Loan Amount,0,1)
