Question

In: Accounting

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 (net of $3,422,984 in accumulated depreciation) 5,218,959
Machinery and equipment (net of $5,134,408 in accumulated depreciation) 8,495,811
Total capital assets (net) 15,497,267
Total Assets 18,201,505
Liabilities
Current liabilities:
Accounts payable 532,496
Interest payable 131,884
Current portion of long-term debt 409,000
Total current liabilities 1,073,380
Liabilities payable from restricted assets:
Customer deposits 9,201
Long-term liabilities:
Revenue bond payable 11,861,000
Total Liabilities 12,943,581
Net Position
Net investment in capital assets 3,209,712
Unrestricted 2,048,212
$ 5,257,924

Following is the information of the Water Utility Fund for fiscal year 2020.

  1. The amount in the Accrued Utility Revenue account was reversed.
  2. Billings to customers for water usage during fiscal year 2020 totaled $2,844,495; $184,892 of the total was billed to the General Fund.
  3. Cash in the amount of $247,965 was received. The cash was for interest earned on investments and $78,205 in accrued interest.
  4. Expenses accrued for the period were management and administration, $343,725; maintenance and distribution, $657,204; and treatment plant, $663,057.
  5. Cash receipts for customer deposits totaled $2,318.
  6. Cash collections on customer accounts totaled $2,811,211, of which $200,121 was from the General Fund.
  7. Cash payments for the period were as follows: Accounts Payable, $1,396,908; interest (which includes the interest payable), $378,133; bond principal, $409,000; machinery and equipment, $596,556; and return of customer deposits, $930.
  8. A state grant amounting to $484,378 was received to help pay for new water treatment equipment.
  9. Accounts written off as uncollectible totaled $10,211.
  10. The utility fund transferred $815,822 in excess operating income to the General Fund.
  11. Adjusting entries for the period were recorded as follows: depreciation on buildings was $244,805 and on machinery and equipment was $367,207; the allowance for uncollectible accounts was increased by $15,210; an accrual for unbilled customer receivables was made for $713,941; accrued interest income was $16,164; and accrued interest expense was $62,630.
  12. The Revenue Bond Payable account was adjusted by $409,000 to record the current portion of the bond.
  13. Closing entries and necessary adjustments were made to the net position accounts.

Required

  1. a-1. For fiscal year 2020, 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.)

  2. a-2. For fiscal year 2020, 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.)

Solutions

Expert Solution



Related Solutions

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...
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...
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...
Steiner College’s statement of financial position for the year ended June 30, 2019, is presented here....
Steiner College’s statement of financial position for the year ended June 30, 2019, is presented here. Steiner is a private college.   STEINER COLLEGE   Statement of Financial Position   June 30, 2019   (amounts in thousands) Assets Cash and cash equivalents $ 734 Short-term investments 7,666 Tuition and fees receivable (net of doubtful accounts of $12) 230 Pledges receivable (net of doubtful accounts of $280) 5,872 Prepaid assets 1,364 Property, plant, and equipment (net of accumulated depreciation of $104,240) 281,404 Investments (at fair...
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...
Statements of Financial Position of Company S -as at 30 June 2019 ($) 2018 ($) Asset...
Statements of Financial Position of Company S -as at 30 June 2019 ($) 2018 ($) Asset Cash at bank 22000 0 Accounts receivable 22000 18000 Inventory 88000 56000 Equipment 56000 46000 Accumulated depreciation – equipment -24000 -16000 Land 35000 50000 Buildings 75000 75000 Accumulated depreciation – buildings -15000 -10000 Total assets 259000 219000 Liabilities Accounts payable 45000 39000 Equity Share capital 204000 174000 Retained earnings 10000 6000 Total liabilities and equity 259000 219000 Statements of Profit & Loss - as...
QUESTION ONE The Statements of Financial Position for Lexington Limited as at 30 June 2019 and...
QUESTION ONE 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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT