Loading...
HomeMy WebLinkAbout1994 - Utility Rate DesignCITY OF COLLEGE STATION PUBLIC UTILITIES DEPARTMENT UTILITY RATE DESIGN FISCAL YEAR 1994-1995 (City Council Review) July 13, 1994 McCord Engineering, Inc. P.O. Box 10047 College Station, Texas 77842 (409) 764-8356 UTILITY DEPARTMENT RATE DESIGN ISSUES Utility Department Financial History Debt Service Summary Planning Horizon Projections: Option I - Base Case - No Rate Increase Option 2 - With Proposed Rate Increases for Fiscal Years 1994-1995 through 1998-1999 Recommended Utility Rate Revision EXHIBIT I UTILITY DEPARTMENT FINANCIAL HISTORY EXHIBIT 1-1 Summary Results of Public Utilities Department Rate Design Revisions Made from 1987-1994 The cash after transfers level of the Water and Wastewater Divisions remain close to breakeven. Utility rates remain cost based as a result of yearly rate changes. Financial ratio's have been stabilized since 1987, although there has been some moderate decline in these ratios over the last several years. Overall utility rates remain competitive. Overall utility rate charges to customers reduced by approximately $1,102,000.00 during seven-year period. There has not been an electric rate increase since July, 1987. Exhibit 1-2 Impact Summary of Utility Rate Changes Implemented Since 1987 Fiscal Year Year 1 1987-1988 Year 2 1988-1989 Year 3 1989-1990 Year 4 1990-1991 Year 5 1991-1992 Year 6 1992-1993 Year 7 1993-1994 TOTAL Electric 1 (364,6.56)1 (1,853,366) (1,351,837) (1,054,000)1 (805,200) 0 0 (5,429,059)� BASE YEAR REVENUES 28,464,801 Cumulative % Change 1987-1994 —19.1% Water 336,734 388,873 413,271 454,0001 01 265,0851 107,5001 1,965,463 5,734,669 34.3% Wastewater 11 392,57711 4641493 538566 011 396;2671 312,0741 257,50011 2,361,477 utility 1 364,6551 (1,000,000� (400,000� (600,000� (408,933� 577,1591 365,0001 (1,1 02,119i ii 4,587,9821 38,787,452 2.8% 51.5% McCord Engineering, Ina REVISED 07/08/94 EXHIBIT 1-3 CITY OF COLLEGE STATION UTILITY DEPARTMENT INCOME STATEMENT HISTORY FISCALYEAR ENDING FISCALYEAR ENDING Historic JUNE 30, 1 SEPTEMBER 3). Avg Annual 1982 19133 1984, 1985 1986 19871 1988 19891 __ 1990 1991 1992 19931 1994 Change Budget '83-'93 OPERATING REVIENUES UTILITY FUND EW&S 16,238,982 22,859,371 25,804,393 31,454,025 32,059,552 32,443,586 34,477,499 35,575,328 36,236,745 36,286,364 36,702,517 38,772,153 41,656,255 4.92% OTHER 306.823 752,176 473,437 419,873 421,178 419,847 479,962 516,382 500,562 771,035 762,479 850,422 662,750 1.12%1 TOTAL 16,545,805 23,611,547 26,277,830 31,873,898 32,480,730 32,863,433 34,957,461 36,091,710 36,737,307 37,057,399 37,464,996 39,622,575 42,319,005 4.82%1 OPERATING EXPENSES ELECTRIC PURCHASED POWER 5,901,946 10,902,2294 10,502,052 15,186,058 15,975,006 15,345,559 16.909,722 17,954,520 18,715,821 19,072,974 18,637,583 19,334,322 20,015,914 5.35% TRANSMISSION 1,322 2,893 17,561 3,933 55,254 45,993 124,832 754,960 874,479 1,063,021 1,107,655 1,321,069 1,331,960 74.490/( DISTRIBUTION 699,967 978,319 1,180,211 1,445,327 1,511,842 1,401,348 1,420,327 1,047,310 1,000,366 1,089,172 1,306,643 1,619,283 1,725,745 4.69%1 WATER PRODUCTION 814,514 949,832 1,194,560 1,279,512 1,257,746 1,144,480 1,190,960 1,328,216 1,363,663 1,281,353 1,439,816 1,403,962 1,523,243 3.62% DISTRIBUTION 264,786 281,759 324,377 406,520 780,170 734,141 699,143 842,767 928,867 885,093 1,052,945 1,166,863 1,007,731 13.79% SEWER TREATMENT 368,855 500,568 569,973 687,184 964,592 978,042 946,702 925,236 960,446 1,005,242 1,257,357 1,265,454 1,368,674 8.80% COLLECTION 178,179 252,062 280,470 336,807 317,403 374,141 356,595 396,236 428,790 521,933 597,216 649,079 698,810 8.98% ADMIN. E,W&S 1,072,287 1,417,705 2,077,281 2,234,696 2,284,051 2,505,924 2,316,546 2,299,131 2,172,033 1,842,302 2,485,439 2,900,388 3,159,202 6.72% DEPR. EW&S 784,961 1,010,995 1,131,280 1,2OZ410 1,359,580 1,570,758 1,683,229 1,935,311 1,973,855 1,986,674 ZOOZO20 2,190,615 Z141,500 7.28% TOTAL 10,086,817 16,296,427 17,277,765 22,782,447 24,505,644 24,100,3861 25,648,057 27,483,6871 28,418,320 28,747,764 29,886,674 31,851,035 32,972,779 6.28%. RETURN 6,458,988 7,315,120 9,000,065 9,091,451 7,975,086 8,763,047 9,309,404 8,608,023 8,318,987 8,309,635 7,578,322 7,771,540 9,346,226 0.55% INTEREST ON LT DEBT 1,206,381 Z163,984 2,156,813 3,955,634 2,593,842 2,925,312 2,685,013 2,425,523 2,243,211 2,253,334 2,117,103 1,848,586 2,364,536 -1.42% OPERATING MARGIN 5,252,607 5,151,136 6,843,252 5,135,817 5,381,244 5,837,735 6,624,391 6,182,500 6,075,776 6,056,301 5,461,219 5,922,954 6,981,690 1.28% NON OPERATING REVENUE 320,107 482,698 716,628 446,834 715,029 406,155 431,866 824,792 644,687 891,695 846,076 936,699 852,600 6.21%[ NET MARGIN 5,572,714 5,633,834 7,559,880 5,582,651 6,096,273 6,243,890 7,056,257 7,007,292 6,720,463 6,947,996 6,307,295 6,859,653 7,834,290 1.81% CASH BEFORE TRANSFERS 7,564,056 E,808,813 10,847,973 10,740,695 10,049,695 10,739,960 11,424,499 11,368,126 10,937,529 11,188,004 10,426,418 10,898,854 12,340,326 1.95% LESS: DEBT SERVICE (2,340,993) (3,561,377) (3,960,764) (4,381,850) (5,599,935� (5,838,418) (5,734,263) (5,375,407) (4,678,665) (5,072,299) (4,994,538) (4,620,381) (5,420,671) -2.39% LESS: CAPITAL OUTLAY (1,445,218) (1,247,794) (995,303) (654,337) (297,597) (305,174) (229,587) (362,996) (452,025) (392,028) (232,815) (1,211,493) (533,000) 0.27% LESS: TRANS GEN FUND (1,647,247) (2,097,226) (2,774,940) (3,272,759) (4,066,951) (4,302,653) (4,363,483) (4,374,720) (4,277,625) (4,324,631) (3,740,T72� (4,128,504) (4,377,992) -6.35% LESS: ECONOMIC DEVELOP (50,000) (50,000) (110,000y (195,000) (165,000) PLUS: FROM BOND FUNDS 1,000,000 1,000,000 0 0 0 0 1 CASH AFTER TRANSFERS 2,130,598 1,902,416 3,116,966 2,431,749 85,212 293,715 1,097,166 2,255,0031 2,479,214 1,349,046 1,348,293 743,476 1,843,663 -8.19%1 FINANCIAL RATIOS: OPERATING TIER 5.35 3.38 4.17 2.30 3.07 3.00 3.47 3.55 3.71 3.69 3.58 4.20 3.95 NETTIER 5.62 3.60 4.51 2.41 3.35 3.13 3.63 3.89 4.00 4.08 3.98 4.71 4.31 DSC 3.23 2-47 2.74 2.45 1.79 1.84 1.99 2-11 2-34 2-21 209 236 2.28 ROR ON RATE BASE 16.72 16.55 17.90 15.47 11.98 12.00 12.77 12.22 12.08 11.59 12.43 10.94 12.62 RATE BASE ($)- 38,641,391 44,188,276 50,267,752 58,782,105 66,575,500 73,037,768 72,876,060 70,460,496 68,854,441 71,685,996 60,969,746 71,033,209 74,040,802 4.23% ROR ON EQUITY 28.11 24.13 26.02 18.98 19.56 18.67 18.41 16.96 15.12 14.90 12.69 12.95 14.09 EQUITY (S) 19,821,414 23,349,643 29,049,654 29,415,389 31,167,374 33,447,783 38,331,265 41,326,750 44,447,878 46,620,183 49,719,196 52,972,615 55,621,246 8.72% EDEBT-TO -EQUITY - 1.403 1.928 1.595 1.623 1.445 1.237 0.943 0.799 0.796 * Rate Base and Rate of Return figures are based on Adjusted Electric Division FERO Accounts, From FERC Accounting Setup Survey. McCord Engineering, Ina REVISED 07/08/94 OPERATING REVENUES ELECTRIC REVENUE OTHER TOTAL OPERATING B(PENSES PURCHASED POWER TRANSMISSION DISTRIBUTION ADMINISTRATION DEPRECIATION TOTAL RETURN INTEREST LT DEBT OPERATING MARGIN NON OPERATING INCOME EXHIBIT 1-4 CITY OF COLLEGE STAT`ION ELECTRIC DIVISION INCOME STATEMENT HISTORY FISCALYEAR ENDING FISCALYEAR ENDING 1 lAvg. Historic JUNE 30, SEPTEMBER 3 1, Annual 1982 1933 1984 1985 19M 1987 1988 19891 1990: 1991 1992 1993 � 1994 ! Change Budget 1 '83-'93 957,007 753,855 878,245 1,001,485 1,066,2151 1,233,395 !� 13,270,757 18,660,642 21,265,591 26,776,175 � 26,982,899 26,981,473 28,080,760 28,300,599 27,945,075 27,517,585 27,320,323 28,464,801 1 30,688,586 1 3.91% 254,806 616,785 388,218 356,891 353,790 348,473 388,769 41Z174 408,453 341,332 539,660 583,2191 448,750;; -0.51% 13,525,563 19,277,427 21,653,8091 27,133,066 27,336,689 27,329,946 28,469,529 28,712,773 28,353,528 27,858,917 27,859,983 29,048,0201 31,137,336 3.80% 5,901,946 10,902,294 10,502,052 15,186,058 15,975,006 15,345,559 16,909,722 17,954,520 18,715,821 19,072,974 18,637,583 19,334,322 1 20,015,914! 1,322 2,893 17,561 3,933 55,254 45,993 124,832 754,960 874,479 1,063,021 1,107,655 1,321,069 1,331,960 1 699,967 978,319 1,180,211 1,445,327 1,511,842 1,401,348 1,420,327 1,047,310 1,000,366 1,089,172 1,306,643 1,619,283 11725,745 557,589 652,144 851,685 849,184 674,972 775,292 764,460 1,148,519 973,530 1,076,846 1,316,207 1,503,670 1,737,771 346,688 461,156 542,694 528,909 529,166 522,331 572,787 682,315 705,563 747,541 725,945 862,828 750,000 7,507,512 12,996,806 13,094,203 18,013,411 18,746,240 18,090,523 19,792,128 21.587,624 22,269,759 23,049,554 23,094,033 24,641,172 1 25,561,390 6,018,051 6280,E21 8,559,606 9,119,655 8,590,449 9,239,423 8,677,401 7,125,149 6,083,769 4,809,363 4,765,950 4,406,M 5,575,946 �� 282,969 410,410 453,857 869,635 660,446 650,412 596,466 544,155 507,285 528,999 505,249 443,493 772,1221 5,735,082 5.870,211 8,105,749 8,250,020 7,930,003 8,589,011 8,080,935 6,580,994 5,576,484 4,280,364 4,260,701 3,963,355 4,803,824;, 262,488 395,812 587,635 379,809 600,624 337,109 358,449 701,254 594,816 773,155 773,483 915,694 779,800 NET MARGIN 5,997,570 6,266,023 8,693,384 8,629,829 8,530,627 8,926,120 8,439,384 7,282,248 6,171,300 5,053,519 5,034,184 4,879,049 1 5,583,624 CASH BEFORE TRANSFERS 6,627,227 7,137,589 9,689,935 10,028,373 9,720,239 10,098,863 9,608,637 8,508,718 7,384,148 6,330,059 6,265,378 6,185,3701 7,105,746 LESS: DEBT SERVICE (595,919) (776,617) (916,514) (1,062,250) (1,270,026) (1,316,795) (1,278,266) (1,229,782) (1,177,482) (1,183,9991 (1,182,849) (1,099,893) (1,660,707, LESS: CAPITAL OUTLAY (1,270,382) (943,973) (759,633) (466,088) (236,080) (236,161) (199,452) (190,091) (237,988) (227,979� (11Z487) (1,145,499) (533,000 LESS: TRANS GEN FUND (1,350,743) (1,719,725) (2,275,451) (2,781,845) (3,416,239) (3,571,202) (3,534,421) (3,674,765) (3,271,125) (3,318,131) (2,670,192) (2,871,704) (3,22 LESS: ECONOMIC DEVELOP (50,000) (50,000) (110,000) (195,000) (165,000) PLUS: FROM BOND FUNDS 210,000 210,000 CASH AFTER TRANSFERS 3,410,183 3M7,274 5,738,337 5,718,190 4,797,894 4,974,705 4,596,498 3,624,080 2,857,553 1,549,950 2,189,850 873,2741 1,519,047. FINANCIAL RATIOS: OPERATING TIER 21.27 15.30 18.86 10.49 13.01 14.21 14.55 13.09 11.99 9.09 9.43 9.94 7.22 NET TIER 22.20 1E.27 20.15 10.92 13.92 14.72 15.15 14.38 13.17 10.55 10.96 12.00 8.23 DSC 11.12 S.19 10.57 9-44 7.65 7.67 7.52 6.92 6.27 5.35 5.30 5.62 4.28 RATE OF RETURN 30.66 26.29 30.74 32.28 31.04 30.32 30.39 28.52 25.93 18.89 25.62 20.45 24.64 RATE BASE (S)- 19,627,586 23,889,664 27,847,931 28,247,806 27,674,560 30,475,315 28,552,247 24,986,046 23,464,379 25,456,985 18,603,912 21,549,724 22,627,210 * Rate Base and Rate of Return figures are based on Adjusted FERC Accounts, From FERC Accounting Setup Survey. 5.35% 74.49%� 4 ' 69% 7.89% 5�86% 5.99./.l -3.51% 7.929/o -2.25% -1.29% -3.21% -1.77% -4.77% -1229% McCord Engineering, Ina REVISED 07/08/94 EXHI BIT 1-5 CITY OF COLLEGE STATION WATER DIVISION INCOME STATEMENT HISTORY FISCALYEAR ENDING FISCALYEAR ENDING Historic 1Avg. JUNE 30, SEPTEMBER 30, Annual 19821 19831 19114 19851 19861 1987 19881 1989 1990 19911 1992 1993 1994 Change --- --- Budget '83-*93 OPERATING REVENUES BASE RATES 1,877,300 2,539,231 2,824,595 2,887,548 3,196,890 3,151,632 3,699,813 4,152,934 4,625,436 4,866,570 5,139,730 5,718,580 5,831,831 7 . 661/6 OTHER 34,181 82,739 52,078 37,790 42,118 41,985 52,796 65,032 59,958 99,248 128,591 152,045, 124,000 5.69% TOTAL 1,911,481 2,621,970 2,876,673 2,925,338 3,239,008 3,193,617 3,752,609 4,217,966 4,685,394 4,965,818 5,268,321 5,870,625 5,955,831 7.60% OPERATING E)(PEI\ISES 678,562 773,716 816,525 871,502 946,345 1'098 ' 996 PRODUCTION 814,514 949,832 1,194,560 1,279,512 1,257,746 1,144,480 1,190,960 1,328,216 1,363,663 1,281,353 1,439,816 1,403,962 1,523,243 3.62% DISTRIBUTION AND CC 264,786 281,759 324,377 406,520 780,170 734,141 699,143 842,767 928,867 885,093 1,052,945 1,166,863 1,007,731 13.79% ADMINISTRATION 332,409 467,843 789,367 826,838 969,666 1,006,312 926,618 777,608 807,990 527,608 692,820 755,769 804,975 4.46% DEPRECIATION 286,939 380,203 390,354 450,874 456,457 631,579 670,000 727,504 741,511 726,884 749,945 772,321 772,GOO 6.65% 2,570,825 2,530,9741 TOTAL 1,698,648 2,079,637 2,698,658 2,963,744 3,464,039 3,516,512 3,486,722 3,676,095 3,842,031 3,420,938 3,935,526 4,098,915 4,107,949 6.36% RETURN 212,833 542,333 178,015 (38,406i (225,031� (322,895) 265,887 541,871 843,363 1,544,880 1,332,795 1,771,710 1,847,882 11.36% INTEREST LT DEBT 645,469 1,101,177 1,103,523 1,865,394 1,165,938 1,362,406 1,261,334 1,130,944 1,042,076 980,948 896,937 773,908 640,207 -3.16% OPERATING MARGIN (432,636) (558,844) (925,508) (1,903,800) (1,390,9691 (1,685,301) (995,447) (589,073) (198,713) 563,932 435,858 997,802. 1,207,675 NON OPERATING INCOME 35,212 53,097 78,829 40,215 71,503 40,615 43,186 87,240 (9,795) 48,500 16,417 (64,778 3,600 NET MARGIN (397,424) (505,747) (846,679) (1,863,585) (1,319,466) (1,644,686) (952,261) (501,833) (208,508) 612,432 452,275 933,024 1,211,275 CASH BEFORE TRANSFERS 534,984 975,633 647,198 452,683 302,929 349,299 979,073 1,356,615 1,575,079 2,320,264 2,099,157 2,479,2531 2,623,482 8.85% LESS: DEBT SERVICE (1,141,120) (1,775,179) (1,982,072) (1,991,8951 (2,605,678) (2,695,840) (2,669,734) (2,483,259) (2,058,580) (2,273,198) (2,190,987) (2,019,9581 (1,806,095) -1.18% LESS: CAPITAL OUTLAY (101,122) (164,724) (146,372) (60,9441 (2,117) (24,901) (11,098) (42,649) (110,385) (86,652) (45,060) (17,71-Pi' 0 18.35% LESS: TRANS GEN FUND (181,197) (230,695) (305,243) (294,54 "1 (406,695) (430,265) (479,983) (437,472) (594,750) (594,750) (616,980) (690,600) (600,000] -10.48% PLUS: FROM BOND FUNDS 480,000 480,000 CASH AFTER TRANSFERS (888,455) (1,194,965) (1,786,489) (1,894,704� (2,711,561) (2,801,707) (2,181,742) (1,126,765) (708,636) (634,336) (753,870) (249,022) 217,387 13.29% FINANCIAL RATIOS: OPERATING TIER 0.33 0.49 0.16 (0.02) (0-19) (0-24) 0.21 0.48 0.81 1.57 1.49 2.29 2.89 NETTIER 0.38 0.54 0.23 0.00 (0-13) (0.21) 0.25 0.56 0.80 1.62 1.50 2.21 2.89 DSC 0.47 0.55 0.33 0.23 0.12 0.13 0.37 0.55 0.77 1.02 0.96 1.23 1.45 RATE OF RETURN 1.59 3.89 1.16 (0.231 (0-95) (1.24) 1.03 2.06 3.20 5.97 5.75 6.51 6.59 RATE BASE (S) 13.373,462 13,955,377 15,307,997 16,418,868 23,804,763, 25,939,804 25,923,308 26,342,471 26,344,117 25,855,924 23,171,749 27,203,378 28,019,479 McCord Engineering, Ina REVISED 07/08/94 OPERATING REVENUES BASE RATES OTHER TOTAL OPERATING E>(PENSES TREATMENT COLLECTION ADMINISTRATION DEPRECIATION TOTAL RETURN INTEREST LT DEBT OPERATING MARGIN NON OPERATING INCOME NET MARGIN CASH BEFORE TRANSFERS LESS: DEBT SERVICE LESS: CAPITAIL OUTLAY LESS: TRANS GEN FUND PLUS: FROM BOND FUNDS CASH AFTER TRANSFERS FINANCIAL RATIOS: OPERATING TIER NET TIER DSC RATE OF RETURN RATE BASE (S) EXHIBIT 1-6 CITY OF COLLEGE STATION WASTEWATER DIVISION INCOME STATEMENT HISTORY i FISCALYEAR ENDING FISCALYEAR ENDING Historic JUNE 30, SEPTEMBER 3), 1 Avg. Annual 1982 1983 1984 1985 19861 1987 1988 1989 1990 19911 1992 1993 1994 Change Budget '83-'93 1,090,925 1,659,498 1,714,207 1,790,302 1,879, 310 1 2,696,926 3,121,795 3,666,234 3,902,209 4,242,464 4,588,772 5,135,838 9.69% 33,141 25,192 25, 70 38,397 39,176 32,151 330,4551' 94,228 115,158� 90,000 7.37% 763 2 48 17,836 52,652 2 29,389 1,108,761 1,712,150 1,747,348 1,815,494 1,905,033 2,339,870 2,735,323 3,160,971 3,698,385 4,232,664 4,336,692 4,703,930 � 5,225,838 9.62% 368,855 500,568 569,973 687,184 964,592 978,042 946,702 925,236 960,446 1,005,242 1,257,357 1,265,454 1,368,674 8.80% 178,179 252,062 280,470 336,807 317,403 374,141 356,595 396,236 428,790 521,933 597,216 649,079 698,810 8.98% 182,289 297,718 436,229 558,674 639,413 724,320 625,467 373,004 390,513 237,848 476,412 640,949 616,456 7.22% 151.334 169,636 198,232 222,627 373,957 416,848 440,442 525,492 526,781 512,249 526,130 555,466 619,500 11.39% 10,948 2,683,940 880,657 1,219,984 1,484,904 1,805,292 2,295,365 � 2,493,351 2,369,207 2,219,968 2,306,530 2,277,272 2,857,115 3,1 3,303,440 8.88% 228,104 492,166 262,444 10,202 (390,3321� (153,481"' 366,116:: 941,003 1,391,855 1,955,392 1,479,577 1,592,982 1,922,398 11.27% 277,943 652,397 599,433 1,220,605 767,458 912,494 827,213 750,424 693,850 743,387 714,917 631,185 952,2071 (49,839) (160,231) (336,989) (1,210,403) (1,157,7901 (1,065,975; (461,09-1; 190,579 698,005 1,212,005 764,660 961,797 970,1911 22,407 33,789 50,164 26,810 42,902 28,431 30,231 36,298 59,666 70,040 56,176 85,783, 69,2001 8.84% (27,432; (126,442) (286,825) (1,183,593) (1,114,888) (1,037,544; (430,866) 226,877 757,671 1,282,045 820,836 1,047,580 1,039,391 401,845 695,591 510,840 259,639 26,527 291,798 836,789 1,502,793 1,978,302 2,537,681 2,061,883 2,234,231 2,611,098 11.19% (603,954) (1,009,581) (1,062,178) (1,327,705) (1,724,231 (1,825,763� (1,786,263) (1,662,366) (1,442,603) (1,615,102) (1,620,702) (1,500,5301 (1,953,869 -3.67% (73,714; (139,097) (89,298) (127,305) (59,4 ) (44,11 Z (19,037) (130,256) (103,652) (77,397) (75,268� (48,277! 0 9.17%' (115,307) (146,806) (194,246) (196,366 (244,01T, (301,186; (349,079) (262,483) (411,750) (411,750) (453,600 (566,200 � (550,000 -13.061/. 310,000 310,000 1 (1,317,590) (242,312) 330,297 433,432 (87,68 119,224 107,229 (391,130) (599,893) (834,882� (1,391,73� (2,001,121' 1: (1,879,283� 0.82 0.75 0.44 0.01 (0.51) (0.17) 0.44 1.25 2.01 2-63 2.07 2.52 2.02 0.90 0.81 0.52 0.03 (0-45) (0.14) 0.48 1.30 2.09 2.72 2.15 2.66 2.09 0.67 0.69 0.48 0.20 0.02 0.16 0.47 0.90 1.37 1.57 1.27 1.49 1.34 4.04 7.76 3.69 0.07 (2.59) (0-92) 1.99 4.92 7.31 9.60 7.71 7.15 8.22 5,640,343 6,343,236 7,111,824 14,115,431 15,096,178 16,622,648 18,400,505 19,131,979 19,045,944 20,373,087 19,194,086 22,280,107 23,394,112 m 8 6 Ml 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 YEAR - UTILITY WATER - ELECTRIC WASTEWATER Exhibit 1-8 CASH AFTER TRANSFERS r*l 4 cn 2 0 00, m 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 YEAR UTILITY WATER ELECTRIC WASTEWATER 0 -0 Lu 7' 20 W ry ui ry 10 I I 0 9 Exhibit 1-9 F-flor"'Tu"RY - RATES OF RETURN 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 YEAR RETURN ON EQUITY Exhibit 1-10 I"'TORY - OPERATING TIER 6 4 ry LLJ V-Z a_ 0 2 A 1982 983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 YEAR EXHIBIT 11 DEBT SERVICE SUMMARY EXHIBIT 11-1 Public Utilities Department Projected CIP Revenue Bond Sales FY 1994-1995 through FY 1998-1999 DIVISION Fiscal Year Electric Water Wastewater 1993-1994 4,000,000 0 0 1994-1995 7,650,000 825,000 9,750,000 1995-1996 6,625,000 1,200,000 2,310,000 1996-1997 5,500,000 1,975,000 3,600,000 1997-1998 5,000,000 1,500,000 1,590,000 Total Increase 28,775,000 51500,000 171250,000 TOTAL 4,000,000 18,225,000 10,135,000 11,075,000 8,090,000! 51,525,000 Fiscal Year 1994-1995 1995-1996 1996-1997 1997-1998 EXHIBIT 11-2 Public Utilities Department Debt Service Requirements Summary DEBT SERVICE REQUIREMENTS Present Revenue New Bond Debt Bond Debt With CIP Bond Sales 4,653,722 5,002,259 4,559,573 6,643,544 4,267,426 7,210,499 ITotal Increase jAverage increase 3,672,253 2,897,104 7,556,385 7,462,046 Increase 348,538 2,083,970 2,943,073 3,884,132 4,564,942 13,824,655 2,764,931 10 4 2 N Exhibit 11-3 Utility Department - Debt Service 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 1982 1984 1986 1988 1990 1992 1994 1996 1998 Year Historical Debt Service M 1994-1999 Projected Debt Servict 5 tC 4 3 m I W, 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 1982 1984 1986 1988 1990 1992 1994 1996 1998 Year Historical Debt Service m 1994-1999 Projected Debt Service I 5 I 3 2 i 1#1 Exhibit 11-5 A ater Division - Debt Service 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 1982 1984 1986 1988 1990 1992 1994 1996 1998 Year Historical Debt Service 0 1994-1999 Projected Debt Service 5 4 3 2 I I Exhibit 11-6 Wastewater Division - Debt Service 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 1982 1984 1986 1988 1990 1992 1994 1996 1998 Year i m Historical Debt Service M 1994-1999 Projected Debt Service EXHIBIT III PLANNING HORIZON PROJECTIONS FISCAL YEARS 1994-1995THROUGH 1998-1999 Option 1 - Base Case - No Rate Increase Option 2 - With Proposed Rate Increases for Fiscal Years 1994- 1995 through 1998-1999 OPTION - I PLANNING HORIZON PROJECTIONS FISCAL YEARS 1994-1995 THROUGH 1998-1999 Base Case - No Rate Increases McCord Engineering, Inc. REVISED 07/11/94 EXHIBIT III — 1.A CITY OF COLLEGE STATION UTILITY DEPARTMENT INCOME STATEMENT PROJECTION Base Case — No Rate Increases Projected ---------------- FISCAL YEAR ENDING SEPTEMBER 30 -------------- Annual 1995 1996 1997 1998 1999 Change OPERATING REVENUES UTILITY FUND E,W&S 44,770,433 47,449,319 50,054,262 52,473,994 54,964,066 WATER & SEWER TAPS 217,500 217,500 217,500 217,500 217,500 5.26% OTHER 550,000 562,000 574,000 586,000 598,000 2.11% TOTAL 45,537,933 48,228,819 50,845,762 53,277,494 55,779,566 5.20% OPERATING EXPENSES ELECTRIC PURCHASED POWER 24,158,950 26,294.005 28,239,768 30,077.756 31,988,555 7.27% TRANSMISSION 1,554,949 1,669,000 1,780,000 1,895,000 2,009.000 6.61% DISTRIBUTION 2,014,104 2,103,000 2,191.000 2,280,000 2,369,000 4,14% WATER PRODUCTION 1.489,529 1,600,000 1,642,000 1,686,000 1,729,000 3.80% DISTRIBUTION 1,117,147 1,216,000 1,276,000 1,335,000 1,395,000 5.71% SEWER TREATMENT 1,487,154 1,529,000 1,620,000 1,712,000 1,804,000 4.95% COLLECTION 789,152 804,000 887,000 969,000 1,052,000 7.45% ADMIN. E,W&S 2,945,399 3,750,469 3,803,475 4,027,954 4,255,287 9.63% DEPR. E,W&S 2,307,000 2,404,000 2,500,000 2,598,000 2,694,000 3.95% TOTAL 37,863,384 41,369,474 43,939,243 46,580.710 49,295,842 6.82% RETURN 7,674,549 6,859,345 6,906,519 6,696,784 6,483,724 —4.13% INTEREST ON LT DEBT 1,836.209 2.572.732 2,849.645 3.179.524 3.373.374 16.42% OPERATING MARGIN 5,838,340 4,286,613 4,056,874 3,517,260 3,110,350 —14.57% NON OPERATING REVENUE 868,800 886,000 903,200 921,400 939,600 1.98% NETMARGIN 6.707,140 5,172,613 4,960,074 4,438,660 4,049,950 —11.85% CASH BEFORE TRANSFERS 10,850,349 10,149,345 10,309,719 10,216,184 10,117,324 —1.73% LESS: DEBT SERVICE 14.958.668) (6.556.361) (7.079.725) (7,382,019) (7.287.681) —10.10% LESS: CAPITAL OUTLAY (757,000) (793,000) (884,000) (750,000) (550,000) —7.68% LESS: TRANS GEN FUND (4,694,215) (4,975,943) (5,249,898) (5,504,389) (5,766,272) 5.26% LESS: ECONOMIC DEVELOP (200,000) (205,000) (210,000) (215,000) (220,000) 2.41% LESS: TRANS RESERVES 0 0 0 0 0 CASH AFTER TRANSFERS 240,465 (2,380,959) (3,113,904) (3,635,224) (3,706,629) 98.14% FINANCIAL RATIOS: OPERATING TIER 4.18 2.67 2.42 2.11 1.92 NETTIER 4.65 3.01 2.74 2.40 2.20 DSC 2.19 1.55 1.46 1.38 1.39 ROR ON RATE BASE 9.94 8.52 8.23 7.66 7.11 RATE BASE ($)- 77.182,452 80,464,373 83,893,075 87,475,376 91.218,421 4.27% BASE—I.WK3 Rate Base and Rate of Return figures are based on Adjusted FERC Accounts. From FERC Accounting Setup Survey. McCord Engineering, Inc. REVISED 07/11/94 EXHIBITIII—I.B CITY OF COLLEGE STATION ELECTRIC DIVISION INCOME STATEMENT PROJECTION Base Case — No Rate Increases Projected ---------------- FISCAL YEAR ENDING SEPTEMBER 30 -------------- Annual 1995 1996 1997 1998 1999 Change OPERATING REVENUES ELECTRIC REVENUE 33,984,433 36,542,319 39,024,262 41,317,994 43,683,066 6.48% OTHER 450,000 460,000 470,000 480,000 490,000 2.15% TOTAL 34,434,433 37,002,319 39,494,262 41,797,994 44,173,066 6.42% OPERATING EXPENSES PURCHASED POWER 24,158,950 26,294,005 28,239.768 30,077,756 31,988,555 7,27% TRANSMISSION 1,554,949 1,669,000 1,780,000 1,895,000 2.009,000 6.61% DISTRIBUTION 2,014,104 2,103,000 2,191,000 2,280,000 2,369.000 4.14% ADMINISTRATION 1,501.399 2.238,469 2,222,475 2.378,954 2,538,287 14.03% DEPRECIATION 849,000 881,000 913.000 946,000 978,000 3.60% TOTAL 30,078,402 33,185,474 35,346.243 37,577,710 39,882,842 7.31% RETURN 4,356,031 3,816,845 4,148,019 4,220,284 4,290.224 —0.38% INTEREST LT DEBT 599,617 963,154 1,252.390 1,464.634 1.675,401 29.29% OPERATING MARGIN 3,756,414 2,853,691 2,895,629 2,755,650 2,614.823 —8.66% NON OPERATING INCOME 800,000 816,000 832,000 849,000 866,000 2.00% NETMARGIN 4,556,414 3,669,691 3,727,629 3,604,650 3,480,823 —6.51% CASH BEFORE TRANSFERS 6,005,031 5,513,845 5,893.019 6,015,284 6,134,224 0.53% LESS: DEBT SERVICE (1.414.352) (2.020.641) 12.487.003) 12.851.476) (3,008,759) 20.77% LESS: CAPITAL OUTLAY (677,000) (703,000) (784,000) (640,000) (430,000) —10.73% LESS: TRANS GEN FUND 10.5% (3,615.615) (3,885.243) (4,146,898) 14,388,789) (4,638,172) 6.42% LESS: ECONOMIC DEVELOP (200,000) (205,000) (210,000) (215,000) (220,000) 2.41% LESS: TRANS RESERVES 0 0 0 0 0 CASH AFTER TRANSFERS 98,063 (1,300,039) (1,734,882) (2,079,901) (2,162,707) FINANCIAL RATIOS: OPERATING TIER 7.26 3.96 3.31 2.88 2.56 NETTIER 8.60 4.81 3.98 3.46 3.08 DSC 4.25 2.73 2.37 2.11 2.04 RATE OF RETURN 18.33 15.30 15.84 15.34 14.86 RATE BASE 23,758,571 24.946,499 26,193,824 27,503,515 28,878,691 5.00% BASE—I.WK3 Rate Base and Rate of Return figures are based on Adjusted FERC Accounts, From FERC Accounting Setup Survey. McCord Engineering, Inc. REVISED 07/11/94 EXHIBIT III-1.0 CITY OF COLLEGE STATION WATER DIVISION INCOME STATEMENT PROJECTION Base Case — No Rate Increases. Projected ---------------- FISCAL YEAR ENDING SEPTEMBER 30 -------------- Annual 1995 1996 1997 1998 1999 Change OPERATING REVENUES BASE RATES 5,737.000 5,817,000 5,898,000 5,981,000 6,064.000 1.40% WATER TAPS 130,000 130,000 130,000 130.000 130,000 0.00% OTHER 50,000 51,000 52,000 53,000 54,000 1.94% TOTAL 5,917,000 5,998,000 6,080.000 6,164,000 6,248,000 1.37% OPERATING EXPENSES PRODUCTION 1,489,529 1,600,000 1,642,000 1,686,000 1,729,000 3.80% DISTRIBUTION 1,117,147 1,216,000 1,276,000 1,335,000 1,395,000 5.71% ADMINISTRATION 812,000 840,000 869,000 898,000 926,000 3.34% DEPRECIATION 806,000 838,000 869,000 901,000 933,000. 3.73% TOTAL 4,224,676 4,494,000 4,656,000 4,820,000 4,983,000 4.21% RETURN 1,692,324 1,504,000 1,424,000 1.344,000 1,265,000 —7.02% INTEREST LT DEBT 568,000 509,989 475,251 490,789 487,628 —3.74% OPERATING MARGIN 1,124,324 994,011 948,749 853,211 777,372 —8.81% NON OPERATING INCOME 3,800 4,000 4,200 4,400 4,600 4.89% NET MARGIN 1,128,124 998,011 952,949 857,611 781,972 —8.76% CASH BEFORE TRANSFERS 2,502,124 2,346,000 2,297,200 2,249,400 2,202,600 —3.14% LESS: DEBT SERVICE (1.822.208) (1.812,815) (1.750,895) (1,665.644) (1.496,708) 4.80% LESS: CAPITAL OUTLAY (35,000) (40,000) (45,000) (50,000) (55,000) —11.96% LESS: TRANS GEN FUND 10% (573,700) (581,700) (589,800) (598,100) (606,400) —1.40% PLUS: FROM BOND FUNDS 0 0 0 0 0 CASH AFTER TRANSFERS -/1,216 (88,515) (138.,495) (84,344) 44,492 .11.10% FINANCIAL RATIOS: OPERATING TIER 2.98 2.95 3.00 2.74 2.59 NETTIER 2.99 2.96 3.01 2.75 2.60 DSC 1.37 1.29 1.31 1.35 1.47 RATE OF RETURN (%) 5.86 5.06 4.65 4.26 3.89 RATE BASE 28,860,064 29,725,866 30,617,642 31,536,171 32,482,256 3.00% BASE—I.WK3 McCord Engineering, Inc. REVISED 07/11/94 OPERATING REVENUES BASE RATES SEWER TAPS OTHER TOTAL OPERATING EXPENSES TREATMENT COLLECTION ADMINISTRATION DEPRECIATION TOTAL RETURN INTEREST LT DEBT OPERATING MARGIN NON OPERATING INCOME NETMARGIN CASH BEFORE TRANSFERS LESS: DEBT SERVICE LESS: CAPITAL OUTLAY LESS: TRAN S G EN FUN D 10% PLUS: FROM BOND FUNDS CASH AFTER TRANSFERS FINANCIAL RATIOS: OPERATING TIER NETTIER DSC RATE OF RETURN (%) RATE BASE ($) EXHIBIT III-1.D CITY OF COLLEGE STATION WASTEWATER DIVISION INCOME STATEMENT PROJECTION Base Case — No Rate Increases ---------------- FISCAL YEAR ENDING SEPTEMBER 30,- 1995 1996 1997 1998 Projected — — — — — — — — Annual 1999 Change 5,049,000 5,090,000 5,132,000 5,175,000 5,217.000 0.82% 87,500 87,500 87,500 87,500 87,500 0.00% 50,000 51,000 52,000 53,000 54,000. 1.94% 5,186,500 5,228,500 5,271,500 5,315,500 5,358,500 0.82% 1,487,154 1,529,000 1,620,000 1,712,000 1,804,000 4.95% 789,152 804,000 887,000 969,000 1,052,000 7.45% 632,000 672,000 712,000 751,000 791,000 5.77% 652,000 685,000 718,000 751,000 783,000. 4.68% 3,560,306 3,690,000 3,937,000 4,183,000 4,430,000 5.62% 1,626,194 1,538,500 1,334,500 1,132,500 928,500 —13.07% 668,592 1.099.589 1.122,004 1,224,101 1,210.345 15.99% 957,602 438,911 212,496 (91,601) (281,845) 65,000 66,000 67,000 68,000 69,000. 1.50% 1,022,602 504,911 279,496 (23,601) (212,845) 2,343,194 2,289,500 2,119,500 1,951,500 1,780,500 —6.64% (1,722.108) (2,722,905) (2,841.827) (2.864.899) (2,782.214) 12.74% (45,000) (50,000) (55,000) (60,000) (65,000) 9.63% (504,900) (509,000) (513,200) (517,500) (521,700) 3.00% 0 0 0 0 0 71,186 (992,405) (1,290.,527) (1,490,899) (1,588,414) 117.34% 2.43 1.40 1.19 0.93 0.77 2.53 1.46 1.25 0.98 0.82 1.36 0.84 0.75 0.68 0.64 6.62 5.97 4.93 3.98 3.11 24,563,818 25.792,008 27,081,609 28.435,689 29,857,474 5.00% BASE—I.WK3 Exhibit III-l.E l:ISTORY & PROJECTIONS - NET MARGIN 0 History Projections 8 6 ME, Elf < 0 -2 -4 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 YEAR UTILITIES ELECTRIC WATER WASTEWATER ----------- - --- - ------ Exhibit III-I.F HISTORY & PROJECTIONS CASH AFTER TRANSFERS 8 History 1 Projections 4 < 2 0 -2 00 m 1982 1984 1986 1988 1990 1992 1994 1996 1998 1983 1985 1987 1989 1991 1993 1995 1997 1999 YEAR - UTILITIES -- ELECTRIC - WATER - WASTEWAT19 Exhibit III-I.G HISTORY & PROJECTIONS - RATES OF RETURN 30.0 Projections Histo ry Lu 20.0 z LLJ 10.0 ui 0- 1982 1983 1984 1985 1986 1987 1988 1989 1990 19911992 1993 1994 1995 1996 1997 1998 1999 YEAR MW Ct UJ 4. 0 (D z ui 2.0 0- 0 m A—Talmmum H isto ry Projections 1982 1984 1986 1988 1990 1992 1994 1996 1998 1983 1985 1987 1989 1991 1993 1995 1997 1999 YEAR UTILITY DEPARTMENT OPTION - 2 PLANNING HORIZON PROJECTIONS With Proposed Rate Increases for Fiscal Years 1994-1995 through 1998-1999 Fiscal Year Projected Increase 1994-1995 10 % Wastewater 1995-1996 5 % Electric 5 % Water 10% Wastewater 1996-1997 6 % Wastewater 1997-1998 2 % Electric 5 % Wastewater 1998-1999 No Increases McCord Engineering, Inc. REVISED 07/08/94 EXHIBIT 111-2.A CITY OF COLLEGE STATION UTILITY DEPARTMENT INCOME STATEMENT PROJECTION With Proposed Rate Increases For Fiscal Years 1994-1995 Throuqh 1998-1999 Projected ----------------- FISCAL YEAR ENDING SEPTEMBER 30 ------------- Annual 1995 1996 1997 1998 1999 Change 5% ELECTRIC 5% WATER 2% ELECTRIC OPERATING REVENUES 10% WASTEWATEI 10% WASTEWAI 6% WASTEWAI 5% WASTEWATI NO WASTEWATER UTILITY FUND E,W&S 45,274,433 50,637.285 53,750,375 57,502,622 60,180,764 WATER & SEWER TAPS 217,500 217,500 217,500 217,500 217,500 7.37% OTHER 550,000 562,000 574.000 586,000 598,000 2.11% TOTAL 46,041,933 51,416,785 54,541,875 58,306,122 60,996,264 7.28% OPERATING EXPENSES ELECTRIC PURCHASED POWER 24,158,950 26,294,005 28,239,768 30,077,756 31,988,555 7.27% TRANSMISSION 1,554,949 1,669,000 1,780,000 1,895,000 2,009,000 6.61% DISTRIBUTION 2,014,104 2,103.000 2,191,000 2,280,000 2,369,000 4.14% WATER PRODUCTION 1,489,529 1,600,000 1,642,000 1,686,000 1,729,000 3.80% DISTRIBUTION 1,117,147 1,216,000 1,276,000 1,335,000 1,395,000 5.71% SEWER TREATMENT 1,637,154 1.529,000 1,520.000 1,612,000 1,704,000 1.01% COLLECTION 839,152 904,000 987,000 1,069,000 1,152,000 8.24% ADMIN. E,W&S 2,945,399 3,823,553 3,881,524 4,145,297 4,379,347 10.42% DEPR. E,W&S 2,307,000 2,404,000 2,500,000 2,598,000 2,694,000 3.95% TOTAL 38,063,384 41,542,558 44,017,292 46,698,053 49,419,902 6.75% RETURN 7,978,549 9,874,227 10,524,583 11,608,069 11.576,362 9.75% INTEREST ON LT DEBT 1,866.209 2.631,916 2.937.149 3.294.432 3.484.714 16.90% OPERATING MARGIN 6,112,340 7,242,310 7,587,434 8,313,637 8,091,648 7.26% NON OPERATING REVENUE 868,800 886,000 903,200 921,400 939,600, 1.98% NET MARGIN 6,981,140 8,128,310 8,490,634 9,235,037 9,031,248 6.65% CASH BEFORE TRANSFERS 11,154,349 13,164,227 13,927,783 15,127,469 15,209,962 8.06% LESS: DEBT SERVICE (5.002.260) (6,643.546) (7,210 �jO A (7.556.388) (7.331,273) —10.03% LESS: CAPITAL OUTLAY (257,000� (293,000) (384,000) (250,000) (550,000) 20.95% LESS: TRANS GEN FUND (4,744,615) (5,303,876) (5,629,265) (6,021,920) (6,303,449) 7.36% LESS: ECONOMIC DEVELOP (200,000) (205,000) (210,000) (215,000) (220,000) 2.41% LESS: TRANS RESERVES 0 0 0 0 0 CASH AFTER TRANSFERS 950.473 718,805 494,016 1,084,161 805,240 —4.06% FINANCIAL RATIOS: OPERATING TIER 4.28 3.75 3.58 3.52 3.32- NETTIER 4.74 4.09 3.89 3.80 3.59 DSC 2.23 1.98 1.93 2.00 2.07 HOR ON RATE BASE 10.34 12.27 12.55 13.27 12.69 RATE BASE ($)* 77,182,452 80,464,373 83,893,075 87,475,376 91,218,421 4.27% BASEI.WK3 Rate Base and Rate of Return figures are based on Adjusted FERC Accounts, From FERC Accounting Setup Survey. McCord Engineering, Inc. REVISED 07/08/94 EXHIBIT 111-2.13 CITY OF COLLEGE STATION ELECTRIC DIVISION INCOME STATEMENT PROJECTION With Proposed Rate Increases For Fiscal Years 1094-1995 Throuqh 1998-1999 Projected ----------------- FISCAL YEAR ENDING SEPTEMBER 30 ------------- Annual 1995 1996 1997 1998 1999 Change 5% 2% OPERATING REVENUES INCREASE INCREASE ELECTRIC REVENUE 33,984,433 38,369,435 40,975,475 44,251,572 46,784,564 8.32% OTHER 450,000 460,000 470,000 480,000 490,000. 2.15% TOTAL 34,434,433 38,829,435 41,445,475 44,731,572 47,274,564 8.25% OPERATING EXPENSES PURCHASED POWER 24,158,950 26,294,005 28,239,768 30,077,756 31,988,555 7.27% TRANSMISSION 1,554,949 1,669,000 1,780,000 1,895,000 2,009,000 6.61% DISTRIBUTION 2,014,104 2,103,000 2,191,000 2,280,000 2,369,000 4.14% ADMINISTRATION 1.501,399 2,311,553 2.300,524 2,496,297 2,662,347 15.40% DEPRECIATION 849,000 881,000 913,000 946,000 978,000 3.60% TOTAL 30,078,402 33.258,558 35.424,292 37,695,053 40,006,902 7.39% RETURN 4,356,031 5,570,877 6,021,183 7,036,519 7,267,662 13.65% INTEREST LT DEBT 629,617 1,022,338 1.339,894 1,579,542 1.786.741 29.79% OPERATING MARGIN 3,726,414 4,548,538 4,681,289 5,456,977 5.480.921 10.13% NON OPERATING INCOME 800,000 816,000 832,000 849,000 866,000. 2.00% NET MARGIN 4,526,414 5,364,538 5,513,289 6,305.977 6,346,921 8.82% CASH BEFORE TRANSFERS 6,005,031 7,267,877 7,766.183 8,831,519 9,111,662 10.99% LESS: DEBT SERVICE (1.457,944) (2.107.826) (2.617.780) (3,025.845) (3.052.351) 20.29% LESS: CAPITAL OUTLAY (177,000) (203,000) (284,000) (140,000) (430,000) 24.85% LESS: TRANS GEN FUND 10.5% (3,615,615) 14.077�091) (4.351.775) (4.696,815) 14.963.829) 8.25% LESS: ECONOMIC DEVELOP (200,000) (205,000) (210,000) (215,000) (220,000) 2.41% LESS: TRANS RESERVES 0 0 0 0 0. CASH AFTER TRANSFERS 554,471 674,960 302,628 753,859 445,482 FINANCIAL RATIOS: OPERATINGTIER 6.92 5.45 4.49 4.45 4.07 NETTIER 8.19 6.25 5.11 4.99 4.55 DSC 4.12 3.45 2.97 2.92 2.99 RATE OF RETURN (%)- 18.33 22.33 22.99 25.58 25.17 RATE BASE 23,758,571 24,946,499 26,193,824 27,503,515 28,878,691 5.00% BASEI.WK3 Rate Base and Rate of Return figures are based on Adjusted FERC Accounts, From FERC Accounting Setup Survey. McCord Engineering, Inc. REVISED 07/08/94 EXHIBIT 111-2.0 CITY OF COLLEGE STATION WATER DIVISION INCOME STATEMENT PROJECTION With Proposed Rate Increases For Fiscal Years 1994-1995 Throuqh 1998-1999 Projected ----------------- FISCAL YEAR ENDING SEPTEMBER 30 ------------- Annual 1995 1996 1997 1998 1999 Change 5% OPERATING REVENUES INCREASE BASE RATES 5,737,000 6,107,850 6,192,900 6,280,050 6,367,200 2.64% WATER TAPS 130,000 130,000 130,000 130,000 130,000 0.00% OTHER 50,000 51,000 52,000 53,000 54,000 1.94% TOTAL 5,917,000 6,28B,850 6,374,900 6,463,050 6,551,200 2.58% OPERATING EXPENSES PRODUCTION 1,489,529 1,600,000 1,642,000 1,686,000 1 p729,000 3.80% DISTRIBUTION 1,117,147 1,216,000 1,276,000 1,335,000 1,395,000 5.71% ADMINISTRATION 812,000 840,000 869,000 898,000 926,000 3.34% DEPRECIATION 806,000 838,000 869.000 901,000 933,000 3.73% TOTAL 4,224.676 4,494,000 4,656,000 4,820,000 4,983,000 4.21% RETURN 1,692,324 1,794,850 1,718,900 1,643,050 1.568,200 —1.89% INTEREST LT DEBT 568,000 509,989 475,251 490,789 487,628 —3.74% OPERATING MARGIN 1,124,324 1,284.861 1,243,649 1,152,261 1,080,572 —0.99% NON OPERATING INCOME 3,800 4,000 4,200 4,400 4.600 4.89% NET MARGIN 1,128,124 1,288,861 1,247.849 1,156,661 1.085,172 —0.97% CASH BEFORE TRANSFERS 2,502,124 2,636,850 2,592,100 2,548,450 2,505,800 0.04% LESS: DEBT SERVICE (1,822,208) (1,812,815) (1,750,895) (1.665,644) (1,496,708) 4.80% LESS: CAPITAL OUTLAY (35,000) (40,000) (45,000) (50,000) (55,000) —11.96% LESS: TRANS GEN FUND 10% (573,700) (610,785) (619,290) (628,005) (636,720) —2.64% PLUS: FROM BOND FUNDS 0 0 0 0 0 CASH AFTER TRANSFERS 71,216 173,250 176,915 204,801 317,372 —45.29% FINANCIAL RATIOS: OPERATING TIER 2.98 3.52 3.62 3.35 3.22 NETTIER 2.99 3.53 3.63 3.36 3.23 DSC 1.37 1.45 1.48 1.53 1.67 RATE OF RETURN (%) 5.86 6.04 5.61 5.21 4.83 RATE BASE 28,860,064 29,725,866 30,617,642 31,536,171 32,482,256 3,00% BASE1.WK3 McCord Engineering, Inc. REVISED 07/08/94 EXHIBIT 111-2.D CITY OF COLLEGE STATION WASTEWATER DIVISION INCOME STATEMENT PROJECTION With Proposed Rate Increases For Fiscal Years 1994-1995 Throuqh 1998-1999 Projected ----------------- FISCAL YEAR ENDING SEPTEMBER 30 ------------- Annual 1995 1996 1997 1998 1999 Change 10% 10% 6% 5% NO OPERATING REVENUES INCREASE INCREASE INCREASE INCREASE INCREASE BASE RATES 5,553,000 6,160,000 6,582,000 6,971,000 7,029,000 6.07% SEWER TAPS 87,500 87,500 87,500 87,500 $7,500 0.00% OTHER 50,000 51.000 52,000 53,000 54,000 1.94% TOTAL 5,690,500 6.298,500 6,721,500 7,111,500 7,170,500 5.95% OPERATING EXPENSES TREATMENT 1,637,154 1,529,000 1,520,000 1,612,000 1,704,000 1.01% COLLECTION 839,152 904,000 987,000 1,069,000 1,152,000 8.24% ADMINISTRATION 632,000 672,000 712,000 751,000 791,000 5.77% DEPRECIATION 652,000 685,000 718,000 751,000 783,000 4,68% TOTAL 3,760,306 3,790,000 3,937,000 4,183,000 4,430,000 4.18% RETURN 1,930,194 2,508,500 2,784,500 2,928,500 2,740,500 9.16% INTEREST LT DEBT 668,59 1,099.589 1,122.004 1,224,101 1.210.345 15,99% OPERATING MARGIN 1,261,602 1,408,911 1,662,496 1,704,399 1,530.155 NON OPERATING INCOME 65,000 66,000 67,000 68,000 69,000 1.50% NET MARGIN 1,326,602 1,474,911 1,729,496 1,772,399 1,599,155 CASH BEFORE TRANSFERS 2,647,194 3,259,500 3,569,500 3,747,500 3,592,500 7.93% LESS: DEBT SERVICE (1.722.108) (2,722.905) (2.841.827) (2,864,899) (2.782.214) 12,74% LESS: CAPITAL OUTLAY (45,000) (50,000) (55,000) (60,000) (65,000) 9.63% LESS: TRANS GEN FUND 10% (555,300) (616,000) (658,200) (697,100) (702,900) 3.00% PLUS: FROM BOND FUNDS 0 0 0 0 0 CASH AFTER TRANSFERS 324,786 (129,405) 14,473 125,501 42,386 —39.90% FINANCIAL RATIOS: OPERATING TIER 2.89 2.26 2.48 2.39 2.26 NET TIER 2.98 2.34 2.54 2.45 2.32 DSC 1.54 1.20 1.26 1.31 1.29 RATE OF RETURN (%) 7.86 9.73 10.28 10.30 9.18 RATE BASE 24,563,818 25,792,008 27,081,609 28,435,689 29,857,474 5.00% BASE1.WK3 Exhibit 111-2.E F ilt" 4)' T ur' R & rnr7x'%f-- J"'J E C T 10 N S - N E T M A R G I N lim I 6 K 0 Ooo -2 History Projections 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 YEAR UTILITY WATER ELECTRIC WASTEWATER M, I Exhibit 111-2.F 'HISTORY & PROJECTIONS - CASH AFTER TRANSFER%.z4 F9 History -3 I Projections i 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 YEAR UTILITY - WATER ELECTRIC WASTEWATER Exhibit 111-2.G HISTORY & PROJECTIONS - RATES OF RETURN W, History 25 20 15 --N nlo 10 *11 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 YEAR 6 1� 'History Projections LU 0- 2 0 x 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 YEAR EXHIBIT IV RECOMMENDED RATE CHANGES FOR FISCAL YEARS 1994-1995 THROUGH 1998-1999 EXHIBIT IV-1 Recommended Rate Design Changes for Fiscal Year 1994-1995 No electric rate increase. No water rate increase. A 10% rate increase for the Wastewater Division. Utility rates have been designed to achieve and maintain a Rate of Return on Rate Base of at least 12%. EXHIBIT IV-2 Forecasted Utility Rate Increases Fiscal Year Projected Increase 1995-1996 5 % Electric 5 % Water 10% Wastewater 1996-1997 6 % Wastewater 1997-1998 2 % Electric 5 % Wastewater 1998-1999 No Increases EXHIBIT IV-3 Future Rate Design Issues Future power supply costs will play an important role in the determination of any future electric rate increase requirements. Regulatory requirements for additions at Carter Creek Wastewater Treatment Plant will necessitate wastewater rate increases over approximately the next four years. Water rate increases will be minimal over the next five year period due to only slight changes in capital improvement requirements. APPENDIX A A. -3 144 19 CITY OF COLLEGE STATION FINANCIAL RATIO FORMULA SUMMARY Operating TIER (Operating Times Interest Earned Ratio) = Ooeratinci Marain +Interest Exoense Interest Expense 0r)eratIna Times Interest Earned Ratio (0r)eratina TIER) measures the Utility's ability to meet it's interest expense, prior to the inclusion of non -operating revenue contribution to margins. Typical TIER values considered acceptable for municipalities generally fall in the range of 2.0 to 3.5. Net TIER (Net Times Interest Earned Ratio) Net Marain + Interest Exoense Interest Expense Net Time Interest Earned Ratio (Net TIER) measures the Utility's ability to meet its interest expense, after the inclusion of non -operating revenue contribution to margins. Typical TIER values considered acceptable for municipal utilities generally are found to be in the range of 2.0 to 3.5. DSC (Debt Service Coverage)= Net Marain + Interest Exnense + Depreciation Exoense Debt Service Payments Debt Service Coveraae (DSCI Ratio quantitates the Utility's ability to provide revenues to meet its debt service payment requirements. Values in the range of 1.75 to 2.50 are generally considered satisfactory for municipal utility systems. Your City's current bond covenants require the maintenance of minimum DSC levels in the range of 1.25 to 1.40. ROR (Rate of Return) on Rate Base Return X 100% Rate Base Where Return = Total Operating Revenues - Total, Operating Expenses Rate Base (invested Capital) Original Cost of Plant, - Accumulated + Working Property, & Equipment Depreciation Capital Allowance Rate of Return (ROR) on Rate Base reflects the earnings level of the Utility, prior to the payment of its capital costs and non -operating transfers to other Departments, expressed as a % of the total invested capital used and useful in rendering service to the public (Rate Base). Rate of return on rate base is primarily a financial' Indicator that has developed in the regulatory rate environment, and is not common- ly used in the development of revenue requirements for rate design for municipalities. Rate of return levels for municipal utility systems vary widely, depending on the amount of debt requirements and the level of transfers made to other City funds. E. ROR (Rate of Return) on Equity Net Marain X 100% Equity Where Equity Assets - Liabilities (Taken directly from Annual Financial Audit) Rate of Return (ROR) on Eauitv measures the net earnings level of the Utility, after payment of all expenses but prior to non -operating transfers to other Departments, expressed as a % of the equity portion of total invested capital. Return on equity values are not commonly employed in rate design for municipal electric systems, and values vary widely, depending on the level of transfers to other Departments and the level and source of funding of capital additions made to the utility system. Appendix A (Cont'd) F. Debt -to -Equity Ratio Total Liabilities Equity Where Equity Assets - Liabilities (Taken directly from Annual Financial Audit) Debt-to-Eaultv Ratio is a measure of the balance between the Utility's debt and equity. A ratio of 1.25 means that debt provides $1.25 worth of capital to every $1.00 of capital provided by equity.