NOT SURE HOW TO SOLVE THIS. Instructions are unclear please help.
A B D E F. 1 Company In Thousands or Millions Year Ended 2 | Liquidity Ratios Numerator Denominator Ratio 11 7 Inventory turnover COGS / 2 year average Inventory of finished goods #DIV/0! 12 8 Fixed assets turnover Sales / Fixed assets (2 year average) #DIV/0! 13 9 Total assets turnover Sales / Total assets #DIV/0! 14 10 Accounts receivables turnover Annual Credit sales laverage 2 year net accounts receivable #DIV/0! 15 11 Average collection period/DSO Average 2 year Net Accounts Receivable / Total credit sales/365 days #DIV/0! 16 12 Income per employee Net income / total number of employees #DIV/0! 17 13 Revenue per employee Total revenue / total number of employees #DIV/0! 18 IV Profitability Ratios 19 14 Gross Profit Margin Sales minus COGS / sales*100 #DIV/0! 2015 Operating Profit Margin Income before interest and taxes EBITA / Sales #DIV/0! 21 16 Net Profit Margin Net income / Sales *100 #DIV/0! 22 17 Return ot total assets (ROA) Net income / total assets *100 #DIV/0! 23 18 Return on stockholders' equity (ROE Net income / shareholders' equity *100 #DIV/0! 24 19 Earnings per share (EPS) Net income / Number of shares of common stock outstanding #DIV/0! 25 20 Price earnings ratio Market price per share / Earnings per share #DIV/0! 26 V Growth (Current over Previous Year) 27 21 Sales Current Period Net Sales - Prior Period Net Sales / Prior Period Net Sales * 100 #DIV/0! 28 22 Net Income Current Period Net Income - Prior Period Net Income / Prior Period Net Income * 100 #DIV/0! 29 23 Earnings per share Current Period EPS - Prior Period EPS / Prior Period EPS * 100 #DIV/0! 30 24 Dividends per share Current Period DPS - Prior Period DPS / Prior Period DPS * 100 #DIV/0! 31 If annual credit sales are not provided assume all sales are credit. 32 You must sync your numbers. Remember that #employees are actual and net income and revenue numbers are stated in thousands (000) or millions of dollars (000000) Be careful on *100 equations. The times 100 is built into the final column formula. All it does is converts your product into % 34 33 A B D E F. 1 Company In Thousands or Millions Year Ended 2 | Liquidity Ratios Numerator Denominator Ratio 11 7 Inventory turnover COGS / 2 year average Inventory of finished goods #DIV/0! 12 8 Fixed assets turnover Sales / Fixed assets (2 year average) #DIV/0! 13 9 Total assets turnover Sales / Total assets #DIV/0! 14 10 Accounts receivables turnover Annual Credit sales laverage 2 year net accounts receivable #DIV/0! 15 11 Average collection period/DSO Average 2 year Net Accounts Receivable / Total credit sales/365 days #DIV/0! 16 12 Income per employee Net income / total number of employees #DIV/0! 17 13 Revenue per employee Total revenue / total number of employees #DIV/0! 18 IV Profitability Ratios 19 14 Gross Profit Margin Sales minus COGS / sales*100 #DIV/0! 2015 Operating Profit Margin Income before interest and taxes EBITA / Sales #DIV/0! 21 16 Net Profit Margin Net income / Sales *100 #DIV/0! 22 17 Return ot total assets (ROA) Net income / total assets *100 #DIV/0! 23 18 Return on stockholders' equity (ROE Net income / shareholders' equity *100 #DIV/0! 24 19 Earnings per share (EPS) Net income / Number of shares of common stock outstanding #DIV/0! 25 20 Price earnings ratio Market price per share / Earnings per share #DIV/0! 26 V Growth (Current over Previous Year) 27 21 Sales Current Period Net Sales - Prior Period Net Sales / Prior Period Net Sales * 100 #DIV/0! 28 22 Net Income Current Period Net Income - Prior Period Net Income / Prior Period Net Income * 100 #DIV/0! 29 23 Earnings per share Current Period EPS - Prior Period EPS / Prior Period EPS * 100 #DIV/0! 30 24 Dividends per share Current Period DPS - Prior Period DPS / Prior Period DPS * 100 #DIV/0! 31 If annual credit sales are not provided assume all sales are credit. 32 You must sync your numbers. Remember that #employees are actual and net income and revenue numbers are stated in thousands (000) or millions of dollars (000000) Be careful on *100 equations. The times 100 is built into the final column formula. All it does is converts your product into % 34 33
