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
19 October 2026
Accountant

Jari Saree Center

New Delhi

Others

View Details
Company
05 October 2026
Senior Accountant

Vision IT Peripherals Pvt Ltd

Mumbai

B.Com

View Details
Company
Featured ARTICLESHIP 06 October 2026
Semi Qualified

AJAY SINGH AND CO LLP

Thane

CA Final

View Details
Company
12 October 2026
Chartered Accountant - Internal Audit

HKC | Chartered Accountants & Business Advisors

Ludhiana

CA

View Details
Company
14 October 2026
Asst. Manager/Dy Manager (Costing)

manufacturing

Pune

CMA

View Details
Company
ARTICLESHIP 17 October 2026
Articled Assistant

RRPM & Associates LLP

Chennai

CA Inter

View Details
Company
10 October 2026
Accounts Associate Level 1

Abic and Mani Chartered Accountants

Kottayam

B.Com

View Details
Company
14 October 2026
GST & TDS ASSISTANT

AGGARWAL SANJAY & ASSOCIATES

New Delhi

B.Com

View Details