D
BOROUGH OF SOMERVILLE
SEWER UTILITY FUND
COMPARATIVE BALANCE SHEETS
REGULATORY BASIS
DECEMBER 31, 2021 AND 2020
| ASSETS | REF. | BALANCE DEC. 31, 2021 |
BALANCE DEC. 31, 2020 |
|---|---|---|---|
| Operating Fund: | |||
| Cash and Investments - Treasurer | D-5 | $2,435,244.16 |
$2,169,674.58 |
| Change Fund | 50.00 | ||
| Interfunds Receivable | D-13 | 524,095.80 | 524,095.80 |
| 2,959,339.96 | 2,693,820.38 | ||
| Receivables With Full Reserves: | |||
| Consumer Accounts Receivable | D-8 | 324,421.32 | 316,741.35 |
| Sewer Utility Liens Receivable | D-10 | 1,850.00 | 1,850.00 |
| 326,271.32 | 318,591.35 | ||
| Total Operating Fund | 3,285,611.28 | 3,012,411.73 | |
| Capital Fund: | |||
| Cash and Investments - Treasurer | D-5 | 940,172.93 | 1,109,248.65 |
| Fixed Capital | D-12 | 3,549,877.57 | 3,549,877.57 |
| Fixed Capital - Authorized and | |||
| Uncompleted | D-14 | 4,529,166.23 | 4,529,166.23 |
| Total Capital Fund | 9,019,216.73 | 9,188,292.45 | |
$12,304,828.01 |
$12,200,704.18 |
||
| LIABILITIES, RESERVES AND FUND BALANCE |
REF. | BALANCE DEC. 31, 2021 |
BALANCE DEC. 31, 2020 |
|---|---|---|---|
| Operating Fund: | |||
| Liabilities: | |||
| Appropriation Reserves | D-4, D-11 | $384,517.55 |
$190,173.12 |
| Reserve for Encumbrances | D-4, D-11 | 38,594.10 | 120,048.57 |
| Rent Overpayments | D-9 | 25,154.03 | 25,850.47 |
| Accounts Payable | D-15 | 3,073.57 | - |
| Accrued Interest | D-22 | 4,867.50 | 4,867.50 |
| 456,206.75 | 340,939.66 | ||
| Reserve for Receivables | Reserve | 326,271.32 | 318,591.35 |
| Fund Balance | D-1 | 2,503,133.21 | 2,352,880.72 |
| Total Operating Fund | 3,285,611.28 | 3,012,411.73 | |
| Capital Fund: | |||
| Sewer Bonds Payable | D-23 | 1,020,000.00 | 1,060,000.00 |
| Improvement Authorizations | |||
| Funded | D-16 | 492,707.72 | 403,860.90 |
| Unfunded | D-16 | 3,052,572.92 | 4,037,002.91 |
| Encumbrances Payable | D-16 | 713,578.70 | 87,071.25 |
| Capital Improvement Fund | D-17 | 167,500.00 | 67,500.00 |
| Reserve for Down Payment on Improvements | D-18 | 732.00 | 732.00 |
| Due to Sewer Operating Fund | D-19 | 512,516.76 | 512,516.76 |
| Reserve for Amortization | D-20 | 2,620,727.78 | 2,580,727.78 |
| Deferred Reserve for Amortization | D-21 | 437,816.02 | 372,816.02 |
| Reserve for Payment of Debt Service | 65,000.00 | ||
| Fund Balance | D-2 | 1,064.83 | 1,064.83 |
| Total Capital Fund | 9,019,216.73 | 9,188,292.45 | |
$12,304,828.01 |
$12,200,704.18 |
||