XL Calculating market value ratios - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Arial 12 AA % Ee Paste BIU. A- Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font D16 AB D E F H I J K 1 2 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? 4 5 6 7 8 9 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 10 11 12 13 14 15 Complete the following analysis. Do not hard code values in your calculations. 16 Net income 17 18 Earnings per share 19 Sheet1 + READY 100% Attempt(s) 3/4 Show Me Calculating market value ratios - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Arial 12 AA % Paste BIU A Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font D16 AB F G H I J K 9 D E 170,000 $ 64 $ 5,150,000 Common shares outstanding Share price Sales 10 11 12 13 14 Complete the following analysis. Do not hard code values in your calculations. 15 Net income 16 17 18 19 Earnings per share 20 Dividends per share 21 22 Book value per share 23 24 Market-to-book ratio 25 Price-earnings ratio 26 27 28 Sales per share 29 Price-sales ratio 30 31 32 Sheet1 o READY T + 100% Attemnt/s) 314 Show Me