It’s a hot summer day, and your teacher just introduced the concept of percentages in your mathematics class. You feel empowered because all those weird symbols and rush at the shopping malls during discount seasons start to make sense. A few months pass by, and a chapter called profit and loss is introduced and brings with it the concept of money. Now you could calculate how much money a shopkeeper makes on a particular investment and what would be loss or profit margin for the same using simple arithmetic operations. The returns calculated through this method are known as absolute returns but this method has problems that render it unusable in real-world investments. This blog focuses on countering that problem.

Absolute returns are a great way to show *how much has the money grown?* But fails to answer *how this money has grown? *I.e., it does not consider the time for which the money remained invested. This can be an essential factor for a long-term investor to compare different companies or funds.

CAGR is the compounded annual growth rate of an investment.

CAGR answers the question, *how has the money grown? *by including the component of time in its calculation. It is one of the best methods to calculate the returns on a lumpsum investment. It gives a much more realistic picture of annual returns than its counterpart annualized returns.

**CAGR=VfinalVinitial1t-1**

CAGR might be great for the calculation of returns on a lumpsum investment but fails in the case of a periodic investment like SIP or RD as it doesn’t take into account the time for which a fraction of money stays in the market and instead treats the entire corpus as a one-time investment.

The XIRR gives a single rate of return when applied on all the investments and yields the current investment amount.The IRR(Internal Rate of Return) solves the problem of determining how the investment has grown in the case of investments distributed over a period of time. However, the IRR can only be used to calculate the returns on investments done at regular intervals, which might not be the case in many scenarios. XIRR solves this problem and can consider all the assets and withdrawals done at regular or irregular periods.

Calculating XIRR is much more complex than the other returns, and thus, investment advisors and even CAs use excel for calculating the same.

Calculating XIRR is much more complex than the other returns, and thus, investment advisors and even CAs use excel for calculating the same.

Date | Amount |
---|---|

10-01-2020 | -1000 |

10-02-2020 | -1000 |

10-03-2020 | -1000 |

10-04-2020 | -1000 |

10-05-2020 | -1000 |

10-06-2020 | -1000 |

10-07-2020 | -1000 |

10-08-2020 | -1000 |

10-09-2020 | -1000 |

10-10-2020 | -1000 |

10-11-2020 | -1000 |

10-12-2020 | -1000 |

10-01-2021 | -1000 |

10-02-2021 | 14500 |

Total | 20.097% |

**Steps:**

- Make a column each for date and amount.
- Put a negative sign on the invested amount and a positive signal on the received return.
- Select any other cell and type
*“=xirr(“entire amount range”,” date range”)”* - Format the cell as a percentage to get the XIRR.

To understand these terms better, let’s take an example of a regular monthly SIP in a hypothetical fund and calculate the absolute return, CAGR, and XIRR at the time of redemption.

Date | Investment (INR) |
---|---|

26-01-2020 | 10,000 |

26-02-2020 | 2,000 |

26-03-2020 | 2,000 |

26-04-2020 | 2,000 |

26-05-2020 | 2,000 |

26-06-2020 | 2,000 |

26-07-2020 | 2,000 |

26-08-2020 | 2,000 |

26-09-2020 | 2,000 |

26-10-2020 | 2,000 |

Total Investment | 28,000 |
---|---|

Value of Investment at the end of period | 31,686.41 |

Absolute Returns | 13.17% |

CAGR | 16.00% |

XIRR | 28% |

This was some information on how to calculate the returns on a particular investment, and we hope this proves helpful the next time you compare different investment opportunities. We’ll be back with some more information.

Till then, Stay safe! Invest Safer!

Annualised interest simply is the absolute returns on an investment divided by the time for which the amount of money remains invested.

CAGR may be used to compare different funds and can also act as a parameter to gauge whether the investment is capable enough to beat the overall inflation rate.

easiest and fastest way to

save and invest

Copyright 2021 Spenny Fintech Pvt. Ltd.

Made with ❤️ in India