¹C«È:
µù¥U
|
µn¿ý
|
·|û
¤Úµá¯S¯Z ¬x·ç®õ (Michael On)
»
°Q½×°Ï1
» ½Ð°Ý¦U¦ì°ª¤â¡A¹w´Á³ø¹S¦p¦ó¤âºâ
§ë²¼
¥æ©ö
Äa½à
¬¡°Ê
¥´¦L
|
±ÀÂË
|
q¾\
|
¦¬ÂÃ
¼ÐÃD: ½Ð°Ý¦U¦ì°ª¤â¡A¹w´Á³ø¹S¦p¦ó¤âºâ
vic
¦P¾Ç
UID 172
ºëµØ 0
¿n¤À 0
©«¤l 2
¾\ŪÅv 99
µù¥U 2011-3-18
¥Î¤áµù¥U¤Ñ¼Æ 4759
¥Î¤á¥¢ÂÜ¤Ñ¼Æ 4720
219.71.231.10
#1
¤À¨É
µoªí©ó 2011-3-28 19:40
¸ê®Æ
¨p¤H°T®§
½Ð°Ý¦U¦ì°ª¤â¡A¹w´Á³ø¹S¦p¦ó¤âºâ
¦U¦ì°ª¤â¦³¤H¥i¥Hºâ¤@®a¤½¥qªº¹w´Á³ø¹Sµ¹§Ú¬Ý¶Ü¡]¤p§Ì·M²Â¡^¡H¥Lªº¶Q»P«U¥u³æ¤@¬Ý¥»¯q¤ñªº¦h¤Ö¿¶Ü¡H
AngusLee
(Angus)
¦P¾Ç
UID 5
ºëµØ 0
¿n¤À 0
©«¤l 322
¾\ŪÅv 99
µù¥U 2011-3-16
¥Î¤áµù¥U¤Ñ¼Æ 4761
¥Î¤á¥¢ÂÜ¤Ñ¼Æ 735
¨Ó¦Û ªá½¬
61.60.215.21
#2
µoªí©ó 2011-3-29 11:00
¸ê®Æ
¥D¶
¨p¤H°T®§
¹w´Á³ø¹S²v«ç»òºâ
¨þ¨þ¡A³o¤p°ÝÃD¥æµ¹§Ú
º¥ý©Ò¿×ªº¥Î¤âºâ¬O¥ÎEXCELºâ!
²Ä¤@¨B¡A½T»{¶R¤J»ù
¨Ò¦p§A¤¤¿û¶R20¤¸
²Ä¤@®æ´N¼g -20
¨S¿ù¬Otªº
²Ä¤G¨B¡A¹w¦ô¨C¤@¦~ªºªÑ®§
¨Ò¦p¤¤¿û¨C¦~ªÑ®§2¤¸
°²³]«ù¦³4¦~
²Ä¤G®æ~²Ä¤®æ³£¿é¤J2¤¸
²Ä¤T¨B¡A¹w¦ô²Ä¤K¦~ªÑ»ù¦h¤Ö¤¸
¨Ò¦p¥|¦~«á¤¤¿ûªÑ»ù50¤¸
´N§â50¤¸¥[¶i¥h²Ä¥|¦~ªºªÑ®§=52¤¸
©Ò¥H¤®æ¼Æ¦r±Æ¦C¤U¨Ó·|¬O
¢Ï
¢°¡@-20
¢±¡@2
¢²¡@2
¢³¡@2
¢´¡@52
¦A¨ÓÀH«K¦b¤@ӪŮæ³B¿é¤J"=IRR(A1:A5)"
´N·|ºâ¥XIRR=33%(¹w´Á³ø¹S²v)
¤]´N¬O¥|¦~¥§¡¦~³ø¹S²v33%
³o¤@©Û¥i¥Hpºâ¥ô¦ó§ë¸ê¤è¦¡
¨Ò¦p§ë¸ê©Ð¦a²£¥X¯²¤p®M©Ð
¶R¤J»ù=200¸U
¨C¦~©Ð¯²¦¬¤J=10¸U
¤¦~«á©Ð»ù=300¸U
-200
10
10
10
10
310
¥§¡¦~³ø¹S²vIRR=13%
mikeon88
ºÞ²zû
UID 1
ºëµØ 0
¿n¤À 0
©«¤l 15453
¾\ŪÅv 255
µù¥U 2007-1-14
¥Î¤áµù¥U¤Ñ¼Æ 6284
¥Î¤á¥¢ÂÜ¤Ñ¼Æ 0
114.42.223.15
#3
µoªí©ó 2011-3-29 11:08
¸ê®Æ
¥D¶
¤å¶°
¨p¤H°T®§
ÁÙ¥H¬°n¸Ñ¤@¤¸¤K¦¸¤èµ{¦¡µ¹§Ú̬Ýù
AngusLee
(Angus)
¦P¾Ç
UID 5
ºëµØ 0
¿n¤À 0
©«¤l 322
¾\ŪÅv 99
µù¥U 2011-3-16
¥Î¤áµù¥U¤Ñ¼Æ 4761
¥Î¤á¥¢ÂÜ¤Ñ¼Æ 735
¨Ó¦Û ªá½¬
61.60.215.21
#4
µoªí©ó 2011-3-29 19:12
¸ê®Æ
¥D¶
¨p¤H°T®§
mike¯u¬O»¡¯º¤F...
¦Ü©ó¶Q«U«ç»ò»{©w
´Nn¹B¥ÎNPVpºâ²b²{ÈÅo
¦P¼ËªºÃD¥Ø...
¤¤¿û¨C¦~°t®§2¤¸
¹w¦ô¥|¦~«áªÑ»ù50¤¸
Y±ý«ù¦³4¦~¡A¥B¦~¥§¡³ø¹S²v¹F15%
À³¸Ó¦b´X¤¸¥H¤º¶R¶i©O?
¦P¼Ë¦bEXCELpºâ¡A¨Ã¦Cªí¦p¤U
.....¢Ï
¢°..2
¢±..2
¢²..2
¢³..52
¦bªÅ¥Õ³B¿é¤J¡@=NPV(15%, A1:A4)
·|±o¨ì34.3¤¸
³o´N¬O«U»ù¤F
¶Q»ù´N¬O±N¢°¢´¢H§ï¦¨¢¯¢H¡D¡D
¹ï¤F¡A¤W±¼ÆȬҬ°°²³]¡A¦Ü©ó¨C¦~ªÑ®§¸ò´X¦~«á½æ¥X»ù
³q³q³£¥i¥H¹B¥ÎNAV¡AROE¡AEPS¡A°t®§¡A°t®§²v¡A¥»¯q¤ñ¡A¥h±À¦ô!!
³o¨Ç¦b¬Õ¦bªíªº¯µ±K¤pªá¶éùر...
<¥»¤å¦P®Éµo¥¬©ó³¡¸¨®æ>
mikeon88
ºÞ²zû
UID 1
ºëµØ 0
¿n¤À 0
©«¤l 15453
¾\ŪÅv 255
µù¥U 2007-1-14
¥Î¤áµù¥U¤Ñ¼Æ 6284
¥Î¤á¥¢ÂÜ¤Ñ¼Æ 0
114.42.203.60
#5
µoªí©ó 2011-3-29 19:22
¸ê®Æ
¥D¶
¤å¶°
¨p¤H°T®§
Angus®á
»¡²z²M·¡
¤£¿ù°Ú
okpop
·|û
UID 235
ºëµØ 0
¿n¤À 0
©«¤l 16
¾\ŪÅv 10
µù¥U 2011-3-22
¥Î¤áµù¥U¤Ñ¼Æ 4755
¥Î¤á¥¢ÂÜ¤Ñ¼Æ 4536
112.105.106.20
#6
µoªí©ó 2011-3-30 01:18
¸ê®Æ
¤å¶°
¨p¤H°T®§
QUOTE:
ì©«¥Ñ <i>AngusLee</i> ©ó 2011-3-29 19:12 µoªí<br />
mike¯u¬O»¡¯º¤F...<br />
<br />
¦Ü©ó¶Q«U«ç»ò»{©w<br />
´Nn¹B¥ÎNPVpºâ²b²{ÈÅo<br />
¦P¼ËªºÃD¥Ø...<br />
¤¤¿û¨C¦~°t®§2¤¸<br />
¹w¦ô¥|¦~«áªÑ»ù50¤¸<br />
Y±ý«ù¦³4¦~¡A¥B¦~¥§¡³ø¹S²v¹F15%<br />
À³¸Ó¦b´X¤¸¥H¤º¶R¶i©O?<br />
<br />
¦P¼Ë¦bEXCELpºâ¡A¨Ã¦C ...
<br />
¦pªG¦³Ægªº¸Ü
§Ú·Qµ¹§A«ö¤@Ó
vic
¦P¾Ç
UID 172
ºëµØ 0
¿n¤À 0
©«¤l 2
¾\ŪÅv 99
µù¥U 2011-3-18
¥Î¤áµù¥U¤Ñ¼Æ 4759
¥Î¤á¥¢ÂÜ¤Ñ¼Æ 4720
219.71.231.10
#7
µoªí©ó 2011-3-31 18:02
¸ê®Æ
¨p¤H°T®§
ÁÂÁÂ
AngusLee
®áªº¦^µª
§ë²¼
¥æ©ö
Äa½à
¬¡°Ê
Powered by
Discuz!
© Comsenz Inc.
ÀËÁ|½×¾Â