Please advice on the approach for solving this problem. Financial Data tab

$1.$Create a calculated column to determine if an invoice is late and calculate a late penalty if applicable. Which company$/$companies are the worst offenders when it comes to paying their invoices on time?

$2.$What is the total amount of late penalties? Express this both as an amount and a percent of sales.

$3.$ For invoices with $2/15$ net $30$ or $3/10$ net $30$ terms $$ determine if an invoice has been paid early and hence warrants a discount. What is the total amount of discounts? Express this both as an amount and a percent of sales $$ where applicable.

$4.$ The accounting department has suggested moving to a single payment terms for all invoices. What is the overall impact of using $2/15$ net $30$ for ALL invoices? I.e$.,$ what will the total discounts be using this scheme $($vs currently$)$ and what will the total penalties be using this scheme $($again $$ vs the current scheme of five different $\backslash$table$[[,$InvNum,CustID,CustName,ItemNum,ItemDescr,UnitPrice,Qty$,$InvoiceTotal,InvoiceDate,Terms,PaymentDate$],[2,39475,$PP$091,$Payette Payload Services,$1369,$Airframe fasteners,$4\mathrm{.}20,237,995\mathrm{.}40,2023-09-02,$Full $45,2023-09-26$terms across the various customers$)?$