| fv(rate, nperopen in new window, pmtopen in new window, pvopen in new window[, when]) | 计算未来值。 |
| pvopen in new window(rate, nper, pmt[, fv, when]) | 计算现值。 |
| npvopen in new window(rate, values) | 返回现金流系列的NPV(净现值)。 |
| pmtopen in new window(rate, nper, pv[, fv, when]) | 根据贷款本金加利息计算付款。 |
| ppmtopen in new window(rate, per, nper, pv[, fv, when]) | 根据贷款本金计算付款。 |
| ipmtopen in new window(rate, per, nper, pv[, fv, when]) | 计算付款的利息部分。 |
| irropen in new window(values) | 返回内部收益率(IRR)。 |
| mirropen in new window(values, finance_rate, reinvest_rate) | 修改后的内部收益率。 |
| nperopen in new window(rate, pmt, pv[, fv, when]) | 计算定期付款的数量。 |
| rateopen in new window(nper, pmt, pv, fv[, when, guess, tol, …]) | 计算每个期间的利率。 |
