You would like to form a portfolio. You have the following information: Facebook stock has an average return of 12% and

[answerhappygod]

You would like to form a portfolio. You have the following
information:
Facebook stock has an average return of 12% and a variance of
6.25%.
IBM stock has an average return of 16% and a variance of 9%.
The correlation between Facebook and IBM is equal to 15%.
The risk free rate is equal to 3%.
Question: You form the capital allocation line (CAL) with the
minimum-variance portfolio. One of this CAL portfolios has a
variance of 3.057%. Find the weight of IBM of that CAL
portfolio.
Please use excel (solver to find the answer)
the X and Y can be taken as, if X is 0% then Y will be 100%, if
X is 10% then y will be 90% and on till X is 100% and y is
0%.