View the step-by-step solution to:

- Interpret the two estimated slope coecients of your regression. Hint: Keep in mind that this is a multivariate regression. Here is the given Excel...

Mutual Fund Performance Evaluation

On Blackboard, you will find a spreadsheet containing historical returns as well as other in- formation on the Fidelity Magellan Fund for the period 1968-2016. To conduct a performance analysis on this fund, you will also need data on di↵erent systematic risk factors. Go to Ken French's website and download monthly returns for the three Fama-French factors, the risk-free rate, and the momentum factor over the same sample period and add them to your spreadsheet. Note that the risk-free rate is included in the same file as the three Fama-French factors.

  1. Estimate the Carhart 4-factor model for the Magellan fund by regressing its' excess returns on the four factors (note that the fund returns in the spreadsheet are NOT in excess of the risk-free rate). Use the entire 1968-2016 sample period for this regressions.

• What does the regression suggest about the investment strategy of this fund? • Based on the results from the 4-factor model, is this a good fund to invest in?


2.) Perform rolling window 4-factor model regressions: In each month t (starting with the 60est month of the sample), estimate the regression using data for months t 59 to t.1 Produce two plots:

  1. (a) Plot the time series of rolling-window alpha estimates, along with a rolling window average of the excess return (not adjusted for risk; also using data for months t 59 to t)
  2. (b) Plot the rolling-window beta estimates for the four factors. Put all four series in one plot.


3.) Interpret the development of the coecients with respect to the data provided about the fund (changes of the manager, expenses,...). Do you see any connection to the facts about the fund? Comment on the alphas. Hint: This is an open-ended question, i.e. there isn't one correct answer. It is sucient to discuss a few things you notice about the relationship between the fund's betas and the other information you know about the fund.


(1The easiest way to for this in Excel is the '=linest()' function. You can use linest as an array function and have it return all slope coecients (betas) and the intercept (alpha) simultaneously. For estimating the 4-factor model, select a 5⇥1 block of cells, type =linest() with the appropriate inputs, then press SHIFT-CTRL-ENTER. Consulting the help page for LINEST may help. )


4. In each month t, compute the average excess return on the market using data for months t59 to t. Denote this variable by r ̄M,t. Similarly, denote the average excess return on the Magellan Fund in months t 59 to t (computed in part 2a) by r ̄F,t. Regress the variable 'flow' (in column I) in month t on r ̄M,t and r ̄F,t using the available dates ,i.e. 1991-2016.

• What does the variable 'flow' measure? Hint: The spreadsheet contains a formula that computes flow. Looking at this formula is helpful for the interpretation.

• Interpret the two estimated slope coecients of your regression. Hint: Keep in mind that this is a multivariate regression. Finance Assignment-02.jpgee different excel sheets!Finance Assignment-03.jpgFinance Assignment-04.jpgFinance Assignment-05.jpgFinance Assignment-06.jpgFinance Assignment-07.jpgFinance Assignment-08.jpgFinance Assignment-09.jpgFinance Assignment-10.jpgFinance Assignment-11.jpgFinance Assignment-12.jpgFinance Assignment-13.jpgFinance Assignment-14.jpg

Finance Assignment-02.jpg

