Allowance of doubtful debts using aging of Accounts receivable | ||||
Accounts Receivable ($)* | Percent Uncollectible (%)* | Total | ||
Not yet due | 10,000 | x | 1.50 | 150 |
1 to 30 | 25,000 | x | 3 | 750 |
31 to 60 | 90,000 | x | 8 | 7,200 |
61 to 90 | 240,000 | x | 33 | 79,200 |
Over 90 | 820,000 | x | 68.5 | 561,700 |
Total Allowance | 649,000 |
* Based on the graphical presentation given, closely estimated amounts are plotted
As percentages of uncollectible is given, allowance for bad debts for that amount is created.
The manager asks you to assist her with the data analytics on bad debts expense at...
The manager asks you to assist her with the data analytics on bad debts expense at year-end. To do this, you access the following Tableau Dashboard for your company. Makeup of Current Assets 1,220,000 1,708,000 732,000 476,000 Cash Accounts Receivable Inventory Supplies Value ($) Accounts Receivable by Age Over 90 days past due 12,000 61-90 days past due 38,000 31-60 days past due 86,000 1-30 days past due 254,000 1.30 days past due Not yet due Not yet due 830,000...
cash: 732,000 A/R: 1,220,000 Inventory: 1,708,000 Supplies: 476,000 over 90: 12,000 61-90: 38,000 31-60: 86,000 1-30: 254,000 not yet: 830,000 cash sales: 2,250,000 Credit sales: 7,150,000 Makeup of Current Assets Cash Accounts Receivable Supplies Value ($) Accounts Receivable by Age Over 90 days past due 61-90 days past due 31-60 days past due 1-30 days past due Not yet due mie $0 $200,000 $800,000 $400,000 Accounts Receivable ($) $200,000 $600,000 $800,000 $400,000 Accounts Receivable ($) Percent Uncollectible by Age Makeup...
Tableau DA 7-2: Percent of sales method, percent of recelvables method, and aging of receivables method LO P3 The manager asks you to assist her with the data analytics on bad debts expense at year-end. To do this, you access the following Tableau Dashboard for your company. $732000 Makeup of Current Assets $1220000 $1708000 $476000 Cash Accounts Receivable Inventory Supplies Value (5) Accounts Receivable by Age Over 90 days past due $12000 61.90 days past due $38000 31.60 days past...
Required information Problem 9-3A Aging accounts receivable and accounting for bad debts LO P2, P3 [The following information applies to the questions displayed below.] Jarden Company has credit sales of $2,200,000 for year 2017. On December 31, 2017, the company's Allowance for Doubtful Accounts has an unadjusted credit balance of $14,666. Jarden prepares a schedule of its December 31, 2017 accounts receivable by age. On the basis of past experience, it estimates the percent of receivables in each age category...
Required information Problem 9-3A Aging accounts receivable and accounting for bad debts LO P2, P3 The following information applies to the questions displayed below.] Jarden Company has credit sales of $2,400,000 for year 2017. On December 31, 2017, the company's Allowance for Doubtful Accounts has an unadjusted credit balance of $14,904. Jarden prepares a schedule of its December 31, 2017, accounts receivable by age. On the basis of past experience, it estimates the percent of receivables in each age category...
Required information Problem 9-3A Aging accounts receivable and accounting for bad debts LO P2, P3 (The following information applies to the questions displayed below.) Jarden Company has credit sales of $2,500,000 for year 2017. On December 31, 2017, the company's Allowance for Doubtful Accounts has an unadjusted credit balance of $14,900. Jarden prepares a schedule of its December 31, 2017, accounts receivable by age. On the basis of past experience, it estimates the percent of receivables in each age category...
A company uses the aging of accounts receivable method to estimate its bad debts expense. On December 31 of the current year an aging analysis of accounts receivable revealed the following 4. A company uses the aging of accounts receivable method to estimate its bad debts expense On December 31 of the current year an aging analysis of accounts receivable revealed the following Account Age Current (not yet due) 1-30 days past due 30 60 days past due 61-90 days...
Required information [The following information applies to the questions displayed below.] Jarden Company has credit sales of $2,600,000 for year 2017. On December 31, 2017, the company's Allowance for Doubtful Accounts has an unadjusted credit balance of $15,066. Jarden prepares a schedule of its December 31, 2017, accounts receivable by age. On the basis of past experience, it estimates the percent of receivables in each age category that will become uncollectible. This information is summarized here. December 31, 2017 Accounts...
Required Information [The following information applies to the questions displayed below.) Jarden Company has credit sales of $2,900,000 for year 2018. On December 31, 2018, the company's Allowance for Doubtful Accounts has an unadjusted credit balance of $21,659. Jarden prepares a schedule of its December 31, 2018 accounts receivable by age. On the basis of past experience, it estimates the percent of receivables in each age category that will become uncollectible. This information is summarized here. December 31, 2018 Accounts...
Check my Roby Reg 2 Prepare the adjusting entry to record bad debts expense assuming the unadjusted balance in the Allowance for Doubtful Accounts is a $1,400 credit. View transaction list Journal entry worksheet Record estimated bad debts assuming that allowance for Doubtful Accounts has a $1,400 credit balance. Net Zero Products, a wholesaler of sustainable raw materials. Prepared the following aging of receivables analysis. Days Past Due Total 0 1 $129,000 $84,000 Accounts receivable Percent uncollectible to 30 31...