Please answer these questions through excel if calculations are neccesary in the question! Show all formulas. IF YOU ARE NOT GOING TO USE EXCEL, DO NOT ANSWER

1 Homework Assignment for CAPM and Market Model (7.1 points in total) Show all formula, steps and calculation for full credits (for problem solving). 1. (0.3 point) Your invest $4,000 in Stock A and $6,000 in Stock B. Your forecast a 12 rate of return for A and a 15% for B. Your forecasted wealth in one year is (a) $11,380. (b) $11,960. (c) $ 1,380. (d) $12,420. (e) $ 2,420. 2. (0.3 point) You own 100 shares of A with a present value of $30 per share; 200 shares of B at $20. You forecast a rate of return of 10% for A; 14% for B. Your portfolio expected return IS (a) 12.08. (b) 10.89. (c) 11.69. (d) 12.31. 3. (0.2 point) The calculation of wealth at the end of the holding period includes (a) only market value. (b) market value plus dividends, but not interest receipts. (c) only dividend and interest receipts. (d) market value plus any dividend or interest receipts. 4. (0.2 point) The normal probability distribution of possible return (a) considers only down-side risk. (b) ignores up-side risk. (c) ignores down-side risk. (d) considers only up-side risk. (e) assumes symmetric risk. 5. (0.2 point) A positive covariance between two stocks' returns means (a) both returns have positive standard deviations. (b) both have positive expected returns. (c) the two returns tend to move together. (d) the two returns tend to move in opposite directions. (e) there is no relationship between the two stocks' returns. strong positive relationship. The correlation 2.0. (d) 0.9