.

. Themes Aa. Excel File Edit View Insert Format Tools Data Window Window Help 5) ) 76% a EU.S. Thu 2:14 AM QE OO chapter03_wacc.xlsm 2 6 3. 2. 2. Y. f LE LOOX - ? Q- Search in Sheet n Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Alignment Number Format Cells Themes Fill Arial - 11-AA- abc Wrap Text Number 1. Percent 2 XII ES Clear B IV - -A Paste Merge % .00 . Conditional Normal Insert Delete Formatting Format B4 % fx 36.4323 B D D G H 1 K L M 1 Coca-Cola Stock Price 2015-2020 Amazon Stock Price 2015-2020 S&P 500 Index 2015-2020 2 Date Adj Close % Return Date Adi Close % Return Date Index % Return 3 12/1/15 36.47 12/1/15 675.89 12/1/15 2043.94 S&P 500 Historical Avorage Monthly Return 4 1/1/16 1/1/16 587.00 1/1/16 1940 24 Coca-Cola Beta 5 2/1/16 36.61 2/1/16 562.52 2/1/16 1932.23 Amazon Beta 6 3/1/16 39.38 3/1/16 593.84 3/1/16 2059.74 7 4/1/16 36.32 4/1/16 659.59 4/1/16 2065.30 8 5/1/16 38.15 5/1/16 722.79 5/1/16 2096.95 9 6/1/18 36.78 6/1/16 715.62 8/1/18 2098.86 10 7/1/16 37.61 7/1/16 758.81 7/1/16 2173.60 11 8/1/16 37.44 8/1/16 769.16 8/1/16 2170.95 12 9/1/16 36.46 9/1/16 837.31 9/1/16 2166 27 13 10/1/16 36.85 10/1/16 789.82 10/1/16 2126.15 14 11/1/16 35.07 11/1/16 750.57 11/1/18 2198.81 15 12/1/16 36.34 12/1/16 749.87 12/1/16 2238.83 16 1/1/17 36.43 1/1/17 823.48 1/1/17 2278.87 17 2/1/17 36.77 2/1/17 345.04 2/1/17 2363 64 18 3/1/17 37.19 3/1/17 886.54 3/1/17 2362.72 19 4/1/17 36.15 4/1/17 924.99 4/1/17 2384 20 20 5/1/17 40.20 5/1/17 904.62 5/1/17 2411.80 21 6/1/17 39.65 6/1/17 968.00 6/1/17 2423.41 22 7/1/17 40.06 7/1/17 907.78 7/1/17 2470.30 23 8/1/17 40.60 8/1/17 980.60 8/1/17 2471.65 24 9/1/17 40.12 9/1/17 981.35 9/1/17 2519 36 25 10/1/17 41.31 10/1/17 1105.28 10/1/17 2575.26 26 11/1/17 41.13 11/1/17 1176.75 11/1/17 2647.58 27 12/1/17 41.56 12/1/17 1109.47 12/1/17 2673.61 28 1/1/18 43.11 1/1/18 1450.00 1/1/18 2823.81 29 2/1/18 39.15 2/1/18 1512.45 2/1/18 2713.83 30 3/1/18 39.34 3/1/18 1447.34 3/1/18 2640.87 31 4/1/18 MO 39.49 4/1/18 1556.13 4/1/18 2648.05 32 5/1/18 39.30 5/1/18 1629.62 5/1/18 2705 27 33 6/1/18 40.08 6/1/18 1699.80 6/1/18 2718.37 34 7/1/18 42.99 7/1/18 1777 44 7/1/18 2016 29 35 8/1/18 41.09 8/1/18 2012.71 8/1/18 2901.52 36 9/1/18 42.59 9/1/18 2003.00 9/1/18 2913.98 37 10/1/10 44.52 10/1/10 1590.01 10/1/18 2711.74 2R 11/11R 46.AZ 11/1/18 600 17 11/11 276017 KN Page 109,bottom assignment2 Page 73 Page 80 Page 81 For book with hidden Page 81, bottom Page 88 P: Normal View Ready Sum-36.43 18 LE Insert Format Tools Data Window 5 n ) 76% a EU.S. Thu 2:15 AM QE Excel File Edit View 2 6 Help chapter03_wacc.xlsm , LE 100% - ? Q- Search in Sheet n Home Layout Tables Charts SmartArt Formulas Edit Fort Data Review Alignment abc Wrap Text Number Format Cells Themes Fill Arial - 11-AA- Number , Percent 2 H Clear Paste i Merge - % CA Normal Conditional Formatting Insert Delete Format Themes Aa- D G H K L M 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 03 64 65 B4 . A 1/1/18 2/1/18 3/1/18 4/1/18 5/1/18 6/1/18 7/1/18 8/1/18 9/1/18 10/1/10 11/1/18 12/1/16 1/1/19 2/1/19 3/1/19 4/1/19 5/1/19 6/1/19 7/1/19 B/1/19 9/1/19 10/1/19 11/1/19 12/1/19 1/1/20 2/1/20 3/1/20 4/1/20 5/1/20 6/1/20 7/1/20 8/1/20 9/1/20 10/1/20 11/1/20 12/1/20 % fx 36.4323 B C 43.11 39.15 39.34 39.49 39.30 40.08 42.99 41.09 42.59 44.52 46.87 44.38 45.11 42.49 43.92 46.38 46.45 48.14 50.14 52.44 51.87 52.24 51.25 53.52 56.47 51.72 42.79 44.76 45.53 43.56 46.50 46.75 48.59 47.69 51.20 54.84 E E 1/1/18 2/1/18 3/1/18 4/1/18 5/1/18 6/1/18 7/1/18 8/1/18 9/1/18 10/1/10 11/1/18 12/1/18 1/1/19 2/1/19 3/1/19 4/1/19 5/1/19 6/1/19 7/1/19 8/1/19 8/1/19 10/1/19 11/1/19 12/1/19 1/1/20 2/1/20 3/1/20 4/1/20 5/1/20 6/1/20 7/1/20 8/1/20 9/1/20 10/1/20 11/1/20 12/1/20 F 1450.89 1512.45 1447.34 1556.13 1629.62 1699.80 1777.44 2012.71 2003.00 1590.01 1690.17 1501 97 1718.73 1639.83 1780.75 1926.52 1775.07 1896.63 1856.78 1776.29 1735.91 1770 66 1800.80 1847.84 2000.72 1883.75 1949.72 2474.00 2442.37 2758.82 3161.68 3450.90 3148.73 3036.15 3168.04 3256.93 1 1/1/18 2/1/18 3/1/18 4/1/18 5/1/18 6/1/18 7/1/18 8/1/18 9/1/18 10/1/10 11/1/18 12/1/18 1/1/19 2/1/19 31/19 4/1/19 5/1/19 6/1/19 7/1/19 3/1/19 9/1/19 10/1/19 11/1/19 12/1/19 1/1/20 2/1/20 3/1/20 4/1/20 5/1/20 6/1/20 7/1/20 8/1/20 9/1/20 10/1/20 11/1/20 12/1/20 2823.81 2713 83 2640.87 2648.05 2705 27 2718.37 2A1629 2901 52 2913.98 2711.74 2760.17 2506 A5 2704.10 2784.49 2034 40 2945.83 2752 06 2941.76 2980.38 2926.46 2976.74 303756 3140.98 3230.78 3225.52 2954.22 2584 59 2912.43 3044.31 3100.29 3271.12 3500 31 3363.00 3269.96 3621.63 375607 KN Page 109,bottom assignment2 Page 73 Page 80 Page 81 Normal View Ready For book with hidden Page 81, bottom Page 88 P: Sum 36.43 18 . Question 5 0 / 10 pts Go to assignment2 sheet in the Chapter 3 Excel file. Compute the 60 monthly log returns of S&P 500 using its 61 monthly indices from August 2015 to August 2020, and then report the annualized historical average monthly return of S&P 500