Remember Me?

#1
October 28th 04, 03:17 PM
 PatrickBurg Posts: n/a
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.

#2
October 28th 04, 03:26 PM

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Joseph Geretz Excel Discussion (Misc queries) 5 July 19th 13 03:18 PM maze2009 Excel Discussion (Misc queries) 0 January 20th 05 08:27 PM cnuk Excel Discussion (Misc queries) 2 January 17th 05 09:07 PM Richard Excel Discussion (Misc queries) 1 January 5th 05 09:36 AM Joseph Geretz Excel Discussion (Misc queries) 2 December 29th 04 04:49 PM

All times are GMT +1. The time now is 02:17 PM.