Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help figuring problems c and d. Its super helpful to see the work as well thanks! d. Prepare a statement of cash flows for

Need help figuring problems c and d. Its super helpful to see the work as well thanks!

image text in transcribed

image text in transcribed

image text in transcribed

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.)

image text in transcribed

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,014,773;$195,960 of the total was billed to the General Fund. 3. Cash in the amount of $262,809 was received. The cash was for interest earned on investments and $82,886 in accrued interest. 4. Expenses accrued for the period were management and administration, $364,299; maintenance and distribution, $696,542; and treatment plant, $702,745. 5. Cash receipts for customer deposits totaled $2,457. 6. Cash collections on customer accounts totaled $2,979,787, of which $212,122 was from the General Fund. 7. Cash payments for the period were as follows: Accounts Payable, $1,480,678; interest (which includes the interest payable), $400,809; bond principal, $398,000; machinery and equipment, $580,512; and return of customer deposits, $905. 8. A state grant amounting to $471,357 was received to help pay for new water treatment equipment. 9. Accounts written off as uncollectible totaled $9,937. 10. The utility fund transferred $793,930 in excess operating income to the General Fund. 11. Adjusting entries for the period were recorded as follows: depreciation on buildings was $238,236 and on machinery and equipment was $357,354; the allowance for uncollectible accounts was increased by $14,802; an accrual for unbilled customer receivables was made for $694,790; accrued interest income was $15,730; and accrued interest expense was $60,948. 12. The Revenue Bond Payable account was adjusted by $398,000 to record the current portion of the bond. 13. Closing entries and necessary adjustments were made to the net position accounts. Prenare a ctatement nf net noeition for the Mater l ltilitu Fiund as af lune 20 on 23. 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,014,773;$195,960 of the total was billed to the General Fund. 3. Cash in the amount of $262,809 was received. The cash was for interest earned on investments and $82,886 in accrued interest. 4. Expenses accrued for the period were management and administration, $364,299; maintenance and distribution, $696,542; and treatment plant, $702,745. 5. Cash receipts for customer deposits totaled $2,457. 6. Cash collections on customer accounts totaled $2,979,787, of which $212,122 was from the General Fund. 7. Cash payments for the period were as follows: Accounts Payable, $1,480,678; interest (which includes the interest payable), $400,809; bond principal, $398,000; machinery and equipment, $580,512; and return of customer deposits, $905. 8. A state grant amounting to $471,357 was received to help pay for new water treatment equipment. 9. Accounts written off as uncollectible totaled $9,937. 10. The utility fund transferred $793,930 in excess operating income to the General Fund. 11. Adjusting entries for the period were recorded as follows: depreciation on buildings was $238,236 and on machinery and equipment was $357,354; the allowance for uncollectible accounts was increased by $14,802; an accrual for unbilled customer receivables was made for $694,790; accrued interest income was $15,730; and accrued interest expense was $60,948. 12. The Revenue Bond Payable account was adjusted by $398,000 to record the current portion of the bond. 13. Closing entries and necessary adjustments were made to the net position accounts. Prenare a ctatement nf net noeition for the Mater l ltilitu Fiund as af lune 20 on 23

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Codes Of Finance

Authors: Vincent Antonin Lépinay

1st Edition

0691151504, 978-0691151502

More Books

Students also viewed these Finance questions