D

BOROUGH OF SOMERVILLE

SEWER UTILITY FUND

COMPARATIVE BALANCE SHEETS

REGULATORY BASIS

DECEMBER 31, 2022 AND 2021

ASSETS REF. BALANCE
DEC. 31, 2022
BALANCE
DEC. 31, 2021
Operating Fund:
Cash and Investments - Treasurer D-5
$3,394,704.75
$2,435,244.16
Interfunds Receivable D-12
524,095.80
524,095.80
3,918,800.55
2,959,339.96
Receivables With Full Reserves:
Consumer Accounts Receivable D-7
157,871.15
324,421.32
Sewer Utility Liens Receivable D-9
1,850.00
1,850.00
159,721.15
326,271.32
Total Operating Fund
4,078,521.70
3,285,611.28
Capital Fund:
Cash and Investments - Treasurer D-5, D-6
684,656.18
940,172.93
Fixed Capital D-11
3,549,877.57
3,549,877.57
Fixed Capital Authorized and Uncompleted D-13
4,529,166.23
4,529,166.23
Total Capital Fund
8,763,699.98
9,019,216.73
$12,842,221.68
$12,304,828.01
LIABILITIES, RESERVES
AND FUND BALANCE
REF. BALANCE
DEC. 31, 2022
BALANCE
DEC. 31, 2021
Operating Fund:
Liabilities:
Appropriation Reserves D-4 ,D-10
$854,189.70
$384,517.55
Reserve for Encumbrances D-4 ,D-10
101,612.19
38,594.10
Rent Overpayments D-8
12,006.99
25,154.03
Accounts Payable D-14
3,073.57
3,073.57
Accrued Interest D-21
4,450.00
4,867.50
975,332.45
456,206.75
Reserve for Receivables Reserve
159,721.15
326,271.32
Fund Balance D-1
2,943,468.10
2,503,133.21
Total Operating Fund
4,078,521.70
3,285,611.28
Capital Fund:
Sewer Bonds Payable D-22
960,000.00
1,020,000.00
Improvement Authorizations:
Funded D-15
391,849.89
492,707.72
Unfunded D-15
3,323,369.95
3,052,572.92
Encumbrances Payable D-15
188,122.75
713,578.70
Capital Improvement Fund D-16
267,500.00
167,500.00
Reserve for Down Payment on Improvements D-17
732.00
732.00
Due to Sewer Operating Fund D-18
512,516.76
512,516.76
Reserve for Amortization D-19
2,889,043.80
2,620,727.78
Deferred Reserve for Amortization D-20
229,500.00
437,816.02
Fund Balance D-2
1,064.83
1,064.83
Total Capital Fund
8,763,699.98
9,019,216.73
$12,842,221.68
$12,304,828.01
Bonds and Notes Authorized But Not Issued D-23
$4,000,500.00
$4,000,500.00

The accompanying Notes to the Financial Statements are an integral part of this statement.

19