Ashal,
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 ?
Thanks Ashal for your response
Dear Seenu, Ok I got it. Please use XIRR function in your exl. sheet and calculate the CAGR.
Thanks
Ashal
Ashal,
To get clear picture, visit this link and use the tool
http://ncalculators.com/investment/recurring-deposit-calculator.htm
Ashal,
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.
Thanks
Ashal