North Carolina
Department of State Treasurer
Financial Information
Village of Walnut Creek

Financial Profile | General Fund | Enterprise Funds | Cash, Investments and Financing
Annual Financial Information Report Detail | Water/Sewer Information
Financial Graphs and Comparisons
Download Excel 97 Version of Financial Summary

Institute of Government North Carolina Cities Web Site

Go to North Carolina County and Municipal Financial Information Home Page
Go to Wayne County Map Page

Note: All data unless otherwise specified is for the 12 month period ending June, 30th of the designated year

Municipality Revenues and Expenditures Financial Profile Go to top of page			2011	2010	2009	2008	2007	2006
	Revenues by Source
		Property Tax	$600,234	567,573	554,066	554,327	531,708	539,924
		Utility	294,729	266,731	240,303	273,528	271,557	275,341
		Sales Tax	179,731	175,623	212,198	260,912	266,145	271,870
		Sales & Services	7,025	7,340	8,450	6,220	6,450	5,200
		Intergovernmental	137,262	103,948	88,979	66,513	80,508	64,934
		Debt Proceeds	649,340	3,640	4,153	114,400	2,658	2,322
		Other Miscellaneous	2,380	6,183	12,127	41,312	47,394	24,114
		Total	$1,870,701	1,131,038	1,120,276	1,317,212	1,206,420	1,183,705

	Expenditures by Function
		Utility	$250,389	113,117	117,278	201,330	107,045	92,053
		Debt Service	554,220	200,182	205,071	234,835	237,832	157,473
		Transportation	173,609	80,843	66,917	318,842	54,209	54,831
		General Government	342,920	332,636	345,172	334,886	1,155,123	380,061
		Public Safety	180,688	177,341	188,267	175,601	177,349	137,993
		Other	88,779	100,327	116,622	120,495	139,748	138,577
		Total	$1,590,605	1,004,446	1,039,327	1,385,989	1,871,306	960,988

	Expenditures by Object
		Salaries & Wages	$302,251	305,376	305,364	298,995	277,354	267,912
		Capital Outlay	170,807	-	9,230	108,711	856,333	36,319
		Other Operating + Debt Service	1,117,547	699,070	724,733	978,283	737,619	656,757
		Total	$1,590,605	1,004,446	1,039,327	1,385,989	1,871,306	960,988


	Per Capita Revenues by Source
		Property Tax	$717	617	608	614	593	604
		Utility	352	290	263	303	303	308
		Sales Tax	215	190	232	288	296	303
		Sales & Services	8	8	9	7	7	6
		Intergovernmental	164	113	98	74	90	73
		Debt Proceeds	776	4	5	127	3	3
		Other Miscellaneous	3	7	13	46	53	27
		Total	$2,235	1,229	1,228	1,459	1,345	1,324

	Per Capita Expenditures by Function
		Utility	$299	123	129	223	119	103
		Debt Service	662	218	225	260	265	176
		Transportation	207	88	73	353	60	61
		General Government	410	361	379	372	1,288	426
		Public Safety	216	193	206	194	198	154
		Other	106	109	128	133	156	155
		Total	$1,900	1,092	1,140	1,535	2,086	1,075

	Per Capita Expenditures by Object
		Salaries & Wages	$361	332	335	331	309	300
		Capital Outlay	204	-	10	120	955	41
		Other Operating	1,335	760	795	1,084	822	734
		Total	$1,900	1,092	1,140	1,535	2,086	1,075

	Population Group		No Electric 500 to 999	No Electric 500 to 999	No Electric 500 to 999	No Electric 500 to 999	No Electric 500 to 999	No Electric 500 to 999
		Number of Municipalites in Group	92	99	94	96	96	95
		Average Population In Group	717	727	726	729	726	727
		Village of Walnut Creek Population	837	920	912	903	897	894
	Group Average Per Capita Revenues by Source
		Property Tax	433	411	400	400	335	298
		Utility	690	425	444	423	366	312
		Sales Tax	141	135	165	190	167	155
		Sales & Services	112	67	58	55	51	47
		Intergovernmental	283	320	399	298	361	357
		Debt Proceeds	129	35	90	96	29	45
		Other Miscellaneous	201	146	180	178	232	165
		Total	1,989	1,539	1,736	1,640	1,541	1,379

	Group Average Per Capita Expenditures by Function
		Utility	843	441	428	437	404	484
		Debt Service	167	105	110	97	83	71
		Transportation	144	135	122	148	153	117
		General Government	264	258	309	321	313	224
		Public Safety	338	283	301	294	250	241
		Other	233	279	382	291	279	292
		Total	1,989	1,501	1,652	1,588	1,482	1,429

	Group Average Per Capita Expenditures by Object
		Salaries & Wages	522	425	419	406	352	309
		Capital Outlay	418	241	302	298	334	370
		Other Operating	1,049	835	931	884	796	750
		Total	1,989	1,501	1,652	1,588	1,482	1,429


General Fund Go to top of page			2011	2010	2009	2008	2007	2006
	General Fund revenues		$961,992	864,145	875,800	1,036,791	916,553	903,180
	General Fund expenditures		1,233,568	782,788	811,614	1,072,330	764,439	680,643
	Operating transfers in		-	-	-	-	-	-
	Operating transfers out		-	-	450,175	2,747	127,136	6,843
	Capital leases and installment purchase proceeds		-	-	-	-	-	-
	Other items		-	-	-	-	-	-
	Excess of revenues and other sources over (under) expenditures and other uses		(271,576)	81,357	(385,989)	(38,286)	24,978	215,694

	Fund balance available (FBA):
		In dollars	$0	926,638	839,490	734,464	783,295	742,458
		FBA as a % of GF Net Expenditures:
		Unit's FBA %	0.00	118.38	66.53	68.32	87.86	108.00
		Group weighted average FBA %	91.95	100.58	103.21	88.65	100.61	101.57
		State weighted average Non-Electric Group	38.21	38.71	37.89	36.66	37.39	37.38
		State weighted average FBA %	38.21	37.47	37.03	36.35	36.54	36.96


