See attachment. Looking for assistance setting up part III.

Assignment #1 - due Thursday 9 PM September 25 via net submission (worth 150 points or 15% of total grade) Part I: Acquisition Scenarios (48 points) Hint #1: The valuation of a company's stock can be expressed in the following formula If the company in question is generating a dividend that is growing at a constant and perpetual rate of g: P0 = D1 / (Ke - g) Where: P0 = Current share price today (year 0) D1 = Expected dividend paid at end of the upcoming year (year 1) Ke = required investor return on equity g = perpetual growth rate in dividends Differences in the level of Ke are determined by differences in risk between earnings streams for companies. If we know P0 , D1 and g, we can solve for Ke. Hint #2: Assume that the stock market is efficient and that investors all agree on the expected dividends and earnings in the future. This means that the impact of any merger announcement will be accurately reflected in the current stock price immediately. Hint #3: Apply the value additivity concept from the diversification folly example in class. (Firm value equals sum of the valuation \"pieces\") with the pieces including values of the target firm and the bidder firm and present valus of merger synergies. Hint #4: Estimating a weighted cost of equity for the new post merger firms in the below questions is not really needed to get valuations. Just add together the valuation pieces. Value of acquirer, value of target, value of extra cash flows from deal. Acquisitions Inc is looking to expand its reach via acquisition. It feels that it has some assets that when combined with other businesses could yield some synergies. We are currently in year 0. The firm currently pays all earnings in a year as dividends. Below is some additional information on Acquisitions Inc: Debt = None Market Value of Equity = $ 10,000 million Shares outstanding = 100 million Current share price = $100 Expected Earnings for year 1 = D1 = $10.00 per share Growth rate (g) in perpetuity is zero for dividends and earnings. Acquisitions Inc is mulling a number of acquisition ideas. Answer the questions related to each one in isolation. In other words, they would only do one merger. 1. Acquisition Candidate E: Acquisitions has negotiated with firm E on an acquisition of E. Acquisitions Inc. would give firm D shareholders .57 shares of stock in Acquisitions Inc. for each share outstanding of firm E. Here is some information about firm E: Debt = None Market Value of Equity = $ 5,000 million (before acquisition offer is known) Shares outstanding = 100 million Current share price = $50 Expected Earnings for year 1 = D1 = $6.00 per share Growth rate (g) in perpetuity is zero for dividends and earnings The rationale (synergy) for the merger is that Firm E's excellent products can be sold through the distribution channels of Acquisition Inc and generate extra profits and dividends starting very quickly (with no extra investment). In fact, the assumption is that the earnings and dividends of the joint firm will increase in the upcoming year (time 1) by $48 million and stay at that higher level in perpetuity. The risk of these extra earnings is thought to be similar to the risk of firm E's cash flows today. Firm E is in a more cyclical (riskier) line of business than Acquisitions Inc. a) Will a merger between these two companies result in a greater combined value of the two firms? Please show with numbers. b) What is the new Price of one share of Acquisitions Inc stock immediately after the merger is done? c) Will the EPS (earnings per share) of Acquisitions Inc rise or fall in year 1 if this acquisition is done? What would the new EPS be? d) What is the new price to earnings ratio (P / E1) for Acquisitions Inc after the merger closes? e) If Acquisitions Inc management simply required that any new merger to be approved must increase EPS and must have some \"synergy\