Can you please show me how to solve this in excel (all parts)?

Assume that JCT brokerage company's client is interested in a portfolio of Equity fund and a treasury bond fund.

Expected return for Equity fund

6.80%

with a standard deviation of

13.90%

Expected return for Treasury fund

4.50%

with a standard deviation of

3.60%

The covariance of an investment in the Equity fundwith an investment in a treasury bond fund is

-12.4

a)

Which of the fund would be considered risky? Why?

b)

If JCT recommends that the client invest 70% in the Equity Fund and 30% in the treasury fund, what is the expected percent return and standard deviation, in dollars, for a client investing $20,000 in such a portfolio?

c)

If JCT recommends that the client invest 30% in the Equity Fund and 70% in the treasury fund, what is the expected percent return and standard deviation for such a portfolio?

What would be the expected percent return and standard deviation, in dollars, for a client investing $20,000 in such a portfolio?

d)

Which of the portfolios in parts (b) and (c) woud you recommend for an aggressive investor? Why

Which would you recommend for a conservative investor? Why?