Assormontrakeassignmentvain dotovokeretaketssonmentSession Locanorabnorporessatalse Show Me How Of Calculator Number of days past due parts to local dealers throughout the Midwest Toot's credit s are 30. As of the end of business on October Toot Auto Supply distributes new and used automat 31. the following accounts recevable were pot due Account Due Date Amount Avalanche Auto $12,000 August 17 October 2 une 13 2.400 6,600 Bales Auto Derby Auto Repair Lucky's Auto Repair Pet Stop Auto Reuter Trident 1.100 2 Determine the number of days each is a dues October 31. Round your Number of Days Paste COMU OSIBOT NW E T H M M Cemal YouTube Maps M Plan & Schedule C WebAdvisor Excel template - Saved Home Insert Data Review View Help Tell me what you want to do Wrap Text General Copy Format Painter B I R - A Merge & Center % 9 Conditional Format Insert Delete Form ber 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, the accounts receivable provided below were past due DATA Date of the end of business October 31 5 7 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.017) 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 1) Lucky's Auto Repair 14 PR Stop Auto 15 Reliable Auto Repair 16 Trident Auto 17 Valley Repair & Tow Due Date August 17 October 2 June 13 September September 22 July 2 August 25 May 22 Amount $12.000 2400 3.900 6.600 1.100 9.750 1.800 4,000 Sad signmentSessionLocatori progresse Assign Plan & Schedule m ent over Web dvisor Trots August 26 May 22 Valley Ratow This information has been collected in the Microsoft Excel Online Open the spreadsheet, perform the required analysis, and input your an Determine the number of days each account is post dut as of October 31. Round your answers to the nearest whole number Due Date Number of Days Past Due Avalanche Auto Aug 17 O2 Derby Lucky's Auto Repair PR Stop Auto September 22 Reliable Auto Repair Trident Auto August 26 May 22 (euse Deck My Work Q 115 M