Finally, I would like to mention that both XIRR and CAGR are utilised to determine the rate of return over a multi-year period. XIRR is essentially a modified version of CAGR.
XIRR is a useful tool when making a SIP investment. When looking at lump sum investments that were made over the course of one year, XIRR and CAGR should show comparable results.
Let’s take an example –
Investment date – 3rd Jan 2018
Investment amount – Rs.1,00,000/-
Today’s date – 3rd Jan 2020
Current value of investment – Rs.1,25,000/-
The CAGR works out to –
[1,25,000/1,00,000]^(1/2)-1
= 11.8%
If you run the XIRR function on the same set of numbers –
You reach the same conclusion. I trust you comprehend the logic behind XIRR and CAGR.
By signing up, you agree to receive transactional messages on WhatsApp. You may also receive a call from a BP Wealth representative to help you with the account opening process
Disclosures and Disclaimer: Investment in securities markets are subject to market risks; please read all the related documents carefully before investing. The securities quoted are exemplary and are not recommendatory. Past performance is not indicative of future results. Details provided in the above newsletter are for educational purposes and should not be construed as investment advice by BP Equities Pvt. Ltd. Investors should consult their investment advisor before making any investment decision. BP Equities Pvt Ltd – SEBI Regn No: INZ000176539 (BSE/NSE), IN-DP-CDSL-183-2002 (CDSL), INH000000974 (Research Analyst), CIN: U45200MH1994PTC081564. Please ensure you carefully read the Risk Disclosure Document as prescribed by SEBI | ICF
Attention Investors
Issued in the interest of Investors
Communications: When You use the Website or send emails or other data, information or communication to us, You agree and understand that You are communicating with Us through electronic records and You consent to receive communications via electronic records from Us periodically and as and when required. We may communicate with you by email or by such other mode of communication, electronic or otherwise.
Investor Alert:
BP Equities Pvt Ltd – SEBI Regn No: INZ000176539 (BSE/NSE), INZ000030431 (MCX/NCDEX), IN-DP-CDSL-183-2002 (CDSL),
INH000000974 (Research Analyst) CIN: U45200MH1994PTC081564
BP Comtrade Pvt Ltd – SEBI Regn No: INZ000030431 CIN: U45200MH1994PTC081564
For complaints, send email on investor@bpwealth.com