Each companies amount due in sales date for a particular invoice is given in the table below. The first row has been solved for your reference. Use advanced filter to get a list of the companies. Calculate by how many days is the payment late for each invoice in column G$.$ Refer to the penalty criteria. Calculate what penalty percentage applies to each invoice in column H$.$ Last step would be calculating the total penalty for each invoice in column I. Solve in Excel.