Question

In: Finance

The condensed financial statements of Murawski Company for the years 2016 and 2017 are presented below. (Amounts in thousands.)

The condensed financial statements of Murawski Company for the years 2016 and 2017 are presented below. (Amounts in thousands.)

MURAWSKI COMPANY Balance Sheets December 31 2017 2016 Current assets $ 330 $ 360 Cash and cash equivalents Accounts receivable (net) Inventory Prepaid expenses 470 400 460 390 120 160 Total current assets 1,380 1,310 Investments 10 10 Property, plant, and equipment Intangibles and other assets 420 380 530 510

 

 

Compute the following ratios for 2017 and 2016.

(a) Current ratio.

(b) Inventory turnover. (Inventory on 12/31/15 was $340.)

(c) Profit margin.

(d) Return on assets. (Assets on 12/31/15 were $1,900.)

(e) Return on common stockholders’ equity. (Stockholders’ equity on 12/31/15 was $900.)

(f) Debt to assets ratio.

(g) Times interest earned.

Solutions

Expert Solution

(a) Current ratio

Current ratio = Current Assets / Current Liabilities
 

2017

2016

Current ratio $1,380 / $900 = 1.53 : 1 $1,310 / $790 = 1.66 : 1

 

(b) Inventory turnover

Inventory turnover = Cost of goods sold / Average Inventories
 

2017

2016

Average Inventories ($390 + $460) / 2 = $425 ($340 + $390) / 2 = $365
Inventory turnover $955 / $425 = 2.25 times $890 / $365 = 2.44 times

 

(c) Profit Margin ratio

Profit margin ratio = Net Income / Sales revenue x 100
 

2017

2016

Profit margin ratio $294 / $3,800 x 100 = 7.7% $154 / $3,460 x 100 = 4.5%

 

(d) Return on assets

Return on assets = Net Income / Average total assets x 100
 

2017

2016

Average total assets ($2,210 + $2,340) / 2 = $2,275 ($1,900 + $2,210) / 2 = $2,055
Return on assets $294 / $2,275 x 100 = 12.9% $154 / $2,055 x 100 = 7.5%

 

(e) Return on common stockholder\'s equity

Return on common stockholders\' equity = Net Income / Average common stockholders\' equity x 100
 

2017

2016

Average common stockholders\' equity ($1,040 + $1,030) / 2 = $1,035 ($900 + $1,040) / 2 = $970
Return on common stockholders\' equity $294 / $1,035 x 100 = 28.4% $154 / $970 x 100 = 15.9%

 

(f) Debt to asset ratio

Debt to asset ratio = Total Liabilities / Total Assets x 100
 

2017

2016

Debt to asset ratio ($900 + $410) / $2,340 x 100 = 56.0% ($790 + $380) / $2,210 x 100 = 52.9%

 

(g) Times interest earned

Times Interest earned = (Income before income taxes + Interest expense) / Interest expense
 

2017

2016

Times Interest earned ($420 + $25) / $25 = 17.8 times ($220 + $20) / $20 = 12.0 times

(a) Current ratio

Current ratio = Current Assets / Current Liabilities
 

2017

2016

Current ratio $1,380 / $900 = 1.53 : 1 $1,310 / $790 = 1.66 : 1

Related Solutions

