does anyone know of a formula to calculate the amount of
time it would take to payoff an installment loan if the
borrower made additional payments?

Simply add a column to your amortization schedule for the extra payments.
See a template at:
http://office.microsoft.com/template...CT010317261033

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
"mtgloanof" <(E-Mail Removed)> wrote in message
news:1ca901c3aedd$b6684cc0$(E-Mail Removed)...
> does anyone know of a formula to calculate the amount of
> time it would take to payoff an installment loan if the
> borrower made additional payments?

One way, as Jim pointed out, is to build an amortization table.

If you are simply increasing the payments, you can use NPER to determine the
revised number of periods.

If the payments are irregular (and especially if there's just a few), you
still could use financial functions to calculate your result. Whenever you
are making an irregular payment, treat it as a new loan. Use FV to calculate
the current balance on the loan, then NPER to calculate the number of
periods remaining after the additional payment.

But if you want to do a what if analysis, I'm with Jim, an amortization
table is the best way.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"mtgloanof" <(E-Mail Removed)> wrote in message
news:1ca901c3aedd$b6684cc0$(E-Mail Removed)...
> does anyone know of a formula to calculate the amount of
> time it would take to payoff an installment loan if the
> borrower made additional payments?