PACKET 2026 6 8 Work Session website

Unverified text extraction. Check the original page for numbers, names, and layout.

56 
 
Water Division 
Five Year Income and Cash Projections 
 
 
2027 2028 2029 2030 2031
R
EVENUE:
    Residential 2,390,869 2,510,413 2,635,933 2,767,730 2,906,116
    Small Commercial 2,506,467 2,631,791 2,763,380 2,901,549 3,046,627
    Large Commercial 585,348 595,240 605,300 615,529 625,932
    Other 324,212 327,455 330,729 334,036 337,377
Total Revenue 5,806,897$      6,064,898$      6,335,342$      6,618,845$      6,916,052$      
Purchased Supply 935,612 944,968 954,418 963,962 973,602
Contribution Margin 4,871,285$      5,119,930$      5,380,924$      5,654,883$      5,942,450$      
Operating Expenses 2,853,567        3,007,660        3,170,073        3,341,257        3,521,685        
Maintenance Expenses 777,979           810,655          844,702          880,180          917,147          
Depreciation Expense 866,073           916,132          969,085          1,025,098        1,084,348        
Other -                  -                 -                 -                 -                 
Debt Expense 77,301 82,025 76,719 71,270 65,664
Net Income Before Grants 296,364$         303,458$         320,345$         337,078$         353,605$         
Grants 29,000            
Net Income 325,364$         303,458$         320,345$         337,078$         353,605$         
Beginning Cash Estimate 7,207,287        4,042,259$      896,627$         (4,444,771)$     (7,799,182)$     
Depreciation 866,073           916,132          969,085          1,025,098        1,084,348        
New Debt 6,500,000        
Debt Service 66,336            220,222          225,828          231,587          231,587          
Net Income 325,364           303,458          320,345          337,078          353,605          
Regular Capital Improvements 985,000           925,000          925,000          925,000          925,000          
Capital Investments 9,135,000        3,120,000        5,420,000        3,520,000        2,970,000        
Vehicles 260,000           190,000          150,000          130,000          -                 
Retirements and Salvage (410,129)          90,000            90,000            90,000            90,001            
Estimated Ending Cash 4,042,259$      896,627$         (4,444,771)$     (7,799,182)$     (10,397,814)$   
Projected Ending Debt Balance 8,802,477        8,582,255        8,356,427        8,124,840        7,893,253        
O&M and Depreciation 5,510,532.71$  5,761,439.55$ 6,014,996.78$ 6,281,766.49$ 6,562,446.19$