Heike Moeller February 10, 2020 Mutual Fund
This formula shows the value of the shares in that fund. The second column will be offer price, which is what an investor would pay that day to buy more shares. If a fund is no-load, you will see an NL in that column, meaning you would just pay what the NAV is. The last column is the change column. A plus sign here will indicate that the funds value has gone up since the previous day, and a minus sign means that it has declined.
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.
In his book "The Trouble With Mutual Funds," Richard Rutner shares that "No one denies that the average mutual fund returns 2% less per year than the stock market returns in general. Yet the mutual fund industry spends billions of shareholder dollars to promote its money managers as experts who can manage investor`s dollars with skill. The vast majority of mutual funds (94% according to a recent five-year survey by Lipper Analytical Services) have underperformed the stock market as a whole."
Investing in stocks, mutual funds and exchange traded funds can be a great way to build wealth, but timing the markets can be detrimental to your bottom line and extremely hard to do. While there are many services out there that claim to accurately pick the highs and lows, the reality is that very few individual investors can accurately use market timing effectively.