5.1c ERMUSR 02-14-2023ELK RIVER MUNICIPAL UTILITIES
ELK RIVER, MINNESOTA
WATER BALANCE SHEET
Current Month
Change from
December 31, 2022
November 30, 2022
Prior Month
ASSETS
CURRENT ASSETS
CASH
8,713,701
10,287,364
(1,573,664)
ACCOUNTS RECEIVABLE
476,569
514,788
(38,219)
INVENTORIES
28,388
29,463
(1,075)
PREPAID ITEMS
53,748
51,580
2,168
CONSTRUCTION IN PROGRESS
942,826
966,592
(23,766)
TOTAL CURRENT ASSETS
10,215,231
11,849,788
(1,634,556)
RESTRICTED ASSETS
EMERGENCY RESERVE FUND
1,353,860
1,346,524
7,336
TOTAL RESTRICTED ASSETS
1,353,860
1,346,524
7,336
FIXED ASSETS
PRODUCTION
16,510,965
14,962,754
1,548,211
DISTRIBUTION
26,461,173
25,751,342
709,831
GENERAL
1,122,302
1,081,462
40,840
FIXED ASSETS (COST)
44,094,440
41,795,558
2,298,882
LESS ACCUMULATED DEPRECIATION
(22,101,213)
(22,003,222)
(97,991)
TOTAL FIXED ASSETS, NET
21,993,226
19,792,335
2,200,891
INTANGIBLE ASSETS
OTHER ASSETS AND DEFERRED OUTFLOWS
266,964
266,964
0
TOTAL ASSETS
33,829,282
33,255,611
573,671
LIABILITIES AND FUND EQUITY
CURRENT LIABILITIES
ACCOUNTS PAYABLE
538,040
561,107
(23,068)
SALARIES AND BENEFITS PAYABLE
150,472
143,795
6,677
DUE TO CITY
24,643
2,198
22,445
BONDS PAYABLE -CURRENT PORTION
60,000
0
60,000
UNEARNED REVENUE
141,184
161,214
(20,031)
TOTAL CURRENT LIABILITIES
914,339
868,315
46,024
LONG TERM LIABILITIES
DUE TO CITY
0
22,680
(22,680)
BONDS PAYABLE, LESS CURRENT PORTION
1,628,596
1,689,151
(60,554)
PENSION LIABILITIES
369,988
369,988
0
TOTAL LONG TERM LIABILITIES
1,998,584
2,081,819
(83,234)
TOTAL LIABILITIES
2,912,924
2,950,133
(37,210)
DEFERRED INFLOWS OF RESOURCES
339,354
339,354
0
FUND EQUITY
RETAINED EARNINGS
28,234,009
28,234,009
0
NET INCOME (LOSS) (THROUGH PREVIOUS MONTH)
2,342,996
1,732,115
610,881
TOTAL FUND EQUITY
30,577,005
29,966,124
610,881
TOTAL LIABILITIES & FUND EQUITY
33,829,282
33,255,611
573,671
65