Calculating CAGR

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


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%.



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.