North Carolina
Department of State Treasurer
Financial Information
Town of Franklinville



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 Randolph County Map Page

The AFIR report that was due 10/31/2011 has not been received as of 02/04/2012The audit report that was due 10/31/2011 has not been received as of 02/04/2012


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
201120102009200820072006

Revenues by Source







Property Tax$0 133,108 140,831 137,846 124,732 122,822


Utility - 374,934 377,180 237,363 250,534 240,683


Sales Tax - 167,025 202,675 307,131 244,107 221,372


Sales & Services - 54,841 56,710 57,839 55,405 48,768


Intergovernmental - 157,173 238,112 70,136 64,507 61,761


Debt Proceeds - 4,641 6,071 26,366 19,891 19,124


Other Miscellaneous - 19,526 19,897 32,126 30,664 23,277


Total$0 911,248 1,041,476 868,807 789,840 737,807










Expenditures by Function







Utility$0 275,639 431,207 238,201 183,692 207,777


Debt Service - 22,753 29,560 56,897 54,560 53,397


Transportation - 204,044 158,652 164,607 256,482 201,821


General Government - 153,597 155,747 151,585 145,861 165,166


Public Safety - 45,355 43,896 38,326 32,749 16,984


Other - 119,547 122,850 80,095 96,229 82,285


Total$0 820,935 941,912 729,711 769,573 727,430










Expenditures by Object







Salaries & Wages$0 178,787 181,160 232,716 213,606 209,655


Capital Outlay - 52,210 216,706 5,407 110,546 123,244


Other Operating + Debt Service - 589,938 544,046 491,588 445,421 394,531


Total$0 820,935 941,912 729,711 769,573 727,430



















Per Capita Revenues by Source







Property Tax$0 93 100 100 91 91


Utility - 262 269 172 183 178


Sales Tax - 117 146 222 178 164


Sales & Services - 38 40 42 41 36


Intergovernmental - 110 170 51 47 46


Debt Proceeds - 3 4 19 15 14


Other Miscellaneous - 14 14 23 22 17


Total$0 637 743 629 577 546










Per Capita Expenditures by Function







Utility$0 193 308 172 134 154


Debt Service - 16 21 41 40 40


Transportation - 143 113 119 187 149


General Government - 106 111 110 108 121


Public Safety - 32 31 28 24 13


Other - 84 88 58 70 61


Total$0 574 672 528 563 538










Per Capita Expenditures by Object







Salaries & Wages$0 125 129 169 156 155


Capital Outlay - 37 155 4 81 91


Other Operating - 412 388 355 326 292


Total$0 574 672 528 563 538










Population GroupNo Electric 1,000 to 2,499 No Electric 1,000 to 2,499 No Electric 1,000 to 2,499 No Electric 1,000 to 2,499 No Electric 1,000 to 2,499 No Electric 1,000 to 2,499


Number of Municipalites in Group 102 96 100 101 101 103


Average Population In Group 1,623 1,660 1,652 1,661 1,642 1,638


Town of Franklinville Population 1,167 1,430 1,402 1,381 1,368 1,351

Group Average Per Capita Revenues by Source







Property Tax 433 414422406369348


Utility 472 435436423430399


Sales Tax 154 153178201195180


Sales & Services 103 8276807771


Intergovernmental 274 233228217220243


Debt Proceeds 36 3933463846


Other Miscellaneous 100 129162261203273


Total 1,572 1,4851,5351,6341,5321,560










Group Average Per Capita Expenditures by Function







Utility 465 499531572461487


Debt Service 139 130154126110108


Transportation 148 142148140142131


General Government 239 204216265201222


Public Safety 391 348350384346326


Other 197 177201203206205


Total 1,579 1,5001,6001,6901,4661,479










Group Average Per Capita Expenditures by Object







Salaries & Wages 527 465480450427402


Capital Outlay 244 258302483305373


Other Operating 808 777818757733704


Total 1,579 1,5001,6001,6901,4651,479


















General Fund
Go to top of page
201120102009200820072006

