<< Click to Display Table of Contents >> 财务函数复制链接 |
函数 |
语法 |
说明 |
返回类型 |
---|---|---|---|
accrint |
double accrint(Object issue, Object firstIneterest, Object settlement, double rate,double par, double frequency, double basis) |
返回定期付息证券的应计利息。 |
double |
accrintm |
accrintm(Object issue, Object maturity, double rate, double par,double basis) |
返回在到期日支付利息的债券的应计利息。 |
double |
amordegrc |
amordegrc(double cost, Object date_purchased, Object first_period, double salvage, int period, double rate, intbasis) |
返回使用折旧系数的每个记帐期的折旧值。 |
double |
amorlinc |
amorlinc(double cost, Object date_purchased, Object first_period, double salvage, int period, double rate, int basis) |
返回每个记帐期的折旧值。 |
double |
coupdaybs |
coupdaybs(Object settlement, Object maturity, double frequency, int basis) |
返回从付息期开始到成交日之间的天数。 |
double |
coupdays |
coupdays(Object settlement, Object maturity, double frequency, double basis) |
返回在优惠期的天数,包括结算日期。 |
int |
coupdaysnc |
coupdaysnc(Object settlement, Object maturity, double frequency, double basis) |
返回从成交日到下一付息日之间的天数。 |
double |
coupncd |
coupncd(Object settlement, Object maturity, double frequency, double basis) |
返回成交日之后的下一个付息日。 |
date |
coupnum |
coupnum(Object settlement, Object maturity, double frequency, double basis) |
返回成交日和到期日之间的应付利息次数。 |
int |
couppcd |
couppcd(Object settlement, Object maturity, double frequency, double basis) |
返回成交日之前的上一付息日。 |
date |
cumipmt |
cumipmt(double rate, int nper, double pv, double start,double end, int type) |
返回两个付款期之间累积支付的利息。 |
double |
cumprinc |
cumprinc(double rate, int nper, double pv, double start, double end,int type) |
返回两个付款期之间为贷款累积支付的本金。 |
double |
financialDb
|
financialDb (double cost, double salvage, double life, double period, double month) |
使用固定余额递减法,返回一笔资产在给定期间内的折旧值。 |
double |
ddb |
ddb(double cost, double salvage, double life, double period, double factor) |
使用双倍余额递减法或其他指定方法,返回一笔资产在给定期间内的折旧值。 |
double |
disc |
disc(Object settlement, Object maturity, double pr, double redemption, double basis) |
返回债券的贴现率。 |
double |
duration |
duration(Object settlement, Object maturity, double coupon, double yld, double frequency, double basis) |
返回定期支付利息的债券的每年期限。 |
double |
effect |
effect(double nominal_rate, double npery) |
返回年有效利率。 |
double |
fv |
fv(double rate, int nper, double pmt, double pv, int type) |
返回一笔投资的未来值。 |
double |
fvschedule |
fvschedule(double principal, Object scheduleObj) |
返回应用一系列复利率计算的初始本金的未来值。 |
double |
intrate |
intrate(Object settlement, Object maturity, double investment,double redemption, double basis) |
返回完全投资型债券的利率。 |
double |
ipmt |
ipmt(double rate, int per, int nper, double pv, double fv, int type) |
返回一笔投资在给定期间内支付的利息。 |
double |
ispmt |
ispmt(double rate, int per, int nper, double pv) |
计算特定投资期内要支付的利息。 |
double |
mduration |
mduration(Object settlement, Object maturity, double coupon, double yld,double frequency, double basis) |
返回假设面值为¥100的有价证券的Macauley修正期限。 |
double |
mirr |
mirr(Object valuesObj, double finance_rate, double reinvest_rate) |
返回正和负现金流以不同利率进行计算的内部收益率。 |
String |
nominal |
nominal(double rate, double npery) |
返回年度的名义利率。 |
double |
nper |
nper(double rate, double pmt, double pv, double fv, int type) |
返回投资的期数。 |
double |
npv |
npv(double rate, Object valuesObj) |
返回基于一系列定期的现金流和贴现率计算的投资净现值。 |
double |
pmt |
pmt(double rate, int nper, double pv, double fv, int type) |
返回年金的定期支付金额。 |
double |
ppmt |
ppmt(double rate, int per, int nper, double pv, double fv, int type) |
返回一笔投资在给定期间内偿还的本金。 |
double |
price |
price(Object settlement, Object maturity, double rate, double yield,double redemption, double frequency, int basis) |
返回每张票面为¥100且定期支付利息的债券的现价。 |
double |
pricedisc |
pricedisc(Object settlement, Object maturity, double discount,double redemption, double basis) |
返回每张票面为¥100的已贴现债券的现价。 |
double |
pricemat |
pricemat(Object settlement, Object maturity, Object issue, double rate,double yield, double basis) |
返回每张票面为¥100且在到期日支付利息的债券的现价。 |
double |
pv |
pv(double rate, int nper, double pmt, double fv, int type) |
返回投资的现值。 |
double |
received |
received(Object settlement, Object maturity, double investment, double discount, double basis) |
返回完全投资型债券在到期日收回的金额。 |
double |
sln |
sln(double cost, double salvage, int life) |
返回固定资产的每期线性折旧费。 |
double |
syd |
syd(double cost, double salvage, double life, double per) |
资产在某一特定时期内年数总和折旧值。 |
double |
tbilleq |
tbilleq(Object settlement, Object maturity, double discount) |
返回国库券的等价债券收益。 |
double |
tbillprice |
tbillprice(Object settlement, Object maturity, double discount) |
返回面值¥100的国库券的价格。 |
double |
tbillyield |
tbillyield(Object settlement, Object maturity, double par) |
返回国库券的收益率。 |
double |
vdb |
vdb(double cost, double salvage, double life, double start_period,double end_period, double factor, boolean flag) |
使用余额递减法,返回一笔资产在给定期间或部分期间内的折旧值。 |
double |
xnpv |
xnpv(double rate, Object valuesObj, Object datesObj) |
返回一组现金流的净现值,这些现金流不一定定期发生。 |
double |
yielddisc |
yielddisc(Object settlement, Object maturity, double pr, double redemption,double basis) |
返回已贴现债券的年收益。 ➢例如:短期国库券 |
double |
yieldmat |
yieldmat(Object settlement, Object maturity, Object issue, double rate, double pr, double basis) |
返回在到期日支付利息的债券的年收益。 |
double |