Enterprise Funds: Go to top of page
	Water/Sewer

	Combined financial results:
		Working capital	$795,178	292,168	246,294	(221,065)	(190,576)	(221,961)
		Quick ratio	5.72	4.61	4.05	0.60	0.65	0.62
		Net income	88,482	24,544	456,877	51,493	44,713	98,846
		Cashflow from operations	262,857	128,232	137,576	186,126	180,646	190,738
		Depreciation & Amortization Expense	99,034	99,576	97,956	99,691	99,690	24,637



Cash, Investments and Financing Go to top of page			2011	2010	2009	2008	2007	2006

		Population at July 1st of the Previous Year	837	920	912	903	897	894
		Population Group	No Electric 500 to 999	No Electric 500 to 999	No Electric 500 to 999	No Electric 500 to 999	No Electric 500 to 999	No Electric 500 to 999
		Cash &Investments	$1,539,011	$1,221,720	$1,127,590	$1,009,836	$1,080,568	$1,048,248
		Investment Earnings	772	5,065	10,304	19,415	41,674	15,311
		Tax Rate Equivalent	0.0005	0.0033	0.0070	0.0129	0.0279	0.0103
		Tax Rate Equivalent Group weighted average	0.0032	0.0051	0.0185	0.0245	0.0375	0.0327
		Tax Rate Equivalent Statewide weighted average	0.0156	0.0247	0.0133	0.0524	0.0920	0.0573
		Latest year of Revaluation	2003	2003	2003	2003	2003	2003
		January 1, Prior Year Assessed Valuation	$153,676,817	155,352,732	147,973,888	150,915,044	149,607,072	148,987,073
		Tax Rate	0.3800	0.3600	0.3600	0.3600	0.3600	0.3600
		Tax Rate Group weighted average	0.2037	0.1922	0.1910	0.1936	0.2310	0.2737
		Tax Rate State Wide	0.4122	0.4090	0.4262	0.4238	0.4450	0.4321
		Assessment -to-Sales Ratio	99.47	82.67	82.81	87.95	90.83	94.52
		Assessment -to-Sales Ratio Group weighted average	98.51	101.44	87.47	87.75	77.67	88.06
		Assessment -to-Sales Ratio Statewide	101.47	98.27	90.81	88.53	88.41	92.28
		Assessed Valuation Adjusted for Assesment to Sales Ratio	$154,495,644	187,919,115	178,690,844	171,591,864	164,711,078	157,624,919
		EffectiveTax Rate	0.3780	0.2976	0.2981	0.3166	0.3270	0.3403
		Group weighted average Effective Tax Rate	0.2006	0.1950	0.1670	0.1699	0.1794	0.2410
		Statewide weighted average Effective Tax Rate	0.4183	0.4020	0.3870	0.3752	0.3934	0.3987
		Percent Collected	99.1500	99.1100	98.8900	98.7000	97.9900	99.3900
		Percent Collected Group weighted average	96.40	95.20	95.59	96.16	96.02	95.56
		Percent Collected Statewide	97.59	97.36	97.34	97.56	97.58	97.55
		Percent Collected Excluding Motor Vehicles	99.87	99.71	99.54	99.31	98.28	100.00
		Percent Collected Excluding Motor Vehicles Group weighted average	96.85	96.47	96.77	97.36	97.36	97.10
		Percent Collected Excluding Motor Vehicles Statewide weighted average	98.35	98.23	98.30	98.65	98.59	98.61
		Percent Collected Motor Vehicles Only	91.58	91.90	92.10	92.22	94.58	92.52
		Percent Collected Motor Vehicles Only Group weighted average	84.62	81.89	83.96	83.47	81.48	82.58
		Percent Collected Motor Vehicles Only Statewide weighted average	87.28	86.34	86.55	86.74	86.71	86.80
		Tax Uncollected	52,940	44,958	50,208	51,165	51,225	43,897
		Tax Rate Equivalent	0.0344	0.0289	0.0339	0.0339	0.0342	0.0295
		Dominant County: Wayne
	Debt Information
		Population Group	500 to 999	500 to 999	500 to 999	500 to 999	500 to 999	500 to 999
		Ratings:
		Fitch
		Moody's
		S & P

		General Obligation Debt (GO) where the taxing power of the entrire municipality is pledged to pay the obligation
		Enterprise GO Debt	$0	0	0	0	0	0
		General Government GO Debt	0	0	0	0	0	0
		Total General Obligation Debt	0	0	0	0	0	0
		Per Capita	$0	0	0	0	0	0
		Total Per Capita for the Population Group	#N/A	193	200	215	212	223
		Total Per Capita Statewide	#N/A	449	455	456	478	495
		Total per Assessed Valuation Adjusted for Current Year Sales	0.0000%	0.0000%	0.0000%	0.0000%	0.0000%	0.0000%
		Total per Assessed Valuation Adjusted for Current Year Sales- Group Average	#N/A	0.0895%	0.0813%	0.0884%	0.1085%	0.1673%
		Total per Assessed Valuation Adjusted for Current Year Sales - Statewide	#N/A	0.4104%	0.3909%	0.4132%	0.4706%	0.5275%
		Total Authorized but not Issued General Obligation Debt	$0

		Installment Sales Purchases and Lease Obligations
		--Enterprise	$0	0	0	0	0	61,732
		--General Government	0	448,668	520,477	592,286	664,095	700,000
		Total*	$0	448,668	520,477	592,286	664,095	761,732
		* The total only includes the contracts that require Local Government Commission approval.
		Revenue Bond Debt	$0	1,173,673	1,251,918	1,330,162	1,408,407	1,486,652


