2025 06 09 Work Session Packet 1

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

56 
 
Water Division 
Five Year Income and Cash Projections 
 
 
2026 2027 2028 2029 2030
REVENUE:
    Residential 2,351,164 2,468,722 2,592,159 2,721,766 2,857,855
    Small Commercial 2,421,961 2,543,059 2,670,212 2,803,723 2,943,909
    Large Commercial 559,917 569,379 579,002 588,787 598,737
    Other 323,549 326,785 330,053 333,353 336,687
Total Revenue 5,656,591$      5,907,946$      6,171,425$      6,447,629$      6,737,188$      
Purchased Supply 805,000 813,050 821,181 829,392 837,686
Contribution Margin 4,851,591$      5,094,896$      5,350,245$      5,618,237$      5,899,502$      
Operating Expenses 2,696,749        2,842,373        2,995,861        3,157,638        3,328,150        
Maintenance Expenses 694,966           724,154          754,569          786,261          819,284          
Depreciation Expense 834,872           883,128          934,173          988,168          1,045,284        
Other -                  -                 -                 -                 -                 
Debt Expense 82,500 82,025 76,719 71,270 65,664
Net Income Before Grants 542,505$         563,215$         588,923$         614,901$         641,120$         
Grants 33,000            
Net Income 575,505$         563,215$         588,923$         614,901$         641,120$         
Beginning Cash Estimate 7,240,142        2,136,249$      108,125$         (1,713,552)$     (3,530,705)$     
Depreciation 834,872           883,128          934,173          988,168          1,045,284        
New Debt
Debt Service 204,299           209,467          214,773          220,222          225,828          
Net Income 575,505           563,215          588,923          614,901          641,120          
Regular Capital Improvements 886,893           850,000          860,000          860,000          860,000          
Capital Investments 8,385,000        2,295,000        2,235,000        2,365,000        2,635,000        
Vehicles 310,000           210,000          125,000          65,000            -                 
Retirements and Salvage 3,271,922        90,000            90,000            90,000            90,001            
Estimated Ending Cash 2,136,249$      108,125$         (1,713,552)$     (3,530,705)$     (5,475,129)$     
Projected Ending Debt Balance 2,314,228        2,104,761        1,889,988        1,669,766        1,443,938        
O&M and Depreciation 5,114,086.73$  5,344,730.34$ 5,582,502.26$ 5,832,728.64$ 6,096,068.06$ 
57