In: Finance
Factor Models Suppose a factor model is appropriate to describe the returns on a stock. The current expected return on the stock is 10.5 percent. Information about those factors is presented in the following:
Factor |
B |
Expected Value |
Actual Value |
Growth in GNP |
1.67 |
2.1% |
2.6% |
Inflation |
-1.09 |
4.3 |
4.8 |
a. What is the systematic risk of the stock return?
b. The firm announced that its market share had unexpectedly increased from 11 percent to 15 percent. Investors know from past experience that the stock return will increase by .58 percent for every 1 percent increase in its market share. What is the unsystematic risk of the stock?
c. What is the total return on this stock?
**can you please show excel formulas/details on work
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
for second answer, excel formula can not be used as we can not frame it in excel, as data is given in simple language. For all other answers, excel formula and references are provided.