Formula required - weighted roi

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 !!

Replies (5)

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

RCS

 

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

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
06 July 2026
Accountant

Agarwal Anoop and Associates

Noida

CA Final

View Details
Company
11 July 2026
CA semi qualified

Vakilsearch.com

Chennai

CA Inter

View Details
Company
Featured 02 August 2026
Accounts Executive

Aashok F&C Advisory

Guwahati

CA

View Details
Company
23 July 2026
CA Inter

Vikram Jadhav and Company

Pune

CA Inter

View Details
Company
23 July 2026
Senior Accountant

Felicity Adobe LLP

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 11 July 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
Featured 16 July 2026
CA Inter, CA Intermediate, CA IPCC, CA CPT, CA SemiQualified

Vakilsearch.com

Chennai

CA Inter

View Details
Company
Featured 18 July 2026
CA Articleship

apricus india

Mumbai

CA Inter

View Details
Follow