Get Help With Your Essay
"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."
Part 2: Portfolio construction 1. Use CAL and efficient frontier to determine what are the optimal weights on 10 stocks. To do this, please refer to tutorial.xls file. 2. Calculate risky portfolio (consisting of 10 risky assets) return and risk 3. Calculate the optimal weight on T-bill and Risky portfolio. (hint: use y*=(E(rp)-rf)/(A*s^2); assuming a risk averse level of 4) 4. Calculate complete portfolio return, risk, Sharpe ratio. 5. Plot the Efficient frontier and Capital allocation line in the risk-return space. 6. Use VaR to measure your portfolio risks (maximum possible loss);