- Picture and text skills
- Case
Returns the total number of periods for an investment based on a fixed interest rate and equal installments.
Syntax
NPER(rate,pmt,pv,fv,type)
￭rate is the interest rate of each period, which is a fixed value.
￭pmt is the amount payable in each period An amount whose value remains constant throughout the annuity period. Usually, pmt includes principal and interest, but does not include other fees
Uses and taxes.
￭pv is the current value, that is, from the The amount of money that has been accounted for at the beginning of an investment, or the cumulative sum of the current value of a series of future payments, also called principal.
￭fv is the future value, or at the end The cash balance expected after a payment. If fv is omitted, its value is assumed to be zero, which is the future of a loan
The value is zero.
￭type number 0 or 1, used for Specify whether payment for each period is at the beginning or end of the period.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-cai-wu-han-shu-NPER-han-shu-ji-suan-dai-kuan-zong-qi-shu.html
支付宝扫一扫 
评论列表（196条）
测试