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,212 | | |
| Accounts receivable (net of $13,375 provision for uncollectible accounts) | | | | | | 307,053 | | |
| Accrued utility revenue | | | | | | 500,100 | | |
| Due from General Fund | | | | | | 29,317 | | |
| Interest receivable | | | | | | 82,017 | | |
| Total current assets | | | | | | 2,694,699 | | |
| Restricted assets: | | | | | | | | |
| Cash | | | | | | 9,200 | | |
| Capital assets: | | | | | | | | |
| Land | $ | 1,782,303 | | | | | | |
| Buildings (net of $3,422,611 in accumulated depreciation) | | 5,218,390 | | | | | | |
| Machinery and equipment (net of $5,133,848 in accumulated depreciation) | | 8,494,884 | | | | | | |
| Total capital assets (net) | | | | | | 15,495,577 | | |
| Total Assets | | | | | | 18,199,476 | | |
| Liabilities | | | | | | | | |
| Current liabilities: | | | | | | | | |
| Accounts payable | | 532,436 | | | | | | |
| Interest payable | | 131,869 | | | | | | |
| Current portion of long-term debt | | 407,000 | | | | | | |
| Total current liabilities | | | | | | 1,071,305 | | |
| Liabilities payable from restricted assets: | | | | | | | | |
| Customer deposits | | | | | | 9,200 | | |
| Long-term liabilities: | | | | | | | | |
| Revenue bond payable | | | | | | 11,803,000 | | |
| Total Liabilities | | | | | | 12,883,505 | | |
| Net Position | | | | | | | | |
| Net investment in capital assets | | | | | | 3,277,266 | | |
| Unrestricted | | | | | | 2,038,705 | | |
| | | | | | $ | 5,315,971 | | |
|
Following is the information of the Water Utility Fund for fiscal year 2020.
- The amount in the Accrued Utility Revenue account was reversed.
- Billings to customers for water usage during fiscal year 2020 totaled $2,875,898; $186,934 of the total was billed to the General Fund.
- Cash in the amount of $250,704 was received. The cash was for interest earned on investments and $79,069 in accrued interest.
- Expenses accrued for the period were management and administration, $347,523; maintenance and distribution, $664,466; and treatment plant, $670,383.
- Cash receipts for customer deposits totaled $2,343.
- Cash collections on customer accounts totaled $2,841,530, of which $202,279 was from the General Fund.
- Cash payments for the period were as follows: Accounts Payable, $1,411,972; interest (which includes the interest payable), $382,211; bond principal, $407,000; machinery and equipment, $593,638; and return of customer deposits, $926.
- A state grant amounting to $482,294 was received to help pay for new water treatment equipment.
- Accounts written off as uncollectible totaled $10,167.
- The utility fund transferred $812,306 in excess operating income to the General Fund.
- Adjusting entries for the period were recorded as follows: depreciation on buildings was $243,749 and on machinery and equipment was $365,623; the allowance for uncollectible accounts was increased by $15,144; an accrual for unbilled customer receivables was made for $710,843; accrued interest income was $16,094; and accrued interest expense was $62,358.
- The Revenue Bond Payable account was adjusted by $407,000 to record the current portion of the bond.
- Closing entries and necessary adjustments were made to the net position accounts.
- Prepare a statement of revenues, expenses, and changes in fund net position for the Water Utility Fund for the year ended June 30, 2020. (Negative amounts should be indicated by a minus sign.)
that is literally the ENTIRE question given in the excercise. can you answer it?
i would like for you to answer the entire wuestion please. the entries too. some of them are done but i need the entire question from part A-D
this is my 5th time uodating this question. what is not visible???
The City of Castleton's General Fund had the following post closing trial balance at June 30, 2019, the end of its fiscal year: Credits Debits $298,000 584,000 $299,120 26, 380 11,260 16,200 Yaxes Receivable-Delinquent Allowance for Uncollectible Delinquent Taxes Interest and Penalties Receivable Allowance for Uncollectible Interest and Penalties Inventory of Supplies Vouchers Payable Due to Federal Government Deferred Inflows of Resources-Unavailable Revenues Fund balance-Nonspendable Inventory of Supplies Fund Balance-Unassigned 149,500 60,490 300,000 16,200 88,010 $924,580 $924,580 a. Record the effect of the following transactions on the General Fund and governmental activities for the year ended June 30, 2020, b. Record in general journal form entries to close the budgetary and operating statement accounts in the General Fund only. Do not close the governmental activities accounts. c. Prepare a General Fund balance sheet as of June 30, 2020 d. Prepare a statement of revenues, expenditures, and changes in fund balance for the year ended June 30, 2020. Do not prepare the government-wide financial statements. Complete this question by entering your answers in the tabr holom The City of Castleton's General Fund had the following post-closing trial balance at June 30, 2019. the end of its fiscal year Credits Debits $298,000 584,000 $299, 120 26,380 Cash Taxes Receivable-Delinquent Allowance for Uncollectible Delinquent Taxes Interest and Penalties Receivable Allowance for Uncollectible Interest and Penalties Inventory of Supplies Vouchers Payable Due to Federal Government Deferred Inflows of Resources-Unavailable Rove lancelospodalomtory of Supplies und Balcesigned 11,260 16,200 149,50 50.490 300,000 16,200 HEID Record the effect of the following transactions on the General Fund and governmental activities for the year ended lune 30 2020. b. Record in general jutalom entries to dose the budgetary and operating statement accounts in the General Fund only Do not close the governmental activities accounts c. Prepare a General Fund balance sheet as of June 30, 2020 d. Prepare a statement of revenues expenditures, and changes in fond balance for the year ended June 3027020 Do not prepare the government wide financial statements Complete the OVDE General Dours 1. The budget for FY 2020 provided for General Fund estimated revenues totaling $3,160,000 and appropriations totaling $3,119,000 1 General Fund Estimated Revenues 3,160,000 Appropriations Budgetary Fund Balance 3,119,000 41.000 Governmental Activities No Journal Entry Required 2 The city council authorized temporary borrowing of $510,000 in the form of a 120-day tax anticipation note. The loan was obtained from a local bank al a discount of 5 percent per annum (debit Expenditures for the discount in the General Fund journal and Expenses-General Government in the governmental activities journal) 2 General Fund Cash 510,000 Expenditures 8,500 Tax Anticipation Notes Payable 518,500 Governmental Activities Cash Expenses Tax Anticipation Notes Payable 510,000 8.500 518,500 3. The property tax levy for FY 2020 was recorded. Net assessed valuation of taxable property for the year was $43 100,000, and the tax rate was $5 per 5100 It was estimated that 2 percent of the levy would be uncollectible. 3 General Fund Taxes Receivable.Current 2, 155 000 Allowance for Uncollectible Current Taxes 43.100 General Revenues 2.111 900 Proy 1 of 1 BRE Next arch O ED 3. The property tax lovy for FY 2020 was recorded Net assessed valuation of taxable property for the year was $43,100,000, and the tax rate was $5 per $100 it was estimated that 2 percent of the levy would be uncollectible 3 General Fund Taxes Receivable Current 2,155,000 Allowance for Uncollectible Current Taxes 43,100 General Revenues 2,111,900 2,155,000 Governmental Activities axes Receivable--Current Allowance for Uncollectible Current Taxes General Revenues 43 100 2,111,900 Purchase orders and contracts were issued to vendors and others in the amount of $2,070,000 4 General Fund Encumbrances Encumbrances Outstanding 2,070,000 20,700 Governmental Activities No Journal Entry Required 5 $1 071000 of current taxes $384 270 of delinquent taxes, and $20,670 of interest and penalties were collected the delinquent taxes and associated interest and penalties were collected more than 60 days after the prior year-end Record the $1,971,000 of current taxes $384 270 of delinquent taxes and $20,670 of interest and penalties collected ba General Fund Cash 2.375,940 taxes Receivable--Current 1971 000 Taxes Receivable-Delinquent 384 270 Interest and Penalties Receivable 20 670 Prey 1 of Nex ch o M Record the delinquent taxes and associated interest and penalties collected more than 60 days after the prior year end Deferred Inflows of Resources Unavailable Revenues Revenues Governmental Activities Record the $1,971,000 of current taxes, $384,270 of delinquent taxes, and $20,670 of interest and penalties collected Cash 2,375,940 laxes Receivable --Current 1,971,000 Taxes Receivable-Delinquent 384 270 interest and Penalties Receivable 20,670 5d Record the delinquent taxes and associated interest and penalties collected more than 60 days after the prior year-end No Journal Entry Required itional interest and penalties on delinquent taxes were accrued in the amount of $38,540, of which 25 percent was estimated to be uncollectible 6 General Fund 38 540 interest and Penalties Receivable Allowance for Uncollectible Interest and Penalties Revenues 9.635 28.905 38 510 Governmental Activities interest and Penalties Receivable Allowance for Uncollectible Interest and Penalties (General Revenues 9,635 28 905 Prey 1 of 1 NOX - 7. Because of a change in state law, the city was notified that it will receive $82,000 loss in intergovernmental revenues than was budgeted 7 General Fund Budgetary Fund Balance 82,000 Estimated Revenues 82,000 Governmental Activities 8 Delinquent taxes of $13,000 were deemed uncollectible and written off. The associated interest and penalties of $967 also were written off 8 General Fund Allowance for Uncollectible Delinquent Taxes 13,000 Allowance for Uncollectible Interest and Penalties 967 Taxes ReceivableDelinquent interest and Penalties Receivable 13,000 957 13,000 967 Governmental Activities Allowance for Uncollectible Delinquent Taxes Allowance for Uncollectible Interest and Penalties Taxes Receivable-Delinquent interest and Penalties Receivable 13,000 967 9 Total payroll duning the year was 5829 490 of that amount, 563.690 was withheld for employees' FICA tax liability, 5104 710 for employees federal income tax liability, and 534 500 for state taxes, the balance was paid to employees in cash 13 General Fund Expenditures 829,490 Due to Federal Government 168. 400 Due from State Government 34 500 Cash 626,590 Prey 1 of 1 . Next arch o 829 490 Governmental Activities Expenditures Due to Federal Government Due to State Government 168.400 34,500 626,590 10 The employer's FICA tax liability was recorded for $63,690 10 General Fund Expenditures Due to Federal Government 63 690 63,690 63,690 Governmental Activities Expenses Due to Federal Government 63 690 11 Revenues from sources other than taxes were collected in the amount of $948 000 11 General Fund Cash Revenues 948,000 948.000 948 000 Governmental Activities Cash Revenues 948,000 12 Amounts due the federal government as of June 30, 2020, and amounts due for FICA taxes and state and federal withholding taxes dunng the year were vouchered 12 General Fund Due to Federal Government Due to State Government Vouchers Payable Pray of 1 Nel Gavemental Activities Due to Federal Government Due to State Government Vouchers Payable 13. Purchase orders and contracts encumbered in the amount of $1,998,040 wore filled at a net cost of $1,997570, which was vouchered 130 General Fund Record the encumbrances outstanding for 2020 Encumbrancos Outstanding 1998,040 Encumbrancos Outstanding 1 998 040 13b Record the total expenditures against vouchers payable for 2020 Expenditures Vouchers Payable 1,997,570 1,997,570 135 Governmental Activities Record the total expenses against vouchers payable for 2020 Expenses Nouchers Payable 1,997 570 199,570 14 Vouchers payable totaling S2 311 660 were paid after deducting a credit for purchases discount of $8 130 (credit Expenditures) 14 General Fund Nouchers Payable 2,311 660 Cash Expenditures 2 311 660 8.130 2311660 Governmental Activities Vouchers Payable Cash 2,311 660 Prey 1 ore Nex! O ac 2,311,00 Governmental Activities Vouchers Payable Cash Expenditures 2,311 660 8.130 The tax anticipation note of $510,000 was repard 15 General Fund Tax Anticipation Notes Payable Cash 510,000 510,000 510 000 Governmental Activities frax Anticipation Notes Payable Cash 510,000 All unpaid current year's property taxes became delinquent. The balances of the current taxes receivables and related uncollectibles were transferred kelinquent accounts The City uses the 60-day rule for all revenues and does not expect to collect any delinquent property taxes or interest and alties in the first 60 days of the next fiscal year 160 General Fund Record the delinquent amount of unpaid property taxes Taxes Receivable-Delinquent Taxes Receivable-Current 1035 Record the adjustment for the delinquent amount of tax against the allowance Allowance for Uncollectible Current Taxes Allowance for Uncollectible Delinquent Taxes 16 Record the deferred inflow of resource Revenues Deferred Inflows of Resources-Unavailable Revenues 100 Governmental Activiti Record the delinquent amount of unpaid property taxes Prey 1 of 1 Nox o 154 Governmental Activities Record the delinquent amount of unpaid property taxes. Taxes Receivable Delinquent Taxes Receivable Current 16e Record the adjustment for the delinquent amount of tax against the allowance Allowance for Uncollectible Current Taxes Allowance for Uncollectible Delinquent Taxes 167 Record the deferred inflow of resource No Journal Entry Required 17. A physical inventory of materials and supplies at June 30, 2020, showed a total of $19,300. Inventory is recorded using the purchases method in the General Fund, the consumption method is used at the government-wide level (Note. A periodic inventory system is used both in the General Fund and at the government wide level When inventory was purchased during the year Expenditures were debited in the General Fund journal and Inventory of Supplies was debited in the governmental activities journal Recorded entry to reclassify the fund balance.) 17 General Fund Inventory of Supplies 3,100 Fund Balance--Nonspendable--Inventory of Supplies 3.100 Governmental Activities inventory of Supplies 3.100 Expenses 3,100 Required B > Proy 1 of 1 Non Required A Required B Required c Required D Record in general journal form entries to close the budgetary and operating statement accounts in the General Fund only. Do not cle governmental activities accounts. (If no entry is required for a transaction/event, select "No Joumal Entry Required in the first acce field. Do not round Intermediate calculations.) Debit Credit Transactions Fund General Journal 1 Record the closure of budgetary statements account General Fund Appropriations Estimated Revenues Budgetary Fund Balance 2. Record the closure of operating statements account 2 General Fund (Revenues Expenditures Fund Balance --Unassigned Prey 1 Next CITY OF CASTLETON General Fund Balance Sheet As of June 30, 2020 Assets 0 0 S 0 Cash Taxes Receivable-Delinquent Less Allowance for Uncollectible Taxes-Delinquent Interest and Penalties Receivable Less Allowance for Uncollectible Interest and Penalties Inventory of Supplies Total Assets Liabilities and Fund Balances Liabilities Vouchers Payable Deferred Inflows of Resources-Unavailable Revenues Total Liabilities and Deferred Inflows of Resources Fund Balances Nonspendable--Inventory of Supplies Unassigned Total Fund Balances Total Liabilities and Fund Balances 0 0 S 0 Pard Pardun Prey 1 of 1 o search o At M Required Required B Required Required D Prepare a statement of revenues, expenditures, and changes in fund balance for the year ended June 30, 2020. Do not prepare the government-wide financial statements CITY OF CASTLETON General Fund Statement of Revenues Experties and Changes in Fund Balance For the Year Ended June 30 2020 Revenues Taxes Interest and Penalties on Taxes Other Sources Total Revenues D Expenditures Salaries and Wages Interest on Note Payable Other Total Expenditures $ 0 Excess of Revens ovet Expenditures Increase in wory of Supplies Fundaces 1. 2019 Fund Balances June 30 2000 0 The City of Castleton's General Fund had the following post-closing trial balance at June 30, 2019, the end of its fiscal year Credits Debits $298,000 584,000 $299,120 26,380 11,260 Cast Taxes Receivable Delinquent Allowance for Uncollectible Delinquent Taxes Interest and Penalties Receivable Allowance for Uncollectible Interest and Perttips Inventory of Supplies Vouchers Payable Due to Federal Government Deferred Inflows of Resources-Unavailable Revenues fund Balance-Nonspendable-Inventory of Supplies Fund Balance-Unassigned 16,200 149,500 60,490 300,000 16,200 88,010 $924,530 $924,580 a. Record the effect of the following transactions on the General Fund and governmental activities for the year ended June 30, 2020. b. Record in general journal form entries to close the budgetary and operating statement accounts in the General Fund only. Do not close the governmental activities accounts. c. Prepare a General Fund balance sheet as of June 30, 2020. d. Prepare a statement of revenues, expenditures, and changes in fund balance for the year ended June 30, 2020. Do not prepare the government wide financial statements