Posts: 9,841
Threads: 711
Joined: Mar 2012
Reputation:
64
(27-12-2013, 09:16 PM)lvpierre Wrote: then perhaps it is possible to have a XIRR of 4.1% for 2013 alone.
The XIRR gives CAGR (Compounded Annual Growth Rate). CAGR of about 12%, means double the initial investment in 6 years.
“夏则资皮,冬则资纱,旱则资船,水则资车” - 范蠡
Posts: 1,039
Threads: 14
Joined: Dec 2012
(28-12-2013, 12:02 AM)Some-one Wrote: My XIRR for 2013 alone is 14.3%, CAGR is 45%. Not too bad for a weak year...
Nice~
Would you like to share which stock was the top contributor to your 2013 success and may I also know your CAGR is over a period of how many years? thanks ^^
Posts: 1,039
Threads: 14
Joined: Dec 2012
28-12-2013, 09:33 AM
(This post was last modified: 28-12-2013, 09:34 AM by felixleong.)
(27-12-2013, 06:06 PM)Dividend Warrior Wrote: (27-12-2013, 04:34 PM)CityFarmer Wrote: (27-12-2013, 01:56 PM)Dividend Warrior Wrote: I have keyed in all the figures into the template, and the computer tells me that the XIRR for 2013 is 4.1%
Somehow, I have a feeling I am using the excel template wrongly.....
You can troubleshoot with approach of one step at a time.
First starts with portfolio value at the start and end, XIRR return should tally with the % increment.
Next add in the dividends, the XIRR return should tally
Then add in the sale/buy transaction.
Hope it will help.
Thanks CityFarmer.
I followed your steps and re-entered all the figures. And since I am already doing it, might as well start from the beginning of my investing journey in 2010. Took me quite a while to enter all the data.
XIRR return of my portfolio from 2010 to 2013 (4-year period) is 12.2%.
12.2% is really good results over 4 years, I think that probably beat the index~ (STI i think was about 10% over the last 4 years? not sure)
Btw DW which were your top performers? any thoughts?
Posts: 2,300
Threads: 27
Joined: Jul 2012
Reputation:
41
28-12-2013, 10:28 AM
(This post was last modified: 29-12-2013, 05:29 PM by CY09.)
My Portfoilo was up approx. 38% this year.
Top performer was Superbowl which I had accumulated at an avg price of 0.487 (inclusive of brokerage fees) in Feb/Mar 2013, sold off at 0.735.
Another performer was Foreland Fabric (a remnant of my past mistakes), sold off at 0.049, bought 0.037
Posts: 657
Threads: 29
Joined: Sep 2010
Reputation:
11
I think this is a good thread for reflection.
For me portfolio return for the year is in the 17% range.
CAGR over the last 2.5 years (since I started keeping proper records) is 13+%.
I think it's important to keep proper records so the above mentioned thread on calculating XIRR is a godsend.
Last two years have been good, will next year be the same or will we see a 2011?
Only time will tell.
Posts: 2,808
Threads: 170
Joined: Sep 2010
Reputation:
1
with so many people performing so well, it will be hard to see property crash
Posts: 23
Threads: 0
Joined: Jun 2013
Reputation:
2
Since 2007 to date, my XIRR return is 12.91%.
From 17/01/2013 to 30/12/2013 my XIRR return was 11.03%.