The URL can be used to link to this page

Home My WebLink AboutExcel SpreadsheetFINANCIAL MASTER PLAN - WORK IN PROCESS AS OF 411412022 Table 2: Water General Fund Fiscal Year Ending Operating Revenue Residential Sales Commercial Sales Miscellaneous Revenue (1) Total Revenues Operating Expense Purchased Power Distribution Operations and Maintenance Customer Accounts and Administration Interdepartmental Rent Total Costs Net Operating Income NonOperatimg Revenue(Expense) Debt Service Interest Interest Income Total Other Net Income Adjustments to Net Income Capital Improvements Debt Service Principal Cash Transfers From(To) Facility Fee Reserve From(To) Operating Reserve From(To) Meter Reserve From(To) Vehicle Reserve Fund Total Cash Transfers Debt Service Coverage (2) (1.25 requirement) Draft Budget Draft Budget Projection Projection Projection Projection Projection Projection Projection Projection $ 10,125,616 $ 10,727,529 $ 11,159,848 $ 11,609,590 $ 12,077,457 $ 12,442,196 $ 12,817,950 $ 12,946,130 $ 13,075,591 $13,206,347 1,283,892 1,356,673 1,411,347 1,468,224 1,527,394 1,573,521 1,621,041 1,637,252 1,653,624 1,670,160 414,481 419,854 421,953 424,063 426,183 428,314 430,456 432,608 434,771 436,945 $ 11,823,989 $ 12,504,056 $ 12,993,149 $ 13,501,878 $ 14,031,034 $ 14,444,031 $ 14,869,447 $ 15,015,990 $ 15,163,986 $15,313,452 $1,204,043 $ 1,216,0 $ 1,273,085 $ 1,337,248 $ 1,391,139 $ 1,447,202 $ 1,505,525 $ 1,566,197 $ 1,629,315 $ 1,694,976 3,428,900 3,619, 3,728,195 3,840,041 3,955,242 4,073,900 4,196,117 4,137,000 4,261,110 4,388,943 2,788,843 2,875, 2,961,314 3,300,153 3,399,158 3,501,133 3,606,167 3,529,352 3,635,232 ######### 553,602 561,47 589,553 607,240 625,457 644,220 663,547 683,453 703,957 725,076 $ 7,975,388 $ 8,272,267 $ 8,552,147 $ 9,084,682 $ 9,370,996 $ 9,666,455 $ 9,971,355 $ 9,916,002 $ 10,229,614 $10,553,285 $ 3,848,601 $ 4,231,789 $ 4,441,002 $ 4,417,195 $ 4,660,038 $ 4,777,576 $ 4,898,093 $ 5,099,987 $ 4,934,372 $ 4,760,168 $ (693,571) $ (644,817) $ (595,053) $ (546,319) $ (492,042) $ (432,182) $ (354,812) $ (332,288) $ (307,109) $ (283,368) 24,425 22,939 31,777 34,649 41,027 67,510 77,066 81,716 $ (642,410) $ (587,276) $ (570,628) $ (523,380) $ (460,264) $ (397,533) $ (313,785) $ (264,778) $ (230,043) $ (201,652) $ 3,206,191 $ 3,644,513 $ 3,870,374 $ 3,893,815 $ 4,199,773 $ 4,380,044 $ 4,584,307 $ 4,835,210 $ 4,704,329 $ 4,558,516 �8) $ � $ (2,868,686) $ (2,856,824) $ (3,043,483) $ (3,088,974) $ (3,736,293) $ (4,202,968) $ (4,043,876) $ (3,349,408) (1,432,014) (1,482,123) (1,380,414) (1,429,842) (1,487,404) (1,377,230) (580,065) (603,612) (625,132) (654,044) $ (4,361,802) $ (4,440,312) $ (4,249,100) $ (4,286,666) $ (4,530,886) $ (4,466,204) $ (4,316,358) $ (4,806,581) $ (4,669,009) $ (4,003,452) Z!, 305T"$ 356,07r $ 356,284 $ 355,324 $ 357,618 $ 356,179 $ 358,008 $ 358,672 $ 359,233 $ 360,884 668,968 224,356 285,275 285,933 (155,227) (70,560) (126,444) (137,856) 164,964 155,137 14,442 90,461 (162,006) 47,349 $ 1,155,610 $ 795,799 $ 230,106 $ 217,468 $ 522,581 $ 511,317 $ 372,450 $ 449,134 $ 197,227 $ 408,233 1.84 2.01 2.41 2.39 2.52 2.81 5.31 5.55 5.41 5.24 Ending Cash Balance 1 2,442,494 2,442,494 2,442,493 2,293,873 2,118,490 2,309,959 2,735,115 3,375,514 3,853,277 4,085,825 5,049,122 4/14/2022 of 2.58 PM 6 Financial Master Plan - 2016 8 2017 12.01.16[WaterCashltowj