please do the 3 requirements thanks!

Data for Shamrock State Bank follow 2. Click the icon to view the data) Evaluate the common stock of Samrock State Bank as an investment Specifically use the three stock inton to determine whether the common stock han created or decreased in atractiveness during the past year. Round two decimal places Begin by selecting the formula to calculate the pricemingsrano Prilingsrutie Market price per share common Euminga ner share New Caledonie Matricwarnings to for 2016 and 2017 Round interior to the rear curt, EX XX and your answer two decimal om. XXX) Pricing 1558 2018 3011 $ leder clear vidurid yait en common stock tr 2018 2017. aand bar s beb.com, XX mo you who aper) Biyadan Commons 2018 2018 2017 Net Income $ 58,100 $ 50, 100 Dividends-Common 20,000 20,000 16,500 16,500 Dividends-Preferred Total Stockholders' Equity at Year-End (includes 80,000 shares of common stock) Preferred Stock 770,000 580,000 190,000 190,000 Market Price per Share of Common Stock $ 18.50 $ 12.00