View Single Post
  #3   Report Post  
Myrna Larson
 
Posts: n/a
Default

The NPER function will calculate the number of periods, but it will not work
for unequal payments.

On Sat, 7 May 2005 18:11:01 -0700, "Wayneca"
wrote:

I am looking for a template that will calculate how long it will take to pay
off my credit card based on a specific interest rate and a minimum repayment.
Most of the templates I have found have a field for "Period of Loan",
however, I cannot complete this field as there is no set loan period for
credit cards. It would also be helpful if I was able to add additional
payments and it calculted the earleir payout date.