banner_ad

Formula required - weighted roi

Secondary Mkt 749 views 5 replies

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

 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 27 May 2026
CA Article Trainee

Rahul Dang & Associates-Chartered Accountants

Pune

CA Inter

View Details
Company
04 June 2026
Semi Qualified CA

Goyal Puneet & Associates

New Delhi

CA Final

View Details
Company
23 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
26 May 2026
Senior Accountant cum purchase Manager

Vardhaman Group of India

Pimpri Chinchwad

CA Inter

View Details