Manuals/calci/NPER

From ZCubes Wiki
Revision as of 02:38, 24 February 2014 by Devika (talk | contribs) (→‎Description)
Jump to navigation Jump to search
NPER(r,pm,pv,fv,ty)


  • 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 r } 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 pm } 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 pv } 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 fv } 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 ty } is the type.

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(r,pm,pv,fv,ty)} , 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 r} 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 r} 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 r} 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 pm} 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 pm} value includes principal and interest amount but there is no other fees or taxes additionally.
  • We have to enter 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 pm} 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 fv} 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 fv} ,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 ty} 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 ty} , then it is assumed to be 0. .
ty 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

See Also


References

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