In: Accounting
Web Wizard, Inc., has provided information technology services for several years. For the first two months of the current year, the company has used the percentage of credit sales method to estimate bad debts. At the end of the first quarter, the company switched to the aging of accounts receivable method. The company entered into the following partial list of transactions during the first quarter. During January, the company provided services for $41,000 on credit. On January 31, the company estimated bad debts using 2 percent of credit sales. On February 4, the company collected $20,500 of accounts receivable. On February 15, the company wrote off a $150 account receivable. During February, the company provided services for $31,000 on credit. On February 28, the company estimated bad debts using 2 percent of credit sales. On March 1, the company loaned $2,600 to an employee, who signed a 6% note, due in 6 months. On March 15, the company collected $150 on the account written off one month earlier. On March 31, the company accrued interest earned on the note. On March 31, the company adjusted for uncollectible accounts, based on an aging analysis (below). Allowance for Doubtful Accounts has an unadjusted credit balance of $1,210. Number of Days Unpaid Customer Total 0–30 31–60 61–90 Over 90 Alabama Tourism $ 230 $ 110 $ 90 $ 30 Bayside Bungalows 410 $ 410 Others (not shown to save space) 17,400 6,900 8,500 1,100 900 Xciting Xcursions 390 390 Total Accounts Receivable $ 18,430 $ 7,400 $ 8,590 $ 1,130 $ 1,310 Estimated Uncollectible (%) 3 % 10 % 20 % 30 % PA8-4 Part 1 Required: For items (a)–(j), analyze the transaction to determine effects on specific financial statement accounts and the overall accounting equation. (Enter any decreases to Assets, Liabilities, or Stockholders Equity with a minus sign. Do not round intermediate calculations.
Solution :
Computation of allowance for estimated uncollectibles - Web Wizard | |||||
Customer | Balance | 0-30 days | 31-60 days | 61-90 days | Over 90 days |
Total Receivables | $18,430.00 | $7,400.00 | $8,590.00 | $1,130.00 | $1,310.00 |
Percentage uncollectibles | 3% | 10% | 20% | 30% | |
Allowance for doubtful accounts | $1,700.00 | $222.00 | $859.00 | $226.00 | $393.00 |
Event | Assets | = | Liabilities | + | Stockholder's Equity | |||
a | Accounts receivables | $41,000.00 | Service revenue | $41,000.00 | ||||
b | Allowance for doubtful accounts | -$820.00 | Bad debts expense | -$820.00 | ||||
c | Cash | $20,500.00 | ||||||
Accounts receivables | -$20,500.00 | |||||||
d | Allowance for doubtful accounts | $150.00 | ||||||
Accounts receivables | -$150.00 | |||||||
e | Accounts receivables | $31,000.00 | Service revenue | $31,000.00 | ||||
f | Allowance for doubtful accounts | -$620.00 | Bad debts expense | -$620.00 | ||||
g | Note receivables | $2,600.00 | ||||||
Cash | -$2,600.00 | |||||||
h | Accounts receivables | $150.00 | ||||||
Allowance for doubtful accounts | -$150.00 | |||||||
Cash | $150.00 | |||||||
Accounts receivables | -$150.00 | |||||||
i | Interest receivables | $13.00 | Interest revenue | $13.00 | ||||
J | Allowance for doubtful accounts | -$490.00 | Bad debts expense | -$490.00 |