Required information

Skip to question

[The following information applies to the questions displayed below.]

Following is the June 30, 2022, statement of net position for the City of Bay Lake Water Utility Fund.

2 Part 2 of 4 10 points $1,776,055 307,031 499,800 29,388 81,970 2,694,156 Cash 9,199 eBook Following is the June 30, 2022 statement of net position for the City of Bay Lake Water Utility Fund. CITY OF BAY LAKE Water Utility Fund Statement of Fund Net Position June 30, 2822 Assets Current assets: Cash and investments Accounts receivable (net of $13,374 provision for uncollectible accounts) Accrued utility revenue Due from General Fund Interest receivable Total current assets Restricted assets: Capital assets: Land $1,782,111 Buildings (net of $3,422,246 in accumulated depreciation) 5,217,836 Machinery and equipment (net of $5,133, 3es in accumulated depreciation) 8,493,989 Total capital assets (net) Total Assets Liabilities Current liabilities: Accounts payable 532,374 Interest payable 131,852 Current portion of long-term debt 392.ee Total current liabilities Liabilities payable from restricted assets: Customer deposits Long-term liabilities: Revenue bond payable Total Liabilities Net Position Net investment in capital assets Unrestricted Print 15,493,936 18, 197, 291 References 1,856, 226 9,199 11,368,080 12,433,425 3,796,383 1,967,483 $ 5,763,866 Following is the information of the Water Utility Fund for fiscal year 2023. 1. The amount in the Accrued Utility Revenue account was reversed. 2. Billings to customers for water usage during fiscal year 2023 totaled $3,118,206; $202.682 of the total was billed to the General Fund. 3. Cash in the amount of $271.824 was received. The cash was for interest earned on investments and $85,727 in accrued interest 4. Expenses accrued for the period were management and administration, $376.787. maintenance and distribution. $720,418; and treatment plant. $726,833. 5. Cash receipts for customer deposits totaled $2,541. 6. Cash collections on customer accounts totaled $3.081.661, of which $219.376 was from the General Fund. 7. Cash payments for the period were as follows: Accounts Payable. $1.531,312, interest (which includes the interest payable). $414.513: bond principal. $392.000; machinery and equipment. $571758; and return of customer deposits. $893. 8. A state grant amounting to $465.105 was received to help pay for new water treatment equipment. 9. Accounts written off as uncollectible totaled $9,805. 10. The utility fund transferred $783.382 in excess operating income to the General Fund. 11. Adjusting entries for the period were recorded as follows: depreciation on buildings was $235.068 and on machinery and equipment was $352,602: the allowance for uncollectible accounts was increased by $14.604; an accrual for unbilled customer receivables was made for $685.496; accrued interest income was $15,520; and accrued interest expense was $60,132 12. The Revenue Bond Payable account was adjusted by $392,000 to record the current portion of the bond. 13. Closing entries and necessary adjustments were made to the net position accounts. Print b. Prepare a statement of revenues, expenses and changes in fund net position for the Water Utility Fund for the year ended June 30. 2023. (Deductions should be indicated by a minus sign.) References CITY OF BAY LAKE Water Utility Fund Statement of Revenue, Expenses, and Changes in Fund Net Position For The Year Ended June 30, 2023 Operating Income: Operating Expenses: Total Operating Expenses 00 Nonoperating Revenue/Expenses 0 Total Nonoperating Revenue Expenses Income Before Transfers and Contributions Interfund Transfers Out Capital Contributions Change in Net Position Net Position, July 1, 2022 Net Position, June 30, 2023 0 $ 0