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 weekly closing stock (or S&P 500 index) prices and the risk-free rate over the 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? 

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

If this is not the paper you were searching for, you can order your 100% plagiarism free, professional written paper now!

Order Now Just Browsing

All of our assignments are originally produced, unique, and free of plagiarism.

Free Revisions Plagiarism Free 24x7 Support