- Interpret the two estimated slope coecients of your regression. Hint: Keep in mind that this is a
multivariate regression. Here is the given Excel Sheet Fidelity Magellan Fund (CRSP FUNDNO 11943) year month Mgr_Name expenses turnover return net_assets Flow 1968 1 1/1/68 0.00% -5.46% 1968 2 2/1/68 0.00% -8.85% 1968 3 3/1/68 0.00% 0.44% 1968 4 4/1/68 0.00% 15.73% 1968 5 5/1/68 0.00% 17.05% 1968 6 6/1/68 0.00% -2.23% 1968 7 7/1/68 0.00% —3.25% 1968 8 8/1/68 0.00% 5.46% 1968 9 9/1/68 0.00% 7.16% 1968 10 10/1/68 0.00% 1.65% 1968 11 11/1/68 0.00% 12.45% 1968 12 12/1/68 0.00% -1.67% 7.1
1969 1 1/1/69 0.00% -0.76% 7.1
1969 2 2/1/69 0.00% -11.11% 7.1
1969 3 3/1/69 0.00% 3.77% 7.1
1969 4 4/1/69 0.00% 4.08% 7.1
1969 5 5/1/69 0.00% 3.50% 7.1
1969 6 6/1/69 0.00% 42.25% 7.1
1969 7 7/1/69 0.00% -10.77% 7.1
1969 8 8/1/69 0.00% 7.11% 7.1
1969 9 9/1/69 0.00% -0.60% 7.1
1969 10 10/1/69 0.00% 6.38% 7.1
1969 11 11/1/69 0.00% -4.74% 7.1
1969 12 12/1/69 0.00% 0.77% 8.2
1970 1 1/1/70 0.79% -7.97% 8.2
1970 2 2/1/70 0.79% -0.05% 8.2
1970 3 3/1/70 0.79% -8.85% 8.2
1970 4 4/1/70 0.79% -12.22% 8.2
1970 5 5/1/70 0.79% 4.56% 8.2
1970 6 6/1/70 0.79% -7.06% 8.2
1970 7 7/1/70 0.79% 3.63% 8.2
1970 8 8/1/70 0.79% 4.27% 8.2
1970 9 9/1/70 0.79% 12.58% 8.2
1970 10 10/1/70 0.79% —2.71% 8.2
1970 11 11/1/70 0.79% 2.68% 8.2
1970 12 12/1/70 0.79% 6.25% 6.9
1971 1 1/1/71 0.00% 8.54% 6.9
1971 2 2/1/71 0.00% 6.45% 6.9
1971 3 3/1/71 0.00% 7.83% 6.9
1971 4 4/1/71 0.00% 4.02% 6.9

Finance Assignment-03.jpg

Finance Assignment-04.jpg

1975
1975
1975
1975
1975
1975
1975
1976
1976
1976
1976
1976
1976
1976
1976
1976
1976
1976
1976
1977
1977
1977
1977
1977
1977
1977
1977
1977
1977
1977
1977
1978
1978
1978
1978
1978
1978
1978
1978
1978
1978
1978
1978
1979
1979
1979
1979
1979
1979 _\
DLOOO‘NIO') _\._‘
AMA —'L
ommwmmhmw _L_L
_|.N_L _x
OCDCD'NIO'JU‘I-D-QJN _\_‘
ANA _\
00300310301.me _\._‘
AMA 0301th 6/1/75
7/1/75
8/1/75
9/1/75
10/1/75
11/1/75
12/1/75
1/1/76
2/1/76
3/1/76
4/1/76
5/1/76
6/1/76
7/1/76
8/1/76
9/1/76
10/1/76
11/1/76
12/1/76
1/1/77
2/1/77
3/1/77
4/1/77
5/1/77
6/1/77
7/1/77
8/1/77
9/1/77
10/1/77
11/1/77
12/1/77
1/1/78
2/1/78
3/1/78
4/1/78
5/1/78
6/1/78
7/1/78
8/1/78
9/1/78
10/1/78
11/1/78
12/1/78
1/1/79
2/1/79
3/1/79
4/1/79
5/1/79
6/1/79 Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch 1.68%
1.68%
1.68%
1.68%
1.68%
1.68%
1.68%
1.68%
1.68%
1.68%
1.68%
1.68%
1.68%
1.68%
1.68%
1.68%
1.68%
1.68%
1.68%
1.49%
1.49%
1.49%
1.49%
1.49%
1.49%
1.49%
1.49%
1.49%
1.49%
1.49%
1.49%
1.50%
1.50%
1.50%
1.50%
1.50%
1.50%
1.50%
1.50%
1.50%
1.50%
1.50%
1.50%
1.43%
1.43%
1.43%
1.43%
1.43%
1.43% 1.689
1.689
1.689
1.689
1.689
1.689
1.689
1.689
1.689
1.689
1.689
1.689 2.39
2.39
2.39
2.39
2.39
2.39
2.39
2.39
2.39
2.39
2.39
2.39
2.485
2.485
2.485
2.485
2.485
2.485 5.45%
~6.86%
-1.39%
-2.94% 1.01% 1.12% 1.48%
15.09% 3.86% 2.49% 0.07% 2.16% 7.57%
-3.20%
-3.26% 1.86%
-2.40% 3.34% 6.27% 1.52%
-0.04%
-1.45% 3.42% 0.35% 7.52%
-2.48%
-3.30%
—0.26%
-3.11% 8.21% 4.00%
-6.62% 4.21% 9.17%
12.28% 6.39%
~2.38%
12.50% 8.89%
-3.30% -20.84%
10.00% 3.06%
10.38%
-4.41%
12.71% 2.01%
-2.58% 7.38% 22.2
22.2
22.2
22.2
22.2
22.2
22.2
22.2
22.2
22.2
22.2
22.2
26.4
26.4
26.4
26.4
26.4
26.4
26.4

