accrint

返回定期付息证券的应计利息

double

double accrint(Object issue, Object firstIneterest, Object settlement, double rate,double par, double frequency, double basis)

accrintm

返回在到期日支付利息的债券的应计利息

double

accrintm(Object issue, Object maturity, double rate, double par,double basis)

amordegrc

返回使用折旧系数的每个记帐期的折旧值

double

amordegrc(double cost, Object date_purchased, Object first_period,

double salvage, int period, double rate, intbasis)

amorlinc

返回每个记帐期的折旧值

double

amorlinc(double cost, Object date_purchased, Object first_period,

double salvage, int period, double rate, int basis)

coupdaybs

返回从付息期开始到成交日之间的天数

double

coupdaybs(Object settlement, Object maturity, double frequency, int basis)

coupdays

返回在优惠期的天数，包括结算日期

int

coupdays(Object settlement, Object maturity, double frequency, double basis)

coupdaysnc

返回从成交日到下一付息日之间的天数

double

coupdaysnc(Object settlement, Object maturity, double frequency, double basis)

coupncd

返回成交日之后的下一个付息日

date

coupncd(Object settlement, Object maturity, double frequency, double basis)

coupnum

返回成交日和到期日之间的应付利息次数

int

coupnum(Object settlement, Object maturity, double frequency, double basis)

couppcd

返回成交日之前的上一付息日

date

couppcd(Object settlement, Object maturity, double frequency, double basis)

cumipmt

返回两个付款期之间累积支付的利息

double

cumipmt(double rate, int nper, double pv, double start,double end, int type)

cumprinc

返回两个付款期之间为贷款累积支付的本金

double

cumprinc(double rate, int nper, double pv, double start, double end,int type)

financialDb

使用固定余额递减法，返回一笔资产在给定期间内的折旧值

double

financialDb

(double cost, double salvage, double life, double period, double month)

ddb

使用双倍余额递减法或其他指定方法，返回一笔资产在给定期间内的折旧值

double

ddb(double cost, double salvage, double life, double period, double factor)

disc

返回债券的贴现率

double

disc(Object settlement, Object maturity, double pr, double redemption, double basis)

duration

返回定期支付利息的债券的每年期限

double

duration(Object settlement, Object maturity, double coupon, double yld, double frequency, double basis)

effect

返回年有效利率

double

effect(double nominal_rate, double npery)

fv

返回一笔投资的未来值

double

fv(double rate, int nper, double pmt, double pv, int type)

fvschedule

返回应用一系列复利率计算的初始本金的未来值

double

fvschedule(double principal, Object scheduleObj)

intrate

返回完全投资型债券的利率

double

intrate(Object settlement, Object maturity, double investment,double redemption, double basis)

ipmt

返回一笔投资在给定期间内支付的利息

double

ipmt(double rate, int per, int nper, double pv, double fv, int type)

ispmt

计算特定投资期内要支付的利息

double

ispmt(double rate, int per, int nper, double pv)

mduration

返回假设面值为 ￥100 的有价证券的 Macauley 修正期限

double

mduration(Object settlement, Object maturity, double coupon, double yld,double frequency, double basis)

mirr

返回正和负现金流以不同利率进行计算的内部收益率

String

mirr(Object valuesObj, double finance_rate, double reinvest_rate)

nominal

返回年度的名义利率

double

nominal(double rate, double npery)

nper

返回投资的期数

double

nper(double rate, double pmt, double pv, double fv, int type)

npv

返回基于一系列定期的现金流和贴现率计算的投资的净现值

double

npv(double rate, Object valuesObj)

pmt

返回年金的定期支付金额

double

pmt(double rate, int nper, double pv, double fv, int type)

ppmt

返回一笔投资在给定期间内偿还的本金

double

ppmt(double rate, int per, int nper, double pv, double fv, int type)

price

返回每张票面为 ￥100 且定期支付利息的债券的现价

double

price(Object settlement, Object maturity, double rate, double yield,double redemption, double frequency, int basis)

pricedisc

返回每张票面为 ￥100 的已贴现债券的现价

double

pricedisc(Object settlement, Object maturity, double discount,double redemption, double basis)

pricemat

返回每张票面为 ￥100 且在到期日支付利息的债券的现价

double

pricemat(Object settlement, Object maturity, Object issue, double rate,double yield, double basis)

pv

返回投资的现值

double

pv(double rate, int nper, double pmt, double fv, int type)

received

返回完全投资型债券在到期日收回的金额

double

received(Object settlement, Object maturity, double investment, double discount, double basis)

sln

返回固定资产的每期线性折旧费

double

sln(double cost, double salvage, int life)

syd

资产在某一特定时期内年数总和折旧值

double

syd(double cost, double salvage, double life, double per)

tbilleq

返回国库券的等价债券收益

double

tbilleq(Object settlement, Object maturity, double discount)

tbillprice

返回面值 ￥100 的国库券的价格

double

tbillprice(Object settlement, Object maturity, double discount)

tbillyield

返回国库券的收益率

double

tbillyield(Object settlement, Object maturity, double par)

vdb

使用余额递减法，返回一笔资产在给定期间或部分期间内的折旧值

double

vdb(double cost, double salvage, double life, double start_period,double end_period, double factor, boolean flag)

xnpv

返回一组现金流的净现值，这些现金流不一定定期发生

double

xnpv(double rate, Object valuesObj, Object datesObj)

yielddisc

返回已贴现债券的年收益；例如，短期国库券

double

yielddisc(Object settlement, Object maturity, double pr, double redemption,double basis)

yieldmat

返回在到期日支付利息的债券的年收益

double

yieldmat(Object settlement, Object maturity, Object issue, double rate, double pr, double basis)