Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Might have to zoom in on your screen to see. begin{tabular}{|l|l|l|} hline multicolumn{1}{|c|}{ Question } hline 1. If Home Depot has an invoice due

Might have to zoom in on your screen to see.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

\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}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Theory

Authors: William R Scott

5th Edition

0132072866, 978-0132072861

More Books

Students also viewed these Accounting questions