Corporate Finance

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

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.