Consider that on January 2, 2014 (Wednesday) you decide to invest in a portfolio consisting of these 10 stocks. You want to find the optimal portfolio to invest in, so you analyze the performance of these 10 stocks over time (using past historical data from January 3, 2011 to December 31, 2013). Please construct the optimal portfolio if short selling is allowed. Use the 3-month T-bill rate as a proxy for the risk-free rate. Assume that riskless borrowing/lending is possible (Hint: Use the borrowing/lending rate on January 2, 2014 use the specific value provided in the Excel file for this assignment). Please solve this part using Excel Solver (GRG Nonlinear Method).

What is the proportion of your funds invested in Tesla? Please round your answer to 3 decimals. Please do not report the %. For example, if your answer is 0.3021 (corresponding to 30.21%), you will report 0.302.

Continuation of Question 1. Please construct the optimal portfolio if short selling is not allowed. Solve this part using Excel Solver (GRG Nonlinear Method).

What is the proportion of your funds invested in Accenture PLC Ireland? Please round your answer to 3 decimals. Please do not report the %. For example, if your answer is 0.3021 (corresponding to 30.21%), you will report 0.302.