Question

In: Accounting

The following data is given: December 31, 2018 2017 Cash $66,500 $49,500 Accounts receivable (net) 90,000...

The following data is given:

December 31, 2018 2017

Cash $66,500 $49,500

Accounts receivable (net) 90,000 59,000

Inventories 90,000 105,000

Plant assets (net) 382,500 324,000

Accounts payable 55,500 39,500

Salaries and wages payable 12,000 5,500

Bonds payable 68,500 72,000 8%

Preferred stock, $40 par 100,000 100,000

Common stock, $10 par 120,000 90,000

Paid-in capital in excess of par 75,000 70,000

Retained earnings 198,000 160,500

Net credit sales 995,000

Cost of goods sold 740,000

Net income 82,000

Compute the following ratios:

(a) Acid-test ratio at 12/31/18 : 1
(b) Accounts receivable turnover in 2018 times
(c) Inventory turnover in 2018 times
(d) Profit margin on sales in 2018 %
(e) Return on common stock holders’ equity in 2018 %
(f) Book value per share of common stock at 12/31/18 $

Solutions

Expert Solution

The ratios are calculated below:

a) Acid-test ratio = Quick Assets / Current Liability

= (Cash + Accounts receivable ) / (Accounts payable + Salaries and wages payable)

= ($66,500 + $90,000 ) / ($55,500 + $12,000 )

= $156,500 / $67,500

Acid-test ratio = 2.32 : 1

b) Accounts receivable turnover in 2018 is calculated below:

Accounts receivable turnover = Net Credit Sale / Average Account Receivable

Average Account Receivable = (Begining Average Account Receivable + Ending Average Account Receivable)/2

= $59,000 + $90,000 / 2

=$74,500

Accounts receivable turnover = $995,000 /  $74,500

= 13.36 Times

(c) Inventory turnover in 2018 is calculated below:

  Inventory turnover = Cost of Goods Sold / Average Inventory

Average Inventory  = (Begining Inventory  + Ending Average Inventory )/2

Inventory turnover = ($90,000 + $105,000) / 2

= $97,500

Inventory turnover = $740,000 / $97,500

= 7.59 times

(d) Profit Margin on sales in 2018 is calculated below:

Profit Margin on sales = Net Income / Net Sale *100

= $82,000/  $995,000 *100

= 8.24%

Profit Margin on sales in 2018 is 8.24%

(e)Return on common stock holders’ equity in 2018 is calculated below:

Return on common stock holders’ equity

= (Net Income - Prefrence Dividend ) / Average common stock holders’ equity * 100

Average common stock holders’ equity = ($90,000 + $70,000 +$160,500) + $120,000 + $75,000 + $198,000 )/2

=($320,500 + $393,000) / 2

= $356,750

Return on common stock holders’ equity = ($82,000 - $0) / $356,750 *100

= $82,000 / $356,750 *100

= 22.99%

(f)Book value per share of common stock at 12/31/18 is calculated below:

Book value per share of common stock = Stockholder's Equity - Preferred Stock / Average Shares Outstanding

Begining Shares = $90,000 / $10 = 9,000 shares

Ending Shares = $120,000 / $10 = 12,000 shares

Average Shares Outstanding = 9,000 + 12,000 / 2

= 10,500 Shares

Book value per share of common stock = ($100,000 + $120,000 + $75,000 + $198,000) - $100,000 /10,500 Shares

= $493,000 - $100,000 /10,500 Shares

= $393,000 / 10,500

   = $37.43

