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.
|