TOWN OF CARY, NORTH CAROLINA
SEWER PROJECT SUB-FUND  
SCHEDULE OF REVENUES, EXPENDITURES, AND
CHANGES IN FUND NET ASSETS
BUDGET AND ACTUAL (NON-GAAP)
From Inception To June 30, 2006
Schedule 12
  Actual  
Project Prior Current Total
Authorization Years Year To Date
REVENUES
Intergovernmental Grants $1,564,750            1,359,156             205,594 1,564,750
Investment Earnings                 117,561               117,561 --- 117,561
Developer Reimbursements (Paid by Developers)                   64,953                 64,953               41,050 106,003
Miscellaneous Reimbursements                 142,500               142,500 --- 142,500
            Sub-total              1,889,764            1,684,170             246,644          1,930,814
            Less:  Completed Projects             (1,314,750)          (1,109,156)           (205,594) (1,314,750)
TOTAL REVENUES 575,014 575,014 41,050 616,064
EXPENDITURES
Asset-Related Projects
Annexation Sewer Lines - Doylin Dr.  * 75,665 75,665 --- 75,665
Annexation Sewer Lines - Frostwood Dr.  * 185,730 185,730 --- 185,730
Annexation Sewer Lines - Greenwood Acres 1,080,000 --- 129,679 129,679
Annexation Sewer Lines - Hazelwood Sewer 190,000 --- --- ---
Annexation Sewer Lines - Hillsdale Forest 1,320,000 241,266 767,220 1,008,486
Annexation Sewer Lines - Larkwood Ln.  * 384,381 370,145 14,237 384,382
Annexation Sewer Lines - Summerwinds 1 & 2 1,400,000 --- --- ---
Annexation Sewer Lines - Triangle Forest  * 414,809 23,071 391,738 414,809
Annexation Sewer Lines - Tryon Road
    (Summerwinds)  *
130,000 --- 130,000 130,000
Annexation Sewer Lines - Wild Weasel Way 145,000 --- --- ---
Annexation Sewer Lines - Windsor Oaks 1,520,359 --- 25,954 25,954
Annexation Sewer Lines - Woodland Dr. 250,000 --- --- ---
Annexation Sewer Lines - 2104 Piney Plains 250,000 --- --- ---
Annexation Sewer Lines - 9520 Chapel
    Hill Rd.  *
38,432 36,531 1,901 38,432
Annexation Sewer Lines - Main Project 1,615,624 8,107 (7,943) 164
Bachelor Branch Interceptor & Pump Station
    Elimination
1,950,000 --- --- ---
Camp Branch 'Reach A' Interceptor 1,580,000 29,907 173,892 203,799
Cape Fear Discharge Planning/Permitting 374,977 286,251 115,647 401,898
East Kit Creek Sewer Interceptor  * 103,952 --- 103,952 103,952
Fairfield Inn Pump Station Elimination  * 495,000 276,898 13,326 290,224
Fieldstone Pump Station Improvement 337,474 --- --- ---
Hollybrook Sewer Extension Pump Station
    Elimination
