Assignment: Financial Analysis Application:
Carnivorous Funds Mini-case
Carnivorous Funds (CF) is a mutual fund company located in Charlotte, NC. They have contracted with TF Inc. an investment advisory firm to consider investments in some additional stocks.
The fund is considering investments in the stocks of American Electric Power(AEP), Idaho Power Company (IDA), and Piedmont Natural Gas (PNY).
It is the fall of 2016 and you are a manager at TF. CF has requested that TF perform some financial analysis (focusing on risk and return).
You are directed to calculate the following statistics. TF generally uses the S&P 500 as a market proxy and uses the short-term Treasury bill rate as the risk-free rate.
Your intern will provide weeklyclosing stock (or S&P 500 index) prices and the risk-free rate overthe years 2011 through 2016.
The stock prices are dividend-adjusted (i.e., include the value of any dividends paid).
The data from the intern's spreadsheet also include the value of the S&P 500 index (S&P500) and the risk-free rate (i.e., the short-term Treasury bill rate).
Use the S&P 500 as a market proxy.
You are to calculate the following:
1. Mean return for AEP, IDA, and PNY (arithmetic and geometric means)
2. Standard deviation of returns for AEP, IDA, and PNY
3. Correlation coefficient of returns between AEP-IDA, AEP-PNY, IDA-PNY, AEP-S&P500, IDA-S&P500, and PNY-S&P500
4. Covariance of returns between AEP-IDA, AEP-PNY, IDA-PNY, AEP-S&P500, IDA-S&P500, and PNY-S&P500
5. Beta (using returns) for AEP, IDA, and PNY
6. Coefficient of variation for AEP, IDA, and PNY
7. Treynor ratio for AEP, IDA, and PNY
8. Sharpe ratio for AEP, IDA, and PNY
9. Jensen's alpha for AEP, IDA, and PNY
Additionally, your managing director has requested that you:
Write a one-page memo to your client explaining your stock recommendation based on the calculations above. If you must recommend one stock, which stock would you recommend to your client based on the risk-return analysis?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Financial-Analysis-Application-Data.rar