Q9

Need this done asap. Please help me with the proper solutions. Thanks in advance.

Number of days past due Toot Auto Supply distributes new and used automobile parts to local dealers throughout the Midwest. Toot's credit terms are n/30. As of the end of business on October 31, the following accounts receivable were past due: Account Due Date Amount Avalanche Auto August 19 $12,000 Bales Auto 2,400 Derby Auto Repair 3,900 6,600 Lucky's Auto Repair October 6 June 24 September 7 September 25 July 5 August 27 Pit Stop Auto 1,100 Reliable Auto Repair 9,750 1,800 Trident Auto Valley Repair & Tow May 20 4,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. x3 Open spreadsheet Determine the number of days each account is past due as of October 31. Round your answers to the nearest whole number. Account Due Date Number of Days Past Due Avalanche Auto August 19 Bales Auto October 6 Derby Auto Repair June 24 Lucky's Auto Repair September 7 Pit Stop Auto September 25 Reliable Auto Repair July 5 Trident Auto August 27 Valley Repair & Tow May 20