- 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.
支付宝扫一扫
评论列表（196条）
测试