- Graphic skills
- Cases
Returns the total number of periods for an investment based on a fixed interest rate and equal installments.
SyntaxNPER(rate,pmt,pv,fv,type)
■rate is the interest rate for each period, which is a fixed value.
■pmt is the amount payable in each period, and its value remains unchanged throughout the annuity period. Typically, pmt includes principal and interest, but excludes other fees and taxes.
■pv is the present value, which is the amount of money that has been accounted for since the beginning of the investment, or the cumulative sum of the current values of a series of future payments, also called principal.
■fv is the future value, or the cash balance expected after the last payment. If fv is omitted, its value is assumed to be zero, that is, the future value of a loan is zero.
■type A number 0 or 1 that specifies whether payment is due at the beginning or end of each period.
![支付宝扫一扫](/wpcom/picture/wechat_shoukuan.jpg)
评论列表(196条)
测试