Preparing an Aging Schedule to Estimate Allowance for Doubtful Accounts A review of open invoices of Sketchers Inc. results in the following report. Invoice Amount Date (Each from this year) #496 $458.48 5-Dec #495 685.77 2-Dec #427 274.16 5-Nov #100 109.06 28-Jun #300 741.43 3-Oct #410 670.26 31-Oct #204 62.69 25-Aug #498 760.84 28-Dec #499 276.15 28-Dec #487 747.28 28-Nov #310 207.65 8-Oct #178 643.21 7-Aug #497 335.03 5-Dec #488 142.90 29-Nov #105 18.73 5-Jul $6,133.64 Required a. Organize the list of open invoices as of December 31 into a table with the following aging categories across the top: (1) less than 30 days, (2) 31-60 days, (3) 60-90 days, and (4) greater than 90 days. b. Assume that the company estimates the allowance for doubtful accounts based upon the following percentages applied to the appropriate aging categories: (1) 1% for less than 30 days, (2) 5% for 31-60 days, (3) 30% for 60-90 days, and (4) 60% for greater than 90 days. What is the ending allowance for doubtful accounts as estimated by the company? Complete the following table to complete requirements of parts a and b. Note: For each of the dollar amounts that you enter into the table below, round to two digits after the decimal; for example, enter 1.42 for 1.424, or 1.43 for 1.425. Less than 30 days 31-60 Days 60-90 Days Greater than 90 Days Total Total Receivables Answer Answer Answer Answer Answer Percentage Answer Answer Answer Answer Estimated Uncollectibles Answer Answer Answer Answer Answer

College Accounting, Chapters 1-27

23rd Edition

ISBN:9781337794756

Author:HEINTZ, James A.

Publisher:HEINTZ, James A.

Chapter16: Accounting For Accounts Receivable

Section: Chapter Questions

Problem 10SPA: AGING ACCOUNTS RECEIVABLE An analysis of the accounts receivable of Johnson Company as of December...

See similar textbooks

Related questions

Question

Preparing an Aging Schedule to Estimate Allowance for Doubtful Accounts

A review of open invoices of Sketchers Inc. results in the following report.

Invoice	Amount	Date (Each from this year)
#496	$458.48	5-Dec
#495	685.77	2-Dec
#427	274.16	5-Nov
#100	109.06	28-Jun
#300	741.43	3-Oct
#410	670.26	31-Oct
#204	62.69	25-Aug
#498	760.84	28-Dec
#499	276.15	28-Dec
#487	747.28	28-Nov
#310	207.65	8-Oct
#178	643.21	7-Aug
#497	335.03	5-Dec
#488	142.90	29-Nov
#105	18.73	5-Jul
	$6,133.64

Required

a. Organize the list of open invoices as of December 31 into a table with the following aging categories across the top: (1) less than 30 days, (2) 31-60 days, (3) 60-90 days, and (4) greater than 90 days.

b. Assume that the company estimates the allowance for doubtful accounts based upon the following percentages applied to the appropriate aging categories: (1) 1% for less than 30 days, (2) 5% for 31-60 days, (3) 30% for 60-90 days, and (4) 60% for greater than 90 days. What is the ending allowance for doubtful accounts as estimated by the company?

Complete the following table to complete requirements of parts a and b.

Note: For each of the dollar amounts that you enter into the table below, round to two digits after the decimal; for example, enter 1.42 for 1.424, or 1.43 for 1.425.