In: Finance
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:_____
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
JUST WRITTEN IN EXCEL, NO EXCEL FUNCTION IS USED