Suppose an investor estimates the following input data for IBM corporate bond and IBM common stock:

E(rB)=5% B=8% E(rS)=10% S=19% BS=0.2

Assuming that portion of your wealth invested on stock range from -1.5 to 1.5 with incremental of 0.1

Calculate the all possible combinations of return and risk of the risky portfolio consist of IBM corporate bond and IBM common stock, given the range of weights invested on stock, and draw investment opportunity set.

Calculate the weights on each assets, return and risk for minimum variance portfolio consist of IBM corporate bond and IBM common stock.

Demonstrate, using excel spreadsheet, how correlation coefficient, BS, related with riskiness of the risky portfolio that consist of IBM corporate bond and IBM common stock.