To begin, we have a list of $200$ receivables that are all past their due date as of today$$s date of $12/31/2025.$ Create a calculated field to show the numbers of days each invoice is past due.

Create a summary table that shows the total amount each company owes.

Create a filtered view to show the detailed information for each company. Customer InvoiceAmount Due Date

IBM $406\mathrm{.}5710/3/2025$

PepsiCo $747\mathrm{.}1212/15/2025$

Smirnoff $373\mathrm{.}599/12/2025$

$3$M $1415\mathrm{.}7611/27/2025$

Canon $308\mathrm{.}6311/30/2025$

Intel Corporation $526\mathrm{.}429/29/2025$

H&M $1117\mathrm{.}7510/5/2025$

American Express $612\mathrm{.}2812/3/2025$

Shell Oil Company $1348\mathrm{.}399/8/2025$

Home Depot $1442\mathrm{.}2412/20/2025$

Porsche $890\mathrm{.}029/29/2025$

Burberry $1158\mathrm{.}989/11/2025$

AT&T $439\mathrm{.}8311/5/2025$

Porsche $1440\mathrm{.}038/18/2025$

Porsche $999\mathrm{.}249/15/2025$

Beko $1183\mathrm{.}6812/8/2025$

BMW $812\mathrm{.}628/16/2025$

United Parcel Service $461\mathrm{.}819/23/2025$

Deere & Company $1011\mathrm{.}4110/30/2025$

Beko $653\mathrm{.}448/5/2025$

Citigroup $1204\mathrm{.}748/20/2025$

Samsung Group $1409\mathrm{.}6312/12/2025$

General Electric $1478\mathrm{.}87/27/2025$

Nokia $656\mathrm{.}2812/3/2025$

Citigroup $1056\mathrm{.}9211/27/2025$

Xerox $377\mathrm{.}612/2/2025$

Starbucks $1259\mathrm{.}979/28/2025$

Coca$-$Cola $1476\mathrm{.}098/14/2025$

$3$M $331\mathrm{.}811/24/2025$

Ralph Lauren $1122\mathrm{.}469/5/2025$

Porsche $838\mathrm{.}1810/3/2025$

The Walt Disney Company $387\mathrm{.}239/6/2025$

KFC $1389\mathrm{.}29/10/2025$

MTV $685\mathrm{.}110/31/2025$

Vodafone $1424\mathrm{.}719/27/2025$

Harley$-$Davidson $772\mathrm{.}1412/8/2025$

Moet et Chandon $981\mathrm{.}8712/14/2025$

Canon $957\mathrm{.}0711/29/2025$

Yahoo! $694\mathrm{.}2911/15/2025$

Avon $279\mathrm{.}428/21/2025$

Gap Inc. $994\mathrm{.}3510/30/2025$

VISA $230\mathrm{.}9810/16/2025$

Honda Motor Company $419\mathrm{.}8610/8/2025$

Kleenex $1249\mathrm{.}677/27/2025$

Audi $1469\mathrm{.}0611/4/2025$

Credit Suisse $541\mathrm{.}269/6/2025$

Siemens AG $1427\mathrm{.}7911/22/2025$

Intel Corporation $893\mathrm{.}49/8/2025$

Nintendo $1093\mathrm{.}7210/8/2025$

Chase $1031\mathrm{.}8811/15/2025$

Kellogg Company $654\mathrm{.}889/6/2025$

Microsoft $289\mathrm{.}168/2/2025$

Hermes $392\mathrm{.}538/17/2025$

Zara $1447\mathrm{.}3212/22/2025$

Xerox $899\mathrm{.}538/17/2025$

Mastercard $717\mathrm{.}6510/12/2025$

Johnson & Johnson $1385\mathrm{.}1611/18/2025$

Jack Daniel's $723\mathrm{.}9410/10/2025$

Hyundai $1220\mathrm{.}0311/3/2025$

Amazon.com $664\mathrm{.}258/12/2025$

eBay $481\mathrm{.}848/10/2025$

L'Oreal $731\mathrm{.}910/4/2025$

Nissan Motor $1162\mathrm{.}8812/11/2025$

Johnson & Johnson $1210\mathrm{.}119/29/2025$

Intel Corporation $715\mathrm{.}558/30/2025$

Blackberry $1369\mathrm{.}328/20/2025$

MasterCard $982\mathrm{.}758/20/2025$

Nissan Motor $325\mathrm{.}0810/29/2025$

Adidas $887\mathrm{.}489/28/2025$

Siemens AG $751\mathrm{.}448/16/2025$

Mercedes$-$benz $471\mathrm{.}337/25/2025$

Caterpillar Inc. $1442\mathrm{.}878/6/2025$

Pampers $1303\mathrm{.}0111/19/2025$

General Electric $770\mathrm{.}139/20/2025$

Toyota Motor Coporation $1091\mathrm{.}059/8/2025$

Apple Inc. $848\mathrm{.}2210/10/2025$

HSBC $806\mathrm{.}868/13/2025$

Bucci $1110\mathrm{.}777/30/2025$

Bucci $1427\mathrm{.}168/15/2025$

eBay $1180\mathrm{.}658/24/2025$

Nintendo $249\mathrm{.}819/8/2025$

Pizza Hut $768\mathrm{.}38/8/2025$

Corona $810\mathrm{.}2810/20/2025$

Beko $1062\mathrm{.}4811/21/2025$

Oracle Corporation $1434\mathrm{.}4411/13/2025$

Morgan Stanley $1241\mathrm{.}0111/6/2025$

Google Allianz $326\mathrm{.}6111/3/2025$

Toyota Motor Coporation $894\mathrm{.}048/21/2025$

The Walt Disney Company $364\mathrm{.}979/10/2025$

SAP $288\mathrm{.}58/17/2025$

Jack Daniel's