Question

In: Accounting

Required information [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets...

Required information

[The following information applies to the questions displayed below.]

Simon Company’s year-end balance sheets follow.

At December 31 2017 2016 2015
Assets
Cash $ 35,503 $ 41,499 $ 41,957
Accounts receivable, net 89,600 62,200 53,700
Merchandise inventory 110,500 84,000 52,000
Prepaid expenses 11,433 10,894 4,662
Plant assets, net

342,908

309,979 263,181
Total assets $ 589,944 $ 508,572 $ 415,500
Liabilities and Equity
Accounts payable $ 149,834 $ 87,668 $ 55,943
Long-term notes payable secured by
mortgages on plant assets
113,128 119,311 93,662
Common stock, $10 par value 162,500 162,500 162,500
Retained earnings 164,482 139,093 103,395
Total liabilities and equity $ 589,944 $ 508,572 $ 415,500


The company’s income statements for the years ended December 31, 2017 and 2016, follow. Assume that all sales are on credit:

For Year Ended December 31 2017 2016
Sales $ 766,927 $ 605,201
Cost of goods sold $ 467,825 $ 393,381
Other operating expenses 237,747 153,116
Interest expense 13,038 13,920
Income taxes 9,970 9,078
Total costs and expenses 728,580 569,495
Net income $ 38,347 $ 35,706
Earnings per share $ 2.36 $ 2.20

(1) Compute days' sales uncollected.

Days' Sales Uncollected
Choose Numerator: / Choose Denominator: x Days = Days' Sales Uncollected
/ x = Days' Sales Uncollected
2017: / x = 0 days
2016: / x = 0 days

(2) Compute accounts receivable turnover.

Accounts Receivable Turnover
Choose Numerator: / Choose Denominator: = Accounts Receivable Turnover
/ = Accounts receivable turnover
2017: / = times
2016: / = times

(3) Compute inventory turnover.

Inventory Turnover
Choose Numerator: / Choose Denominator: = Inventory Turnover
/ = Inventory turnover
2017: / = times
2016: / = times

(4) Compute days' sales in inventory.
  

Days’ Sales In Inventory
Choose Numerator: / Choose Denominator: x Days = Days’ Sales In Inventory
/ x = Days’ sales in inventory
2017: / x = 0 days
2016: / x = 0 days

Solutions

Expert Solution

1&4.

Calculate days' sales uncollected and days' sales in inventory as follows:

Above figures have been calculated in the following manner:

2&3

Calculate accounts receivable turnover and inventory turnover as follows:

Above figures have been calculated in the following manner:


Related Solutions

Required information [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets...
Required information [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 36,427 $ 42,580 $ 43,476 Accounts receivable, net 89,700 62,200 50,200 Merchandise inventory 113,500 84,500 59,000 Prepaid expenses 11,731 11,177 4,831 Plant assets, net 359,936 326,521 277,293 Total assets $ 611,294 $ 526,978 $ 434,800 Liabilities and Equity Accounts payable $ 153,734 $ 89,950 $ 57,968 Long-term notes payable...
Required information [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets...
Required information [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 32,717 $ 38,243 $ 38,665 Accounts receivable, net 89,800 62,300 50,400 Merchandise inventory 114,500 84,000 51,000 Prepaid expenses 10,536 10,039 4,296 Plant assets, net 296,104 274,088 238,539 Total assets $ 543,657 $ 468,670 $ 382,900 Liabilities and Equity Accounts payable $ 138,078 $ 80,789 $ 51,554 Long-term notes payable...
Required information [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets...
Required information [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 31,313 $ 36,602 $ 36,999 Accounts receivable, net 88,959 63,420 49,332 Merchandise inventory 110,719 83,805 53,069 Prepaid expenses 10,084 9,418 4,153 Plant assets, net 284,405 259,755 233,947 Total assets $ 525,480 $ 453,000 $ 377,500 Liabilities and Equity Accounts payable $ 129,536 $ 78,854 $ 50,827 Long-term notes payable secured by mortgages on plant...
Required information [The following information applies to the questions displayed below.]    The following calendar year-end...
Required information [The following information applies to the questions displayed below.]    The following calendar year-end information is taken from the December 31, 2017, adjusted trial balance and other records of Leone Company. Advertising expense $ 28,750 Direct labor $ 675,480 Depreciation expense—Office equipment 7,250 Income taxes expense 233,725 Depreciation expense—Selling equipment 8,600 Indirect labor 56,875 Depreciation expense—Factory equipment 33,550 Miscellaneous production costs 8,425 Factory supervision 102,600 Office salaries expense 63,000 Factory supplies used 7,350 Raw materials purchases 925,000 Factory...
Required information [The following information applies to the questions displayed below.]     The following calendar year-end...
Required information [The following information applies to the questions displayed below.]     The following calendar year-end information is taken from the December 31, 2019, adjusted trial balance and other records of Leone Company.     Advertising expense $ 33,400 Direct labor $ 672,000 Depreciation expense—Office equipment 7,700 Income taxes expense 241,800 Depreciation expense—Selling equipment 10,000 Indirect labor 58,000 Depreciation expense—Factory equipment 37,700 Miscellaneous production costs 9,700 Factory supervision 134,900 Office salaries expense 62,000 Factory supplies used 9,000 Raw materials purchases 972,000...
[The following information applies to the questions displayed below.] The balance sheets for Fantasy Football for...
[The following information applies to the questions displayed below.] The balance sheets for Fantasy Football for 2018 and 2017 are provided below. Required: 1. Prepare a vertical analysis of Fantasy Football's 2018 and 2017 balance sheets. Express each amount as a percentage of total assets for that year. (Amounts to be deducted should be indicated by a minus sign. Round your answers to 1 decimal place.) FANTASY FOOTBALL Balance Sheets December 31 2018 2017 Amount % Amount % Assets Current...
[The following information applies to the questions displayed below.] Income statements and balance sheets data for...
[The following information applies to the questions displayed below.] Income statements and balance sheets data for Virtual Gaming Systems are provided below. VIRTUAL GAMING SYSTEMS Income Statements For the year ended December 31 2019 2018 Net sales 3,470,000 2,996,000 Cost of goods sold 2,472,000 1,942,000 Gross Profit 998,000 1,054,000 Expenses: Operating Expenses 947,000 850,000 Depreciation expenses 22,000 23,000 Loss on sale of land 0 7,200 Interest expense 14,000 11,000 Income tax expense 7,200 44,000 Total expenses 990,200 935,200 Net income...
Required information [The following information applies to the questions displayed below.] A comparative balance sheet and...
Required information [The following information applies to the questions displayed below.] A comparative balance sheet and income statement is shown for Cruz, Inc. CRUZ, INC. Comparative Balance Sheets December 31, 2017 2017 2016 Assets Cash $ 99,000 $ 25,000 Accounts receivable, net 42,800 53,100 Inventory 89,600 99,700 Prepaid expenses 5,600 4,400 Total current assets 237,000 182,200 Furniture 113,000 124,700 Accum. depreciation—Furniture (17,600 ) (9,400 ) Total assets $ 332,400 $ 297,500 Liabilities and Equity Accounts payable $ 15,600 $ 21,900...
Required information [The following information applies to the questions displayed below.] Elegant Decor Company’s management is...
Required information [The following information applies to the questions displayed below.] Elegant Decor Company’s management is trying to decide whether to eliminate Department 200, which has produced losses or low profits for several years. The company’s departmental income statements show the following. ELEGANT DECOR COMPANY Departmental Income Statements For Year Ended December 31, 2019 Dept. 100 Dept. 200 Combined Sales $ 436,000 $ 290,000 $ 726,000 Cost of goods sold 262,000 207,000 469,000 Gross profit 174,000 83,000 257,000 Operating expenses...
Required information [The following information applies to the questions displayed below.] Martinez Company’s relevant range of...
Required information [The following information applies to the questions displayed below.] Martinez Company’s relevant range of production is 7,500 units to 12,500 units. When it produces and sells 10,000 units, its unit costs are as follows: Amount Per Unit   Direct materials $ 6.90   Direct labour $ 4.40   Variable manufacturing overhead $ 1.50   Fixed manufacturing overhead $ 4.90   Fixed selling expense $ 3.90   Fixed administrative expense $ 2.00   Sales commissions $ 1.00   Variable administrative expense $ 0.50 Required: 1. For financial...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT