Expected return 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 -30% Below average 0.1 -14 Average 0.3 11 Above average 0.3 20 Strong 0.2 45 1.0 Calculate the stock's expected return. Round your answer to two decimal places. Calculate the stock's standard deviation. Round your answer to two decimal places. % Calculate the stock's coefficient of variation. Round your answer to two decimal places.

EBK CFIN
6th Edition
ISBN:9781337671743
Author:BESLEY
Publisher:BESLEY
Chapter8: Risk And Rates Of Return
Section: Chapter Questions
Problem 17PROB
icon
Related questions
Question

Problem 8-1
Expected return

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 -30%    
Below average 0.1 -14   
Average 0.3 11 
Above average 0.3 20
Strong 0.2 45 
  1.0  

Calculate the stock's expected return. Round your answer to two decimal places.

Calculate the stock's standard deviation. Round your answer to two decimal places.
%


Calculate the stock's coefficient of variation. Round your answer to two decimal places.

 

I'm struggling with the standard deviation and coefficient of deviation. Can you please post the formulas to calculate these in excel? Thank you!

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Risk and Return
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Recommended textbooks for you
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT