project 9 personal finance

worksheets_12.1-12.3.xlsx

12.1

Worksheet 12.1 - Mutual Funds for Different Time Horizons and Objectives
Research different mutual funds and choose funds that support your short-term, intermediate, and long-term objectives. Compare funds based on their past performance, expense ratios, loads, risks, and holdings.
Short-Term Investment (< 1 Year)
Mutual Fund	Initial Investment	Load/Expense Ratio	Holdings
Intermediate Investment (1 - 5 Years)
Mutual Fund	Initial Investment	Load/Expense Ratio	Holdings
Long-Term Investment (> 5 Years)
Mutual Fund	Initial Investment	Load/Expense Ratio	Holdings

Worksheet 12.2 - Comparison of Mutual Fund Companies
Research different mutual fund companies and choose three similar funds with similar holdings. Compare the three funds based on past performance, expense ratios, loads, risks, and holdings. Where do they fit in the Morningstar Style Box?
	Fund 1	Fund 2	Fund 3
Fund name
Fund symbol
Benchmark index
Benchmark return over:
1 year
3 years
5 years
10 years
Fund return over:
1 year
3 years
5 years
10 years
Fund manager tenure
Minimum initial investment
Minimum continuous automatic investment
Annual expense ratio
Load?
How much?
12b-1 fee?
Turnover rate
Morningstar Box
			Large
			Medium
			Small
Value	Blend	Growth

Worksheet 12.3 - Mutual Fund Planning Worksheet
Construct an investment plan that includes appropriate use of mutual funds to meet your short-term, intermediate, and long-term savings objectives. Then log this information in your online GoalTracker.
	Short-Term	Intermediate	Long-Term
Goal/Purpose
Fund Name
Symbol
Holdings/Style Box
Risk Level
Fund return over:
1 year
3 years
5 years
10 years
Fund manager tenure
Minimum initial investment
Minimum continuous, automatic investment
Annual expense ratio
Load/How much?
12b-1 fee?
Turnover rate