Dear All,
Below given table has an example of investments and other relevant details.
| A | B | C | D (=C/A) | E (=D/B) | F (=Ex365 days) | |
| Sl # | Invest Value | Invest days | Profit | ROI | ROI/Day | Annulaized-ROI |
| 1 | 20000 | 20 | 1450 | 7.30% | 0.40% | 132.30% |
| 2 | 50000 | 30 | 2000 | 4.00% | 0.10% | 48.70% |
| 3 | 80000 | 25 | 3000 | 3.75% | 0.15% | 54.75% |
It would be a great help if somebody can help me by giving a formula to arrive at "Total Annualized ROI" of all the investments.
Thanks in advance !!
THE TOTAL ANNUALIZED ROI OR THE WEIGHTED ANNUAL ROI WILL BE CALCULATED ON THE TOTAL AMOUNT INVESTED ....IT AS SAME AS WE CALCULATE THE WEIGHTED COST OF CAPITAL.....BUT AS THERE ARE NO SUCH AMOUNT INVESTED VALUE IS GIVEN SO I THINK THE INTEREST VALUE SHALL BE TAKEN FOR CALCULATING WEIGHTAGE OF EACH......
I THINK THIS WAY....IF M WRONG PLEASE CORRECT ME
Thanks for your reply. But, I am still wondering will it be the correct way, as the time period is different for each of the investment.
TIME PERIOD IS NO DIFFERENCE ....AS U HAVE CALCULATED THE ANNUALIZED ROI
CAclubindia
