Question

The Town of Weston has a Water Utility Fund with the following trial balance as of...

The Town of Weston has a Water Utility Fund with the following trial balance as of July 1, 2019, the first day of the fiscal year:

Debits Credits
Cash $ 349,000
Customer accounts receivable 211,400
Allowance for uncollectible accounts $ 31,900
Materials and supplies 132,000
Restricted assets (cash) 267,000
Utility plant in service 7,031,000
Accumulated depreciation—utility plant 2,631,000
Construction work in progress 119,000
Accounts payable 142,800
Accrued expenses payable 98,500
Revenue bonds payable 3,531,000
Net position 1,674,200
Totals $ 8,109,400 $ 8,109,400


During the year ended June 30, 2020, the following transactions and events occurred in the Town of Weston Water Utility Fund:

  1. Accrued expenses at July 1 were paid in cash.
  2. Billings to nongovernmental customers for water usage for the year amounted to $1,466,000; billings to the General Fund amounted to $125,000.
  3. Liabilities for the following were recorded during the year:
Materials and supplies $ 216,000
Costs of sales and services 390,000
Administrative expenses 218,000
Construction work in progress 237,000
  1. Materials and supplies were used in the amount of $300,000, all for costs of sales and services.
  2. After collection efforts were unsuccessful, $15,600 of old accounts receivable were written off.
  3. Accounts receivable collections totaled $1,570,000 from nongovernmental customers and $53,200 from the General Fund.
  4. $1,137,400 of accounts payable were paid in cash.
  5. One year’s interest in the amount of $192,600 was paid.
  6. Construction was completed on plant assets costing $267,000; that amount was transferred to Utility Plant in Service.
  7. Depreciation was recorded in the amount of $277,100.
  8. The Allowance for Uncollectible Accounts was increased by $11,000.
  9. As required by the loan agreement, cash in the amount of $119,000 was transferred to Restricted Assets for eventual redemption of the bonds.
  10. Accrued expenses, all related to costs of sales and services, amounted to $119,000.
  11. Nominal accounts for the year were closed.


Required:
a. Record the transactions for the year in general journal form.
b. Prepare a Statement of Revenues, Expenses, and Changes in Fund Net Position.
c. Prepare a Statement of Net Position as of June 30, 2020.
d. Prepare a Statement of Cash Flows for the year ended June 30, 2020. Assume all debt and interest are related to capital outlay. Assume the entire construction work in progress liability (see item 3) was paid in entry 7. Include restricted assets as cash and cash equivalents.

0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1


Town of Weston Journal Enteries Trans. Particulars i Accrued Expenses a/c To Cash Dr. Debit in $ Credit in $ 98500 98500 Cust

1580000 Statement of Revenues, Expenses and Changes In Fund Net Position For the Year ended 30.6.2020 Operating Revenues Char

Statement of Net Position As at 30.6.2020 Assets Current and Accrued Assets Cash Customer Accounts Receivable Less:Allowance

> Cash flow missing

Sanu Mon, Feb 14, 2022 10:28 AM

