The following is the link to Demo of a Mutual Fund analysis in Excel sheet done by me. One has to input the NAV history only. Rest all calculations are done in Excel sheet automatically. Have a look :
~~
https://docs.google.com/spreadsheet/ccc?key=0AhQ9k7pZLg-PdFZDQlpSa19JQlUtTFR6cTRoOUFxSGc
~~
https://docs.google.com/spreadsheet/ccc?key=0AhQ9k7pZLg-PdGtMVTNScE14ZDVLaDRVNW9pRlg4Y2c
~~
For any clarification, doubts, let me know.
~~
https://docs.google.com/spreadsheet/ccc?key=0AhQ9k7pZLg-PdFZDQlpSa19JQlUtTFR6cTRoOUFxSGc
~~
https://docs.google.com/spreadsheet/ccc?key=0AhQ9k7pZLg-PdGtMVTNScE14ZDVLaDRVNW9pRlg4Y2c
~~
For any clarification, doubts, let me know.