Question

In: Accounting

The following data are taken from the financial statements of Sigmon Inc. Terms of all sales...

The following data are taken from the financial statements of Sigmon Inc. Terms of all sales are 2/10, n/45.

20Y3 20Y2 20Y1
Accounts receivable, end of year $157,200 $164,000 $171,800
Sales on account 1,092,080 1,007,400

a. For 20Y2 and 20Y3, determine (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Round answers to one decimal place. Assume a 365-day year.

20Y3 20Y2
1. Accounts receivable turnover
2. Number of days' sales in receivables days days

b. The collection of accounts receivable has (improved, deteriorated) . This can be seen in both the (increase, decrease) in accounts receivable turnover and the (increase, decrease) in the collection period.

Solutions

Expert Solution

a.

For 2013

Accounts receivable, beginning = $164,000

Accounts receivable, ending = $157,200

Average accounts receivable = ( Beginning accounts receivable+Ending accounts receivable)/2

= (164,000+157,200)/2

= 321,200/2

= $160,600

Accounts receivable turnover = sales on account/ Average accounts receivable

= 1,092,080/160,600

= 6.8 times

Number of days sales in receivable = 365/ Accounts receivable turnover

= 365/6.8

= 53.7 days

For 2012

Accounts receivable, beginning = $171,800

Accounts receivable, ending = $164,000

Average accounts receivable = ( Beginning accounts receivable+Ending accounts receivable)/2

= (171,800+164,000)/2

= 335,800/2

= $167,900

Accounts receivable turnover = sales on account/ Average accounts receivable

= 1,007,400/167,900

= 6 times

Number of days sales in receivable = 365/ Accounts receivable turnover

= 365/6

= 60.8 days

20Y3 20Y2
1. Accounts receivable turnover 6.8 times 6 times
2. Number of days' sales in receivables 53.7 days 60.8 days

b.

The collection of accounts receivable has improved . This can be seen in both the increase in accounts receivable turnover and the decrease) in the collection period.


Related Solutions

