TOWN OF READING, MASSACHUSETTS
MUNICIPAL LIGHT DEPARTMENT
SCHEDULE OF ACCOUNTS RECEIVABLE
12/31/07
SCHEDULE B
PREVIOUS YEAR CURRENT YEAR
SCHEDULE OF ACCOUNTS RECEIVABLE
RESIDENTIAL AND COMMERCIAL 4,347,214.00 5,632,707.30
ACCOUNTS RECEIVABLE - OTHER 259,346.18 213,624.01
ACCOUNTS RECEIVABLE - LIENS 85,842.07 103,680.05
ACCOUNTS RECEIVABLE - EMPLOYEE ADVANCES 1,067.16 1,067.16
SALES DISCOUNT LIABILITY (282,540.07) (302,818.84)
RESERVE FOR UNCOLLECTIBLE ACCOUNTS (206,167.95) (218,218.26)
   TOTAL ACCOUNTS RECEIVABLE BILLED 4,204,761.39 5,430,041.42
UNBILLED ACCOUNTS RECEIVABLE 3,126,031.41 2,714,176.30
   TOTAL ACCOUNTS RECEIVABLE, NET 7,330,792.80 8,144,217.72
SCHEDULE OF PREPAYMENTS
PREPAID INSURANCE 1,592,069.80 1,624,038.08
PREPAYMENT PURCHASED POWER 337,965.90 144,854.92
PREPAYMENT PASNY 193,297.11 194,170.65
   TOTAL PREPAYMENT 2,123,332.81 1,963,063.65
* ACCOUNTS RECEIVABLE AGING CURRENT YEAR:
RESIDENTIAL AND COMMERCIAL 4,989,817.08
LESS: SALES DISCOUNT LIABILITY (327,940.81)
GENERAL LEDGER BALANCE 4,661,876.27
CURRENT 4,157,203.63 88.73%
30 DAYS 322,960.43 6.89%
60 DAYS 114,446.88 2.44%
90 DAYS 55,269.01 1.18%
OVER 90 DAYS 35,643.24 0.76%
TOTAL 4,685,523.19 100.00%