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.
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" <[email protected]> wrote in message
news:[email protected]...
>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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks