LUBIN SCHOOL OF BUSINESS
Pace University
Fin 647 Advanced Topics in Financial Management
Prof. P.V. Viswanath
Fall 2007
Midterm
Notes:
- If your answers are not legible or are otherwise difficult to follow, I
reserve the right not to give you any points.
- If you cheat in any way, I reserve the right to give you no points for the
exam, and to give you a failing grade for the course.
- You may bring in sheets with formulas, but no worked-out examples, or definitions,
or anything else.
- You must explain all your answers.
1. Read the following WSJ article and answer any two of the questions
below (10 points each):
- Honeywell and 3M were down 4.6% and 6.5%, much more than Caterpillar, which
dropped 3.5%. If this was the only information you had to go by, what would
you say about their market betas?
- Is there any other information in the article that would cause you to be
cautious about the inference in part (a)? Explain.
- Based on what you know of the businesses that McDonald's, 3M and Caterpillar
are in, what can you say about their betas?
3M Company (3M) is a diversified technology company with a global presence
in various businesses, including industrial and transportation, healthcare,
display and graphics, consumer and office, safety, security and protection
services, and electro and communications.
Caterpillar Inc. operates in three principal lines of business: Machinery,
Engines and Financial Products. Machinery deals with the design, manufacture,
marketing and sales of construction, mining and forestry machinery.
McDonald's Corporation primarily franchises and operates McDonald's restaurants
in the food service industry. These restaurants serve a varied, yet limited,
value-priced menu in more than 100 countries around the world.
The
Dow’s Three Stooges
Posted by David Gaffen, October 19, 2007, 10:55 am
It’s an earnings-driven breakdown on the Dow Jones Industrial Average
today, as three of the four components that reported prior to today’s
opening were responsible for a good chunk of the losses on the 30-stock average
in the morning.
3M, Honeywell and Caterpillar are leading the charge lower.
Stocks are continuing to sink, reacting to the brief bump-up in oil over $90
a barrel and another bout of weakness in the U.S. dollar as investors continue
to express concern over the possibility of sluggish economic growth, but with
dollar-induced inflation from overseas. Industrials are leading the major indexes
lower, as the Morgan Stanley Cyclicals Index is off 1.9%.
“Because the risks are not fully known as yet, a lot of attention is
being paid to forward guidance that is murky, and I think if a company gives
murky guidance the market is not giving it benefit of the doubt,” says
Alan Gayle, director of asset allocation at Trusco Capital Management.
Among those issuing clouded guidance was industrial equipment giant Caterpillar,
which was down 3.5% % after the company missed expectations and lowered forthcoming
guidance. Fellow components Honeywell and 3M are worse, falling 4.6% and 6.5%,
respectively, as the latter said it would be slowing its pace of stock buybacks.
Combined, the three stocks account for 96 points of negative drag on the Dow,
with 3M’s massive drop making up 50 points of that fall-off. The lone
earnings reporter to buck the trend was McDonald’s, which was off fractionally,
contributing little to the Dow’s move.
2. I collected (using a program written by Michael Kishinevsky) price data
on McDonald's (MCD) and the NYSE Composite Index for the period Oct. 2002 to
Sept. 2007, and then computed returns on the MCD and the NYSE Index. I then
regressed MCD returns on NYSE returns and obtained the following output.
Regression Statistics |
|
|
|
|
|
Multiple R |
0.623226 |
|
|
|
|
|
R Square |
0.38841 |
|
|
|
|
|
Adjusted R Square |
0.37768 |
|
|
|
|
|
Standard Error |
0.048185 |
|
|
|
|
|
Observations |
59 |
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
|
df |
SS |
MS |
F |
Significance F |
|
Regression |
1 |
0.08405 |
0.08405 |
36.19971 |
1.35E-07 |
|
Residual |
57 |
0.132344 |
0.002322 |
|
|
|
Total |
58 |
0.216394 |
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Intercept |
0.005054 |
0.006802 |
0.742981 |
0.460544 |
-0.00857 |
0.018676 |
NYSE |
1.407973 |
0.234014 |
6.01662 |
1.35E-07 |
0.939368 |
1.876578 |
Answer the following questions using the information above:
- (5 points) What is McDonald's beta according to this regression?
- (10 points) How closely does McDonald's move with the market? Are you surprised?
What piece of information from the regression are you using to answer this
question?
- (10 points) Can you reject the hypothesis that McDonald's beta is one? Explain.
- (10 points)
Subsequently, I ran another regression, this time using data for the second
half of the period. The results are given below:
Regression Statistics |
|
|
|
|
|
Multiple R |
0.634874 |
|
|
|
|
|
R Square |
0.403065 |
|
|
|
|
|
Adjusted R Square |
0.380956 |
|
|
|
|
|
Standard Error |
0.03953 |
|
|
|
|
|
Observations |
29 |
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
|
df |
SS |
MS |
F |
Significance F |
|
Regression |
1 |
0.028488 |
0.028488 |
18.23106 |
0.000216 |
|
Residual |
27 |
0.04219 |
0.001563 |
|
|
|
Total |
28 |
0.070678 |
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Intercept |
0.005243 |
0.008339 |
0.628723 |
0.534814 |
-0.01187 |
0.022353 |
0.01798 |
1.448386 |
0.339218 |
4.269784 |
0.000216 |
0.752369 |
2.144403 |
What is your estimate of McDonald's beta from the new results for the second-half
of the subperiod? How different is it from your answer in (a)? Can you explain
the size of the discrepancy (if it's large, explain why, and if it's not large,
give the reason why it's not large).
3. 3M Company operates as a diversified technology company. It operates in
six segments: Industrial and Transportation; Health Care; Display and Graphics;
Consumer and Office; Safety, Security, and Protection Services; and Electro
and Communications. It's market capitalization is $62b. and its beta is 0.8,
according to Yahoo. The table below gives the proportion of sales contributed
by each segment, according to the 2006 10-Ks filed by the company in February
2007.
Business Segments |
Percentage
Sales (2006) |
Industrial
and Transportation |
29.8 |
Health
Care |
17.5 |
Display
and Graphics |
16.4 |
Consumer
and Office |
14.1 |
Safety,
Security and Protection Services |
11.4 |
Electro
and Communications |
10.8 |
You have the additional information re other firms in the Security and Protection
Services industry (Source: Yahoo):
Company |
Market Capitalization (Market Value of
Shares Outstanding) |
Debt/Equity Ratio |
Equity Beta |
Checkpoint Systems Inc. (CKP) |
$1.1 |
0.032 |
1.06 |
L-1 Identity Solutions Inc. (ID) |
$1.3 |
0.175 |
4.52 |
Geo Group Inc. (GEO) |
$1.5 |
0.955 |
1.75 |
Brinks Co. (BCO) |
$2.9b |
0.164 |
0.99 |
- (10 points) Compute the market value of assets for each of the firms in
the table above.
- (10 points) Use the numbers computed in (a) to estimate the asset beta for
the Security and Protection Services sector (assuming these four firms are
representative of the industry)
- (10 points) Use this information to estimate the beta of the rest of 3M
(other than the Security and Protection Services segment).
- (10 points) Suppose you now believe that due to structural changes in the
economy, the asset beta of the Security and Protection Services sector needs
to be raised by 20%. Estimate the new beta of 3M.
4. (10 points) Answer any three of the following questions in no more than
half a page each.
- Is it good to make insider trading illegal? Can you think of reasons why
insider trading should be made legal?
- The uncertainty regarding a firm's returns that is unrelated to the market
is called idiosyncratic risk. The uncertainty regarding a firm's returns that
is related to the market is called systematic risk. The sum of idiosyncratic
and systematic risks is called the total risk and is equal to the variance
of the firm's return. Consider the proportion of a firm's returns that is
accounted for by systematic risk. Would this proportion be higher for smaller
firms or larger firms? Why?
- Why does the Board of Directors not always function well to control the
CEO's activities?
- Would a geometric average of historical returns a better forecast of future
returns if investors have a long-term horizon or would an arithmetic average
be better?
- Why is the beta the more appropriate measure of risk of an asset, rather
than its return variance?
- When is regression inapproriate to estimate a firm's beta?
Solutions to Midterm
1.
- It looks like this is a market-wide slowdown. Hence, I would say that Caterpillar,
Honeywell and 3M, all had large betas, with their magnitudes in that same
order. If we can interpret the Morgan Stanley Cyclicals Index as a measure
of what's happening to the market overall, we'd have betas of 3.5/1.9 (= 1.84),
4.6/1.9 (=2.42) and 6.5/1.0 (=6.5), overall.
- There are some cautions in interpreting these numbers as betas. Since the
slowdown, apparently, is due to the drop in the dollar and increase in oil
prices, stock price declines would be related to how exposed the firms were
to exchange rate risk and how dependent they were, directly or indirectly,
on oil. Further, if the downturn is earnings driven, perhaps some of the firms
with very steep declines are those that had unexpectedly low drops. For these
firms, the beta, as measured above, might be too high.
- Firms and industries producing capital goods and consumer durables are usually
hard hit by recessions. Two factors explain this:
* Postponability – Within limits, purchases of durable goods can be
postponed. During recessions, producers frequently delay the purchase or more
modern production facilities and the construction of new plants, whereas in
good times, capital goods are often replaced before they completely depreciate.
Similarly, during recessions, households often delay the purchase of big-ticket
items, including automobiles, white goods, and so on.
* Monopoly Power – Many industries producing capital goods and consumer
durables are found in high concentration, i.e. a small number of large firms
dominate the market. These firms can set above-competitive prices to increase
their profit. When recession hits, these firms are reluctant to lower prices
since this would upset the industry price structure, possibly sparking a price
war. This reluctance means that the initial effects of a drop in demand are
primarily a decline in production and an increase in employment.
If we use this perspective, we see that Caterpillar's profits would fluctuate
a lot more with the business cycle than McDonald's. 3M's products cater partly
to businesses and partly to consumers and hence they would be in an intermediate
position. Hence, we'd expect Caterpillar to have the highest beta, followed
by 3M and then McDonald's. According to Yahoo, 3M has a beta of 0.8, while
Caterpillar has a beta of 1.69, and McDonald's has a beta of 1.74. Of course,
this analysis ignores the other characteristics of the goods, themselves,
as well as the debt/equity ratios. McDonald's has a D/E ratio of 0.542, while
Caterpillar and 3M have debt/equity ratios of and 3.189 and 0.477 respectively.
This partly clarifies the picture, but the high beta of McDonald's is still
unexpected, if we think of McDonald's product as a necessity. It is possible
that competition for low-margin staple foods has transformed the fast-food
industry into a primarily high-margin, non-necessity producing industry.
2.
- McDonald's beta is 1.407973, according to the regression.
- The R-squared tells us how closely McDonald's moves with the market. The
R-squared here, is 38.84%; that is, 38.84% of the variance in the return on
McDonald's can be explained by market movements. It is not particularly huge.
- The standard error of the beta is 0.234014; hence the estimated beta is
(1.407973-1)/0.234014 or 1.74 standard deviations larger than a beta of one.
The chances of getting an estimated beta this large, if the true underlying
beta were 1 is less than 10%; hence one could reject the null hypothesis of
a unit beta. Under other assumptions, it would be even easier to reject a
unit beta.
- The beta in the second period is very similar to the beta in the overall
period from Oct. 2002 to Sept. 2007. This suggests that McDonald's did not
change its operations too much between the first period and the second period.
3.