Might have to zoom in on your screen to see. ...

90.2K

Verified Solution

Question

Accounting

Might have to zoom in on your screen to see.

image

image

image

image

image

image

image

image

\begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ Question } \\ \hline 1. If Home Depot has an invoice due date of 12/2/2021 and today's date is 12/31/2021, what is the number of days past due? & \\ \hline 2. What is the total receivables due in the 130 day A/R aging bucket? Round to 2 decimal places. \\ \hline 3. What is the gross (or total) amount of accounts receivable for this dataset? Round to 2 decimal places. \\ \hline 4. In the detailed 151-180 A/R aging bucket, what is the amount owed by Coca-Cola? Round to 2 decimal places. \\ \hline 5. In the detailed 1-30 A/R aging bucket, what is the amount owed by Canon? Round to 2 decimal places. \\ \hline \end{tabular} Question 1. What is the gross amount of receivables owed? Round to two decimal places. 2. What is the total receivables due in the 61-90 A/R aging bucket? Round to two decimal places. 3. What is the total receivables due in the 121150A/R aging bucket? Round to two decimal places. 4. How many unpaid invoices are listed in the 151180A/R aging bucket? 5. What is the amount of the largest individual invoice in the 1-30 A/R aging bucket? Round to two decimal places. 1. If you wanted to adjust the charts to count the number of unpaid invoices in each aging bucket, for each company, what would you do? 2. If you wanted to adjust the charts to sum the total amount of unpaid invoices in each aging bucket, for each company, what would you do? \begin{tabular}{|lrr|} \hline Customer & Invoice Amount & Due Date \\ \hline Home Depot & 377.6 & 12/2/25 \\ \hline Porsche & 1259.97 & 9/28/25 \\ \hline Burberry & 1476.09 & 8/14/25 \\ \hline AT\&T & 331.8 & 11/24/25 \\ \hline Porsche & 1122.46 & 9/5/25 \\ \hline Porsche & 838.18 & 10/3/25 \\ \hline Beko & 387.23 & 9/6/25 \\ \hline BMW & 1389.2 & 9/10/25 \\ \hline United Parcel Service & 685.1 & 10/31/25 \\ \hline Deere \& Company & 1424.71 & 9/27/25 \\ \hline Beko & 772.14 & 12/8/25 \\ \hline Citigroup & 981.87 & 12/14/25 \\ \hline Samsung Group & 957.07 & 11/29/25 \\ \hline General Electric & 694.29 & 11/15/25 \\ \hline Nokia & 279.42 & 8/21/25 \\ \hline Citigroup & 994.35 & 10/30/25 \\ \hline Xerox & 230.98 & 10/16/25 \\ \hline Starbucks & 415.15 .55 & 8/30/25 \\ \hline Coca-Cola & 419.86 & 10/8/25 \\ \hline SM & 1249.67 & 7/27/25 \\ \hline Intel Corporation & 1469.06 & 11/4/25 \\ \hline Nintendo & 541.26 & 9/6/25 \\ \hline Porsche & 1427.79 & 11/22/25 \\ \hline The Walt Disney & & \\ \hline Company & 893.4 & 9/8/25 \\ \hline KFC & 1093.72 & 10/8/25 \\ \hline MTV & 1031.88 & 11/15/25 \\ \hline Vodafone & 654.88 & 9/6/25 \\ \hline Harley-Davidson & 289.16 & 8/2/25 \\ \hline Moet et Chandon & 392.53 & 8/17/25 \\ \hline Canon & 1447.32 & 12/22/25 \\ \hline Yahoo! & 899.53 & 8/17/25 \\ \hline Avon & 717.65 & 10/12/25 \\ \hline Gap Inc. & 1385.16 & 11/18/25 \\ \hline VISA & 723.94 & 10/10/25 \\ \hline Honda Motor Company & 8/12/25 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ Question } \\ \hline 1. If Home Depot has an invoice due date of 12/2/2021 and today's date is 12/31/2021, what is the number of days past due? & \\ \hline 2. What is the total receivables due in the 130 day A/R aging bucket? Round to 2 decimal places. \\ \hline 3. What is the gross (or total) amount of accounts receivable for this dataset? Round to 2 decimal places. \\ \hline 4. In the detailed 151-180 A/R aging bucket, what is the amount owed by Coca-Cola? Round to 2 decimal places. \\ \hline 5. In the detailed 1-30 A/R aging bucket, what is the amount owed by Canon? Round to 2 decimal places. \\ \hline \end{tabular} Question 1. What is the gross amount of receivables owed? Round to two decimal places. 2. What is the total receivables due in the 61-90 A/R aging bucket? Round to two decimal places. 3. What is the total receivables due in the 121150A/R aging bucket? Round to two decimal places. 4. How many unpaid invoices are listed in the 151180A/R aging bucket? 5. What is the amount of the largest individual invoice in the 1-30 A/R aging bucket? Round to two decimal places. 1. If you wanted to adjust the charts to count the number of unpaid invoices in each aging bucket, for each company, what would you do? 2. If you wanted to adjust the charts to sum the total amount of unpaid invoices in each aging bucket, for each company, what would you do? \begin{tabular}{|lrr|} \hline Customer & Invoice Amount & Due Date \\ \hline Home Depot & 377.6 & 12/2/25 \\ \hline Porsche & 1259.97 & 9/28/25 \\ \hline Burberry & 1476.09 & 8/14/25 \\ \hline AT\&T & 331.8 & 11/24/25 \\ \hline Porsche & 1122.46 & 9/5/25 \\ \hline Porsche & 838.18 & 10/3/25 \\ \hline Beko & 387.23 & 9/6/25 \\ \hline BMW & 1389.2 & 9/10/25 \\ \hline United Parcel Service & 685.1 & 10/31/25 \\ \hline Deere \& Company & 1424.71 & 9/27/25 \\ \hline Beko & 772.14 & 12/8/25 \\ \hline Citigroup & 981.87 & 12/14/25 \\ \hline Samsung Group & 957.07 & 11/29/25 \\ \hline General Electric & 694.29 & 11/15/25 \\ \hline Nokia & 279.42 & 8/21/25 \\ \hline Citigroup & 994.35 & 10/30/25 \\ \hline Xerox & 230.98 & 10/16/25 \\ \hline Starbucks & 415.15 .55 & 8/30/25 \\ \hline Coca-Cola & 419.86 & 10/8/25 \\ \hline SM & 1249.67 & 7/27/25 \\ \hline Intel Corporation & 1469.06 & 11/4/25 \\ \hline Nintendo & 541.26 & 9/6/25 \\ \hline Porsche & 1427.79 & 11/22/25 \\ \hline The Walt Disney & & \\ \hline Company & 893.4 & 9/8/25 \\ \hline KFC & 1093.72 & 10/8/25 \\ \hline MTV & 1031.88 & 11/15/25 \\ \hline Vodafone & 654.88 & 9/6/25 \\ \hline Harley-Davidson & 289.16 & 8/2/25 \\ \hline Moet et Chandon & 392.53 & 8/17/25 \\ \hline Canon & 1447.32 & 12/22/25 \\ \hline Yahoo! & 899.53 & 8/17/25 \\ \hline Avon & 717.65 & 10/12/25 \\ \hline Gap Inc. & 1385.16 & 11/18/25 \\ \hline VISA & 723.94 & 10/10/25 \\ \hline Honda Motor Company & 8/12/25 \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students