Call us 24/7: + 1(925)399 0085

Get your paper done by an expert

No matter what kind of academic paper you need, it is simple and secure to hire an essay writer for a price you can afford at StudyAcer. Save more time for yourself.

WhatsApp + 1(925)399 0085
$ 10
  • bibliography
  • title page
  • revisions
per page
19 k happy customers
4.7 out of 5 satisfaction rate
27 writers active

fin 371 investment analysis 1

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.

Our guarantees

Study Acers provides students with tutoring and help them save time, and excel in their courses. Students LOVE us!No matter what kind of essay paper you need, it is simple and secure to hire an essay writer for a price you can afford at StudyAcers. Save more time for yourself. Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Our Homework Writing Disciplines

With a highly diverse team in almost all academic fields including:

Warning: Invalid argument supplied for foreach() in /home/acemfljg/public_html/wp-content/themes/essay-writing/footer.php on line 12