Data for Shamrock State Bank follow. Click the icon to view the data.) Evaluate the common stock of Shamrock State Bank as an investment. Specifically, use the three stock ratios to determine whether the common stock has increased or decreased in attractiveness during the past year. Round to two decimal places Begin by selecting the formula to calculate the pricelearnings ratio. Price/earnings ratio = Market price per share of common stock/Earnings per share Data Table - X Now, calculate the price earnings ratio for 2018 and 2017. (Round interim calculations to the nearest cent, $XXX and your answers to two decimal places, Xxx.) 2018 2018: S 36.79 34.21 2017 44.000 Net Income S 55,250 $ 2017: S Dividends-Common 24,000 24,000 15,500 15,500 Select the formula to calculate the dividend yield. Dividend yield = Annual dividend per share / Market price per share Dividends-Preferred Total Stockholders' Equity at Year-End (includes 75,000 shares of common stock) Preferred Stock Market Price per Share of Common Stock 780,000 600.000 Now, calculate the dividend yield on common stock for 2018 and 2017. (Round interim calculations to the nearest cent, $X.XX, and your final answers to one tenth of 53.31% 190.000 19.50 $ 190.000 13.00 S 2018: 2017: 61.5% Print Done