- ©«¤l
- 463
- ¥DÃD
- 116
- ºëµØ
- 0
- ¿n¤À
- 580
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-4
- ³Ì«áµn¿ý
- 2017-11-13
|
¦^´_ 29# kanawa2003
cappuccino22 «e½ú§A¦n!
¡@¡@ «e½ú!ÁÂÁ¤À¨É¦ý¬OºÃ´bªº¬O???
¦p½d¨Ò¤@
°²³]©d¤l·s«Ø¤@Ó±b¤á¨C¤ë©³¦s¤J300 ¤¸¡A
¦~§Q2.1% (§Y¤ë®§0.00175)¡A ³sÄò¦s´Ú5 ¦~¡A
¤½¦¡¡§=FV(A2,B2,-C2,D2,1)¡¨
§ë¸êªº¨ì´Á¥»ª÷¦Xp¬°¡§¢D18,994.67¡¨
³o¸Ì¬O¤ë©³¡A©Ò¥H¤½¦¡¤£¬O=FV(A2,B2,-C2,D2,0)
µª®×À³¬° 18,961.49¤£¬O¶Ü?
¦p½d¨Ò¤G
«OÀI¤½¥q¶}¿ì¤F¤@ºØ¥¦w«OÀI¡A
¨ãÅé¿ìªk¬O¤@¦¸©Êú¶O12000 ¤¸¡A
«OÀI´Á¬°20 ¦~¡C¦pªG«OÀI´Á¤º¨S¦³¥XÀI¡A
¨C¦~ªðÁÙ 1000 ¤¸¡C½Ð°Ý¦b¨S¦³¥XÀIªº±¡ªp¤U¡A
¥¦»P²{¦bªº»È¦æ§Q²v¬Û¤ñ¡A³oºØ«OÀIªº¦¬¯q²v¦p¦ó¡C
¥H¤W±Ð¾Éªº¤½¦¡=RATE(A2,B2,C2,,D2,E2)±o¨ìµª®×À³¸Ó¬O-100%
¦Ó«D¸Ó«OÀIªº¦~¦¬¯q²v¬°¡§0.06¡¨
Y¥H¤p§Ìªº©Òª¾ªº¤½¦¡=RATE(C3,C4,C5,C6,C7)
C3=20¦~ C4=¨C¦~ªðÁÙ 1000 ¤¸ C5=¤@¦¸©Êú¶O12000 ¤¸
C6=¥¼¨ÓÈ(FV=0) C7=¦~©³ªðÁÙ(type=0)
=RATE(20,1000,-12000,0,0)¦~¦¬¯q²v¬°5.45%
YC7=¦~¥XªðÁÙ(type=1)
=RATE(20,1000,-12000,0,1)¦~¦¬¯q²v¬°6.183%
¬O³o¼Ë!!¹ï¶Ü?½Ðª¾¹Dªº«e½ú,¤£§[½ç±ÐÁÂÁ¦A¤T!! |
|