Car loan payment calculations

  • Thread starter Thread starter saziz
  • Start date Start date
S

saziz

Hi,
How do we calculate the interest and payments of car loan?
Any help please.
Thanks
Saziz
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CUMIPMT 0
Montly payment with interest paid and balance of loan 6
Loan calculator with extra payments 2
Help to create amortization schedule 0
Interest payment 2
Calculating interest due on late loan payments 1
Quarterly payment calculation question 4
Calculate the annual payment for a $4,000 loan, 3%, 3 years, 2

Back
Top