Before getting into the calculation methods and formulae, let us first understand the meaning of investment returns.
What is “Returns on investment”?
Returns on Investment (ROI) is the loss or gain of the investment asset for a particular period of time which is usually calculated in percentage. “More risk, greater the potential for higher return or loss”.
Two basic Components in ROI are:
1. Appreciation / Depreciation (increase/decrease in the investment value)
2. Interests and Dividends (generated income by the investment)
Is it important to know how to find the ROI?
Yes. It is very much important for you to know how to find the ROI for the following reasons:
You need to “determine the ROI” to be sure that you are on the right track and make the required adjustments (when necessary)
You need to “estimate the ROI” to help you choose the right investment plans (more than one)
Different types of returns
There are different types of returns on investment which are mostly categorized by the term period.
1. Absolute return
2. Simple annualized return
3. Average Annual return (AAR)
4. Compound Annual growth rate (CAGR)
1. Absolute return
- It is the percentage increase or decrease an investment achieves over a period of time.
Example: If your investment on an asset in May 2013 is $25,000 and you sold the same in July 2016 at the cost of Rs. $56,000, then your absolute returns in this case would be:
Absolute returns = ((56,000-25,000)/25,000)*100 = 124%.
This is the simplest method to calculate returns. But this does not consider the time period of the investment.
2. Simple Annualized Return
- It is the percentage increase or decrease an investment achieves for a year or more (specific period).
Example: You have made an investment for $2,00,000 which has become $2,50,000 over three years, then your simple annualized return would be:
Absolute return = ((2,50,000-2,00,000)/2,00,00)*100= 25%
Simple annualized return = 25 / 3 = 8.33%
3. Average Annual Return
- The arithmetic mean of a series of ‘ROI returns’ forms the ‘average annual return’ in percentage.
Example: Let us assume you have investment records from 2016 – 2019 as follows:
Year Annual return
2016 25%
2017 20%
2018 15%
2019 28%
Average Annual Return (2016-2019) = (25+20+15+28)/4 = 22%
This is used for determine the ROI but cannot be considered as common formula for analysis.
4. Compound Annual Growth Rate (CAGR)
- It is the growth rate of the investment year over year for a specified period of time. This helps determine the annual growth rate on an investment whose value has fluctuated from one time period to the next.
Example: Let us assume that your investment of 10,000 in May 2011 became $ 25,000 by May 2018 and by May 2019, it became $15,000; then your CAGR would be:
CAGR = ((15,000/10,000)^(1/2))-1= 22.47%
Investors usually compare the CAGR to evaluate how well ones’ stocks or mutual funds have performed against other stocks in peer group or against the market index.
There are many more detailed ways of calculating the ROI such as IRR, XIRR, rolling returns etc.

Explain IRR or other methods of calculating return.
ReplyDeleteInternal Rate of Return (IRR)
DeleteThe IRR is a capital budgeting metric used to decide whether they should make investments. The IRR is the annualized effective compounded return rate which can be earned on the invested capital.
A project is a good investment proposition if its IRR is a greater than the rate of return that could be earned by alternative investment (investing in other projects, buying bonds, even putting the money in a bank account). Thus, the IRR should be compared to any alternate costs of capital including an appropriate risk premium.
If IRR is a greater than the project's cost of capital, the project will add value for the company. It can also be compared against prevailing rates of return in the securities market. If a firm can't find any projects with IRR greater than the returns that can be generated in the financial markets, it may simply choose to invest its retained earnings into the market.
Example: Your requried rate of return is 11%. If you invest Rs. 250 today you will receive the following:
ReplyDelete- At the end of Year 1: Rs. 97
- At the end of Year 2: Rs. 65
- At the end of Year 3: Rs. 99
- At the end of Year 4: Rs. 152
What is the return from the project?
Solution: Year Cash Flow
1 -250
2 97
3 65
4 99
5 152
TO calculate Return from Project:
Use IRR function in Excel:=IRR(Select values)= 21.27%