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

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.

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

"kv" <kv@discussions.microsoft.com> wrote in message
news:96818DF1-A69D-44EE-9102-E0117F1E0082@microsoft.com...
>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.

There are tons of free templates at:
http://office.microsoft.com/en-us/default.aspx

kv wrote:
>
> 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.

--

Dave Peterson