Add a comment
Know the answer?
Add Answer to:
The Town of Weston has a Water Utility Fund with the following trial balance as of...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • The Town of Weston has a Water Utility Fund with the following trial balance as of...

    The Town of Weston has a Water Utility Fund with the following trial balance as of July 1, 2016, the first day of the fiscal year: Debits Credits Cash $ 338,000 Customer accounts receivable 204,800 Allowance for uncollectible accounts $ 30,800 Materials and supplies 123,200 Restricted assets (cash) 256,000 Utility plant in service 7,009,000 Accumulated depreciation—utility plant 2,609,000 Construction work in progress 108,000 Accounts payable 129,600 Accrued expenses payable 81,100 Revenue bonds payable 3,509,000 Net position 1,679,500 Totals $ 8,039,000...

  • The Town of Weston has a Water Utility Fund with the following trial balance as of...

    The Town of Weston has a Water Utility Fund with the following trial balance as of July 1, 2019, the first day of the fiscal year: Credits Debits $ 333,000 201,800 121,200 253,000 7,004,000 $ 30,300 Cash Customer accounts receivable Allowance for uncollectible accounts Materials and supplies Restricted assets (cash) Utility plant in service Accumulated depreciation-utility plant Construction work in progress Accounts payable Accrued expenses payable Revenue bonds payable Net position Totals 2,603,000 103,000 123,600 77,300 3,503,000 1,678,800 $8,016,000 $8,016,000...

  • The Town of Weston has a Water Utility Fund with the following trial balance as of...

    The Town of Weston has a Water Utility Fund with the following trial balance as of July 1, 2016, the first day of the fiscal year: Credits $ Debits 337,000 204,200 $ 30,700 122,800 255,000 7,007,000 Cash Customer accounts receivable Allowance for uncollectible accounts Materials and supplies Restricted assets (cash) Utility plant in service Accumulated depreciation-utility plant Construction work in progress Accounts payable Accrued expenses payable Revenue bonds payable Net position Totals 2,607,000 107,000 128,400 80, 300 3,507,000 1,679,600 $8,033,000...

  • The Town of Weston has a Water Utility Fund with the following trial balance as of...

    The Town of Weston has a Water Utility Fund with the following trial balance as of July 1, 2016, the first day of the fiscal year: Debits Credits Cash $ 337,000 Customer accounts receivable 204,200 Allowance for uncollectible accounts $ 30,700 Materials and supplies 122,800 Restricted assets (cash) 255,000 Utility plant in service 7,007,000 Accumulated depreciation—utility plant 2,607,000 Construction work in progress 107,000 Accounts payable 128,400 Accrued expenses payable 80,300 Revenue bonds payable 3,507,000 Net position 1,679,600 Totals $ 8,033,000...

  • I just need help with the statement of cash flow Required: a. Record the transactions for...

    I just need help with the statement of cash flow Required: a. Record the transactions for the year in general journal form. b. Prepare a Statement of Revenues, Expenses, and Changes in Fund Net Position. c. Prepare a Statement of Net Position as of June 30, 2020. d. Prepare a Statement of Cash Flows for the year ended June 30, 2020. Assume all debt and interest are related to capital outlay. Assume the entire construction work in progress liability (see...

  • 6–C. Part 1. Internal Service Fund Transactions The Stores and Service Fund of the City of...

    6–C. Part 1. Internal Service Fund Transactions The Stores and Service Fund of the City of Monroe had the following account balances as of January 1, 2017: Debits Credits Cash $28,000 Due from other funds 27,000 Inventory of supplies 27,500 Land 18,000 Buildings 84,000 Accumulated depreciation—buildings $30,000 Equipment 46,000 Accumulated depreciation—equipment 25,000 Accounts payable 19,000 Advance from water utility fund 30,000 Net position 126,500 Totals $230,500 $230,500 Required: a. Open a general journal for the City of Monroe Stores and...

  • Required: a. Open a general journal for the City of Monroe Stores and Service Fund and record the...

    Required: a. Open a general journal for the City of Monroe Stores and Service Fund and record the following transactions. (1) A budget was prepared for FY 2017. It was estimated that the price charged other departments for supplies should be 1.25% of cost to achieve the desired breakeven for the year. (2) The amount due from other funds as of January 1, 2017, was collected in full. (3) During the year, supplies were ordered and received in the amount...

  • $ 1,775,142 | 306,870 499,600 29, 288 81,936 2,692,836 9,194 CITY OF BAY LAKE Water Utility...

    $ 1,775,142 | 306,870 499,600 29, 288 81,936 2,692,836 9,194 CITY OF BAY LAKE Water Utility Fund Statement of Fund Net Position June 30, 2019 Assets Current assets: Cash and investments Accounts receivable (net of $13,367 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,420,381 in accumulated depreciation) Machinery and equipment (net of $5,130,505 in accumulated depreciation) Total capital assets (net) Total Assets...

  • The Following is the June 30, 2019, statement of net position for the City of Bay...

    The Following is the June 30, 2019, 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, 2019 Assets Current assets: Cash and investments $ 1,774,824 Accounts receivable (net of $13,365 provision for uncollectible accounts) 306,824 Accrued utility revenue 499,600 Due from General Fund 29,288 Interest receivable 81,936 Total current assets 2,692,472 Restricted assets: Cash 9,192 Capital assets: Land $ 1,780,753 Buildings (net...

  • The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31,...

    The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Debits Credits Accounts payable $ 119,000 Accounts receivable $ 32,900 Accrued interest payable 36,100 Accumulated depreciation 54,500 Administrative and selling expenses 56,500 Allowance for uncollectible accounts 14,100 Capital assets 736,000 Cash 100,100 Charges for sales and services 583,000 Cost of sales and...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT