Saturday, 24 October 2009

iCap completed transactions - The Winners

http://spreadsheets.google.com/pub?key=tvUBvGFsmHcpydgvtogKM9Q&output=html




Analysing the Winners:




Total = 140 transactions




Holding Periods


less than 1 year
64 transactions
Holding Period Return less than 15% = 14
Holding Period Return more than 15% = 50


exceeding 1 year
29 transactions
CAGR less than 15% = 5
CAGR more than 15% = 24


exceeding 2 year
17 transactions
CAGR less than 15% = 8
CAGR more than 15% = 9


exceeding 3 year
5 transactions
CAGR less than 15% = 3
CAGR more than 15% = 2


exceeding 4 year
8 transactions
CAGR less than 15% = 8
CAGR more than 15% = 0


exceeding 5 year
3 transactions
CAGR less than 15% = 1
CAGR more than 15% = 2


exceeding 6 year
3 transactions
CAGR less than 15% = 3
CAGR more than 15% = 0


exceeding 7 year
4 transactions
CAGR less than 15% = 4
CAGR more than 15% = 0


exceeding 8 year
3 transactions
CAGR less than 15% = 3
CAGR more than 15% = 0


exceeding 9 year
2 transactions
CAGR less than 15% = 2
CAGR more than 15% = 0


exceeding 10 year
0 transactions
CAGR less than 15% = 0
CAGR more than 15% = 0


exceeding 11 year
2 transactions
CAGR less than 15% = 0
CAGR more than 15% = 2




Findings:




Of the 140 transactions:
  • 51 (36%) have a return (HPR or CAGR) of less than 15% and
  • an amazing 89 (64%) have a return (HPR or CAGR) of more than 15%


Of those transactions giving more than 15% HPR or CAGR, 93% ( 83/89) were stocks held for less than 3 years:
  • 50 of the stocks were held for less than 1 year
  • 24 of the stocks were held for more than 1 year but less than 2 years
  • 9 stock were held for more than 2 years but less than 3 years.








Take Home Message:


1.  Of 4 stocks selected, 3 were winners and 1 was a loser.

 2.  Of the 3 winners:
  • 1 gives a CAGR of less than 15% and
  • an amazing 2 give a CAGR of greater than 15%.
 3.  Of 4 stocks selected:
  • 1 faltered,
  • 1 did fairly alright and
  • 2 did exceptionally well.

No comments: