Geisel Inc reported net sales revenue of 512000 in 2015 and

Geisel, Inc. reported net sales revenue of $512,000 in 2015 and $628,000 in 2016. The company’s average net receivables were $118,000 during 2014 and $138,000 during 2015. At December 31, 2016, the company had Accounts Receivable of $147,000. and an unadjusted debit balance in its Allowance for Doubtful Accounts account of $1,900. The company reported Bad Debt Expense of $11,600 during 2016.

Geisel, Inc. reported net sales revenue of $512,000 in 2015 and $628,000 in 2016. The company’s average net receivables were $118,000 during 2014 and $138,000 during 2015. At December 31, 2016, the company had Accounts Receivable of $147,000. and an unadjusted debit balance in its Allowance for Doubtful Accounts account of $1,900. The company reported Bad Debt Expense of $11,600 during 2016.

Required a. Determine the net receivables at December 31, 2016. Net receivables b. Calculate the receivables turnover ratio for 2015 and 2016. (Round your intermediate calculations and final answers to 1 decimal place. Use 365 days a year.) 2015 2016 Accounts Receivable Turnover Ratio c. Calculate the days to collect for 2015 and 2016. (Round your intermediate calculations and final answers to 1 decimal place. Use 365 days a year.) 2015 2016 Days to Collect

Solution

a. the net receivables at December 31, 2016 = $147000 + (1900 - 11600 ) = $137300 b. the receivables turnover ratio :Sales / Average Net Accounts Receivables for 2015 = $512000 / (118000 + 138000 / 2) = 4 times for 2016 = $628000 / (138000 + 137300 / 2 ) = 611000 / 136960 = 4.56 times c. the days to collection : No. of days / Net Accounts Receivable turnover for 2015 = 365 / 4 = 91.25 days for 2016 = 365 / 4.56 = 80.04 days