Calculate the monthly returns.

Reference no: EM13674119

The Beta β for the following stocks are presented for the period 2004- 2008 in the Table below.
see the "Monthly Adjusted Prices" spreadsheet-or from finance.yahoo.com. Refer to the useful Spreadsheet Functions box
near the end of Chapter 9 for information on Excel functions

Stock Beta Stock Beta
Amazon 2.16 Disney .96
Ford 1.75 Newmont .63
Dell 1.41 Exxon Mobil .55
Starbucks 1.16 Johnson & Johnson .50
Boeing 1.14 Campbell Soup .30

Download to a spreadsheet the last five years of monthly adjusted stock prices for each of the companies in Table and for the Standard & Poor's Composite Index (S&P 500).
a. Calculate the monthly returns.
b. Calculate beta for each stock using the Excel function SLOPE, where the "y" range refers
to the stock return (the dependent variable) and the "x" range is the market return (the
independent variable).
c. How have the betas changed from those reported in Table? Please comment on the 10 stocks.

Reference no: EM13674119

Questions Cloud

Characteristic line : Explain the relationship between the 'characteristic line' and the 'security market line' and then discuss the practical significance of the 'capital asset pricing model'.

What is the expected return on the mutual fund : What is the expected return on the mutual fund?

Discuss the roles of hedgers and speculators : Discuss the roles of hedgers and speculators in the currency markets.

What is the expected return on the complete portfolio : What is the expected return on the complete portfolio?

Calculate the monthly returns. : a. Calculate the monthly returns.

Congress increased the personal tax rate on interest, : If Congress increased the personal tax rate on interest, dividends, and capital gains, but simultaneously reduced the rate on corporate income, what effect would this have on the average company's capital structure? Explain.

Monthly payments and finance charges : Monthly Payments and Finance Charges.

How much will be in your account after 5 years : Future Value: If you have deposit 10,000 in a bank account that pays 10% interest annually, how much will be in your account after 5 years?

What is the price of a 3-month : Tru-U stock is selling for $36 a share. A 3-month call on Tru-U stock with a strike price of $40 is priced at $1. Risk-free assets are currently returning .025% per month. What is the price of a 3-month put on Tru-U stock with a strike price of..

User Account

All Pages