• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

10 Year Rolling XIRR in Excel.

R

Retrieval2915

New Member
Dear Expert Members I have Sensex Monthly Price Data going back to 1979 and I want to calculate 10 Year Rolling XIRR of it. The cashflows will be many inflows of 1000 and one big outflow of all the previous values. I am having issues with doing this as the second to last value has to be a inflow, in this case the second to last value is the big outflow due to me doing rolling XIRR but if I modify that to be a inflow of 1000 the previous 10 Year Rolling XIRR will be gone. I could just do Paste Values on the previous rolling XIRR to keep the value but this will be tedious process so I want to know how to calculate 10 Year Rolling XIRR in Excel.

Thanks.
 

Attachments

  • Rolling XIRR - Copy.xlsx
    52.7 KB · Views: 9
You must log in or register to reply here.
Back
Top