Heike Moeller February 16, 2020 Mutual Fund
Spreadsheets & Formulas I have known plenty of investors who have invested extensive time, money and research into choosing their mutual funds. They have devised their own systems, using complex formulas and spreadsheets to allow them to make the right choice about their mutual funds. Ultimately however, this begs the question: If you have to do all this research, why are you buying mutual funds in the first place? For the amount of time you are spending on your decisions, you could buy individual stocks and not pay a money manager a fee.
Create a plan Define your financial goals. Are you saving for retirement? Putting money aside for a home? Funding a child`s college education? Your answer will have significant implications on your choice of mutual funds. More time gives you flexibility to use an aggressive approach. Immediate needs call for safety and capital preservation. Take careful consideration of your tolerance for risk. If the market dips, at what point would you lose sleep? Is it a 5% drop? 10% drop? An asset allocation plan will balance your portfolio and maximize return for your level of acceptable risk.
Can You Beat The Market Of course matching the market is not the most appealing concept to many of us. While we do not want to seem greedy, it sure would be nice to exceed the expected returns. Is there some amount of analysis that would allow us to blaze past the averages?
But you have to remember those special mutual fund factors: minimum holding requirements once you buy a fund; short-term penalty fees if you sell too soon, and a possible frozen account if you re-buy a recently sold fund or funds too soon within 12 months. In other words either you or your software must track or base your selling and buying decisions upon how long you have owned a fund with a re-buy restriction on recently sold funds so you do not get caught in the round-trip trap.
Understanding Mutual Fund Data Now that you know how to find mutual fund prices today, there is the matter of knowing how to read what it is that you have found. Funds are listed in alphabetical order, divided into columns underneath the name of the managing company. Your average newspaper will display three columns: in the first, you will see "NAV," short for net asset value.
Mutual fund ratings while they can be accurate at times are not something to base your future investments on alone. If you rely on these alone you may as be blind folded to pick your investments. If you are into investments but you do not want to invest in one kind of stock or another, perhaps you would rather invest in a mutual fund. With mutual funds you can diversify, meaning you can buy more than one kind of stock. By diversifying you reduce the risks without losing your returns.