Difference between revisions of "Manuals/calci/NPER"
Jump to navigation
Jump to search
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''NPER( | + | <div style="font-size:30px">'''NPER (Rate,Payment,PresentValue,FutureValue,Type)'''</div><br/> |
| − | *<math> | + | |
| − | *<math> | + | *<math>Rate </math> is the interest rate. |
| − | *<math> | + | *<math> Payment</math> is the amount for a period. |
| − | *<math> | + | *<math> PresentValue </math> is the at present value. |
| − | *<math> | + | *<math> FutureValue </math> is the future value. |
| + | *<math> Type </math> is the type. | ||
| + | **NPER(),returns the number of periods for an investment. | ||
==Description== | ==Description== | ||
| Line 10: | Line 12: | ||
*It is based on the period, fixed payments and a fixed interest rate. | *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. | *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( | + | *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> | + | *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> | + | *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> | + | *<math>Payment</math> is the fixed payment payed in each period and there is no changes in the life of the annuity. |
| − | *Normally <math> | + | *Normally <math>Payment</math> value includes principal and interest amount but there is no other fees or taxes additionally. |
| − | *We have to enter <math> | + | *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> | + | *<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> | + | *when we are not giving the value of <math>Type</math>, then it is assumed to be 0. . |
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
| − | ! | + | ! Type value |
! Explanation | ! Explanation | ||
| − | |||
|- | |- | ||
| 0 | | 0 | ||
| Line 38: | Line 38: | ||
#=NPER(15%/12,-300,20000) = 144.2347824 | #=NPER(15%/12,-300,20000) = 144.2347824 | ||
#=NPER(15%/12,-300,20000,500000) = 392.4483377 | #=NPER(15%/12,-300,20000,500000) = 392.4483377 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|1s1eyiXQ9qk|280|center|NPER Function}} | ||
==See Also== | ==See Also== | ||
| Line 45: | Line 49: | ||
*[[Manuals/calci/PPMT | PPMT ]] | *[[Manuals/calci/PPMT | PPMT ]] | ||
| + | ==References== | ||
| + | *[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 ]] | ||
Latest revision as of 16:20, 22 August 2018
NPER (Rate,Payment,PresentValue,FutureValue,Type)
- is the interest rate.
- is the amount for a period.
- is the at present value.
- is the future value.
- is the type.
- NPER(),returns the number of periods for an investment.
is the interest rate.
is the amount for a period.
is the at present value.
is the future value.
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 , 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 value is 8%/12.
- So we have to enter the value as 8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
- is the fixed payment payed in each period and there is no changes in the life of the annuity.
- Normally value includes principal and interest amount but there is no other fees or taxes additionally.
- We have to enter with negative(-) sign. 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 ,then it is assumed to be 0.
- 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 , 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
- =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
Related Videos
See Also
References