TOWN OF READING, MASSACHUSETTS
MUNICIPAL LIGHT DEPARTMENT
SCHEDULE OF ACCOUNTS RECEIVABLE
5/31/08
SCHEDULE B
PREVIOUS YEAR CURRENT YEAR
SCHEDULE OF ACCOUNTS RECEIVABLE
RESIDENTIAL AND COMMERCIAL 3,220,692.08 3,700,887.75
ACCOUNTS RECEIVABLE - OTHER 249,527.53 188,738.08
ACCOUNTS RECEIVABLE - LIENS 48,170.97 80,148.33
ACCOUNTS RECEIVABLE - EMPLOYEE ADVANCES 1,067.16 1,067.16
SALES DISCOUNT LIABILITY (241,802.14) (194,649.71)
RESERVE FOR UNCOLLECTIBLE ACCOUNTS (196,100.63) (179,005.66)
   TOTAL ACCOUNTS RECEIVABLE BILLED 3,081,554.97 3,597,185.95
UNBILLED ACCOUNTS RECEIVABLE 3,126,031.41 2,714,176.30
   TOTAL ACCOUNTS RECEIVABLE, NET 6,207,586.38 6,311,362.25
SCHEDULE OF PREPAYMENTS
PREPAID INSURANCE 515,774.76 538,118.49
PREPAYMENT PURCHASED POWER (182,828.65) (316,701.14)
PREPAYMENT PASNY 193,297.11 194,170.65
   TOTAL PREPAYMENT 526,243.22 415,588.00
* ACCOUNTS RECEIVABLE AGING MAY 2008:
RESIDENTIAL AND COMMERCIAL 3,700,887.75
LESS: SALES DISCOUNT LIABILITY (194,649.71)
GENERAL LEDGER BALANCE 3,506,238.04
CURRENT 2,830,466.95 80.72%
30 DAYS 318,688.42 9.09%
60 DAYS 154,499.33 4.41%
90 DAYS 84,217.32 2.40%
OVER 90 DAYS 118,366.02 3.38%
TOTAL 3,506,238.04 100.00%