Chapter 3, Problem 6P

Please fill out the parts in the above table that are shaded in yellow. You will notice that there are nine line items Please answer : Covariance with MP   Correlation with Market Index   Beta   CAPM Req. Return

(c) Consider information given in the table below and answers the question asked thereafter:   i. Calculate expected return on each stock? On the basis of this measure, which stock you will choose?ii. Calculate standard deviation of the returns on each stock? On the basis of this measure, which stock you will choose?iii. Calculate coefficient of variance of the returns on each stock? On the basis of this measure, which stock you will choose?iv. Calculate covariance and coefficient of correlation between the returns of the stocks A and B.v. Now suppose you have $100,000 to invest and you want to a hold a portfolio comprising of $35,000 invested in stock A and remaining amount in stock B. Calculate risk and return of your portfolio. (d) Firm A reports a Profit Margin of 6.5% and a Total Asset Turnover Ratio of 3.25. Their total asset level is $8,500,000. Assume there are 700,000 shares outstanding and the PE ratio is 11. Also, assume the Return on Equity is 16%. Based on this, calculate…

KINDLY ANSWER PART 5,6.and 7     Using the stock price data for any two companies provided below carry out the following tasks: 1.Compute, for each asset: i.Total Returns ii.Expected returns iii.standard deviation iv.Correlation Coefficient 2.Construct the variance-covariance matrix 3.Construct equally weighted portfolio and calculate Expected Return, Standard Deviation and Sharpe ratio. 4.Reconstruct equally weighted portfolio and calculate Expected Return, Standard Deviation and Sharpe ratio. 5.Use Solver to determine optimal risky portfolio. 6.Create hypothetical portfolios (commencing from Weight A=0 and weight B=100) 7.Calculate Expected return and Standard Deviation for all the above combinations 8.Graph the efficient frontier 9.Graph the optimal portfolio 10.Assuming that the investors prefers lower level of risk than what a portfolio of risky assets offer, introduce a risk free asset in the portfolio with a return of 3% 11.Using hypothetical weights (A= Portfolio of Risky…