General Fund revenues
488,965 494,935 610,081 519,989 479,893

General Fund expenditures
488,509 472,964 434,388 519,392 458,296

Operating transfers in
- - - - -

Operating transfers out
- 34,498 22,733 15,600 -

Capital leases and installment purchase proceeds
- - - 38,000 -

Other items
- - - 1,800 -

Excess of revenues and other sources over (under) expenditures and other uses
456 (12,527) 152,960 24,797 21,597










Fund balance available (FBA):







In dollars
547,212 539,952 432,017 362,566 339,129


FBA as a % of GF Net Expenditures:







Unit's FBA %
112.02106.4094.5172.9574.00


Group weighted average FBA %73.2466.7966.0562.4465.4864.58


State weighted average Non-Electric Group26.6838.7137.8936.6637.3937.38


State weighted average FBA %29.0137.4737.0336.3536.5436.96

















Enterprise Funds:
Go to top of page







Water/Sewer













Combined financial results:







Working capital
304,472 226,080 (205,275) 83,625 22,209


Quick ratio
8.37 5.58 0.43 1.29 1.37


Net income
(92,165)130,470 2,072,626 464,811 (22,616)


Cashflow from operations
90,588 78,065 111,918 90,153 86,863


Depreciation & Amortization Expense
175,271 142,755 97,833 99,558 101,463


























Cash, Investments and Financing
Go to top of page
201120102009200820072006











Population at July 1st of the Previous Year1,1671,4301,4021,3811,3681,351


Population GroupNo Electric 1,000 to 2,499 No Electric 1,000 to 2,499 No Electric 1,000 to 2,499 No Electric 1,000 to 2,499 No Electric 1,000 to 2,499 No Electric 1,000 to 2,499


Cash &Investments$0 $931,498 $839,664 $656,108 $543,469 $465,336


Investment Earnings0 4,490 7,172 19,351 18,239 12,927


Tax Rate Equivalent0.00000.01210.01990.05790.06200.0447


Tax Rate Equivalent Group weighted average0.00310.00450.01310.02610.04090.0283


Tax Rate Equivalent Statewide weighted average0.01560.02470.01330.05240.09200.0573


Latest year of Revaluation 200720072007200720012001


January 1, Prior Year Assessed Valuation$36,702,765 37,077,829 35,958,696 33,441,622 29,411,811 28,906,571


Tax Rate0.42000.42000.42000.40000.40000.4000


Tax Rate Group weighted average0.27770.29700.29830.28600.34240.3297


Tax Rate State Wide0.41220.40900.42620.42380.44500.4321


Assessment -to-Sales Ratio97.4898.1992.4396.7686.1888.20


Assessment -to-Sales Ratio Group weighted average100.8297.6986.7788.9479.9685.71


Assessment -to-Sales Ratio Statewide101.4798.2790.8188.5388.4192.28


Assessed Valuation Adjusted for Assesment to Sales Ratio$37,651,585 37,761,309 38,903,707 34,561,412 34,128,349 32,773,890


EffectiveTax Rate0.40940.41240.38820.38700.34470.3528


Group weighted average Effective Tax Rate0.28000.29010.25890.25440.27370.2826


Statewide weighted average Effective Tax Rate0.41830.40200.38700.37520.39340.3987


Percent Collected0.000081.060081.140094.070095.040094.0800


Percent Collected Group weighted average96.5395.3795.9996.8697.1896.94


Percent Collected Statewide97.5997.3697.3497.5697.5897.55


Percent Collected Excluding Motor Vehicles0.0081.6882.8997.2197.9798.35


Percent Collected Excluding Motor Vehicles Group weighted average97.1895.9996.6797.7898.0197.76


Percent Collected Excluding Motor Vehicles Statewide weighted average98.3598.2398.3098.6598.5998.61


Percent Collected Motor Vehicles Only 0.0076.1168.0475.2780.2672.69


Percent Collected Motor Vehicles Only Group weighted average84.3385.4584.6085.1686.0785.54


Percent Collected Motor Vehicles Only Statewide weighted average 87.2886.3486.5586.7486.7186.80


Tax Uncollected0 42,044 43,249 23,382 22,561 22,018


Tax Rate Equivalent0.00000.11340.12030.06990.07670.0762


Dominant County: Randolph






Debt Information








Population Group1,000 to 2,4991,000 to 2,4991,000 to 2,4991,000 to 2,4991,000 to 2,4991,000 to 2,499


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 8,731 22,131 34,131


General Government GO Debt0 0 0 0 0 0


Total General Obligation Debt0 0 0 8,731 22,131 34,131


Per Capita$0 0 0 6 16 25


Total Per Capita for the Population Group236 256 265 277 294 297


Total Per Capita Statewide450 449 455 456 478 495


Total per Assessed Valuation Adjusted for Current Year Sales0.0000%0.0000%0.0000%0.0253%0.0648%0.1041%


Total per Assessed Valuation Adjusted for Current Year Sales- Group Average0.1642%0.1838%0.1750%0.1852%0.2336%0.2606%


Total per Assessed Valuation Adjusted for Current Year Sales - Statewide0.4280%0.4134%0.3909%0.4132%0.4706%0.5275%


Total Authorized but not Issued General Obligation Debt
















Installment Sales Purchases and Lease Obligations







--Enterprise$0 0 0 0 0 0


--General Government0 0 0 0 0 0


Total*$0 0 0 0 0 0


* The total only includes the contracts that require Local Government Commission approval.




Revenue Bond Debt $297,000 300,000 300,000 0 0 0


















Annual Financial Information Report Detail
Go to top of page






LineSectionDescription201120102009200820072006

Population at July 1st of the Previous Year Adjusted for Boundry Changes1,1671,4301,4021,3811,3681,351









1.5AFISCAL Governmental Activities Assets
1,157,8431,130,1961,099,839949,795853,935
1.5BSUMMARYGovernmental Activities Liabilities
26,57340,77954,76984,10853,233
3.5A
Business Type Activities Assets
5,537,5965,642,4915,529,9993,433,3572,743,911
3.5B
Business Type Activities Liabilties
338,340351,07069,048328,971104,336
6.5A
Fiduciary Funds Assets





6.5B
Fiduciary Funds Liabilties





10.0PART 2Current Collections of Unit -Wide Levy
124,605130,622135,233121,702117,535
11.0TAXCurrent Collections of Special Tax Districts





12.0REVENUESPrior Years' Levy Collections
6,2077,0472,0222,2582,874
13.0
Penalties and Interest
2,2963,1625917722,413
14.0
Collections of Taxes Previously Written Off





15.0
Animal Tax





15.1
Solid Waste Disposal Tax
955



16.0
1% Local Government Option Sales Tax
68,75280,892307,131244,107221,372
17.0
1/2% Local Government Option Sales Tax (40)
53,62351,243


18.0
1/2% Local Government Option Sales Tax (42)
40,78950,903


18.5
1/2% Local Government Option Sales Tax (44)
3,86119,637


19.0
Privilege Licenses
775725


19.2
Privilege -- All other privileges and pemits


775425350
20.0
Auto Licenses





21.0
Vehicle Tax for Public Transportation





22.0
Other Licenses





23.0
Local Occupancy Tax





24.0
Prepared Food Tax





25.0
911 Charges





26.0
Gross Short Term lease and Rental Tax





27.0FEDERALPayments In Lieu of Taxes - Federal





28.0INTERGOVEquitable Sharing of Fed. Forfeited Prop.





29.0REVENUESGeneral 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

160,504


36.0
Human Services: Health, Mental Hlt & Hosp





37.0
Human Services: All Other





38.0
Culture & Recreation





39.0STATEPayments In Lieu of Taxes - State





40.0INTERGOVUnauthorized Substance Tax





41.0REVENUESTransitional Hold Harmless
45,248



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
2,1032,014


44.0
Utility Franchise Tax
24,37823,35123,51123,78420,549
45.0
Beer and Wine Tax