Annual Financial Information Report Detail Go to top of page
Line	Section	Description	2011	2010	2009	2008	2007	2006
	Population at July 1st of the Previous Year Adjusted for Boundry Changes		837	920	912	903	897	894

1.5A	FISCAL	Governmental Activities Assets	3,802,882	4,213,143	4,274,762	4,820,262	4,939,192	4,975,825
1.5B	SUMMARY	Governmental Activities Liabilities	19,800	446,340	534,135	607,040	696,779	723,956
3.5A		Business Type Activities Assets	3,640,476	2,978,251	3,031,644	2,656,581	2,683,163	2,778,961
3.5B		Business Type Activities Liabilties	1,750,153	1,176,410	1,254,347	1,336,161	1,414,236	1,554,747
6.5A		Fiduciary Funds Assets
6.5B		Fiduciary Funds Liabilties
10.0	PART 2	Current Collections of Unit -Wide Levy	591,675	558,710	543,565	541,815	526,084	535,612
11.0	TAX	Current Collections of Special Tax Districts
12.0	REVENUES	Prior Years' Levy Collections	7,311	3,785	7,147	10,807	3,285	4,312
13.0		Penalties and Interest	1,248	5,078	3,354	1,705	2,339
14.0		Collections of Taxes Previously Written Off
15.0		Animal Tax
15.1		Solid Waste Disposal Tax	458	640	420
16.0		1% Local Government Option Sales Tax	88,809	83,454	87,200	94,356	94,657	98,944
17.0		1/2% Local Government Option Sales Tax (40)	47,538	46,282	50,757	59,994	61,981	61,887
18.0		1/2% Local Government Option Sales Tax (42)	43,384	42,949	50,302	59,586	61,575	61,526
18.5		1/2% Local Government Option Sales Tax (44)		2,938	23,939	46,976	47,932	49,513
19.0		Privilege Licenses
19.2		Privilege -- All other privileges and pemits
20.0		Auto Licenses
21.0		Vehicle Tax for Public Transportation
22.0		Other Licenses	516	449	548	20,376	3,635	6,967
23.0		Local Occupancy Tax
24.0		Prepared Food Tax
25.0		911 Charges
26.0		Gross Short Term lease and Rental Tax
27.0	FEDERAL	Payments In Lieu of Taxes - Federal
28.0	INTERGOV	Equitable Sharing of Fed. Forfeited Prop.
29.0	REVENUES	General Government
30.0		Public Safety
31.0		Transportation - Streets
32.0		Transportation - All Other
33.0		Environmental Protection
34.0		Econ. & Phys. Dev. - Housing/Comm. Dev.
35.0		Econ. & Phys. Dev. - All Other
36.0		Human Services: Health, Mental Hlt & Hosp
37.0		Human Services: All Other
38.0		Culture & Recreation
39.0	STATE	Payments In Lieu of Taxes - State
40.0	INTERGOV	Unauthorized Substance Tax
41.0	REVENUES	Transitional Hold Harmless	44,667	31,371	10,821
42.0		Wireless Enhanced 911 Service Charges
42.1		Emergency Telephone Services Fund (ETSF) Revenues (Do not include interest)
42.2		ETSF Interest Income
43.0		Piped Natural Gas Charge Distribution
44.0		Utility Franchise Tax	53,294	36,378	34,919	20,259	32,814	22,921
45.0		Beer and Wine Tax	4,055	1,301	4,055	4,232	4,040	3,896
46.0		Powell Bill	35,246	34,898	39,184	42,022	37,645	38,117
50.0		Court Fees - Facilities and Arrest Fees
51.0		General Government
52.0		Public Safety					6,009
53.0		Transportation - Streets
54.0		Transportation - All Other
55.0		Environmental Protection
56.0		Econ. & Phys. Dev. - Housing/Community Dev
57.0		Econ. & Phys. Dev. - All Other
58.0		Human Services -Health, Mental Health, Hosp
59.0		Human Services - All Other
60.0		Culture and Recreation
61.0	LOCAL	Payments in Lieu of Taxes - Local
62.0	INTERGOV	General Government
63.0	REVENUES	Public Safety
64.0		Transportation - Streets
65.0		Transportation - All Other
66.0		Environmental Protection
67.0		Economic and Physical Development
68.0		Human Services - Health, Mental Hlt & Hosp
69.0		Human Services - All Other
70.0		Culture and Recreation
71.0	PERMITS	Building Permits	1,092	669	1,275	1,521	2,085	1,836
72.0	& FEES	Inspection Fees
72.1		Amusements licensing and permit taxes
73.0		Other Permits	7,025	7,340	8,450	6,220	6,450	5,200
74.0	SALES &	Parking Revenues
75.0	SERVICES	Rents and Royalties
76.0		Airport
77.0		Fire Protection Charges
78.0		Solid Waste
79.0		Ambulance and Rescue Squad Charges
80.0		Cemeteries
81.0		Recreation Service Revenues
82.0		Library Service Revenues
83.0		Other Cultural and Rec Service Revenues
84.0		Mass Transit - City Operated
85.0		Other Sales and Services
86.0	UTILITY	Water and Sewer Charges	294,729	266,731	240,303	273,528	271,557	275,341
87.0	REVENUES	Electric Charges
88.0		Gas Charges
88.1		Storm Water Fees
89.0	MISC.	Investment Earnings - Bond Proceeds
90.0	REVENUES	Investment Earnings - All Other Funds	772	5,065	10,304	19,415	41,674	15,311
91.0		Special Assessments
92.0		Private Contributions and Donations
93.0		Sales of Materials and Fixed Assets
94.0		Sale of Real Property
95.0		Nongovt Contr For Streets & Traffic Signals
96.0		ABC Mixed Drink Surcharge
97.0		ABC Profit Distribution
98.0		Other Miscellaneous Revenues	35,674	3,640	4,153	114,400	2,658	2,322
99.0		Proceeds of Sale of Bonds and Notes	613,666
100.0		Proceeds of Capital Leases/Install Purchases
101.0		Other						700,000
102.0	NON-REV	School - Current Levy Collections
103.0	RECEIPTS	Prior Years' Levy Collections
104.0		Tax Collections for Other Units
105.0		Utilities Customer's Deposits
106.0		Deposits Other than Utility
107.0		Prepaid Taxes
108.0		Prepaid Privilege Licenses
109A	PART 4	Governing Body - Salaries & Wages	209,114	213,509	208,479	211,628	192,704	223,501
109B	GENERAL	Governing Body - Other Direct	133,806	119,127	136,693	123,258	132,379	125,741
109C	GOVT	Governing Body - Construction					821,580	30,819
109D		Governing Body - Purchase of P,P&E					8,460
110A		Administration - Salaries & Wages
110B		Administration - Other Direct
110C		Administration - Construction
110D		Administration - Purchase of P,P&E
111A		Elections - Salaries & Wages
111B		Elections - Other Direct
111C		Elections - Construction
111D		Elections - Purchase of P,P&E
112A		Finance - Salaries & Wages
112B		Finance - Other Direct
112C		Finance - Construction
112D		Finance - Purchase of P,P&E
113A		Taxes - Salaries & Wages
113B		Taxes - Other Direct
113C		Taxes - Construction
113D		Taxes - Purchase of P,P&E
114A		Legal - Salaries & Wages
114B		Legal - Other Direct
114C		Legal - Construction
114D		Legal - Purchase of P,P&E
115A		Public Buildings - Salaries & Wages
115B		Public Buildings - Other Direct
115C		Public Buildings - Construction
115D		Public Buildings - Purchase of P,P&E
116A		Court Facilities - Salaries & Wages
116B		Court Facilities - Other Direct
116C		Court Facilities - Construction
116D		Court Facilities - Purchase of P,P&E
117A		Central Services - Salaries & Wages
117B		Central Services - Other Direct
117C		Central Services - Construction
117D		Central Services - Purchase of P,P&E
118A		Gen. Govt. All Other - Salaries & Wages
118B		Gen. Govt. All Other - Other Direct
118C		Gen. Govt. All Other - Construction
118D		Gen. Govt. All Other - Purchase of P,P&E
119A	PUBLIC	Police & Comm - Traffic Control - Salaries and Wages	93,137	91,867	96,885	87,367	84,650	44,411
119B	SAFETY	Police & Comm - Traffic Control - Other Direct	14,059	11,942	18,218	16,218	14,551	18,237
119C		Police & Comm - Traffic Control - Construction
119D		Police & Comm - Traffic Control - Purchase of P,P&E					7,633
120A		Emergency Communications - Salaries & Wages
120B		Emergency Communications - Other Direct
120C		Emergency Communications - Construction
120D		Emergency Communications - Purchase of P,P&E
120B		Emergency Telephone Service Fund (ETSF) Expenditures - Operating
120C		ETSF Expenditures - Capital Construction
120D		ETSF Expenditures - Capital Purchases
121A		Emergency Mgmt - Salaries & Wages
121B		Emergency Mgmt - Other Direct
121C		Emergency Mgmt - Construction
121D		Emergency Mgmt - Purchase of P,P&E
122A		Fire - Salaries & Wages
122B		Fire - Other Direct	69,932	69,932	69,738	68,504	67,168	72,175
122C		Fire - Construction
122D		Fire - Purchase of P,P&E
123A		Inspectors - Salaries & Wages
123B		Inspectors - Other Direct
123C		Inspectors - Construction
123D		Inspectors - Purchase of P,P&E
124A		Rescue Units - Salaries & Wages
124B		Rescue Units - Other Direct
124C		Rescue Units - Construction
124D		Rescue Units - Purchase of P,P&E
125A		Animal Control - Salaries & Wages
125B		Animal Control - Other Direct
125C		Animal Control - Construction
125D		Animal Control - Purchase of P,P&E
126A		Pub. Safety All Other - Salaries & Wages
126B		Pub. Safety All Other - Other Direct
126C		Pub. Safety All Other - Construction
126D		Pub. Safety All Other - Purchase of P,P&E
127A	TRANSPOR	Traffic Engineering - Salaries & Wages
127B	TATION	Traffic Engineering - Other Direct
127C		Traffic Engineering - Construction
127D		Traffic Engineering - Purchase of P,P&E
128A		Streets and Highways - Salaries & Wages
128B		Streets and Highways - Other Direct	173,609	80,843	66,917	318,842	54,209	54,831
128C		Streets and Highways - Construction
128D		Streets and Highways - Purchase of P,P&E
129A		Street Cleaning - Salaries & Wages
129B		Street Cleaning - Other Direct
129C		Street Cleaning - Construction
129D		Street Cleaning - Purchase of P,P&E
130A		Powell Bill - Salaries & Wages
130B		Powell Bill - Other Direct
130C		Powell Bill - Construction
130D		Powell Bill - Purchase of P,P&E
131A		Parking Facilities - Salaries & Wages
131B		Parking Facilities - Other Direct
131C		Parking Facilities - Construction
131D		Parking Facilities - Purchase of P,P&E
132A		Mass Transit - City - Salaries & Wages
132B		Mass Transit - City - Other Direct
132C		Mass Transit - City - Construction
132D		Mass Transit - City - Purchase of P,P&E
133B		Mass Transit - Private - Other Direct
134A		Airport - Salaries & Wages
134B		Airport - Other Direct
134C		Airport - Construction
134D		Airport - Purchase of P,P&E
135A		Transpor. All Other - Salaries & Wages
135B		Transpor. All Other - Other Direct
135C		Transpor. All Other - Construction
135D		Transpor. All Other - Purchase of P,P&E
136A	ENVIRON	Solid Waste - Salaries & Wages
136B	MENTAL	Solid Waste - Other Direct	76,656	73,947	73,517	62,664	66,404	52,319
136C	PROTECTION	Solid Waste - Construction
136D		Solid Waste - Purchase of P,P&E
137A		Drainage & Watershed - Salaries & Wages
137B		Drainage & Watershed - Other Direct
137C		Drainage & Watershed - Construction
137D		Drainage & Watershed - Purchase of P,P&E
138A		Cemeteries - Salaries & Wages
138B		Cemeteries - Other Direct
138C		Cemeteries - Construction
138D		Cemeteries - Purchase of P,P&E
139A		Environ. All Other - Salaries & Wages
139B		Environ. All Other - Other Direct
139C		Environ. All Other - Construction
139D		Environ. All Other - Purchase of P,P&E
140A	ECONOMIC	Planning & Zoning - Salaries & Wages
140B	& PHYSICAL	Planning & Zoning - Other Direct		595
140C	DEVELOP	Planning & Zoning - Construction
140D		Planning & Zoning - Purchase of P,P&E
141A		Economic Development - Salaries & Wages
141B		Economic Development - Other Direct
141C		Economic Development - Construction
141D		Economic Development - Purchase of P,P&E
142A		Community Development - Salaries & Wages
142B		Community Development - Other Direct
142C		Community Development - Construction
142D		Community Development - Purchase of P,P&E
143A		Housing & Urban Renewal - Salaries & Wages
143B		Housing & Urban Renewal - Other Direct
143C		Housing & Urban Renewal - Construction
143D		Housing & Urban Renewal - Purchase of P,P&E
144A		Special Empl Programs - Salaries & Wages
144B		Special Empl Programs - Other Direct
144C		Special Empl Programs - Construction
144D		Special Empl Programs - Purchase of P,P&E
145A		Econ. Dev. All Other - Salaries & Wages
145B		Econ. Dev. All Other - Other Direct				3,958
145C		Econ. Dev. All Other - Construction
145D		Econ. Dev. All Other - Purchase of P,P&E
146A	HUMAN	Health - Salaries & Wages
146B	SERVICES	Health - Other Direct
146C		Health - Construction
146D		Health - Purchase of P,P&E
147A		Mental Health - Salaries & Wages
147B		Mental Health - Other Direct
147C		Mental Health - Construction
147D		Mental Health - Purchase of P,P&E
148A		Social Services - Salaries & Wages
148B		Social Services - Other Direct
148C		Social Services - Construction
148D		Social Services - Purchase of P,P&E
149B		Hospital-City - Other Direct
150B		Hospital-Private - Other Direct
151A		Legal Aid - Salaries & Wages
151B		Legal Aid - Other Direct
151C		Legal Aid - Construction
151D		Legal Aid - Purchase of P,P&E
152A		Human Serv. All Other - Salaries & Wages
152B		Human Serv. All Other - Other Direct
152C		Human Serv. All Other - Construction
152D		Human Serv. All Other - Purchase of P,P&E
153A	CULTURE	Recreation & Parks - Salaries & Wages
153B	RECREATION	Recreation & Parks - Other Direct	12,123	25,785	43,105
153C		Recreation & Parks - Construction				5,281	5,000	5,500
153D		Recreation & Parks - Purchase of P,P&E
154A		Coliseum - Salaries & Wages
154B		Coliseum - Other Direct
154C		Coliseum - Construction
154D		Coliseum - Purchase of P,P&E
155A		Museums - Salaries & Wages
155B		Museums - Other Direct
155C		Museums - Construction
155D		Museums - Purchase of P,P&E
156A		Libraries - Salaries & Wages
156B		Libraries - Other Direct
156C		Libraries - Construction
156D		Libraries - Purchase of P,P&E
157A		Cult. & Recr. All Other - Salaries & Wages
157B		Cult. & Recr. All Other - Other Direct				48,592	68,344	80,758
157C		Cult. & Recr. All Other - Construction
157D		Cult. & Recr. All Other - Purchase of P,P&E
158A	UTILITY	Water & Sewer - Salaries & Wages
158B		Water & Sewer - Other Direct	79,582	113,117	108,048	97,900	93,385	92,053
158C		Water & Sewer - Construction	40,347
158D		Water & Sewer - Purchase of P,P&E	130,460		9,230	103,430	13,660
159A		Electric Power - Salaries & Wages
159B		Electric Power - Other Direct
159C		Electric Power - Construction
159D		Electric Power - Purchase of P,P&E
160A		Natural Gas - Salaries & Wages
160B		Natural Gas - Other Direct
160C		Natural Gas - Construction
160D		Natural Gas - Purchase of P,P&E
161.1A		Storm Water - Salaries & Wages
161.1B		Storm Water - Other Direct
161.1C		Storm Water - Construction
161.1D		Storm Water - Purchase of P,P&E
161B	DEBT	Water & Sewer - Interest & Fees	28,403	30,296	32,190	34,084	38,265	40,656
161D	SERVICE	Water & Sewer - Principal	78,245	78,245	78,245	78,245	139,977	116,817
162B		Electric - Interest & Fees
162D		Electric - Principal
163B		Gas - Interest & Fees
163D		Gas - Principal
164B		School - Interest & Fees
164D		School - Principal
165B		Hospital - Interest & Fees
165D		Hospital - Principal
166B		All Other - Interest & Fees	16,856	19,832	22,827	32,744	23,685
166D		All Other - Principal	430,716	71,809	71,809	89,762	35,905
167B	PENSION	Direct Benefit Program - Other Direct
168B	FRINGE	Fringe Benefits Unallocated
169B		Separation Allowance - Law Enforcement
170B		Separation Allowance - Other Employees
171B		Supplemental Retirement - Law Enforcement	3,560	3,600	3,426	3,512	3,347	3,170
172B		Fringe Benefits Other
173A	INTERGOV	Multi-Cnty Libr Dis,Cnty,Or Other - Recipient
173B	EXPEND	Multi-Cnty Libr Dis,Cnty,Or Other - Item #
173C		Multi-Cnty Libr Dis,Cnty,Or Other - Amount
174A		Gen Gov Activities Shared W/ Cnty - Recipient
174B		Gen Gov Activities Shared W/ Cnty - Item #
174C		Gen Gov Activities Shared W/ Cnty - Amount
175A		Highways (Payments to State) - Recipient
175B		Highways (Payments to State) - Item No.
175C		Highways (Payments to State) - Amount
176A		Other - Intergovt. Expenditures - Recipient
176B		Other - Intergovt. Expenditures - Item #
176C		Other - Intergovt. Expenditures - Amount
177A		Other - Intergovt. Expenditures - Recipient
177B		Other - Intergovt. Expenditures - Item #
177C		Other - Intergovt. Expenditures - Amount
178A		Other - Intergovt. Expenditures - Recipient
178B		Other - Intergovt. Expenditures - Item #
178C		Other - Intergovt. Expenditures - Amount
179.0		Current year's levy -- Excluding motor vehicles	544,504.	520,277.00	501,726.00	501,232.00	494,156.00	495,000.00
180.0		Current year's levy -- Motor vehicles (only)	52,255.	43,456.00	47,916.00	47,730.00	42,735.00	43,897.00
181.0	PART 6	Uncollected Taxes - Current Year's Levy Except Mot Veh	685.	1,502.00	2,292.00	3,435.00	8,490.00	0.00
182.0	OTHER	Uncollected Taxes - CY Levy -Motor Vehicles	4,399	3,521	3,785	3,712	2,317	3,285
183.0	DATA	Percentage of Taxes Collected - All Property %	99.15	99.11	98.89	98.70	97.99	99.39
184.0	DATA	Percentage of Taxes Collected - Exclude Motor Vehicles%	99.87	99.71	99.54	99.31	98.28	100.00
185.0		Percentage of Taxes Collected - Motor Vehicles %	91.58	91.90	92.10	92.22	94.58	92.52
186.0		Ttl Amt Salaries/Wages for Construction
187A		Capital Reserve Schools - July 1, 2009
187B		Capital Reserve Schools - June 30, 2010
188A		Capital Reserve Hospitals - July 1, 2009
188B		Capital Reserve Hospitals - June 30, 2010
189A	PART 7	Cash On Hand & in Bank - Debt Service
189B	CASH &	Cash On Hand & in Bank - Construction Bond
189C	INVEST	Cash On Hand & in Bank - All Other	1,539,011	1,221,720	1,127,590	1,009,836	1,080,568	1,048,248
190A	PART	Appropriations Made During FY - B(1) - B(7)
190B	8	Expenditures Made During FY - B(1) - B(7)
191.0		Investment in Property - B(1) - B(4)
192.0		Amount Expended During FY - B(5) and B(7)
193.0		Amount of Tax Revenues Taken Into Account
194A	PART 9	Amount - Total Revenues	1,871,159	1,131,678	1,120,696	1,317,212	1,206,420	1,883,705
194B	FISCAL	Amount - Subtract Refunding Bond Proceeds
194C	SUMMARY	Amount - Subtract Interfund Transfers In
194D		Amount - Net Revenues	1,871,159	1,131,678	1,120,696	1,317,212	1,206,420	1,883,705
		Calculated amount	1,871,159	1,131,678	1,120,696	1,317,212	1,206,420	1,883,705
		Amounts in AGREEMENT??	Yes	Yes	Yes	Yes	Yes	Yes
		Difference
