Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. find total outstanding receivables, the percentage

find total outstanding receivables, the percentage of receivables written off out of credit sales, and...

80.2K

Verified Solution

Question

Accounting

find total outstanding receivables, the percentage of receivables written off out of credit sales, and the percentage per aging category of outstanding receivables

Assume that if the receivable was not paid over the course of the following year, the entire amount is written off. In that case, the corresponding cell in column 5 remains blank. Assume 4 categories of aging receivables: (1) 0-30 days outstanding, (2) 31-60 days outstanding, (3) 61-90 days outstanding, and (4) over 90 days outstanding.

- Column 1: the customer ID - Column 2: the total sale on account and invoiced during the year - Column 3: the account receivable balance outstanding at year-end - Column 4: the date when the invoice was issued - Column 5: the date when the invoice balance was paid off in the following year

please with explanation

image

\begin{tabular}{|r|r|r|r|r|} \hline 96 & 169,834 & 83,460 & 2013/12/4 & 2014/1/18 \\ \hline 97 & 106,720 & 66,279 & 2013/9/6 & 2014/1/22 \\ \hline 98 & 229,464 & 147,850 & 2013/10/31 & 2014/1/21 \\ \hline 99 & 86,045 & 63,129 & 2013/9/13 & 2014/1/4 \\ \hline 100 & 196,545 & 108,168 & 2013/9/22 & \\ \hline 101 & 90,989 & 20,733 & 2013/9/4 & \\ \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

Finance
1.2K views

I'm primarily interested in the last question put in Bold: If the spot rate for British pounds...

Chemistry
1.2K views

a hydrogen-oxygen fuel cell is used in the space program to generate clean energy. Describe, in...

Civil Engineering
1.2K views

discuss and describe the particle electrical charge theory with emphasis on electrical double layer theory and...

Biology
1.2K views

2 You are car A Who should yield the right of way as you are...

Physics
1.2K views

(a) Which force does positive work?TRFg(b) Which force does negative work?TRFg(c) Which force does zero...

Geometry
1.2K views

3 The diagram shows a falcon F on a tree with a squirrel S and...

Geometry
1.2K views

Grocery Drugstores Health Stores Food Stores What was the average number of locations chosen per...

Basic Math
1.2K views

Isabella filled her pool with water at a constant rate.The table compares the remaining volume...

Algebra
1.2K views

Two narrow cylindrical pipes A and B have the same length Pipe A is open...

Accounting
1.2K views

the range of 105 , 100 , 79 , 86 , 101 , 94 ,...

Accounting
1.2K views

5. A Co, assigned $100,000 of account receivables for a service lee of S500 and...

Accounting
1.2K views

Lobel Machines Company is evaluating an investment of $1,250,000 which will yield net cash inflows...