Alpha, Beta and Fitted Line for Colgate-Palmolive (CL)

History of S&P 500 from Jan 5, 1950 - Mar 30, ...

Latest Work (2014 and 2016) in $11 only (Instant Download)

Case Study on page 447-448 within the Ross textbook

1.   Go to and download the ending monthly stock prices for Colgate-Palmolive for the last 60 months. Use the adjusted closing price, which adjusts for dividend payments and stock splits. Next, download the ending value of the S&P 500 index over the same period. For the historical risk-free rate, go to the St. Louis Federal Reserve Web site  ( and find the three-month Treasury bill secondary market rate. Download this file. What are the monthly returns, average monthly returns, and standard deviations for

Colgate-Palmolive stock, the three-month Treasury bill. and the S&P 500 tbr this period?

2.   Beta is often estimated by linear regression. A model often used is called the market model, which is: