Assignment #2 Stock Valuation A. Choose a stock that interests you. Utilizing Bloomberg, Yahoo Finance, Google Finance, etc. as a source of data, collect the following information: a. The stock's Beta b. The rate of return on the market (S&P 500 Index) c. The risk-free rate ( d. The last dividend paid O. e. The annual expected growth rate of earnings B. In Excel, use the Discounted Dividend Model for Constant Growth Stocks and solve for the intrinsic stock price () Based on your above calculations, compare the calculated price with the current market price and indicate whether is the stock price overvalued, undervalued, or at equilibrium? Explain. C. Now, assume that your company has just released a new product and will be experiencing supernormal growth of 25% for the next three years. In Excel, use the information in "A" and the Discounted Dividend Model for Nonconstant Growth Stocks and solve for the intrinsic stock price). 133.29 +1.31 (+0.99%) 133.50 +0.21 (0.16%) At close: LOOPM EST After hours 5:15PM EST Buy Sell Summary Company Outlook Chart Conversations Statistics Historical Data Profile Financial Analysis Options Ho Previous Close 131.98 105D 1M6M YTD 1Y SY Max 185.868 0.57 * Full screen 13330 Open Market Cap Beta (3Y Monthly) PE Ratio (TTM) 132.63 Bid 133.30 x 1200 15.17 Ask 133,50 x 1200 EPS (TTM) 8.79 132333 Day's Range 132.01 - 133.57 Feb 13, 2020 Earnings Date Forward Dividend & Yield 1319 13100 52 Week Range 105.03. 140.45 3.82 (2,89%) Volume 2.237.280 Ex-Dividend Date 2019.09.05 04 PM sourced from all markets Trade peces are Avg. Volume 3,682,552 ty Target Est 139.67 View more ideas BUY Fair Valve Near Fair Value Analyst Recommendation by Arus Research Short Term Mid Term Long Term