![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
PRICEMAT函数
计算到期付息债券价格
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
MDURATION函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
DURATION函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
Covariance.S函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
Covariance.P函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
DOLLARFR函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
DOLLARDE函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
DISC函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
COUPPCD函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
COUPNUM函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
COUPNCD函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
COUPDAYS函数
计算结算日付息期天数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
AMORLINC函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
COUPDAYSNC函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ISPMT函数计算
特定投资期要支付利息
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
CUMIPMT函数
两个付款期之间累计利息
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
YIELD函数计算
定期支付利息债券收益率
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
COUPDAYBS函数
计算付息期到结算日天数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
VDB函数计算
给定期间的折旧值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
XNPV函数计算
不定期收益项目净现值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
SYD函数计算折旧值
(年数总和法)
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
DB函数计算
给定期间内折旧值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
巧用SLN函数计算
线性折旧值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
巧用IPMT函数计算贷款利息
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)