Question

Using Excel prepare, in good form, a Statement of Activities for the city of Northern Pines for the year ended June 30, 2015. Northern Pines has no component units.

The following information is available for the preparation of the government-wide financial statements for the city of Northern Pines for the year ended June 30, 2015:

Expenses:
General government	$	10,100,000
Public safety		22,900,000
Public works		11,890,000
Health and sanitation		6,210,000
Culture and recreation		4,198,000
Interest on long-term debt, governmental type		1,021,000
Water and sewer system		11,550,000
Parking system		419,000
Revenues:
Charges for services, general government		1,110,000
Charges for services, public safety		1,210,000
Operating grant, public safety		698,000
Charges for services, health and sanitation		2,555,000
Operating grant, health and sanitation		1,210,000
Charges for services, culture and recreation		2,198,000
Charges for services, water and sewer		12,578,000
Charges for services, parking system		398,000
Property taxes		27,112,000
Sales taxes		20,698,000
Investment earnings, business-type		319,000
Special item–gain on sale of unused land, governmental type		1,250,000
Transfer from governmental activities to business-type activities		688,000
Net position, July 1, 2014, governmental activities		11,222,000
Net position, July 1, 2014, business-type activities		22,333,000

Answer 1

		City of Northern Pines
		Statement of Activities
		Year Ended June 30, 2015
Functions / Programs		Program Revenues			Net Revenue & Change in Net Assets
	Expenses	Charges for services	Operating Grants		Governmental Activities	Business Type Activities	Total
General government	10,100,000	1,110,000			-8,990,000		-8,990,000
Public safety	22,900,000	1,210,000	698,000		-20,992,000		-20,992,000
Public works	11,890,000				-11,890,000		-11,890,000
Health and sanitation	6,210,000	2,555,000	1,210,000		-2,445,000		-2,445,000
Culture and recreation	4,198,000	2,198,000			-2,000,000		-2,000,000
Interest on long-term debt	1,021,000				-1,021,000		-1,021,000
Total Government Activities	56,319,000	7,073,000	1,908,000		-47,338,000		-47,338,000
Business Activities
Water and sewer system	11,550,000	12,578,000				1,028,000
Parking system	419,000	398,000				-21,000
Total Business Activities	11,969,000	12,976,000				1,007,000
Total Primary Government	68,288,000	20,049,000	1,908,000		-47,338,000	1,007,000	-47,338,000
				General Revenue
				Property taxes	27,112,000		27,112,000
				Sales taxes	20,698,000		20,698,000
				Investment earnings		319,000	319,000
				Special item–gain on sale of unused land	1,250,000		1,250,000
				Transfer from governmental activities	-688000	688,000	0
				Total General Revenues	48,372,000	1,007,000	49,379,000
				Change in Net Assets	1,034,000	2,014,000	3,048,000
				Net Assets, Beginning	11,222,000	22,333,000	33,555,000
				Net Assets, Ending	12,256,000	24,347,000	36,603,000