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