I am learning excel. Can someone show me how to do this in excel? Let's assume that you're thinking about buying stock in West Coast Electronics. So far in your analysis, you've uncovered the following information: The stock pays annual dividends of $5.07 a share indefinitely. It trades at a P/E of 10.8 times earnings and has a beta of 1.12. In addition, you plan on using a risk-free rate of 3.00% in the CAPM, along with a market return of 9%. You would like to hold the stock for 3 years, at the end of which time you think EPS will be $8.24 a share. Given that the stock currently trades at$66.97 use the IRR approach to find this security's expected return. Now use the dividend valuation model (with constant dividends) to put a price on this stock. Does this look like a good investment to you? Explain. This security's expected return (IRR) is enter your response here%.(Round to two decimal places.) Thanks