Question

In: Accounting

Following is the June 30, 2017, statement of net position for the City of Bay Lake...

Following is the June 30, 2017, 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, 2017
  Assets
  Current assets:
     Cash and investments $ 1,776,021
     Accounts receivable (net of $13,374           provision for uncollectible accounts) 307,030
     Accrued utility revenue 500,100
     Due from General Fund 29,317
      Interest receivable 82,017
       Total current assets 2,694,485
  Restricted assets:
     Cash 9,199
  Capital assets:
     Land $ 1,782,109
     Buildings (net of $3,422,238 in accumulated          depreciation) 5,217,821

     Machinery and equipment (net of $5,133,288          in accumulated depreciation)

8,493,957
       Total capital assets (net) 15,493,887
  Total Assets 18,197,571
  Liabilities
  Current liabilities:
     Accounts payable 532,380
     Interest payable 131,855
     Current portion of long-term debt 406,000
       Total current liabilities 1,070,235
  Liabilities payable from restricted assets:
     Customer deposits 9,199
  Long-term liabilities:
     Revenue bond payable 11,774,000
  Total Liabilities 12,853,434
  Net Position
     Net investment in capital assets 3,310,191
     Unrestricted 2,033,946
$ 5,344,137
Following is the information of the Water Utility Fund for fiscal year 2017.
  (1) The amount in the Accrued Utility Revenue account was reversed.
  (2)

Billings to customers for water usage during fiscal year 2017 totaled $2,891,136; $187,924 of the total was billed to the General Fund.

  (3)

Cash in the amount of $252,032 was received. The cash was for interest earned on investments and $79,488 in accrued interest.

  (4)

Expenses accrued for the period were: management and administration, $349,365; maintenance and distribution, $667,988; and treatment plant, $673,936.

  (5) Cash receipts for customer deposits totaled $2,355.
  (6)

Cash collections on customer accounts totaled $2,856,083, of which $203,315 was from the General Fund.

  (7)

Cash payments for the period were as follows: Accounts Payable, $1,419,204; interest (which includes the interest payable), $384,169; bond principal, $406,000; machinery and equipment, $592,179; and return of customer deposits, $924.

  (8) A state grant amounting to $481,252 was received to help pay for new water treatment equipment.
  (9) Accounts written off as uncollectible totaled $10,145.
(10) The utility fund transferred $810,548 in excess operating income to the General Fund.
(11)

Adjusting entries for the period were recorded as follows: depreciation on buildings was $243,221 and on machinery and equipment was $364,831; the allowance for uncollectible accounts was increased by $15,111; an accrual for unbilled customer receivables was made for $709,294; accrued interest income was $16,059; and accrued interest expense was $62,222.

(12) The Revenue Bond Payable account was adjusted by $406,000 to record the current portion of the bond.
(13) Closing entries and necessary adjustments were made to the net position accounts.

1.

value:
4.68 points

Required information

Required
a-1.

For fiscal year 2017, prepare general journal entries for the Water Utility Fund. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.)

a-2.

For fiscal year 2017, prepare closing entries for the Water Utility Fund. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.)

- Record the closure of all revenue and expenses account.

- Record the net change in investment in capital assets.

Solutions

Expert Solution



Related Solutions

