PE 9-6B Accounts receivable turnover and number of days’ sales in receivables
Financial statement data for years ending December 31 for Sherick Company are shown below.
2012 2011
Net sales $4,514,000 $4,200,000
Accounts receivable:
Beginning of year 280,000 320,000
End of year 330,000 280,000
a. Determine the accounts receivable turnover for 2012 and 2011.
b. Determine the number of days’ sales in receivables for 2012 and 2011. Round to one
decimal place.
c. Does the change in accounts receivable turnover and the number of days’ sales in
receivables from 2011 to 2012 indicate a favorable or an unfavorable trend?
Answer:
a. Accounts Receivable Turnover 2012 2011 Net sales............................... $4,514,000 $4,200,000 Accounts receivable: Beginning of year............ $280,000 $320,000 End of year....................... $330,000 $280,000 Average accts. receivable... $305,000 $300,000 [($280,000 + $330,000) ÷ 2] [($320,000 + $280,000) ÷ 2] Accts. receivable turnover 14.8 14.0 ($4,514,000 ÷ $305,000) ($4,200,000 ÷ $300,000)
b. Number of Days’ Sales in Receivables 2012 2011 Net sales............................... $4,514,000 $4,200,000 Average daily sales............. $12,367.1 $11,506.8 ($4,514,000 ÷ 365 days) ($4,200,000 ÷ 365 days) Average accts. receivable... $305,000 $300,000 [($280,000 + $330,000) ÷ 2] [($320,000 + $280,000) ÷ 2] Number of days’ sales in receivables................... 24.7 days 26.1 days ($305,000 ÷ $12,367.1) ($300,000 ÷ $11,506.8)
c. The increase in the accounts receivable turnover from 14.0 to 14.8 and the decrease in the number of days’ sales in receivables from 26.1 days to 24.7 days indicate favorable trends in the efficiency of collecting receivables.
2012 2011
Net sales $4,514,000 $4,200,000
Accounts receivable:
Beginning of year 280,000 320,000
End of year 330,000 280,000
a. Determine the accounts receivable turnover for 2012 and 2011.
b. Determine the number of days’ sales in receivables for 2012 and 2011. Round to one
decimal place.
c. Does the change in accounts receivable turnover and the number of days’ sales in
receivables from 2011 to 2012 indicate a favorable or an unfavorable trend?
Answer:
b. Number of Days’ Sales in Receivables 2012 2011 Net sales............................... $4,514,000 $4,200,000 Average daily sales............. $12,367.1 $11,506.8 ($4,514,000 ÷ 365 days) ($4,200,000 ÷ 365 days) Average accts. receivable... $305,000 $300,000 [($280,000 + $330,000) ÷ 2] [($320,000 + $280,000) ÷ 2] Number of days’ sales in receivables................... 24.7 days 26.1 days ($305,000 ÷ $12,367.1) ($300,000 ÷ $11,506.8)
c. The increase in the accounts receivable turnover from 14.0 to 14.8 and the decrease in the number of days’ sales in receivables from 26.1 days to 24.7 days indicate favorable trends in the efficiency of collecting receivables.