In: Accounting
Chamberlain Enterprises Inc. reported the following receivables in its December 31, 2018, year-end balance sheet: Current assets: Accounts receivable, net of $26,000 in allowance for uncollectible accounts $ 228,000 Interest receivable 7,850 Notes receivable 280,000 Additional Information: The notes receivable account consists of two notes, a $55,000 note and a $225,000 note. The $55,000 note is dated October 31, 2018, with principal and interest payable on October 31, 2019. The $225,000 note is dated June 30, 2018, with principal and 6% interest payable on June 30, 2019. During 2019, sales revenue totaled $1,360,000, $1,290,000 cash was collected from customers, and $24,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. On March 31, 2019, the $225,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. Not including sales revenue, what revenue and expense amounts related to receivables will appear in Chamberlain’s 2019 income statement? 2. & 3. What amounts will appear in the 2019 year-end balance sheet for accounts receivable and Calculate the receivables turnover ratio for 2019.
| Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | ||||
| Working 1: | Interest Rate for Note of $ 55000 | |||
| Interest for 2018: | ||||
| Total Interest (From Balance sheet) | $ 7,850 | |||
| Less: | ||||
| Interest on 225000 Note | $ 6,750 | |||
| (225000*6%*6/12) | ||||
| Interest on 55000 Note for 2 Months | $ 1,100 | |||
| Hence Rate for 100000 Note is | 12% | |||
| (1100/55000*12/2) | ||||
| Requirement -1 | ||||
| Interest for 2019: | ||||
| 55000*12%*10/12 | $ 5,500 | |||
| 225000*6%*3/12 | $ 3,375 | |||
| (Jan Feb Mar) | ||||
| Interest Revenue | $ 8,875 | |||
| Bad Debt Expense: | ||||
| Analysis of accounts receivable : | ||||
| Beginning accounts receivable | 228000+26000 | $ 254,000 | ||
| Add: Credit sales | $ 1,360,000 | |||
| Less: Write offs | $ -24,000 | |||
| Less: Cash collections | $ -1,290,000 | |||
| Ending accounts receivable | $ 300,000 | |||
| Analysis of allowance for uncollectible accounts: | ||||
| Beginning allowance | $ 26,000 | |||
| Add: Bad debt expense (26000-24000-30000) | $ 28,000 | |||
| Less: write offs | $ -24,000 | |||
| Ending allowance 300000*10% | $ 30,000 | |||
| Loss on Note Receivable: | ||||
| 225000*6%*9/12 | $ 10,125 | |||
| Add: Note Receivable | $ 225,000 | |||
| Carrying Value of Note | A | $ 235,125 | ||
| Face Amount | $ 225,000 | |||
| Interest on Maturity 225000*6% | $ 13,500 | |||
| Maturity Value | $ 238,500 | |||
| Less Discount 238500*8%*3/12 | $ 4,770 | |||
| Cash Proceeds | B | $ 233,730 | ||
| Loss on sale of Note Receivable | A-B | $ 1,395 | ||
| Interes Revenue | $ 8,875 | |||
| Bad Debt Expense | $ 28,000 | |||
| Loss on Sale of Note | $ 1,395 | |||
| Requirement -2 | ||||
| Accounts Receivable, Net of 30000 in allowance | $ 270,000 | |||
| Receivable Turnover Ratio | ||||
| (Credit Sale/Average Receivable) | 5.15 | |||
| 1360000/266000 | ||||
| Average Receivable | $ 264,000 | |||
| (228000+300000)/2 | ||||