Thx

Nylander Pty Ltd has accounts receivable of $202,000 at 31 March 2019. An analysis of the accounts shows these amounts Balance, 31 March Cell referencing REQUIRED Month of sale 2019 $67,000 57,000 44,000 34,000 2018 $65,660 56,430 38,280 27,880 188,250 March propercell reference formulas to the Use red bolded datacells for all of your entriesto the answer cells. December and November and October Credit terms are 2/7, nV30. At 31 March 2019 there is a $900 credit balance in Allowance for Doubtful Debts before adjustment Nylander uses the ageing of accounts receivable basis for estimating uncollectable accounts. The company's estimates of bad debts are as follows: $900 credit balance in Allowance for Doubtful Debts of accounts Estimated uncollectable Current 1-30 days 31-90 days Over 90 days 2% 5% due t due 50% Required (a) Determine the total estimated uncollectibles by completing the following schedule. Estimated uncollectible Accounts receivable Amount Percent Percent Percent Percent Total value value value 1-30 days past due Over 90 (b) Prepare the ad usting entry at 31 March 2019 to record bad debts expense. 31 Mareh Debit a s value Credit a/c K2 $ value (c) Discuss the implications of the change in the ageing schedule from 2018 and 2019. Type your answer here