PLEASE WORK $ON$ EXCEL $DO$ NOT TYPE HOW $TODOIT$ USE THE SPREAD SHEEET Start with the partial model in the file Ch$03$ P$07$ Build a Model.xlsx$.$ Following is information for the required returns and standard deviations of returns for A$,$ B$,$ and C:

Stock ri $\backslash$sigma i

A $6\mathrm{.}0\%31\mathrm{.}10\%$

B $10\mathrm{.}055\mathrm{.}40$

C $17\mathrm{.}089\mathrm{.}51$

The correlation coefficients for each pair are shown in the following matrix, with each cell in the matrix giving the correlation between the stock in that row and column. For example, $\backslash$rho AB $=0\mathrm{.}1566$ is in the row for A and the column for B$.$ Notice that the diagonal values are equal to $1$ because a variable is always perfectly correlated with itself.

A B C

A $1\mathrm{.}00000\mathrm{.}15660\mathrm{.}1854$

B $0\mathrm{.}15661\mathrm{.}00000\mathrm{.}1673$

C $0\mathrm{.}18540\mathrm{.}16731\mathrm{.}0000$

The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Round your answers to two decimal places.

Download spreadsheet Ch$03$ P$07$ Build a Model$-502382.$xlsx

Suppose a portfolio has $40\%$ invested in A$,30\%$ in B$,$ and $30\%$ in C$.$ What are the expected return and standard deviation of the portfolio?

Expected return: fill in the blank $2$

$10\mathrm{.}50$

$\%$

Standard deviation: fill in the blank $3$

$\%$

The partial model lists sixty six different combinations of portfolio weights $($only six of them are shown below$).$ For each combination of weights, find the required return and standard deviation.

wA wB wC $\backslash$sigma p

$0\%80\%20\%$ fill in the blank $4$

$\%$ fill in the blank $5$

$\%$

$10\%70\%20\%$ fill in the blank $6$

$\%$ fill in the blank $7$

$\%$

$30\%10\%60\%$ fill in the blank $8$

$\%$ fill in the blank $9$

$\%$

$50\%20\%30\%$ fill in the blank $10$

$\%$ fill in the blank $11$

$\%$

$60\%10\%30\%$ fill in the blank $12$

$\%$ fill in the blank $13$

$\%$

$70\%20\%10\%$ fill in the blank $14$

$\%$ fill in the blank $15$

$\%$

Construct a scatter diagram showing the required returns and standard deviations already calculated. This provides a visual indicator of the feasible set. Choose the correct graph.

The correct graph is

graph D

$.$

A$.$

B$.$

C$.$

D$.$

If you seek a return of $10\mathrm{.}3\%,$ then what is the smallest standard deviation that you must accept?

fill in the blank $17$

$\%$