ANSWER MUST BE IN EXCEL FORMULA FORMAT

H 3 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 company 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? Addition to retained earnings Cash dividends Total equity Common shares outstanding Share price Sales $ 395,000 $ 195,000 $ 5,300,000 170,000 64 $ 5,150,000 Complete the following analysis. Do not hard code values in your calculations. Net income Earnings per share Dividends per share Book value per share Market-to-book ratio Price-earnings ratio Sales per share Price-sales ratio