October 17, 2013 11:46 am
Is it possible to calculate effective yield for CAGR ?
Thanks Ashal for your response
Dear Seenu, Ok I got it. Please use XIRR function in your exl. sheet and calculate the CAGR.
To get clear picture, visit this link and use the tool
If I invest for example Rs 200 for three years RD with the interest rate of 9 %, at the end of my 3rd year, I get returns Rs. 8283.45 for my total investment of 7200. The effective yield is 10.2% for this RD. My question is how to calculate effective yield for CAGR ?
Dear Seenu, what do you mean by effective yield for CAGR? I’m unable to understand your query.
Your email address will not be published. Required fields are marked *
Please subscribe me to your Email Newsletters
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
New here? Create an account