Asked by Patrick Garland on May 07, 2024
Verified
A partially completed aging of receivables schedule for Lindy Designs is shown below. Calculate the amount that is estimated to be uncollectible.?
(a) Determine the amount estimated to be uncollectible by completing the aging of receivables schedule. Round calculations to the nearest dollar.? Estimated Uncollectible Accounts \quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad { \text { Estimated Uncollectible } } \\\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad { \text { Accounts } } Estimated Uncollectible Accounts
Age Interval Balance Percentage Amount Not past due 5550,0002.50%1−30 days past due 96,5004.0031−60 days past due 43,7509.5061−90 days past due 22,25016.0091−180 days past due 5,60031.00181−365 days past due 3,10060.00 Over 365 days past due 1,25095.00 Total $722,450‾\begin{array}{|l|r|c|c|}\hline \text { Age Interval } & \text { Balance } & \text { Percentage } & \text { Amount } \\\hline \text { Not past due } & 5550,000 & 2.50 \% & \\\hline 1-30 \text { days past due } & 96,500 & 4.00 & \\\hline 31-60 \text { days past due } & 43,750 & 9.50 & \\\hline 61-90 \text { days past due } & 22,250 & 16.00 & \\\hline 91-180 \text { days past due } & 5,600 & 31.00 & \\\hline 181-365 \text { days past due } & 3,100 & 60.00 & \\\hline \text { Over } 365 \text { days past due } & 1,250 & 95.00 & \\\hline \text { Total } & \underline{\mathbf{\$ 7 2 2 , 4 5 0}} & & \\\hline\end{array} Age Interval Not past due 1−30 days past due 31−60 days past due 61−90 days past due 91−180 days past due 181−365 days past due Over 365 days past due Total Balance 5550,00096,50043,75022,2505,6003,1001,250$722,450 Percentage 2.50%4.009.5016.0031.0060.0095.00 Amount (b) If Allowance for Doubtful Accounts has a credit balance of $9,700, record the adjusting entry for bad debt expense for the year.
(c) If Allowance for Doubtful Accounts has a debit balance of $9,700, record the adjusting entry for bad debt expense for the year.
Aging Of Receivables
A method used in accounting to estimate the amount of receivables that may not be collectible by categorizing them according to the length of time they have been outstanding.
Uncollectible
Refers to accounts receivable that are considered to be uncollectible and thus written off as a loss.
Adjusting Entry
A journal entry made prior to preparing financial statements to adjust the balances of accounts to accurately reflect the financial activity.
- Apply aging of receivables method to estimate uncollectible accounts.
Verified Answer
LM
Leticia MolinaMay 09, 2024
Final Answer :
(a)? Estimated Uncollectible Accounts \quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad { \text { Estimated Uncollectible } } \\\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad { \text { Accounts } } Estimated Uncollectible Accounts
Age Interval Balance Percentage Amount Not past due $550,0002.50%$13,7501−30 days past due 96,5004.003,86031−60 days past due 43,7509.504,15661−90 days past due 22,25016.003,56091−180 days past due 5,60031.001,736181−365 days past due 3,10060.001,860 Over 365 days past due 1,250‾95.001,188‾ Total $722,450‾$30,110‾\begin{array} { | l | r | c | r | } \hline \text { Age Interval } & \text { Balance } & \text { Percentage } & \text { Amount } \\\hline \text { Not past due } & \$ 550,000 & 2.50 \% & \$ 13,750 \\\hline 1 - 30 \text { days past due } & 96,500 & 4.00 & 3,860 \\\hline 31 - 60 \text { days past due } & 43,750 & 9.50 & 4,156 \\\hline 61 - 90 \text { days past due } & 22,250 & 16.00 & 3,560 \\\hline 91 - 180 \text { days past due } & 5,600 & 31.00 & 1,736 \\\hline 181 - 365 \text { days past due } & 3,100 & 60.00 & 1,860 \\\hline \text { Over } 365 \text { days past due } & \underline{1,250} & 95.00 & \underline{1,188} \\\hline \text { Total } & \underline{\mathbf { \$ 7 2 2 , 4 5 0 }} & & \underline{\mathbf { \$3 0 , 1 1 0 }} \\\hline\end{array} Age Interval Not past due 1−30 days past due 31−60 days past due 61−90 days past due 91−180 days past due 181−365 days past due Over 365 days past due Total Balance $550,00096,50043,75022,2505,6003,1001,250$722,450 Percentage 2.50%4.009.5016.0031.0060.0095.00 Amount $13,7503,8604,1563,5601,7361,8601,188$30,110
(b) Dec. 31 Bad Debt Expense 20,410
Allowance for Doubtful Accounts 20,410?? Calculation of expense:
Amount of calculated uncollectible accounts $30,110\quad \$ 30,110$30,110
Less credit balance of account 9,700\quad 9,7009,700
Bad debt expense $20,410‾\underline{\$20,410}$20,410
(c) Dec. 31 Bad Debt Expense 39,810
Allowance for Doubtful Accounts 39,810? Calculation of expense:
Amount of calculated uncollectible accounts $30,110\quad \$ 30,110$30,110
Plus debit balance of account 9,700\quad 9,7009,700
Bad debt expense $30,810‾~~~~~\underline{\$ 30,810} $30,810
Age Interval Balance Percentage Amount Not past due $550,0002.50%$13,7501−30 days past due 96,5004.003,86031−60 days past due 43,7509.504,15661−90 days past due 22,25016.003,56091−180 days past due 5,60031.001,736181−365 days past due 3,10060.001,860 Over 365 days past due 1,250‾95.001,188‾ Total $722,450‾$30,110‾\begin{array} { | l | r | c | r | } \hline \text { Age Interval } & \text { Balance } & \text { Percentage } & \text { Amount } \\\hline \text { Not past due } & \$ 550,000 & 2.50 \% & \$ 13,750 \\\hline 1 - 30 \text { days past due } & 96,500 & 4.00 & 3,860 \\\hline 31 - 60 \text { days past due } & 43,750 & 9.50 & 4,156 \\\hline 61 - 90 \text { days past due } & 22,250 & 16.00 & 3,560 \\\hline 91 - 180 \text { days past due } & 5,600 & 31.00 & 1,736 \\\hline 181 - 365 \text { days past due } & 3,100 & 60.00 & 1,860 \\\hline \text { Over } 365 \text { days past due } & \underline{1,250} & 95.00 & \underline{1,188} \\\hline \text { Total } & \underline{\mathbf { \$ 7 2 2 , 4 5 0 }} & & \underline{\mathbf { \$3 0 , 1 1 0 }} \\\hline\end{array} Age Interval Not past due 1−30 days past due 31−60 days past due 61−90 days past due 91−180 days past due 181−365 days past due Over 365 days past due Total Balance $550,00096,50043,75022,2505,6003,1001,250$722,450 Percentage 2.50%4.009.5016.0031.0060.0095.00 Amount $13,7503,8604,1563,5601,7361,8601,188$30,110
(b) Dec. 31 Bad Debt Expense 20,410
Allowance for Doubtful Accounts 20,410?? Calculation of expense:
Amount of calculated uncollectible accounts $30,110\quad \$ 30,110$30,110
Less credit balance of account 9,700\quad 9,7009,700
Bad debt expense $20,410‾\underline{\$20,410}$20,410
(c) Dec. 31 Bad Debt Expense 39,810
Allowance for Doubtful Accounts 39,810? Calculation of expense:
Amount of calculated uncollectible accounts $30,110\quad \$ 30,110$30,110
Plus debit balance of account 9,700\quad 9,7009,700
Bad debt expense $30,810‾~~~~~\underline{\$ 30,810} $30,810
Learning Objectives
- Apply aging of receivables method to estimate uncollectible accounts.