Week 2

cpowers
Week2Homework.xlsx

Problem 1

Fund Name Fund Type Net Asset Value ($) 5 Year Average Return (%) Expense Ratio (%) Morningstar Rank (Stars)
Amer Cent Inc & Growth Inv DE 28.88 12.39 0.67 2
American Century Intl. Disc IE 14.37 30.53 1.41 3
American Century Tax-Free Bond FI 10.73 3.34 0.49 4
American Century Ultra DE 24.94 10.88 0.99 3
Ariel DE 46.39 11.32 1.03 2
Artisan Intl Val IE 25.52 24.95 1.23 3
Artisan Small Cap DE 16.92 15.67 1.18 3
Baron Asset DE 50.67 16.77 1.31 5
Brandywine DE 36.58 18.14 1.08 4
Brown Cap Small DE 35.73 15.85 1.20 4
Buffalo Mid Cap DE 15.29 17.25 1.02 3
Delafield DE 24.32 17.77 1.32 4
DFA U.S. Micro Cap DE 13.47 17.23 0.53 3
Dodge & Cox Income FI 12.51 4.31 0.44 4
Fairholme DE 31.86 18.23 1.00 5
Fidelity Contrafund DE 73.11 17.99 0.89 5
Fidelity Municipal Income FI 12.58 4.41 0.45 5
Fidelity Overseas IE 48.39 23.46 0.90 4
Fidelity Sel Electronics DE 45.60 13.50 0.89 3
Fidelity Sh-Term Bond FI 8.60 2.76 0.45 3
Fidelity DE 39.85 14.40 0.56 4
FPA New Income FI 10.95 4.63 0.62 3
Gabelli Asset AAA DE 49.81 16.70 1.36 4
Greenspring DE 23.59 12.46 1.07 3
Janus DE 32.26 12.81 0.90 3
Janus Worldwide IE 54.83 12.31 0.86 2
Kalmar Gr Val Sm Cp DE 15.30 15.31 1.32 3
Managers Freemont Bond FI 10.56 5.14 0.60 5
Marsico 21st Century DE 17.44 15.16 1.31 5
Mathews Pacific Tiger IE 27.86 32.70 1.16 3
Meridan Value DE 31.92 15.33 1.08 4
Oakmark I DE 40.37 9.51 1.05 2
PIMCO Emerg Mkts Bd D FI 10.68 13.57 1.25 3
RS Value A DE 26.27 23.68 1.36 4
T. Rowe Price Latin Am. IE 53.89 51.10 1.24 4
T. Rowe Price Mid Val DE 22.46 16.91 0.80 4
Templeton Growth A IE 24.07 15.91 1.01 3
Thornburg Value A DE 37.53 15.46 1.27 4
USAA Income FI 12.10 4.31 0.62 3
Vanguard Equity-Inc DE 24.42 13.41 0.29 4
Vanguard Global Equity IE 23.71 21.77 0.64 5
Vanguard GNMA FI 10.37 4.25 0.21 5
Vanguard Sht-Tm TE FI 15.68 2.37 0.16 3
Vanguard Sm Cp Idx DE 32.58 17.01 0.23 3
Wasatch Sm Cp Growth DE 35.41 13.98 1.19 4

Problem 2

Tasks
Attending Required Meetings Preparing Business Reports Customer Interaction Idle
Locations Seattle 32% 17% 37% 14%
Portland 52% 11% 24% 13%
Bend 18% 11% 52% 19%
Missoula 21% 6% 43% 30%
Boise 12% 14% 64% 10%
Olympia 17% 12% 54% 17%

Problem 3

Project Expected Rate of Return (%) Risk Estimate Capital Invested (Millions $)
1 12.6 6.8 6.4
2 14.8 6.2 45.8
3 9.2 4.2 9.2
4 6.1 6.2 17.2
5 21.4 8.2 34.2
6 7.5 3.2 14.8