Collins Company analyzes its accounts receivable at December 31 and arrives at the age categories below along with the percentages that are estimated as uncollectible. The balance of the allowance for uncollectible accounts is $1,100 on December 31 before any adjustments.

Age Group Accounts Receivable Estimated Loss (%)

0-30 days past due 110,000 1

31-60 days past due 40,000 2

61-120 days past due 27,000 5

121-180 days past due 14,000 10

Over 180 days past due 9,000 25

Total Accounts Receivable 200,000

Questions:

a) What amount of bad debts expense will Collins report in its income statement for the year?

b) Use the financial statement effects template to record Collins' bad debts expense for the year.

c) What is the balance of accounts receivable on its December 31 balance sheet?

I'm stuck because I think of the wording. How do I calculate bad debt if I don't know what the Allowance start of year and End of Year is? Is it 200,00 as the start? Is the write off $1,100 and the end of year (200,000 -6,900 (total of estimated loss) = 193,100??