In: Accounting
Chamberlain Enterprises Inc. reported the following receivables in its December 31, 2016, year-end balance sheet:
Current assets: | |
Accounts receivable, net of $24,000 in allowance for | |
uncollectible accounts | $218,000 |
Interest receivable | 6,800 |
Notes receivable | 260,000 |
Additional Information:
1. The notes receivable account consists of two notes, a $60,000 note and a $200,000 note. The $60,000 note is dated October 31, 2016, with principal and interest payable on October 31, 2017. The $200,000 note is dated June 30, 2016, with principal and 6% interest payable on June 30, 2017.
2. During 2017, sales revenue totaled $1,340,000, $1,280,000 cash was collected from customers, and $22,000 in accounts receivable were written off. All sales are made on a credit basis. Bad debt expense is recorded at year-end by adjusting the allowance account to an amount equal to 10% of year-end accounts receivable.
3. On March 31, 2017, the $200,000 note receivable was discounted at the Bank of Commerce. The bank’s discount rate is 8%. Chamberlain accounts for the discounting as a sale.
Required:
1. In addition to sales revenue, what revenue and expense amounts related to receivables will appear in Chamberlain’s 2017 income statement?
2. What amounts will appear in the 2017 year-end balance sheet for accounts receivable?
3. Calculate the receivables turnover ratio for 2017.
1.
Bad debt expense:
Accounts receivable | ||
Opening | 242000 | |
Add sales | 1340000 | |
Less collection | -1280000 | |
Less written off | -22000 | |
Closing | 280000 | |
Rate of allowance | 10% | |
Allowance balance required | 28000 | |
Unadjusted balance in books | ||
Opening balance | 24000 | |
Less written off | -22000 | |
a | Unadjusted balance in books | 2000 |
b | Balance required | 28000 |
c=b-a | Bad debt expense | 26000 |
Interest revenue of 5760 on two note receivables.
Note amount | Interest rate | Interest receivable | Interest revenue for months | Interest revenue |
60,000 | 8% | 800 | 10 | 4,000 |
2,00,000 | 6% | 6,000 | 1760 | |
6,800 | 5,760 |
workings:
Note amount | 2,00,000 | |
Interest portion | 12,000 | |
Total note amount receivable | 2,12,000 | |
Discount rate | 8% | |
Number of months to maturity | 3 | |
Discount amount | 4,240 | |
212000*8%*3/12 | ||
Cash received | 2,07,760 | |
Carrying value in books | ||
Note amount | 200000 | |
Interest receivable | 6000 | |
a | Total | 206000 |
b | Cash received | 2,07,760 |
c=b-a | Interest revenue | 1,760 |
2. AR balance:
Accounts receivable | |
Gross balance | 280000 |
Less allowacne | 28000 |
Net balance | 252000 |
3.
accounts receivables turn over= sales/ average accounts receivable =1340000/ (242000+280000)/2 = 5.13