QUOTE(guy3288 @ Oct 22 2015, 09:20 AM)
PS: Wanna ask yklooi and other sifus, wonder if my earlier mentioned of Summary IRR 10%
was falsely elevated due to this new purchase Global Titans?? That would be bad as it does not reflect true returns.
If strictly to the defination and usage of IRR (Internal Rate of Return), answer is no.was falsely elevated due to this new purchase Global Titans?? That would be bad as it does not reflect true returns.
IRR is on a series of purchases at various times, and it is the common returns on each purchase.
(When the annualised rate is on a single purchase, CAGR (Compound Annual Growth Rate) is the term; to avoid abuse and confusion btw IRR and CAGR.)
The following figures as an example; with the purchases in negative, and their respective current values:
1/1/2014 1/10/2015 -1000 1150
1/6/2014 1/10/2015 -500 575
1/1/2015 1/10/2015 -500 575
1/6/2015 1/10/2015 -500 575
1/9/2015 1/10/2015 -1000 1150
Note that each of the purchases have the same growth/return/ROI of 15%.
Their respective CAGR will be, using 1/10/2015 as the current date:
8.32%
11.04%
20.55%
51.91%
447.63%
And the IRR is 16.71%.
Q. Does the 16.71% reflect the "true returns"?
A. There is no such thing as "true". IRR is the common representative figure that when applies to each purchases, it will gives the sum of all the returns.
In other words, if the CAGR of each purchase is 16.71%, the current value of the whole portfolio after some calculations will add up to 4025.
Clear?
============
The IRR was calculated using excel function XIRR. The formula is: =XIRR(C1:D5,A1:B5), where A1:B5 are the dates, and C1:D5 are the purchase costs and their respective current values.
Oct 22 2015, 06:38 PM

Quote
0.0285sec
0.17
6 queries
GZIP Disabled