Academic Papers

We have a wide range of professionally written academic papers to help you get better academically.

Title : Week 3 Excel Assignment: Accounting for Receivables


Instructions :

Assume the following information concerning accounts receivable: Percent likely To be Uncollectible .01 (Current) .05 (0-30 Days) .1 (31-60 Days) .2 (61-90 Days) Using Excel, construct an accounts receivable aging schedule using this information. Please include the payment history in the schedule. The Excel template contains the estimated bad debt percentage for each receivables category. After you completed the aging schedule then create a pivot table indicating how many of the good customers fall under each receivable category (current, 0-30 days, etc.) and how many of the slow customers fall under each receivable category. .5 (Over 90 Days)

Description :

Assume the following information concerning accounts receivable: Percent likely To be Uncollectible .01 (Current) .05 (0-30 Days) .1 (31-60 Days) .2 (61-90 Days) .5 (Over 90 Days) Customer Current 0-30 Days 31-60 Days 61-90 Days Over 90 Days Green 5,000.00 $ 2,000.00 Jones $ 4,000.00 $ 2,300.00 $ 5,700.00 Smith $ 12,000.00 Thomas $ 1,000.00 $ 2,400.00 $ 3,450.00 $ 2,000.00 $ 1,400.00 Williams $ 5,050.00 In addition, the payment history of each customer is as follows: Green – Good Jones – Slow Smith – Good Thomas – Slow Williams – Good Using Excel, construct an accounts receivable aging schedule using this information. Please include the payment history in the schedule. The Excel template contains the estimated bad debt percentage for each receivables category. After you completed the aging schedule then create a pivot table indicating how many of the good customers fall under each receivable category (current, 0-30 days, etc.) and how many of the slow customers fall under each receivable category. Use the following Excel template: Receivables Template

Price:

$20