46.0
Powell Bill
37,43141,83046,62540,72341,212
50.0
Court Fees - Facilities and Arrest Fees





51.0
General Government





52.0
Public Safety





53.0
Transportation - Streets





54.0
Transportation - All Other





55.0
Environmental Protection

643


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
48,0139,770


61.0LOCALPayments in Lieu of Taxes - Local





62.0INTERGOVGeneral Government





63.0REVENUESPublic 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
12,00012,00012,00012,00010,000
71.0PERMITS Building Permits





72.0& FEESInspection Fees





72.1
Amusements licensing and permit taxes





73.0
Other Permits
5256009755001,500
74.0SALES &Parking Revenues





75.0SERVICESRents and Royalties
5,7195,5505,3405,3406,050
76.0
Airport





77.0
Fire Protection Charges





78.0
Solid Waste
48,01449,78950,80148,62239,112
79.0
Ambulance and Rescue Squad Charges





80.0
Cemeteries





81.0
Recreation Service Revenues





82.0
Library Service Revenues
5837717238431,151
83.0
Other Cultural and Rec Service Revenues



100955
84.0
Mass Transit - City Operated





85.0
Other Sales and Services
3,6753,2753,010

86.0UTILITYWater and Sewer Charges
371,259373,905234,353250,534240,683
87.0REVENUESElectric Charges





88.0
Gas Charges





88.1
Storm Water Fees





89.0MISC.Investment Earnings - Bond Proceeds





90.0REVENUESInvestment Earnings - All Other Funds
4,4907,17219,35118,23912,927
91.0
Special Assessments





92.0
Private Contributions and Donations
2,261



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
4,6416,07126,36619,89119,124
99.0
Proceeds of Sale of Bonds and Notes





100.0
Proceeds of Capital Leases/Install Purchases





101.0
Other


31,6515,9424,587
102.0NON-REVSchool - Current Levy Collections





103.0RECEIPTSPrior 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





109APART 4Governing Body - Salaries & Wages
4,7004,7004,0404,0404,040
109BGENERALGoverning Body - Other Direct
1,461359


109CGOVTGoverning Body - Construction





109D
Governing Body - Purchase of P,P&E





110A
Administration - Salaries & Wages
60,71961,19079,60875,34686,839
110B
Administration - Other Direct
72,44777,83554,21853,14054,189
110C
Administration - Construction





110D
Administration - Purchase of P,P&E
1,730



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
12,54011,66313,71913,33513,891
115C
Public Buildings - Construction





115D
Public Buildings - Purchase of P,P&E




6,207
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





119APUBLICPolice & Comm - Traffic Control - Salaries and Wages





119BSAFETYPolice & Comm - Traffic Control - Other Direct





119C
Police & Comm - Traffic Control - Construction





119D
Police & Comm - Traffic Control - Purchase of P,P&E





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
45,35543,89638,32632,74916,984
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





127ATRANSPORTraffic Engineering - Salaries & Wages





127BTATIONTraffic Engineering - Other Direct





127C
Traffic Engineering - Construction





127D
Traffic Engineering - Purchase of P,P&E





128A
Streets and Highways - Salaries & Wages
99,79899,744131,937118,445103,410
128B
Streets and Highways - Other Direct
56,61451,20128,51830,28237,120
128C
Streets and Highways - Construction


1,257

128D
Streets and Highways - Purchase of P,P&E
1,4005,966
36,1349,320
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
46,2321,7412,8951,4035,300
130C
Powell Bill - Construction





130D
Powell Bill - Purchase of P,P&E



70,21846,671
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





136AENVIRONSolid Waste - Salaries & Wages





136BMENTALSolid Waste - Other Direct
55,09456,88353,74751,78348,486
136CPROTECTIONSolid 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





140AECONOMICPlanning & Zoning - Salaries & Wages





140B& PHYSICALPlanning & Zoning - Other Direct
2,500163


140CDEVELOPPlanning & 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





145C
Econ. Dev. All Other - Construction





145D
Econ. Dev. All Other - Purchase of P,P&E





