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 24 $12,000 Bales Auto October 4 2,400 Derby Auto Repair June 24 3,900 Lucky's Auto Repair September 7 6,600 Pit Stop Auto September 25 1,100 Reliable Auto Repair July 3 9,750 Trident Auto August 22 1,800 Valley Repair & Tow May 22 4,000 This information has been collected in the Microsoft Excel Online nie. Open the spreadsheet perform the required analysis, and Input your answers in the questions below. 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 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 24 Bales Auto October 4 Derby Auto Repair June 24 Lucky's Auto Repair September 7 Pit Stop Auto September 25 Reliable Auto Repair July 3 Trident Auto August 22 Valley Repair & Tow May 22 119 Feedback Check My Work Do not include the due date in your count. Remember that not all months have an equal number of days TUT FUTUR VIEW VIEW rep lel me what you want to 00 Arial -A" A General 9 DS M WIB Paste B TUD . A - $ . % 2828 Insert Delete format Clear Sort Conditional Format Format - Tbile Styles Tables Cyboard Font Alignment Number Catte D N c F G Number of days past due Toot Auto Supply distributes new and used automobile parts to local dealers throughout the Midwest. Toot's credit torms are n/30. As of the end of business, the accounts receivable provided below were past due. DATA Date of the end of business October 31 Using formulas and cell references, perform the required analysis, and input your answers into the Number of Days Past Due column. Transfer the numeric results for the green entry cells (D10:D17) into the appropriate fields in CNOWV2 for grading. Number of Days Past Due Formulas 9 Account 10 Avalanche Auto 11 Bales Auto 12 Derby Auto Repair 13 Lucky's Auto Repair 14 Pit Stop Auto 15 Reliable Auto Repair 16 Trident Auto 17 Valley Repair & Tow 18 Due Date August 24 October 4 June 24 September 7 September 25 July 3 August 22 May 22 Amount $12,000 2.400 3.900 6,800 1.100 9,750 1.800 4.000 Data
