GE has determined that the hypothetical cash flows generated by this purchase would be of similar riskiness to its own total asset cash flows. Therefore, GE will use its asset expected return to discount the future cash flows it expects to receive from the manufacturing company. Your challenge is to calculate GEs asset expected return, which will be used as the independent manufacturers discount rate. a) First, calculate GEs equity beta. Go to Yahoo! Finance and click on Get Quotes for GE. Click on Historical Prices and download monthly GE price data from August. 1, 2012 to August 3, 2015. Do the same for the S&P500 (symbol: ^GSPC), our underlying proxy for the market return. Next, calculate monthly returns for each security using the equation rt=(Pt-Pt-1)/Pt-1, where rt is the return in month t, and Pt is the adjusted closing price in month t. When calculating returns, make sure your data are sorted so that time is in ascending order, not the default descending order. Convert all of your returns into excess returns (rt-rf) by subtracting the monthly risk-free rate, which we will assume as 0.03/12. You will not have a return observation for the first month of your time series. Then, run a linear regression of GE excess returns (your Y variable) on S&P500 excess returns (your X variable). You can find Regression in Microsoft Excel in Data Analysis under the Data tab.1 If the X-variable coefficient is positive and statistically significant (t-statistic greater than 1.95), then we conclude (with 95% confidence) that if S&P500 returns are 1 percent higher, then GE returns are (Coefficient multiplied by 1 percent) higher. Report the X-variable coefficient along with its t-statistic. The X-variable coefficient is the equity beta for GE. This was derived by fitting data to the CAPM. b) Next, we need GEs market values of debt and equity. Go back to the GE page in Yahoo! Finance. The market value of equity is also known as market capitalization and can be found on the Summary page. 1 If Data Analysis does not appear, do the following: click File, then Options, then Add-Ins, then click the Go button. Check the Analysis ToolPak box and click OK. Data Analysis should then appear in the Data tab. To find the market value of debt, click on Balance Sheet on the left hand side and obtain GEs Total Liabilities from December 31, 2014. Because GEs debt is fairly stable, it is safe to assume that the book value of debt equals the market value of debt. Because GEs debt is considered very low risk, we will assume GEs debt beta equals 0.05. Report the market value of equity and the market value of debt for GE. c) Using the information from parts (a) and (b), calculate the asset beta for GE. Show your workings. d) Using the CAPM, calculate and report the expected return for GEs assets. Assume a market risk premium of 6.0% and a risk-free rate of 3.0% (an approximate yield on 30-year U.S. treasury securities). Show your workings. You expect this acquisition to generate its first cash flow next year and that it will be equal to 0.10 percent of your firms end-of-2014 cash flows provided by operating activities (see GEs most recent cash flow statement, which can be found under Cash Flow on the left hand side of the GE page on Yahoo! Finance). Forecasts inform you that these cash flows will grow by 0.25 percent per year thereafter, and that you will receive cash flows in perpetuity. These cash flows are due to the cash flows generated by the acquired manufacturing company and the projected benefits from having GE combine forces with this company. e) What is the maximum you would be willing to pay for this independent manufacturing company? That is, what is the value of this independent manufacturing company? Question 3 You are an original owner of a publicly traded food service company called Smiths Foods (SF). Your company has been in the high-end restaurant business (HE) for the past ten years. You announced today that the company will be issuing debt today to open a new fast food division (FF). Opening this new division costs $10M today, which you will fund by issuing debt. Revenues from this new division are expected to be $3M next year and are projected to grow by 4 percent per year. Costs from this new division are expected to be $2M next year and are projected to grow by 2 percent per year. The life of this project is 15 years. Analysis of other fast food businesses suggests that the beta of a fast food division equals 0.70. Assume that the revenues and costs have similar risk. Throughout this problem, assume a risk-free rate of 3 percent and a market risk premium of 6 percent. a) What is the NPV of this new investment? Is it a good investment? Hint: you will need to use the growing annuity formula twice. Once for revenues and once for costs. A regression of monthly SF excess stock returns on monthly S&P 500 excess returns from the past ten years tells you that the beta of the high-end division equals 1.5. Directly before the investment in the fast food division, SF was an all-equity firm with 1M shares outstanding trading at $25 per share. Assume that the announcement of the new division does not affect the value or beta of the high-end division. b) What is the beta of the firm after the announcement of the new division? The beta of a firm can be calculated as the value-weighted average of the division betas: Bfirm = (Vd1/(Vd1+Vd2)Bd1 + (Vd2/(Vd1+Vd2))Bd2 where the value of a division (VD1 or VD2) equals the present value of its future net cash flows. c) Assume that the beta of the new debt (valued at $10M) is equal to 0.1. What is the beta of the firms equity after the announcement of the new division? d) The beta of your firms equity was originally 1.6. There are two reasons why the announcement caused the beta of your firms equity to slightly change one reason causes the original beta to decrease while the other causes it to increase. Briefly explain these reasons. e) What is the change in the expected return of the firm due to the announcement?