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:
- 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.
- 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).
- I have already provided you with an Excel workbook with the most recent quarter for your fund.
- 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.
- Use Yahoo to look up the stock symbol:
- 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
- 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.).
- 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.
- For the remaining company and your fund, download the adjusted closing prices from 07-01-2015 to 06-30-2018.
- 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.
- 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:
- A master list of companies held by the company over appropriate period.
- A list of holdings and their portfolio weights for each quarter over the appropriate period
- The fund’s weighting of each sector for each quarter over the appropriate period
- 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.
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
-
-
-
- Assignment status: Solved by our Writing Team
-
-
Comments
Post a Comment