与货币时间价值有关的计算与财务函.xls

文档介绍：in D7: =D3*(1+D4)^D5
当前存款额 1200 年利息年末存 in D8: =FV(D4,D5,,-D3)
银行利率 6% 款余额 in D9: =J15
存款年限 10 0
1 in J5: =D3
存款将来值 2
存款将来值 3 in I6: =$D$4*J5 in J6: =J5+I6
存款将来值 4
5
6
7
8
9
10






当前存款额 1200
银行利率 6%
存款年限 10

存款将来值
存款将来值
存款将来值








in D7: =D3*(1+D4)^D5
当前存款额 1200 年利息年末存 in D8: =FV(D4,D5,,-D3)
银行利率 6% 款余额 in D9: =J15
存款年限 10 0
1 in J5: =D3
存款将来值 2
存款将来值 3 in I6: =$D$4*J5 in J6: =J5+I6
存款将来值 4
5
6
7
8
9
10
























in D7: =D3*(1+D4)^D5
当前存款额 1200 年利息年末存 in D8: =FV(D4,D5,,-D3)
银行利率 6% 款余额 in D9: =J15
存款年限 10 0
1 in J5: =D3
存款将来值 2
存款将来值 3 in I6: =$D$4*J5 in J6: =J5+I6
存款将来值 4
5
6
7
8















当前存款额 1200 年利息年末存
银行利率 6% 款余额
存款年限 10 0
1
存款将来值 2
存款将来值 3
存款将来值 4
5
6
7
8
9
10





in D7: =D3*(1+D4)^D5
in D8: =FV(D4,D5,,-D3)
in D9: =J15

in J5: =D3

in I6: =$D$4*J5 in J6: =J5+I6












in D7: =D3*(1+D4)^D5
当前存款额 1200 年利息年末存 in D8: =FV(D4,D5,,-D3)
银行利率 6% 款余额 in D9: =J15
存款年限 10 0
1 in J5: =D3
存款将