Monthly adjusted prices, Monthly Adjusted Prices

Monthly adjusted prices

Reference no: EM13673559

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: EM13673559

Questions Cloud

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

Evaluate the force constant of the spring : A 0.46 kilogram mass attached to a spring undergoes simple harmonic motion with a period of 0.77 second. Evaluate the force constant of the spring

Evaluate his initial velocity when he left the end of ramp : After leaving the end of a ski ramp, a ski jumper lands downhill at a point that is displaced 55 kilometer horizontally from the end of the ramp. evaluate his initial velocity (magnitude and direction) when he left the end of the ramp

What is the sharpe ratio of the complete portfolio : What is the Sharpe ratio of the complete portfolio?

Monthly adjusted prices : Monthly Adjusted Prices

Evaluate what is the tension in the rope : A sledge loaded with bricks has a total mass of 17.5 kilogram and is pulled at constant speed by a rope inclined at 19.6 degree above the horizontal. Evaluate what is the tension in the rope

The average company capital structure explain : 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.

Obtain the torque about the elbow : Athletes sometimes do an exercise called "curling weights." Obtain the torque about the elbow caused by a 40-pound weight that makes an angle of 55o with respect to the body

User Account

All Pages