The Asset section of the Balance Sheet of Aubergine Ltd at the 30th June 20X2 is presented below: Current Assets $ Cash at Bank $ 15,354 79,840 Inventory Accounts Receivable 42,387 (3,981) Less Allowance for Doubtful Debts 38,406 133,600 Non-Current Assets Plant & Equipment Less Accumulated depreciation Intangibles 1,950,000 (390,000) 1,560,000 250,000 1,810,000 TOTAL ASSETS 1,943,600 Note that where journal entries are needed narrations are not required. Round any calculations to the nearest dollar. a) During the year ending 30th June 20x3, Aubergine Ltd identified the following debts as uncollectible on the dates mentioned: Date Debtora Bad debt $24 11/10/X20 D. Martyne 1,2542 18/2/X3 N. Fyfe 1,7672 Required Prepare journal entry/ies to write off these bad debts on the dates mentioned. 3 marks Date DR CR E E- El EL E E E- E- |||||||||||| H . El H b) On 30th June 20x3 Aubergine Ltd reassessed its Allowance for Doubtful Debts account to allow for bad debts that may become uncollectable in the future using the aged receivables method. You are provided with the following aged debtors listing as at the 30th June 20x3.- Current Debtor 0-30 days431-60 days 61-90 days 91+ days $ $e 2,7864 1,348 3,7604 1,347 989 4,322 T. Walker P. Dangerfielde R. Sloane A. Gaffe S. Pendleburye L. Neale 3,656 2,3104 1,982 1,800 1,3231 1,112 5,4384 2,3294 N. Natainuie 3,185 1,877 4,5344 R. Gray L. Franklin 3,2444 2,8784 Aubergine Ltd have determined that the following rates of uncollectability are to be applied in determining their allowance for bad debts. Current To 30 days 31-60 days 61-90 days 90+ days 1.0% 2.5% 4.0% 18.0% 45.0% Required 7 marks Prepare the general journal entry to record the Allowance for Doubtful Debts for Aubergine Ltd as at 30th June 20x3 using the aged receivables method and the above information. Note-you need to take account of the debts written off in part a) above when calculating the journal entry. Date DR CR Ef H. TTTTTT E E E- E E- E- HO El . c) On the 31st October 20x3 Aubergine Ltd decided to write off all the amounts that were owing by A. Gaff as at 30th June 20x3 as a bad debt. Required 2 marks Prepare the journal entry for the write off all the amounts owing by A.Gaff as a bad debt as at 31st October 20X3.- DR. CR Date E 6 He E E E E E E E H H . H d) There are no further debt write offs for the year ended 30th June 20x4 for Aubergine Ltd. At the 30th June 20X4 Aubergine Ltd calculated the balance of the Allowance for Doubtful Debts account using the aged receivables method. This amount was $2,978. Required 2 marks Prepare the journal entry to record the adjustment to the Allowance for Doubtful Debts account required at the 30 June 20X4.- Date DR CR Fe E- E E- E E- E E E- H H E Et CCC HF e) During the financial year ending 30th June 20x5 there were no bad debt write offs. As a result Aubergine Ltd reviewed all their percentages which are applied in the aged receivables method. Consequently the balance of the Allowance for Doubtful Debts at the 30th June 20x5 was calculated to be $2,270.- Required 3 marks Prepare the journal entry to record the adjustment to the Allowance for Doubtful Debts account required at the 30 June 20X5.4 tt Date DR CR H E- E- E E E- E E- E- E H E E The Asset section of the Balance Sheet of Aubergine Ltd at the 30th June 20X2 is presented below: Current Assets $ Cash at Bank $ 15,354 79,840 Inventory Accounts Receivable 42,387 (3,981) Less Allowance for Doubtful Debts 38,406 133,600 Non-Current Assets Plant & Equipment Less Accumulated depreciation Intangibles 1,950,000 (390,000) 1,560,000 250,000 1,810,000 TOTAL ASSETS 1,943,600 Note that where journal entries are needed narrations are not required. Round any calculations to the nearest dollar. a) During the year ending 30th June 20x3, Aubergine Ltd identified the following debts as uncollectible on the dates mentioned: Date Debtora Bad debt $24 11/10/X20 D. Martyne 1,2542 18/2/X3 N. Fyfe 1,7672 Required Prepare journal entry/ies to write off these bad debts on the dates mentioned. 3 marks Date DR CR E E- El EL E E E- E- |||||||||||| H . El H b) On 30th June 20x3 Aubergine Ltd reassessed its Allowance for Doubtful Debts account to allow for bad debts that may become uncollectable in the future using the aged receivables method. You are provided with the following aged debtors listing as at the 30th June 20x3.- Current Debtor 0-30 days431-60 days 61-90 days 91+ days $ $e 2,7864 1,348 3,7604 1,347 989 4,322 T. Walker P. Dangerfielde R. Sloane A. Gaffe S. Pendleburye L. Neale 3,656 2,3104 1,982 1,800 1,3231 1,112 5,4384 2,3294 N. Natainuie 3,185 1,877 4,5344 R. Gray L. Franklin 3,2444 2,8784 Aubergine Ltd have determined that the following rates of uncollectability are to be applied in determining their allowance for bad debts. Current To 30 days 31-60 days 61-90 days 90+ days 1.0% 2.5% 4.0% 18.0% 45.0% Required 7 marks Prepare the general journal entry to record the Allowance for Doubtful Debts for Aubergine Ltd as at 30th June 20x3 using the aged receivables method and the above information. Note-you need to take account of the debts written off in part a) above when calculating the journal entry. Date DR CR Ef H. TTTTTT E E E- E E- E- HO El . c) On the 31st October 20x3 Aubergine Ltd decided to write off all the amounts that were owing by A. Gaff as at 30th June 20x3 as a bad debt. Required 2 marks Prepare the journal entry for the write off all the amounts owing by A.Gaff as a bad debt as at 31st October 20X3.- DR. CR Date E 6 He E E E E E E E H H . H d) There are no further debt write offs for the year ended 30th June 20x4 for Aubergine Ltd. At the 30th June 20X4 Aubergine Ltd calculated the balance of the Allowance for Doubtful Debts account using the aged receivables method. This amount was $2,978. Required 2 marks Prepare the journal entry to record the adjustment to the Allowance for Doubtful Debts account required at the 30 June 20X4.- Date DR CR Fe E- E E- E E- E E E- H H E Et CCC HF e) During the financial year ending 30th June 20x5 there were no bad debt write offs. As a result Aubergine Ltd reviewed all their percentages which are applied in the aged receivables method. Consequently the balance of the Allowance for Doubtful Debts at the 30th June 20x5 was calculated to be $2,270.- Required 3 marks Prepare the journal entry to record the adjustment to the Allowance for Doubtful Debts account required at the 30 June 20X5.4 tt Date DR CR H E- E- E E E- E E- E- E H E E