Required
-
Compute the accounts receivable turnover for 2018.
-
Compute the inventory turnover for 2018.
-
Compute the net margin for 2017.
Homework Answers
| a. | Account Receivable turnover for 2018 | 6.28 | times | Net sales / Net Account Receivable |
| b. | Inventory turnover for 2018 | 5.08 | times | Net sales / Total Inventory |
| c. | Net margin for 2017 | 19.34 | % | Net margin / Net sales |
| Particulars | 2018 | 2017 | ||
| Net credit sales | $ 2,018,000.00 | $ 1,754,000.00 | ||
| Net cash sales | $ 410,000.00 | $ 313,000.00 | ||
| Net sales | $ 2,428,000.00 | $ 2,067,000.00 | ||
| Cost of goods sold | $ 1,600,000.00 | $ 1,430,000.00 | ||
| Selling, general & administrative Exp. | $ 239,600.00 | $ 214,500.00 | ||
| Other expenses | $ 39,100.00 | $ 22,800.00 | ||
| Total Operating expenses | $ 1,878,700.00 | $ 1,667,300.00 | ||
| Net Margin | $ 549,300.00 | $ 399,700.00 |
Add Answer to:
Required
Compute the accounts receivable turnover for 2018.
Compute the inventory turnover for 2018.
Compute the...
Selected data from Emporia Company follow Balance Sheets As of December 31 2017 2018 $600,000 (40,000)...
Selected data from Emporia Company follow Balance Sheets As of December 31 2017 2018 $600,000 (40,000) $480,000 Accounts receivable Allowance for doubtful accounts (20,000) $460,000 Net accounts receivable $560,000 Inventories, lower of cost or market $500,000 $400,000 Income Statement For the Years Ended December 31 2018 2017 Net credit sales Net cash sales $2,400,000 600,e00 $1,950,000 450,000 Net sales 3,000,000 2,400,000 Cost of goods sold Selling, general, and administrative expenses Other expenses 1,800,000 300,000 80,000 1,520,e00 240,000 se,000 Total operating...
Selected data of Islander Company follow: Balance Sheet Data Accounts receivable Allowance for doubtful accounts Net...
Selected data of Islander Company follow: Balance Sheet Data Accounts receivable Allowance for doubtful accounts Net accounts receivable Inventories-lower of cost or market As of December 31, 2017 2016 $500,000 $470,000 (25,000) (20,000) 475,000 450,000 600,000 550,000 Income Statement Data Net credit sales Net cash sales Net sales Cost of goods sold Selling, general, and administrative expenses Other Total operating expenses Year Ended December 31, 2017 2016 $2,500,000 $2,200,000 500,000 400,000 3,000,000 2,600,000 2,000,000 1,800,000 300,000 270,000 50,000 30,000 2,350,000...
Cash Accounts receivable (net) Inventory Accounts payable Notes payable Common stock, $100 par Retained earnings December...
Cash Accounts receivable (net) Inventory Accounts payable Notes payable Common stock, $100 par Retained earnings December 31, 2017 $ 34,000 77,000 210,000 54,000 29,000 417,000 106,000 December 31, 2016 $ 16,500 122,500 183,000 92,500 65,000 417,000 102,500 Additional information: 1. The inventory turnover is 2.2 times. 2. The return on common stockholders' equity is 25%. The company had no additional paid-in capital. 3. The accounts receivable turnover is 8.1 times. 4. The return on assets is 12.5%. 5. Total assets...
CULLUMBER COMPANY Balance Sheets December 31 Assets Cash Debt investments (short-term) Accounts receivable Inventory Prepaid expenses Land Building and equipment (net) Total assets Liabilities...
CULLUMBER COMPANY Balance Sheets December 31 Assets Cash Debt investments (short-term) Accounts receivable Inventory Prepaid expenses Land Building and equipment (net) Total assets Liabilities and Stockholders' Equity Notes payable Accounts payable Accrued liabilities Bonds payable, due 2017 Common stock, $10 par Retained earnings 2017 2016 69,000 69,000 41,000 103,000 92,000 239,000 164,000 25,000 29,000 132,000 132,000 263,000 188,000 $884,000 $715,000 53,000 $170,000 $101,000 66,000 54,000 42,000 251,000 170,000 205,000 205,000 150,000 143,000 Total liabilities and stockholders' equity $884,000 $715,000 42,000...
2017 2016 Cash Accounts receivable (net) Inventory Land Buildings Accumulated depreciation-buildings $3,200 23,300 7,200 26,400 70,000...
2017 2016 Cash Accounts receivable (net) Inventory Land Buildings Accumulated depreciation-buildings $3,200 23,300 7,200 26,400 70,000 (14,600) (10,600) $110,300$119,500 $12,70031,100 68,600 19,800 $110,300$119,500 $ 4,500 20,800 10,100 19,500 70,000 Total Accounts payable Common stock Retained earnings 74,900 22,700 Total Wiemers's 2017 income statement included net sales of $110,000, cost of goods sold of $60,800, and net income of $15,000 Compute the following ratios for 2017. (Round answers to 2 decimal places, e.g. 1.65, or 1.65% .) Current ratio Acid-test ratio...
Assets 2017 2018 2018 Current assets Cash Accounts receivable Inventory $ 24,236 14,348 27,892 $ 26,000...
Assets 2017 2018 2018 Current assets Cash Accounts receivable Inventory $ 24,236 14,348 27,892 $ 26,000 17,100 29.000 $ 72,100 Liabilities and Owners' Equity 2017 Current liabilities Accounts payable $ 25,084 Notes payable 19,000 Other 13,471 $ 29,000 12,700 18,300 Total $ 66,476 Total $ 57,555 $ 60,000 $ 87,698 Long-term debt $ 88,000 S 45.000 Owners' equity Common stock and paid-in surplus Accumulated retained earnings $ 45,000 219,616 244,302 Fixed assets Net plant and equipment $343,695 $364 900 Total...
Exercise 17-8 Liquidity analysis and interpretation LO P3 [The following information applies to the questions displayed...
Exercise 17-8 Liquidity analysis and interpretation LO P3 [The following information applies to the questions displayed below.j Simon Company's year-end balance sheets follovw At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets 2017 $ 31,800 35,625 $37,800 50,200 54,000 5,000 278, 500 255,000 230,500 $523,000 $445,000 377,500 89,500 62,500 112,500 82,500 9,375 10,700 Liabilities and Equity Accounts payable Long-term notes payable secured by $129,900 75,250 $ 51,250 mortgages on plant assets Common...
Compute Wainwright Company's (a) accounts receivable turnover and (b) average collection period in days.
In 2014, Wainwright Company has net credit sales of $1,300,000 for the year. It had a beginning accounts receivable (net) balance of $101,000 and an ending accounts receivable (net) balance of $107,000. Compute Wainwright Company's (a) accounts receivable turnover and (b) average collection period in days.
December 31, Balance Sheet Data 2017 $ 84,000 2018 $ 78,000 Trade accounts receivable-net Inventory 150,000...
December 31, Balance Sheet Data 2017 $ 84,000 2018 $ 78,000 Trade accounts receivable-net Inventory 150,000 (95,000) 140,000 (98,000) Accounts payable-merchandise (credit) Total sales for 2018 were $1,200,000 and for 2017 were $1,100,000. Cash sales were 20% of total sales each year. Cost of goods sold was $840,000 for 2018. .Variable general and administrative (G&A) expenses for 2018 were $120,000. These expenses are the same proportion of sales every year and have been paid at the rate of 50% in...
Selected data from Franklin Company follow: Balance Sheets As of December 31 2018 2017 Accounts receivable...
Selected data from Franklin Company follow: Balance Sheets As of December 31 2018 2017 Accounts receivable Allowance for doubtful accounts Net accounts receivable Inventories, lower of cost or market $404,000 $379,000 (20,200)(15,160) $383,800 $363,840 $476,000 $435,000 Income Statement For the Years Ended December 31 2018 2017 Net credit sales Net cash sales Net sales $2,007,000 $1,752,000 415,000 309,00 Cost of goods sold Selling, general, and administrative expenses Other expenses 2,422,000 1,606,000 2,061,000 1,432,000 214,600 239,900 40,80022,500 Total operating expenses $1,886,700...
Selected data from Emporia Company follow Balance Sheets As of December 31 2017 2018 $600,000 (40,000) $480,000 Accounts receivable Allowance for doubtful accounts (20,000) $460,000 Net accounts receivable $560,000 Inventories, lower of cost or market $500,000 $400,000 Income Statement For the Years Ended December 31 2018 2017 Net credit sales Net cash sales $2,400,000 600,e00 $1,950,000 450,000 Net sales 3,000,000 2,400,000 Cost of goods sold Selling, general, and administrative expenses Other expenses 1,800,000 300,000 80,000 1,520,e00 240,000 se,000 Total operating...
Selected data of Islander Company follow: Balance Sheet Data Accounts receivable Allowance for doubtful accounts Net accounts receivable Inventories-lower of cost or market As of December 31, 2017 2016 $500,000 $470,000 (25,000) (20,000) 475,000 450,000 600,000 550,000 Income Statement Data Net credit sales Net cash sales Net sales Cost of goods sold Selling, general, and administrative expenses Other Total operating expenses Year Ended December 31, 2017 2016 $2,500,000 $2,200,000 500,000 400,000 3,000,000 2,600,000 2,000,000 1,800,000 300,000 270,000 50,000 30,000 2,350,000...
Cash Accounts receivable (net) Inventory Accounts payable Notes payable Common stock, $100 par Retained earnings December 31, 2017 $ 34,000 77,000 210,000 54,000 29,000 417,000 106,000 December 31, 2016 $ 16,500 122,500 183,000 92,500 65,000 417,000 102,500 Additional information: 1. The inventory turnover is 2.2 times. 2. The return on common stockholders' equity is 25%. The company had no additional paid-in capital. 3. The accounts receivable turnover is 8.1 times. 4. The return on assets is 12.5%. 5. Total assets...
CULLUMBER COMPANY Balance Sheets December 31 Assets Cash Debt investments (short-term) Accounts receivable Inventory Prepaid expenses Land Building and equipment (net) Total assets Liabilities and Stockholders' Equity Notes payable Accounts payable Accrued liabilities Bonds payable, due 2017 Common stock, $10 par Retained earnings 2017 2016 69,000 69,000 41,000 103,000 92,000 239,000 164,000 25,000 29,000 132,000 132,000 263,000 188,000 $884,000 $715,000 53,000 $170,000 $101,000 66,000 54,000 42,000 251,000 170,000 205,000 205,000 150,000 143,000 Total liabilities and stockholders' equity $884,000 $715,000 42,000...
2017 2016 Cash Accounts receivable (net) Inventory Land Buildings Accumulated depreciation-buildings $3,200 23,300 7,200 26,400 70,000 (14,600) (10,600) $110,300$119,500 $12,70031,100 68,600 19,800 $110,300$119,500 $ 4,500 20,800 10,100 19,500 70,000 Total Accounts payable Common stock Retained earnings 74,900 22,700 Total Wiemers's 2017 income statement included net sales of $110,000, cost of goods sold of $60,800, and net income of $15,000 Compute the following ratios for 2017. (Round answers to 2 decimal places, e.g. 1.65, or 1.65% .) Current ratio Acid-test ratio...
Assets 2017 2018 2018 Current assets Cash Accounts receivable Inventory $ 24,236 14,348 27,892 $ 26,000 17,100 29.000 $ 72,100 Liabilities and Owners' Equity 2017 Current liabilities Accounts payable $ 25,084 Notes payable 19,000 Other 13,471 $ 29,000 12,700 18,300 Total $ 66,476 Total $ 57,555 $ 60,000 $ 87,698 Long-term debt $ 88,000 S 45.000 Owners' equity Common stock and paid-in surplus Accumulated retained earnings $ 45,000 219,616 244,302 Fixed assets Net plant and equipment $343,695 $364 900 Total...
Exercise 17-8 Liquidity analysis and interpretation LO P3 [The following information applies to the questions displayed below.j Simon Company's year-end balance sheets follovw At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets 2017 $ 31,800 35,625 $37,800 50,200 54,000 5,000 278, 500 255,000 230,500 $523,000 $445,000 377,500 89,500 62,500 112,500 82,500 9,375 10,700 Liabilities and Equity Accounts payable Long-term notes payable secured by $129,900 75,250 $ 51,250 mortgages on plant assets Common...
December 31, Balance Sheet Data 2017 $ 84,000 2018 $ 78,000 Trade accounts receivable-net Inventory 150,000 (95,000) 140,000 (98,000) Accounts payable-merchandise (credit) Total sales for 2018 were $1,200,000 and for 2017 were $1,100,000. Cash sales were 20% of total sales each year. Cost of goods sold was $840,000 for 2018. .Variable general and administrative (G&A) expenses for 2018 were $120,000. These expenses are the same proportion of sales every year and have been paid at the rate of 50% in...
Selected data from Franklin Company follow: Balance Sheets As of December 31 2018 2017 Accounts receivable Allowance for doubtful accounts Net accounts receivable Inventories, lower of cost or market $404,000 $379,000 (20,200)(15,160) $383,800 $363,840 $476,000 $435,000 Income Statement For the Years Ended December 31 2018 2017 Net credit sales Net cash sales Net sales $2,007,000 $1,752,000 415,000 309,00 Cost of goods sold Selling, general, and administrative expenses Other expenses 2,422,000 1,606,000 2,061,000 1,432,000 214,600 239,900 40,80022,500 Total operating expenses $1,886,700...
Most questions answered within 3 hours.
-
For a 2-Level design, with 8 factors, a recommended screening
design model is:
a. Taguchi L12...
asked 29 minutes ago -
1. Define a function in python that returns the sum of the
following 4 lists. Remember...
asked 20 minutes ago -
Elspeth, associate research specialist for a marketing research
firm in a large Midwestern city, had just...
asked 20 minutes ago -
If domestic savings are insufficient to finance domestic private
investment and exports are greater than imports,...
asked 35 minutes ago -
Q.4.
Use the format in Exhibit 9-1 to compute the ending LIFO
inventory and cost of...
asked 41 minutes ago -
Discuss the different receiving and dispatch equipment required
for uploading and loading different types of material...
asked 46 minutes ago -
Which of the following is true for simultaneous testing?
a. Net specificity is greater than the...
asked 49 minutes ago -
Discuss the importance of homologous recombination and
transposition in natural horizontal gene transfer and evolution. Be...
asked 54 minutes ago -
Brittle material has the properties Sut = 30 kpsi and Suc = 90
kpsi. Using the...
asked 52 minutes ago -
*
write about Plastic recycling statistics ( Plastic recycling rate )
last two years , i...
asked 52 minutes ago -
The activation energy for a given reaction is 50.3 kJ/mol. If
the rate constant for the...
asked 1 hour ago -
An entomologist discovers a dung beetle rolling a ball of dung
along the ground, and decides...
asked 3 hours ago