Rewrite

profileUnited.j
1571132696016_MicrosoftEventStudyBlank1.xlsm
Home>Business & Finance homework help>Management homework help>Rewrite

Dividend 1

Date MSFT MKTRET IGM MSFTRET MKTRET IGMRET AR T-Stat Significant? CAR AR T-Stat Significant CAR
1/21/03 18.76 887.62 29.62
1/17/03 18.8 901.78 29.82
1/16/03 20.22 914.6 30.99
1/15/03 20.56 918.22 31.69
1/14/03 20.82 931.66 32.28
1/13/03 20.6 926.26 31.97
1/10/03 20.43 927.57 32.12
1/9/03 20.39 927.57 31.86
1/8/03 19.82 909.93 30.92
1/7/03 20.39 922.93 31.51 Single-Factor Model Two-Factor Model
1/6/03 20.01 929.01 31.23 Intercept <-- Industry Market Intercept
1/3/03 19.65 908.59 30.13 Slope (Beta) <-- Slope <--
1/2/03 19.63 909.03 29.93 Standard Error <-- Standard Errors
12/31/02 18.89 879.82 28.63 R-Square <-- R-Square
12/30/02 19.27 879.39 28.59 F Statistic
12/27/02 19.35 875.4 28.82 Ssxy
12/26/02 19.51 889.66 29.16
12/24/02 19.67 892.47 29.48
12/23/02 19.73 897.38 29.64
12/20/02 19.38 895.76 29.51
12/19/02 19.41 884.25 29.02
12/18/02 19.56 891.12 29.4
12/17/02 19.86 902.99 30.45
12/16/02 19.91 910.4 30.62
12/13/02 19.18 889.48 29.78
12/12/02 19.79 901.58 30.6
12/11/02 19.97 904.96 30.58
12/10/02 19.73 904.45 30.52
12/9/02 19.56 892 29.54
12/6/02 20.27 912.23 31.07
12/5/02 20.22 906.55 30.98
12/4/02 20.66 917.58 31.65
12/3/02 20.72 920.75 32.64
12/2/02 21.08 934.53 33.77
11/29/02 21.08 936.31 33.36
11/27/02 21.22 938.87 33.7
11/26/02 20.79 913.31 32.22
11/25/02 21.28 932.87 33.41
11/22/02 21.27 930.55 32.69
11/21/02 21.13 933.76 32.83
11/20/02 20.69 914.15 31.17
11/19/02 20.05 896.74 29.98
11/18/02 20.41 900.36 30.5
11/15/02 20.71 909.83 30.8
11/14/02 20.82 904.27 30.78
11/13/02 20.23 882.53 29.37
11/12/02 19.92 882.95 28.99
11/11/02 19.68 876.19 28.24
11/8/02 20.13 894.74 29.09
11/7/02 20.47 902.65 29.66
11/6/02 20.84 923.76 31.12
11/5/02 20.71 915.39 30.31
11/4/02 20.5 908.35 30.21
11/1/02 19.37 900.96 29.43
10/31/02 19.54 885.76 28.49
10/30/02 19.41 890.71 28.14
10/29/02 19.03 882.15 27.58
10/28/02 18.98 890.23 28.07
10/25/02 19.25 897.65 28.17
10/24/02 18.72 882.5 27.45
10/23/02 19.44 896.14 27.36
10/22/02 18.88 890.16 26.59
10/21/02 19.19 899.72 27.41
10/18/02 19.42 884.39 26.46
10/17/02 18.55 879.2 26.05
10/16/02 18.42 860.02 24.92
10/15/02 19.11 881.27 26.49
10/14/02 18.01 841.44 24.72
10/11/02 17.86 835.32 24.4
10/10/02 16.95 803.92 23.31
10/9/02 16.07 776.76 21.87
10/8/02 16.44 798.55 22.21
10/7/02 16.1 785.28 22.15
10/4/02 15.99 800.58 22.79
10/3/02 16.37 818.95 23.5
10/2/02 16.67 827.91 23.84
10/1/02 16.89 847.91 24.47
9/30/02 15.98 815.28 23.46
9/27/02 16.53 827.37 24.45
9/26/02 16.88 854.95 24.78
9/25/02 16.99 839.66 24.91
9/24/02 16.68 819.29 23.93
9/23/02 16.53 833.7 24.22
9/20/02 17.34 845.39 24.98
9/19/02 17.25 843.32 25.28
9/18/02 17.45 869.46 26.26
9/17/02 17.28 873.52 26.58
9/16/02 17.46 891.1 27.1
9/13/02 17.51 889.81 27.53
9/12/02 17.23 886.91 27.56
9/11/02 17.75 909.45 28.92
9/10/02 18.19 909.58 28.49
9/9/02 17.79 902.96 27.91
9/6/02 17.47 893.92 27.92
9/5/02 16.77 879.15 26.79
9/4/02 17.62 893.4 27.83
9/3/02 17.18 878.02 27.26
8/30/02 17.93 916.07 28.7
8/29/02 18.48 917.8 28.94
8/28/02 18.04 917.87 28.75
8/27/02 18.58 934.82 29.5
8/26/02 19.04 947.95 30.59
8/23/02 19.08 940.86 30.39
8/22/02 19.45 962.7 31.83
8/21/02 19.1 949.36 31.31
8/20/02 18.65 937.43 30.83
8/19/02 19 950.7 31.36
8/16/02 18.27 928.77 30.21
8/15/02 18.19 930.25 29.17
8/14/02 18.16 919.62 29.02
8/13/02 17.2 884.21 28.34
8/12/02 17.71 903.8 28.02
8/9/02 17.58 908.64 28.03
8/8/02 17.87 905.46 28.26
8/7/02 17.21 876.77 27.06
8/6/02 16.69 859.57 26.85
8/5/02 16.07 834.6 25.5
8/2/02 16.23 864.24 26.73
8/1/02 16.72 884.66 27.42
7/31/02 17.53 911.62 28.54
7/30/02 17.58 902.78 29.78
7/29/02 17.63 898.96 28.97
7/26/02 16.57 852.84 26.59
7/25/02 15.65 838.68 27.05
7/24/02 16.89 843.43 28.92
7/23/02 15.72 797.7 27.73
7/22/02 17.36 819.85 28.93
7/19/02 18.11 847.75 29.32
7/18/02 18.67 881.56 30.83
7/17/02 19 906.04 31.39
7/16/02 18.73 900.94 31.3
7/15/02 18.93 917.93 30.94
7/12/02 18.95 921.39 30.94
7/11/02 19.33 927.37 30.93
7/10/02 19.09 920.47 29.87
7/9/02 19.44 952.83 30.72
7/8/02 19.34 976.98 31.38
7/5/02 20.04 989.03 32.38
7/3/02 18.94 953.99 30.67
7/2/02 18.8 948.09 29.41
7/1/02 19.24 968.65 30.5
6/28/02 19.99 989.82 32.04
6/27/02 20.07 990.64 31.81
6/26/02 19.78 973.53 31.15
6/25/02 19.35 976.14 31.26
6/24/02 19.79 992.72 32.07
6/21/02 19.1 989.14 31.72
6/20/02 19.77 1006.29 32.71
6/19/02 19.86 1019.99 33.68
6/18/02 20.46 1037.14 35.12
6/17/02 20.34 1036.17 35.5
6/14/02 20.19 1007.27 33.6
6/13/02 19.81 1009.56 34.21
6/12/02 20.29 1020.26 34.79
6/11/02 19.21 1013.6 34.38
6/10/02 19.3 1030.74 35.54
6/7/02 18.99 1027.53 35.45
6/6/02 18.96 1029.15 36.1
6/5/02 18.88 1049.9 36.59
6/4/02 18.26 1040.69 36.59
6/3/02 18.06 1040.68 35.97
5/31/02 18.6 1067.14 37.36
5/30/02 19.23 1064.66 37.69
5/29/02 19.02 1067.66 37.84
5/28/02 19.12 1074.55 38.58
5/24/02 19.46 1083.82 38.74
5/23/02 20.03 1097.08 39.53
5/22/02 19.62 1086.02 39.17
5/21/02 19.07 1079.88 38.93
5/20/02 19.73 1091.88 40.02
5/17/02 20.47 1106.59 41.01
5/16/02 20.37 1098.23 40.67
5/15/02 20 1091.07 40.15
5/14/02 20.05 1097.28 40.31
5/13/02 19.25 1074.56 38.33
5/10/02 18.29 1054.99 36.74
5/9/02 19.04 1073.01 38.12
5/8/02 20.09 1088.85 39.36
5/7/02 18.08 1049.49 35.88
5/6/02 17.77 1052.67 35.93
5/3/02 18.11 1073.43 36.55
5/2/02 18.71 1084.56 37.79
5/1/02 19.27 1086.46 38.6
4/30/02 19.1 1076.92 38.95
4/29/02 19.09 1065.45 37.89
4/26/02 18.82 1076.32 38.37
4/25/02 19.63 1091.48 40
4/24/02 19.37 1093.14 40.08
4/23/02 19.73 1100.96 41.12
4/22/02 20.31 1107.83 40.98
4/19/02 20.9 1125.17 42.27
4/18/02 20.6 1124.47 42.05
4/17/02 20.69 1126.07 42.56
4/16/02 21.12 1128.37 42.46
4/15/02 20.35 1102.55 40.7
4/12/02 20.44 1111.01 40.61
4/11/02 20.02 1103.69 39.86
4/10/02 20.57 1130.47 41.36
4/9/02 20.05 1117.8 40.97
4/8/02 20.91 1125.29 42.03
4/5/02 20.41 1122.73 42.19
4/4/02 20.63 1126.34 43
4/3/02 20.58 1125.4 42.98
4/2/02 20.93 1136.76 43.6
4/1/02 22.06 1146.54 44.79
3/28/02 22.04 1147.39 44.56
3/27/02 21.72 1144.58 43.71
3/26/02 21.59 1138.49 43.7
3/25/02 21.64 1131.87 43.53
3/22/02 22.09 1148.7 44.44
3/21/02 22.42 1153.59 45.16
3/20/02 21.96 1151.85 44.13
3/19/02 22.74 1170.29 45.56
3/18/02 22.71 1165.55 45.42
3/15/02 22.83 1166.16 45.09
3/14/02 22.37 1153.04 45.12
3/13/02 22.69 1154.09 45.41
3/12/02 22.85 1165.58 46.33
3/11/02 23.51 1168.26 47.65
3/8/02 23.37 1164.31 47.41
3/7/02 22.92 1157.54 45.98
3/6/02 23.25 1162.77 46.22
3/5/02 23.05 1146.14 46.15
3/4/02 23.13 1153.84 45.58
3/1/02 22.42 1131.78 43.6
2/28/02 21.32 1106.73 41.41
2/27/02 21.33 1109.89 42.08
2/26/02 21.39 1109.38 42.72
2/25/02 21.59 1109.43 43.08
2/22/02 21.19 1089.84 41.08
2/21/02 21.21 1080.95 41.17
2/20/02 21.89 1097.98 43.34
2/19/02 21.53 1083.34 42.7
2/15/02 22.01 1104.18 44.75
2/14/02 22.54 1116.48 46.02
2/13/02 22.59 1118.51 46.12
2/12/02 21.97 1107.5 45.56
2/11/02 22.34 1111.94 45.79
2/8/02 22.16 1096.22 44.98
2/7/02 21.85 1080.17 44.79
2/6/02 22.07 1083.51 44.94
2/5/02 22.34 1090.02 45.27
2/4/02 22.33 1094.44 45.84
2/1/02 22.9 1122.2 47.23
1/31/02 23.28 1130.2 47.79
1/30/02 22.96 1113.57 47.32
1/29/02 22.77 1100.64 46.51
1/28/02 23.32 1133.06 47.93
1/25/02 23.31 1133.28 47.89
1/24/02 23.6 1132.15 48.22
1/23/02 23.29 1128.18 47.3
1/22/02 23.55 1119.31 46.45
1/18/02 24.15 1127.58 48.1
1/17/02 25.53 1138.88 49.89
1/16/02 24.8 1127.57 48.51
1/15/02 25.41 1146.19 50.04

