Apple Inc WACC Project

profilegattist
RegressionSpreadsheetCorrect.xls
Home>Business & Finance homework help>Accounting homework help>Apple Inc WACC Project

Regression Spreadsheet Correct

Date S&P Adj Close Market Return Apple's Adj Close Apple's Return
1/1/20 3,225.52 -0.0016 76.600517 0.0540
12/1/19 3,230.78 0.0286 72.675339 0.1021
11/1/19 3,140.98 0.0340 65.943619 0.0743
10/1/19 3,037.56 0.0204 61.381241 0.1107
9/1/19 2,976.74 0.0172 55.264339 0.0770
8/1/19 2,926.46 -0.0181 51.311405 -0.0202
7/1/19 2,980.38 0.0131 52.368397 0.0764
6/1/19 2,941.76 0.0689 48.65168 0.1349
5/1/19 2,752.06 -0.0658 42.869724 -0.1276
4/1/19 2,945.83 0.0393 49.138439 0.0564
3/1/19 2,834.40 0.0179 46.513416 0.1017
2/1/19 2,784.49 0.0297 42.218506 0.0403
1/1/19 2,704.10 0.0787 40.582428 0.0552
12/1/18 2,506.85 -0.0918 38.46114 -0.1136
11/1/18 2,760.17 0.0179 43.391079 -0.1840
10/1/18 2,711.74 -0.0694 53.178249 -0.0305
9/1/18 2,913.98 0.0043 54.849937 -0.0048
8/1/18 2,901.52 0.0303 55.115868 0.1962
7/1/18 2,816.29 0.0360 46.07476 0.0280
6/1/18 2,718.37 0.0048 44.820538 -0.0056
5/1/18 2,705.27 0.0216 45.072868 0.1308
4/1/18 2,648.05 0.0027 39.860565 -0.0150
3/1/18 2,640.87 -0.0269 40.468391 -0.0542
2/1/18 2,713.83 -0.0389 42.78793 0.0638
1/1/18 2,823.81 0.0562 40.21999 -0.0106
12/1/17 2,673.61 0.0098 40.652374 -0.0117
11/1/17 2,647.58 0.0281 41.133884 0.0166
10/1/17 2,575.26 0.0222 40.461285 0.0968
9/1/17 2,519.36 0.0193 36.890041 -0.0566
8/1/17 2,471.65 0.0005 39.101368 0.1027
7/1/17 2,470.30 0.0193 35.460644 0.0327
6/1/17 2,423.41 0.0048 34.337669 -0.0533
5/1/17 2,411.80 0.0116 36.27177 0.0634
4/1/17 2,384.20 0.0091 34.108673 -0.0001
3/1/17 2,362.72 -0.0004 34.111042 0.0532
2/1/17 2,363.64 0.0372 32.386887 0.1289
1/1/17 2,278.87 0.0179 28.689308 0.0477
12/1/16 2,238.83 0.0182 27.381918 0.0533
11/1/16 2,198.81 0.0342 25.995438 -0.0266
10/1/16 2,126.15 -0.0194 26.705769 0.0043
9/1/16 2,168.27 -0.0012 26.590519 0.0713
8/1/16 2,170.95 -0.0012 24.821346 0.0181
7/1/16 2,173.60 0.0356 24.379189 0.0901
6/1/16 2,098.86 0.0009 22.364946 -0.0368
5/1/16 2,096.95 0.0153 23.220165 0.0653
4/1/16 2,065.30 0.0027 21.7971 -0.1399
3/1/16 2,059.74 0.0660 25.343138 0.1333
2/1/16 1,932.23 -0.0041 22.361717 -0.0067
1/1/16 1,940.24 -0.0507 22.512041 -0.0752
12/1/15 2,043.94 -0.0175 24.343718 -0.1064
11/1/15 2,080.41 0.0005 27.242897 -0.0100
10/1/15 2,079.36 0.0830 27.519243 0.0834
9/1/15 1,920.03 -0.0264 25.4006 -0.0174
8/1/15 1,972.18 -0.0626 25.850096 -0.0704
7/1/15 2,103.84 0.0197 27.807886 -0.0329
6/1/15 2,063.11 -0.0210 28.754684 -0.0332
5/1/15 2,107.39 0.0105 29.742304 0.0410
4/1/15 2,085.51 0.0085 28.571152 0.0058
3/1/15 2,067.89 -0.0174 28.406776 -0.0275
2/1/15 2,104.50 0.0000 29.211523 0.0000
1/1/15 1,994.99 26.641926
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.5710297107
R Square 0.3260749305
Adjusted R Square 0.3142516836
Standard Error 0.0627218905
Observations 59
ANOVA
df SS MS F Significance F
Regression 1 0.1084973009 0.1084973009 27.5791358376 0.0000023268
Residual 57 0.2242400265 0.0039340356
Total 58 0.3327373274
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.009320153 0.0083840238 1.1116563214 0.2709528938 -0.007468565 0.0261088711 -0.007468565 0.0261088711
X Variable 1 1.2743861531 0.2426669977 5.2515841265 0.0000023268 0.7884538721 1.7603184341 0.7884538721 1.7603184341
The equation is highly significant with a level of 0.0000023685
A significance level of .10 or lower is acceptable
Apple's beta is 1.274 with a signficance level of 0.0000023685