Data Case As a new analyst for a large brokerage firm, you are anxious to demonstrate the skills you learned in your MBA program and prove that you are worth your attractive salary. Your first assignment is to analyze the stock of the General Electric Corporation. Your boss recommends determining prices based on both the dividend-discount model and discounted free cash flow valuation methods. GE uses a cost of equity of 10.5% and an after-tax weighted average cost of capital of 7.5%. The expected return on new investments is 12%. However, you are a little concerned because your finance professor has told you that these two methods can result in widely differing estimates when applied to real data. You are really hoping that the two methods will reach similar prices. Good luck with that! 1. Go to Yahoo! Finance (http://finance.yahoo.com) and enter the symbol for General Electric (GE). From the main page for GE, gather the following information and enter it onto a spreadsheet: a. The current stock price (last trade) at the top of the page. b. The current dividend amount, which is in the bottom-right cell in the same box as the stock price. 2. Next, click “Key Statistics” from the left side of the page. From the Key Statistics page, gather the following information and enter it on the same spreadsheet: a. The number of shares of stock outstanding. b. The Payout ratio. 3. Next, click “Analyst Estimates” from the left side of the page. From the Analyst Estimates page, find the expected growth rate for the next five years and enter it onto your spreadsheet. It will be near the very bottom of the page. 4. Next, click “Income Statement” near the bottom of the menu on the left. Place the cursor in the middle of the income statements and right-click. Select “Export to Microsoft Excel.” Copy and paste the entire three years of income statements into a new worksheet in your existing Excel file.Repeat this process for both the...