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 finance.yahoo.com 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  (www.stlouisfed.org) 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:

Ratio Analysis and Comparison for Exxon Mobil Corporation and Royal Dutch Shell plc

Ratio Analysis and Comparison for Exxon Mobil Corporation and Royal Dutch Shell plc in $15 Only
1) Need to choose two firms within the same industryRatio Analysis and Comparison

 

2) Go to each firm’s Web site, and then access and download their annual reports (financial statements).

3) Using the accounting data from the firms’ financial statements, calculate all ratios for each firm (liquidity ratios, activity ratios, profitability ratios, leverage ratios, and coverage ratio)

Liquidity Ratios

Current Ratio = Current Assets/Current Liabilities

Quick Ratio = Current Assets – Inventory/Current Liabilities