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