Required information Following is the June 30, 2019, statement of net position for the City of...
Required information 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,776,504 Accounts receivable (net of $13,377 provision for uncollectible accounts) 307,099 Accrued utility revenue 500,100 Due from General Fund 29,317 Interest receivable 82,017 Total current assets 2,695,037 Restricted assets: Cash 9,201 Capital assets: Land $ 1,782,497 Buildings...
QUESTION TWO At 30 June 2017 the statement of Financial Position of Timing Limited included a...
QUESTION TWO At 30 June 2017 the statement of Financial Position of Timing Limited included a deferred tax liability amounting to a credit balance R11 152. The deferred tax relates to the only item of equipment owned by the company. The following information is relevant: Year ended 30 June 2019 R 2018 R Profit before taxation 282 000 252 000 Wear and tear allowance 40 000 50 000 Depreciation 48 000 48 000 Additional information: The tax base of the...
The following statement of financial position relates to XYZ Ltd for the years ending 30 June...
The following statement of financial position relates to XYZ Ltd for the years ending 30 June 2019 and 30 June 2020. XYZ Ltd Statement of Financial Position As at 30 June 2020 2019 Cash at Bank       $     43,000 $    42,000 Accounts Receivable 34,500 96,000 Inventory 113,500 124,000 Land 45,000 62,500 Buildings 265,000 137,500 Accumulated depreciation – Buildings (100,000) (85,000) Plant & Equipment 40,000 40,000 Accumulated depreciation – Plant & Equipment (10,000) (5,000) 431,000 412,000 Accounts Payable 67,000 60,500 Interest...
From the following account balances to 30 June 2020 prepare a statement of financial position in...
From the following account balances to 30 June 2020 prepare a statement of financial position in the narrative classified format. Note: you will need to determine the balance of the retained earnings.    Type of Account                                 $ Accounts Receivable                              46500 Provisions                              50000 Prepayments                              1200 Sales Revenue                            455000 Plant and Equipment                            220000 Other Current Assets                              11000 Borrowings                            120000 Interest on Borrowings E                              6000 Accumulated Depreciation                            48500 Accounts Payable                              26000 Share Capital                            450000 Land and Buildings                            339000 Inventory                              78000 Two Year Term...
On 30 June 2018, the Statement of Financial Position of Emerald Ltd showed the following non-current...
On 30 June 2018, the Statement of Financial Position of Emerald Ltd showed the following non-current asset after charging depreciation: Plant 400,000 Accumulated Depreciation (150,000) 250,000 As of 30 June 2018, the company decided to adopt the revaluation model for the plant. Therefore, on 30 June 2018, an independent valuer assessed the fair value of the plant to be $280,000 with a remaining useful life of 7 years. On 30 June 2019, the plant was revalued again to its fair...
On 30 June 2018, the Statement of Financial Position of Emerald Ltd showed the following non-current...
On 30 June 2018, the Statement of Financial Position of Emerald Ltd showed the following non-current asset after charging depreciation: Plant 400,000 Accumulated Depreciation (150,000) 250,000 As of 30 June 2018, the company decided to adopt the revaluation model for the plant. Therefore, on 30 June 2018, an independent valuer assessed the fair value of the plant to be $280,000 with a remaining useful life of 7 years. On 30 June 2019, the plant was revalued again to its fair...
Spear Ltd reported the following information in its statement of financial position at 30 June 2020:...
Spear Ltd reported the following information in its statement of financial position at 30 June 2020:                    Plant                                                    $325 000                    Accumulated depreciation – plant        (75 000)                    Intangible assets                                    150 000                    Accumulated amortisation                    (50 000)                    Land                                                      150 000                    Total non-current assets                         500 000                    Cash                                                         25 000                    Inventory                                                  90000                    Total current assets                                115 000                    Total assets                                          $615 000                    Liabilities                                                 75 000                    Net assets                                         $540 000 At 30 June 2020, Spear Ltd...
GCA Ltd reported the following information in its statement of financial position at 30 June 2020:...
GCA Ltd reported the following information in its statement of financial position at 30 June 2020:                    Plant                                                                    $650,000                    Accumulated depreciation – plant                  (150,000)                    Intangible assets                                               300,000                    Accumulated amortisation                               (100,000)                    Land                                                                    300,000                    Total non-current assets                                  1,000,000                    Cash                                                                    50,000                    Inventory                                                             180,000                    Total current assets                                          230,000                    Total assets                                                       $1,230,000                    Liabilities                                                             150,000                    Net assets                                                          $1,080,000 At 30 June 2020, GCA Ltd analysed the internal and external sources of information that would indicate deterioration in the worth of its assets. It determined that there were indications of impairment. GCA Ltd calculated the recoverable amount of the assets...
The Statements of Financial Position for Lexington Limited as at 30 June 2019 and 30 June...
The Statements of Financial Position for Lexington Limited as at 30 June 2019 and 30 June 2020 are provided below: Lexington Ltd Statement of Financial Position as at 30 June 2020 2019 Assets $ $ Cash at bank 64,580 38,400 Accounts Receivable 82,800 35,000 Inventory 112,500 102,850 Prepaid Advertising 14,400 14,000 Machinery 310,000 282,500 Less: Accumulated Depreciation (50,000) (52,000) Total Assets $534,280 $420,750 Liabilities Accounts Payable 157,000 59,300 Dividends payable 15,000 - Wages payable 20,700 25,000 Loan 125,000 130,000 Total...
The Statements of Financial Position for Kiwi Limited as at 30 June 2019 and 30 June...
The Statements of Financial Position for Kiwi Limited as at 30 June 2019 and 30 June 2020 are provided below: Kiwi Limited Statement of Financial Position as at 30 June 2019 2020 Assets $ $ Cash at Bank 68,000 56,000 Accounts Receivable 121,000 139,000 Inventory 44,000 41,000 Land 241,000 241,000 Plant and Machinery 319,000 414,000 Less: Accumulated Depreciation (10,000) (89,000) Total Assets $783,000 $802,000 Liabilities Accounts Payable 55,000 54,000 Tax Payable 16,000 23,000 Loan 536,000 362,000 Total Liabilities $607,000 $439,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT