報酬率計算 - 理財

By Susan
at 2009-10-11T17:02
at 2009-10-11T17:02
Table of Contents
每年繳25665元,共15年,總繳金額384975元
到第16年開始就不用再繳任何一毛錢
如果想在第20年領回,則可領回486015元.......
請問年化報酬率是不是:=RATE(15,25665,0,-486015,0)
用excel算為3.245%
這樣觀念及算法對嗎?
--
到第16年開始就不用再繳任何一毛錢
如果想在第20年領回,則可領回486015元.......
請問年化報酬率是不是:=RATE(15,25665,0,-486015,0)
用excel算為3.245%
這樣觀念及算法對嗎?
--
Tags:
理財
All Comments

By Edward Lewis
at 2009-10-15T12:17
at 2009-10-15T12:17

By Agnes
at 2009-10-19T14:18
at 2009-10-19T14:18

By Jack
at 2009-10-24T07:58
at 2009-10-24T07:58

By Frederica
at 2009-10-28T04:20
at 2009-10-28T04:20

By Joe
at 2009-11-01T14:56
at 2009-11-01T14:56

By Donna
at 2009-11-03T09:21
at 2009-11-03T09:21

By Robert
at 2009-11-06T13:18
at 2009-11-06T13:18

By Isabella
at 2009-11-10T15:41
at 2009-11-10T15:41

By Quanna
at 2009-11-13T18:39
at 2009-11-13T18:39

By Harry
at 2009-11-15T18:38
at 2009-11-15T18:38

By Joe
at 2009-11-20T05:46
at 2009-11-20T05:46

By Damian
at 2009-11-23T04:21
at 2009-11-23T04:21

By Enid
at 2009-11-24T05:39
at 2009-11-24T05:39

By William
at 2009-11-25T06:17
at 2009-11-25T06:17

By Thomas
at 2009-11-29T06:20
at 2009-11-29T06:20

By Agnes
at 2009-11-29T10:30
at 2009-11-29T10:30

By Oliver
at 2009-11-30T16:00
at 2009-11-30T16:00

By Gary
at 2009-12-01T06:47
at 2009-12-01T06:47

By Andrew
at 2009-12-01T21:31
at 2009-12-01T21:31

By Rachel
at 2009-12-02T18:29
at 2009-12-02T18:29

By Suhail Hany
at 2009-12-06T20:32
at 2009-12-06T20:32

By Suhail Hany
at 2009-12-07T19:07
at 2009-12-07T19:07

By Rosalind
at 2009-12-08T04:22
at 2009-12-08T04:22

By Ina
at 2009-12-12T11:58
at 2009-12-12T11:58

By William
at 2009-12-14T20:29
at 2009-12-14T20:29
Related Posts
請問這有沒有個公式呀?

By Candice
at 2009-10-11T06:11
at 2009-10-11T06:11
請問車子抵押貸款

By Anonymous
at 2009-10-11T00:09
at 2009-10-11T00:09
一銀弊案連爆 又傳理專挪用客戶存款

By Eden
at 2009-10-10T18:32
at 2009-10-10T18:32
正確的薪資分配

By Zora
at 2009-10-10T16:11
at 2009-10-10T16:11
何謂現金認股~ 收到認股繳款書意味著什 …

By Valerie
at 2009-10-10T03:33
at 2009-10-10T03:33