![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
CUMPRINC
快速计算应还贷款本金
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
巧用IRR函数
算内部收益率
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
PMT函数计算分期还款
每期额度
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
AMORDEGRC函数
计算财务常用的折旧值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
XIRR函数计算基金收益率
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
巧用NPV函数
一秒计算收支净额
![](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)
FV函数计算投资未来值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
巧用PV函数计算投资现值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
巧用ACCRINT函数
算定期证券利息
![](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)
巧用RATE函数求利率
![](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)
PPMT函数计算
规定期间本金偿还额
![](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)
COUPDAYBS函数
计算付息期到结算日天数
![](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)
ACCRINTM函数
到期一次性证券利息
![](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)
NPER函数计算贷款总期数
![](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)
ISPMT函数计算
特定投资期要支付利息
![](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)
XNPV函数计算
不定期收益项目净现值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)