1. Tabulate your cashflow
2. Sum up all outflow
Total investment: 3224.48+3224.48+4646.38+4377.63 = RM15,472.97
3. Sum up all holding share
Total holding share: 10000+10000+10000+24000+7500 = 61,500
4. Average cost per share: 15472.97/61500 = RM0.2516
5. Market price per share: RM0.530
6. Holding return (appreciation), from 2-Sep-06 to 22-Aug-11: (0.53-0.2516)/0.2516 = 110.65%
or, Holding return (appreciation), from 2-Sep-06 to 22-Aug-11: (32595-15472.97)/15472.97 = 110.65%
7. Sum up all your received dividend
Total dividend received: 290+386.9+585+630+631.8+891.75+889.25+889.25+889.25 = RM6,083.20
8. Holding return (dividend), from 2-Sep-06 to 22-Aug-11: 6083.20/15472.97 = 39.32%
9. Holding return (appreciation+dividend), from 2-Sep-06 to 22-Aug-11: 110.65+39.32 = 149.97%
NPV@15% = XNPV(0.15,F2:F16,A2:A16) = RM7532.12 (accepted)
IRR = XIRR(F2:F16,A2:A16) = 32.12% p.a.
