#1   Report Post  
Old October 28th 04, 03:17 PM
PatrickBurg
 
Posts: n/a
Default 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   Report Post  
Old October 28th 04, 03:26 PM
Paul Corrado
 
Posts: n/a
Default

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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I isolate my Excel server (automation) from other Excel instances? Joseph Geretz Excel Discussion (Misc queries) 5 July 19th 13 03:18 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 08:27 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 09:07 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 09:36 AM
VB Automation is Whacking out my Excel Environment 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.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017