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 | $ | 8,039,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 | $ | 194,000 | |
Costs of sales and services | 368,000 | ||
Administrative expenses | 207,000 | ||
Construction work in progress | 226,000 | ||
Required:
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.
Statement of Cash Flow | ||||
Cash flow from operating activities: | ||||
Cash received from customers | $ 1,563,900 | |||
Cash paid to suppliers and employee | 1067000+81100-226000 | $ -922,100 | ||
Net cash provided by operating activities | $ 641,800 | |||
Cash flow from capital and related financing activities: | ||||
Interst paid on long term debt | $ -180,500 | |||
Construction of fixed assets | $ -226,000 | |||
Net Cash used for capital and related financing acti: | $ -406,500 | |||
Net increase in cash and cash equivalents | $ 235,300 | |||
Beginning cash and cash equivalents | $ 594,000 | |||
Ending cash and cash equivalents | $ 829,300 | $ - | ||
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 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, 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 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 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...
he Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2017, 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 $ 104,000 Accounts receivable $ 26,100 Accrued interest payable 29,200 Accumulated depreciation 47,000 Administrative and selling expenses 49,000 Allowance for uncollectible accounts 12,500 Capital assets 709,000 Cash 90,500 Charges for sales and services 555,000 Cost of sales and...
$ 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...
Augusta has a municipal water and gas utility district (MUD). The trial balance on January 1, 20X1, follows: Debit Credit Cash $ 92,700 Accounts Receivable 26,500 Inventory of Supplies 9,400 Land 120,100 Plant and Equipment 492,000 Accumulated Depreciation $ 80,700 Vouchers Payable 15,500 Bonds Payable, 6% 518,000 Net Position: Invested in Capital Assets, Net of Related Debt 13,400 Unrestricted 113,100 Total $ 740,700 $ 740,700 Additional Information for 20X1: Charges to customers for water and gas were $421,700; collections were...