India’s equity mutual fund landscape has matured significantly over the past decade. Out of 539 Direct Equity Mutual Funds, 210 funds have a performance history long enough—10 years or more—to allow meaningful evaluation.
Read MoreIndia’s equity mutual fund landscape has matured significantly over the past decade. Out of 539 Direct Equity Mutual Funds, 210 funds have a performance history long enough—10 years or more—to allow meaningful evaluation.
Read MoreThe most important factor for a long-term investor is the performance of his investment. As SIPs have become widely accepted as the right choice of investment into mutual funds, the question arises about what the performance of the funds in the long run, for periods over five years, is.
Read MoreAssessing the overall performance of Fund Houses (AMCs) with respect to equity mutual funds is to check for its outperforming schemes in each category. Here, outperformance in a category is defined as showing better long term stability and short term momentum. Only the schemes that have been consistently outperforming its peers over a period of two weeks are considered. For better comparison, only Direct - Growth schemes are included. The more outperforming schemes a fund house (AMC) has the better is its performance.
Read MoreListing all existing mutual fund investments, calculating monthly investment targets, recording transactions and estimating target value.
Recording each transaction in a prescribed format for better representation to understand the effects of investment and redemption over a period of time.
Summarisation of investments, redemptions and current holding. Tabulation of investment in various categories and accounts.
Calculation of absolute returns and XIRR and comparing the performance with large cap, mid cap and small cap indices.
Monthly recording of data with respect to portfolio, index valuations, absolute returns and XIRR.
Tabulation of fund data and comparing the performance with peers and other categories to compute investment on the basis of the summary data.
Information with respect to current NAVs and performance of funds, category performance summary and historic index values.
Constructing a robust low-risk high-return portfolio structure involving all categories of open-ended equity mutual funds.
Choosing the top performing mutual fund scheme in each category with respect to stability and momentum.
Adjusting allocation and selection to increase weightage of funds with higher momentum.
Replacing funds having a weaker outlook with ones with stronger outlook to boost overall long term returns.
Maintaining allocation targets to de-risk higher returns providing long term stability and growth

I have been managing my mutual fund data sheets in prescribed format for over 3 years now. I had never imagined that proper maintenance of data can help improve return so much. I can confidently say that I understand mutual funds investments much better. The best part is that the time involvement is next to nil.
*Index returns are calculated as on 6th Dec 2024 taking the Index Values as NAVs.