| 单词 | nper | ||||||||||
| 释义 |
|
3、在"粘贴函数"对话框中，在"Nper"中输 入偿还周期5(年),在"Pmt"中输入7000(每年的回报额)，在"Pv"中输入－30000(投资金额)。 oapdf.com | 3, in the "Paste Function" [...] dialog box, in the "Nper" Enter the reimbursement [...]cycle 5 (years), in the "Pmt" enter 7000 (the [...]amount of annual return), in "Pv" type -30000 (the amount of investment) . oapdf.com |
期间数(nper)--为总投资（或贷款）期，即该项投资（或贷款）的付款期总数。 oapdf.com | During the few(nper) - foratotal [...] investment (or loan), that the investment (or loan) the total number of payment period. oapdf.com |
其中rate为各期利率，是一固定值，nper为总 投资（或贷款）期，即该项投资（或贷款）的付款期总数，pv为各期所应付给（或得到）的金额，其数值在整个年金期间（或投资期内）保持不变，通常Pv包括本金和利息，但不包括其它费用及税款，pv为现值，或一系列未来付款当前值的累积和，也称为本金，如果省略pv，则假设其值为零，type为数字0或1，用以指定各期的付款时间是在期初还是期末，如果省略t，则假设其值为零。 oapdf.com | For the period in which interest rate is a [...] fixed value, nper for a total investment [...](or loan), that the investment (or loan) [...]the total number of payment period, pv for the period due to (or receive) the amount, its value in the annuity period (during or investment) remain unchanged, Pv usually include principal and interest, but does not include other fees and taxes, pv is the present value, or a series of future payments and the current cumulative value, also known as the principal, if omitted pv, is the assumption that its value is zero, type for the number of 0 or 1, for the designated time period for payment in the beginning or end, if omitted from t, then the assumption that its value is zero. oapdf.com |
其语法形式为：PMT(rate,nper,pv,fv,type) 其中，rate为各期利率，是一固定值，nper为总投资（或贷款）期，即该项投资（或贷款）的付款期总数，pv为现值，或一系列未来付款当前值的累积和，也称为本金，fv为未来值，或在最后一次付款后希望得到的现金余额，如果省略fv，则假设其值为零（例如，一笔贷款的未来值即为零），type为0或1，用以指定各期的付款时间是在期初还是期末。 oapdf.com | The form of its syntax: [...] PMT (rate, nper, pv,fv, type) which, rate for the period of interest rate is a fixed value, nper fora total [...]investment (or loan), [...]that the investment (or loan) the payment of the total period shall, pv is the present value, or a series of future payments and the current cumulative value, also known as the principal, fv values for the future, or the last payment in the hope that the cash balance, if omitted fv, the the assumption that its value is zero (for example, a loan that is the future value of zero), type is 0 or 1, for the designated time period for payment in the beginning or end. oapdf.com |
其语法形式为CUMPRINC(rate,nper,pv,start_period,end_period,type) 其中rate为利率，nper为总付款期数，pv为现值，start_period为计算中的首期，付款期数从1开始计数，end_period为计算中的末期，type为付款时间类型。 oapdf.com | The form of its syntax [...] CUMPRINC (rate, nper, pv, start_period, end_period, type) for the interest rate which, nper payment for [...]the total number, pv [...]is the present value, start_period the first phase of the purpose of calculating the payment number from 1 the beginning of counting, end_period for the calculation of the late, type for type of payment. oapdf.com |
英汉双解词典包含2273206条英汉词条，基本涵盖了全部常用单词的翻译及用法，是英语学习的有利工具。