¼ÐÃD: ½Ð°Ý¦U¦ì°ª¤â¡A¹w´Á³ø¹S¦p¦ó¤âºâ [¥´¦L¥»¶]
§@ªÌ:
vic ®É¶¡: 2011-3-28 19:40 ¼ÐÃD: ½Ð°Ý¦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 ®É¶¡: 2011-3-29 11:00
¹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 ®É¶¡: 2011-3-29 11:08
ÁÙ¥H¬°n¸Ñ¤@¤¸¤K¦¸¤èµ{¦¡µ¹§Ú̬Ýù
§@ªÌ:
AngusLee ®É¶¡: 2011-3-29 19:12
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 ®É¶¡: 2011-3-29 19:22
Angus®á»¡²z²M·¡
¤£¿ù°Ú
§@ªÌ:
okpop ®É¶¡: 2011-3-30 01:18
ì©«¥Ñ <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 ®É¶¡: 2011-3-31 18:02
ÁÂÁÂAngusLee ®áªº¦^µª
Åwªï¥úÁ{ ¤Úµá¯S¯Z ¬x·ç®õ (Michael On) (http://mikeon88.freebbs.tw/) |
Powered by Discuz! 5.0.0 |