Equity Valuation Project: Group
Equity Valuation Project: Group
Group:
Mike Altman
Alison Birch
Erin Burns
Joe Faber
Santosh Lakhan
Josh Sullivan
Companies:
Affiliated Computer Services
Apple Computer
Biosite
Gundle Environmental Systems
Infosys
Nextel Partners
Affiliated Computer Services
1. Company Overview
Affiliated Computer Services, Inc. (ACS) is a global company delivering comprehensive business
process outsourcing and information technology (IT) outsourcing solutions to commercial and
government clients. The Company is organized into commercial, state and local government and
the federal government segments. Within the commercial segment, ACS provides technology
outsourcing, business process outsourcing and systems integration services to clients in such
industries as insurance, utilities, manufacturing, financial institutions, telecommunications,
healthcare, retail and transportation. In the state and local government segment, the Company is
a business process outsourcing provider to state and local governments. In the federal
government segment, ACS provides systems integration services, business process outsourcing
and technology outsourcing to federal agencies.
Services company.
2. DCF Valuation
We implemented the two-stage FCFF discount model since it is best suited for firms with shifting
leverage and growing at a moderate rate.
Sensitivity Analysis
The key drivers for ACS are the length of the growth period and stable growth rate
Growth Period
Stable Growth Rate 5 10
3 $ 48.75 $ 54.07
5 $ 49.40 $ 54.73
7 $ 50.05 $ 55.41
Since it is unlikely that ACS would have sustained growth greater than 3%, the assumptions
made in the base case are very reasonable.
3. Relative Valuation
77 companies were used as comparables. Since ACS derives a majority of its revenue from the
US, the comparables used were primarily US firms in the computer software and services
sectors. The firms were further selected based on size and growth to best reflect ACSs value
Regressions were completed with both PE and PBV ratios. The regression vs. PBV produced the
highest R-squared.
Based on this regression, ACSs predicted PBV is 3.283 resulting in a predicted stock price of $
59.87.
The average PBV for the comparables was 2.618 resulting in a predicted stock price of $ 47.75.
4 Market Valuation
PEG = 0.159 ROE + 0.358 Beta + 0.117 Growth 0.011 Payout Ratio (R2 = 48%)
Based on this equation the predicted PBV is 2.65, resulting in a stock price of $ 48.36 clearly the
market regression works well for ACS.
5. EVA
ROC 11.27%
WACC 9.37%
BV Capital $ 2923.88 million
EVA $ 55.61 million
6. Final Analysis
Current Price $ 50.50
DCF Base $ 48.75
DCF Hi $ 54.07
DCF Extreme Hi $ 54.73
Average PBV of comparables 2.618
Average PBV regression 3.283
Market PBV regression 2.54
I would place more weight on the DCF valuation than the average regression since there is some
ambiguity associated with choosing comparables. Thus, I think the base case DCF valuation is
most representative of ACSs current value.
1. Company Overview
Apple Computer, Inc. designs, manufactures and markets personal computers (PCs) and related
personal-computing solutions for sale primarily to education, creative, consumer and business
customers. The Company's personal-computing products include desktop and notebook PCs,
related devices and peripherals, networking and connectivity products, as well as various third-
party hardware products. Apple software products and computer technologies include operating
systems; professional application software; consumer-, education- and business-oriented
application software; Internet products and technologies, and wireless connectivity and
networking products. The Company also has its own retail stores.
2. DCF Valuation
We chose the 2 stage FCFE model because the company has historically had very little debt and
given its new product introductions, it would appear that the company is embarking on a rather
aggressive growth strategy over the near-term. In addition, R&D was capitalized for the firm as
those expenditures are quite significant and last year's earnings were normalized.
Sensitivity Analysis
The key drivers for Apple are the length of the growth rate and length of the growth period
Growth Period
Growth Rate 5 10
10 $22.58 $23.59
15 $24.06 $27.06
20 $25.68 $31.52
As you can see by valuing the inputs the value of Apple varies by almost 70%.
3. Relative Valuation
37 companies were used as comparables. The selection criteria was computer services firms
with revenues greater than 100MM. These firms were selected because they should trade similar
to Apple.
The multiple that was analyzed was the PE ratio. This produced the best R-squared of any of the
earnings multiples (i.e. PE etc). The Regression equation is shown below
R-Sq = 29.7%
Based on this regression, Apples predicted PE is 31.45 resulting in a predicted stock price of
$24.53.
The average PE for the comparables was 61.64 resulting in a predicted stock price of $48.31.
Using both simple and regression techniques it appears as if Apple is undervalued in relation to
comparable firms.
4. Market Valuation
PE = 1.228(g)-.-011(payout)+11.75(Beta)
Based on this equation the predicted PE is 23.4, resulting in a stock price of $18.31. The market
regression indicates that Apple is slightly overvalued
5. EVA
Book value of equity is approximately 2/3 of the invested capital; research asset is worth over
$1.1 billion and represents the other third. This leads to a current EVA of 58.12 which means that
Apple is creating value by reinvesting.
6. Final Analysis
The data above indicates that Apple is undervalued by every metric except the Market PE
regression. This is overwhelming evidence that Apple is undervalued.
1. Company Overview
Biosite Incorporated is a provider of novel, rapid medical diagnostics that improve a physician's
ability to diagnose critical diseases and health conditions. The Company focuses on disease
categories that are in need of improved diagnosis and monitoring. Biosite has adopted a strategy
that encompasses the diagnostic continuum from protein validation to point-of-care diagnostics.
2. DCF Valuation
The 3 stage FCFE discount model is best suited for firms with stable leverage and having high
growth. For Biosite, the growth rate is a fundamental growth rate. Historical growth rates were
not used because the company's earnings just recently became positive, and so the calculated
rates were not very useful. Biosite, although fairly new, has several successful products in the
market, some new launches this year, and a backlog of products being tested for FDA approval.
This is why the analyst growth rate of 28% seemed reasonable. However, to keep our estimates
as conservative as possible, this was replaced with the calculated 14.97% fundamental growth
rate in the high growth phase. The high growth phase was limited to 5 years, after which the
company's risk should transition to an average risk, and the growth will begin to mimic the growth
of the economy. Because of the firm's high level of research and dependence on new products, it
is assumed that capital spending will continue at a high rate. It should also be noted that, at the
moment the company has a very low beta. This is due in part to the low industry beta of the
Medical Supply industry, but even more to the high balance of cash and cash equivalents they
are carrying. As this cash is used to fund new projects going forward, it is assumed that later in
the companys life the beta will move towards 1.
There is also a transition period built in, while the company moves from the High Growth values
to the stable growth values. The transition period will also last approximately 5 years.
The key driver for Biosite is the growth rate in the high growth period, as well as the length of that
period.
Although Biosite has some unique products, it is in a very competitive and rapidly innovative
industry, so assuming sustained high growth of over 5 years seems unreasonable. However,
there is a consensus among analysts that they are poised for high growth so our value estimate
may be low. This only underscores the Buy recommendation we have put on Biosite.
3. Relative Valuation
Based on this regression, Biosites predicted VS is 3.294 resulting in a predicted stock price of
$22.50.
The average VS for the comparables was 3.314 resulting in a predicted stock price of $22.64.
4. Market Valuation
Based on this equation the predicted VS is 4.315, resulting in a stock price of $29.68. This is
much closer to our DCF valuation than the regression against comparables. I believe that the
market comparison is actually more accurate in this case, as it seems that growth is being
undervalued in the industry. You can see that the weighting put in growth is quite high in the
market comparison, while in the comparables regression the greater weight is put on margins.
5. EVA
ROC 10.13%
WACC 6.69%
BV Capital 119,383
EVA 4,103
Biosite, Inc. had a very high EVA in the year ended December 31, 2002, mostly due to a new
product which was just approved to enter the market in 2002. Sales of that product yielded an
ROC in 2002 which was double that of 2001 and significantly higher than the firm's cost of
capital. This brought the firm, historically had a negative EVA, over to a very positive EVA. I
think this can be interpreted as years of investment and research finally paying off.
6. Final Analysis
I place the most weight on my DCF valuation, as I used the most conservative estimates to get
this value, and it is still pointing to a higher actual value than the market is recognizing.
Additionally, the DCF valuation takes in the most information regarding my specific company,
including its current high growth, high margins, potential for extended growth with an extended
transition period, and high current reinvestment rate (100%).
Gundle/SLT Environmental, Inc. manufactures, sells and installs geosynthetic lining products and
services for environmental protection and other uses. It offers products such as flexible
geomembrane liners, drainage nets, geosynthetic clay liners, concrete protection liners and
geocomposite products made from specially formulated polyethylene and polypropylene resins.
2. DCF Valuation
We chose a FCFF with 3 stages because the firm is currently in a period of high growth. In an
effort to taper the earnings down to terminal growth, we used 3 stages. An assumption was
made that the D/E ratio would eventually reach the industry average, so FCFF was utilized.
Two key drivers for Gundle are the growth rate and debt ratio used in the stable growth period
As you can see even with the huge variance between the predicted stock prices, even the most
conservative estimate indicates that the firm is undervalued.
3. Relative Valuation
25 comparables were used for Gundle. The comparable firms were selected from the
environmental industry. All firms with negative earnings were eliminated. This selection criteria
results in a set of firms that are similar to Gundle, ROE was used to control for differences. Only
one variable was used in the regression due to the small sample size.
R-Sq = 27.2%
Based on this regression, Gundles predicted P/BV is 2.271 which results in a predicted stock
price of $29.57.
The average P/BV for the comparables was 1.69 resulting in a predicted stock price of $22.06.
Using both simple and regression techniques it appears as if Gundle is undervalued in relation to
comparable firms.
4 Market Valuation
Based on this equation the predicted P/BV is 2.42, resulting in a stock price of $31.49. The
market regression indicates that Gundle is undervalued
5. EVA
ROC 11.73%
WACC 6.71%
BV Capital 169,193
EVA $8,493
6. Final Analysis
The data above indicates that Gundle is undervalued by every metric. This is overwhelming
evidence that Gundle is undervalued.
1. Company Overview
Infosys Technologies Limited, along with its majority-owned and -controlled subsidiary, Progeon
Limited, is a global information technology (IT) services company. The Company provides end-to-
end business solutions that leverage technology, enabling its clients to enhance business
performance. Its service offerings include custom application development, maintenance and
production support, software re-engineering, package evaluation and implementation, IT
consulting and other solutions, including testing services, engineering services, business process
management, systems integration and IT outsourcing. In addition, the Company offers software
products for the banking industry and business process management services. Its primary client
markets are financial services, manufacturing, telecommunications and retail, as well as utilities
and logistics.
2. DCF Valuation
Infosys has benefited significantly from the recent trend towards outsourcing IT implementation to
India. This trend of high growth is likely to continue over the next 5 years and is reflected in
analysts predictions of > 15% growth over the next 5 years. After the high growth phase is
completed, Infosys off-shoring model will allow it to maintain a sustainable competitive cost
advantage which will allow the firm to grow at a stable rate of 5% in perpetuity. Based on this
information a 2-stage FCFF model was used to calculate firm value.
Sensitivity Analysis
The key drivers for Infosys are the length of the growth period and stable growth rate
Growth Period
Stable Growth Rate 5 10
3 3651 4464
5 4270 5156
7 5682 6733
Since it is unlikely that Infosys would have sustained growth greater than 5%, the assumptions
made in the base case are very reasonable.
3. Relative Valuation
50 companies were used as comparables. Since Infosys derives a majority of its revenue from
the US, the comparables used were primarily US firms in the computer software and services
sectors. The firms were further selected based on size and growth to best reflect Infosys value
Regressions were completed with both PE and PEG ratios. The regression vs. PEG produced
the highest R-squared.
Regression Analysis: PEG versus LN Growth, Value Line Beta, Payout Ratio
The regression equation is
PEG = 5.03 - 1.60 LN Growth + 1.29 Value Line Beta + 0.52 Payout Ratio
Based on this regression, Infosyss predicted PEG is 1.303 resulting in a predicted stock price of
5,307 Rs.
The average PEG for the comparables was 2.22 resulting in a predicted stock price of 9,043 Rs.
4. Market Valuation
PEG = 12.393 + 1.474 Beta -0.015 Payout - 4.55 ln(g) (R2 = 41.8%
Based on this equation the predicted PEG is .34, resulting in a stock price of 16.82 Rs, clearly the
market regression does not work well for Infosys.
One common reason why a firms stock price might be mismatched with its value is poor
management. Poor management can lead to severe value loss. It is possible to estimate the
value of control in a firm by calculating the value of the firm (under current management) and
comparing it to the value of the firm if it were optimally managed. This is a particularly important
concept in mergers and acquisitions.
Infosys Technologies is the perfect case of a firm that could benefit from a value-enhancing
strategy. The firm currently has no debt and its value would increase substantially if it were to
take on a small amount of leverage. The following table summarizes the DCF valuation of
Infosys in its current state.
If Infosys were to raise its debt ratio from 0 to 11.5% its beta would increase but its cost of capital
would decrease. The impact of increasing the debt ratio on various valuation variables is
highlighted below.
Variable Old New
Beta 2.09 2.25
Cost of Equity 13.86% 14.48%
Cost of Debt 4.06% 4.06%
WACC 13.86% 13.29%
The growth period was assumed to be 5 years after which the beta will drop to 1.2. Based on the
new inputs the following DCF analysis was conducted.
Thus, either incumbent or new management would be able to increase the value of Infosys by
$1.36 billion by altering the capital structure.
One potential merger partner is Affiliated Computer Services (ACS). ACS and Infosys both
operate in similar lines of business and therefore there are a number of synergies that could be
realized between the two firms. ACS could benefit substantially from Infosyss cost advantages in
off-shoring IT activities. This would lead to an increased growth rate in the near term as well as a
sustainable competitive advantage that would lead to an increase in the stable growth rate of the
combined firm from 3% to 5%. It is possible to calculate the value of these operating synergies,
by calculating the value of the 2 firms alone and then calculating the value of the combined firm
with synergies.
The background data used in the calculation is as follows
ACS Infosys
Current EBIT 539.23 259.63
Current Revenues 3985.65 922.00
CapEx-Dep 15.07 23.91
Exp Growth (next 5 yrs) 10.0% 17.0%
Exp Growth (stable) 3.0% 5.0%
D/D+E 11.5% 11.5%
After Tax cost of Debt 4.26% 4.26%
Beta - next 5 1.27 2.25
Beta - stable 1.00 1.20
Working Cap/Rev 22% 5.10%
Based on the inputs shown above, ACS can be valued using a FCFF 2 stage model
The following operating synergies are assumed to take effect immediately. The combined firm will
have a 5 year growth period of 15% (this is an increase for ACS and a slight decrease for
Infosys), and a stable growth rate of 5% (again an increase for ACS). At the same time, by
leveraging the off-shoring model of Infosys, ACS will be able to increase its ROC from 8% to
15%. By merging the 2 firms will also have a new beta and cost of capital.
Infosys ACS
Unlevered Beta 2.09 1.217
Firm Value 7.38 5.35
Unlevered Beta 1.72
Combined Firm D/E 11.50%
New Levered Beta 1.85
Cost of Equity 11.41%
WACC 10.58%
Based on the inputs outlined above the combined firm can be valued with the operating synergies
previously described.
Year FCFF Terminal Value PV
1 349 315.5957
2 401 327.9109
3 481 355.6823
4 591 395.194
5 702 10262 10686.03
Terminal 948
Value of Combined Firm $ 13,028
Value of Infosys + ACS $ 12,729
Total Value of Synergy $ 299
From the calculations outlined above, the complete value of Infosys can be broken down as
follows
In the potential merger outlined, how the increased value associated with combining the firms is
divided between the firms would be subject to negotiation.
6. EVA
ROC 28.12%
WACC 13.86%
BV Capital 3383
EVA 482 Rs crore
7. Final Analysis
I would place more weight on the DCF valuation than the market regression since there is some
ambiguity associated with choosing comparables across countries. Thus, I think the base case
DCF valuation is most representative of Infosyss current value.
1. Company Overview
Nextel Partners: Nextel Partners, Inc. provides digital mobile communications services using the
Nextel brand name in mid-sized and tertiary markets throughout the United States. The Company
offers digital cellular services; Direct Connect (the long-range digital walkie-talkie service);
wireless data services, including e-mail; text messaging and Nextel Online. Nextel Partners has
constructed and operated a digital mobile network compatible with the digital mobile network
established and operated by Nextel Communications Inc. (Nextel) in targeted portions of these
markets in the United States.
2. DCF Valuation
Since the firm has negative earnings, we used an n-stage FCFF model in arriving at the
valuation. Target growth rates were estimated for a five year high growth phase using average
analyst estimates. In addition, given the firms high leverage, an option pricing model was used
to determine the value of equity as a call option.
The key drivers for Nextel Partners are the length of the growth period, high and stable growth
rate and capital spending, depreciation and working capital needs during the high growth period.
3. Relative Valuation
53 wireless networking companies were used as comparables. Four outlier companies were
removed from the original sample to best reflect Nextels value.
Based on this regression, Nextels predicted Value/BV Capital is 1.36 resulting in a predicted
stock price of $8.82.
The average Value/BV Capital for the comparables was 1.80 resulting in a predicted stock price
of $11.65.
4. Market Valuation
Value/Book Capital= 1.89+ .10 g (rev) + .061 (Return on Capital) - .043 (Debt/Capital)
Based on this equation the predicted V/BV Capital is 1.87, resulting in a stock price of $12.15.
Nextel Partners is a negative earnings firm with high leverage. Utilizing the option pricing model,
with industry average standard deviations for stock and bond prices and an average debt life of
6.4 years, results in an option value of $9.09.
Output
d1 = -0.266884801
N(d1) = 0.394778988
d2 = -1.998944408
N(d2) = 0.022807115
6. EVA
ROC -19.71%
WACC 18.57%
BV Capital 1,632
EVA -625
The wireless networking industry has average firm EVA of -5,742. Nextel Partners experienced a
greater ROC-WACC differential on a smaller capital base than the wireless networking industry
average. This lead to a less negative, and hence more favorable, EVA calculation compared to
the industry mean.
7. Final Analysis
I would place more weight on the DCF valuation than the market regression since there is some
ambiguity associated with choosing comparables across countries. Thus, I think the base case
DCF valuation is most representative of Nextels current value.