Could you Please
leave a THUMBS UP for encouraging me..
There are two portfolios A and B, which you think capture macroeconomic risks. Denote the excess...
Consider the two (excess return) index-model regression results for stocks A and B. The risk-free rate over the period was 8%, and the market's average return was 16%. Performance is measured using an index model regression on excess returns. Stock 18 + 1.2 (ry - rp) 0.677 Index model regression estimates R-square Residual standard deviation, (e) Standard deviation of excess returns Stock B 28 +0.8(IN - rf) 0.487 20.88 28.30 126 23.38 a. Calculate the following statistics for each stock:...
I would like to know how to solve these questions step by step
on excel. How do you do that?
Consider the data contained in the table below, which lists 30
monthly excess returns to two different actively managed stock
portfolios (A and B) and three different common risk factors (1, 2,
and 3). (Note: You may find it useful to use a computer spreadsheet
program such as Microsoft Excel to calculate your answers.)
Period Porttolio A Porttolio B Factor...