POSTED BY April 18, 2014 11:41 am COMMENTS (6)ON
I googled some information about calculating XIRR and YTD and found below article useful:
Following the about link. I was trying to calculated the XIRR for the investment done in 2011 by me. The data is as below:
|15% of 4000||601.392||(15.0348*4000)/100 = 601.392|
|Diff between amt invested and final amount||312.3999||4000-3687.60015 = 312.3999|
Now the thing is that using XIRR I am getting YTD as -601 and \”difference between invested amount and final total amount is -312. I am not able to tally both amount.
I am not sure where I am wrong.. Can someone point out the mistake.