- UID
- 223397
- 帖子
- 276
- 主题
- 21
- 注册时间
- 2011-7-11
- 最后登录
- 2014-8-7
|
9#
发表于 2011-7-13 16:10
| 只看该作者
FYI.
I also had the same doubts, so I did the following calculation in excel using PMT functions. Hope it helps
number of years N annual interest rate I/Y FV PV type PMT
10 120 8% 0.00667 1 -1 0 $0.00667 $0.0800 annual interest rate
10 120 8% 0.00667 -1 0 0 $0.00547 $0.0656 sinking fund factor
10 120 8% 0.00667 0 -1 0 $0.01213 $0.1456 annual mortgage cost
for a better visibility, you could save the following as a csv file and open it in excel:
number of years,N,annual interest rate,I/Y,FV,PV,type,PMT,,
10,120,8%,0.00667,1,-1,0,$0.00667 ,$0.0800 ,annual interest rate
10,120,8%,0.00667,-1,0,0,$0.00547 ,$0.0656 ,sinking fund factor
10,120,8%,0.00667,0,-1,0,$0.01213 ,$0.1456 ,annual mortgage cost |
|