Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

based on the following 5 year data, answer the following on tbe 3rd attachment & show the excel formula. huge thumbs up if correct! thanks

based on the following 5 year data, answer the following on tbe 3rd attachment & show the excel formula. huge thumbs up if correct! thanks image text in transcribed
image text in transcribed
image text in transcribed
Forma Parte Clipboard SIGN IN TO OFFICE It looks like your stored credential are out of date. Please sign in as S Number a du so we can verify your subscription u m Date: Adj. Close: (Citations Below) Monthly Returns: (In Percent) S&P500 (SPY): Coca Cola (KO): Netflix (NFLX): 9.16 0.81 2.73 4.83 1.68 1.46 10.97 8.65 5. 4.16 - 11.37 -0.71 0.66 -2.48 0 -2.52 -0.31 1.24 0.75 -0.42 -1.04 0.32 19.46 -0.78 -12.77 4.12 11.95 15.78 -1.18 -23.54 0.57 -1.15 10.06 0.73 S&P500 (SPY): Coca-Cola (KO): Netflix (NFLX): 1/1/2015 180.740311 34.978382 6 3.114285 2/1/2015 190.898758 36.783059 67.844284 3/1/2015 187.065536 34.451626 59.527142 4/1/2015 189.748367 34.746067 79.5 5/1/2015 192.187805 35.08873 89.151428 6/1/2015 137.372604 11.506709 SUMS72 7/1/2015 192.537247 35.451859 114.309988 8/1/2015 182.166932 33.961693 115.029999 9/1/2015 175.277496 34.652683 103.260002 10/1/2015 192.057938 36.895635 108.379997 11/1/2015 191.874023 37.130924 123.330002 12/1/2015 187.442459 37.714157 114.379997 1/1/2016 179.170334 37.679047 91.839996 2/1/2016 179.022339 37.863411 93.410004 3/1/2016 190.084061 40.72533 102.230003 4/1/2016 191.81749 39.636204 90.029999 5/1/2016 195,080612 39.459244 102.57 6/1/2016 194.745926 40.105118 91.480003 7/1/2016 202.898254 38.892076 91.25 8/1/2016 203.14119 38.718773 97.449997 9/1/2016 202.131958 37.729183 98.550003 10/1/2016 199.630951 38.109337 124.870003 11/1/2016 205.985031 36.266788 117 12/1/2016 209.941558 38. 6954 123.500003 1/1/2017 214.960022 37.679199 140.710007 2/1/2017 223.406097 30.0127 142.130005 3/1/2017 222.716461 46777 147.809995 4/1/2017 225.905701 39.456528 152.199997 5/1/2017 229.093587 41 57792 163.070007 6/1/2017 229.435436 41011009 149.410004 7/1/2017 235.293213 42.261227 131.660004 8/1/2017 235.979721 41.99187 174.710007 9/1/2017 239.545776 41.496021181.350006 Coca-Cola Stock Prices - Monthly Return Comparison of Data 2.26 136 -2.09 -1.18 -0.35 -2.21 -1.18 -1.99 - 13.20 11.54 - 12.09 -1.23 5.20 7.15 -0.76 -2.01 3.50 6.35 1.96 4.02 0.10 25.32 -8.87 15.91 7:45 0.30 1.19 -0.65 -0.56 -0.01 4.68 3.39 -1.69 2.19 2.19 0.56 -157 - 14.66 0.25 -0.31 2.57 -1.50 Type here to search Activity2F340 Review View Saved Help Formulas Data 2 x Home Insert Page Layout out Calibri Copy - Format Painter B IU - - 11 AA EE - - A. Wrap Text Merge & Center - $ -% % 40 Conditional For Formatting to SIGN IN TO OFFICE looks like your stored credentials are out of date. Please sign in as S u m e du so we can verify your subscription Sign in - -120 0.55 0.77 14.79 -10.87 -9.19 1.33 5.22 -5.09 -0.30 7724 20.08 2.97 16.11 -1.20 -0.19 38.83 -54.98 9.94 2.01 7.72 10/1/2017 11/1/2017 12/1/2017 1/1/2018 2/1/2018 3/1/2018 4/1/2018 5/1/2018 6/1/2013 7/1/2018 8/1/2018 9/1/2018 10/1/2018 11/1/2018 12/1/2018 1/1/2019 2/1/2019 3/1/2019 4/1/2019 5/1/2019 6/1/2019 71/2019 8/1/2019 9/1/2019 10/1/2019 11/1/2019 12/1/2019 X 246.407227 42.727592 196.429993 25191919 2:51 195 SOM 255.711655 42.964207 191.960007 271.506028 44.526277 270.29998 261.63205 40.4921 291.180005 251.445526 40.60683 295.350006 255.775681 40.540092 312 459991 261.993317 40.641605 351.500006 20122013 41454641391429993 273.261749 OM 337.450012 281.984253 42.500675 367.679993 282.382538 44,04546 374.130005 264.058674 46,045149 301.779999 268.956757 48.4688 286.130005 243.851501 45.295733 267.660004 264.913605 45.651779 29.5 273.501007 43.947472 58.100006 277.230438 45.420784 356.559998 20.826965 47.968349 370 540009 271.34433 1036789 2021503 49.786957 357.320007 2.51 51.100619 289.51458 54.23539 293.75 293.960541 53.644157 267.619993 301.845947 54,02644 287.410004 312.772247 53.000078 314.660004 320.285309 55. 38 323.570007 -0.60 -19.32 3.90 -2.96 0.54 1.00 1.42 5.45 -7135 -16.55 -19.47 20.54 17.50 1.57 -0.24 0.47 2.73 11.60 1.55 12.98 -1948 0.75 21.00 1.07 1.37 -5.93 3.28 6.59 9.93 6.51 -1.59 -0.62 -30.24 27.13 18.79 26.25 1.35 5 References: 67 Netflix (NFLX) Stock Historical Prices & Data (2020, J ary 2). Retrieved from 68 https//finance.yahoo.com/quote/Nxhistoryprodo1420174 Seriod-1571200 intervals moniter history & frequency mo To Coca Cola (KO) Stock Historical Prices & Duta (2020. January 2). Retrieved from 71 httpsc hoe.com/stort periodic 201 1 577901200 interattieniston freesime Coca Cola Stock Prices Monthly Return comparison of Data Type here to search X Cut Copy - Paste Calibri 11 AAE W rap Test General Format Painter BIU- A. Merge & Center - $ - % Clipboard SIGN IN TO OFFICE It looks like your stored credentials are out of date. Please sign in as S***@um******edu so we can verify your su Alignment Number A 1 Return & Risk Statistics Over 5 Years 2 B C D S&P500 (SPY): Coca-Cola (KO): Netflix (NFLX): S&P500 (SPY 4 Average Monthly Return 6 Annualized Return 8 Standard Deviation of Monthly Return 10 Annualized Standard Deviation 14 Differences in returns and standard deviations Coca-Cola Stock Prices Monthly Return Comparison of Data Type here to search

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

Step: 3

blur-text-image

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

International Financial Management

Authors: Jeff Madura

10th Edition

1439038333, 9781439038338

More Books

Students also viewed these Finance questions

Question

List three benefits of using a to-do list.

Answered: 1 week ago

Question

Consider some type of redress for the customer, such as a coupon.

Answered: 1 week ago

Question

Demonstrate through language that you are grateful to be informed.

Answered: 1 week ago

Question

Always mention the specifi c problem the customer faced.

Answered: 1 week ago