Dividend 2

Date MSFT MKTRET IGM MSFTRET MKTRET IGMRET AR T-Stat Significant? CAR AR T-Stat Significant? CAR
7/23/04 21.63 1086.2 39.3
7/22/04 22.37 1096.84 40.27
7/21/04 22.27 1093.88 39.87
7/20/04 21.85 1108.67 40.69
7/19/04 21.56 1100.9 40
7/16/04 21.2 1101.39 39.98
7/15/04 21.5 1106.69 40.56
7/14/04 21.7 1111.47 40.64 Single Factor Model Two-Factor Model
7/13/04 21.29 1115.14 41.43 Intercept <-- Industry Market Intercept
7/12/04 21.52 1114.35 41.47 Slope <-- Slope <--
7/9/04 21.49 1112.81 41.78 Standard Error <-- Standard Error
7/8/04 21.32 1109.11 41.48 R-Square <-- R-Square
7/7/04 21.68 1118.33 42.11 F Statistic
7/6/04 21.62 1116.21 42.13 Ssxy
7/2/04 22.04 1125.38 43.24
7/1/04 22.09 1128.94 43.76
6/30/04 22.03 1140.84 44.74
6/29/04 21.99 1136.2 44.4
6/28/04 21.82 1133.35 43.89
6/25/04 22.04 1134.43 44.16
6/24/04 21.9 1140.65 43.97
6/23/04 21.83 1144.06 44.12
6/22/04 21.83 1134.41 43.3
6/21/04 21.87 1130.3 42.8
6/18/04 21.87 1135.02 43.17
6/17/04 21.43 1132.05 43.02
6/16/04 21.08 1133.56 43.74
6/15/04 21.15 1132.01 43.8
6/14/04 20.75 1125.29 43.24
6/10/04 20.65 1136.47 43.87
6/9/04 20.42 1131.33 43.74
6/8/04 20.52 1142.18 44.32
6/7/04 20.39 1140.42 44.23
6/4/04 20.02 1122.5 43.26
6/3/04 19.97 1116.64 42.63
6/2/04 20.16 1124.99 43.36
6/1/04 20.14 1121.2 43.42
5/28/04 20.24 1120.68 43.6
5/27/04 20.21 1121.28 43.43
5/26/04 20.17 1114.94 43.15
5/25/04 20.14 1113.05 43.02
5/24/04 19.87 1095.41 41.99
5/21/04 19.97 1093.56 41.54
5/20/04 19.85 1089.19 41.55
5/19/04 19.77 1088.68 41.69
5/18/04 19.93 1091.49 41.29
5/17/04 19.7 1084.1 40.74
5/14/04 19.95 1095.7 41.36
5/13/04 20.14 1096.44 42.09
5/12/04 20.01 1097.28 42.16
5/11/04 20.01 1095.45 42.41
5/10/04 20.01 1087.12 41.59
5/7/04 19.89 1098.7 41.9
5/6/04 20.15 1113.99 41.92
5/5/04 20.29 1121.53 42.19
5/4/04 20.31 1119.55 41.95
5/3/04 20.33 1117.49 41.41
4/30/04 20.16 1107.3 41.46
4/29/04 20.43 1113.89 42.26
4/28/04 20.49 1122.41 43.13
4/27/04 21 1138.11 44.04
4/26/04 21.02 1135.53 44.36
4/23/04 21.25 1140.6 44.84
4/22/04 20.02 1139.93 44.47
4/21/04 19.64 1124.09 43.34
4/20/04 19.54 1118.15 42.96
4/19/04 19.7 1135.82 43.96
4/16/04 19.41 1134.61 43.64
4/15/04 19.46 1128.84 44.09
4/14/04 19.68 1128.17 44.64
4/13/04 19.64 1129.44 44.97
4/12/04 19.76 1145.2 45.43
4/8/04 19.66 1139.32 45.32
4/7/04 19.74 1140.53 44.98
4/6/04 19.91 1148.16 45.23
4/5/04 20.02 1150.57 45.99
4/2/04 19.94 1141.81 45.48
4/1/04 19.35 1132.17 44.43
3/31/04 19.23 1126.21 43.74
3/30/04 19.44 1127 44.05
3/29/04 19.53 1122.47 43.92
3/26/04 19.31 1108.06 43.39
3/25/04 19.43 1109.19 43.32
3/24/04 18.83 1091.33 41.91
3/23/04 18.63 1093.95 41.77
3/22/04 18.9 1095.4 41.56
3/19/04 19 1109.78 42.36
3/18/04 19.2 1122.32 43.1
3/17/04 19.39 1123.75 43.4
3/16/04 19.43 1110.7 42.71
3/15/04 19.41 1104.49 42.43
3/12/04 19.58 1120.57 43.53
3/11/04 19.36 1106.78 42.67
3/10/04 19.57 1123.89 43.09
3/9/04 19.84 1140.58 43.95
3/8/04 19.93 1147.2 44.02
3/5/04 20.33 1156.86 45.33
3/4/04 20.35 1154.87 45.44
3/3/04 20.35 1151.03 45.02
3/2/04 20.36 1149.1 45.22
3/1/04 20.6 1155.97 45.6
2/27/04 20.47 1144.94 45.05
2/26/04 20.45 1144.91 45.27
2/25/04 20.6 1143.67 45.13
2/24/04 20.74 1139.09 44.49
2/23/04 20.53 1140.99 44.5
2/20/04 20.5 1144.11 45.56
2/19/04 20.41 1147.06 45.66
2/18/04 20.65 1151.82 46.52
2/17/04 20.82 1156.99 46.53
2/13/04 20.51 1145.81 45.96
2/12/04 20.79 1152.11 46.24
2/11/04 20.95 1157.76 46.86
2/10/04 20.85 1145.54 46.33
2/9/04 20.75 1139.81 46.14
2/6/04 20.89 1142.76 46.29
2/5/04 20.8 1128.59 45.27
2/4/04 20.84 1126.52 45.03
2/3/04 21.05 1136.03 46.39
2/2/04 21.14 1135.26 46.23
1/30/04 21.33 1131.13 46.62
1/29/04 21.53 1134.11 46.2
1/28/04 21.38 1128.48 46.72
1/27/04 21.8 1144.05 47.44
1/26/04 22.22 1155.37 48.31
1/23/04 21.97 1141.55 47.32
1/22/04 21.61 1143.94 47.71
1/21/04 21.83 1147.62 48.17
1/20/04 21.68 1138.77 48.9
1/16/04 21.46 1139.83 48.63
1/15/04 21.25 1132.05 47.64
1/14/04 21.37 1130.52 47.48
1/13/04 21.16 1121.22 47.12
1/12/04 21.27 1127.23 47.7
1/9/04 21.34 1121.86 46.87
1/8/04 21.73 1131.92 47.35
1/7/04 21.76 1126.33 46.37
1/6/04 21.79 1123.67 46.03
1/5/04 21.71 1122.22 45.74
1/2/04 21.18 1108.48 44.36
12/31/03 21.12 1111.92 44.26
12/30/03 21.23 1109.64 44.36
12/29/03 21.19 1109.48 44.54
12/26/03 20.99 1095.89 43.9
12/24/03 20.86 1094.04 43.82
12/23/03 20.95 1096.02 43.9
12/22/03 20.97 1092.94 43.3
12/19/03 21.11 1088.66 43.15
12/18/03 21.14 1089.18 43.48
12/17/03 20.86 1076.48 42.54
12/16/03 20.88 1075.13 42.75
12/15/03 20.63 1068.04 42.65
12/12/03 20.56 1074.14 43.33
12/11/03 20.53 1071.21 43.28
12/10/03 20.51 1059.05 42.32
12/9/03 20.35 1060.18 42.13
12/8/03 20.24 1069.3 43.32
12/5/03 20.04 1061.5 43.13
12/4/03 20.21 1069.72 43.98
12/3/03 19.81 1064.73 43.76
12/2/03 19.8 1066.62 44.14
12/1/03 19.94 1070.12 44.25
11/28/03 19.84 1058.2 43.77
11/26/03 19.64 1058.45 43.52
11/25/03 19.6 1053.89 43.2
11/24/03 19.85 1052.08 43.34
11/21/03 19.37 1035.28 42.12
11/20/03 19.37 1033.65 42.1
11/19/03 19.56 1042.44 42.38
11/18/03 19.4 1034.15 41.8
11/17/03 19.4 1043.63 42.54
11/14/03 19.67 1050.35 43.05
11/13/03 19.82 1058.41 44.13
11/12/03 20.04 1058.53 44.34
11/11/03 19.91 1046.57 43.18
11/10/03 20.06 1047.11 43.49
11/7/03 20.14 1053.21 44.07
11/6/03 20.24 1058.05 44.29
11/5/03 20.14 1051.81 43.99
11/4/03 20.11 1053.25 43.8
11/3/03 20.58 1059.02 43.84
10/31/03 20.17 1050.71 43.07
10/30/03 20.15 1046.94 43
10/29/03 20.63 1048.11 42.92
10/28/03 20.99 1046.79 42.69
10/27/03 20.76 1031.13 41.38
10/24/03 20.53 1028.91 40.98
10/23/03 22.3 1033.77 41.59
10/22/03 22.29 1030.36 42.32
10/21/03 22.64 1046.03 43.03
10/20/03 22.64 1044.68 42.57
10/17/03 22.32 1039.32 42.23
10/16/03 22.55 1050.07 43.05
10/15/03 22.43 1046.76 42.99
10/14/03 22 1049.48 42.78
10/13/03 22.08 1045.35 42.79
10/10/03 22.18 1038.06 42.52
10/9/03 22.2 1038.73 42.26
10/8/03 22.11 1033.78 41.99
10/7/03 22.36 1039.25 42.07
10/6/03 22.4 1034.35 41.72
10/3/03 22.31 1029.85 41.4
10/2/03 21.87 1020.24 40.16
10/1/03 21.88 1018.22 39.87
9/30/03 21.33 995.97 39.19
9/29/03 22.12 1006.58 40.02
9/26/03 21.63 996.85 39.38
9/25/03 21.67 1003.27 39.73
9/24/03 21.84 1009.38 40.28
9/23/03 22.71 1029.03 41.7
9/22/03 22.3 1022.82 41.1
9/19/03 22.99 1036.3 41.99
9/18/03 22.63 1039.58 42.09
9/17/03 21.87 1025.97 41.46
9/16/03 22.17 1029.32 41.49
9/15/03 21.76 1014.81 40.33
9/12/03 21.74 1018.63 40.61
9/11/03 21.36 1016.42 40.5
9/10/03 21.14 1010.92 40.11
9/9/03 21.77 1023.17 41.41
9/8/03 22.13 1031.64 41.9
9/5/03 21.77 1021.39 41
9/4/03 21.81 1027.97 41.25
9/3/03 21.71 1026.27 40.77
9/2/03 20.91 1021.99 40.4
8/29/03 20.35 1008.01 39.77
8/28/03 20.34 1002.84 39.42
8/27/03 20.27 996.79 39.07
8/26/03 20.39 996.73 38.78
8/25/03 20.33 993.71 38.58
8/22/03 20.12 993.06 38.8
8/21/03 20.13 1003.27 38.77
8/20/03 20.29 1000.3 38.3
8/19/03 20.42 1002.35 38.46
8/18/03 19.72 999.74 37.83
8/15/03 19.59 990.67 36.87
8/14/03 19.66 990.51 36.69
8/13/03 19.64 984.03 36.44
8/12/03 19.74 990.35 36.42
8/11/03 19.65 980.59 35.76
8/8/03 19.63 977.59 35.37
8/7/03 19.73 974.12 35.45
8/6/03 19.68 967.08 35.79
8/5/03 19.69 965.46 36.05
8/4/03 20.09 982.82 36.98
8/1/03 20.08 980.15 37.1
7/31/03 20.26 990.31 37.32
7/30/03 20.12 987.49 36.82
7/29/03 20.31 989.28 37.2
7/28/03 20.42 996.52 37.37
7/25/03 20.63 998.68 37.15
7/24/03 19.95 981.6 36.95
7/23/03 20.29 988.61 37.08
7/22/03 20.24 988.11 36.87
7/21/03 19.98 978.8 36.19
7/18/03 20.63 993.32 36.95