195A		Amount - Total Expenditures	1,590,605	1,004,446	1,039,327	1,385,989	1,871,306	960,988
195B		Amount - Subtract Pymts. to Refunded Debt Agent
195C		Amount - Subtract Interfund Transfers Out
195D		Amount - Net Expenditures	1,590,605	1,004,446	1,039,327	1,385,989	1,871,306	960,988
		Calculated amount	1,590,605	1,004,446	1,039,327	1,385,989	1,871,306	960,988
		Amounts in AGREEMENT??	Yes	Yes	Yes	Yes	Yes	Yes
		Difference

401A	Part 10	Number of residential accounts billed Water
401B	Water /	Number of residential accounts billed Sewer					409
402A	Sewer	Amount processed and/or purchased in units Water	27	29	28		37,517
402B	Operations	Amount processed and/or purchased in units Sewer	12	11	8		11,271
403A		Total amount billed in units - Water	25	21	26		36,177
403B		Total amount billed in units - Sewer	11	11	8		11,271
404A		Of the total in 403A above how many units were Residential W	24	20	26		36,177
404B		Of the total in 403B above how many units were Residential S
405A		Of the total in 403 above, how many units were Outside Muni W
405B		Of the total in 403 above, how many units were Outside Muni S
406A		Of the total in 405A above how many units were Residential W
406B		Of the total in 405B above how many units were Residential S
407A		Of the total in 403A, how many units were sold for redistribution
407B		Of the total in 403B how many unit were delivered in bulk	127,475	159,187	77,853	64,878	90,431
408A		Dollars related to 403A above	131,321	188,690	125,210	98,885	117,570
408B		Dollars related to 403B above	126,174	158,895	76,655	63,879	90,431
409A		Dollars related to 404A above	123,321	180,690	115,555	91,260	117,570
409B		Dollars related to 404B above
410A		Dollars related to 405A above
410B		Dollars related to 405B above
411A		Dollars related to 406A above
411B		Dollars related to 406B above
412A		Dollars related to 407A above
412B		Dollars related to 407B above	369	371	369	369
421A		Number of residential accounts billed - Water	172	172	172	172
421B		Number of residential accounts billed - Sewer	1	1	1	1
422A		Number of non-residential & bulk accounts billed - Water	1	1	1	1
422B		Number of non-residential & bulk accounts billed - Sewer	2	2	2	2	2	2
423A		Estimated percentage of accounts outside of municipal limits



950.0		Official	Louis Cook
951.0		Title	Village Manager
952.0		Date	01/12/2012	10/29/2010	12/06/2009	10/31/2008	10/31/2007	10/20/2006
953.0		Contact	Louis Cook
954.0		Title	Village Manager
955.0		Phone	919-778-9687
956.0		Fax	919-778-6088
957.0		E-Mail:

Go to top of page Key Ratios and Operations Statistics of Water and Sewer Systems for
Village of Walnut Creek

	2011	2010	2009	2008	2007	2006

Population	837	920	912	903	897	894
Population Group	No Electric 500 to 999	No Electric 500 to 999	No Electric 500 to 999	No Electric 500 to 999	No Electric 500 to 999	No Electric 500 to 999
Total Operating Revenues	$0	0	0	0	0	0
Total Operating Revenues Per Capita	$0	0	0	0	0	0
Group Weighted Average Revenues Per Capita	137	275	277	274	258	215
State Weighted Average Revenues Per Capita	20	273	252	255	255	249

% to Total Operating Revenues
Operating Expenses	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
Group Weighted Average	106.09%	108.37%	108.99%	108.37%	108.05%	109.50%
State Weighted Average	92.57%	83.23%	87.16%	84.09%	80.04%	79.35%

Operating Margin	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
Group Weighted Average	-6.09%	-8.37%	-8.99%	-8.37%	-8.05%	-9.50%
State Weighted Average	7.43%	16.77%	12.84%	15.91%	19.96%	20.65%

Operating Transfers In	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
Group Weighted Average	4.09%	1.06%	5.05%	4.83%	8.65%	8.02%
State Weighted Average	11.39%	1.58%	1.20%	1.31%	1.10%	1.56%

Operating Transfers Out	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
Group Weighted Average	2.11%	0.62%	0.69%	0.94%	4.11%	5.64%
State Weighted Average	17.30%	1.55%	2.65%	3.15%	1.85%	2.84%

Net Income before capital contributions	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
Group Weighted Average	48.01%	28.10%	44.73%	20.28%	46.94%	46.03%
State Weighted Average	212.96%	15.81%	-9.94%	18.14%	25.59%	24.27%

Key Ratios and Cash Flow

Quick Ratio	5.72	4.61	4.05	0.60	0.65	0.62
Group Weighted Average	3.80	3.46	3.30	2.93	2.76	3.51
State Weighted Average	3.94	3.21	2.82	2.96	2.91	2.83

Days Sales in Receivables	8.0	N/A	N/A	N/A	N/A	N/A
Group Weighted Average	24.9	62.5	55.9	47.5	49.0	47.0
State Weighted Average	13.0	57.9	58.5	56.6	61.6	59.8

Days Cash on Hand	0.0	0.0	0.0	0.0	0.0	0.0
Group Weighted Average	-2,184.7	602.4	648.8	600.1	591.3	635.4
State Weighted Average	-80.4	613.4	559.6	588.2	645.7	570.9

Cash flow from Operations	$262,857	128,232	137,576	186,126	180,646	190,738

Debt to Equity	0.00	0.00	0.00	0.00	0.00	0.00
Group Weighted Average	0.12	0.12	0.12	0.13	0.14	0.15
State Weighted Average	0.31	0.59	0.54	0.54	0.55	0.55

Debt per Capita	0	0	0	0	0	0
Group Weighted Average	160	273	283	311	316	288
State Weighted Average	34	897	784	781	761	733

Capital Expenditures:	2011	2010	2009	2008	2007	2006
	$0	0	0	0	0	0

	2005	2004	2003	2002
	$0	34,735	100,578	0

Capital Contributions: Excluded from income above	$0	0	0	0	0	0


Operating Statistics

Estimated population of the areas served Water	0	0	0	0	897	NA
Estimated population of the areas served Sewer	0	0	0	0	409	NA

Number of Gallons of Water Processed (000) omitted	27	29	28	0	37,517	NA
Number of Gallons of Sewage Processed (000) omitted	12	11	8	0	11,271	NA

Number of Gallons of Water Billed (000) omitted	25	21	26	0	36,177	NA
Number of Gallons of Sewage Billed (000) omitted	11	11	8	0	11,271	NA

Ratio of Water Billed to Water Processed	0.91145	0.72414	0.93615		0.96428	NA
Ratio of Sewage Billed to Sewage Processed	0.91111	1.00000	1.00000		1.00000	NA

Total Revenue from Water Sales	127,475	159,187	77,853	64,878	90,431	NA
Total Revenue from Sewage Sales	131,321	188,690	125,210	98,885	117,570	NA

Water Revenue per 1000 gallons of Sales					100.81494	NA
Sewage Revenue per 1000 gallons of Sales					287.45721	NA

Group Average Sales per thousand Gallons Water	$0.00342	$25.16691	$28.47236	$12,972.02948	$5,350.70834	NA
Group Average Sales per thousand Gallons Sewage	$0.00223	$48.57325	$47.83284	$11,816.81710	$3,994.76021	NA

State Average Sales per thousand Gallons Water	$0.00342	$25.16691	$28.47236	$12,972.02948	$5,350.70834	NA
State Average Sales per thousand Gallons Sewage	$0.00223	$48.57325	$47.83284	$11,816.81710	$3,994.76021	NA

Residential Water Sales per thousand Gallons	$5,235.43568	7,944.75000	3,000.19569		2.49968	NA
Residential Sewage Sales per thousand Gallons	$11,345.07820	18,069.00000	15,007.14286		10.43120	NA

Water Sales per thousand Gallons outside Municipal Limits						NA
Sewage Sales per thousand Gallons outside Municipal Limits						NA

Total Water Sales per thousand gallons for Redistribution	$0.00000	0.00000	0.00000	0.00000	0.00000	NA
Total Sewage Sales per thousand gallons for Redistribution	$0.00000	0.00000	0.00000	0.00000	0.00000	NA

Financial Graphs and Comparisons

Analysis of Available Fund Balance: General Fund
Analysis of Property Tax Collection %
Analysis of General Obligation Debt
Analysis of Revenue (5 years)
Analyis of Revenue (most recent fiscal year)
Analysis of Expenditures by Function
Analysis of Expenditures by Object

Go to top of page

Analysis of Available Fund Balance: General Fund

	2007	2008	2009	2010	2011
Unit's FBA %	87.86%	68.32%	66.53%	118.38%	0.00%
Group average FBA %	100.61%	88.65%	103.21%	100.58%	91.95%
State average Electric/Non Electric Group FBA %	37.39%	36.66%	37.89%	38.71%	38.21%
State average FBA %	36.54%	36.35%	100.61%	37.47%	38.21%

Municipal Population Group: No Electric 500 to 999

Go to top of page

2007 2008 2009 2010 2011

Municipality 97.99% 98.70% 98.89% 99.11% 99.15%

Pop. Group 96.02% 96.16% 95.59% 95.20% 96.40%

Statewide 97.58% 97.56% 97.34% 97.36% 97.59%

Municipal Population Group: No Electric 500 to 999

	2007	2008	2009	2010	2011
Municipality	97.99%	98.70%	98.89%	99.11%	99.15%
Pop. Group	96.02%	96.16%	95.59%	95.20%	96.40%
Statewide	97.58%	97.56%	97.34%	97.36%	97.59%

Municipal Population Group: No Electric 500 to 999

Go to top of page

2007 2008 2009 2010 2011

Municipality 0 0 0 0 0

Pop. Group 212 215 200 193 #N/A

Statewide 478 456 455 449 #N/A

Municipal Population Group: 500 to 999

	2007	2008	2009	2010	2011
Municipality	0	0	0	0	0
Pop. Group	212	215	200	193	#N/A
Statewide	478	456	455	449	#N/A

Municipal Population Group: 500 to 999

Go to top of page

2007 2008 2009 2010 2011

Property Tax $593 614 608 617 717

Utility 303 303 263 290 352

Sales Tax 296 288 232 190 215

Sales & Services 7 7 9 8 8

Intergovernmental 90 74 98 113 164

Debt Proceeds 3 127 5 4 776

Other Miscellaneous 53 46 13 7 3

Total $1,345 1,459 1,228 1,229 2,235

	2007	2008	2009	2010	2011
Property Tax	$593	614	608	617	717
Utility	303	303	263	290	352
Sales Tax	296	288	232	190	215
Sales & Services	7	7	9	8	8
Intergovernmental	90	74	98	113	164
Debt Proceeds	3	127	5	4	776
Other Miscellaneous	53	46	13	7	3
Total	$1,345	1,459	1,228	1,229	2,235

Go to top of page

2011
2011

Category Revenue
Per Capita

Property Tax $600,234
$717

Water/Sewer 0
0

Electric 294,729
352

Other Utilities 0
0

Sales Tax 179,731
215

Sales & Services 7,025
8

Intergovernment 137,262
164

Debt Proceeds 649,340
776

Miscellaneous 2,380
3

Total $1,870,701
$2,235

Municipal Population Group: No Electric 500 to 999

Go to top of page

2011
2011

Category Expenditures
Per Capita

General Government $342,920
$410

Water/Sewer 0
0

Electric 250,389
299

Other Utilities 0
0

Debt Service 554,220
662

Transportation 173,609
207

Public Safety 180,688
216

Other 88,779
106

Total $1,590,605
$1,900

Municipal Population Group: No Electric 500 to 999

Go to top of page

2011
2011

Category Expenditures
Per Capita

Salaries & Wages $302,251
$361

Water/Sewer Capital 0
0

Electric Capital 170,807
204

Other Capital 0
0

Other Operating 1,117,547
1,335

Total $1,590,605
$1,900

Municipal Population Group: No Electric 500 to 999

Last Updated 1/31/2012 4:41:07 PM



	2011	2011
Category	Revenue	Per Capita
Property Tax	$600,234	$717
Water/Sewer	0	0
Electric	294,729	352
Other Utilities	0	0
Sales Tax	179,731	215
Sales & Services	7,025	8
Intergovernment	137,262	164
Debt Proceeds	649,340	776
Miscellaneous	2,380	3
Total	$1,870,701	$2,235

Municipal Population Group: No Electric 500 to 999

North CarolinaDepartment of State TreasurerFinancial InformationVillage of Walnut Creek

Financial Graphs and Comparisons

North Carolina
Department of State Treasurer
Financial Information
Village of Walnut Creek