Problem 1 (20 points) Shown below is a trial balance for the general fund of a Michigan municipality. From this trial balance please prepare a Statement of Revenues, Expenditures, and Changes in Fund Balance and a Balance Sheet. Please be sure to categorize the subcategories of fund balance properly. Please format your financial statements appropriately with proper headings and subheadings, borders, etc. Cash and investments Taxes receivable Allowance for uncollectible taxes Accounts receivable Accrued interest receivable Due from other governments Due from other funds Inventory Prepaid expenditures Accounts payable Accrued expenses Deposits payable Unearned revenue Deferred inflows: Property taxes levied in advance Fund Balance-Beginning Property tax revenue Licenses and permits revenue Federal grants revenue State grants revenue Charges for services revenue Fines and forfeits revenue Interest and rents revenue Other revenue General government expenditures Public safety expenditures Public works expenditures Community development expenditures Recreation expenditures Other expenditures Capital outlay expenditures Debt service: principal expenditures Proceeds from issuance of long-term debt Transfers out to other funds Transfers in from other funds Total Debit Credit 1,728,639 4,012.355 154,321 69,284 957 150,958 11,365 27,617 232,638 101, 121 37,536 10,485 24,331 3,854,880 1,583,560 3,747,599 109,607 16.977 831,899 531,283 33,348 18,132 130,841 1,453,632 1,703,448 1,275,688 99,006 472,838 37,769 17,248 17,790 560,000 634,688 200,000 11,031,599 11,031,599 of the fund balance at year end, $250,000 consists of unexpended proceeds of a state grant required by law to be used for health education. of the fund balance at year end, $275,000 was required by the city council to be set aside to meet contractual obligations for capital projects