Question

The September 30, 2018 balance sheet of ABC Corporation disclosed the following information relating to its receivables:

Accounts Receivable (net of $18,000 allowance)

$342,000

ABC prepares quarterly financial statements. The following occurred during the fourth quarter of 2018:

1. During the 4th quarter, ABC had credit sales of $2,600,000 and collections on accounts receivable (general) of $2,300,000. Uncollectible accounts totaling $19,000 were written off, and a $2,600 accounts receivable previously written off was collected (not included in the $2,300,000 of cash collections reported above.)

2. On November 1, ABC assigned $300,000 of accounts receivable to Quicken Finance on a non-notification basis. Quicken advanced ABC cash proceeds for 85% of the accounts assigned, less a finance fee of $5,000, in exchange for an interest-bearing note. The note incurs interest at 1% per month on the outstanding loan balance. Cash collections from these assigned accounts are to be remitted monthly to Quicken Finance and include accrued interest (i.e. the cash collected each month must be used to repay both principal and interest on the note.)

*During November, ABC collected $150,000 on assigned accounts. ABC also accepted sales returns of $2,000. The November collections were remitted to Quicken on November 30th and included accrued interest for the month.

*During December, ABC wrote off $3,000 of assigned accounts as uncollectible. By December 31st, assigned accounts of $80,000 were collected in cash. These cash collections were remitted to Quicken Finance on December 31, 2018, and included accrued interest for December.

1) Determine Bad Debt Expense for the fourth quarter as of December 31, 2018:

2)  Determine the ending balance of the Allowance for Doubtful Accounts (after adjustment) as of December 31, 2018:

Answer 1

Bad Debt Expense:

Bad Debt Expense = (Accounts receivable ending balance x percentage estimated as uncollectible) – Existing credit balance in the allowance for doubtful accounts or + existing debit balance in the allowance for doubtful accounts

=3,42,000* 5.5%(19,000/3,42,000/100)

+23,00,000*0.939%(19,000+2,600/23,00,000/100)

+3,00,000*17.67%(45,000+5,000+3,000/3,00,000/100)

=18,810+21,597+53,010

=93,417

Ending balance of Allowance for doubtful debts:

= 93,417(calculated as before)

+1,50,000*3.33%(2,000+3,000/1,50,000*100)

+80,000*3.75%(3,000/80,000*100)

=93,417+4,995+3,000

=1,01,412