1. Using finance.yahoo.com, download WEEKLY price data, as we have done in the class, for

SPY, QQQ, JNK, GLD, IWF, IWD, IWN, IWO, EFA, EEM

2. These are all ETFs. Find out what kind of asset class these ETFs represent, and write a brief (at most two lines) description of these asset classes.

3. As we have done in the class, calculate the weekly returns (for the dates that are common to ALL of these ETFS). Make sure to use the Adjusted Close to calculate the return data

4. Calculate the average weekly return (multiply it by 52 to get an “annualized” number)

5. Calculate the standard deviation (risk) for these ETFS

6. Using SOLVER, as we have done in the class, calculate and graph the minimum variance boundary, and note where the efficient frontier lies on this boundary. For this step, do not limit weights to be non-negative.

7. Repeat Step 6, but this time force all portfolio weights to be non-negative (including the last one).

For your convenience, I am attaching the files I used during the lecture

Looking for solution of this Assignment?

WHY CHOOSE US?

We deliver quality original papers

Our experts write quality original papers using academic databases.  

Free revisions

We offer our clients multiple free revisions just to ensure you get what you want.

Discounted prices

All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount

100% originality

We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity

On-time delivery

We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay