5.1c ERMUSR 06-13-2023ELK RIVER MUNICIPAL UTILITIES
ELK RIVER, MINNESOTA
WATER BALANCE SHEET
Current Month
Change from
April 30, 2023
March 31, 2023
Prior Month
ASSETS
CURRENT ASSETS
CASH
8,513,001
8,381,529
131,473
ACCOUNTS RECEIVABLE
5,470,859
5,696,716
(225,857)
INVENTORIES
25,250
29,273
(4,023)
PREPAID ITEMS
49,378
71,603
(22,225)
CONSTRUCTION IN PROGRESS
974,872
940,617
34,254
TOTAL CURRENT ASSETS
15,033,360
15,119,738
(86,378)
RESTRICTED ASSETS
EMERGENCY RESERVE FUND
1,358,160
1,356,176
1,984
TOTAL RESTRICTED ASSETS
1,358,160
1,356,176
1,984
FIXED ASSETS
PRODUCTION
16,525,311
16,510,965
14,346
DISTRIBUTION
26,766,971
26,729,422
37,550
GENERAL
1,129,389
1,117,615
11,774
FIXED ASSETS (COST)
44,421,670
44,358,001
63,670
LESS ACCUMULATED DEPRECIATION
(22,489,038)
(22,391,401)
(97,637)
TOTAL FIXED ASSETS, NET
21,932,632
21,966,600
(33,968)
INTANGIBLE ASSETS
OTHER ASSETS AND DEFERRED OUTFLOWS
226,587
226,587
0
TOTAL ASSETS
38,550,739
38,669,101
(118,362)
LIABILITIES AND FUND EQUITY
CURRENT LIABILITIES
ACCOUNTS PAYABLE
287,510
298,718
(11,209)
SALARIES AND BENEFITS PAYABLE
118,914
132,207
(13,293)
DUE TO CITY
1,658
915
743
BONDS PAYABLE -CURRENT PORTION
60,000
60,000
0
UNEARNED REVENUE
174,926
174,926
0
TOTAL CURRENT LIABILITIES
643,007
666,767
(23,759)
LONG TERM LIABILITIES
BONDS PAYABLE, LESS CURRENT PORTION
1,626,379
1,626,934
(554)
PENSION LIABILITIES
725,038
725,038
0
TOTAL LONG TERM LIABILITIES
2,351,417
2,351,972
(554)
TOTAL LIABILITIES
2,994,425
3,018,738
(24,314)
DEFERRED INFLOWS OF RESOURCES
5,121,831
5,121,831
0
FUND EQUITY
RETAINED EARNINGS
30,887,406
30,887,406
0
NET INCOME (LOSS) (THROUGH PREVIOUS MONTH)
(452,923)
(358,874)
(94,048)
TOTAL FUND EQUITY
30,434,483
30,528,532
(94,048)
TOTAL LIABILITIES & FUND EQUITY
38,550,739
38,669,101
(118,362)
145