show excel formulas in calculations and =formulatext or explain

You are evaluating various investment opportunities currently avallable and you have calculated expected returns and standard deviations for five different weldiversified portfolios of risky assets: (a) For each portfolio, calculate the risk premium per unit of risk that you expect to receive ([E(R)RFP]/). Assume that the risk-free rate is 3.0 per cent. (b) Using your computations in Part a, explain which of these five portfolios is most likely to be the market portfolio. Use your calculations to draw the capital market line (CML). (c) If you are only willing to make an investment with =7.0%, is it possible for you to earn a return of 7.0 per cent? (d) What is the minimum level of risk that would be necessary for an investment to earn 7.0 per cent? What is the composition of the portfolio along the CML that will generate that expected return? (e) Suppose you are now willing to make an investment with =18.2%. What would be the investment proportions in the riskless asset and the market portfolio for this portfolio? What is the expected return for this portfolio? You are evaluating various investment opportunities currently avallable and you have calculated expected returns and standard deviations for five different weldiversified portfolios of risky assets: (a) For each portfolio, calculate the risk premium per unit of risk that you expect to receive ([E(R)RFP]/). Assume that the risk-free rate is 3.0 per cent. (b) Using your computations in Part a, explain which of these five portfolios is most likely to be the market portfolio. Use your calculations to draw the capital market line (CML). (c) If you are only willing to make an investment with =7.0%, is it possible for you to earn a return of 7.0 per cent? (d) What is the minimum level of risk that would be necessary for an investment to earn 7.0 per cent? What is the composition of the portfolio along the CML that will generate that expected return? (e) Suppose you are now willing to make an investment with =18.2%. What would be the investment proportions in the riskless asset and the market portfolio for this portfolio? What is the expected return for this portfolio