Finance Assignment-05.jpg

1979
1979
1979
1979
1979
1979
1980
1980
1980
1980
1980
1980
1980
1980
1980
1980
1980
1980
1981
1981
1981
1981
1981
1981
1981
1981
1981
1981
1981
1981
1982
1982
1982
1982
1982
1982
1982
1982
1982
1982
1982
1982
1983
1983
1983
1983
1983
1983
1983 (BOON 11
12
1 —I.
owm-qmmhmm _|._;
”—1. 1 —L
OLDCONIO'JU'ILOJM _L_L
N—A 1 A
OCDCD‘HOEU'I-bO-JM _\_L
N-x 1 #0301th 7/1/79
8/1/79
9/1/79
10/1/79
11/1/79
12/1/79
1/1/80
2/1/80
3/1/80
4/1/80
5/1/80
6/1/80
7/1/80
8/1/80
9/1/80
10/1/80
11/1/80
12/1/80
1/1/81
2/1/81
3/1/81
4/1/81
5/1/81
6/1/81
7/1/81
8/1/81
9/1/81
10/1/81
11/1/81
12/1/81
1/1/82
2/1/82
3/1/82
4/1/82
5/1/82
6/1/82
7/1/82
8/1/82
9/1/82
10/1/82
11/1/82
12/1/82
1/1/83
2/1/83
3/1/83
4/1/83
5/1/83
6/1/83
7/1/83 Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch 1.43%
1.43%
1.43%
1.43%
1.43%
1.43%
1.40%
1.40%
1.40%
1.40%
1.40%
1.40%
1.40%
1.40%
1.40%
1.40%
1.40%
1.40%
1.23%
1.23%
1.23%
1.23%
1.23%
1.23%
1.23%
1.23%
1.23%
1.23%
1.23%
1.23%
1.34%
1.34%
1.34%
1.34%
1.34%
1.34%
1.34%
1.34%
1.34%
1.34%
1.34%
1.34%
0.85%
0.85%
0.85%
0.85%
0.85%
0.85%
0.85% 2.485
2.485
2 .485
2 .485
2 .485
2.485
3.38
3.38
3.38
3.38
3.38
3.38
3.38
3.38
3.38
3.38
3.38
3.38
2.77
2.77
2.77
2.77
2.77
2.77
2.77
2.77
2.77
2.77
2.77
2.77
1 .94 1 .94 1 .94 1 .94 1 .94 1 .94 1 .94 1 .94 1 .94 1 .94 1 .94 1 .94 1 .2 1 .2 1 .2 1 .2 1 .2 1 .2 1 .2 2.59%
11.75%
-0.68%
-9.60%
10.28% 5.32% 8.63% 0.41% -13.50% 8.32% 8.72% 7.83% 8.90% 4.87% 7.82% 6.07%
11.94%
-3.00%
-0.93% 2.37% 9.59% 3.09% 6.53%
-1.01%
-0.14%
-7.67%
-7.00%
10.45% 4.41%
-2.54%
-2.94%
-2.33% 0.00% 8.28%
-2.93% 0.37%
~0.47% 9.24% 3.97%
14.38%
10.89% 3.26% 6.07% 6.12% 6.76%
10.51% 3.29% 5.28%
-3.47% 26.4
26.4
26.4
26.4
26.4
35.1
35.1
35.1
35.1
35.1
35.1
35.1
35.1
35.1
35.1
35.1
35.1
53.5
53.5
53.5
58.81
58.81
58.81
104.37
104.37
104.37
90.44
90.44
90.44
107.25
107.25
107.25
115.778
115.778
115.778
146.819
146.819
146.819
231.161
231.161
231.161
458.433
458.433
458.433
797.602
797.602
797.602
1351.9
1351.9

Finance Assignment-06.jpg

1983
1983
1983
1983
1983
1984
1984
1984
1984
1984
1984
1984
1984
1984
1984
1984
1984
1985
1985
1985
1985
1985
1985
1985
1985
1985
1985
1985
1985
1986
1986
1986
1986
1986
1986
1986
1986
1986
1986
1986
1986
1987
1987
1987
1987
1987
1987
1987
1987 8
9
10
11
12 A
OCDCDNIODU'I-bmmé _'L_|,
AN—x —I.
OLDED'NIO‘SU'ILCQN _x_.
_L|\_')._L —L
omm-qmmbum _\_‘
_\M_x mummhwm 8/1/83
9/1/83
10/1/83
11/1/83
12/1/83
1/1/84
2/1/84
3/1/84
4/1/84
5/1/84
6/1/84
7/1/84
8/1/84
9/1/84
10/1/84
11/1/84
12/1/84
1/1/85
2/1/85
3/1/85
4/1/85
5/1/85
6/1/85
7/1/85
8/1/85
9/1/85
10/1/85
11/1/85
12/1/85
1/1/86
2/1/86
3/1/86
4/1/86
5/1/86
6/1/86
7/1/86
8/1/86
9/1/86
10/1/86
11/1/86
12/1/86
1/1/87
2/1/87
3/1/87
4/1/87
5/1/87
6/1/87
7/1/87
8/1/87 Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch 0.85%
0.85%
0.85%
0.85%
0.85%
1.04%
1.04%
1.04%
1.04%
1.04%
1.04%
1.04%
1.04%
1.04%
1.04%
1.04%
1.04%
1.12%
1.12%
1.12%
1.12%
1.12%
1.12%
1.12%
1.12%
1.12%
1.12%
1.12%
1.12%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08% 1 .2 1 .2 1 .2 1 .2 1 .2
0.85
0.85
0.85
0.85
0.85
0.85
0.85
0.85
0.85
0.85
0.85
0.85
1 .26
1 .26
1 .26
1 .26
1 .26
1 .26
1 .26
1 .26
1 .26
1 .26
1 .26
1 .26
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96 -2.24%
3.35%
-4.35%
4.49%
-1.56%
-0.91%
—6.49%
1.79%
-0.80%
—6.82%
3.23%
-1.58%
11.66%
0.18%
1.28%
-1.21%
2.90%
10.12%
0.70%
0.88%
0.53%
5.41%
2.99%
0.75%
0.49%
4.69%
6.48%
8.45%
5.19%
3.94%
10.34%
6.73%
0.45%
3.29%
2.38%
-6.67%
6.43%
-8.50%
5.23%
1.01%
-1.48%
13.00%
7.42%
1.29%
-1.62%
0.10%
4.14%
4.89%
4.02% 1351 .9
1477.9
1477.9
1477.9
1606
1606
1606
1604.107
1604.107
1604.107
1617.6
1617.6
1617.6
1891 .91
1891 .91
1891 .91
1954.4
1954.4
1954.4
2359.026
2359.026
2359.026
2878.476
2878.476
2878.476
2961 .971
2961 .971
2961 .971
4136
4136
4136
5998.5
5998.5
5998.5
7270.9
7270.9
7270.9
6504
6504
6504
7405.5
7405.5
7405.5
9843.9
9843.9
9843.9
10842.3
10842.3
10842.3

Finance Assignment-07.jpg

1987
1987
1987
1987
1988
1988
1988
1988
1988
1988
1988
1988
1988
1988
1988
1988
1989
1989
1989
1989
1989
1989
1989
1989
1989
1989
1989
1989
1990
1990
1990
1990
1990
1990
1990
1990
1990
1990
1990
1990
1991
1991
1991
1991
1991
1991
1991
1991
1991 9
10
11
12 —\
DLOOO'QOSUIACJM—I _\._;
AMA —I
occac-qcncnhmw _L_L
AN—A _‘—‘L
Accom-Mmmhmm A
AN com-qmmhmru 9/1/87
10/1/87
11/1/87
12/1/87 1/1/88 2/1/88 3/1/88 4/1/88 5/1/88 6/1/88 7/1/88 8/1/88 9/1/88
10/1/88
11/1/88
12/1/88 1/1/89 2/1/89 3/1/89 4/1/89 5/1/89 6/1/89 7/1/89 8/1/89 9/1/89
10/1/89
11/1/89
12/1/89 1/1/90 2/1/90 3/1/90 4/1/90 5/1/90 6/1/90 7/1/90 8/1/90 9/1/90
10/1/90
11/1/90
12/1/90 1/1/91 2/1/91 3/1/91 4/1/91 5/1/91 6/1/91 7/1/91 8/1/91 9/1/91 Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch
Peter Lynch 1.08%
1.08%
1.08%
1.08%
1.13%
1.13%
1.13%
1.13%
1.13%
1.13%
1.13%
1.13%
1.13%
1.13%
1.13%
1.13%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.08%
1.01%
1.01%
1.01%
1.01%
1.01%
1.01%
1.01%
1.01%
1.01%
1.01%
1.01%
1.01%
1.06%
1.06%
1.06%
1.06%
1.06%
1.06%
1.06%
1.06%
1.06% 0.96
0.96
0.96
0.96
0.82
0.82
0.82
0.82
0.82
0.82
0.82
0.82
0.82
0.82
0.82
0.82
0.87
0.87
0.87
0.87
0.87
0.87
0.87
0.87
0.87
0.87
0.87
0.87
1 .42
1 .42
1 .42
1 .42
1 .42
1 .42
1 .42
1 .42
1 .42
1 .42
1 .42
1 .42 -2.46%
-25.81%
-7.55%
9.74%
3.97%
6.07%
-0.27%
1.79%
-0.27%
6.84%
—0.65%
-3.18%
4.20%
2.09%
-1.35%
1.97%
8.11%
-1.63%
2.98%
5.03%
5.28%
-0.87%
8.40%
2.62%
1.73%
-3.14%
1.65%
0.63%
—6.45%
2.05%
2.56%
-2.53%
8.89%
0.44%
-1.13%
-9.80%
~6.35%
-1.24%
7.57%
3.10%
6.99%
8.68%
3.40%
0.37%
5.70%
»5.88%
6.21%
3.07%
-0.38% 11589.5
11589.5
11589.5
7800.1
7800.1
7800.1
8434.3
8434.3
8434.3
9257.4
9257.4
9257.4
9016
9016
9016
8971.1
8971.1
8971.1
9622.2
9622.2
9622.2
10756.6
10756.6
10756.6
12427.9
12427.9
12427.9
12699.6
12699.6
12699.6
13176.9
13176.9
13176.9
14038.9
14038.9
14038.9
11318.9
11318.9
11318.9
12325.7
13122.3
14292.5
14805.3
14990
16004.6
15251.8
16384.4
17227.3
17276.5 -0.53%
0.23%
0.19%
0.38%
1 .07%
1 .17%
1.22%
2.07%
0.66%

Finance Assignment-08.jpg

Finance Assignment-09.jpg

Finance Assignment-10.jpg

Finance Assignment-11.jpg

Finance Assignment-12.jpg

Finance Assignment-13.jpg

Finance Assignment-14.jpg

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question