The following data are taken from the financial statements of McKee Technology Inc. Terms of all...
The following data are taken from the financial statements of McKee Technology Inc. Terms of all sales are 2/10, n/55. 2016 2015 2014 Accounts receivable, end of year $149,600 $157,000 $164,200 Net sales on account 827,820 786,940 a. For 2015 and 2016, determine (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Round answers to one decimal place. Assume a 365-day year. 2016 2015 1. Accounts receivable turnover ? ? 2. Number of days' sales...
The following data were taken from the financial statements of Hunter Inc. for December 31 of...
The following data were taken from the financial statements of Hunter Inc. for December 31 of two recent years: Current Year Previous Year Accounts payable $510,000 $130,000 Current maturities of serial bonds payable 320,000 320,000 Serial bonds payable, 10% 1,270,000 1,590,000 Common stock, $1 par value 60,000 80,000 Paid-in capital in excess of par 660,000 660,000 Retained earnings 2,280,000 1,810,000 The income before income tax was $588,300 and $514,800 for the current and previous years, respectively. a. Determine the ratio...
The following data were taken from the financial statements of Gates Inc. for the current fiscal...
The following data were taken from the financial statements of Gates Inc. for the current fiscal year. Property, plant, and equipment (net) $1,414,800 Liabilities: Current liabilities $156,000 Note payable, 6%, due in 15 years 786,000 Total liabilities $942,000 Stockholders' equity: Preferred $4 stock, $100 par (no change during year) $942,000 Common stock, $10 par (no change during year) 942,000 Retained earnings: Balance, beginning of year $1,004,000 Net income 357,000 $1,361,000 Preferred dividends $37,680 Common dividends 67,320 105,000 Balance, end of...
The following data were taken from the financial statements of Hunter Inc. for December 31 of...
The following data were taken from the financial statements of Hunter Inc. for December 31 of two recent years: Current Year Previous Year Accounts payable $360,000 $110,000 Current maturities of serial bonds payable 240,000 240,000 Serial bonds payable, 10% 1,020,000 1,260,000 Common stock, $1 par value 60,000 70,000 Paid-in capital in excess of par 590,000 600,000 Retained earnings 2,050,000 1,630,000 The income before income tax was $415,800 and $363,800 for the current and previous years, respectively. a. Determine the ratio...
The following data were taken from the financial statements of Hunter Inc. for December 31 of...
The following data were taken from the financial statements of Hunter Inc. for December 31 of two recent years: Current Year Previous Year Accounts payable $918,000 $217,000 Current maturities of serial bonds payable 540,000 540,000 Serial bonds payable, 10% 2,150,000 2,690,000 Common stock, $1 par value 90,000 110,000 Paid-in capital in excess of par 990,000 1,000,000 Retained earnings 3,430,000 2,720,000 The income before income tax expense was $941,500 and $823,800 for the current and previous years, respectively. a. Determine the...
The following data were taken from the financial statements of Gates Inc. for the current fiscal...
The following data were taken from the financial statements of Gates Inc. for the current fiscal year. Property, plant, and equipment (net) $1,598,400 Liabilities: Current liabilities $201,000 Note payable, 6%, due in 15 years 999,000 Total liabilities $1,200,000 Stockholders' equity: Preferred $4 stock, $100 par (no change during year) $1,800,000 Common stock, $10 par (no change during year) 1,800,000 Retained earnings: Balance, beginning of year $1,920,000 Net income 674,000 $2,594,000 Preferred dividends $72,000 Common dividends 122,000 194,000 Balance, end of...
The following data were taken from the financial statements of Gates Inc. for the current fiscal...
The following data were taken from the financial statements of Gates Inc. for the current fiscal year. Property, plant, and equipment (net) $1,286,900 Liabilities: Current liabilities $152,000 Note payable, 6%, due in 15 years 757,000 Total liabilities $909,000 Stockholders' equity: Preferred $2 stock, $100 par (no change during year) $909,000 Common stock, $10 par (no change during year) 909,000 Retained earnings: Balance, beginning of year $970,000 Net income 381,000 $1,351,000 Preferred dividends $18,180 Common dividends 120,820 139,000 Balance, end of...
The following data were taken from the financial statements of Gates Inc. for the current fiscal...
The following data were taken from the financial statements of Gates Inc. for the current fiscal year. Property, plant, and equipment (net) $1,887,000 Liabilities: Current liabilities $222,000 Note payable, 6%, due in 15 years 1,110,000 Total liabilities $1,332,000 Stockholders' equity: Preferred $4 stock, $100 par (no change during year) $1,998,000 Common stock, $10 par (no change during year) 1,998,000 Retained earnings: Balance, beginning of year $2,132,000 Net income 779,000 $2,911,000 Preferred dividends $79,920 Common dividends 167,080 247,000 Balance, end of...
The following data were taken from the financial statements of Woodwork Enterprises Inc. for the current...
The following data were taken from the financial statements of Woodwork Enterprises Inc. for the current fiscal year. Assuming that there are no intangible assets. Property, plant, and equipment (net) $1,662,900 Liabilities: Current liabilities $144,000 Mortgage note payable, 10%, ten-year note issued two years ago 723,000 Total liabilities $867,000 Stockholders' equity: Preferred $4 stock, $100 par (no change during year) $650,250 Common stock, $10 par (no change during year) 650,250 Retained earnings: Balance, beginning of year $694,000 Net income 258,000...
The following data were taken from the financial statements of Gates Inc. for the current fiscal...
The following data were taken from the financial statements of Gates Inc. for the current fiscal year. Property, plant, and equipment (net) $2,444,400 Liabilities: Current liabilities $234,000 Note payable, 6%, due in 15 years 1,164,000 Total liabilities $1,398,000 Stockholders' equity: Preferred $4 stock, $100 par (no change during year) $2,097,000 Common stock, $10 par (no change during year) 2,097,000 Retained earnings: Balance, beginning of year $2,236,000 Net income 661,000 $2,897,000 Preferred dividends $83,880 Common dividends 17,120 101,000 Balance, end of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT