FIN 340 SNHU Return and Risk Statistics Over 5 Years Project

User Generated

oeraqbapebava1234

Business Finance

fin 340

Southern New Hampshire University

FIN

Description

This activity will help you gather and analyze data relating to returns and standard deviations.

Use Yahoo! Finance or another site to get monthly pricing for the S&P 500 ETF (SPY), Coca-Cola, and Netflix for the past five years. Then, calculate the following using Excel and the provided instructions:

  •       Monthly returns for each stock
  •        Average monthly return for each stock
  •        Annualized returns based on the monthly average return for each stock
  •        Standard deviation of monthly returns for each stock
  •        Annualized standard deviation based on standard deviation of monthly returns

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Here you go....Please let me know if you have any question.Thanks and Goodbye 😎

Date
1/1/2014
2/1/2014
3/1/2014
4/1/2014
5/1/2014
6/1/2014
7/1/2014
8/1/2014
9/1/2014
10/1/2014
11/1/2014
12/1/2014
1/1/2015
2/1/2015
3/1/2015
4/1/2015
5/1/2015
6/1/2015
7/1/2015
8/1/2015
9/1/2015
10/1/2015
11/1/2015
12/1/2015
1/1/2016
2/1/2016
3/1/2016
4/1/2016
5/1/2016
6/1/2016
7/1/2016
8/1/2016
9/1/2016
10/1/2016
11/1/2016
12/1/2016
1/1/2017
2/1/2017
3/1/2017
4/1/2017
5/1/2017

SPY
161.37006
168.71492
169.36702
171.29671
175.27188
178.03728
176.48622
183.451
180.07832
185.18108
190.26836
188.74399
184.16238
194.5132
190.60742
193.34084
195.82646
190.95723
196.13631
185.6142
178.55905
195.6951
195.50777
190.99223
182.56307
182.41226
193.68344
195.44931
198.77422
198.43317
206.7403
206.98787
205.95949
203.41121
210.90454
213.91908
219.03044
227.63649
226.93379
230.18341
233.43196

KO
32.185677
32.509064
32.900524
34.988251
35.091179
36.334934
33.955063
36.055107
36.86747
36....


Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags