Group Project -- Second Report
PART I
|
You will do just one analysis, for
your stock. There is no separate analysis for the competitor firm. | |||||||
|
Whenever your stock exhibits a
significant price change, you want to identify if the source of the price
change was economy-wide news or industry-wide news or firm-specific news. | |||||||
|
That's where the competitor firm
and the market index will be relevant -- to judge what type of news affected
your stock:
| |||||||
|
For economy-wide news, the best source may be the weekly
market summaries to be found on the CBS.marketwatch.com web site.
This will require signing up for a free account.
If you can figure out how to access weekly market summaries directly
from their home page, good for you (and please let me know!).
Otherwise, once you have an account, the following link will be a
good starting point: The
week's top news and commentary, 3/31 - 4/4.
When you scroll down to the bottom, you’ll find links to other
weekly summaries (more recent and older).
You can keep hopping back using these links to get to whichever weeks
you need. (I think it goes back only 6 months. If so, just go back as
far as you can, and don't worry about identifying economy-wide news for the
previous period.) | |||||||
|
For firm-specific and industry-wide news, just pull up the
stock in yahoo. Click on news,
and keep scrolling back. |
PART II
|
Use annual earnings estimates, not quarterly. | |
|
Use the mean estimate for the current year. | |
|
When computing PV of existing assets, we have to locate the
earnings on a time line. In other words, we have to decide on what
date the earnings for the current year are deemed to be received. Instead of
assuming they are received at the end of the fiscal year, it is more
reasonable to assume they are received in the middle of the fiscal year
(since the earnings are generated continuously over the year). | |
|
So
you want to compute the PV of the existing assets "today"
(whatever date you look up the stock price) assuming that annual earnings
are received in the middle of the fiscal year. | |
|
If
your company has a negative earnings estimate, come and talk to me. | |
|
If you come up with a negative PVGO, come and talk to me. |
PART III
|
Assume that T’ is 20%. | |||||
|
To estimate WACC we need the market value of Debt, Equity and
any other source of capital your firm uses (e.g. preferred stock).
We also need the cost of capital for each source. | |||||
|
Equity is straightforward:
| |||||
|
Long-term debt, short-term debt and preferred stock are
discussed below. If your
company has convertible debt, talk to me. |
Long-term debt – estimating market value
|
We need to estimate the total market value of all the
long-term debt. | |||||||||
|
It is generally not a good idea to assume that market value
equals book value. It’s an
even worse idea to do it at this point in time, given that interest rates
have dropped steadily the last few years.
This will have increased the market value of most bonds.
| |||||||||
|
However, estimating the total market value of all the long-term debt would require valuing each bond separately. And large firms sometimes have a very large number of bond issues, so this can add up to a lot of work. So here’s what we’ll do:
| |||||||||
|
The first thing you will need is
information about how many different bonds the company has issued, the book
value (or the number of bonds issued) for each bond issue, and the bond
rating for each issue. There is
no good online source for this information. You will need to go to the
Commerce Library and looking up your company in the Mergent's manuals.
There are different manuals for different sectors of the economy, e.g.
Mergent's Industrial, Mertgent’s OTC, Mergent's Transportation,
Mergent’s Utilities, etc. Ask for help at the reference desk if you
have trouble finding your company in one of the Mergent's manuals.
When you look up your company, you will find a detailed profile of the
company, including details of each individual bond issue. Photocopy
the relevant pages from Mergent’s, and turn them in with your report. | |||||||||
|
The first step in trying to value a bond is to see if you can
find a price quotation for the bond. If
so, you have the value right away. I
suggest the folowing online sources for price quotations: bondsonline.com (Bondsonline)
and the NASD bond information page (NASD
Bond Information). If you don’t find a price quotation in either
place, chances are you will not find a price anywhere else online, but feel
free to try. If you find a
price quotation, print out that page and turn it in with your report.
| |||||||||
|
If there is no price quotation for a bond, then you will need
to compute its market price. For
this you need a discount rate. Find
3 matching bonds with the same maturity and rating. Use their average YTM as your discount rate.
Remember to take partial periods into account in computing the PV
(just like the Fin 300 bond project). | |||||||||
Bondsonline is probably best for searching for
matching bonds. Note the
following:
| |||||||||
|
Make sure you show all your work for the market value
of debt computation. |
Long-term debt – estimating cost of debt
|
Rd is not the coupon rate or YTM, it is the
required return. To come up
with the cost of debt, we need to estimate the beta of debt, which is
problematic. Here’s what
we’ll do. | |||||||
For investment grade debt (i.e. rating of BBB and
above) default risk is pretty small. Expected
return is only slightly less than the promised YTM.
So we’ll just use YTM as an estimate of Rd.
| |||||||
|
For speculative grade debt (anything below BBB), YTM is not a good approximation for E(R). And there is no good way to estimate Rd. Most bonds are not traded frequently enough to provide reliable data for estimating the bond’s beta. For that reason, we cannot look up bond betas the way we can look up equity betas. Recommended procedure for project: make up a reasonable debt beta. This would be the overall beta for all the firm’s long-term debt together. We can develop rules of thumb to define ‘reasonable”: |
|
For
large blue-chip firms, debt betas range between .1 and .3; treat that as
the normal range, and .2 as the average debt beta (see p. 229) | |
|
On
average, stocks have a beta of 1; i.e. the average equity beta is 1. | |
|
Assume
an average debt-to-value ratio of 0.5 (see p. 381). | |
|
This
implies an average asset beta of 0.5*0.2*(1-.2) + 0.5*1 = 0.58 | |
|
Benchmark
value: a firm with an asset beta of 0.58 and a debt-to-value ratio of 0.5
will have a debt beta of 0.2 | |
|
If
asset beta is higher, that will increase debt beta; if the debt-to-value
ratio is higher, that will increase debt beta. |
|
Unless
the probability of default is extremely high, however, (i.e. debt rating
is very low) the debt beta should not be much higher than .3 (since .1 to
.3 is the normal range) |
Using these rules of thumb, cook up a reasonable debt beta for your company. In your report, justify the number you came up with.
Short-term debt – include or not?
|
When financing a project, the firm has to raise capital to
finance fixed assets plus net working capital (NWC). This defines the project’s capital needs. | |
|
When
NWC is positive:
Say CA = 100, CL = 80 and NWC = 20. The
firm finances the CA partly through CL (including short-term debt).
However, the $20 difference represented by NWC is financed by some
mix of long-term debt and equity. Short-term
debt is not used to meet the project’s capital needs.
So, short-term debt does not need to be considered as a separate
source of capital in computing WACC. | |
|
When
NWC is negative:
Say CA = 100, CL = 120 and NWC = -20.
The firm is using short-term debt (or other CL) to finance long-term
assets. There are three sources
of financing for long-term assets: long-term debt, short-term debt and
equity. Now short-term debt
needs to be considered in computing WACC. | |
|
Bottom line: short-term debt should be considered only if net working capital is expected to be negative on a long-term basis (i.e. if short-term debt will be a permanent source of financing for long-term assets) |
Short-term debt – Market value and cost of debt
|
Assume that market value is same as book value.
That’s a reasonable assumption for short-term debt. | |||||||
|
Cost of debt is again problematic. Try to cook up a reasonable number. Bear in mind the following:
|
Preferred Stock
The cookbook comes out again. Just like bonds, preferred stock is not traded frequently enough to yield reliable estimates of beta. So if your company has preferred stock, cook up a reasonable number for the cost of preferred debt, keeping in mind:
|
The
cost of preferred stock will lie in between the cost of long-term debt and
the cost of equity. | |||||||
|
Usually, it will be a lot closer to the cost of long-term
debt than to the cost of equity. | |||||||
|
The less preferred stock there is, the closer its cost will
be to the cost of long-term debt. | |||||||
|
Also, strangely enough, the less long-term debt there is, the
closer the cost of preferred stock will be to the cost of long-term debt.
| |||||||
|
Once again, in your report, justify the number you came up with. | |||||||
|
You can compute the market value of
the preferred stock by discounting the preferred dividends at this cost of
capital. If you think some
other assumption is more reasonable, go ahead and use that instead.
Make sure you explain clearly what you’re assuming, and why. |