I had some money that needed to grow, I didn’t want it to get eaten away by inflation. Do I put it in a tax free wrapper (an ISA in the UK), a high interest savings account. What should I do?
In a pension review I recently had, a figure of three percent was suggested as a requirement to maintain the value. I was getting just over 5% a year in a small AVC pension I had (which was invested in a fund). I had never actively invested in a fund before, so I decided to have a look.
I discovered there is a huge range of funds out there, all wanting you to invest your hard earned cash. But how do you decide which one to use?
My small AVC pension was with the company Aviva, so I started to look at their list of funds. There were way too many to choose from, so I decided to download the complete list of funds on a spreadsheet. All 1,357 of them.
Now what do I do with this huge list?
I opened the spreadsheet and used some filters, so I could narrow down the list of results.
I am not a financial advisor. This website does not provide any financial advice or recommendations to buy or sell any investments, nor does it recommend any supplier of services. Please ensure you do your own research, or ask a regulated financial advisor before making any investment decisions.
When you download a large list of funds, it can all look very daunting. What we need to do, is to make life a whole lot easier, by breaking down the list into smaller chunks. We can do this by filtering the spreadsheet.
First we need to find out what we need to filter…
The list of funds I downloaded had the following key headings:
This list is in the order I have used for filtering the spreadsheet, (for my own personal use, and not necessarily in any order of importance)…
I added my own additional columns to help filter the list of 1,357 different funds.
Anything to do with investments have a similar standard phrase…
The value of investments may go up or down. Dividend payments can fall as well as rise. Any information relating the to past performance of an investment, or investment service is not a guide to future performance. You may not get back the original amount invested. You should not invest any money you cannot afford to lose.
No-one wants to think it, but very wise words…
The key thing here, is not to be greedy and go for the biggest returns, but to decide what level of risk you want to take? There are loads of ‘risk calculators’ out there, so do a Google financial risk calculator search. But don’t get sucked in to anyone trying to sell you something. Choose one from a reputable site, or from a financial organisation you know. As I was looking at Aviva, here’s a link to theirs…
Once you have decided on the risk rating(s) you want to use, you can use this rating to filter your spreadsheet. I used the risk ratings 3, 4 and 5 to compare the percentage returns (historical) against each other. I.e. there may be a fund with a lower risk rating, with a better return (historical) than a fund with a higher risk.
How I keep using the term historical. It’s all too easy to forget the figures shown are historical, and are no indication of what you may get back in the future? We can only hope…
Discrete performance shows the performance for each year. I.e. Year one, two, three, five and ten. The importance here, is that you can see if the fund is consistently performing. I.e. The fund has historically consistently performed every year, rather than one good year (three years ago) and a poor performance the rest of the time…
This is where a new column for ‘Average Discrete Performance’ comes in.
The Discrete Performance Average:
If you’re creating a new column in excel to measure the average discrete performance, you need the following formula in an adjoining cell, (and then copy it down the column to the last entry).
Amend the formula cell references to suit your own spreadsheet.
This will give you the average of the discrete performance. You can then use this average to compare each year measured to see if there is consistent historical performance.
There are various places a fund can invest money. Some of the main ones are:
Each investment area has its risks, so it’s worth noting what they are. You may have a particular area of investing that you don’t want to take a risk with or be a part of. Again, there are loads of ‘fund risk warnings’ out there, so do a Google fund risk warnings search. But don’t get sucked in to anyone trying to sell you something. Choose one from a reputable site, or from a financial organisation you know. As I was looking at Aviva, here’s a link to theirs…
Once the spreadsheet has been filtered to narrow down which funds you may be interested in, you can check the risk warnings to see if you’re happy with them.
Beware of charges. They can soon add up, and appear amplified if your fund doesn’t do so well…
Bear in mind there may be two sets of charges, the fund managers charges and investment platform charges.
An example list:
Other possible charges:
Each fund provider may have a different set of fees.
Take note of how you are charged..?
You have actually lost 20% of your profit.
It’s nice to see the year on year cumulative performance of what you might get. But don’t get suckerred in! These are historical results, not necessarily what your gonna get when you put your hard earned cash upfront!
I created an additional spreadsheet column (call it whatever you want), so I could mark which funds may be of interest, so I could easily find them again, (if I re-sorted the spreadsheet).
An index fund, index tracker fund, or an exchange traded fund (ETF) is a portfolio of stocks or bonds designed to follow the performance of a financial market index.
They can be one of the simplest ways to invest. There’s no manager or analysts fees to pay, so are often a low cost option. However, platform charges may apply (the investment company charges), or they may be actively managed (where additional fees may apply).
An example of an index fund is Standard & Poor’s 500 Index (S&P 500). Here is a list of most of the stock market indices.
The fund may be offered to you by different investment platforms, so you need to check the small print for any differences in operating charges (expense ratios) that may be applied.
The simple answer is to do a search for index funds and read the details…
On the spreadsheet list of funds, an index tracker fund should show no charges, (other than the ongoing platform charges).
It’s all too easy to randomly pick a fund that looks good. The one with the biggest historical return. But how do you know it’s going to do the same in the future?
You don’t. So you need to read the small print.
Look at the: (Links open in a new tab)
In no particular order (Links to tools in brackets ) – Links open in a new tab.
I’ve tried to pick free tools, but some may have additional plans for extra tools, and fluffy stuff, etc.
Hope this helps…