Calculation Tools

DietIrnBru

Hi,

I currently have a number of tracker funds I have built up over the past 5 years. I have a monthly direct debit to continue deposits.

When looking at my investments I would like to have the ability to calculate how much they have grown in a year while stripping out previous years growth and contributions I have made (the Fidelity website has some excellent tools, but its Profit/Loss function shows the profit/loss since inception rather than the current financial year).

If anyone knows of any websites or spreadsheet packages on offer - that would be great.

Many thanks.

Channey

I know it's not ideal but for each fund you can normally see the YTD growth on the online fact sheets. But if you want something more accurate for your own portfolio I think the best way would be to set up your own spreadsheet with all the funds, and start keeping a monthly record of the value of each on the 1st of each month. You can then factor in the monthly contributions you make. It will take a year to get an annual performance result but after a while you'll have enough historical data to choose your own time frames for returns and performance and will get exactly the figures you want. You can also add in annual inflation and fees and charges if you want. A DIY spreadsheet will give you exactly what you want.

If someone knows of an existing solution I'm sure they'll be along shortly.

theEnd

Google Finance is quite good now. You can just search for the fund (both my HSBC and Investec, via Fidelity are there).

I've also set-up a Portfolio, so can track my overall too.

Totton

One way to do this is to unitise your own portfolio, basically when adding money you buy units in your own portfolio. There are a couple o fatheads with this idea below. Another way is to use the XIRR formula within Excel, some links listed below.

http://news.fool.co.uk//news/investing/investing-strategy/2009/09/01/two-more-ways-to-measure-growth.aspx?source=isesitlnk0000001&mrr=1.00

http://office.microsoft.com/en-us/excel-help/xirr-HP005209341.aspx

http://search.fool.co.uk/search/solr.aspx?q=xirr&submit=#2

http://boards.fool.co.uk/unitisation-10581966.aspx?sort=whole

HTH,
Mickey