146AHUMANHealth - Salaries & Wages





146BSERVICESHealth - 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





153ACULTURE Recreation & Parks - Salaries & Wages





153BRECREATIONRecreation & Parks - Other Direct
2,7056,9463,13111,0194,530
153C
Recreation & Parks - Construction
37,7479,770


153D
Recreation & Parks - Purchase of P,P&E

26,244

7,700
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
13,57015,52617,13115,77515,366
156B
Libraries - Other Direct
4,4523,1181,7111,5291,289
156C
Libraries - Construction





156D
Libraries - Purchase of P,P&E
3,4794,2004,1504,1944,154
157A
Cult. & Recr. All Other - Salaries & Wages





157B
Cult. & Recr. All Other - Other Direct


22511,929760
157C
Cult. & Recr. All Other - Construction





157D
Cult. & Recr. All Other - Purchase of P,P&E





158AUTILITYWater & Sewer - Salaries & Wages





158B
Water & Sewer - Other Direct
267,785260,681238,201183,692158,585
158C
Water & Sewer - Construction

163,026


158D
Water & Sewer - Purchase of P,P&E
7,8547,500

49,192
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





161BDEBTWater & Sewer - Interest & Fees
12,57010,8612,4865,0646,619
161DSERVICEWater & Sewer - Principal
4,99413,51031,27133,89631,545
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
1954107,2007,2001,782
166D
All Other - Principal
4,9944,77915,9408,40013,451
167BPENSIONDirect Benefit Program - Other Direct





168BFRINGEFringe Benefits Unallocated





169B
Separation Allowance - Law Enforcement





170B
Separation Allowance - Other Employees





171B
Supplemental Retirement - Law Enforcement





172B
Fringe Benefits Other





173AINTERGOVMulti-Cnty Libr Dis,Cnty,Or Other - Recipient





173BEXPENDMulti-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.136,717.00142,043.00119,976.00103,171.00101,946.00
180.0
Current year's levy -- Motor vehicles (only).16,996.0018,941.0020,031.0020,464.0020,334.00
181.0PART 6Uncollected Taxes - Current Year's Levy Except Mot Veh.25,048.0024,308.003,351.002,097.001,684.00
182.0OTHERUncollected Taxes - CY Levy -Motor Vehicles
4,0606,0544,9534,0395,554
183.0DATAPercentage of Taxes Collected - All Property %0.0081.0681.1494.0795.0494.08
184.0DATAPercentage of Taxes Collected - Exclude Motor Vehicles%0.0081.6882.8997.2197.9798.35
185.0
Percentage of Taxes Collected - Motor Vehicles %0.0076.1168.0475.2780.2672.69
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





189APART 7Cash On Hand & in Bank - Debt Service





189BCASH &Cash On Hand & in Bank - Construction Bond





189CINVESTCash On Hand & in Bank - All Other
931,498839,664656,108543,469465,336
190A PARTAppropriations Made During FY - B(1) - B(7)





190B 8Expenditures 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





194APART 9Amount - Total Revenues
912,2031,041,476900,458795,782742,394
194BFISCALAmount - Subtract Refunding Bond Proceeds





194CSUMMARYAmount - Subtract Interfund Transfers In





194D
Amount - Net Revenues
912,2031,041,476900,458795,782742,394


Calculated amount
912,2031,041,476900,458795,782742,394


Amounts in AGREEMENT??YesYesYesYesYesYes


Difference





195A
Amount - Total Expenditures
820,935941,912729,711769,573727,430
195B
Amount - Subtract Pymts. to Refunded Debt Agent





195C
Amount - Subtract Interfund Transfers Out





195D
Amount - Net Expenditures
820,935941,912729,711769,573727,430


Calculated amount
820,935941,912729,711769,573727,430


Amounts in AGREEMENT??YesYesYesYesYesYes


Difference














401APart 10Number of residential accounts billed Water





401BWater /Number of residential accounts billed Sewer



1,351
402ASewer Amount processed and/or purchased in units Water
35,350,77032,237,75033,282

