Need a formula to calculate the number of months to pay off a loan

K

kv

I need a formula to calculate the number of months it will take to pay off a
loan, given interest rate, balance and the amount of payments.
 
N

Niek Otten

Look in HELP for the NPER() function

Make sure you use monthly rate if you require number of months

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 

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

Calculating interest due on late loan payments 1
FV Function (Excel) 3
Turning off automatic calculation 0
Variable interest rate loan calculations- PLEASE HELP!!! 1
Montly payment with interest paid and balance of loan 6
[newbie] financial accounting problem 1
Interest payment 2
Looking for Compounding Interest Loan Template 1

Top