5.15% | interest rate |
30 | years |
400000 | loan amount |
=PMT(A1,A2,A3) | annual payment |
=PMT(A1,A2,A3)/26 | fortnightly payment |
sunday55 发表于 2013-10-2 22:26
其实你对excel的worksheet点右键, 然后按Insert, 就可以选loan amortization schedule, 这个还可以看到你的 ...
欢迎光临 新西兰天维网社区 (http://bbs.skykiwi.com/) | Powered by Discuz! X2 |