Excel 計複息

2010-11-05 11:19 pm
p.a. = 5.0%
Monthly pay = $1,000

MonthBalanceCapitalCum. Growth
3 $3,013$3,0000.4%
6 $6,063$6,0001.0%
9 $9,151$9,0001.7%
12 $12,279$12,0002.3%


用FV 在 Excel 計複息,5%pa,每月儲$1,000,一年後本息有$12,279
這計算結果正確嗎?

回答 (1)

2010-11-06 6:43 am
✔ 最佳答案
每月儲$1,000 (月初付),一年後本息有$12,330
每月儲$1,000 (月尾付),一年後本息有$12,279


收錄日期: 2021-04-13 17:37:27
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20101105000051KK00641

檢視 Wayback Machine 備份