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 |