October 2012 Financial StmtsHarnett Count y of Harnett
c o u N T Y Financial Summary Report
NORTH CAROLINA October 31, 2012
Revenues:
Ad valorem taxes
Other taxes and licenses
Unrestricted intergovernmental
Restricted intergovernmental
Permits and fees
Sales and services
Investment earnings
Other general revenues
Total revenues
Expenditures:
Current:
General government
Public safety
Environmental protection
Transportation
Economic and physical development
Human services
Cultural and recreational
Education
Debt service:
Principal
Interest and fees
Total expenditures
Excess(deficiency) of revenues over (under)
expenditures
Other financing sources (uses):
Capital Lease Sources
Residual Equity
Transfers in
Transfers out
Appropriated Fund Balance
Capital. Reserve
Contingency
Total other financing sources (uses)
Y -T -D Fund Balance Increase (Decrease)
General Fund
$ (4,289,740) (1,429,913) $ (18,185,064)
$
$
1,165,000
Current Budget
388,333.33 $ -
Y -T -D %
Annual Budget
(4 months)
Actual to Date
Collected
144,704 -
(448,421)
$ 53,704,461
17,901,487
$ 8,921,750
16.61%
1.4,133,123
4,711,041
1,371,835
9.71 %
40,044
13,348
13,606
33.98%
18,334,232
6,111,411
6,683,924
36.46 %
2,396,709
798,903
830,195
34.64%
10,038,375
3,346,125
1,756,619
17.50%
4,856
1,619
1,324
27.27%
2,421,979
807,326
1,128,689
46.60%
$ 101,073,779
33,691,260
$ 20,707,942
20.49%
Actual to Date
Current Budget
Including
Y -T -D %
Annual Budget
(4 months)
Encumbrances
Expended
$ 11,969,811
3,989,937
$ 5,561,851
46.47 %
27,473,043
9,157,681
11,819,792
43.02%
136,066
45,355
42,668
31.36 %
186,568
62,189
140,508
75.31%
5,149,735
1,716,578
1,878,689
36.48%
26,905,055
8,968,352
10,140,109
37.69 %
1,404,948
468,316
533,334
37.96%
20,950,818
6,983,606
8,674,273
41,40%
6,578,594
2,192,865
96,508
1.47%
4,608,881
1,536,294
5,275
0.11%
$ 105,363,519
35,1.21,173
$ 38,893,006
36.91%
$ (4,289,740) (1,429,913) $ (18,185,064)
$
$
1,165,000
$
388,333.33 $ -
1,037,351
$
345,784 -
434,113
$
144,704 -
(448,421)
$
(149,474) -
2,131,514
$
710,505 -
(29,817)
$
(9,939) -
4,289,740
$
1,429,913 $ -
-
$
- $ (18,185,064)
Current Year Encumbrances - General Fund $ 6,360,366
BALANCE SHEET - GENERAL FUND
October 31, 2012
Assets:
General Fund
Cash and investments
$13,504,132
Taxes receivable, net
45,163,059
Accounts receivable, net
4,220,390
Due from other funds
214,440
Inventories
87,430
Prepaid Items
774,272
Restricted assets:
Cash and cash equivalents
574,274
Accounts receivable
909,049
Capital assets:
Land and construction in progress
17,675,339
Other capital assets, net
35,626,187
School debt /assets
92,299,312
Total assets
$211,047,884
Liabilities:
Current liabilities:
Accounts payable and accrued liabilities $161,616
Due to other funds 429,646
Unearned revenues 214,559
Deferred revenues 49,651,425
Current portion of long term debt 6,424,013
Total current liabilities 56,881,259
Non - current liabilities:
Non - current portion of long term debt 123,258,025
Other post - employment benefits 5,164,299
Non - current portion of compensated absences 2,419,210
Total non - current liabilities 130,841,534
Total Liabilities $187,722,793
Fund Balances:
Reserved for Encumbrances
Reserved for Debt Service
Fund Balance
Total Fund Balances
Total liabilities and fund balance
6,360,366
7,480
16,957,245
23,325,091
$211,047,884
Harnett County of Harnett
iq 0 o u N T Y Financial Summary Report
� NORTH CAROLINA
October 31, 2012
Public Utilities Fund
Revenues:
Charges for services
Water and sewer taps
Investment earnings
Johnston County
Other operating revenues
Sale of Other Assets
Capital Outlay Offset
Fund Balance Appropriated
Total revenues
Expenditures:
Current Budget
Annual Budget
(4 months)
Actual to Date
$ 22,107,000
7,369,000
$ 7,123,465
345,000
115,000
92,450
5,000
1,667
120
3,600
1,200
-
2,258,812
752,937
970,254
1,000
333
-
-
0
-
885,097
295,032
-
$ 25,605,509
8,535,170
$ 8,186,289
Y -T -D %
32.22%
26.80%
2.40%
0.00%
42.95%
0.00%
0.00%
Actual to Date
Current Budget Including Y -T -D %
Annual Budget (4 months) Encumbrances Expended
Operating Expenses
$ 19,011,328
6,337,109 $
9,451,559
49.72%
Capital Lease Districts
2,792,620
930,873
59,075
2.12%
Depreciation Expense
-
0
-
0,00%
Debt Service:
0
Principal
2,216,099
738,700
385,417
17.39%
Interest
1,080,365
360,122
520,767
48.20%
Total expenditures
$ 25,100,412
8,366,804 $
10,416,818
41.50%
Revenue over(under) expenditures
$ 505,097 $
168,366 $
(2,230,529)
Other financing sources (uses):
Transfers in
Transfers out
Total other financing sources (uses)
Excess of revenues and other financing
sources (uses) over (under)
expenditures and other financing
sources (uses)
(505,097) (168,365.67)
$ (505,097) (168,366) $
Current Year Encumbrances - Public Utilities $ 3,864,780
$ (2,230,529)
Harnett County of Harnett
C 0 U N T Y Financial Summary Report
NORTH CAROLINA October 31, 2012
Solid Waste Fund
Other financing sources (uses):
Bonds and capital lease issuance - - _
Bond Premium - _ _
Revenue Bonds - _ _
Payment to Escrow Agent - - -
Residual Equity Transfer -
Transfers in -
Transfers out (200,000) (66,667) -
Total other financing sources (uses) $ (200,000) (66,667) $ -
Excess of revenues and other financing
sources (uses) over (under)
expenditures and other financing
sources (uses) (2,518,049
Current Year Encumbrances -Solid Waste S 2,082,313
Current Budget
Y -T -D %
Annual Budget
(4 months)
Actual to Date
Collected
Revenues:
Solid Waste User Fees
$ 5,014,623
1,671,541
$ 823,766
16.43%
Other operating revenues
400
133
177
44.25%
Investment Earnings
200
67
78
39.00%
Solid Waste state taxes
259,000
86,333
14
0.01%
Capital Outlay Offset
-
-
-
0.00%
Sale of Other Assets
2,000
667
-
0.00%
Fund Balance Appropriated
-
-
-
0.00%
Total revenues
$ 5,276,223
1,758,741
$ 824,035
15.62%
Actual to Date
Current Budget
Including
Y -T -D %
Annual Budget
(4 months)
Encumbrances
Expended
Expenditures:
Operating Expenses
$ 4,924,915
1,641,638
$ 3,342,084
67.86%
Depreciation Expense
-
-
-
0.00%
Debt Service:
_
_
Principal
65,518
21,839
-
0.00%
Interest
85,790
28,597
-
0.00%
Total expenditures
$ 5,076,223
1,692,074
$ 3,342,084
65.84%
Revenue over(under) expenditures
$ 200,000
66,667
$ (2,518,049)
Other financing sources (uses):
Bonds and capital lease issuance - - _
Bond Premium - _ _
Revenue Bonds - _ _
Payment to Escrow Agent - - -
Residual Equity Transfer -
Transfers in -
Transfers out (200,000) (66,667) -
Total other financing sources (uses) $ (200,000) (66,667) $ -
Excess of revenues and other financing
sources (uses) over (under)
expenditures and other financing
sources (uses) (2,518,049
Current Year Encumbrances -Solid Waste S 2,082,313
AARNETT COUNTY, NORTH CAROLINA
1' • PROPRIETARY D.
*ctober !
Non - current assets:
Land 1,827,526 912,287
Other capital assets, net 177,265,306 2,429,593
Bond issuance cost, net 722,803 26,648
Total non - current assets 179,815,634 3,368,528
Total assets $278,553,867 $7,970,701
Liabilities:
Current liabilities:
Accounts payable and accrued liabilities $219,055 $8,171
Due to other funds 0 5,000
Unearned revenues 96,097 0
Customer Deposits 1,643,780 0
Deferred Revenues 314,122 3,009,927
Current portion of long term debt 2,216,067 65,517
Total current liabilities 4,489,122 3,088,615
Non- current liabilities:
Non- current portion of long term debt
Water & Sewer
1,885,057
Post Closure Liabilities
Fund
Solid Waste Fund
Assets:
740,420
78,910
Current assets:
540,442
48,850
Cash and cash investments
$13,364,886
$490,412
Accounts receivable, net
2,696,867
2,226,685
Due from other funds
4,325,953
0
Inventory
513,712
0
Prepaid
0
0
Restricted assets:
0
0
Cash and cash investments, restricted
309,903
18
Amounts to be provided /debt
77,526,912
1,885,057
Total current assets
98,738,233
4,602,172
Non - current assets:
Land 1,827,526 912,287
Other capital assets, net 177,265,306 2,429,593
Bond issuance cost, net 722,803 26,648
Total non - current assets 179,815,634 3,368,528
Total assets $278,553,867 $7,970,701
Liabilities:
Current liabilities:
Accounts payable and accrued liabilities $219,055 $8,171
Due to other funds 0 5,000
Unearned revenues 96,097 0
Customer Deposits 1,643,780 0
Deferred Revenues 314,122 3,009,927
Current portion of long term debt 2,216,067 65,517
Total current liabilities 4,489,122 3,088,615
Non- current liabilities:
Non- current portion of long term debt
77,216,912
1,885,057
Post Closure Liabilities
1,570,845
Other post - employment benefits
740,420
78,910
Non - current portion of compensated absences
540,442
48,850
Total non - current liabilities
78,497,774
3,583,662
Total Liabilities
$82,986,895
$6,672,277
Fund Balances:
Reserved Encumbrances
3,864,780
2,082,313
Reserved for Debt Service
201,109
0
GAAP Adjustments
1,536,473
0
Fund Balance
189,964,609
(783,889)
Total Fund Balances
195,566,971
1,298,424
Total liabilities and fund balance
$278,553,867
$7.970.701—