402BOperationsAmount processed and/or purchased in units Sewer
13,847,78032


403A
Total amount billed in units - Water
494



403B
Total amount billed in units - Sewer
207



404A
Of the total in 403A above how many units were Residential W
484



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
6,216265,134175,219

408A
Dollars related to 403A above
1,90863,39757,834

408B
Dollars related to 403B above
4,397



409A
Dollars related to 404A above
1,806



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
465
482

421A
Number of residential accounts billed - Water
189
214

421B
Number of residential accounts billed - Sewer
7
26

422A
Number of non-residential & bulk accounts billed - Water
18
18

422B
Number of non-residential & bulk accounts billed - Sewer
22222
423A
Estimated percentage of accounts outside of municipal limits
































950.0
OfficialMelanie Neighbors

951.0
TitleFinance Officer

952.0
Date





953.0
ContactMelanie Neighbors

954.0
TitleFinance Officer

955.0
Phone336-824-2604




956.0
Fax336-824-2446




957.0
E-Mail:


















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



Town of Franklinville













201120102009200820072006








Population
1,1671,4301,4021,3811,3681,351
Population Group
No Electric 1,000 to 2,499 No Electric 1,000 to 2,499 No Electric 1,000 to 2,499 No Electric 1,000 to 2,499 No Electric 1,000 to 2,499 No Electric 1,000 to 2,499
Total Operating Revenues

371,259373,905339,654275,478256,612
Total Operating Revenues Per Capita

260267246201190
Group Weighted Average Revenues Per Capita34289290290274263
State Weighted Average Revenues Per Capita7272252255255249








% to Total Operating Revenues






Operating Expenses

121.45%107.90%95.99%99.87%106.32%
Group Weighted Average
99.05%105.51%106.51%104.66%105.75%103.04%
State Weighted Average
91.62%83.21%87.12%84.06%80.00%79.32%








Operating Margin

-21.45%-7.90%4.01%0.13%-6.32%
Group Weighted Average
0.95%-5.51%-6.51%-4.66%-5.75%-3.04%
State Weighted Average
8.38%16.79%12.88%15.94%20.00%20.68%








Operating Transfers In

0.00%2.78%0.00%0.00%0.00%
Group Weighted Average
16.51%10.42%6.34%4.91%3.25%3.52%
State Weighted Average
27.09%1.59%1.20%1.28%1.10%1.57%








Operating Transfers Out

0.00%0.00%0.00%0.00%0.00%
Group Weighted Average
18.35%1.61%7.42%1.88%2.88%15.74%
State Weighted Average
52.67%1.55%2.65%3.15%1.86%2.84%








Net Income before capital contributions

-24.82%-8.03%3.36%-1.63%-8.81%
Group Weighted Average
-77.01%11.11%-26.45%26.08%15.63%14.62%
State Weighted Average
643.66%15.82%-9.92%18.20%25.61%24.40%








Key Ratios and Cash Flow














Quick Ratio

8.375.580.431.291.37
Group Weighted Average
3.963.333.092.803.183.56
State Weighted Average
4.023.212.822.962.912.83








Days Sales in Receivables
8.048.454.553.1367.529.5
Group Weighted Average
4.145.545.450.549.943.3
State Weighted Average
1.257.958.556.761.659.8








Days Cash on Hand

396.5316.9181.6223.5135.8
Group Weighted Average
-105.6471.6447.9455.0692.9524.2
State Weighted Average
-16.4614.6560.8588.9647.0571.9








Cash flow from Operations

90,58878,065111,91890,15386,863








Debt to Equity

0.060.060.060.010.03
Group Weighted Average
0.270.240.260.290.270.28
State Weighted Average
0.220.590.540.540.550.55








Debt per Capita

2112192262651
Group Weighted Average
38422451482433421
State Weighted Average
8897783781761733








Capital Expenditures:
201120102009200820072006


$000000










2005200420032002



$3,5007,865137,68226,319









Capital Contributions: Excluded from income above
$00160,5042,061,197469,2980
















Operating Statistics














Estimated population of the areas served Water00001,351NA
Estimated population of the areas served Sewer00001,351NA








Number of Gallons of Water Processed (000) omitted035,350,77032,237,75033,2820NA
Number of Gallons of Sewage Processed (000) omitted013,847,7803200NA








Number of Gallons of Water Billed (000) omitted0494000NA
Number of Gallons of Sewage Billed (000) omitted0207000NA








Ratio of Water Billed to Water Processed
0.000010.000000.00000
NA
Ratio of Sewage Billed to Sewage Processed
0.000010.00000

NA








Total Revenue from Water Sales00000NA
Total Revenue from Sewage Sales01,90863,39757,8340NA








Water Revenue per 1000 gallons of Sales




0.00000NA
Sewage Revenue per 1000 gallons of Sales




0.00000NA








Group Average Sales per thousand Gallons Water$0.00016$58.68442$27.87923$1,769.81984$14,046.04813NA
Group Average Sales per thousand Gallons Sewage$0.00023$82.78241$36.57171$899.82774$7,994.92601NA








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








Residential Water Sales per thousand Gallons$0.000009.08471


NA
Residential Sewage Sales per thousand Gallons$0.000009.55556


NA








Water Sales per thousand Gallons outside Municipal Limits$0.00000



NA
Sewage Sales per thousand Gallons outside Municipal Limits$0.00000



NA








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




Financial Graphs and Comparisons


Go to top of page
Analysis of Available Fund Balance:  General Fund

20062007200820092010
Unit's FBA %74.00%72.95%94.51%106.40%112.02%
Group average FBA %64.58%65.48%62.44%66.05%66.79%
State average Electric/Non Electric Group FBA %37.38%37.39%36.66%37.89%38.71%
State average FBA %36.96%36.54%64.58%37.03%37.47%






Municipal Population Group: No Electric 1,000 to 2,499

Go to top of page
Analysis of Property Tax

20062007200820092010
Municipality94.08%95.04%94.07%81.14%81.06%
Pop. Group96.94%97.18%96.86%95.99%95.37%
Statewide97.55%97.58%97.56%97.34%97.36%






Municipal Population Group: No Electric 1,000 to 2,499






Go to top of page
Analysis of General Obligation Debt

20072008200920102011
Municipality166000
Pop. Group294277265256236
Statewide478456455449450






Municipal Population Group: 1,000 to 2,499






Go to top of page
Analysis of Revenue

20062007200820092010
Property Tax$919110010093
Utility178183172269262
Sales Tax164178222146117
Sales & Services3641424038
Intergovernmental464751170110
Debt Proceeds14151943
Other Miscellaneous1722231414
Total$546577629743637

Go to top of page
Analysis of Revenue for Fiscal 2011











2010
2010
CategoryRevenue
Per Capita
Property Tax$133,108
$93
Water/Sewer3,675
3
Electric371,259
260
Other Utilities0
0
Sales Tax167,025
117
Sales & Services54,841
38
Intergovernment157,173
110
Debt Proceeds4,641
3
Miscellaneous19,526
14
Total$911,248
$637





Municipal Population Group: No Electric 1,000 to 2,499





Go to top of page
Analysis of Expenditures by Function for Fiscal 2011











2010
2010
CategoryExpenditures
Per Capita
General Government$153,597
$106
Water/Sewer0
0
Electric275,639
193
Other Utilities0
0
Debt Service22,753
16
Transportation204,044
143
Public Safety45,355
32
Other119,547
84
Total$820,935
$574





Municipal Population Group: No Electric 1,000 to 2,499





Go to top of page
Analysis of Expenditures by Object for Fiscal 2011






2010
2010
CategoryExpenditures
Per Capita
Salaries & Wages$178,787
$125
Water/Sewer Capital0
0
Electric Capital7,854
5
Other Capital44,356
31
Other Operating589,938
412
Total$820,935
$574





Municipal Population Group: No Electric 1,000 to 2,499






Last Updated 2/7/2012 2:21:32 PM