Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compute and fill out the excel sheet. Compute the AVERAGE monthly return of S&P, Coca-Cola Beta, and Amazon Beta. Amazon Stock Price 2015-2020 Date Adj

image text in transcribedimage text in transcribedimage text in transcribed

Compute and fill out the excel sheet. Compute the AVERAGE monthly return of S&P, Coca-Cola Beta, and Amazon Beta. image text in transcribed

Amazon Stock Price 2015-2020 Date Adj Close % Return 8/1/15 512.89 9/1/15 511.89 10/1/15 625.90 11/1/15 664.80 12/1/15 675.89 1/1/16 587.00 2/1/16 552.52 3/1/16 593.64 4/1/16 659.59 5/1/16 722.79 6/1/16 715.62 7/1/16 758.81 8/1/16 769.16 9/1/16 837.31 10/1/16 789.82 11/1/16 750.57 12/1/16 768.66 1/1/17 823.48 2/1/17 845.04 3/1/17 886.54 4/1/17 924.99 5/1/17 994.62 6/1/17 968.00 7/1/17 987.78 8/1/17 980.60 9/1/17 961.35 10/1/17 1105.28 11/1/17 1176.75 12/1/17 1169.47 1/1/18 1450.89 2/1/18 1512.45 3/1/18 1447.34 4/1/18 1566.13 5/1/18 1629.62 6/1/18 1699.80 7/1/18 1777.44 8/1/18 2012.71 9/1/18 2003.00 10/1/18 1598.01 11/1/18 1690.17 12/1/18 1501.97 1/1/19 1718.73 2/1/19 1639.83 3/1/19 1780.75 4/1/19 1926.52 5/1/19 1775.07 6/1/19 1893.63 7/1/19 1866.78 8/1/19 1776.29 9/1/19 1735.91 10/1/19 1776.66 11/1/19 1800.80 12/1/19 1847.84 1/1/20 2008.72 2/1/20 1883.75 3/1/20 1949.72 4/1/20 2474.00 5/1/20 2442.37 6/1/20 2758.82 7/1/20 3164.68 8/1/20 3450.96 S&P 500 index 2015-2020 Date Index % Return 8/1/15 1972.18 9/1/15 1920.03 10/1/15 2079.36 11/1/15 2080.41 12/1/15 2043.94 1/1/16 1940.24 2/1/16 1932.23 3/1/16 2059.74 4/1/16 2065.30 5/1/16 2096.95 6/1/16 2098.86 7/1/16 2173.60 8/1/16 2170.95 9/1/16 2168.27 10/1/16 2126.15 11/1/16 2198.81 12/1/16 2238.83 1/1/17 2278.87 2/1/17 2363.64 3/1/17 2362.72 4/1/17 2384.20 5/1/17 2411.80 6/1/17 2423.41 7/1/17 2470.30 8/1/17 2471.65 9/1/17 2519.36 10/1/17 2575.26 11/1/17 2584.84 12/1/17 2673.61 1/1/18 2823.81 2/1/18 2713.83 3/1/18 2640.87 4/1/18 2648.05 5/1/18 2705.27 6/1/18 2718.37 7/1/18 2816.29 8/1/18 2901.52 9/1/18 2913.98 10/1/18 2711.74 11/1/18 2760.17 12/1/18 2506.85 1/1/19 2704.10 2/1/19 2784.49 3/1/19 2834.40 4/1/19 2945.83 5/1/19 2752.06 6/1/19 2941.76 7/1/19 2980.38 8/1/19 2926.46 9/1/19 2976.74 10/1/19 3037.56 11/1/19 3140.98 12/1/19 3230.78 1/1/20 3225.52 2/1/20 2954.22 3/1/20 2584.59 4/1/20 2912.43 5/1/20 3044.31 6/1/20 3100.29 7/1/20 3271.12 8/1/20 3500.31 Coca-Cola Stock Price 2015-2020 Date Adj Close % Return 8/1/15 39.32 9/1/15 40.12 10/1/15 42.35 11/1/15 42.62 12/1/15 42.96 1/1/16 42.92 2/1/16 43.13 3/1/16 46.39 4/1/16 44.80 5/1/16 44.60 6/1/16 45.33 7/1/16 43.63 8/1/16 43.43 9/1/16 42.32 10/1/16 42.40 11/1/16 40.35 12/1/16 42.00 1/1/17 41.57 2/1/17 41.96 3/1/17 42.44 4/1/17 43.15 5/1/17 45.47 6/1/17 44.85 7/1/17 45.84 8/1/17 45.55 9/1/17 45.01 10/1/17 45.98 11/1/17 45.77 12/1/17 45.88 1/1/18 47.59 2/1/18 43.22 3/1/18 43.43 4/1/18 43.21 5/1/18 43.00 6/1/18 43.86 7/1/18 46.63 8/1/18 44.57 9/1/18 46.19 10/1/18 47.88 11/1/18 50.40 12/1/18 47.35 1/1/19 48.13 2/1/19 45.34 3/1/19 46.86 4/1/19 49.06 5/1/19 49.13 6/1/19 50.92 7/1/19 52.63 8/1/19 55.04 9/1/19 54.44 10/1/19 54.43 11/1/19 53.40 12/1/19 55.35 1/1/20 58.40 2/1/20 53.49 3/1/20 44.25 4/1/20 45.89 5/1/20 46.68 6/1/20 44.68 7/1/20 47.24 8/1/20 49.53 S&P 500 Historical Average Monthly Return Coca-Cola Beta Amazon Beta

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Financial Management

Authors: Eugene F. Brigham, Joel F. Houston

16th Edition

0357517571, 978-0357517574

More Books

Students also viewed these Finance questions

Question

Explain the focus of safety programs.

Answered: 1 week ago

Question

Describe the consequences of musculoskeletal disorders.

Answered: 1 week ago