Hi please answer the finance questions by hand solving not excel please.

Thank you

Please answer by hand, that helps me to understand the answer better. If a question requires excel, then go for it.

Thank you so much

Problem 1 ( 33 pts) A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T-bill money market fund that yields a rate of 3.5%. The expected return of stock fund and bond fund are 32% and 12%, respectively. The standard deviations of stock fund and bond fund are 35% and 20% respectively. The correlation between the fund returns is 0.42. Assume you have a quadratic utility in the form of [U=E(rp)21AP2] and a risk aversion coefficient equal to 3 . a) What are the investment proportions of the minimum-variance portfolio of the two risky funds, and what is the expected value and standard deviation of its rate of return? (4pts) b) In this question, assume you are to invest in the stock fund and bond fund only (the two risky funds only). Solve numerically for the proportions of each asset and for the expected return and standard deviation of the optimal risky portfolio that will maximize your utility. What will be your utility? (5pts) c) Solve numerically for the proportions of each asset and for the expected return and standard deviation of the optimal risky portfolio "P" for the best feasible CAL (the line extending from the risk-free rate and that is tangent to the opportunity set). What is the slope of the best feasible CAL? Draw the CAL. Indicate on the graph the optimal risky portfolio 'P'. (8pts) d) You want to invest $10,000 in a portfolio C that is formed from the T-Bill money market fund, the bond fund, and the stock fund. You require that your portfolio "C" yield an expected return of 40 percent and that it be efficient, on the best feasible CAL. What is the standard deviation of your portfolio? How much money will you invest in the T-bill fund and each of the two risky funds? (5.5pts) e) You want to invest $10,000 in a portfolio C that is formed from the T-Bill money market fund, the bond fund and the stock fund. You require that your portfolio " C " standard deviation not to exceed 20 percent and that it be efficient, on the best feasible CAL. What is the maximum return that you can achieve on your portfolio? How much money will you invest in the T-bill fund and each of the two risky funds? (5.5pts) f) You want to invest $10,000 in a portfolio C that is formed from the T-Bill moncy market fund, the bond fund and the stock fund. If you require that your portfolio maximizes your utility and that it be efficient, on the best feasible CAL. What is the rate of return of your portfolio? What is the standard deviation of your portfolio? How much money will you invest in the T-bill fund and each of the two risky funds? What will be your utility? (8pts) Problem 1 ( 33 pts) A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T-bill money market fund that yields a rate of 3.5%. The expected return of stock fund and bond fund are 32% and 12%, respectively. The standard deviations of stock fund and bond fund are 35% and 20% respectively. The correlation between the fund returns is 0.42. Assume you have a quadratic utility in the form of [U=E(rp)21AP2] and a risk aversion coefficient equal to 3 . a) What are the investment proportions of the minimum-variance portfolio of the two risky funds, and what is the expected value and standard deviation of its rate of return? (4pts) b) In this question, assume you are to invest in the stock fund and bond fund only (the two risky funds only). Solve numerically for the proportions of each asset and for the expected return and standard deviation of the optimal risky portfolio that will maximize your utility. What will be your utility? (5pts) c) Solve numerically for the proportions of each asset and for the expected return and standard deviation of the optimal risky portfolio "P" for the best feasible CAL (the line extending from the risk-free rate and that is tangent to the opportunity set). What is the slope of the best feasible CAL? Draw the CAL. Indicate on the graph the optimal risky portfolio 'P'. (8pts) d) You want to invest $10,000 in a portfolio C that is formed from the T-Bill money market fund, the bond fund, and the stock fund. You require that your portfolio "C" yield an expected return of 40 percent and that it be efficient, on the best feasible CAL. What is the standard deviation of your portfolio? How much money will you invest in the T-bill fund and each of the two risky funds? (5.5pts) e) You want to invest $10,000 in a portfolio C that is formed from the T-Bill money market fund, the bond fund and the stock fund. You require that your portfolio " C " standard deviation not to exceed 20 percent and that it be efficient, on the best feasible CAL. What is the maximum return that you can achieve on your portfolio? How much money will you invest in the T-bill fund and each of the two risky funds? (5.5pts) f) You want to invest $10,000 in a portfolio C that is formed from the T-Bill moncy market fund, the bond fund and the stock fund. If you require that your portfolio maximizes your utility and that it be efficient, on the best feasible CAL. What is the rate of return of your portfolio? What is the standard deviation of your portfolio? How much money will you invest in the T-bill fund and each of the two risky funds? What will be your utility? (8pts)