Question

In: Finance

A stock's returns have the following distribution: Demand for the Company's Products Probability of This Demand...

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 -46%
Below average 0.1 -13
Average 0.4 14   
Above average 0.3 34   
Strong 0.1 56   
= 1.0

Assume the risk-free rate is 3%. 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:_____

Solutions

Expert Solution

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

JUST WRITTEN IN EXCEL, NO EXCEL FUNCTION IS USED


Related Solutions

A stock's returns have the following distribution: Demand for the Company's Products Probability of This Demand...
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 (26%) Below average 0.2 (14)    Average 0.3 10   Above average 0.3 21   Strong 0.1 73   1.0 Assume the risk-free rate is 4%. 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...
A stock's returns have the following distribution: Demand for the Company's Products Probability of This Demand...
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 (48%) Below average 0.1 (15)    Average 0.3 11    Above average 0.3 40    Strong 0.2 65    1.0 Assume the risk-free rate is 4%. 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...
A stock's returns have the following distribution: Demand for the Company's Products Probability of This Demand...
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 (28%) Below average 0.1 (11)    Average 0.4 10    Above average 0.3 35    Strong 0.1 61    1.0 Assume the risk-free rate is 4%. 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...
A stock's returns have the following distribution: Demand for the Company's Products Probability of This Demand...
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 (36%) Below average 0.1 (15)    Average 0.3 16    Above average 0.3 21    Strong 0.2 56    1.0 Assume the risk-free rate is 3%. 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...
A stock's returns have the following distribution: Demand for the Company's Products Probability of This Demand...
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 (28%) Below average 0.2 (6)    Average 0.4 18   Above average 0.1 34   Strong 0.2 56   1.0 Assume the risk-free rate is 2%. 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...
A stock's returns have the following distribution: Demand for the Company's Products Probability of This Demand...
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 (32%) Below average 0.3 (14)    Average 0.4 11   Above average 0.1 36   Strong 0.1 55   1.0 Assume the risk-free rate is 2%. 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...
A stock's returns have the following distribution: Demand for the Company's Products Probability of This Demand...
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 (38%) Below average 0.1 (14)    Average 0.3 13    Above average 0.3 31    Strong 0.2 63    1.0 Assume the risk-free rate is 4%. 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...
A stock's returns have the following distribution: Demand for the Company's Products Probability of this Demand...
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 (13) Average 0.5 17 Above Average 0.2 26 Strong 0.1 61 1.0 Calculate the stock's expected return. Round your answer to two decimal places. Calculate the stock's standard deviation. Do not round intermediate calculations. Round your answer to two decimal places. Calculate the stock's coefficient of variation. Round your answer...
A stock's returns have the following distribution: Demand for the Company's Products Probability of This Demand...
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 (26%) Below average 0.3 (8)    Average 0.4 15   Above average 0.1 36   Strong 0.1 62   1.0 Assume the risk-free rate is 3%. 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...
A stock's returns have the following distribution: Demand for the Company's Products Probability of This Demand...
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 (34%) Below average 0.1 (14)    Average 0.3 11    Above average 0.3 38    Strong 0.2 45    1.0 Assume the risk-free rate is 4%. 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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT