3 HOURS DEADLINE MY CAPITAL MARKETS HOMEWORK. PLEASE UPLOAD XLSX FILE @ lnsgnr @ g mail.com

Build a portfolio of the 2 stocks you picked out of the top 50 stocks (by weight) of S&P 500 Index using monthly returns for the last 5 years. (I PICK TESLA AND APPLE OR YOU CHOOSE)

Compute the expected return and std. deviation of the portfolio for different portfolio compositions. (using both methods- portfolio returns and using formulas)

Interpret the expected return and riskiness of these individual stocks and also the expected return and the riskiness of the portfolio.

Plot the efficient frontier.

Identify the minimum variance portfolio (by minimizing the standard dev. of the portfolio), i.e. the starting point of the efficient frontier.

Plot the returns of each stock against S&P returns (characteristic line) and compute the beta of each stock.

Compute the correlation coeff. Between the returns of these stocks.

Identify the portfolio composition which would yield the maximum Sharpe Ratio (Assume the risk-free rate is 0%).

THIS MUST BE DONE IN EXCEL. THIS IS MY HOMEWORK PLEASE HELP. PLEASE UPLOAD XSLX FILE