I am seriously working out my total investments I have made so far since 2008 which includes non-equity debt like PPF , FDs too.

What I am making is a simple excel chart with equally simple formula to find what X amount I invested in Y year and What returns Z I am getting so far.

The idea is to allocate the ratio between equity and debt and also studying the exact returns I am getting in each MFs. If there is a underperformer, I need to get rid of it for sure. While I am studying all other online funds sites and understand a bit about CAGR or absolute returns, I want to focus only on the time period and amount I invested to get a correct picture.

As a layman I understand very simple maths for eg if I invested 10K in Nov 2008 for a particular fund and now the fund has the market value of 12K then my net gain is 2K in 2 years. ie 120% therefore 60% returns per year. Is this all calculation about or there is more than meets the eye. I know many of you reading this might feel me so dumb, but I was barely getting pass marks in maths through out my schooling:lol: , so genetic problem I guess.. the maths part of my brain does not work.. but guys, I am very good in analysis. Help me out please!!

Also is there a simple program in any site which gives me a simple result pls. I know there are good ones at valueresearch online, moneycontrol etc.. but I am not looking to work out individual details like NAV, absolute returns etc.. they are too tedious I guess, may be I am wrong..

Thanks in advance

Regards

Jeet