意見反饋
義工

自由講場 今日: 3998|主題: 1009065

查看: 1040 | 回覆: 1
請問複式利息(compound interest)点計回報?


複式洋房

國民生產總值:254


發表於 09-3-10 11:28 |顯示全部帖子
我的銀行户口是派複式利息 (日日複式), 但我想知我可以點樣計D利息回報呢?

e.g $10萬, 0.31厘, 一個月後, 即係有幾多?

我想同定期比較吓, 邊樣多D?

thanks


大宅

國民生產總值:2106

好媽媽勳章


發表於 09-3-10 11:44 |顯示全部帖子
原帖由 4607 於 09-3-10 11:28 發表
我的銀行户口是派複式利息 (日日複式), 但我想知我可以點樣計D利息回報呢?

e.g $10萬, 0.31厘, 一個月後, 即係有幾多?

我想同定期比較吓, 邊樣多D?

thanks ...


$10萬 * (1+每日利息)(to the power of number of days)

$10萬, 每日0.31%利息, 31日後=$11007.06

or用Excel計:

100001.003110031
100311.003110062.1
10062.11.003110093.29
10093.291.003110124.58
10124.581.003110155.96
10155.961.003110187.45
10187.451.003110219.03
10219.031.003110250.71
10250.711.003110282.48
10282.481.003110314.36
10314.361.003110346.33
10346.331.003110378.41
10378.411.003110410.58
10410.581.003110442.85
10442.851.003110475.23
10475.231.003110507.7
10507.71.003110540.27
10540.271.003110572.95
10572.951.003110605.73
10605.731.003110638.6
10638.61.003110671.58
10671.581.003110704.66
10704.661.003110737.85
10737.851.003110771.14
10771.141.003110804.53
10804.531.003110838.02
10838.021.003110871.62
10871.621.003110905.32
10905.321.003110939.13
10939.131.003110973.04
10973.041.003111007.06


  • 搜 尋
  • APP
  • 網 站
© Baby-Kingdom.com Limited. All rights reserved.