ZCubes Wiki

Difference between revisions of "Manuals/calci/NPER"

(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''NPER'''(Rate, PaymentPeriod, PresentValue, FutureValue, Type) where, '''Rate''' - represents the interest ...")
 
 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''NPER (Rate,Payment,PresentValue,FutureValue,Type)'''</div><br/>
  
−
'''NPER'''(Rate, PaymentPeriod, PresentValue, FutureValue, Type)
+
*<math>Rate </math> is the interest rate.
 +
*<math> Payment</math> is the amount for a period.
 +
*<math> PresentValue </math> is the at present value.
 +
*<math> FutureValue </math> is the future value.
 +
*<math> Type </math> is the type.
 +
**NPER(),returns the number of periods for an investment.
  
−
where,
+
==Description==
 +
*This function gives the number of periods for an investment.
 +
*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 (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>Rate</math> value is 8%/12.
 +
*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>Payment</math> is the fixed  payment payed in each period and there is no changes  in the life of the annuity.
 +
*Normally <math>Payment</math> value includes principal and interest amount but there is no other fees or taxes additionally.
 +
*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>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>Type</math>, then it is assumed to be 0.                      .
 +
{| class="wikitable"
 +
|-
 +
! Type value
 +
! Explanation
 +
|-
 +
| 0
 +
| Payments are due at the end of the period
 +
|-
 +
| 1
 +
|Payments are due at the beginning of the period
 +
|}
  
−
'''Rate''' - represents the interest rate.
+
==Examples==
 +
#=NPER(14%/12,-1500,-4000,100000,1) = 46.55666767
 +
#=NPER(10%/12,-750,-2900,800000,1) = 271.42461700707
 +
#=NPER(10%/12,-750,-2900,800000,0) = 272.292024206798
 +
#=NPER(15%/12,-300,20000) = 144.2347824
 +
#=NPER(15%/12,-300,20000,500000) = 392.4483377
  
−
'''PaymentPeriod''' - the payment of each period.
+
==Related Videos==
  
−
'''PresentValue''' - represents the present value.
+
{{#ev:youtube|1s1eyiXQ9qk|280|center|NPER Function}}
  
−
'''FutureValue''' - represents the future value.
+
==See Also==
 +
*[[Manuals/calci/FV  | FV ]]
 +
*[[Manuals/calci/IPMT  | IPMT ]]
 +
*[[Manuals/calci/PMT  | PMT ]]
 +
*[[Manuals/calci/PPMT  | PPMT ]]
  
−
'''Type''' - represents payments due.
+
==References==
 +
*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_NPER_function  Number of payment periods]
  
−
'''Type              Payment Due'''
 
  
−
0 or omitted    end of the period
 
  
−
1                     beginning of the period
+
*[[Z_API_Functions | List of Main Z Functions]]
−
 
 
−
</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>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 16:20, 22 August 2018

NPER (Rate,Payment,PresentValue,FutureValue,Type)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Rate } is the interest rate.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Payment} is the amount for a period.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PresentValue } is the at present value.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FutureValue } is the future value.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Type } is the type.
    • NPER(),returns the number of periods for an investment.

Description

  • This function gives the number of periods for an investment.
  • 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NPER (Rate,Payment,PresentValue,FutureValue,Type)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Rate} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Rate} value is 8%/12.
  • So we have to enter the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Rate} value as 8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Payment} is the fixed payment payed in each period and there is no changes in the life of the annuity.
  • Normally Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Payment} value includes principal and interest amount but there is no other fees or taxes additionally.
  • We have to enter   with negative(-) sign. Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FutureValue} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FutureValue} ,then it is assumed to be 0.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Type} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Type} , then it is assumed to be 0. .
Type value Explanation
0 Payments are due at the end of the period
1 Payments are due at the beginning of the period

Examples

  1. =NPER(14%/12,-1500,-4000,100000,1) = 46.55666767
  2. =NPER(10%/12,-750,-2900,800000,1) = 271.42461700707
  3. =NPER(10%/12,-750,-2900,800000,0) = 272.292024206798
  4. =NPER(15%/12,-300,20000) = 144.2347824
  5. =NPER(15%/12,-300,20000,500000) = 392.4483377

Related Videos

NPER Function

See Also

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/NPER&oldid=211176"