Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Excel file Coco Cola Retum and Beta shows monthly returns of Coca Cola and S8.P500 index over past 60 months. The arithmetic mean of

image text in transcribed
image text in transcribed
image text in transcribed
The Excel file "Coco Cola Retum and Beta" shows monthly returns of Coca Cola and S8.P500 index over past 60 months. The arithmetic mean of Coca Cola's monthly return is % (in 3 decimal places). The arithmetic mean of SQP500 index monthly return is o (in 3 decimal places). The geometric mean of Coca Cola's monthly return is of (in 3 decimal places). he geometric mean of S&P500 index monthly return is % (in 3 decimal places). The beta of Coca Cola's stock is (3 decimal places). \begin{tabular}{|r|r|r|} \hline Month & Coca Cola & S\&P500 \\ \hline 1/31/20 & 5.364% & 0.163% \\ \hline 12/31/19 & 3.587% & 2.819% \\ \hline 11/30/19 & 1.910% & 3.348% \\ \hline 10/31/19 & 0.018% & 2.023% \\ \hline 9/30/19 & 1.096% & 1.704% \\ \hline 8/31/19 & 4.477% & 1.826% \\ \hline 7/31/19 & 3.303% & 1.304% \\ \hline 6/30/19 & 3.579% & 6.666% \\ \hline 5/31/19 & 0.143% & 6.804% \\ \hline 4/30/19 & 4.588% & 3.856% \\ \hline 3/31/19 & 3.297% & 1.777% \\ \hline 2/28/19 & 5.972% & 2.930% \\ \hline 1/31/19 & 1.634% & 7.574% \\ \hline 12/31/18 & 6.242% & 9.627% \\ \hline 11/30/18 & 5.129% & 1.770% \\ \hline 10/31/18 & 3.593% & 7.193% \\ \hline 9/30/18 & 3.570% & 0.429% \\ \hline 8/31/18 & 4.518% & 2.981% \\ \hline 7/31/18 & 6.124% & 3.539% \\ \hline 6/30/18 & 1.980% & 0.483% \\ \hline 5/31/18 & 0.487% & 2.138% \\ \hline 4/30/18 & 0.508% & 0.272% \\ \hline 3/31/18 & 0.485% & 2.725% \\ \hline 2/28/18 & 9.632% & 3.973% \\ \hline 1/31/18 & 3.659% & 5.466% \\ \hline 12/31/17 & 0.240% & 0.978% \\ \hline 11/30/17 & 0.458% & 2.770% \\ \hline 10/31/17 & 2.132% & 2.195% \\ \hline \end{tabular} \begin{tabular}{|r|r|r|} \hline 9/30/17 & 1.193% & 1.912% \\ \hline 8/31/17 & 0.635% & 0.055% \\ \hline 7/31/17 & 2.183% & 1.916% \\ \hline 6/30/17 & 1.373% & 0.480% \\ \hline 5/31/17 & 5.237% & 1.151% \\ \hline 4/30/17 & 1.659% & 0.905% \\ \hline 3/31/17 & 1.137% & 0.039% \\ \hline 2/28/17 & 0.934% & 3.652% \\ \hline 1/31/17 & 0.265% & 1.773% \\ \hline 12/31/16 & 2.714% & 1.804% \\ \hline 11/30/16 & 4.956% & 3.360% \\ \hline 10/31/16 & 0.189% & 1.962% \\ \hline 9/30/16 & 2.589% & 0.124% \\ \hline 8/31/16 & 0.459% & 0.122% \\ \hline 7/31/16 & 3.822% & 3.499% \\ \hline 6/30/16 & 1.624% & 0.091% \\ \hline 5/31/16 & 0.447% & 1.521% \\ \hline 4/30/16 & 3.488% & 0.270% \\ \hline 3/31/16 & 7.287% & 6.390% \\ \hline 2/29/16 & 0.488% & 0.414% \\ \hline 1/31/16 & 0.093% & 5.207% \\ \hline 12/31/15 & 0.795% & 1.769% \\ \hline 11/30/15 & 0.636% & 0.050% \\ \hline 10/31/15 & 5.409% & 7.972% \\ \hline 9/30/15 & 2.014% & 2.680% \\ \hline 8/31/15 & 4.379% & 6.462% \\ \hline 7/31/15 & 4.608% & 1.955% \\ \hline 6/30/15 & 4.315% & 2.124% \\ \hline 5/31/15 & 0.981% & 1.044% \\ \hline 4/30/15 & 0.025% & 0.848% \\ \hline 3/31/15 & 6.562% & 1.755% \\ \hline 2/28/15 & 5.044% & 5.344% \\ \hline & & \\ \hline \end{tabular} The Excel file "Coco Cola Retum and Beta" shows monthly returns of Coca Cola and S8.P500 index over past 60 months. The arithmetic mean of Coca Cola's monthly return is % (in 3 decimal places). The arithmetic mean of SQP500 index monthly return is o (in 3 decimal places). The geometric mean of Coca Cola's monthly return is of (in 3 decimal places). he geometric mean of S&P500 index monthly return is % (in 3 decimal places). The beta of Coca Cola's stock is (3 decimal places). \begin{tabular}{|r|r|r|} \hline Month & Coca Cola & S\&P500 \\ \hline 1/31/20 & 5.364% & 0.163% \\ \hline 12/31/19 & 3.587% & 2.819% \\ \hline 11/30/19 & 1.910% & 3.348% \\ \hline 10/31/19 & 0.018% & 2.023% \\ \hline 9/30/19 & 1.096% & 1.704% \\ \hline 8/31/19 & 4.477% & 1.826% \\ \hline 7/31/19 & 3.303% & 1.304% \\ \hline 6/30/19 & 3.579% & 6.666% \\ \hline 5/31/19 & 0.143% & 6.804% \\ \hline 4/30/19 & 4.588% & 3.856% \\ \hline 3/31/19 & 3.297% & 1.777% \\ \hline 2/28/19 & 5.972% & 2.930% \\ \hline 1/31/19 & 1.634% & 7.574% \\ \hline 12/31/18 & 6.242% & 9.627% \\ \hline 11/30/18 & 5.129% & 1.770% \\ \hline 10/31/18 & 3.593% & 7.193% \\ \hline 9/30/18 & 3.570% & 0.429% \\ \hline 8/31/18 & 4.518% & 2.981% \\ \hline 7/31/18 & 6.124% & 3.539% \\ \hline 6/30/18 & 1.980% & 0.483% \\ \hline 5/31/18 & 0.487% & 2.138% \\ \hline 4/30/18 & 0.508% & 0.272% \\ \hline 3/31/18 & 0.485% & 2.725% \\ \hline 2/28/18 & 9.632% & 3.973% \\ \hline 1/31/18 & 3.659% & 5.466% \\ \hline 12/31/17 & 0.240% & 0.978% \\ \hline 11/30/17 & 0.458% & 2.770% \\ \hline 10/31/17 & 2.132% & 2.195% \\ \hline \end{tabular} \begin{tabular}{|r|r|r|} \hline 9/30/17 & 1.193% & 1.912% \\ \hline 8/31/17 & 0.635% & 0.055% \\ \hline 7/31/17 & 2.183% & 1.916% \\ \hline 6/30/17 & 1.373% & 0.480% \\ \hline 5/31/17 & 5.237% & 1.151% \\ \hline 4/30/17 & 1.659% & 0.905% \\ \hline 3/31/17 & 1.137% & 0.039% \\ \hline 2/28/17 & 0.934% & 3.652% \\ \hline 1/31/17 & 0.265% & 1.773% \\ \hline 12/31/16 & 2.714% & 1.804% \\ \hline 11/30/16 & 4.956% & 3.360% \\ \hline 10/31/16 & 0.189% & 1.962% \\ \hline 9/30/16 & 2.589% & 0.124% \\ \hline 8/31/16 & 0.459% & 0.122% \\ \hline 7/31/16 & 3.822% & 3.499% \\ \hline 6/30/16 & 1.624% & 0.091% \\ \hline 5/31/16 & 0.447% & 1.521% \\ \hline 4/30/16 & 3.488% & 0.270% \\ \hline 3/31/16 & 7.287% & 6.390% \\ \hline 2/29/16 & 0.488% & 0.414% \\ \hline 1/31/16 & 0.093% & 5.207% \\ \hline 12/31/15 & 0.795% & 1.769% \\ \hline 11/30/15 & 0.636% & 0.050% \\ \hline 10/31/15 & 5.409% & 7.972% \\ \hline 9/30/15 & 2.014% & 2.680% \\ \hline 8/31/15 & 4.379% & 6.462% \\ \hline 7/31/15 & 4.608% & 1.955% \\ \hline 6/30/15 & 4.315% & 2.124% \\ \hline 5/31/15 & 0.981% & 1.044% \\ \hline 4/30/15 & 0.025% & 0.848% \\ \hline 3/31/15 & 6.562% & 1.755% \\ \hline 2/28/15 & 5.044% & 5.344% \\ \hline & & \\ \hline \end{tabular}

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

More Books

Students also viewed these Finance questions

Question

=+70. Refer to the data in Exercise 46 of Section 7.4.

Answered: 1 week ago