Re: 有無人織如何用excel 來計供樓期數
由於反應熱烈, 所以post 個計法出來, 不過可能跟銀行俾你們的schedule 有小小different.
(A)Interest Rate : 2.875% / 12m =0.002396
(B)Loan Amount : HK$2,000,000.00
(C)Number of Installment : 20Yr x 12m=240 installment
(D)在excel計算每月供款
在插入=>涵數=>
MT
2. Mortgage Schedule
Term== Interest== Principal==Balance
1 == (A)*(B)== (D)-Interest==(B)-Principal
2 == Term 1Bal *(A)==(D)-Interest==Term 1 Balance-Principal
3 == Term 2 Bal *(A)==(D)-Interest==Term2 Balanc-Principal
Putting all your troubles on him, for he takes care of you. (Peter I 5:7)
發表於 
返回列表
