In: Accounting
Problem 18-2A
The comparative statements of Painter Tool Company are presented below.
| 
 PAINTER TOOL COMPANY  | 
||||||
| 
 2017  | 
 2016  | 
|||||
| Net sales | $1,810,600 | $1,746,200 | ||||
| Cost of goods sold | 1,012,200 | 984,000 | ||||
| Gross profit | 798,400 | 762,200 | ||||
| Selling and administrative expenses | 515,200 | 479,600 | ||||
| Income from operations | 283,200 | 282,600 | ||||
| Other expenses and losses | ||||||
| Interest expense | 17,300 | 13,300 | ||||
| Income before income taxes | 265,900 | 269,300 | ||||
| Income tax expense | 80,600 | 76,300 | ||||
| Net income | $ 185,300 | $ 193,000 | ||||
| 
 PAINTER TOOL COMPANY  | 
||||||
| 
 Assets  | 
 2017  | 
 2016  | 
||||
| Current assets | ||||||
| Cash | $59,500 | $63,100 | ||||
| Short-term investments | 68,200 | 49,800 | ||||
| Accounts receivable (net) | 117,100 | 102,100 | ||||
| Inventory | 124,000 | 114,400 | ||||
| Total current assets | 368,800 | 329,400 | ||||
| Plant assets (net) | 598,600 | 519,300 | ||||
| Total assets | $967,400 | $848,700 | ||||
| 
 Liabilities and Stockholders’ Equity  | 
||||||
| Current liabilities | ||||||
| Accounts payable | $159,200 | $144,800 | ||||
| Income taxes payable | 43,800 | 41,200 | ||||
| Total current liabilities | 203,000 | 186,000 | ||||
| Bonds payable | 201,600 | 201,600 | ||||
| Total liabilities | 404,600 | 387,600 | ||||
| Stockholders’ equity | ||||||
| Common stock ($5 par) | 278,300 | 299,200 | ||||
| Retained earnings | 284,500 | 161,900 | ||||
| Total stockholders’ equity | 562,800 | 461,100 | ||||
| Total liabilities and stockholders’ equity | $967,400 | $848,700 | ||||
All sales were on account.
Compute the following ratios for 2017. (Weighted-average common
shares in 2017 were 55,100.) (Round Earnings per share,
Current ratio and Acid-test ratio to 2 decimal places, e.g. 1.65 or
1.65:1, and all other answers to 1 decimal place, e.g. 6.8 or
6.8%.)
| (a) | Earnings per share | $ | |||
| (b) | Return on common stockholders’ equity | % | |||
| (c) | Return on assets | % | |||
| (d) | Current ratio | :1 | |||
| (e) | Acid-test ratio | :1 | |||
| (f) | Accounts receivable turnover | times | |||
| (g) | Inventory turnover | times | |||
| (h) | Times interest earned | times | |||
| (i) | Asset turnover | times | |||
| (j) | Debt to assets ratio | % | 
| a) | Earnings per share=Net income/Weighted-average common shares=185300/55100=3..36 | |||||
| b) | Return on common stockholder's equity=Net income/Average common stockholder's equity | |||||
| Average Common stockholder's equity=(Beginning Common stockholder's equity+Ending Common stockholder's equity)/2 | ||||||
| Average Common stockholder's equity=(461100+562800)/2=$ 511950 | ||||||
| Return on common stockholder's equity=185300/511950=0.3619=36.2% | ||||||
| c) | Return on assets=Net income/Average total assets | |||||
| Average total assets=(Beginning total assets+Ending total assets)/2=(848700+967400)/2=$ 908050 | ||||||
| Return on assets=185300/908050=0.2041=20.4% | ||||||
| d) | Current ratio=Current assets/Current liabilities=368800/203000=1.82 | |||||
| e) | Acid-test ratio=Quick assets/Current liabilities | |||||
| Quick assets=Current assets-Inventory=368800-124000=$ 244800 | ||||||
| Acid-test ratio=244800/203000=1.21 | ||||||
| f) | Accounts receivable turnover ratio=Net sales/Average accounts receivable | |||||
| Average accounts receivable=(Beginning accounts receivable+Ending accounts receivable)/2=(102100+117100)/2=$ 109600 | ||||||
| Accounts receivable turnover ratio=1810600/109600=16.5 times | ||||||
| g) | Inventory turnover=Cost of goods sold/average inventory | |||||
| Average inventory=(Beginning inventory+Ending inventory)/2=(114400+124000)/2=$ 119200 | ||||||
| Inventory turnover=1012200/119200=8.5 times | ||||||
| h) | Times interest earned=Earnings before interest and taxes (EBIT)/Interest expenses | |||||
| EBIT: | ||||||
| $ | ||||||
| Income before taxes | 265900 | |||||
| Add: Interest expenses | 17300 | |||||
| EBIT | 283200 | |||||
| Times interest earned=283200/17300=16.4 times | ||||||
| i) | Assets turnover=Net sales/Average total assets | |||||
| Average total assets=(Beginning total assets+Ending total assets)/2=(848700+967400)/2=$ 908050 | ||||||
| Total assets turnover=1810600/908050=2 times | ||||||
| j) | Debt to asset ratio=Total liabilities/Total assets=404600/967400=0.4182=41.8% | |||||