Evaluate the common stock of Nelson 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. (Click the icon to view the financial information.) Enter the formula on the first line, then calculate the price/earnings ratio (P/E) for both years. (Round all intermediat calculations to three decimal places and the P/E ratios to one decimal place.) = P/E ratio times Current year times Last year Enter the formula on the first line, then calculate dividend yield for both years. (Round the annual dividend per share of common stock to four decimal places and the dividend yield to the nearest hundredth percent, X.XX%.) Dividend yield Current year Last year Enter the formula on the first line, then calculate book value per share of common stock for both years. (Abbreviation used: CS = common stock. Round your answers to two decimal places.) Book value per share of common stock Current year Last year Choose from any list or enter any number in the input fields and then continue to the next question. (Click the icon to view the financial information.) ERE Enter the formula on the first line, then calculate dividend yield for both years. (Round the annual dividend per share of common stock to four decimal places and the dividend yield to the nearest hundredth percent, X.XX%.) Dividend yield % Current year % Last year Enter the formula on the first line, then calculate book value per share of common stock for both years. (Abbreviation used: CS = common stock. Round your answers to two decimal places.) Book value per share of = common stock Current year Last year Determine whether the common stock has increased or decreased in attractiveness during the past year. The stock's attractiveness during the current year, as shown by the in the price/earnings ratio and in book value per share. The dividend yield but that would be important only to investors who want dividends. Overall, the common stock looks than it did a year ago. inue to the next question X - Data Table Data Table Bre nu d % Current year Last year $ 80,400 $ 47 200 21,580 $ 21,580 $ 14,000 $ 14,000 Cu $ % Las tion Ent usel Net income. Dividendscommon Dividends-preferred... Total stockholders' equity at year end (includes 83,000 shares of common stock). Preferred stock, 6% Market price per share.of common $ $ 809,300 $ 639,150 220,000 $ 220,000 20.00 $ 8.00 e of bok