Calculating CAGR

POSTED BY Karthik ON August 28, 2012 10:39 am ONE COMMENT

Hi,

I made three transactions in my ULIP

13/01/2011 200,000 (Initial Premium)

17/08/2012 10,000 (top-up)

27/08/2012  10,000 (top-up)

Current value is 229,073.

How can I calculate CAGR with these transactions? Is there any good tool available?

One reply on this article “Calculating CAGR”

  1. Ashal Jauhari says:
    August 28, 2012 at 11:36 am

    Dear Karthik, please use the XIRR function in your exl sheet. From the given data, your CAGR is 2.76%.

    Thanks

    Ashal

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.