ALL I NEED TO KNOW IS THE CASH & CASH EQUIVALENTS AMOUNT FOR DEC 31, 2020!!!!

The City of Bernard starts the year of 2020 with the following unrestricted amounts in its general fund: cash of $37,500 and investments of $86,750. In addition, it holds a small building bought on January 1, 2019, for general government purposes for $352,000 and a related long-term debt of $281,600. 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: $559,000 104,100 28,000 22.500 11,300 6,300 38,000 9,450 34,200 212.000 104,500 150,000 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-end: Property taxes ($11,700 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 Insurance: General government Public safety Public Works (all prepaid as of the end of the year) Health and sanitation 102.000 115,750 70.250 29,400 11,300 20,500 16,700 4.200 30,700 17,400 8,700 5,400 Miscellaneous General government Public safety Public works Health and sanitation Interest on previous debt Principal payment on previous debt Interest on new debt Building (public works) Equipment (public safety) Public works supplies (30% still held) Investments Ordered but not received: Equipment Supplies Due at end of year: Salaries: General government Public safety Public works 14.300 16,700 13,950 10,150 28,160 19,300 19.080 222.000 90.000 20.900 129,500 35,000 8,050 20,900 19,650 5.100 On the last day of the year, the city borrows $67,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 as $302,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 depreciated over 20 years using the straight-line method and no residual value. Depreciation of the equipment a full year's depreciation in the year of acquisition. milar except that its life is only 10 years. Assume the city records The investments have a market value of $139,050 at year-end. Activate Windows a-1. Prepare a statement of activities for governmental activities in government-wide financial statements for December 31, 2020, and the year then ended. Go to Settings to activate Windows, 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. The City of Bernard starts the year of 2020 with the following unrestricted amounts in its general fund: cash of $37,500 and investments of $86,750. In addition, it holds a small building bought on January 1, 2019, for general government purposes for $352,000 and a related long-term debt of $281,600. 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: $559,000 104,100 28,000 22.500 11,300 6,300 38,000 9,450 34,200 212.000 104,500 150,000 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-end: Property taxes ($11,700 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 Insurance: General government Public safety Public Works (all prepaid as of the end of the year) Health and sanitation 102.000 115,750 70.250 29,400 11,300 20,500 16,700 4.200 30,700 17,400 8,700 5,400 Miscellaneous General government Public safety Public works Health and sanitation Interest on previous debt Principal payment on previous debt Interest on new debt Building (public works) Equipment (public safety) Public works supplies (30% still held) Investments Ordered but not received: Equipment Supplies Due at end of year: Salaries: General government Public safety Public works 14.300 16,700 13,950 10,150 28,160 19,300 19.080 222.000 90.000 20.900 129,500 35,000 8,050 20,900 19,650 5.100 On the last day of the year, the city borrows $67,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 as $302,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 depreciated over 20 years using the straight-line method and no residual value. Depreciation of the equipment a full year's depreciation in the year of acquisition. milar except that its life is only 10 years. Assume the city records The investments have a market value of $139,050 at year-end. Activate Windows a-1. Prepare a statement of activities for governmental activities in government-wide financial statements for December 31, 2020, and the year then ended. Go to Settings to activate Windows, 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