Historical nominal returns for Coca-Cola have been 8% and -20%. The nominal returns for the market index S&P500 over the same periods were -15% and 28%. Calculate the beta for Coca-cola.

International Financial Management
14th Edition
ISBN:9780357130698
Author:Madura
Publisher:Madura
Chapter10: Measuring Exposure To Exchange Rate Fluctuations
Section: Chapter Questions
Problem 40QA
icon
Related questions
Question

Historical nominal returns for Coca-Cola have been 8% and -20%. The nominal returns for the market index S&P500 over the same periods were -15% and 28%. Calculate the beta for Coca-cola.

Can you do this with Excel and without Excel (using formulae please) corresponding to the formula attached. 

The other image shows previous answer from an expert but I think the formula used for Beta seems wrong.

 

Expert Solution
steps

Step by step

Solved in 3 steps with 5 images

Blurred answer
Knowledge Booster
Rate Of Return
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
International Financial Management
International Financial Management
Finance
ISBN:
9780357130698
Author:
Madura
Publisher:
Cengage