Show

Show excel financial formula if possible!

G H 1 1. A Stock's return has the distribution as shown in the table below. Calculate the stock's expected return, and standard deviation. SHOW ALL CALCULATIONS!! Market Demand Weak Below Average Average Above Average Strong Probability of Occurrence 0.15 0.2 0.3 0.2 0.15 Return Associated with Occurrence -12% 0% 10% 18% 23% c. In a qualitative rather than a quantitative sense, what happens to the Standard Deviation of the Rate of Return calculated above if the return associated with Weak M Demand increases from -12% to -10%, and the return associated with Strong Market Demand declines from 23% to 20%? Why? 2. Suppose the risk-free rate is 2.25% and the Required Return on the Market is 8.50%. What is the required rate of return on: A. a stock with a Beta = 0.85? B. a stock with a Beta = 1.35