Using the XIRR function in excel I got a value of 47.0115%.It would be very simple to set up an equation and use the goal seek to solve for this - the answer is 56% (assuming contributions paid monthly in arrears).
I presume that the function would provide the correct answer if the investment dates were input specific to the OPs case. Would any other change be needed to clarify the in advance / in arrears scenario for the OP or is this simply based on my inputting the date as being in advance?Well I get 47% if assume contributions paid monthly in advance, so that is what the excel function XIRR is doing for you Satanta, I guess only the OP knows which one of these is the actual result then!
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?