Answer:
Stock's expected return = 12.90%
Standard Deviation = 29.68%
Coefficient of variation = 2.30
Sharpe ratio = 0.30
Explanation:
Note: See the attached excel file for the calculations of the Stock's expected return and Variance.
Given:
Risk-free rate = 4%.
From the attached excel file, we have:
Stock's expected return = Total of Stock's Expected Return = 0.1290, or 12.90%
Variance = Total of F = 0.0880890, or 8.8089%
Standard Deviation = Variance^0.5 = 0.0880890^0.5 = 0.2968, or 29.68%
Coefficient of variation = Standard Deviation / Stock's expected return = 29.68% / 12.90% = 2.30
Sharpe ratio = (Stock's expected return - Risk-free rate) / Standard Deviation = (12.90% - 4%) / 29.68% = 0.30