Chapter 11 A Job at East Coast Yachts, Part 2 Input area: \begin{tabular}{lcc} & \multicolumn{1}{c}{ 10-year annual } & Standard deviation \\ \cline { 2 - 3 } Bledsoe Large Company Stock Fund & 12.15% & 24.43% \\ Bledsoe Bond Fund & 6.93% & 9.96% \\ Risk-free rate & 3.20% & \\ Correlation & 0.15 \\ \hline \end{tabular} Output area: \begin{tabular}{c|c|c|} \hline Weight of stock fund & Portfolio E(R) & \multicolumn{2}{c|}{ Portfolio standard deviation } \\ \hline 0% & & \\ \hline 10% & & \\ 20% & & \\ \cline { 2 - 3 } 30% & & \\ 40% & & \\ 50% & & \\ 60% & & \\ 70% & & \\ \hline 80% & & \\ 90% & & \\ \hline 100% & & \\ \hline \end{tabular} Dominant portfolio: (Using Solver) Weight of stock fund Weight of bond fund Standard deviation Expected return \begin{tabular}{|l|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} Minumum variance portfolio: (Using Solver) Weight of large cap stock fund Weight of bond fund Expected return Variance Standard deviation \begin{tabular}{|l|l|} \hline & \multicolumn{1}{|c}{} \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} Chapter 11 A Job at East Coast Yachts, Part 2 Input area: \begin{tabular}{lcc} & \multicolumn{1}{c}{ 10-year annual } & Standard deviation \\ \cline { 2 - 3 } Bledsoe Large Company Stock Fund & 12.15% & 24.43% \\ Bledsoe Bond Fund & 6.93% & 9.96% \\ Risk-free rate & 3.20% & \\ Correlation & 0.15 \\ \hline \end{tabular} Output area: \begin{tabular}{c|c|c|} \hline Weight of stock fund & Portfolio E(R) & \multicolumn{2}{c|}{ Portfolio standard deviation } \\ \hline 0% & & \\ \hline 10% & & \\ 20% & & \\ \cline { 2 - 3 } 30% & & \\ 40% & & \\ 50% & & \\ 60% & & \\ 70% & & \\ \hline 80% & & \\ 90% & & \\ \hline 100% & & \\ \hline \end{tabular} Dominant portfolio: (Using Solver) Weight of stock fund Weight of bond fund Standard deviation Expected return \begin{tabular}{|l|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} Minumum variance portfolio: (Using Solver) Weight of large cap stock fund Weight of bond fund Expected return Variance Standard deviation \begin{tabular}{|l|l|} \hline & \multicolumn{1}{|c}{} \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular}