Question: While reviewing the data in the ARTable you notice that the companys aging categories are not the industry standard. Therefore, you need to add a

While reviewing the data in the ARTable you notice that the companys aging categories are not the industry standard. Therefore, you need to add a column to the table to calculate the industry standard aging categories. This will allow you to evaluate the receivables against other companies in the same industry.

The industry standard aging categories are

Not due (

Current (0 to 30 days outstanding)

31 to 60 days

61 to 90 days

91 to 180 days

Greater than 180 days

Use the column called days OS to determine each aging category

Name the new column Typical Aging While reviewing the data in the ARTable you notice that the

Typical Aging DAYS OS Aging Cat 30 21 Days or more 30 21 Days or more 177 21 Days or more 146 21 Days or more 123 21 Days or more 192 21 Days or more 192 21 Days or more

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!