need full and right answer ill rate!

Required information [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. CITY OF BAY LAKE Water Utility Fund Statement of Fund Net Position June 30, 2022 Assets Current assets: Cash and investments Accounts receivable (net of $13,369 provision for uncollectible accounts) Accrued utility revenue Due from General Fund Interest receivable Total current assets Restricted assets! Cash Capital assets: Land $1,781,333 Buildings (net of $3,420,746 in accumulated depreciation) 5,215,545 Machinery and equipment (net of $5,131,048 in accumulated depreciation) 8,490,249 Total capital assets (net) Total Assets Liabilities Current liabilities: Accounts payable Interest payable 532,156 Current portion of long-term debt 131,799 402,000 Total current liabilities Liabilities payable from restricted assets: Customer deposits Long-term liabilities $ 1,775,328 306,915 500,000 29,311 82,000 2,693,554 9,195 15, 487, 127 18, 189,876 1,065,955 9,195 Liabilities payable from restricted assets: Customer deposits Long-term Liabilities: Revenue bond payable Total Liabilities Net Position Net investment in capital assets Unrestricted 9,195 11,658,000 12,733, 150 3,441,813 2,014,913 $5,456,726 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 $2,952,045, $191,883 of the total was billed to the General Fund. 3. Cash in the amount of $257,341 was received. The cosh was for interest earned on investments and $81,162 in accrued interest 4. Expenses accrued for the period were management and administration, $356,724 maintenance and distribution, $682,059, and treatment plant, $688131 5. Cash receipts for customer deposits totaled $2,403 6. Cash collections on customer accounts totaled $2,914,295, of which $207,459 was from the General Fund. 7. Cosh payments for the period were as follows: Accounts Payable, $1,448,132, Interest (which includes the interest payable) $392,001, bond principal, $402,000; machinery and equipment, $586,343; and return of customer deposits, $916 8. A state grant amounting to $477084 was received to help pay for new water treatment equipment 9. Accounts written off as uncollectible totaled $10,057 10. The utility fund transferred $803,516 in excess operating income to the General Fund, 11. Adjusting entries for the period were recorded as follows: depreciation on buildings was $241109 and on machinery and equipment was $361663, the allowance for uncollectible accounts was increased by $14,979, an accrual for unbilled customer receivables was made for $703,098; accrued interest income was $15.919; and accrued interest expense was $61,678 1) The Powenia And Pavahle arcount was all tod hv 42.000 in record the current motion of the hond 9. Accounts written off as uncollectible totaled $10,057. 10. The utility fund transferred $803,516 in excess operating income to the General Fund. 11. Adjusting entries for the period were recorded as follows: depreciation on buildings was $241109 and on machinery and equipment was $361663; the allowance for uncollectible accounts was increased by $14,979; an accrual for unbilled customer receivables was made for $703,098, accrued interest income was $15,919; and accrued interest expense was $61,678, 12. The Revenue Bond Payable account was adjusted by $402,000 to record the current portion of the bond. 13. Closing entries and necessary adjustments were made to the net position accounts. d. Prepare a statement of cash flows for the Water Utility Fund as of June 30, 2023 (Cash outflows should be indicated by a minus sign.) CITY OF BAYLAKE Water Utility Fund Statement of Cash Flows For the Year Ended June 30, 2023 Cash Flows from Operating Activities: Cash Received from Customers Cash Paid To Net Cash Provided by Operations Cash Flows from Noncapital Financing Activities O LHRCHIVES I LLINATIHAN Required information 0 Net Cash Provided by Operations Cash Flows from Noncapital Financing Activities: 0 Net Cash Used by Noncapital Financing Activities Cash Flows from Capital and Related Financing Activities: 0 Net Cash Used by Capital and Related Financing Activities Cash Flows from Investing Activities: 0 Net Increase in Cash and Cash Equivalents Cash and Cash Equivalents, July 1, 2022 Cash and Cash Equivalents, June 30, 2023 $ 0 Reconciliation of Cash and Cash Equivalents to the Balance Sheet End of Year Beginning of Year Cash and Cash Equivalents in Current and Accrued Assets Required information Reconciliation of Cash and Cash Equivalents to the Balance Sheet End of Year Beginning of Year Cash and Cash Equivalents in Current and Accrued Assets Restricted Cash and Cash Equivalents Total Cash and Cash Equivalents $ 0 $ 0 Reconciliation of Operating Income to Net Cash Provided by Operations Operating Income Adjustments Depreciation Expense Uncollectible Accounts Increase in Accounts Receivable Increase in Accrued Utility Revenue Decrease in Due from General Fund Increase in Accounts Payable Net Cash Provided by Operating Activities S Required information [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. CITY OF BAY LAKE Water Utility Fund Statement of Fund Net Position June 30, 2022 Assets Current assets: Cash and investments Accounts receivable (net of $13,369 provision for uncollectible accounts) Accrued utility revenue Due from General Fund Interest receivable Total current assets Restricted assets! Cash Capital assets: Land $1,781,333 Buildings (net of $3,420,746 in accumulated depreciation) 5,215,545 Machinery and equipment (net of $5,131,048 in accumulated depreciation) 8,490,249 Total capital assets (net) Total Assets Liabilities Current liabilities: Accounts payable Interest payable 532,156 Current portion of long-term debt 131,799 402,000 Total current liabilities Liabilities payable from restricted assets: Customer deposits Long-term liabilities $ 1,775,328 306,915 500,000 29,311 82,000 2,693,554 9,195 15, 487, 127 18, 189,876 1,065,955 9,195 Liabilities payable from restricted assets: Customer deposits Long-term Liabilities: Revenue bond payable Total Liabilities Net Position Net investment in capital assets Unrestricted 9,195 11,658,000 12,733, 150 3,441,813 2,014,913 $5,456,726 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 $2,952,045, $191,883 of the total was billed to the General Fund. 3. Cash in the amount of $257,341 was received. The cosh was for interest earned on investments and $81,162 in accrued interest 4. Expenses accrued for the period were management and administration, $356,724 maintenance and distribution, $682,059, and treatment plant, $688131 5. Cash receipts for customer deposits totaled $2,403 6. Cash collections on customer accounts totaled $2,914,295, of which $207,459 was from the General Fund. 7. Cosh payments for the period were as follows: Accounts Payable, $1,448,132, Interest (which includes the interest payable) $392,001, bond principal, $402,000; machinery and equipment, $586,343; and return of customer deposits, $916 8. A state grant amounting to $477084 was received to help pay for new water treatment equipment 9. Accounts written off as uncollectible totaled $10,057 10. The utility fund transferred $803,516 in excess operating income to the General Fund, 11. Adjusting entries for the period were recorded as follows: depreciation on buildings was $241109 and on machinery and equipment was $361663, the allowance for uncollectible accounts was increased by $14,979, an accrual for unbilled customer receivables was made for $703,098; accrued interest income was $15.919; and accrued interest expense was $61,678 1) The Powenia And Pavahle arcount was all tod hv 42.000 in record the current motion of the hond 9. Accounts written off as uncollectible totaled $10,057. 10. The utility fund transferred $803,516 in excess operating income to the General Fund. 11. Adjusting entries for the period were recorded as follows: depreciation on buildings was $241109 and on machinery and equipment was $361663; the allowance for uncollectible accounts was increased by $14,979; an accrual for unbilled customer receivables was made for $703,098, accrued interest income was $15,919; and accrued interest expense was $61,678, 12. The Revenue Bond Payable account was adjusted by $402,000 to record the current portion of the bond. 13. Closing entries and necessary adjustments were made to the net position accounts. d. Prepare a statement of cash flows for the Water Utility Fund as of June 30, 2023 (Cash outflows should be indicated by a minus sign.) CITY OF BAYLAKE Water Utility Fund Statement of Cash Flows For the Year Ended June 30, 2023 Cash Flows from Operating Activities: Cash Received from Customers Cash Paid To Net Cash Provided by Operations Cash Flows from Noncapital Financing Activities O LHRCHIVES I LLINATIHAN Required information 0 Net Cash Provided by Operations Cash Flows from Noncapital Financing Activities: 0 Net Cash Used by Noncapital Financing Activities Cash Flows from Capital and Related Financing Activities: 0 Net Cash Used by Capital and Related Financing Activities Cash Flows from Investing Activities: 0 Net Increase in Cash and Cash Equivalents Cash and Cash Equivalents, July 1, 2022 Cash and Cash Equivalents, June 30, 2023 $ 0 Reconciliation of Cash and Cash Equivalents to the Balance Sheet End of Year Beginning of Year Cash and Cash Equivalents in Current and Accrued Assets Required information Reconciliation of Cash and Cash Equivalents to the Balance Sheet End of Year Beginning of Year Cash and Cash Equivalents in Current and Accrued Assets Restricted Cash and Cash Equivalents Total Cash and Cash Equivalents $ 0 $ 0 Reconciliation of Operating Income to Net Cash Provided by Operations Operating Income Adjustments Depreciation Expense Uncollectible Accounts Increase in Accounts Receivable Increase in Accrued Utility Revenue Decrease in Due from General Fund Increase in Accounts Payable Net Cash Provided by Operating Activities S