Manuals/calci/NPER - Revision history

Devika at 22:20, 22 August 2018

2018-08-22T22:20:44Z

Devika at 23:18, 23 July 2018

2018-07-23T23:18:26Z

Devika at 23:16, 23 July 2018

2018-07-23T23:16:51Z

Jayaram at 10:54, 14 March 2017

2017-03-14T10:54:49Z

Swapna at 18:14, 19 July 2015

2015-07-19T18:14:29Z

Devika at 17:43, 13 May 2015

2015-05-13T17:43:39Z

Devika: /* Description */

2014-02-24T08:38:53Z

Description

Devika: /* Description */

2014-02-24T08:38:06Z

Description

Devika at 08:29, 24 February 2014

2014-02-24T08:29:35Z

MassBot1: Created page with "
'''NPER'''(Rate, PaymentPeriod, PresentValue, FutureValue, Type) where, '''Rate''' - represents the interest ..."

2013-10-25T02:41:17Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''NPER'''(Rate, PaymentPeriod, PresentValue, FutureValue, Type) where, '''Rate''' - represents the interest ..."

New page

<div id="6SpaceContent" class="zcontent" align="left">

'''NPER'''(Rate, PaymentPeriod, PresentValue, FutureValue, Type)

where,

'''Rate''' - represents the interest rate.

'''PaymentPeriod''' - the payment of each period.

'''PresentValue''' - represents the present value.

'''FutureValue''' - represents the future value.

'''Type''' - represents payments due.

'''Type              Payment Due'''

0 or omitted    end of the period

1                     beginning of the period

</div>
----
<div id="1SpaceContent" class="zcontent" align="left">

It returns the number of periods for an investment based on periodic, constant interest rate and constant payments.

</div>
----
<div id="7SpaceContent" class="zcontent" align="left">

If Type other than 0 or 1, NPER returns the #ERROR.

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

NPER

</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

Lets see an example in (Column1, Row6)

<nowiki>=NPER(0.2/12, R2C1, R3C1, R4C1, R5C1)</nowiki>

NPER returns -32.01946.

Consider another example

<nowiki>=NPER(0.1/12,50,-500,52000,4)</nowiki>

It returns #ERROR.

</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| class=" SelectTD ChangeBGColor SelectTD" |
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 20%
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| class=" " | Row2
| class=" " | 800
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| Row3
| class=" " | -5000
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| class=" " | Row4
| class=" " | 23000
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| class=" " | Row5
| class="sshl_f " | 1
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row6
| class="sshl_f" | -32.01946
| class=" " |
| class=" " |
| class=" " |
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----

@@ Line 6: / Line 6: @@
 *<math> FutureValue </math> is the future value.
 *<math> Type </math> is the type.
 ==Description==

← Older revision		Revision as of 23:18, 23 July 2018
Line 1:		Line 1:
−	<div style="font-size:30px">'''NPER(r,pm,pv,fv,ty)'''</div><br/>	+	<div style="font-size:30px">'''NPER (Rate,Payment,PresentValue,FutureValue,Type)'''</div><br/>
−	~~NPER (Rate,Payment,PresentValue,FutureValue,Type)~~

	*<math>Rate </math> is the interest rate.		*<math>Rate </math> is the interest rate.

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''NPER(r,pm,pv,fv,ty)'''</div><br/>
-*<math>r </math> is the interest rate.
+NPER (Rate,Payment,PresentValue,FutureValue,Type)
-*<math> pm </math> is the amount for a period.
-*<math> pv </math> is the at present value.
+*<math>Rate </math> is the interest rate.
-*<math> fv </math> is the future value.
+*<math> Payment</math> is the amount for a period.
-*<math> ty </math> is the type.
+*<math> PresentValue </math> is the at present value.
 ==Description==
@@ Line 10: / Line 12: @@
 *It is based on the period, fixed payments and a fixed interest rate.
 *This function calculates number of periods for an investment or a loan with the assumption of constant payments at regular intervals and a fixed interest rate.
-*In <math>NPER(r,pm,pv,fv,ty)</math> , <math>r</math> is the rate of interest for the period.
+*In <math>NPER (Rate,Payment,PresentValue,FutureValue,Type)</math> , <math>Rate</math> is the rate of interest for the period.
-*Suppose we are taking  a loan for 8 percent annual interest rate and paying the amount in monthly, then the <math>r</math> value is 8%/12.
+*Suppose we are taking  a loan for 8 percent annual interest rate and paying the amount in monthly, then the <math>Rate</math> value is 8%/12.
-*So we have to enter the <math>r</math> value as  8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
+*So we have to enter the <math>Rate</math> value as  8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
-*<math>pm</math> is the fixed  payment payed in each period and there is no changes  in the life of the annuity.
+*<math>Payment</math> is the fixed  payment payed in each period and there is no changes  in the life of the annuity.
-*Normally <math>pm</math> value includes principal and interest amount but there is no other fees or taxes additionally.
+*Normally <math>Payment</math> value includes principal and interest amount but there is no other fees or taxes additionally.
-*We have to enter <math>pm</math> with negative(-) sign. <math>fv</math> is the future value of an investment or loan (the value you want to achieve at the end of all periods) when we are omitting the value of <math>fv</math> ,then it is assumed to be 0.
+*We have to enter <math>Payment</math> with negative(-) sign. <math>FutureValue</math> is the future value of an investment or loan (the value you want to achieve at the end of all periods) when we are omitting the value of <math>FutureValue</math> ,then it is assumed to be 0.
-*<math>ty</math> is the number 0 or 1 which is specifies the time to make a payment during the period.
+*<math>Type</math> is the number 0 or 1 which is specifies the time to make a payment during the period.
-*when we are not giving the value of <math>ty</math>, then it is assumed to be 0.                       .
+*when we are not giving the value of <math>Type</math>, then it is assumed to be 0.                       .
 {| class="wikitable"
 |-
-! ty value
+! Type value
 ! Explanation
 |-

← Older revision		Revision as of 10:54, 14 March 2017
Line 49:		Line 49:
	==References==		==References==
	*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_NPER_function Number of payment periods]		*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_NPER_function Number of payment periods]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 36: / Line 36: @@
 #=NPER(15%/12,-300,20000) = 144.2347824
 #=NPER(15%/12,-300,20000,500000) = 392.4483377
 ==See Also==

@@ Line 42: / Line 42: @@
 *[[Manuals/calci/PMT  | PMT ]]
 *[[Manuals/calci/PPMT  | PPMT ]]
 ==References==

@@ Line 18: / Line 18: @@
 *<math>ty</math> is the number 0 or 1 which is specifies the time to make a payment during the period.
 *when we are not giving the value of <math>ty</math>, then it is assumed to be 0.
-ty value -          Explanation
-       -              Payments are due at the end of the period.
+{| class="wikitable"
-       -              Payments are due at the beginning of the period.
+|-
 ==Examples==

Manuals/calci/NPER - Revision history

Devika at 22:20, 22 August 2018

Devika at 23:18, 23 July 2018

Devika at 23:16, 23 July 2018

Jayaram at 10:54, 14 March 2017

Swapna at 18:14, 19 July 2015

Devika at 17:43, 13 May 2015

Devika: /* Description */

Devika: /* Description */

Devika at 08:29, 24 February 2014

MassBot1: Created page with " '''NPER'''(Rate, PaymentPeriod, PresentValue, FutureValue, Type) where, '''Rate''' - represents the interest ..."

MassBot1: Created page with "
'''NPER'''(Rate, PaymentPeriod, PresentValue, FutureValue, Type) where, '''Rate''' - represents the interest ..."