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, 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 $ 8,033,000


During the year ended June 30, 2017, 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,386,000; billings to the General Fund amounted to $112,000.
  3. Liabilities for the following were recorded during the year:
Materials and supplies $ 192,000
Costs of sales and services 366,000
Administrative expenses 206,000
Construction work in progress 225,000
  1. Materials and supplies were used in the amount of $282,000, all for costs of sales and services.
  2. $14,400 of old accounts receivable were written off.
  3. Accounts receivable collections totaled $1,503,600 from nongovernmental customers and $49,600 from the General Fund.
  4. $1,060,600 of accounts payable were paid in cash.
  5. One year’s interest in the amount of $179,400 was paid.
  6. Construction was completed on plant assets costing $255,000; that amount was transferred to Utility Plant in Service.
  7. Depreciation was recorded in the amount of $265,100.
  8. Interest in the amount of $25,500 was reclassified to Construction Work in Progress. (This was previously paid in item 8.)
  9. The Allowance for Uncollectible Accounts was increased by $10,000.
  10. As required by the loan agreement, cash in the amount of $107,000 was transferred to Restricted Assets for eventual redemption of the bonds.
  11. Accrued expenses, all related to costs of sales and services, amounted to $95,000.
  12. Nominal accounts for the year were closed.

Prepare a Statement of Net Position as of June 30, 2017. (Deductions should be entered as a negative amount.)

TOWN OF WESTON
WATER UTILITY FUND
Statement of Net Position
As of June 30, 2017
Assets:
Current and Accrued Assets:
Customer Accounts Receivable
Allowance for Uncollectible Accounts
0
Total Current and Accrued Assets $0
Other Property and Investments:
Utility Plant:
Utility Plant-Net 0
Net Utility Plant 0
Total Assets $0
Liabilities:
Current Liabilities:
Total Current Liabilities 0
Long-Term Debt:
Total Liabilities 0
Net Position:
Total Net Position $0

Prepare a Statement of Cash Flows for the year ended June 30, 2017. 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. (Deductions should be entered as a negative amount.)

TOWN OF WESTON
WATER UTILITY FUND
Statement of Cash Flows
For the Year Ended June 30, 2017
Cash Flows From Operating Activities:
0
Cash Flows From Capital and Related Financing Activities:
0
Cash and Cash Equivalents, July 1, 2016
Cash and Cash Equivalents, June 30, 2017 $0
Reconciliation of Operating Income to Net Cash Provided by Operating Activities:
Adjustments:
Total Adjustments 0
$0
2 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

A Statement of Net Position as of June 30, 2017.

Assets Debit Credit Balance
Current and Accrued Assets
Cash(337000-80300+(1503600+49600)-1060600-107000-179400) 462900
Customer Accounts Receivable(204200+1386000-1503600-14400) 72200
Less: allowance for uncollectable accounts(30700-14400+10000) 26300 45900
Due from general fund(112000-49600) 62400
Material & Supplies(122800+192000-282000) 32800
Total Current & Accrued Assets 604000
Other Property & Investments
Restricted Assets(255000+107000) 362000
Utility Plant
Utlity plant in service(7,007,000+255,000) 7262000
Less: Accumulated Depreciation(2607000+265000) 2872100
Utility Plant- Net(7262000-2872100) 4389900
Construction work in progress(107000+225000-255000+25500) 102500
Net Utlity plant 4854400
Total Assets 5458400
Liabilities
Current Liabilities
Accounts Payable(128400+(192000+366000+206000+225000)-1060600) 56800
Accrued Expense(80300-80300+95000) 95000
Total Current Liabilities 151800
Long term debt:
Revenues Bonds Payable 3507000
Total Liabilities
Net position
Net investment in capital assets restricted (4854400-3507000) 882900
Restricted Assets 362000
Unrestricted 554700
Total Net Position(882900+362000+554700) 1799600

Therefore Total Net Position = $ 1799600

I answered one of the question completely.

if you like my answer hit like button.

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: 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 $ 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: 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...

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

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

  • Enterprise Fund Journal Entries and Financial Statements. Following is the June 30, 2017, statement of net...

    Enterprise Fund Journal Entries and Financial Statements. Following is the June 30, 2017, statement of net position for the City of Bay Lake Water Utility Fund. Page 301 Required A. For fiscal year 2017, prepare general journal entries for the Water Utility Fund using the following information. 1.The amount in the Accrued Utility Revenue account was reversed. 2.Billings to customers for water usage during fiscal year 2017 totaled $2,982,557; $193,866 of the total was billed to the General Fund. 3.Cash...

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