A stock's returns have the following distribution: Demand for the Company's Products Probability of This Demand Occurring Rate of Return If This Demand Occurs Weak 0.1 (42%) Below average 0.1 (10)    Average 0.4 14    Above average 0.3 35    Strong 0.1 48      1.0   Assume the risk-free rate is 3%. With excel, calculate the stock's expected return, standard deviation, coefficient of variation, and Sharpe ratio. Do not round intermediate calculations. Round your answers to two decimal places. Stock's expected return:   % Standard deviation:   % Coefficient of variation:  Sharpe ratio:

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter8: Analysis Of Risk And Return
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

A stock's returns have the following distribution:

Demand for the
Company's Products
Probability of This
Demand Occurring
Rate of Return If
This Demand Occurs
Weak 0.1 (42%)
Below average 0.1 (10)   
Average 0.4 14   
Above average 0.3 35   
Strong 0.1 48   
  1.0  

Assume the risk-free rate is 3%. With excel, calculate the stock's expected return, standard deviation, coefficient of variation, and Sharpe ratio. Do not round intermediate calculations. Round your answers to two decimal places.

Stock's expected return:   %

Standard deviation:   %

Coefficient of variation: 

Sharpe ratio: 

Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Investment in Stocks
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
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage