The City of Bernard starts the year of 2020 with the following unrestricted amounts in its general fund cash of $42,250 and investments of $82,500. In addition, it holds a small building bought on January 1, 2019, for general government purposes for $318,000 and a related long-term debt of $254,400. The building is depreciated on the straight-line method over 10 years. The annual Interest rate on the debt is 10 percent. The general fund has four separate functions: general government, public safety, public works, and health and sanitation. Other information includes the following: $597,000 107,800 25,000 19,400 12,050 5,700 40,800 9,200 28,500 221,000 96.650 136,500 Receipts: Property taxes Sales taxes Dividend income Charges for general government services Charges for public safety services Charges for public works charges for health and sanitation services Charges for landfill Grant to be used for salaries for health workers (no eligibility requirements Issued long-term note payable Sold investments (mentioned above) Receivables at year-endi Property taxes ($10,00 is expected to be uncollectible) Payments Salary: General government Public safety Public Works Health and sanitation (all from grant) Utilities: General government Public safety Public Works Health and sanitation Insurances General government Public safety Public Works (all prepaid as of the end ot the year) Health and sanitation Miscellaneous General government Public safety Publin un 137,000 107, 750 74,250 23.400 10,000 20,300 17,550 6,000 28,700 14,200 8,700 4.800 12,500 12,800 AN 6,000 28,700 14,200 8,700 4.800 FUWA AU WULA Health and sanitation Insurance: General government Public safety Public works (all prepaid as of the end of the year) Health and sanitation Miscellaneous General government Public safety Public Works Health and sanitation Interest on previoun debt Principal payment on previous debt Interest on new debt. Building public works) Equipment public safety) Public works supplies (302 till held) Investments Ordered but not received: Equipment Supplies Due at end of year Salaries: General government Public safety Public Works 12,500 12,800 13,650 9,300 25,440 13,900 19,890 222.000 99,000 21,700 140,500 37,500 7,250 16,600 20,100 7,500 On the last day of the year the city borrows $70,000 from a local bank and uses the money to buy a truck The first payment on the loan (plus interest) will be made at the end of the next year. The city opens a landfill this year that it records within its general fund. It is a public works function. Closure costs today is estimated os $276,500 although officials do not expect the landfill to be filled for nine more years. The city has incurred no costs to date. The landfill is now 15 percent filled. For the equipment and supplies that were ordered but not yet received, the City Council (the highest decision-making body in the government) has voted to honor the commitment when the items arrive The new building is depreciated over 20 years using the straight line method and no residual value. Depreciation of the equipment is similar except that its life is only 10 years. Assume the city records a full year's depreciation in the year of acquisition The city opens a landfill this year that it records within its general fund. It is a public works function. Closure costs today is estimated as $276,500 although officials do not expect the landfill to be filled for nine more years. The city has incurred no costs to date. The landfill is now 15 percent filled. For the equipment and supplies that were ordered but not yet received the City Council (the highest decision-making body in the government) has voted to honor the commitment when the items arrive. The new building is depreciated over 20 years using the straight-line method and no residual value Depreciation of the equipment is similar except that its life is only 10 years. Assume the city records a full year's depreciation in the year of acquisition The investments have a market value of $145,650 at year-end. a-1. Prepare a statement of activities for governmental activities in government-wide financial statements for December 31, 2020, and the year then ended a-2. Prepare a statement of net position for governmental activities in government-wide financial statements for December 31, 2020, and the year then ended. b-1. Prepare a statement of revenues, expenditures, and other changes in fund balances for the general fund in fund financial statements as of December 31, 2020, and the year then ended. Assume the purchases method is applied. b-2. Prepare a balance sheet for the general fund in fund financial statements as of December 31, 2020, and the year then ended Assume the purchases method is applied Complete this question by entering your answers in the tabs below. Reg A1 Reg A2 Reg 31 Reg B2 Prepare a statement of activities for governmental activities in government-wide financial statements for December 31, 2020, and the year then ended. (For columns under "Net (Expense) Revenue and Changes in Net Position", enter values to be deducted with negative sign. Enter rest of the values as positive.) CITY OF BERNARD Statement of Activities Prepare a statement of activities for governmental activities in government-wide financial statements for December 31, 2020, and the year then ended. (For columns under "Net (Expense) Revenue and Changes in Net Position", enter values to be deducted with negative sign. Enter rest of the values as positive.) CITY OF BERNARD Statement of Activities For Year Ended December 31, 2020 Net (Expense) Revenue and Program Revenues Changes in Net Position Functions/Programs Charges for Grants and Governmental Expenses Total Services Contributions Activities Governmental activities: $ 0 $ 0 $ 0 $ 0 $ 0 Total governmental activities General revenues $ 0 $ 0 Total general revenues Change in net position: Change during 2020 $ 05 0 $ 0 $ 0 Prepare a statement of net position for governmental activities in government-wide financial statements for December 31, 2020, and the year then ended. CITY OF BERNARD Statement of Net Position December 31, 2020 Governmental Activities Totals Assets Current assets: $ 0 $ 0 Total current assets Capital assets $ 0$ 0 Total assets Liabilities: Current abilities Noncurrent liabilities: Prepare a statement of revenues, expenditures, and other changes in fund balances for the general fund in fund financial statements as of December 31, 2020, and the year then ended. Assume the purchases method is applied. CITY OF BERNARD Statement of Revenues, Expenditures, and Other Changes in Fund Balances - Governmental Funds For Year Ended December 31, 2020 General Fund Revenues $ 0 Total Expenditures: Current Debt service: Capital outlay Debt service: Capital outlay: $ 0 Total expenditures Excess (deficiency) of revenues over expenses Other financing sources: $ 0 $ 0 Total other financing sources Not changes in fund balance 0