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 | (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 variation:
Sharpe ratio:
The statistical return information of the portfolio is being calculated as follows
|
Risk Free |
4% |
||
|
Demand |
Probability |
Rate % |
|
|
Weak |
0.1 |
-38 |
|
|
Bel Avg |
0.1 |
-14 |
|
|
Avg |
0.3 |
13 |
|
|
Ab Avg |
0.3 |
31 |
|
|
Strong |
0.2 |
63 |
For the
Expected Return we have
Er= (Prob1 (Er1)+ Prob 2x Er2….. )
= (0.1*-38) + (.1*-14) …… (0.2*63)
= 20.6 %
Standard Deviation
Is calculated based on probanlistic return
= ((P1 (return 1- exp return)^2 + p2( return 2- exp return)^2 ……..) ^ 0.5
= 0.1 ( -38-20.60)^2 + 0.1(-14 – 20.6)^2 ……. )^0.5
= 29.54%
Coefficient of variation
CV= Std dev / Mean = 29.537 / 20.6 = 1.43
Sharpe ratio = Rp – Rf / Std dev
Where Rp is exp return of portfolio
Rf = risk free rate of 4%
Sharpe ratio = 20.60- 4 / 29.537
= 0.56
|
Risk Free |
4% |
|||||
|
Demand |
Probability |
Rate % |
Deviation from mean square |
ProbxRate% |
Prob*Dev from mean sw |
|
|
Weak |
0.1 |
-38 |
3433.96 |
-3.8 |
343.396 |
|
|
Bel Avg |
0.1 |
-14 |
1197.16 |
-1.4 |
119.716 |
|
|
Avg |
0.3 |
13 |
57.76 |
3.9 |
17.328 |
|
|
Ab Avg |
0.3 |
31 |
108.16 |
9.3 |
32.448 |
|
|
Strong |
0.2 |
63 |
1797.76 |
12.6 |
359.552 |
|
|
Return of portfolio |
20.60 |
|||||
|
Std dev |
29.54 |
|||||
|
Coefficient of Var |
1.43 |
|||||
|
Sharpe |
0.56 |
Thanks . Please Upvote if you like