The condensed financial statements of Murawski Company for the years 2014 and 2015 are presented below....
The condensed financial statements of Murawski Company for the years 2014 and 2015 are presented below. MURAWSKI COMPANY Balance Sheets December 31 2015 2014 Current assets     Cash and cash equivalents $ 364 $ 367     Accounts receivable (net) 387 466     Inventory 373 446     Prepaid expenses 140 131       Total current assets 1,264 1,410 Property, plant, and equipment 363 434 Investments 11 11 Intangibles and other assets 530 545       Total assets $2,168 $2,400 Current liabilities $ 801 $ 881 Long-term liabilities 355 406...
The condensed financial statements of Ness Company for the years 2016 and 2017 are presented below....
The condensed financial statements of Ness Company for the years 2016 and 2017 are presented below. NESS COMPANY Balance Sheets December 31 (in thousands) 2017 2016 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 470 400 Inventory 460 390 Prepaid expenses 130 160 Total current assets 1,390 1,310 Property, plant, and equipment (net) 410 380 Investments 10 10 Intangibles and other assets 530 510 Total assets $2,340 $2,210 Current liabilities $820 $790 Long-term liabilities 480 380 Stockholders’...
The condensed financial statements of Sunland Company for the years 2016 and 2017 are presented as...
The condensed financial statements of Sunland Company for the years 2016 and 2017 are presented as follows. (Amounts in thousands.) SUNLAND COMPANY Balance Sheets December 31 2017 2016 Current assets    Cash and cash equivalents $330 $360    Accounts receivable (net) 490 420    Inventory 660 590    Prepaid expenses 120 160      Total current assets 1,600 1,530 Investments 30 30 Property, plant, and equipment (net) 420 380 Intangibles and other assets 530 510      Total assets $2,580 $2,450 Current liabilities $920 $810 Long-term liabilities 610...
The condensed financial statements of Murawski Company for the years 2019 and 2020 are presented follows....
The condensed financial statements of Murawski Company for the years 2019 and 2020 are presented follows. (Amounts in thousands.) MURAWSKI COMPANY Balance Sheets December 31 2020 2019 Current assets     Cash and cash equivalents $ 346 $ 370     Accounts receivable (net) 406 442     Inventory 392 470     Prepaid expenses 150 146       Total current assets 1,294 1,428 Investments 12 12 Property, plant, and equipment 390 418 Intangibles and other assets 502 528       Total assets $2,198 $2,386 Current liabilities $ 770 $ 900 Long-term...
The condensed financial statements of Murawski Company for the years 2019 and 2020 are presented follows....
The condensed financial statements of Murawski Company for the years 2019 and 2020 are presented follows. (Amounts in thousands.) MURAWSKI COMPANY Balance Sheets December 31 2020 2019 Current assets     Cash and cash equivalents $ 358 $ 353     Accounts receivable (net) 388 490     Inventory 388 474     Prepaid expenses 170 120       Total current assets 1,304 1,437 Investments 13 12 Property, plant, and equipment 390 418 Intangibles and other assets 492 526       Total assets $2,199 $2,393 Current liabilities $ 800 $ 884 Long-term...
The condensed financial statements of Underwood Company for the years 2017 and 2018 are presented as...
The condensed financial statements of Underwood Company for the years 2017 and 2018 are presented as follows. (Amounts in thousands.) UNDERWOOD COMPANY Balance Sheets December 31 2018 2017 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 470 400 Inventory 460 390 Prepaid expenses 120 160 Total current assets 1,380 1,310 Investments 10 10 Property, plant, and equipment 420 380 Intangibles and other assets 530 510 Total assets $2,340 $2,210 Current liabilities $900 $790 Long-term liabilities 410 380...
Do It! Review 14-3 The condensed financial statements of Murawski Company for the years 2019 and...
Do It! Review 14-3 The condensed financial statements of Murawski Company for the years 2019 and 2020 are presented follows. (Amounts in thousands.) MURAWSKI COMPANY Balance Sheets December 31 2020 2019 Current assets Cash and cash equivalents $ 370 $ 368 Accounts receivable (net) 414 468 Inventory 390 480 Prepaid expenses 166 140 Total current assets 1,340 1,456 Investments 14 10 Property, plant, and equipment 350 400 Intangibles and other assets 484 508 Total assets $2,188 $2,374 Current liabilities $...
Condensed financial data of Cullumber Company for 2017 and 2016 are presented below. CULLUMBER COMPANY COMPARATIVE...
Condensed financial data of Cullumber Company for 2017 and 2016 are presented below. CULLUMBER COMPANY COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2017 AND 2016 2017 2016 Cash $1,830 $1,130 Receivables 1,770 1,290 Inventory 1,620 1,920 Plant assets 1,940 1,680 Accumulated depreciation (1,190 ) (1,170 ) Long-term investments (held-to-maturity) 1,300 1,410 $7,270 $6,260 Accounts payable $1,220 $910 Accrued liabilities 210 260 Bonds payable 1,420 1,530 Common stock 1,890 1,710 Retained earnings 2,530 1,850 $7,270 $6,260 CULLUMBER COMPANY INCOME STATEMENT FOR...
Condensed financial data of Oriole Company for 2017 and 2016 are presented below. ORIOLE COMPANY COMPARATIVE...
Condensed financial data of Oriole Company for 2017 and 2016 are presented below. ORIOLE COMPANY COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2017 AND 2016 2017 2016 Cash $1,830 $1,180 Receivables 1,710 1,320 Inventory 1,590 1,920 Plant assets 1,890 1,710 Accumulated depreciation (1,220 ) (1,190 ) Long-term investments (held-to-maturity) 1,320 1,440 $7,120 $6,380 Accounts payable $1,190 $890 Accrued liabilities 210 260 Bonds payable 1,400 1,580 Common stock 1,940 1,660 Retained earnings 2,380 1,990 $7,120 $6,380 ORIOLE COMPANY INCOME STATEMENT FOR...
Condensed financial data of Waterway Company for 2017 and 2016 are presented below. WATERWAY COMPANY COMPARATIVE...
Condensed financial data of Waterway Company for 2017 and 2016 are presented below. WATERWAY COMPANY COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2017 AND 2016 2017 2016 Cash $1,780 $1,170 Receivables 1,760 1,280 Inventory 1,620 1,880 Plant assets 1,910 1,670 Accumulated depreciation (1,210 ) (1,160 ) Long-term investments (held-to-maturity) 1,330 1,440 $7,190 $6,280 Accounts payable $1,230 $920 Accrued liabilities 210 250 Bonds payable 1,370 1,560 Common stock 1,920 1,680 Retained earnings 2,460 1,870 $7,190 $6,280 WATERWAY COMPANY INCOME STATEMENT FOR...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT