Chapter 8 Homework Account Amount August 11 Avalanche Auto Bales Auto 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: Due Date $12,000 October 4 2,400 Derby Auto Repair June 13 Lucky's Auto Repair September 21 Reliable Auto Repair July 4 9,750 August 21 1,800 Valley Repair & Tow May 21 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. 3,900 6,600 September 8 Pit Stop Auto 1,100 Trident Auto 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 11 October 4 Derby Auto Repair June 13 Lucky's Auto Repair September 8 Pit Stop Auto September 21 Reliable Auto Repair July 4 Bales Auto Trident Auto August 21 Valley Repair & Tow May 21 E H F G 1 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 en 2 accounts receivable provided below were past due. 3 4 DATA 5 Date of the end of business October 31 6 Using formulas and cell references, perform the required analysis, and input your answers into the Number of Days Past Due column. Transfer 7 results for the green entry cells (D10:017) into the appropriate fields in CNOWV2 for grading. 8 9 Account Due Date Amount Number of Days Past Due Formulas 10 Avalanche Auto August 11 $12,000 11 Bales Auto October 4 2,400 12 Derby Auto Repair June 13 3,900 13 Lucky's Auto Repair September 8 6,600 14 Pit Stop Auto September 21 1,100 15 Reliable Auto Repair July 4 9,750 16 Trident Auto August 21 1,800 17 Valley Repair & Tow May 21 4,000 18 19 20 21