# early pay-off formula

mtgloanof
Guest
Posts: n/a

 19th Nov 2003
does anyone know of a formula to calculate the amount of
time it would take to payoff an installment loan if the

Jim
Guest
Posts: n/a

 19th Nov 2003
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

Fred Smith
Guest
Posts: n/a

 20th Nov 2003
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

"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

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post j5b9721 Microsoft Excel Worksheet Functions 0 28th Aug 2009 04:42 AM =?Utf-8?B?bGVzbGlleW9zYmU=?= Microsoft Excel Misc 2 3rd Aug 2006 05:36 PM The Dude Windows XP Help 0 23rd Dec 2003 11:47 PM Don Rain Windows XP Help 1 27th Oct 2003 05:48 AM Matt C. Microsoft Excel Worksheet Functions 1 18th Oct 2003 03:30 PM

Features