Ten Mutual Funds have been selected for study in Projects One and Two. These must be studied individually. The following is the list of funds and the assignment to individuals.

Fund Assignment

Ten Mutual Funds have been selected for study in Projects One and Two.  These must be studied individually.  The following is the list of funds and the assignment to individuals.

You need to gather the following information on your assigned fund:

You need to gather the following information on your assigned fund:

  1. The quarterly holdings of the fund from 06-30-2018 to 06-30-2016. This should include the Company Name, the Company Sector (if reported; if not use Yahoo Finance to identify the sector), the number of shares held, and the value of the shares as reported by the Fund.
    1. There are four reports of holdings published each year (two N-Q’s and two N-CSRS’s). Be sure to record these by the date listed in the report rathe than the date published by the SEC).
    2. I have already provided you with an Excel workbook with the most recent quarter for your fund.
  2. Once you have gathered these holdings, merge them into a unified list of holding across quarters (i.e., any company held in at least one quarter). This is your master list of companies.
  3. Use Yahoo to look up the stock symbol:
    1. If a symbol does not exist (make sure it does not exist), drop the company (since it has likely been acquired). You should drop it from your master list and each quarter in the fund’s list of holdings
    2. If a company is based abroad, you will get the best prices history from the local market (e.g., .BO or .NS in India, etc.).
    3. If a company does not have price data back to 06-30-2015, drop the company from the master list and each quarter in the fund’s list of holdings.
    4. For the remaining company and your fund, download the adjusted closing prices from 07-01-2015 to 06-30-2018.
  4. Based on the remaining holdings (after the elimination of companies in 3), compute the weights of each company in each quarter and the weight of each sector in each quarter.
  5. Once you have determined an appropriate ETF to benchmark your fund against (see below), download the adjusted closing prices for this ETF from 07-01-2015 to 06-30-2018.

In total, you should have a Master Excel File with the following:

  1. A master list of companies held by the company over appropriate period.
  2. A list of holdings and their portfolio weights for each quarter over the appropriate period
  3. The fund’s weighting of each sector for each quarter over the appropriate period
  4. The daily (adjusted) price series for the fund, the benchmark ETF and each company in the master list of companies from 07-01-2015 to 06-30-2018.

You are expected to research your fund and identify the funds objectives (including style of investing).

Get qualified custom writing help fast and easily. order now

The post Ten Mutual Funds have been selected for study in Projects One and Two. These must be studied individually. The following is the list of funds and the assignment to individuals. appeared first on EliteScoreWriters.



from EliteScoreWriters https://ift.tt/2xEJ6xV
Image result for order now

Comments

Popular posts from this blog

Price of oil in international markets has dropped stunningly 60% in the past twelve months. Among the factors mentioned behind this drastic fall is the millions of barrels of oil

Describe the pathophysiology, signs and symptoms, and predisposition(s) of an Abdominal Aortic Aneurysm (50 points)