Listing 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.