03 Jun Question This question asks you to test CAPM by look
Question
This question asks you to test CAPM by looking at the historical performance of small stocks and value stocks using Excel. The data are in CAPM data.xls. We will focus on five risky assets: four stock portfolios called small-low, small-high, big-low, big-high, and a value-weighted stock index that we will treat as the market portfolio. Here “small” and “big” refer to market capitalization, while “low” refers to growth stocks (low book-market ratios), and “high” refers to value stocks (high book-market ratios). Thus for example the small-low portfolio is a portfolio of growth stocks with small market capitalization. The data set runs from January 1930 to December 2004 and contains excess returns Ri?Rf (where Rf is the return on 90-day Treasury bills) for all five risky portfolios. In parts a)-f) of this problem we will focus on the period 1/1930-12/1963 only. The test on the period 1/1964-12/2004 has already been finished in the spreadsheet for reference and comparison.
a) Download the data. What are the average excess returns for the five risky portfolios during 1/1930-12/1963? Use Excel to compute your answers in row 6, columns I-M.
b) What are the betas of the five portfolios during 1/1930-12/1963? To answer, in I7 write =SLOPE(B$6:B$413,$F$6:$F$413). This expression will compute the slope coefficient ?i of a linear regression Ri ? Rf = ?i + ?i (Rm ? Rf ) + ?i
in which the left hand side variable is contained in B$6:B$413 in the spreadsheet (excess return on small-low portfolio), while the right hand side variable is contained in $F$6:$F$413 (excess return on market). Thus, by definition, Excel computes the beta of the small-low portfolio in I7. Repeat the same procedure for columns J-M in row 7 to compute the betas of all other portfolios for 1/1930-12/1963.
c) What are the alphas of the five portfolios? To answer, in row 8 let’s compute the intercepts in the linear regression discussed in part b). Use the INTERCEPT command in Excel to do this. (The intercept is, by definition, the alpha.)
d) What expected excess returns are predicted by CAPM? According to the CAPM equation we should have E[Ri] ? Rf = ?i (E[Rm] ? Rf ). Following this equation, in row 9, compute the product of ?i, and E[Rm] ? Rf for all five portfolios.
e) Compare rows 6 and 9. Do you see a big difference between the CAPM predicted mean excess returns and the actual mean excess returns? You can also do this comparison by looking at the magnitude of the alphas (which are the difference between the predicted and true mean excess returns).
f) Plot the security market line predicted by CAPM, as well as the actual position of the five portfolios in (beta, expected return) space. If you successfully finished part a)-f), you should be able to see the plot show up below the table. Does CAPM work in this data? Please turn in a printout of your table and figure with the solution.
g) Compare your results with the later time period (1/1964-12/2004). Does CAPM work over the more recent period? Which portfolio has the highest alpha?
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.