step by step without using excel please

1.A pension fund manager is considering investing in 3 mutual funds: a stock fund, a long-term government and corporate bond fund and a treasury bill (T bill) money market fund. The T bill fund has an 8% safe return (rf = .08). The following table presents the expected return and standard deviation of the stock fund and the bond fund: Stock fund Expected return 20 12 Standard deviation .30 .15 Bond fund The correlation between the stock fund and the bond fund is p= .10 (a) Find the mininimum variance portfolio. That is find the proportion invested in the stock fund, WMIN and the proportion invested in the bond fund, wHIN = 1 - WMIN. Find the expected return of the min variance portfolio, E (MIN) and its standard deviation, MIN. (b) Tabulate and draw the portfolio frontier of the 2 risky funds. Vary ws and wb = 1 - ws in increments of 20. Complete the following table: ws WBE(rp) OP .20 .40 .60 1.00 and draw the portfolio frontier on a graph with E(rp) on the vertical axis and op on the horizontal axis. On that graph identify the minimum variance portfolio and the efficient portfolio frontier. (c) Draw the capital market line (CML). Identify the intercept with the vertical axis and the tangency point with the efficient portfolio frontier. (d) Find the market portfolio. That is find the proportion invested in the stock fund, WMARKET and the proportion invested in the bond fund, WMARKET = 1 - WMARKET of the market portfolio Find the expected return of the market portfolio, E (MARKET) and its standard deviation, o MARKET Find the Sharpe ratio. (e) An investor requires a target expected return of 14%, that is E (TT) = .14. Find the standard deviation of her portfolio, ot. What proportion will she invest in the monetary market fund, WMONEY? What proportion will she invest in the stock fund, ws? What proportion will she invest in the bond fund, wb? (f) If the investor wanted to invest only in the stock fund and bond fund and achieve a target return of E(TT) = .14, how much would she have to invest in the stock fund, ws and how much in the bond fund, we? What would be the level of risk of this new portfolio? 1.A pension fund manager is considering investing in 3 mutual funds: a stock fund, a long-term government and corporate bond fund and a treasury bill (T bill) money market fund. The T bill fund has an 8% safe return (rf = .08). The following table presents the expected return and standard deviation of the stock fund and the bond fund: Stock fund Expected return 20 12 Standard deviation .30 .15 Bond fund The correlation between the stock fund and the bond fund is p= .10 (a) Find the mininimum variance portfolio. That is find the proportion invested in the stock fund, WMIN and the proportion invested in the bond fund, wHIN = 1 - WMIN. Find the expected return of the min variance portfolio, E (MIN) and its standard deviation, MIN. (b) Tabulate and draw the portfolio frontier of the 2 risky funds. Vary ws and wb = 1 - ws in increments of 20. Complete the following table: ws WBE(rp) OP .20 .40 .60 1.00 and draw the portfolio frontier on a graph with E(rp) on the vertical axis and op on the horizontal axis. On that graph identify the minimum variance portfolio and the efficient portfolio frontier. (c) Draw the capital market line (CML). Identify the intercept with the vertical axis and the tangency point with the efficient portfolio frontier. (d) Find the market portfolio. That is find the proportion invested in the stock fund, WMARKET and the proportion invested in the bond fund, WMARKET = 1 - WMARKET of the market portfolio Find the expected return of the market portfolio, E (MARKET) and its standard deviation, o MARKET Find the Sharpe ratio. (e) An investor requires a target expected return of 14%, that is E (TT) = .14. Find the standard deviation of her portfolio, ot. What proportion will she invest in the monetary market fund, WMONEY? What proportion will she invest in the stock fund, ws? What proportion will she invest in the bond fund, wb? (f) If the investor wanted to invest only in the stock fund and bond fund and achieve a target return of E(TT) = .14, how much would she have to invest in the stock fund, ws and how much in the bond fund, we? What would be the level of risk of this new portfolio