Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

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

image text in transcribedimage text in transcribed

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. 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

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

Healthcare Finance An Introduction To Accounting And Financial Management

Authors: Louis C. Gapenski

4th Edition

1567932800, 978-1567932805

More Books

Students explore these related Finance questions