Questions: On December 31, a company has an unadjusted credit balance of 1,450 in its Allowance for Doubtful Accounts. Following is a schedule of its December 31 accounts receivable by age. Age of Accounts Receivable Accounts Receivable Expected Percent Uncollectible Not yet due 104,000 1.00% 1 to 30 days past due 62,400 2.50% 31 to 60 days past due 20,800 11.00% 61 to 90 days past due 10,400 37.00% Over 90 days past due 2,600 77.00% Total 200,200 Calculate the required balance of the Allowance for Doubtful Accounts on December 31 using an aging of accounts receivable. Accounts Receivable Percent Uncollectible Estimated Uncollectible Not due: x = 1 to 30: x = 31 to 60: x 61 to 90: x Over 90: x = Estimated balance of allowance for uncollectibles

On December 31, a company has an unadjusted credit balance of 1,450 in its Allowance for Doubtful Accounts. Following is a schedule of its December 31 accounts receivable by age.

Age of Accounts Receivable  Accounts Receivable  Expected Percent Uncollectible
Not yet due  104,000  1.00%
1 to 30 days past due  62,400  2.50%
31 to 60 days past due  20,800  11.00%
61 to 90 days past due  10,400  37.00%
Over 90 days past due  2,600  77.00%
Total  200,200 

Calculate the required balance of the Allowance for Doubtful Accounts on December 31 using an aging of accounts receivable.

  Accounts Receivable  Percent Uncollectible   Estimated Uncollectible 
Not due:   x   = 
1 to 30:   x   = 
31 to 60:   x   
61 to 90:   x   
Over 90:   x  =  
Estimated balance of allowance for uncollectibles
Transcript text: On December 31, a company has an unadjusted credit balance of $\$ 1,450$ in its Allowance for Doubtful Accounts. Following is a schedule of its December 31 accounts receivable by age. \begin{tabular}{lrr} Age of Accounts Receivable & \begin{tabular}{c} Accounts \\ Receivable \end{tabular} & \begin{tabular}{c} Expected Percent \\ Uncollectible \end{tabular} \\ \hline Not yet due & $\$ 104,000$ & $1.00 \%$ \\ 1 to 30 days past due & 62,400 & $2.50 \%$ \\ 31 to 60 days past due & 20,800 & $11.00 \%$ \\ 61 to 90 days past due & 10,400 & $37.00 \%$ \\ Over 90 days past due & 2,600 & $77.00 \%$ \\ Total & $\$ 200,200$ & \\ \hline \end{tabular} Calculate the required balance of the Allowance for Doubtful Accounts on December 31 using an aging of accounts receivable. \begin{tabular}{|l|l|l|l|l|l|} \hline & \begin{tabular}{c} Accounts \\ Receivable \end{tabular} & \multicolumn{1}{|c|}{\begin{tabular}{c} Percent \\ Uncollectible \end{tabular}} & & \begin{tabular}{c} Estimated \\ Uncollectible \end{tabular} & \\ \hline Not due: & & x & & $=$ & \\ \hline 1 to $30:$ & & x & & $=$ & \\ \hline 31 to $60:$ & & x & & & \\ \hline 61 to $90:$ & & x & & & \\ \hline Over $90:$ & & x & $=$ & & \\ \hline Estimated balance of allowance for uncollectibles & & & \\ \hline \end{tabular}
failed

Solution

failed
failed

To calculate the required balance of the Allowance for Doubtful Accounts on December 31 using an aging of accounts receivable, we need to determine the estimated uncollectible amount for each age category of accounts receivable and then sum these amounts.

Here's how to calculate it:

  1. Not yet due:

    • Accounts Receivable: \$104,000
    • Expected Percent Uncollectible: 1.00%
    • Estimated Uncollectible: \$104,000 x 1.00% = \$1,040
  2. 1 to 30 days past due:

    • Accounts Receivable: \$62,400
    • Expected Percent Uncollectible: 2.50%
    • Estimated Uncollectible: \$62,400 x 2.50% = \$1,560
  3. 31 to 60 days past due:

    • Accounts Receivable: \$20,800
    • Expected Percent Uncollectible: 11.00%
    • Estimated Uncollectible: \$20,800 x 11.00% = \$2,288
  4. 61 to 90 days past due:

    • Accounts Receivable: \$10,400
    • Expected Percent Uncollectible: 37.00%
    • Estimated Uncollectible: \$10,400 x 37.00% = \$3,848
  5. Over 90 days past due:

    • Accounts Receivable: \$2,600
    • Expected Percent Uncollectible: 77.00%
    • Estimated Uncollectible: \$2,600 x 77.00% = \$2,002

Now, sum the estimated uncollectible amounts for all categories to find the total estimated balance of the allowance for uncollectibles:

  • Total Estimated Uncollectible = \$1,040 + \$1,560 + \$2,288 + \$3,848 + \$2,002 = \$10,738

Therefore, the required balance of the Allowance for Doubtful Accounts on December 31 is \$10,738.

Was this solution helpful?
failed
Unhelpful
failed
Helpful