Amortizing Term on a loan

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I figure the amortizing term on a loan

=ABS(NPER(+K8*0.01/12,-(J8),,-O8)

This is currently the formula that is showing. This is a spreadsheet that was converted from Lotus to Excel.
 
See answer in .misc.

Posting to multiple groups is not an effective use of people's time.

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


Rachel said:
How do I figure the amortizing term on a loan?

=ABS(NPER(+K8*0.01/12,-(J8),,-O8))

This is currently the formula that is showing. This is a spreadsheet that
Click to expand...
was converted from Lotus to Excel.
 
Back
Top