Manually enter the weights, expected returns, SD and Sharpe Ratio for the four cases at the left.

Assume you cannot short any assets. This may mean using the results from the row from $w_s=0$ or $1$ in some cases.

Case $2$: $p_{BS}=0$

Case $3$: $p_{BS}=+1$

Case $4$: $p_{BS}=-1$

The fields here allow us to switch scenarios by typing in case numbers in Cell B$37$

Manually enter the weights, expected returns, SD and Sharpe Ratio for the four cases at the left.

Assume you cannot short any assets. This may mean using the results from the row from $w_5=0$ or $1$ in some cases.

Case $1$: $p_{BS}=0\mathrm{.}2$

Case $2$: $p_{BS}=0$

Case $3$: $p_{BS}=+1$

Case $4$: $p_{BS}=-1$