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 aging schedule using this information. Please include the payment history in the schedule.

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.

Customer Green Jones Smith Thomas Williams Total Balance Current 0-30 Days 31-60 Days 61-90 Days Over 90 Days Total Estimated Bad Debt Percentages Estimated Bad Debt 0.01 0.05 0.1 0.2 0.5 Payment History Total Bad Debt