Can you please help explain how to calculate the missing items? Interest Receivable Machinery & Equipment Accounts Payable Net Investment in Capital Assets Unrestricted

$ 1,775,021 307,30 500,100 29,317 82.217 9,190 Required information [The following information applies to the questions olisplayed below.) 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 et Position June 30, 2022 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 Cash Capital assets: Land Buildings (net of $3,422,238 in accumulated depreciation) 5,217,821 Machinery and equipment (het of $5,133,238 in accumulated depreciation) 8,603.952 Total capital assets (net) Total Assets Liabilities Current liabilities: Accounts payable 532,380 Interest payable 131.855 Current portion of long-term debit 46,00 Total current alte Liabilities payable from restricted assets: Customer deposits Long-term liabilities: Revenue bond payable Total Liabilities Net Position Net investment in capital assets Unrestricted 15,493,882 18,197,571 1,020,235 9.190 11,774,820 12,653,434 3,310,191 2.633.246 $ 5,344, 137 Following is the information of the Water Uerility Fund for fiscal year 2023 2 The amount in the Accrued Utility Revenue account was reversed. 2 Billings to customers for water usage during fiscal year 2023 totaled $2,091,136: $197.924 of the total wes billed to the General Fund 3. Cash in the amount of $252.032 was received. The cash was for interest eamed on Investments and $79.499 in accrued Interest 4 Expenses accrued for the period were management and similaretion, $349,365, maintenance and distribution, $667,998; and treatment plant. $673,936. 5. Cash receipts for customer deposits totaled $2.355. 6. Cash collections on customer accounts totaled $2,856,093, of which $203.315 was from the General Fund 7. Cash payments for the period were as follows: Accounts Payable $1.419.204: Interest (which includes the Interest payable $394169; band principal, $406.000; machinery and equipment, $592,179, and return of customer deposit $924 8. A state grant amounting to $481,252 vas received to help pay for new water treatment equipment 9. Accounts written off as uncollectible totaled $10.145. 10. The ulty fund transferred $10.549 in excess operating Income to the General Fund IL Adjusting entries for the period were recorded as follows: depreciation on buildings was $243.221 and on machinery and equipment was $364,831; the allowance for uncollect ble accounts was increased by $15,111 an accrual for unbilled customer receivables was made for $709294: accrued Interest Income wes $16,059, and accrued Interest expense was $62222 12 The Revenue Bond Payable account was adjusted by $406,000 to record the current portion of the bond 13. Closing entries and necessary scjustments were made to the net position accounts. Answer is not complete. CITY OF BAY LAKE Water Utility Fund Statement of Net Position June 30, 2023 Assets $ 1,753.288 Current Assets: Cash and Investments Accounts Receivable Accrued Utility Revenue Due from General Fund Interest Receivable OOOO 342,363 709,294 13.926 $ 2.818,871 > 10.630 Total Current Assets Restricted Assets: Cash Capital Assets Land Buildings Machinery and Equipment OOO $ 1,782,109 4,974,600 Total Capital Assets Total Assets 6.756,709 $ 9,586.210 Liabilities Current Liabilities: Accounts Payable Interest Payable Current Portion of Long-Term Debt OOO 62.222 400,000 468,222 > 10,630 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 Total Net Position 11,368,000 $11.846,852 0 $ 1,775,021 307,30 500,100 29,317 82.217 9,190 Required information [The following information applies to the questions olisplayed below.) 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 et Position June 30, 2022 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 Cash Capital assets: Land Buildings (net of $3,422,238 in accumulated depreciation) 5,217,821 Machinery and equipment (het of $5,133,238 in accumulated depreciation) 8,603.952 Total capital assets (net) Total Assets Liabilities Current liabilities: Accounts payable 532,380 Interest payable 131.855 Current portion of long-term debit 46,00 Total current alte Liabilities payable from restricted assets: Customer deposits Long-term liabilities: Revenue bond payable Total Liabilities Net Position Net investment in capital assets Unrestricted 15,493,882 18,197,571 1,020,235 9.190 11,774,820 12,653,434 3,310,191 2.633.246 $ 5,344, 137 Following is the information of the Water Uerility Fund for fiscal year 2023 2 The amount in the Accrued Utility Revenue account was reversed. 2 Billings to customers for water usage during fiscal year 2023 totaled $2,091,136: $197.924 of the total wes billed to the General Fund 3. Cash in the amount of $252.032 was received. The cash was for interest eamed on Investments and $79.499 in accrued Interest 4 Expenses accrued for the period were management and similaretion, $349,365, maintenance and distribution, $667,998; and treatment plant. $673,936. 5. Cash receipts for customer deposits totaled $2.355. 6. Cash collections on customer accounts totaled $2,856,093, of which $203.315 was from the General Fund 7. Cash payments for the period were as follows: Accounts Payable $1.419.204: Interest (which includes the Interest payable $394169; band principal, $406.000; machinery and equipment, $592,179, and return of customer deposit $924 8. A state grant amounting to $481,252 vas received to help pay for new water treatment equipment 9. Accounts written off as uncollectible totaled $10.145. 10. The ulty fund transferred $10.549 in excess operating Income to the General Fund IL Adjusting entries for the period were recorded as follows: depreciation on buildings was $243.221 and on machinery and equipment was $364,831; the allowance for uncollect ble accounts was increased by $15,111 an accrual for unbilled customer receivables was made for $709294: accrued Interest Income wes $16,059, and accrued Interest expense was $62222 12 The Revenue Bond Payable account was adjusted by $406,000 to record the current portion of the bond 13. Closing entries and necessary scjustments were made to the net position accounts. Answer is not complete. CITY OF BAY LAKE Water Utility Fund Statement of Net Position June 30, 2023 Assets $ 1,753.288 Current Assets: Cash and Investments Accounts Receivable Accrued Utility Revenue Due from General Fund Interest Receivable OOOO 342,363 709,294 13.926 $ 2.818,871 > 10.630 Total Current Assets Restricted Assets: Cash Capital Assets Land Buildings Machinery and Equipment OOO $ 1,782,109 4,974,600 Total Capital Assets Total Assets 6.756,709 $ 9,586.210 Liabilities Current Liabilities: Accounts Payable Interest Payable Current Portion of Long-Term Debt OOO 62.222 400,000 468,222 > 10,630 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 Total Net Position 11,368,000 $11.846,852 0