Question

Assume that security returns are generated by the single-index model, Ri - Qi + BiRM + ei where R is the excess return for security i and Ry is the market's excess return. The risk-free rate is 2%. Suppose also that there are three securities A, B, and C, characterized by the following data: Security Bi A 0. 6 B 0.9 C 1.2 E(Ri) (ei) 7 % 16% 107 13 10 a. If Om = 10%, calculate the variance of returns of securities A, B, and C. Variance Security A Security B Security C b. Now assume that there are an infinite number of assets with return characteristics identical to those of A, B, and C, respectively. What will be the mean and variance of excess returns for securities A, B, and C? (Enter the variance answers as a percent squared and mean as a percentage. Do not round intermediate calculations. Round your answers to the nearest whole number.) Mean Variance Security A Security B Security C

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

ke - Microsoft Excel (Product Activation Failed) Add-Ins Minimize General za Merge & Center - sv%, Wrap Text Merge & Center - Σ AutoSum : A Fill 2 m Sort & Find & $ o 15 Conditional force soient un insert Delete :.: Insert Delete Format % , Number Conditional Format Formatting as Table Styles Cell Styles File Home Insert Page Layout Formulas Data Review View % Cut Calibri -11AA = = = Dr Ea Copy Paste Format Painter BI U D- DA Clipboard Font Alignment HY487 fic HQ HR HS HT HU 469 2 Clear Filter Editing Select Cells HU HW HX HY HZ IA IB 470 471 472 a 473 total variance of security = (standard deviation of security)^2=(beta)^2(standard deviation of market)^2 + (standard deviation of error term)^2 total variance of A = (0.6^2 * 10^2) + 16^2 = 292.00 292 (rounded to zero decimal) total variance of B = (0.9^2 * 10^2)+7^2 = 130.00 130 (rounded to zero decimal) total variance of C = (1.212 * 10^2)+10^2 = 244.00 244 (rounded to zero decimal) 474 475 476 477 b 478 479 480 481 482 483 484 IF THERE ARE INFINITE NUMBER OF ASSETS WITH RETURN CHARACTERISITICS IDENTICAL TO THOSE OF A.B & C THE PORTFOLIO CONSISTS OF X SECURITIES WILL HAVE MEAN OF 7 & VARIANCE EQUAL TO (0.6^2 * 10^2) = THE PORTFOLIO CONSISTS OF X SECURITIES WILL HAVE MEAN OF 10 & VARIANCE EQUAL TO (0.9^2 * 10^2) = THE PORTFOLIO CONSISTS OF X SECURITIES WILL HAVE MEAN OF 13 & VARIANCE EQUAL TO (1.242 * 10^2) = 36 81 144 SECURITY MEAN WILL BE SAME AS THAT OF INDIVIDUAL ASSET VARIANCE 36 81 144 485 486 487 convexity DGM betaport future INDEX INTL CAP BUD SANDRINE LEASING PV, FV, ANNUITY DIR right clean HON Rea KE CAPM UTILITY, SHARPE, beta ferences: AG470 YIELD bond portfolio WACC RI O BOI 130% - O- 9 . * . 10 ENG 28-11-2019 ... B