![](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)
CUMPRINC
快速计算应还贷款本金
![](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)
PMT函数计算分期还款
每期额度
![](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)
巧用PV函数计算投资现值
![](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)
FV函数计算投资未来值
![](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)
AMORDEGRC函数
计算财务常用的折旧值
![](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)
ACCRINTM函数
到期一次性证券利息
![](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)
PPMT函数计算
规定期间本金偿还额
![](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)
AMORLINC函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
DDB函数双倍余额
递减计算折旧额
![](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)
YIELD函数计算
定期支付利息债券收益率
![](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)
COUPDAYBS函数
计算付息期到结算日天数
![](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)
巧用SLN函数计算
线性折旧值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
PRICE函数
计算债券发行价格
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)