ExcelBanter - Excel: Need Nper

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel: Need Nper (https://www.excelbanter.com/excel-worksheet-functions/5218-excel-need-nper.html)

PatrickBurg

Excel: Need Nper

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

"PatrickBurg" wrote in message
...
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.

All times are GMT +1. The time now is 01:49 AM.