72dbed07-015d-413f-a0d0-6d95d23ad762.xlsx
Student Grade Point A B C D F Grade
Abbey 90.00
Anderson 87.60
Austin 75.30
Barden 93.00
Briggs 65.40
Charnell 72.50
Fitzgerald 73.20
Griffin 81.00
Harrington 80.00
Henderson 59.50
Selby 70.00
Page 1
Aged Receivables
Todays date:
Total Due:
Total Current
Total Over 30:
Total Over 60:
Inv. Date Client Amount Current Over 30 Over 60
6/14/2011 Ferguson & Bardell $6,251
6/30/2011 Spencer Ceramics $1,366
7/5/2011 Wolfgang's Auto Repair $5,651
7/25/2011 Ferguson & Bardell $2,563
8/2/2011 Tropical Ice $8,751
8/16/2011 Wolfgang's Auto Repair $6,966
8/28/2011 Harper Industrial $2,159
9/2/2011 Ferguson & Bardell $8,614
9/12/2011 Spencer Ceramics $5,896
9/27/2011 Second National Bank $540
9/27/2011 Tropical Ice $8,561
9/28/2011 Ferguson & Bardell $5,559
9/29/2011 Harper Industrial $9,546
10/16/2011 Wolfgang's Auto Repair $2,333
10/16/2011 Second National Bank $892
11/1/2011 Wolfgang's Auto Repair $2,561
11/2/2011 Spencer Ceramics $3,261
11/9/2011 Marathon Yacht Broker $6,532
11/12/2011 Ferguson & Bardell $5,650
Page 2
Finished Exercise
Todays date: ########
Total Due: $93,652
Total Current $18,004
Total 30 to 60: $27,431
Total over 60: $48,217
Inv. Date Client Amount Current 30 to 60 Over 60
6/14/2011 Ferguson & Bardell 6,251 6,251
6/30/2011 Spencer Ceramics 1,366 1,366
7/5/2011 Wolfgang's Auto Repair 5,651 5,651
7/25/2011 Ferguson & Bardell 2,563 2,563
8/2/2011 Tropical Ice 8,751 8,751
8/16/2011 Wolfgang's Auto Repair 6,966 6,966
8/28/2011 Harper Industrial 2,159 2,159
9/2/2011 Ferguson & Bardell 8,614 8,614
9/12/2011 Spencer Ceramics 5,896 5,896
9/27/2011 Second National Bank 540 540
9/27/2011 Tropical Ice 8,561 8,561
9/28/2011 Ferguson & Bardell 5,559 5,559
9/29/2011 Harper Industrial 9,546 9,546
10/16/2011 Wolfgang's Auto Repair 2,333 2,333
10/16/2011 Second National Bank 892 892
11/1/2011 Wolfgang's Auto Repair 2,561 2,561
11/2/2011 Spencer Ceramics 3,261 3,261
11/9/2011 Marathon Yacht Broker 6,532 6,532
11/12/2011 Ferguson & Bardell 5,650 5,650
Page 3