Wednesday, September 29, 2010

四厘補貼計算Excel

四厘補貼計算Excel下載:
http://traderant.com/loans/Loan amortization schedule1 chinese version.xls
http://traderant.com/loans/Loan amortization schedule2 chinese version.xls

使用手冊:
- 先開 Loan amortization schedule2 chinese version
- 然後 Loan amortization schedule1 chinese version
- Loan amortization schedule2 chinese version 是不用看的,但要開,因為有連結
- 綠色格是可變的.其他會自動計算
- 可自行假設未來最優惠利率, "於最優惠利率Sheet中可以改"
- 格M1鍵按下會假設最優惠利率全期為5%, 格N1鍵按下則會用於"最優惠利率Sheet"中的假設
- 總供款金額要看 "總貸款Sheet"
- 如有問題,歡迎賜教
Posted by at
Labels:

6 comments:

  1. UnknownNovember 9, 2009 at 8:02 AM

    我有個問題呀....個兩個file既連結唔可以同步更新到呀? 有咩方法可以fix呢?

    ReplyDelete
  2. Earnings TraderNovember 10, 2009 at 10:51 AM

    我剛TRY過,沒問題.
    你是 Loan amortization schedule2 chinese version 連不到至 Loan amortization schedule1 chinese version?

    ReplyDelete
  3. Earnings TraderNovember 10, 2009 at 10:57 AM

    我更新了連結,你可以再TRY TRY

    ReplyDelete
  4. UnknownNovember 11, 2009 at 7:32 AM

    大部份已經OK喇...不過Loan amortization schedule1 chinese version 1 既Sheet"總貸款" 好似都仲未更新到
    可以幫忙再睇下嗎?
    你既effort令好多業主受惠呀...thanks

    ReplyDelete
  5. UnknownNovember 11, 2009 at 7:36 AM

    同埋sheet "非政府補貼部份" 既 I4:I13 都未OK呀好似

    ReplyDelete
  6. Earnings TraderNovember 11, 2009 at 10:21 AM

    you can try again. But 可能是你EXCEL的連結SETTING問題.

    ReplyDelete

Subscribe to: Post Comments (Atom)