eenadu midcap performance based on 963 method on 13th april 25

 

giving importance for 3years 90% and 5 years 60% performance major and 30% for 10years , give rank for all midcap mutual funds as given image;

ChatGPT said:

To calculate the weighted rank for each mutual fund based on the image and the given weights:

• 3-Year Performance Weight = 90%

• 5-Year Performance Weight = 60%

• 10-Year Performance Weight = 30%

We’ll calculate a weighted score for each fund using this formula:

java
Weighted Score = (3Y % * 0.9) + (5Y % * 0.6) + (10Y % * 0.3)

Let's apply this to all the mutual funds in the table.

---

🧮 Calculated Weighted Scores & Rankings

Rank	Mutual Fund Name	Weighted Score
1	Motilal Oswal Midcap Fund	57.08
2	PGIM India Midcap Opportunities Fund	53.85
3	Nippon India Growth Fund	51.68
4	Edelweiss Midcap Fund	51.58
5	Invesco India Midcap Fund	50.84
6	Sundaram Midcap Fund	49.35
7	Franklin India Prima Fund	46.67
8	HDFC Midcap Opportunities Fund	45.29
9	Kotak Emerging Equity Fund	44.63
10	Canara Robeco Emerging Equities Fund	44.35
11	Mahindra Manulife Midcap Fund	43.21
12	UTI Midcap Fund	40.77
13	Axis Midcap Fund	37.86
14	Quant Midcap Fund	36.87
15	DSP Midcap Fund	35.17
16	SBI Magnum Midcap Fund	34.48
17	Tata Midcap Growth Fund	34.22
18	JM Midcap Fund	32.49
19	HSBC Midcap Fund	30.97
20	LIC MF Midcap Fund	27.82

---

Let me know if you'd like this in Excel or CSV format, or visualized in a chart.

You said:

as calculated above, is it good way to predict and choose by its rank? give your analysis?

ChatGPT said:

Great question, Deviprasad! Let's analyze whether ranking midcap mutual funds based on a custom weighted performance metric like the one you've used is a reliable way to choose a fund.

---

🔍 Method Recap:

You’ve used this formula:

java
Weighted Score = (3Y % * 0.9) + (5Y % * 0.6) + (10Y % * 0.3)

This gives more weight to recent performance, especially the last 3 years, which aligns with the belief that:

• Recent trends may better reflect the current fund manager's skill, market strategy, and economic environment.