$\backslash$table$[[$HW:$3],[$Securities $($Tider Symbol$),$Expected Return,Standard Deviation,Weight,Correlations$],[$AAPL$,9\mathrm{.}77\%,37\mathrm{.}40\%,20\mathrm{.}00\%,,$AAP$1,$TSLA,SPY$,$T$1$T$,326],[$TSLA$,12\mathrm{.}58\%,58\mathrm{.}24\%,20\mathrm{.}00\%,$AAPL,$1\mathrm{.}00,0\mathrm{.}92,0\mathrm{.}78,-0\mathrm{.}74,-0\mathrm{.}42],[$SPY$,8\mathrm{.}14\%,27\mathrm{.}44\%,20\mathrm{.}00\%,$TSIA,,$1\mathrm{.}00,0\mathrm{.}69,-0\mathrm{.}19,0\mathrm{.}32],[$TLT$,-11\mathrm{.}24\%,33\mathrm{.}28\%,20\mathrm{.}00\%,$SPY$,,,1\mathrm{.}00,-0\mathrm{.}55,0\mathrm{.}55],[$BRG$,2\mathrm{.}53\%,16\mathrm{.}23\%,20\mathrm{.}00\%,$TLT$,,,,1\mathrm{.}00,0\mathrm{.}63],[,,,,$BRG$,,,,,1\mathrm{.}00],[,,$Portfolio Expected Return,$4\mathrm{.}36\%,,,,,,],[$Portfolio Standard Deviation:,Total of Weights,$100\mathrm{.}00\%,,,,,,],[0\mathrm{.}02765833,,,,,,,,,],[0\mathrm{.}017146592,,,,,,,,,],[21\mathrm{.}17\%,,,,,,,,,]]$

HW #$3-$ Submit your answers in Brightspace by the deadline

Given the data on the HW$3-$Data Excel file, use the Solver Excel Add$-$in to find points on the efficient frontier. The lecture video contains steps on how to install the Solver add$-$in if you don't have it$.$ Work

through these problems in the Excel file and submit your completed XLSX file. Label your answers clearly.

Solve for a constrained optimization problem where we maximize the portfolio's expected return for the following levels of risk $($portfolio standard deviation$)$: $20\%,25\%,30\%,$ and $35\%.$ Make a table showing your portfolio's expected returns at each level of standard deviation.

Draw a graph depicting your results for the efficient frontier $($risk on the $x$ axis and return on the $Y$ axis$).$

Explain what each of the securities are and which asset class they belong to$.$

Extra Credit:

When should the price of TLT go up$?$