the questions i have regarding your response are;Where did you get the revenue growth of 10% from for calculation of the FCF?;Shouldn't the cash flows be done for 10 years and not 5 years as you did it?;Where did you get the discount factor of 1% from?;What is CAGR (8%), and how did you calculate it?;Sorry to bother you again but i need to understand the process in order to explain it in my report. Thank You.;The case is below;@Home Network merger with Excite Inc Case Study;Background;@Home Network announced its merger with Excite Inc. in January 1999 for $6.7 billion. Prior to the announcement, Excite?s market value was about $3.5 billion. The transaction closed in May 1999. The announced purpose of the transaction was to create a new media company capable of providing home and business customers high speed, 24-hour access to personalized services from their PCs, pagers, cellular phones, and television sets. The new company combines the search engine capabilities of one of the best known brands on the Internet, Excite, with @Home?s agreements with 21 cable companies worldwide. @Home gains access to the nearly 17 million households that are regular users of Excite.;At the time, this transaction constituted the largest merger of Internet companies ever. As of July 1999, Excite @Home displayed a P/E ratio in excess of 260 based on the consensus estimates for the year 2000 of $0.21 per share. The firm?s market value was $18.8 billion, 270 times sales. Investors really had great expectations for the future performance of the combined firms, despite their lackluster profit performance since their inception.;Founded in 1995, @Home provided interactive services to home and business users over its proprietary network, telephone company circuits, and through the cable companies? infrastructure. Cable connections provide connections at more than 100 times the speed of dial-up services. @Home also provides branded content in this broadband environment. Subscribers pay $39.95 per month for the service.;Assumptions;? Excite is properly valued immediately prior to announcement of the transaction.;? Annual customer service costs equal $50 per customer.;? Annual customer revenue in the form of @Home access charges and ancillary services equals $500 per customer. This assumes that declining access charges in this highly competitive environment will be offset by increases in revenue from the sale of ancillary services.;? None of the current Excite user households are current @Home customers.;? New @Home customers acquired through Excite remain @Home customers in perpetuity.;? @Home converts immediately 2% or 340,000 of the current 17 million Excite user households. A 2% response rate is typical of both online and direct mail solicitations.;? @Home?s cost of capital is 20% during the growth period and drops to 10% during the slower, sustainable growth period, its combined federal and state tax rate is 40%.;? Capital spending equals depreciation, current assets equal current liabilities.;? FCFF from synergy increases by 15% annually for the next 10 years and 5% thereafter. Its cost of capital after the high-growth period drops to 10%.;? The maximum purchase price @Home should pay for Excite equals Excite?s current market price plus the synergy that results from the merger of the two businesses.;CASE STUDY DISCUSSION QUESTIONS;? Did @Home overpay for Excite? You are required to show all calculations, data and analysis using correct course concepts to support your response to this question. Discuss. Note: It is necessary to also calculate the estimated value of synergy to answer this question.;? What is the maximum purchase price for Excite including synergy? Assume another company was evaluating Excite as a merger candidate, would it obtain the same value? Discuss.;? Assume that Excite has 63 million shares outstanding. These shares are traded relatively frequently. Should the merger go ahead at the current offer of $6.7 billion? How much would the stock price be valued at that level, and how much of a premium or discount would this represent? On the other hand, based on the maximum computed purchase price for Excite (including synergy) referenced in bullet #2 above, determine the price per share associated with this maximum purchase price. Discuss.;? Discuss other assumptions that you might consider in addition to those identified in this case study.;? Discuss the limitations of the valuation method employed in this case.;? Address alternative valuation techniques that could be utilized in this case.;How did you calculate CAGR?
Paper#30821 | Written in 18-Jul-2015Price : $27