In: Accounting
| Your answer is partially correct. Try again. | |
The condensed financial statements of Sheridan Company for the years 2016 and 2017 are presented as follows. (Amounts in thousands.)
| 
 SHERIDAN COMPANY  | 
||||
| 
 2017  | 
 2016  | 
|||
| Current assets | ||||
| Cash and cash equivalents | 
 $330  | 
 $360  | 
||
| Accounts receivable (net) | 
 660  | 
 590  | 
||
| Inventory | 
 660  | 
 590  | 
||
| Prepaid expenses | 
 120  | 
 160  | 
||
| Total current assets | 
 1,770  | 
 1,700  | 
||
| Investments | 
 200  | 
 200  | 
||
| Property, plant, and equipment (net) | 
 420  | 
 380  | 
||
| Intangibles and other assets | 
 530  | 
 510  | 
||
| Total assets | 
 $2,920  | 
 $2,790  | 
||
| Current liabilities | 
 $1,090  | 
 $980  | 
||
| Long-term liabilities | 
 610  | 
 580  | 
||
| Stockholders’ equity—common | 
 1,220  | 
 1,230  | 
||
| Total liabilities and stockholders’ equity | 
 $2,920  | 
 $2,790  | 
||
| 
 SHERIDAN COMPANY  | 
||||
| 
 2017  | 
 2016  | 
|||
| Sales revenue | 
 $4,000  | 
 $3,660  | 
||
| Costs and expenses | ||||
| Cost of goods sold | 
 1,145  | 
 1,080  | 
||
| Selling & administrative expenses | 
 2,400  | 
 2,330  | 
||
| Interest expense | 
 25  | 
 20  | 
||
| Total costs and expenses | 
 3,570  | 
 3,430  | 
||
| Income before income taxes | 
 430  | 
 230  | 
||
| Income tax expense | 
 129  | 
 69  | 
||
| Net income | 
 $ 301  | 
 $ 161  | 
||
Compute the following ratios for 2017 and 2016. (Round
current ratio and inventory turnover to 2 decimal places, e.g. 1.83
and all other answers to 1 decimal place, e.g. 1.8 or
12.6%.)
| (a) | Current ratio. | |
| (b) | Inventory turnover. (Inventory on 12/31/15 was $410.) | |
| (c) | Profit margin. | |
| (d) | Return on assets. (Assets on 12/31/15 were $2,230.) | |
| (e) | Return on common stockholders’ equity. (Stockholders’ equity on 12/31/15 was $980.) | |
| (f) | Debt to assets ratio. | |
| (g) | Times interest earned. | 
| 
 2017  | 
 2016  | 
|||||
| Current ratio. | :1 | :1 | ||||
| Inventory turnover. | times | times | ||||
| Profit margin. | % | % | ||||
| Return on assets. | % | % | ||||
| Return on common stockholders’ equity. | % | % | ||||
| Debt to assets ratio. | % | % | ||||
| Times interest earned. | times | times | ||||
Answer :-
a. Current Ratio = Current assets/ Current liabilities
For 2017 = $1,770 / $1,090 = 1.62
For 2016 = $1,700 / $980 = 1.73
b. Inventory Turnover = Cost of goods sold / Average inventory
For 2017 = $1,145 / ($660+$590)/2 = 1.832
For 2016 = $1,080 / ($590+$410)/2 = 2.16
c. Profit Margin = Net Income / Sales
For 2017 = $301/$4,000 = 7.525%
For 2016 = $161 / $3,660 = 4.39%
d. Return on assets = Net income / Average total assets
For 2017 = $301/($2,920+$2,790)/2 = 10.54%
For 2016 = $161/($2,790+$2,230)/2 = 6.41%
e. Return on common stockholders' equity = Net Income / Average common stockholders equity
For 2017 = $301 / ($1,220 + $1,230)/2 = 24.57%
For 2016 = $161 / ($1,230 + $980)/2 = 14.57%
f. Debt to assets ratio = Total Debt / Total assets
For 2017 = $1,700 / $2,920 = 58.21%
For 2016 = $1,560 / $2,790 = 55.91%
g. Times Interest earned = EBIT / Interest expense
For 2017 = $455 / $25 = 18.2
For 2016 = $250 / $20 = 12.5
If you have any query feel free to ask in comment section. Thanks