Book value per share of common stock = $37.43

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Selected financial data from Barrymore Co. are As of December 31 Cash $75,000 Accounts receivable (net)...
Selected financial data from Barrymore Co. are As of December 31 Cash $75,000 Accounts receivable (net) 225,000 Merchandise inventory 270,000 Trading securities (current) 40,000 Land and building (net) 500,000 Mortgage payable-current portion 30,000 Accounts payable and accrued liabilities 2,000 Short-term notes payable 50,000 Year Ended December 31 Sales $1,500,000 Cost of goods sold 900,000 Barrymore’s quick (acid-test) ratio as of December 31 is
An aging analysis of Yamoto Limited’s accounts receivable at December 31, 2018 and 2017, showed the...
An aging analysis of Yamoto Limited’s accounts receivable at December 31, 2018 and 2017, showed the following: Number of Days Outstanding Accounts Receivable Estimated Percentage Uncollectible 2018 2017 0-30 days $300,000 $320,000 3% 31-61 days 64,000 114,000 6% 61-90 days 86,000 76,000 12% Over 90 days 130,000 50,000 24% Total $580,000 $560,000 Additional information: 1. At December 31, 2017, the unadjusted balance in Allowance for Doubtful Accounts was a credit of $9,000. 2. In 2018, $42,000 of accounts were written...
An aging analysis of Yamoto Limited’s accounts receivable at December 31, 2018 and 2017, showed the...
An aging analysis of Yamoto Limited’s accounts receivable at December 31, 2018 and 2017, showed the following: Number of Days Outstanding Accounts Receivable Estimated Percentage Uncollectible 2018 2017 0-30 days $300,000 $320,000 3% 31-61 days 64,000 114,000 6% 61-90 days 86,000 76,000 12% Over 90 days 130,000 50,000 24% Total $580,000 $560,000 Additional information: 1. At December 31, 2017, the unadjusted balance in Allowance for Doubtful Accounts was a credit of $9,000. 2. In 2018, $42,000 of accounts were written...
Given the following Financial Information Answer the following question: 2017 2018 Cash 2,000 189,100 Accounts Receivable...
Given the following Financial Information Answer the following question: 2017 2018 Cash 2,000 189,100 Accounts Receivable 2,000 2,020 Inventory 8,000 8,080 Prepaid Assets 3,000 3,030 Other Assets 4,000 4,040 Total Current Assets 19,000 206,270 Net PPE 20,000 4,000 Intangibles 10,000 10,000 Total Assets 49,000 220,270 Accounts Payable 8,000 8,080 Salary Payable 6,000 6,060 Notes Payable 3,000 3,000 Total Current Liabilities 17,000 17,140 Long-Term Debt 40,000 40,000 Total Liabilities 57,000 57,140 Common Stock 80,000 80,000 Retained Earnings -88,000 83,130 total equity...
Boca Inc. Balance Sheets December 31 Assets 2018 2017 Cash 110,800 48,400 Accounts Receivable 38,000 87,800...
Boca Inc. Balance Sheets December 31 Assets 2018 2017 Cash 110,800 48,400 Accounts Receivable 38,000 87,800 Inventory 112,500 102,850 Prepaid Expenses 26,000 28,400 Long-term Investments 109,000 138,000 Plant Assets 397,000 242,500 Accumulated depreciation -50,000 -52,000 Total 743,300 595,950 Liabilities and Stockholders' Equity Accounts Payable 72,000 67,300 Accrued Expenses Payable 13,500 21,000 Dividends Payable 3,000          - Bonds Payable 170,000 146,000 Common Stock 262,000 175,000 Retained Earnings 222,800 186,650 Total 743,300 595,950 Additional Information: 1. Old plant assets having an original...
Boca Inc. Balance Sheets December 31 Assets 2018 2017 Cash 60,800 48,400 Accounts Receivable 87,800 38,000...
Boca Inc. Balance Sheets December 31 Assets 2018 2017 Cash 60,800 48,400 Accounts Receivable 87,800 38,000 Inventory 102,850 112,500 Prepaid Expenses 28,400 26,000 Long-term Investments 138,000 109,000 Plant Assets 347,000 242,500 Accumulated depreciation (50,000) (52,000) Total 714,850 524,400 Liabilities and Stockholders' Equity Accounts Payable 67,300 72,000 Accrued Expenses Payable 21,000 13,500 Dividends Payable 3,000 - Bonds Payable 170,000 146,000 Common Stock 262,000 175,000 Retained Earnings 191,550 117,900 Total 714,850 524,400 Additional Information: 1. Old plant assets having an original cost...
SMC, Inc. Balance Sheet December 31, 2017 Assets Cash ......................................................................................................... $34,500 Accounts receivable ...................................................................
SMC, Inc. Balance Sheet December 31, 2017 Assets Cash ......................................................................................................... $34,500 Accounts receivable ................................................................................ 25,000 Inventory .................................................................................................. 10,000 Supplies ................................................................................................... 200 Total assets.............................................................................................. $69,700 Liabilities and Stockholders’ Equity Liabilities: Accounts payable ............................................................................. $12,000 Salaries payable ............................................................................... 1,000 Income taxes payable ...................................................................... 3,675 Total liabilities.......................................................................................... $16,675 Stockholders’ equity: Capital stock (10,000 shares outstanding).................................... $25,000 Retained earnings ............................................................................ 28,025 Total stockholders’ equity ....................................................................... 53,025 Total liabilities and stockholders’ equity................................................ $69,700 SMC, Inc. Income Statement For the Year Ended December31,2017 Sales revenue .............................................................................................
2017 2018 Accounts payable 800 740 Accounts receivable, net 1,850 2,150 Accruals 70 160 Cash ???...
2017 2018 Accounts payable 800 740 Accounts receivable, net 1,850 2,150 Accruals 70 160 Cash ??? ??? Capital surplus 1,250 1,360 Common stock 1,020 1,210 Cost of goods sold 7,340 7,580 Depreciation expense 1,610 1,720 Interest expense 220 190 Inventory (end of year) 5,360 5,240 Long-term debt 6,310 6,450 Net fixed assets 8,240 9,120 Net sales 12,850 13,950 Notes payable 840 750 Operating expenses (excluding depreciation) 2,240 2,430 Retained earnings 8,300 8,460 Taxes 340 450 This company’s operating profit margin...
0 June 2017 30 June 2018 Cash 20,000 91,000 Accounts receivable 65,000 90,000 Inventories 58,000 62,000...
0 June 2017 30 June 2018 Cash 20,000 91,000 Accounts receivable 65,000 90,000 Inventories 58,000 62,000 Prepayments 10,000 12,000 Land 80,000 90,000 Equipment 280,000 320,000 Accumulated depreciation (60,000) (92,000) 453,000 573,000 Accounts payable 45,000 48,000 Loans 160,000 200,000 Share capital 200,000 230,000 Retained earnings 48,000 95,000 453,000 573,000 Additional information There were no disposals of land or equipment during the year. A $30,000 loan was settled through the issue of ordinary shares. There were no other repayments of loans. Profit...
ABC reports the following accounts and balances at December 31, 2017: Accounts Payable                     $22,800 Accounts Receivable   &nb
ABC reports the following accounts and balances at December 31, 2017: Accounts Payable                     $22,800 Accounts Receivable                  18,800 Cash                                           24,400 Land                                           82,400 Machine                                   129,200 Merchandise Inventory              63,600 Long-term Note Payable            79,200 Short-term Note Payable            14,400 Paid-in Capital                         200,000 Retained Earnings                             ? Sales Revenue                          122,000 Cost of Goods Sold                     80,000 Operating Expenses                   40,000 Required: Prepare a balance sheet at December 31, 2017 Also, prepare an income statement for the year ended December 31, 2017. Ignore depreciation expense and interest expense.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT