Question

1. The City of Madison, a general purpose government, reported fund balances in the amount of $19,700,000 in the governmental funds balance sheet dated December 31, 2017. In addition, the following information is relevant:

A. General government capital assets amounted to $28,000,000. Accumulated depreciation of those capital assets amounted to $13,000,000. Enterprise fund capital assets amounted to $ 17,000,000 with accumulated depreciation of $ 8,400,000.

B. Internal service fund’s net assets amounted to $2,500,000. These were reported in the proprietary funds fund basis statements but serve departments in the General Fund.

C. Property Taxes, which should be recognized as revenue in the government-wide statements, amounted to $ 200,000. The balance of deferred inflows - property taxes from the previous year was $ 170,000.

D. Liabilities, in addition to the amount reported in the governmental funds balance sheet included accrued interest payable, $300,000;

E. General long-term liabilities of the government amounted to (1) general obligation bonds of $ 6,000,000 and (2) compensated absences payable of $1,500,000. Revenue Bonds Payable in the enterprise fund totaled $ 2,000,000.

Required: Prepare a reconciliation from the fund balances recognized in the governmental funds balance sheet to the Net Position recognized in the governmental funds column of the government-wide statement of Net Position

2. The City of Henderson reported a change in fund balances of $2,267,000 in its governmental funds Statement of Revenues, Expenditures, and Changes in Fund Balances for the year ended December 31, 2017. In addition, the following information is relevant:

A. Capital outlay expenditures amounted to $8,755,000 in the modified accrual statement. General government capital assets amounted to $90,000,000, excluding land and had an average life of 20 years.

B. The modified accrual statement reported proceeds from the sale of land in the amount of $500,000. The land had a basis of $390,000.

C. Property taxes had been levied in the amount of $10,000,000. It was estimated that 3% would never be collected, that $500,000 would be collected within 60 days of year-end, and that $217,000 would be collected more than 60 days from year-end. The City had recognized the maximum permitted under modified accrual accounting.

D. $205,000 of property taxes had been deferred at the end of the previous year and was recognized under modified accrual as revenue in the current year.

E. The modified accrual statement reflected debt service expenditures in the amount of $500,000 for interest and $612,000 for principal. No adjustment was necessary for interest accruals at year-end.

F. Long term compensated absences liabilities increased $120,000 from the previous year.

Required: Prepare a reconciliation from the change in fund balances reported above to the change in Net Position in the governmental column in the government-wide Statement of Activities for the year ended December 31, 2017.

Answer 1

part 1

City of Madison

Reconciliation of the Balance Sheet of Governmental Funds to the Statement of Net Position

As of December 31, 2017

Fund Balances Reported in Governmental Funds Balance Sheet	19700000
Amounts reported for governmental activities in the Statement of Activities are different because:
Capital assets used in governmental funds are not reported in the funds as they are not financial resources (28000000-13000000)	15000000
Internal service funds are included in governmental activities in the Statement of Net Position as they are used to charge the costs of certain activities to individual funds.	2500000
Deferred inflows for property taxes are accrued in the government-wide statements and also added to Net Position. Thus, they are reported in the funds	200000
Accrued interest payable is reported in the funds as it is accrued in the government-wide statements	(300000)
Long-term liabilities are reported in the funds because they are not due    and payable in the current period (6000000+1500000)	(7500000)
Net Position of governmental activities	29600000

part 2

CITY OF HENDERSON

RECONCILIATION OF THE STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES OF GOVERNMENTAL FUNDS TO THE STATEMENT OF ACTIVITIES

FOR THE YEAR ENDED DECEMBER 31, 2017

Net change in fund balances-total governmental funds	2267000
Amounts reported for governmental activities in the Statement of Activities are different because:
Capital outlays are reported as expenditures in Governmental funds. In the statement of activities it is in the form of depreciation expense. Here the amount recorded is the one by which capital outlays exceeded depreciation in the current period. (8755000-(90000000/20)	4255000
gain on the sale of land is reported in the Statement of Activities, and proceeds from the sale are reported in the governmental funds.	(390000)
Revenues that lacks current financial resources are not reported as revenues in the funds (property taxes) (217000-205000)	12000
Repayment of bond principal is reported in the governmental funds, but there is reduction in long-term liabilities in the Statement of Net Position due to repayment.	612000
Some expenses that lacks current financial resources are not reported as expenditures in the governmental funds	(120000)
Change in Net Position of governmental activities	6636000