All answers must be entered as formulas (using cell names)

AB Makers Corp. had additions to retained earnings for the year just ended of $395,000. The firm paid out $195,000 in cash dividends, and it has ending total equity of $5.3 million. If the 3company currently has 170,000 shares of common stock outstanding, what are earnings per share? Dividends per share? Book value per share? If the stock currently sells for $64 per share, what is the market-to-book ratio? The price-earnings ratio? If the company had sales of $5.15 million, what is the price-sales ratio? 4 6 Addition to retained earnings 7Cash dividends 395,000 $195,000 $5,300,000 170,000 64 $5,150,000 8 Total equity 9 Common shares outstanding 10 Share price 1Sales 12 14 15 16 17 18 Complete the following analysis. Do not hard code values in your calculations. Net income Earnings per share AB 13 14 Complete the following analysis. Do not hard code values in your calculations. 15 16Net income 17 18Earnings per share 19 20Dividends per share 21 22Book value per share 23 24Market-to-book ratio 25 26Price-earnings ratio 27 28Sales per share 29 30 Price-sales ratio 31 32 34