Answer:
The balance of allowance for doubtful accounts is $131,712.
Explanation:
Note: This question is not complete. The complete question is therefore provided before answering the question. See the attached pdf file for the complete question.
The explanation of the answer is now given as follows:
Note: See the attached excel file for the estimated allowance for doubtful accounts.
In the attached excel file, the allowance for doubtful accounts for each Percentage uncollectible is calculated as follows:
Allowance for doubtful accounts = Total receivables * Percentage uncollectible.
Also, the balance of allowance for doubtful accounts is calculated by adding the allowance for doubtful accounts of the Age Classes.
From the attached excel file, the balance of allowance for doubtful accounts is $131,712.