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 August 10 October 5 Account Avalanche Auto Bales Auto Derby Auto Repair Lucky's Auto Repair Pit Stop Auto Reliable Auto Repair June 23 September 4 September 20 July 2 Amount $12,000 2,400 3,900 6,600 1,100 9,750 1,800 4,000 Trident Auto August 23 May 25 1 Valley Repair & Tow 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.

REQUIRED: Determine the number of days each account is past due as of October 31 . Using formulas and cell references from the problem data perform the required analysis. Formulas entered in the green cels show in the orange cells Transfer amounts fo CNOWV2 for grading Determine the number of days each account is past due as of October 31 . Number of dave past due \begin{tabular}{|c|c|c|} \hline Account & Dur Date & Amount \\ \hline Avalenche Nes: & Aypuit ie & 112.900 \\ \hline Buls hate: & Ocasbers & 24t0 \\ \hline Derter Aits Mesar. & lin22 & 2.500 \\ \hline Luchre tuft kaber & Septenter 4 & 6.600 \\ \hline De Shas aste & suptember 20 & 1,100 \\ \hline Balabiende Eabir & Mr2 & itse \\ \hline Thens kits & Aogne 23 & ines \\ \hline Voler keyer \& toue & Now 2s & 4.060 \\ \hline \end{tabular}