1,460,000 21,000 --- 21,000
Asset-Related Projects (cont'd)
Inflow/Infiltration SS Overflow Rehabilitation $350,000 --- --- ---
Kit Creek Basin Sanitary Sewer 429,548 --- --- ---
Kit Creek Pump Station Upgrade 3,200,000 2,391,824 (17,785) 2,374,039
Long Beverage Wholesale Distbution - Sewer 540,000 285,912 211,503 497,415
Morris Branch Regional Pump Station $6,387,479 4,058,206 30,761 4,088,967
Morrisville Pump Station Telemetry Upgrade 15,000 --- 14,619 14,619
NCWRF Odor Control 3,270,000 70,000 --- 70,000
NCWRF Upgrade (10 to 12 mgd) * 13,198,333 9,988,450 489,779 10,478,229
NCWRF Scum Thickener/Digester Pump
    Station Replacement  *
174,800 168,451 --- 168,451
NC55 Widening - Sewer Line 20,000 --- --- ---
NW Area Reclaimed Water - Phase 1 975,000 --- --- ---
Replace/Rehabilitate Sewer Clay Mains FY2003  * 212,762 212,762 --- 212,762
Replace/Rehabilitate Sewer Clay Mains FY2006 1,744,986 --- 170,737 170,737
Replace/Rehabilitate Sewer Clay Mains 937,500 874,912 11,000 885,912
Rocky Branch Sewer & Pump Station Elimination 3,970,000 83,000 139,329 222,329
Sanitary Sewer Oversizings FY2006  * 100,000 --- --- ---
Sewer System Flow Measure 350,000 205 135,587 135,792
Station #7 Offsite Sewer Extension 505,000 --- 54,973 54,973
Swift Creek Cross Gravitational Sewer Extension 100,000 --- --- ---
Swift Creek Pump Station Expansion 4,950,000 286,642 2,613,838 2,900,480
SCWRF Clarifier Repair & Upgrade  * 135,000 124,720 84 124,804
SCWRF Effluent Structure Cover 30,000 --- --- ---
SCWRF Filter & Clearwell Cover  * 30,000 16,131 --- 16,131
SCWRF Odor Control 795,008 41,600 25,883 67,483
Terrington Pump Station 800,000 --- 8,022 8,022
Thermal Biosolids Digester 1,200,000 --- 75,984 75,984
Thermal Biosolids Dryer  * 12,399,084 10,302,681 1,251,431 11,554,112
Thermal Biosolids Pump 30,000 --- 8,770 8,770
US1/64 Utility Relocation - Sewer 300,000 --- --- ---
Walnut Creek Flow Diversion 2,925,000 557,394 9,263 566,657
Walnut Creek Pump Station Grinder Addition  * 160,000 47,241 --- 47,241
Wastewater SCADA 130,000 --- --- ---
White Oak & Bachelor Branch Interceptor & Pump
    Station Elimination
2,060,000 58,040 51,477 109,517
Asset-Related Projects (cont'd)
WWRWMF - Design & Phase 4
    Planning/Permitting
$5,000,000 721,083 640,064 1,361,147
WWRWMF - New Water Reclamation Facility 13,453,253 --- 795,157 795,157
WWRWMF - New Water Reclamation Facility
    Pump Station & Force Main
3,313,396 --- 14,377 14,377
WWRWMF - Organization & Financial
    Development
600,000 61,296 6,025 67,321
WWRWMF - Project Management 45,000 --- 29,655 29,655
WWRWMF - West Cary Pump Station &
    Force Main
12,955,000 1,001,102 2,597,484 3,598,586
WWRWMF - Water Reclamation Facility Land 8,000,000 2,228 3,798,897 3,801,125
WWRWMF - Beaver Creek Pump Station &
    Force Main
1,384,762 --- --- ---
       Less: Local Government Reimbursements (10,948,039) (14,286) (1,701,399) (1,715,685)
            Total Expenditures , net 111,529,275 32,894,165 13,325,118 46,219,283
            Less: Completed Projects (noted by *) (24,557,971) (21,828,476) (2,281,546) (24,110,022)
            Construction-in-Progress 86,971,304 11,065,689 11,043,572 22,109,261
Expense Projects
Force Main Discharge Manhole 157,700 --- 781 781
I/I Elimination/Manhole Repair 425,000 268,670 --- 268,670
Reclaimed Water System Master Plan 150,000 --- --- ---
SCWRF Filter & Clearwell Cover  * 20,000 17,525 --- 17,525
Video Survey - Sewer Interceptor 788,100 240 268,534 268,774
West Cary Collection System Odor Control 75,000 --- --- ---
Water Reclamation Facility Management Study 250,000 --- --- ---
            Total Expenditures 1,865,800 286,435 269,315 555,750
            Less: Completed Projects (noted by *) (20,000) (17,525) --- (17,525)
            Other Projects-in-Progress 1,845,800 268,910 269,315 538,225
TOTAL EXPENDITURES 113,395,075 33,180,600 13,594,433 46,775,033
      Total Completed Projects (24,577,971) (21,846,001) (2,281,546) (24,127,547)
TOTAL PROJECTS IN PROGRESS 88,817,104 11,334,599 11,312,887 22,647,486
Revenues Under Expenditures (88,242,090) (10,759,585) (11,271,837) (22,031,422)
OTHER FINANCING SOURCES:
 State Revolving Loan Proceeds $16,084,334 9,644,274 2,424,930 12,069,204
 Bond Proceeds 57,324,346 19,280,435 --- 19,280,435
 Transfers In, net
       Utility System Operations Sub-Fund 9,000,000 9,000,000 --- 9,000,000
       Capital Reserve Sub-Fund, net 29,096,631 22,345,856 6,750,767 29,096,623
       Sub-Total 111,505,311 60,270,565 9,175,697 69,446,262
       Less:  Completed Projects (23,263,221) (22,820,825) (442,395) (23,263,220)
TOTAL OTHER FINANCING SOURCES 88,242,090 37,449,740 8,733,302 46,183,042
Increase (Decrease) 26,690,155 (2,538,535) 24,151,620
Adjustment for Closed Projects 2,083,980 (2,083,980) ---
FUND BALANCE $          --- 28,774,135 (4,622,515) 24,151,620
Accrual adjustments:
Construction-in-Progress Current Year 13,325,118
Construction-in-Progress Write-Off (20,085)
Debt Proceeds (2,424,930)
CHANGE IN NET ASSETS 6,257,588
Net Assets - Beginning of Year 55,067,746
Reclassification Between Utility Sub-Funds (24,089,932)
NET ASSETS - End of Year $37,235,402