| Name: | Sample Student | | | | | Date: | December 10, 2015 | | | | | 41 |
| Mutual Fund Evaluation |
| Purpose: No checklist can serve as a foolproof guide for choosing a mutual fund. However, the following questions will help you evaluate a potential investment in a specific fund. |
| Instructions: Use mutual fund Web sites and/or library materials to answer these questions about a mutual fund that you believe could help you attain your investment goals. |
| Suggested Web sites: | | morningstar.com/Cover/Funds.aspx | | | | finance.yahoo.com/funds | | | dfaus.com |
| | personal.vanguard.com | | fidelity.com | | | individual.troweprice.com | | | sec.gov/investor/pubs/inwsmf.htm |
| Please read the directions below the sheet as some of the information requested will be downloaded from the web. | | | | | | | | | | | | Your Personal Financial Plan |
| Category 1: Fund Characteristics | | | | | | Category 4: Fund Performance |
| 1. What is the fund's ticker symbol? What is the fund's name? | | | | | | 16. How long has the fund manager been with the fund? |
| Ticker: | VTSMX | Vanguard Total Stock Mkt Idx Inv | | | | | | years |
| 2. What is the fund's Morningstar rating? |
| | | | | | | 17. How would you describe the fund's performance |
| 3. What is the minimum investment? | | | | | | over the past 12 months? |
| 4. Does the fund allow telephone or internet | | | | | | 18. How would you describe the fund's performance |
| exchanges? | | Yes | | No | | over the past five years? |
| 5. Is there a fee for exchanges? |
| | Yes | | No | | | 19. How would you describe the fund's performance |
| | Fee: | | | | | over the past 10 years? |
| Category 2: Costs |
| 6. Is there a front-end load charge? If so, how much is | | | | | | 20. What is the current net asset value for this fund? |
| it? | | | | | | Net Asset Value (NAV): | | | $52.26 |
| Yes___ | No___ | Amount: | | (percentage) |
| 7. Is there a redemption fee? If so, how much is it? | | | | | | 21. What is the high net asset value for this fund |
| Yes___ | No___ | Amount: | | (percentage) | | over the last 12 months? |
| 8. How much is the annual management fee? | | | | | | | High: | N/A |
| | | (percentage) | | | | 22. What is the low net asset value for this fund |
| 9. Is there a 12b-1 fee? If so, how much is it? | | | | | | over the last 12 months? |
| Yes___ | No___ | Amount: | | (percentage) | | | Low: | N/A |
| 10. What is the fund's expense ratio? | | | | | | 23. What do the experts say about this fund? |
| | | (percentage) |
| Category 3: Diversification | | | | | | Category 5: Conclusion |
| 11. What is the fund's objective? |
| | | | | | | 24. Based on the above information, do you think an |
| 12. What types of securities does the fund's portfolio | | | | | | investment in this fund will help you achieve your |
| include? | | | | | | investment goals? |
| | | | | | | | Yes | | No |
| | | | | | | 25. Explain your answer to question 24. |
| 13. How many different securities does the fund's |
| portfolio include? |
| | | | | | | A Word of Caution |
| 14. How many different types of industries does the |
| fund's portfolio include? | | | | | | When you use a checklist, there is always a danger
of overlooking important relevant information. This
checklist is not a cure-all, but it does provide some very
sound questions that you should answer before making
a mutual fund investment decision. Quite simply, it is a
place to start. If you need other information, you are
responsible for obtaining it and for determining how it
affects your potential investment. |
| 15. What are the fund's five largest holdings? |
| What's Next for Your Personal Financial Plan? |
| * Identify additional factors that may affect your decision to invest in this fund. |
| * Develop a plan for monitoring an investment's value once a mutual fund(s) is purchased. |
| Instructions |
| You must be connected to the internet to download the data. Input the requested information in the lightly-shaded cells above. Enter the ticker symbol of the mutual fund you are evaluating in cell B16 and hit ENTER. Finally, compare the information that you entered to the data that will download into the darker-shaded cells. Do not choose the mutual fund that appears when the spreadsheet is first loaded --- find a new mutual fund to evaluate! |
| | | | | | | | | | | | | | | Stock Quotes Provided by MSN Money |
| | | | | | | | | | | | | | | Click here to visit MSN Money |
| | | | | | | | | | Downloaded Data >>>>> | | | | | | | | Last | Previous Close | High | Low | Volume | Change | % Change | 52 Wk High | 52 Wk Low | Market Cap | EPS | P/E Ratio | # Shares Out |
| | | | | | | | | | | | | | | Vanguard Total Stock Mkt Idx Inv | Chart | News | 52.26 | 51.3 | N/A | N/A | N/A | 0.96 | N/A | N/A | N/A | N/A | N/A | N/A | N/A |
| | | | | | | | | | | | | | | MSN Money Home | | | | Microsoft Office Tools on the Web |
| | | | | | | | | | | | | | | Discover MSN Money's tools, columns, and more! | | | | Get the latest from Microsoft Office |
| | | | | | | | | | | | | | | Terms of Use. © 2014 Microsoft Corporation and/or its suppliers. All rights reserved. |
| | | | | | | | | | | | | | | DATA PROVIDERS |
| | | | | | | | | | | | | | | Copyright © 2014 Microsoft. All rights reserved. |
| | | | | | | | | | | | | | | Fundamental company data and historical chart data provided by Morningstar Inc. Real-time index quotes and delayed quotes supplied by Morningstar Inc. Quotes delayed by up to 15 minutes, except where indicated otherwise. Fund summary, fund performance and dividend data provided by Morningstar Inc. Analyst recommendations provided by Zacks Investment Research. IPO data provided by Hoover's Inc. Index membership data provided by Morningstar Inc. |
| | | | | | | | | | | | | | | AdChoices |
hotnicey
worksheet_41.xlsx
