Excel: Need Nper

[Guest]

I'm looking for a formula that will give me the Nper (#of paments).
Assuming I have the pv (loan amount), Rate, and Payment amount. IE
I have a $75,000 loan, a 6.99% intrest rate, and a $500.00 payment. and the
calculation will give me the # of payments which is 356.28 payments
Assuming there are 12 payments per year.

 

[Paul Corrado]

Try

=NPER(0.0699/12,500,0,75000)

Where 75,000 is the FV instead of the PV