Difference between revisions of "NPer"

Latest revision as of 00:53, 30 January 2016

NPer(rate, pmt, pv, fv, type)

Returns the number of periods of an annuity with constant periodic payments and a fixed interest rate.

Parameters:

«Rate»: Interest rate per period.
«Pmt»: Payment received per period.; If you make payments, this is a negative number.; If you receive payments, it is a positive number.
«Pv»: Present value of the annuity.; If you receive a loan, this is the loan amount as a positive number.; If you give a loan, this is the loan amount as a negative number.
«Fv»: (Optional) Future value of the annuity at the end of the annuity.; If you receive a loan, this is the final balloon payment as a negative number.; If the receive a final payment at the end, this is a positive number.
«Type»: (Optional) Indicates whether payments are at the beginning of the period.; True = Payments due at beginning of period, with first payment due immediately.; False = Payments due at end of period. (default)

@@ Line 2: / Line 2: @@
 [[Category:Doc Status D]] <!-- For Lumina use, do not change -->
-= NPer( rate,pmt,pv'', fv,type'' ) =
+== NPer(rate, pmt, pv'', fv, type'') ==
 Returns the number of periods of an annuity with constant periodic payments and a fixed interest rate.
 Parameters:
-  Rate: Interest rate per period.
+;«Rate»: Interest rate per period.
-  Pmt: Payment received per period.  If you make payments, this is a
+;«Pmt»: Payment received per period.
-       negative number.  If you receive payments, it is a positive number.
+:If you make payments, this is a negative number.
-  Pv: Present value of the annuity.  If you receive a loan, this is
+:If you receive payments, it is a positive number.
-       the loan amount as a positive number.  If you give a loan, this
+;«Pv»: Present value of the annuity.
-       is the loan amount as a negative number.
+:If you receive a loan, this is the loan amount as a positive number.
-  Fv: (Optional) Future value of the annuity at the end of the annuity.
+:If you give a loan, this is the loan amount as a negative number.
-       If you receive a loan, this is the final balloon payment as a
+;«Fv»: (Optional) Future value of the annuity at the end of the annuity.
-       negative number.  If the receive a final payment at the end, this
+:If you receive a loan, this is the final balloon payment as a negative number.
-       is a positive number.
+:If the receive a final payment at the end, this is a positive number.
-  Type: (Optional) Indicates whether payments are at the beginning of the
+;«Type»: (Optional) Indicates whether payments are at the beginning of the period.
-        period.
+:<code>True</code>  = Payments due at beginning of period, with first payment due immediately.
-        True  = Payments due at beginning of period, with first payment
+:<code>False</code> = Payments due at end of period. (default)
-                due immediately.
-        False = Payments due at end of period. (default)
+== See Also ==
+* [[Pmt]]
+* [[IPmt]]
+* [[PPmt]]
+* [[CumPrinc]]
+* [[Rate]]
+* [[Pv]]
+* [[Financial functions]]