Step 1: Choose a Company (I have chosen LinkedIn) Pick a high-growth potential company. The company should have earnings or revenues expected to grow more than 50% in the near future. High-Growth potential company choice: LinkedIn Corporation (NYSE:LNKD) Step 2: Discounted Cash Flow Valuation 1.) Value the stock in your company using a discounted cash flow model. You should choose the model that you think is most appropriate for your company. 2.) Estimate how sensitive your value estimates are to changes in your assumptions. What are the key drivers of value for your company? 3.) Identify the key assumption or variable that you would focus on in doing your discounted cash flow valuation. Examples would include the growth rate assumption, the growth period assumption, and the net capital expenditure assumption. 4.) Present your valuation in a creative picture, summarizing the assumptions that you have made. 5.)This should be approximately 2 pages long. The setup should be similar to the Sample attached for the DCF portion.

Equity Valuation Project 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. The assumptions used to build the DCF model are High Growth 5 10.00% 11.51% 1.27 4.3% 4.53% 6.55% 35% 11.27% 56.61% 10.03% 9.37% Length of growth period Growth Rate Debt Ratio Beta Riskfree Rate Risk Premium Cost of Debt Tax Rate Return on Capital Reinvestment Rate Cost of Equity Cost of Capital Stable Growth Forever 3% 16.00% 1 4.3% 4.53% 6.55% 35% 8.83% 37.04% 8.83% 8.10% Based on these inputs the valuation was as follows EBIT $539.23 million Equity Value $6734.72 million Firm Value $7640.96 million Value/Share $48.75 Current Market Price $50.50 Sensitivity Analysis The key drivers for ACS are the length of the growth period and stable growth rate Growth Period Stable Growth Rate 3 5 7 5 $ 48.75 $ 49.40 $ 50.05 10 $ 54.07 $ 54.73 $ 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 ACS's value Regressions were completed with both PE and PBV ratios. The regression vs. PBV produced the highest R-squared. Regression Analysis: PBV versus ROE The regression equation is PBV = 0.608 +15.9*ROE Predictor Constant ROE S = 1.309 Coef 0.608 15.926 R-Sq = 52.6% SE Coef 0.2642 1.733 T P 2.30 9.19 0.024 0 R-Sq(adj) = 52.0% Based on this regression, ACS's 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 The market regression equation is 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 WACC BV Capital EVA 11.27% 9.37% $ 2923.88 million $ 55.61 million ACS is creating value with any reinvestment of capital 6. Final Analysis Current Price DCF Base DCF Hi DCF Extreme Hi Average PBV of comparables Average PBV regression Market PBV regression $ 50.50 $ 48.75 $ 54.07 $ 54.73 2.618 3.283 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 ACS's current value. I recommend to SELL ACS Apple Computer 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 thirdparty 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. The assumptions used to build the DCF model are: High Growth 10 15% 0 2.15 4.4% 4.1% 35% 13% 15% 13.21% Length of growth period Growth Rate Debt Ratio Beta Riskfree Rate Risk Premium Tax Rate Return on Equity Reinvestment Rate Cost of Equity Stable Growth Forever 4% 0 1.2 4.4% 4.1% 35% 15% 30.77% 9.31% Based on these inputs the valuation was as follows: Net Income (w/o interest) $252 Equity Value $5,400 Cash and Marketable Sec $4,545 Value/Share $27.06 Current Market Price $20.85 Sensitivity Analysis The key drivers for Apple are the length of the growth rate and length of the growth period Growth Period Growth Rate 10 15 20 5 $22.58 $24.06 $25.68 10 $23.59 $27.06 $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 Regression Analysis: PE versus Growth, Value Line Beta, Payout Ratio The regression equation is PE = - 56.2 - 107 Payout Ratio + 62.0 Value Line Beta + 270 Growth in EPS R-Sq = 29.7% Based on this regression, Apple's 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 The market regression equation for PE is: 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 Current Price DCF Base DCF Lo DCF Hi Average PE of comparables Average PE regression Market PE regression $20.85 $27.06 $22.58 $31.52 $48.31 $24.53 $18.31 The data above indicates that Apple is undervalued by every metric except the Market PE regression. This is overwhelming evidence that Apple is undervalued. I recommend to BUY Apple. Biosite, Inc. 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. High growth potential company. 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 company's life the beta will move towards 1. The assumptions used to build the DCF model are: High Growth 5 14.97% 10.60% 0.56 4.21% 4.53% 38% 14.60% 100% 6.75% Length of growth period Growth Rate Debt/Equity Beta Riskfree Rate Risk Premium Tax Rate Return on Capital Reinvestment Rate Cost of Equity Stable Growth Forever 4.5% 6.93% 1 4.21% 4.53% 38% 7% 20% 8.74% 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. Based on these inputs the valuation was as follows EPS, Year 1 0.91 Equity Value $ 487,960,000 Value/Share $ 32.76 Current Market Price $ 26.12 Sensitivity Analysis The key driver for Biosite is the growth rate in the high growth period, as well as the length of that period. High Growth Period High Growth Rate 28% 20% 14.97% 5 $65.52 42.92 32.76 10 $161.80 77.55 48.50 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 51 companies were used as comparables. Biosite is a US company operating in the Medical Supply industry, so Medical Supply firms were used as comparables. Regressions were completed with VS (Value to Sales) ratios. Regression Analysis: VS versus Growth in revenues, Operating Margin, and Debt/Capital The regression equation is PEG = -1.33 + 16.507 Growth + 21.26 Operating Margin - 3.031Debt/Capital Predictor Constant Growth Operating Margin Debt/Capital S = 1.7066 R-Sq = 56.2% Coef - 1.331 16.507 21.26 -3.031 SE Coef 1.07849 5.575785 3.905606 2.484828 T -1.23498 2.960603 5.445124 -1.21994 P 0.22311 0.004842 1.95E-06 0.228706 R-Sq(adj) = 53.3% Based on this regression, Biosite's 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 The market regression equation is: VS = 0.264 g(rev) + 0.150 (Operating Margin) - 0.009 (Reinvestment Rate) - 0.048 (Debt/Capital) 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 WACC BV Capital EVA 10.13% 6.69% 119,383 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 Current Price DCF Base DCF Lo DCF Hi Average VS of comparables Comparables VS regression Market VS regression $26.12 $32.76 $32.76 $161.80 $22.64 $22.50 $29.68 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 it's current high growth, high margins, potential for extended growth with an extended transition period, and high current reinvestment rate (100%). I place a BUY recommendation on Biosite, Inc. Gundle Environmental Systems 1. Company Overview 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. The assumptions used to build the DCF model are High Growth 6 10.0% 7.67% 0.55 4.5% 4.5% 5.5% 35% 11.73% 80.0% Length of growth period Growth Rate Debt Ratio Beta Riskfree Rate Risk Premium Cost of Debt Tax Rate Return on Capital Reinvestment Rate Based on these inputs the valuation was as follows EBIT Stable Growth Forever 3% 42.53% 1 4.5% 4.5% 5.5% 35% 10.67% 28.12% $30,790 Equity Value $490,891 Firm Value $509,549 Value/Share $41.13 Current Market Price $19.73 Sensitivity Analysis Two key drivers for Gundle are the growth rate and debt ratio used in the stable growth period Growth Rate 5 10 15 30 $29.20 $35.02 $41.72 Debt Ratio in Stable Growth 42 $34.02 $41.13 $48.67 50 $38.29 $45.98 $54.83 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. Regression Analysis: P/BV vs. ROE The regression equation is P/BV = 1.11 + 7.74* ROE R-Sq = 27.2% Based on this regression, Gundle's 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 The market regression equation for PE is P/BV = 0.159 ROE +.358 Beta +.117 g -.011 Payout 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 WACC BV Capital EVA 11.73% 6.71% 169,193 $8,493 Gundle is creating value with any reinvestment of capital 6. Final Analysis Current Price DCF Base DCF Lo DCF Hi Average P/BV of comparables Average P/BV regression Market P/BV regression $19.13 $41.13 $29.20 $54.83 $22.06 $29.57 $31.49 The data above indicates that Gundle is undervalued by every metric. This is overwhelming evidence that Gundle is undervalued. I recommend to BUY Gundle. Infosys Technologies, LTD 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-toend 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. International and services company. 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. The assumptions used to build the DCF model are High Growth 5 17.23% 0 2.09 5.5% 4% 6.25% 35% 28.12% 61.27% 13.86% 13.86% Length of growth period Growth Rate Debt Ratio Beta Riskfree Rate Risk Premium Cost of Debt Tax Rate Return on Capital Reinvestment Rate Cost of Equity Cost of Capital Stable Growth Forever 5% 5.5% 1.2 5.5% 4% 6.25% 35% 15% 33.3% 10.3% 9.96% Based on these inputs the valuation was as follows: EBIT 2,064 Rs crore Equity Value 29,088 Rs crore Firm Value 29,114 Rs crore Value/Share 4,270 Current Market Price 4,912 Sensitivity Analysis The key drivers for Infosys are the length of the growth period and stable growth rate Growth Period Stable Growth Rate 3 5 7 5 3651 4270 5682 10 4464 5156 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 Predictor Constant LN Growth Value Line Beta Payout R S = 1.095 R-Sq = 31.3% Coef 5.035 -1.6009 1.2863 0.517 SE Coef 1.223 0.364 0.5779 1.257 T P 4.12 -4.4 2.23 0.41 0 0 0.03 0.683 R-Sq(adj) = 27.3% Based on this regression, Infosys's 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 The market regression (using the ADR listing of Infosys) equation is 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. 5. Value of Control and Synergy One common reason why a firm's 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. Year 1 2 3 4 5 FCFF 747 876 1150 1583 1997 2096 27727 Terminal Firm Value Terminal Value 23531 $ PV 656 676 785 968 24642 6,027.61 million $ @ 46 Rs/$ Note: The FCFF and PV values are in Indian Rs 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 Beta Cost of Equity Cost of Debt WACC Old 2.09 13.86% 4.06% 13.86% New 2.25 14.48% 4.06% 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. Year 1 2 3 4 5 Terminal Firm Value w/control change Value of the Firm Status Quo Value of Control FCFF 747 875 1150 1583 1997 2096 33963 Terminal Value 29688 $ $ $ PV 659 682 797 991 30834 7,383.26 million $ @ 46 Rs/$ 6,027.61 1,355.65 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 Infosys's 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 Current EBIT Current Revenues CapEx-Dep Exp Growth (next 5 yrs) Exp Growth (stable) D/D+E After Tax cost of Debt Beta - next 5 Beta - stable Working Cap/Rev ACS 539.23 3985.65 15.07 10.0% 3.0% 11.5% 4.26% 1.27 1.00 22% Infosys 259.63 922.00 23.91 17.0% 5.0% 11.5% 4.26% 2.25 1.20 5.10% Based on the inputs shown above, ACS can be valued using a FCFF 2 stage model Year 1 2 3 4 5 Terminal Value of ACS FCFF 181 199 234 286 334 344 $ 5,346.00 Terminal Value 4415 PV 165 166 179 202 4634 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. Unlevered Beta Firm Value Unlevered Beta Combined Firm D/E New Levered Beta Cost of Equity WACC Infosys 2.09 7.38 1.72 11.50% 1.85 11.41% 10.58% ACS 1.217 5.35 Based on the inputs outlined above the combined firm can be valued with the operating synergies previously described. Year 1 2 3 4 5 Terminal Value of Combined Firm Value of Infosys + ACS Total Value of Synergy FCFF 349 401 481 591 702 948 $ 13,028 $ 12,729 $ 299 Terminal Value 10262 PV 315.5957 327.9109 355.6823 395.194 10686.03 From the calculations outlined above, the complete value of Infosys can be broken down as follows Value of Infosys - Status Quo Value of Control Value of Infosys - Optimally managed Value of Synergy Total Value of Infosys = $ 6,027 million = $ 1,355 million = $ 7,383 million = $ 299 million = $ 7,682 million 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 WACC BV Capital EVA 28.12% 13.86% 3383 482 Rs crore Infosys is creating value with any reinvestment of capital 7. Final Analysis Current Price DCF Base DCF Lo DCF Hi Average PEG of comparables Average PEG regression Market PEG regression 4912 4270 3651 6733 9043 5307 16 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 Infosys's current value. I recommend to SELL Infosys. Nextel Partners, Inc 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. Negative earnings company. 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 firm's high leverage, an option pricing model was used to determine the value of equity as a call option. The assumptions used to build the DCF model are: High Growth 5 Declining from 24% to 8% 39% 3.93 4.4% 4.0% 15.9% 0% -19.71% 100% 20.12% 18.57% Length of growth period Growth Rate Debt Ratio Beta Riskfree Rate Risk Premium Cost of Debt Tax Rate Return on Capital Reinvestment Rate Cost of Equity Cost of Capital Stable Growth Forever 4.75% 39% 1.00 4.4% 4.0% 7.6% 40% 8.10% 100% 8.39% 8.10% Based on these inputs the valuation was as follows Debt Value 1,706 Equity Value 1,026 Firm Value 2,525 Value/Share $11.08 Current Market Price $11.72 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 Nextel's value. Regressions were completed with a Price/Sales, Enterprise Value/Sales, Price/Book Value of Capital and Value/Book Value Capital ratio. The regression of Value/Book Value Capital produced the highest R-squared. Regression Analysis: Value/BV of Capital versus ROC, Market Debt to Capital The regression equation is Value/BV of Capital = 1.64 - 0.644 ROC - 0.693 Market Debt to Capital Predictor Constant ROC Market Debt/Capital S = 1.167 R-Sq = 25.2% Coef 1.6417 -0.6444 -0.6933 SE Coef 0.2248 0.1809 0.4983 T 7.3 -3.56 -1.39 P 0 0.001 0.17 R-Sq(adj) = 22.3% Based on this regression, Nextel's 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 The market regression equation is 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. 5. Option Pricing Model 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 Stock Price= $9,823.00 T.Bond rate= Strike Price= $92,569.73 Variance= 6.4 Expiration (in years) = Annualized dividend yield= d1 = -1.998944408 N(d2) = 0.0% 0.394778988 d2 = 0.468755 -0.266884801 N(d1) = 4.4% 0.022807115 Value of equity as a call = $2,283.80 Value of outstanding debt = $7,539.20 Appropriate interest rate for debt = $9.09 per share 47.97% 6. EVA ROC WACC BV Capital EVA -19.71% 18.57% 1,632 -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 Current Price DCF Base Average Value/BV Capital of comparables Average Value/BV Capital regression Market Value/BV Capital regression $11.72 $11.08 $11.65 $8.82 $12.15 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 Nextel's current value. I recommend to SELL Nextel