Sunday, August 21, 2011

CAGR Calculation Sample for Stock N


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.

2 comments:

Small Cat said...

ha ha ha, who say dividend is not important.

Unknown said...


Dear Sir/ Madam

APPLICATION FORM
Do you need a quick long or short term loan with a relatively low interest rate as low as 2%? We offer Xmas loan, business loan, personal loan, home loan, auto loan, student loan, debt consolidation loan, Business loan e.t.c no matter the amount needed apply
1.NAME..........
2.SEX..........
3.AGE..........
4.CONTACT..........
5.COUNTRY..........
6.PHONE..........
7.AMOUNT NEEDED..........
8.LOAN DURATION:.........
9.PURPOSE OF LOAN..........
10.OCCUPATION..........
11.GENDER..........
12.YOUR MONTHLY INCOME..........
13.MODE OF REPAYMENT:..........,
Apply through :- DR BROWN LOAN AND INVESTMENT
The Linenhall,
32-38 Linenhall Street
BT2 8BG , Belfast
United Kingdom
brownclark176@gmail.com

DR BROWN CLARK
Director
(Field work)(On Roaming) +91828746096