Your Perfect Assignment is Just a Click Away
We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!


FIN371 Carlos Albizu University Miami Campus Investment Analysis Paper

FIN371 Carlos Albizu University Miami Campus Investment Analysis Paper

FIN371 Carlos Albizu University Miami Campus Investment Analysis Paper


Pick an asset (stock, ETF, etc.) that has been around for at least 5 years, download the monthly adjusted closing prices and compute monthly returns for the asset and for the market portfolio.

Make sure that you align asset returns with the other variables by date. Conduct the following exercise.

1. Using monthly data, estimate the CAMP equation:


The dependent variable (Y) is the excess return of the stock, and the independent variable (X) is the excess return of the market portfolio.
Print out:

  1. a) data (with variable names clearly marked);
  2. b) regression output;
  3. c) line fit plot.

In your reports, answer the following questions:

  1. 1) Report the coefficient estimates, t-statistics, as well as the adjusted R-square;
  2. 2) Interpret the beta coefficient and comment on the amount of the market risk this security has;
  3. 3) Interpret the alpha coefficient. Evaluate the performance of this asset. Did it outperform/underperform once its market risk exposure is accounted for;
  4. 4) If you are the Chief Investment Officer of Vanguard, would you consider incorporating this security into your portfolio? Discuss how you would execute this strategy?

Some frequently asked questions:

1. What time period should I use? Should I use 20 years, 10 years, or 5 years?

Answer: The decision is yours. Generally speaking, if the returns are from a stable distribution, you want to use as many observations as possible to increase the power of the regression and minimize estimation error. On the other hand, if you think the return distribution has changed and that the more recent data are more appropriate to infer future performance, you want to use only the more recent observations. So the optimal time period is a tradeoff between the two issues mentioned above. If you feel that your stock has been pretty stable over the last 20 years, you want to use all 20 years of data. But if you think last 5 years are more representative, you want to use 5 years.

2. Where do I get data on the returns and on the risk free rate?

You can get SP 500 index (GSPC) closing prices from Yahoo finance. Use the monthly adjusted closing prices to compute returns. Similarly, using a stock’s ticker symbol, you can download its adjusted closing price and compute monthly returns. You can align the data series of the market portfolio and the stock by the dates.

You can use the risk free rate posted on Blackboard “F-F_Research_Data_Factors 2019”.1 Again, you need to make sure that you align the risk free rate, the market and stock returns by the dates. Note that the variable “rf” is the monthly risk free rate in %. You will need to convert it to decimals if your stock and market returns are in decimals.

3. How do I conduct regression analysis?

In Excel, go to “Data”, then “Data Analysis” and select “Regression”. You need to specify that the Y variable is the excess return of the stock and X variable is the excess return of the market portfolio.

If you don’t see “Data Analysis” in your current Excel settings, you can go to “File”, select “Options”, then “Add-ins”, select “Analysis ToolPak”. Then repeat the procedures in the prior paragraph.

We offer the best custom essay writing services at an affordable rate. We have done this assignment before, we can also do it for you.

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Essay Pillars only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Essay Pillars are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Essay Pillars is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Essay Pillars, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.