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. Dear Karthik, please use the XIRR function in your exl sheet. From the given data, your CAGR is 2.76%.

    Thanks

    Ashal

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.

Download Our FREE Ebook!

Available only for first 100 people today

Download Our FREE Ebook!

Available only for first 100 people today