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:
Materials and supplies | $ | 192,000 | |
Costs of sales and services | 366,000 | ||
Administrative expenses | 206,000 | ||
Construction work in progress | 225,000 | ||
Prepare a Statement of Net Position as of June 30, 2017. (Deductions should be entered as a negative amount.)
|
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.)
|
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.
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 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 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 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 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 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 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 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 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 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...