Loading...
HomeMy WebLinkAbout1991- 1st Quaterly Financial ReportQUARTERLY FINANCIAL REPORT THREE MONTHS ENDING DECEMBER, 1991 C L Post Oftkze Box 9960 College Staticl, Texa (409) 764 - si 1 1101 Texas Avenue /842-096'0 MEMORANDUM TO: FROM: DATE: SUBJECT: Ron Ragland, City Manager Glenn Schroeder, Executive Director of Fiscal and Human March 25, 1992 Interim Financial Reports I have attached monthly interim financial reports for the first quarter of fiscal year 1991-92. These schedules were prepared on a cash basis and the entries to post items such as depreciation and expense accruals have not been made. Schedules of investments to maturity for each month have also been attached. During the first quarter of this fiscal year there were no unexpected occurrences in the financial position of the City. Total general fund revenues are just slightly ahead of budget projections. Municipal court revenues are somewhat higher than expected while all other revenue categories are performing very much as expected. Expenditures for all departments were within the budgeted. amounts. One time purchases in the management services department caused expenditures there to be a little more than the prorated budget but that will be corrected as we move through the fiscal year. Revenues in the hotel/motel fund are higher than projected. Both Conference Center rentals and occupancy tax receipts are performing well. Expenditures are within budget projections. Through the first quarter, the enterprise funds - electric, water, sewer, and solid waste - have revenues slightly below projections except for sewer revenues which are up. Because expenses in these funds are directly related to revenues, expenses were also lower than projected. If there are any questions, please call me. cc: Mayor and City Council Executive Staff MONTHLY FINANCIAL REPORT DECEMBER, 1991 GENERAL FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 DECEMBER, 1991 (25% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (3 MONTHS) (3 MONTHS) (DECREASE) BUDGET BUDGET REVENUES: Sales Tax (1) $1,229,500 $1,763,576 43.44 % 6,572,800 26.83 % Property Tax (2) 651,700 640,758 (1.68) 1,394,720 45.94 Court Revenues 119,000 161,942 36.09 561,000 28.87 Parks & Recreation 26,300 29,074 10.55 386,400 7.52 Trf. In -lieu -of taxes 943,000 972,468 3.12 3,889,900 25.00 Transfer - Admin. 445,000 612,813 37.71 2,640,423 23.21 Investment Earnings 5,388 5,841 8.41 308,500 1.89 Miscellaneous 174,412 167,120 (4.18) 1,006,400 16.61 TOTAL REVENUES 3,594,300 4,353,592 21.12 16,760,143 25.98 EXPENDITURES: Police 865,600 923,385 6.68 % 4,102,717 22.51 Fire 541,400 621,915 14.87 3,144,397 19.78 Public Services 291,900 376,164 28.87 2,326,201 16.17 Culture & Recreation 490,700 526,212 7.24 2,597,035 20.26 Development Services 279,700 314,912 12.59 1,360,346 23.15 Administration 172,127 197,979 15.02 799,921 24.75 Fiscal & Human Res. 294,300 340,943 15.85 1,506,503 22.63 Management Services 401,631 414,470 3.20 1,532,092 27.05 Non -Dept. and Contingency 41,941 76,359 82.06 312,032 24.47 TOTAL EXPENDITURES 3,379,299 3,792,339 12.22 17,681,244 Unexpended Appropriations ($790,340) REVENUES IN EXCESS OF EXPENDITURES (DEFICIT) $215,001 $561,253 ($130,761) (1) Local sales tax increased from 1% to 1-1/2%, effective with December 1990 payments. (2) General fund property tax declined from 13.25c per $100 in 1991 to 12.25c per $100 in 1992. (3) Includes non -departmental and contingency funds. 21.45 REVENUES: Tax Receipts Center Rentals Miscellaneous TOTAL REVENUES EXPENDITURES: Center Operations Debt Service Chamber of Commerce Arts Council B/CS Athlethic Fed. Parks & Recreation Conf. Ctr.- Capital Contingency Trf: Wolfpen Creek TOTAL EXPENDITURES HOTEL/MOTEL TAX FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 DECEMBER, 1991 (25% OF FISCAL YEAR) ACTUAL ACTUAL 1991 1992 (3 MONTHS) (3 MONTHS) $252,700 $303,209 12,100 17,990 1,200 1,125 266,000 322,324 44,700 19,000 108,300 51,600 18,000 9,700 0 0 0 PERCENTAGE INCREASE (DECREASE) 1992 ANNUAL BUDGET 19.99 % $927,000 48.68 50,500 (6.25) 26,800 21.17 1,004,300 64,935 45.27 14,736 (22.44) 89,375 (17.47) 44,516 (13.73) 14,500 (19.44) 31,507 224.81 0 0.00 0 0.00 150,000 100.00 259,748 58,947 357,500 110,000 14,500 92,450 45,978 30,000 226,500 251,300 409,569 62.98 1,195,623 REVENUES IN EXCESS OF EXPENDITURES (DEFICIT) $14,700 ($87,245) ($191,323) PERCENT OF ANNUAL BUDGET 32.71 % 35.62 4.20 32.09 25.00 25.00 25.00 40.47 100.00 34.08 0.00 0.00 66.23 34.26 DEBT SERVICE FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 DECEMBER, 1991 (25% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (3 MONTHS) (3 MONTHS) (DECREASE) BUDGET BUDGET REVENUES: Property Tax (1) $1,685,600 $1,892,557 12.28 % $3,129,550 60.47 % Transfer from other funds 161,700 150,924 (6.66) 58,945 256.04 Investment Earnings 4,500 0 (100.00) 135,000 0.00 TOTAL REVENUES 1,851,800 2,043,481 10.35 3,323,495 61.49 EXPENDITURES: General Obligation Bonds: Principal 200,000 200,000 0.00 2,100,220 9.52 Interest 116,200 107,688 (7.33) 1,486,275 7.25 Certificate of Obligation: Principal 0 0 0.00 203,018 0.00 Interest 0 16,875 0.00 68,677 24.57 Miscellaneous TOTAL EXPENDITURES REVENUES IN EXCESS OF EXPENDITURES(DEFICIT) 1,955 2,837 45.12 15,000 18.91 318,155 327,400 2.91 3,873,190 8.45 $1,533,645 $1,716,081 ($549,695) (1) Debt service property tax increased from 26.75c per $100 valuation in 1991 to 27.75c per $100 In 1992, offset by decrease In General Fund Property Tax. SOLID WASTE COLLECTION FUNDS REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 DECEMBER, 1991 (25% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (3 MONTHS) (3 MONTHS) (DECREASE) BUDGET BUDGET REVENUES: Collection Charges $464,155 $475,658 2.48 % $1,855,537 25.63 % Penalties $4,889 5,527 13.05 20,000 27.64 Recycling 469 883 88.27 4,000 22.08 Interest Earnings 39,040 36,366 (6.85) 38,000 95.70 Reimbursed Administrative 0 12,360 0.00 49,444 25.00 Miscellaneous 7,696 2,333 (69.69) 181,426 1.29 TOTAL REVENUES 516,249 533,127 3.27 2,148,407 24.81 EXPENSES: Collection 463,500 322,693 (30.38) 1,700,337 18.98 Reimbursed Administrative 0 99,066 100.00 300,122 33.01 Transfer in Lieu of Taxes 98,700 37,275 (62.23) 156,270 23.85 Contribution to Brazos Beautiful 9,000 0 (100.00) 10,000 0.00 Capital Outlay 7,897 1,187 (84.97) 4,291 27.66 Debt Service 0 20,379 100.00 81,517 Miscellaneous 0 0 0.00 214,743 0.00 TOTAL EXPENSES 579,097 480,600 (17.01) 2,467,280 19.48 Unexpended Appropriations (69,500) NET INCOME (CASH BASIS) ($62,848) $52,527 ($249,373) NOTE: BVSWMA started operations in May, 1990. City of College Station pays $15/ton tipping fee at landfill. 2,000,000 - 1,800,000 - 1,600,000 - 1,400,000 - 1,200,000 - 1,000,000 - 800,000 - 600,000 - 400,000 - 200,000 - 0 SOLID WASTE COLLECTION REVENUE VS BUDGET I I I I I I I I I OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ❑ BUDGET ® ACTUAL BUDGET/ 12 LANDFILL FUND REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 DECEMBER, 1991 (257% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (3 MONTHS) (3 MONTHS) (DECREASE) BUDGET BUDGET REVENUES: Landfill Operator Fees $72,703 $177,559 144.23 $710,237 Interest Earnings ($420) 0 (100.00) 0 TOTAL REVENUES 72,283 177,559 145.64 710,237 25.00 % 0.00 25.00 EXPENSES: Landfill Operator 106,154 118,017 11.18 496,669 23.76 Reimbursed Administrative 0 46,341 100.00 185,378 25.00 Capital Outlay 1,122 2,078 85.20 31,690 6.56 Contingency 0 0 0.00 20,000 0.00 TOTAL EXPENSES 107,276 166,436 55.15 733,737 22.68 Unexpended Appropriations (23,500) NET INCOME (CASH BASIS) ($34,993) $11,123 $0 NOTE: BVSWMA started operations in May, 1990. City of College Station serves as landfill operator and is reimbursed for expenses. ELECTRIC FUND REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 DECEMBER, 1991 (25% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (3 MONTHS) (3 MONTHS) (DECREASE) BUDGET BUDGET REVENUES: Sale of Electricity (1) $6,431,900 $6,509,303 1.20 % $30,021,964 21.68 % Investment Earnings 20,000 0 (100.00) 625,000 0.00 Miscellaneous 108,500 104,438 (3.74) 448,700 23.28 TOTAL REVENUES 6,560,400 6,613,741 0.81 31,095,664 21.27 EXPENSES: Wholesale Power (2) 3,075,300 3,064,034 (0.37) 19,767,143 15.50 Electric Operations 38,600 50,931 31.95 291,696 17.46 Transmission & Distribution 377,900 464,345 22.88 2,597,507 17.88 Reimbursed Admin. & Transfer In -lieu of Taxes (1) 829,600 796,938 (3.94) 3,187,766 25.00 Development Foundation 0 110,000 0.00 110,000 100.00 Debt Service (Budget Proration) 238,000 262,974 10.49 1,241,143 21.19 Utility Billing 166,000 189,444 14.12 713,346 26.56 Capital Outlay 65,800 41,673 (36.67) 116,551 35.76 TOTAL EXPENSES 4,791,200 4,980,339 3.95 28,025,152 17.77 NET INCOME (CASH BASIS) $1,769,200 $1,633,402 $3,070,512 (1) Two months electric rates. (2) One months wholesale power purchases. 35, 000, 000 - 30, 000, 000 - 25,000,000 - 20, 000, 000 - 15, 000, 000 - 10,000,000 - 5,000,000 - ELECTRIC REVENUE BUDGET VS ACTUAL I »I I I I I I I I I I OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ❑ BUDGET ® ACTUAL _ BUDGET/ 12 WATER FUND REVENUE/EXPENDSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 DECEMBER, 1991 (25% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (3 MONTHS) (3 MONTHS) (DECREASE) BUDGET BUDGET REVENUES: Water Sales (1) $1,234,700 $1,193,225 (3.36) % $5,249,200 Investment Earnings 0 0 0.00 0 Miscellaneous 22,215 20,549 (7.50) 88,300 TOTAL REVENUES 1,256,915 1,213,774 (3.43) 5,337,500 EXPENSES: Water Production & Distribution 489,100 540,451 10.50 2,573,393 Reimbursed Admin.& Transfer In -lieu of Taxes 200,300 216,438 8.06 1,053,032 Debt Service (Budget Proration) 445,000 479,993 7.86 2,081,835 Utility Billing 80,300 64,197 (20.05) 272,236 Capital Outlay 8,100 21,132 160.89 24,250 TOTAL EXPENSES 1,222,800 1,322,211 8.13 6,004,746 NET INCOME (CASH BASIS) $34,115 ($108,437) ($667,246) 22.73 % 23.27 22.74 21.00 20.55 23.06 23.58 87.14 (1) Water rates increased by 10% in 1991, the fourth year of 5-year scheduled increases to cost of service. 22.02 6,000,000 - 5,000,000 - 4,000,000 - 3,000,000 - 2,000,000 - 1,000,000 - 0 WATER REVENUE VS ACTUAL I I I I I I OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP I ❑ BUDGET ® ACTUAL - BUDGET/ 12 SEWER FUND REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 DECEMBER, 1991 (25% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (3 MONTHS) (3 MONTHS) (DECREASE) BUDGET BUDGET REVENUES: Sewer Service Revenue (1) $958,400 $1,066,374 11.27 % $4,370,800 24.40 % Investment Earnings 2,500 0 (100.00) 60,000 0.00 Miscellaneous 17,000 20,163 18.61 70,100 28.76 TOTAL REVENUES 977,900 1,086,537 11.11 4,500,900 24.14 EXPENSES: Sewer Collection & Treatment 285,700 319,370 11.79 1,906,097 16.76 Reimbursed Admin. & Trf. in -lieu of Taxes 149,000 163,527 9.75 799,586 20.45 Debt Service (Budget Proration) 337,400 381,864 13.18 1,650,391 23.14 Utility Billing 13,400 32,610 143.36 143,574 22.71 Capital Outlay 25,000 13,881 (44.48) 72,700 19.09 TOTAL EXPENSES 810,500 911,252 12.43 4,572,348 19.93 NET INCOME (CASH BASIS) $167,400 $175,285 ($71,448) (1) No changes to rate structure in 1991. 4,500,000 - 4,000,000 - 3,500,000 - 3,000,000 - 2,500,000 - 2,000,000 - 1,500,000 - 1,000,000 - 500,000 - SEWER REVENUE VS BUDGET 0 * I \I '1 I 1 I I I I 1 I I OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ❑ BUDGET ® ACTUAL - BUDGET/ 12 REVENUES: Landfill Charges Miscellaneous Interest TOTAL REVENUES EXPENSES: Operating Expenses: Landfill Operator Consultants/Professional Svcs Equipment Rental State Disposal Fees Maintenance Insurance Reimbursed Administrative Project Rose Contingency Miscellaneous Total Operating Expenses Machinery and Equipment Debt Service - Notes Reserves (Budget Proration) Total Other Expenses TOTAL EXPENSES NET INCOME (CASH BASIS) REVENUES: Debt Issue (2) City of Bryan (2) Total Ruvunuoe EXPENSES: Capital Outlay: Land Improvements Machinery and Equipment Total Expenses BRAZOS VALLEY SOLID WASTE MANAGEMENT AGENCY REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 DECEMBER, 1991 (25% OF FISCAL YEAR) OPERATING BUDGET ACTUAL 1991 (3 MONTHS) $430,900 42,900 1,593 475,393 ACTUAL PERCENTAGE 1992 INCREASE (3 MONTHS) (DECREASE) $440,152 14,458 (5,989) 448,621 2.15 % (66.30) (5.63) 1992 ANNUAL BUDGET $1,875,000 30,000 81,300 1,986,300 $107,276 177,559 65.52 710,237 0 1,360 0.00 75,000 0 0 0.00 17,000 0 27,316 0.00 62,500 O 42,207 0.00 30,000 10,502 0 (100.00) 17,000 O 15,964 0.00 40,000 0 50,000 0.00 50,000 O 0 0.00 25,000 9,560 2,210 (76.88) 90,000 127,338 316,616 148.64 1,116,737 42,963 112,501 161.86 35,500 50,760 114,114 124.81 389,023 125,000 125,000 0.00 500,000 0 0 #DIV/01 924,523 $346,061 $668,231 93.10 $2,041,260 $129,332 ($219,610) ($54,960) $719,000 683,000 1,402,000 $168,301 276,237 447,934 892,472 CAPITAL BUDGET Note: BVSWMA commenced operations in May, 1990. 0 88,000 35,500 123,500 PERCENT OF ANNUAL BUDGET 23.47 % 22.59 25.00 1.81 0.00 43.71 140.69 28.35 316.90 29.33 25.00 0.00 32.74 (1) Funds will be scheduled to be received when equipment purchases and capital construction are to take place. CITY OF COLLEGE STATION INVESTMENT MATURITY SCHEDULE December 31, 1991 MATURITY SETTLEMENT DESCRIPTION BROKER INTEREST RATE AMOUNT DATE CITY OF COLLEGE STATION INVESTMENT MATURITY SCHEDULE December 31, 1991 MATURITY SETTLEMENT DESCRIPTION BROKER INTEREST RATE AMOUNT DATE Daily Demand Accounts N.C.N.B: A&M $64,756.67 First American $561,169.55 Daily Agency Fund 1st City Nat'l Bank -Houston $12,516.84 Daily TexPool Fund -1st City TexPool $6,169,284.59 Daily TexPool Fund -First American TexPool 5.23% $966,416.21 TexPool Fund -Sales Tax TexPool $5,016.64 01-15-92 08/17/90 REFCORP Strip Coupon (1,500K) Union Planters 100% Bond Funds CUSIP: 76116EDM9 01-31-92 02/08/90 Treasury Note 8-1/8% (1,000K) First -Southwest 100% Operating Funds CUSIP: 912827YL0 05-31-92 09/25/90 Treasury Note 8-1/2% (2,000K) Prudential-Bache 50% Operating Funds 50% Bond Funds CUSIP: 912827YX4 8.22% 8.34% 8.11% $1,338,825.00 $996,015.63 $2,011,562.50 06-10-92 10/01/90 F.N.M.A. 10-1/8% (1,740K) First Southwest 8.06% $1,795,462.50 100% Operating Funds CUSIP: 313586SW0 08-15-92 02/05/90 Treasury Notes 7-7/8% (2,000K) Prudential-Bache 8.39% $1,976,718.75 100% Bond Funds CUSIP: 912827XV9 09-18-92 01/09/91 S.L.M.A. Notes 8.15% (1,000K) First Tennessee 7.25% $1,013,906.25 100% Bond Funds CUSIP: 863871 GR4 11-02-92 11/02/90 Cert. of Deposit -1st City lst City Nat'l Bank 7.90% $50,000.00 100% Cemetery Fund Corpus Christi 01-15-93 02/05/90 Treasury Note 8-3/4% (1,000K) Prudential-Bache 8.39% $1,009,218.75 100% Bonds Funds 02-15-93 08/31/90 Treasury Note 8-1/4% (1,600K) Prudential-Bache 8.21% $1,601,500.00 100% Operating Funds CUSIP: 912827VQ2 05-11-93 07/01/91 Financing Corporation Bonds (FICO) Vining -Sparks 7.20% $876,650.00 100% Operating Funds (1000K) CUSIP: 31771CAK1 CITY OF COLLEGE STATION INVESTMENT MATURITY SCHEDULE December 31,1991 MATURITY SETTLEMENT DESCRIPTION BROKER INTEREST RATE AMOUNT DATE 10-12-93 08/01/90 F.N.M.A. NOTE 9.05% (1,000K) Paine-Webber 8.70% $366,919.06 Index Sinking Fund Debenture 100% Operating Funds CUSIP: 313586558 11-15-93 11/15/90 Treasury Note 7-3/4% (1,000K) Shearson -Lehman 100% Bond Funds CUSIP: 912827ZM7 11-15-93 02/07/91 Treasury Note 7-3/4% ($1,000K) Prudential-Bache 100% Operating Funds CUSIP: 912827ZM7 11/14/94 12/12/91 F.F.C.B. Note 6.21% (500K) First Tennessee 100% Bond funds CUSIP: 313311N99 7.78% 7.00% $999,210.00 $1,018,437.50 $504,765.63 01-10-94 07/03/91 F.N.M.A. NOTE 7.55% ($1,000K) Shearson -Lehman 7.40% $1,003,281.25 100% Operating Funds CUSIP: 313586U80 03-01-94 03/01/91 F.F.C.B. Note 7.15% (1,000K) Prudential-Bache 7.15% $1,000,000.00 100% Operating Funds CUSIP: 313311 F31 C 04-15-94 03/20/91 REFCORP Strip Coupon (1,000K) First Tennessee 7.75% $791,726.28 100% Operating Funds CUSIP: 76116EAJ9 12-12-94 05/28/91 FNMA Coupon 8.30% (1,500K) MGSI 7.60% $1,531,875.00 Call Date 12/12/91 100% Bond Funds CUSIP: 313586L23 04-05-95 06/14/91 Financing Corporation Bonds (FICO) Vining -Sparks 8.15% $1,622,500.00 100% Bond Funds (2,200K) CUSIP: 31771 DCZ4 09/15/95 01/29/91 F.H.LM.C. 8.25% (1,000K) C.M.O. 2.4 years Cali Date 5/15/93 100% Bond Funds CUSIP: 312904X42 Shearson -Lehman 7.92% $836,205.97 7/1/96 8/22/91 F.H.LM.C. Gold 8% 5 yr. balloon (9751 Vining Sparks 7.56% $110,857.32 100% Bond Funds CUSIP: 31281XSG8 07-1-96 8/22/91 FHLMC Gold 8% 5 yr. balloon (975K) Vining Sparks 7.56% $109,066.62 100% Bond Funds CUSIP: 31281XPU0 CITY OF COLLEGE STATION INVESTMENT MATURITY SCHEDULE December 31, 1991 MATURITY SETTLEMENT DESCRIPTION' BROKER INTEREST RATE AMOUNT DATE 07-01-96 8/22/91 FHLMC Gold 8% 5 yr. balloon (975K) Vining Sparks 100% Bond Funds CUSIP: 31281XRC8 7-1-96 8/22/91 FHLMC Gold 7.5% 5 yr. balln. (1,000K) M.G.S.I. 100% Bond Funds CUSIP: 31281XW99 10/1/96 12/30/91 FHLMC Multifamily 8.5% (10001) M.G.S.I. 100% Bond Funds CUSIP: 313421LA5 7.56% 7.48% 6.71% $766,571.28 S1,000,872.68 $780,347.21 10-15-96 03/25/91 RECORP Strip Coupon (220K) First Southwest 8.23% $140,525.00 BVSWMA Closure Reserve CUSIP: 76116EAP5 11/1/96 11/21/91 FHLMC Gold 8% 5yr.balloon (200K) M.G.S.I. $1,010,986.14 100% Bond Funds Cusip: 31281YJ68 11/1/96 11/21/91 FHLMC Gold 8% 5yr.balloon (200K) M.G.S.I. $836,205.88 100% Bond Funds Cusip: 31282UCH8 11/1/96 11/21/91 FHLMC Gold 8% 5yr.balloon (200K) M.G.S.I. $59,104.45 100% Bond Funds Cusip: 31281YG61 11/1/96 11/21/96 FHLMC Gold 8% 5yr.balloon (200K) M.G.S.I. $116,694.91 100% Bond Funds Cusip: 31281YEJ5 TOTAL $35,055,172.06 COLLATERAL HELD: CITY OF COLLEGE STATION COLLATERAL RECONCILIATION December 31,1991 COLLATERAL BOOK MARKET VALUE BALANCE I. FIRST AMERICAN BANK $1,000,000 S1,072,800.00 S.LM.A. (+accrued interest) 10.50 4/22/93 1.0728 CUSIP 863871AJ8 (12/31/91 WSJ) Plus $100,000 FDIC coverage $561,169.55 MONTHLY FINANCIAL REPORT NOVEMBER, 1991 GENERAL FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 NOVEMBER, 1991 (17% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (2 MONTHS) (2 MONTHS) (DECREASE) BUDGET BUDGET REVENUES: Sales Tax (1) $848,300 $1,295,165 52.68 % 6,572,800 19.70 % Property Tax (2) 103,817 295,331 184.47 1,394,720 21.17 Court Revenues 85,369 123,647 44.84 561,000 22.04 Parks & Recreation 20,743 26,287 26.73 386,400 6.80 Trf. In -lieu -of taxes 0 648,312 0.00 3,889,900 16.67 Transfer - Admin. 24,775 411,750 1561.96 2,640,423 15.59 Investment Earnings 5,388 5,029 (6.66) 308,500 1.63 Miscellaneous 104,139 103,469 (0.64) 1,006,400 10.28 TOTAL REVENUES 1,192,531 2,908,990 143.93 16,760,143 17.36 EXPENDITURES: Police 554,123 616,589 11.27 % 4,102,717 15.03 Fire 323,326 384,544 18.93 3,144,397 12.23 Public Services 166,399 231,600 39.18 2,326,201 9.96 Culture & Recreation 338,238 360,972 6.72 2,597,035 13.90 Development Services 184,724 206,578 11.83 1,360,346 15.19 Administration 113,624 133,024 17.07 799,921 16.63 Fiscal & Human Res. 170,379 212,260 24.58 1,506,503 14.09 Management Services 267,948 303,971 13.44 1,532,092 19.84 Non -Dept. and Contingency 41,941 41,135 (1.92) 312,032 13.18 TOTAL EXPENDITURES Unexpended Appropriations REVENUES IN EXCESS OF 2,160,702 2,490,673 15.27 17,681,244 ($790,340) EXPENDITURES (DEFICIT) ($968,171) $418,317 ($130,761) (1) Local sales tax increased from 1% to 1-1/2%, effective with December 1990 payments. (2) General fund property tax declined from 13.25c per $100 in 1990 to 12.25c per $100 in 1992. 14.09 HOTEL/MOTEL TAX FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 NOVEMBER, 1991 (17% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (2 MONTHS) (2 MONTHS) (DECREASE) BUDGET BUDGET REVENUES: Tax Receipts $155,422 $173,319 11.52 % $927,000 18.70 % Center Rentals 10,121 15,155 49.74 50,500 30.01 Miscellaneous 1,243 988 (20.51) 26,800 3.69 TOTAL REVENUES 166,786 189,462 13.60 1,004,300 18.87 EXPENDITURES: Center Operations 0 43,290 0.00 259,748 16.67 Debt Service 0 9,824 0.00 58,947 16.67 Chamber of Commerce 50,000 89,375 78.75 357,500 25.00 Arts Council 47,973 44,516 (7.21) 110,000 40.47 B/CS Athlethic Fed. 0 0 0.00 14,500 0.00 Parks & Recreation 0 22,639 0.00 92,450 24.49 Conf. Ctr.- Capital 4,934 8,605 74.40 45,978 18.72 Contingency 0 150,000 0.00 30,000 Trf: Wolfpen Creek 0 0 0.00 226,500 0.00 TOTAL EXPENDITURES 102,907 368,249 257.85 1,195,623 30.80 REVENUES IN EXCESS OF EXPENDITURES (DEFICIT) $63,879 ($178,787) ($191,323) DEBT SERVICE FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 NOVEMBER, 1991 (17% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (2 MONTHS) (2 MONTHS) (DECREASE) BUDGET BUDGET REVENUES: Property Tax (1) $582,466 $1,119,897 92.27 % $3,129,550 35.78 % Transfer from other funds 107,794 100,616 (6.66) 58,945 170.69 Investment Earnings 4,476 0 (100.00) 135,000 0.00 TOTAL REVENUES 694,736 1,220,513 75.68 3,323,495 36.72 EXPENDITURES: General Obligation Bonds: Principal 0 0 0.00 2,100,220 0.00 Interest 0 0 0.00 1,486,275 0.00 Certificate of Obligation: Principal Interest Miscellaneous TOTAL EXPENDITURES REVENUES IN EXCESS OF EXPENDITURES(DEFICIT) 0 0 0 0.00 203,018 0.00 0 0.00 68,675 0.00 1,955 2,053 5.01 15,000 13.69 1,955 2,053 5.01 3,873,188 0.05 $692,781 $1,218,460 ($549,693) (1) Debt service property tax increased from 26.75c per $100 valuation in 1991 to 27.75c per $100 In 1992, offset by decrease In General Fund Property Tax. REVENUES: Collection Charges Penalties Recycling Interest Earnings Reimbursed Administrative Miscellaneous TOTAL REVENUES SOLID WASTE COLLECTION FUNDS REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 NOVEMBER, 1991 (17% OF FISCAL YEAR) ACTUAL ACTUAL 1991 1992 (2 MONTHS) (2 MONTHS) PERCENTAGE INCREASE (DECREASE) $296,631 $317,157 6.92 $3,582 3,465 (3.27) 469 330 (29.64) 39,795 0 (100.00) 0 8,240 100.00 5,540 1,974 (64.37) EXPENSES: Collection Reimbursed Administrative Transfer in Lieu of Taxes Contribution to Brazos Beautiful Capital Outlay Debt Service Miscellaneous TOTAL EXPENSES Unexpended Appropriations NET INCOME (CASH BASIS) 346,017 331,166 (4.29) 250,896 196,609 (21.64) 0 66,044 0.00 0 24,850 0.00 O 0 0.00 7,897 1,187 (84.97) 0 13,858 100.00 O 833 0.00 1992 PERCENT ANNUAL OF ANNUAL BUDGET BUDGET % $1,855,537 17.09 % 20,000 17.33 4,000 8.2F 38,000 0.00 49,444 16.67 181,426 1.09 2,148,407 15.41 1,700,337 11.56 300,122 22.01 156,270 15.90 10,000 0.00 0 0.00 81,517 17.00 135,847 0.61 258,793 303,381 17.23 2,384,093 12.73 (69,500) $87,224 $27,785 ($166,186) NOTE: BVSWMA started operations in May, 1990. City of College Station pays $15/ton tipping fee at landfill. 2,000,000 - 1,800,000 - 1,600,000 - 1,400,000 - 1,200,000 - 1,000,000 - 800,000 - 600,000 - 400,000 - 200,000 - 0 SOLID WASTE COLLECTION REVENUE VS BUDGET I I I I I I I OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ❑ BUDGET ® ACTUAL -- BUDGET/ 12 LANDFILL FUND REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 NOVEMBER, 1991 (17% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (2 MONTHS) (2 MONTHS) (DECREASE) BUDGET BUDGET REVENUES: Landfill Operator Fees $72,703 $118,373 62.82 $710,237 Interest Earnings ($420) 0 (100.00) 0 TOTAL REVENUES 72,283 118,373 63.76 710,237 16.67 % 0.00 16.67 EXPENSES: Landfill Operator 71,581 81,332 13.62 496,669 16.38 Reimbursed Administrative 0 30,894 0.00 185,378 16.67 Capital Outlay 1,122 0 (100.00) 31,690 0.00 Contingency 0 0 0.00 20,000 0.00 TOTAL EXPENSES 72,703 112,226 54.36 733,737 15.30 Unexpended Appropriations (23,500) NET INCOME (CASH BASIS) ($420) $6,147 $0 NOTE: BVSWMA started operations in May, 1990. City of College Station serves as landfill operator and is reimbursed for expenses. ELECTRIC FUND REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 NOVEMBER, 1991 (17% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (2 MONTHS) (2 MONTHS) (DECREASE) BUDGET BUDGET REVENUES: Sale of Electricity (1) $4,516,848 $4,345,883 (3.79) % $30,021,964 14.48 % Investment Earnings 19,962 0 (100.00) 625,000 0.00 Miscellaneous 89,968 71,428 (20.61) 448,700 15.92 TOTAL REVENUES 4,626,778 4,417,311 (4.53) 31,095,664 14.21 EXPENSES: Wholesale Power (2) 1,690,383 1,632,141 (3.45) 19,767,143 8.26 Electric Operations 26,323 26,760 1.66 291,696 09.17 Transmission & Distribution 240,364 304,100 26.52 2,597,507 11.71 Reimbursed Admin. & Transfer in -lieu of Taxes (1) 0 527,292 0.00 3,187,766 16.54 Development Foundation 0 0 0.00 110,000 00.00 Debt Service (Budget Proration) 161,806 178,822 10.52 1,241,143 14.41 Utility Billing 0 126,296 0.00 713,346 17.70 Capital Outlay 4,512 17,417 286.02 116,551 14.94 TOTAL EXPENSES 2,123,388 2,812,828 32.47 28,025,152 10.04 NET INCOME (CASH BASIS) $2,503,390 $1,604,483 $3,070,512 (1) Two months electric sales. (2) One month wholesale power purchases. 35, 000, 000 - 30, 000, 000 - 25,000,000 - 20,000,000 - 15,000,000 - 10,000,000 - 5,000,000 - ELECTRIC REVENUE BUDGET VS ACTUAL 0 NI 1 1 1 1 1 1 I 1 1 1 I OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ❑ BUDGET ® ACTUAL y BUDGET/ 12 WATER FUND REVENUE/EXPENDSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 NOVEMBER, 1991 (17% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (2 MONTHS) (2 MONTHS) (DECREASE) BUDGET BUDGET REVENUES: Water Sales (1) $860,908 $830,507 (3.53) % $5,249,201 15.82 % Investment Earnings 5 0 (100.00) 0 Miscellaneous 16,698 20,050 20.07 88,300 22.71 TOTAL REVENUES 877,611 850,557 (3.08) 5,337,501 15.94 EXPENSES: Water Production & Distribution 11,242 307,907 2638.90 2,573,393 11.97 Reimbursed Admin.& Transfer in -lieu of Taxes 0 144,292 0.00 1,053,032 13.70 Debt Service (Budget Proration) 302,600 326,396 7.86 2,081,835 15.68 Utility Billing 0 42,798 0.00 272,236 15.72 Capital Outlay 4,239 8,445 99.22 24,250 34.82 TOTAL EXPENSES 318,081 829,838 160.89 6,004,746 13.82 NET INCOME (CASH BASIS) $559,530 $20,719 ($667,245) (1) Water rates increased by 10% in 1991, the fourth year of 5-year scheduled increases to cost of service. 6,000,000 - 5,000,000 - 4,000,000 - 3,000,000 - 2,000,000 - 1,000,000 - WATER REVENUE VS ACTUAL 0 ' I 1 1 1 1 1 1 1 1 1 1 I OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ❑ BUDGET ® ACTUAL - BUDGET/ 12 SEWER FUND REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 NOVEMBER, 1991 (17% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (2 MONTHS) (2 MONTHS) (DECREASE) BUDGET BUDGET REVENUES: Sewer Service Revenue (1) $641,933 $717,083 11.71 % $4,370,800 16.41 % Investment Earnings 2,482 0 (100.00) 60,000 0.00 Miscellaneous 12,262 12,698 3.56 70,100 18.11 TOTAL REVENUES 656,677 729,781 11.13 4,500,900 16.21 EXPENSES: Sewer Collection & Treatment 163,966 191,075 16.53 1,906,097 10.02 Reimbursed Admin. & Trf. In -lieu of Taxes 0 109,018 0.00 799,586 13.63 Debt Service (Budget Proration) 229,398 259,668 13.20 1,650,391 15.73 Utility Billing 0 21,740 0.00 143,574 15.14 Capital Outlay 0 5,639 0.00 72,700 7.76 TOTAL EXPENSES 393,364 587,140 49.26 4,572,348 12.84 NET INCOME (CASH BASIS) $263,313 $142,641 ($71,448) (1) No changes to rate structure in 1991. 4,500,000 - 4,000,000 - 3,500,000 - 3,000,000 - 2,500,000 - 2,000,000 - 1,500,000 - 1,000,000 - 500,000 - SEWER REVENUE VS BUDGET 0 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ❑ BUDGET ® ACTUAL - BUDGET/ 12 REVENUES: Landfill Charges Miscellaneous Interest TOTAL REVENUES EXPENSES: Operating Expenses: Landfill Operator Consultants/Professional Svcs Equipment Rental State Disposal Fees Maintenance Insurance Reimbursed Administrative Project Rose Contingency Miscellaneous Total Operating Expenses Machinery and Equipment Debt Service - Notes Reserves (Budget Proration) Total Other Expenses TOTAL EXPENSES NET INCOME (CASH BASIS) REVENUES: Debt Issue (2) City of Bryan (2) Total Revenues EXPENSES: Capital Outlay: Land Improvements Machinery and Equipment Total Expenses BRAZOS VALLEY SOLID WASTE MANAGEMENT AGENCY REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 NOVEMBER, 1991 (17% OF FISCAL YEAR) OPERATING BUDGET ACTUAL 1991 (2 MONTHS) $294,956 (10) 1,593 296,539 ACTUAL PERCENTAGE 1992 INCREASE (2 MONTHS) (DECREASE) $299,452 0 (5,989) 293,463 1.52 (100.00) (1.04) 1992 ANNUAL BUDGET % $1,875,000 30,000 81,300 1,986,300 $72,703 112,226 54.36 710,237 0 526 0.00 75,000 0 0 0.00 17,000 0 0 0.00 62,500 0 44,012 0.00 30,000 10,502 0 (100.00) 17,000 0 14,588 0.00 40,000 0 0 0.00 50,000 0 0 0.00 25,000 4,453 6,655 49.45 90,000 87,658 178,007 103.07 1,116,737 42,963 117,230 172.86 35,500 50,760 50,983 0.44 389,023 42,615 85,000 99.46 500,000 0 0 0.00 924,523 $223,996 $431,220 92.51 $2,041,260 $72,543 ($137,757) ($54,960) $719,000 683,000 1,402,000 $168,301 276,237 447,934 892,472 CAPITAL BUDGET Note: BVSWMA commenced operations in May, 1990. 0 0 0 0 88,000 35,500 123,500 PERCENT OF ANNUAL BUDGET 15.97 % 14.77 15.80 0.70 0.00 0.00 146.71 15.94 330.23 13.11 17.00 0.00 21.13 (1) Funds will be scheduled to be received when equipment purchases and capital construction are to take place. CITY OF COLLEGE STATION INVESTMENT MATURITY SCHEDULE November 30, 1991 MATURITY SETTLEMENT DESCRIPTION BROKER INTEREST RATE AMOUNT DATE Daily Demand Accounts N.C.N.B: A&M $65,404.87 First American $671,807.25 Daily Agency Fund 1st City Nat'l Bank -Houston $18,786.92 Daily TexPool Fund -1st City TexPool $1,424,381.60 Daily TexPool Fund -First American TexPool 5.53% $961,916.76 TexPool Fund -Sales Tax TexPool $667,167.23 01-15-92 08/17/90 REFCORP Strip Coupon (1,500K) Union Planters 100% Bond Funds CUSIP: 76116EDM9 01-31-92 02/08/90 Treasury Note 8-1/8% (1,000K) First -Southwest 100% Operating Funds CUSIP: 912827YL0 05-31-92 09/25/90 Treasury Note 8-1/2% (2,000K) Prudential-Bache 50% Operating Funds 50% Bond Funds CUSIP: 912827YX4 8.22% 8.34% 8.11% $1,338,825.00 $996,015.63 $2,011,562.50 06-10-92 10/01/90 F.N.M.A. 10-1/8% (1,740K) First Southwest 8.06% $1,795,462.50 100% Operating Funds CUSIP: 313586SW0 08-15-92 02/05/90 Treasury Notes 7-7/8% (2,000K) Prudential-Bache 8.39% $1,976,718.75 100% Bond Funds CUSIP: 912827XV9 09-18-92 01/09/91 S.LM.A. Notes 8.15% (1,000K) First Tennessee 7.25% $1,013,906.25 100% Bond Funds CUSIP: 863871 GR4 11-02-92 11/02/90 Cert. of Deposit - 1st City 1st City Nat'l Bank 7.90% $50,000.00 100% Cemetery Fund Corpus Christi 01-15-93 02/05/90 Treasury Note 8-3/4% (1,000K) Prudential-Bache 8.39% $1,009,218.75 100% Bonds Funds 02-15-93 08/31/90 Treasury Note 8-1/4% (1,600K) Prudential-Bache 8.21% $1,601,500.00 100% Operating Funds CUSIP: 912827VQ2 05-11-93 07/01/91 Financing Corporation Bonds (FICO) Vining -Sparks 7.20% $876,650.00 100% Operating Funds (1000K) CUSIP: 31771 CAK1 10-12-93 08/01/90 F.N.M.A. NOTE 9.05% (1,000K) Index Sinking Fund Debenture 100% Operating Funds CUSIP: 313586S58 Paine-Webber 8.70% $366,919.06 CITY OF COLLEGE STATION INVESTMENT MATURITY SCHEDULE November 30, 1991 MATURITY SETTLEMENT DESCRIPTION BROKER DATE 11-15-93 11/15/90 Treasury Note 7-3/4% (1,000K) Shearson -Lehman 100% Bond Funds CUSIP: 912827ZM7 11-15-93 02/07/91 Treasury Note 7-3/4% ($1,000K) Prudential-Bache 100% Operating Funds CUSIP: 912827ZM7 01-10-94 07/03/91 F.N.M.A. NOTE 7.55% ($1,000K) Shearson -Lehman 100% Operating Funds CUSIP: 313586U80 03-01-94 03/01/91 F.F.C.B. Note 7.15% (1,000K) Prudential-Bache 100% Operating Funds CUSIP: 313311 F31 C 04-15-94 03/20/91 REFCORP Strip Coupon (1,000K) First Tennessee 100% Operating Funds CUSIP: 76116EAJ9 12-12-94 05/28/91 FNMA Coupon 8.30% (1,500K) MGSI Call Date 12/12/91 100% Bond Funds CUSIP: 313586L23 INTEREST RATE AMOUNT 7.78% 7.00% 7.40% 7.15% 7.75% 7.60% $999,210.00 $1,018,437.50 $1,003,281.25 $1,000,000.00 $791,726.28 $1,531,875.00 04-05-95 06/14/91 Financing Corporation Bonds (FICO) Vining -Sparks 8.15% $1,622,500.00 100% Bond Funds (2,200K) CUSIP: 31771DCZ4 09/15/95 01/29/91 F.H.LM.C. 8.25% (1,000K) C.M.O. 2.4 years Call Date 5/15/93 100% Bond Funds CUSIP: 312904X42 Shearson -Lehman 7.92% $852,246.57 7/1/96 8/22/91 F.H.LM.C. Gold 8% 5 yr. balloon (9751 Vining Sparks 7.56% $111,110.03 100% Bond Funds CUSIP: 31281XSG8 07-1-96 8/22/91 FHLMC Gold 8% 5 yr. balloon (975K) Vining Sparks 7.56% $109,154.74 100% Bond Funds CUSIP: 31281XPU0 07-01-96 8/22/91 FHLMC Gold 8% 5 yr. balloon (975K) Vining Sparks 7.56% $767,258.92 100% Bond Funds CUSIP: 31281XRC8 7-1-96 8/22/91 FHLMC Gold 7.5% 5 yr. balln. (1,000K) M.G.S.I. 7.48% $1,001,489.78 100% Bond Funds CUSIP: 31281XW99 CITY OF COLLEGE STATION INVESTMENT MATURITY SCHEDULE November 30, 1991 MATURITY SETTLEMENT DESCRIPTION BROKER INTEREST RATE AMOUNT DATE 10-15-96 03/25/91 RECORP Strip Coupon (220K) First Southwest BVSWMA Closure Reserve CUSIP: 76116EAP5 11/1/96 11/21/91 FHLMC Gold 8% 5yr.balloon M.G.S.I. 100% Bond Funds Cusip: 31281YJ68 11/1/96 11/21/91 FHLMC Gold 8% 5yr. balloon M.G.S.I. 100% Bond Funds Cusip: 31282UCH8 11/1/96 11/21/91 FHLMC Gold 8% 5yr. balloon M.G.S.. 100% Bond Funds Cusip: 31281YG61 11/1/96 11/21/96 FHLMC Gold 8% 5yr. balloon M.G.S.. 100% Bond Funds Cusip: 31281YEJ5 8.23% $140,525.00 $1,011,563.54 $837,473.11 $59,137.50 $116,762.33 TOTAL $29,819,994.62 COLLATERAL HELD: L FIRST AMERICAN BANK $1,000,000 S.L..M.A. 10.50 4/22/93 CUSIP 863871 AJ8 CITY OF COLLEGE STATION COLLATERAL RECONCILIATION November 30,1991 COLLATERAL MARKET VALUE $1,067,800.00 (+accrued Interest) 1.0678 (11/30/91 WSJ) Plus $100,000 FDIC coverage BOOK BALANCE $671,807.25 MONTHLY FINANCIAL REPORT O CTO B E R, 1991 REVENUES: Sales Tax (1) Property Tax (2) Court Revenues Parks & Recreation Trf. In -lieu -of taxes Transfer - Admin. Investment Earnings Miscellaneous TOTAL REVENUES EXPENDITURES: GENERAL FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 OCTOBER, 1991 (8% OF FISCAL YEAR) ACTUAL ACTUAL 1991 1992 (1 MONTH) (1 MONTH) $322,069 $878,529 15,927 15,478 46,994 70,361 10,356 20,107 0 0 8,108 30,930 297 1,802 96,311 45,873 Police Fire Public Services Culture & Recreation Development Services Administration Fiscal & Human Res. Management Services Non -Departmental and Continge TOTAL EXPENDITURES Unexpended Appropriations REVENUES IN EXCESS OF EXPENDITURES (DEFICIT) 500,062 1,063,080 PERCENTAGE INCREASE (DECREASE) 1992 PERCENT ANNUAL OF ANNUAL BUDGET BUDGET 172.78 % 6,572,800 13.37 % (2.82) 1,394,720 1.11 49.72 561,000 12.54 94.16 386,400 5.20 0.00 3,889,900 0.00 281.48 2,640,423 1.17 506.73 308,500 0.58 (52.37) 1,006,400 4.56 112.59 16,760,143 6.34 283,133 326,527 15.33 % 4,102,717 164,519 164,396 (0.07) 3,144,397 97,549 120,712 23.74 2,326,201 177,111 178,063 0.54 2,597,035 91,080 103,136 13.24 1,360,346 60,249 67,494 12.03 799,921 83,132 110,586 33.02 1,506,503 155,177 202,515 30.51 1,532,092 26,575 0 (100.00) 312,032 1,138,525 1,273,429 ($638,463) ($210,349) 11.85 17,681,244 ($786,983) ($134,118) (1) Local sales tax Increased from 1% to 1-1/2%, effective with December 1990 payments. (2) General fund property tax declined from 13.25c per $100 In 1990 to 12.25c per $100 in 1992. 7.96 5.23 5.19 6.86 7.58 8.44 7.34 13.22 0.00 7.20 HOTEL/MOTEL TAX FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 OCTOBER, 1991 (8% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (1 MONTH) (1 MONTH) (DECREASE) BUDGET BUDGET REVENUES: Tax Receipts $79,991 $91,352 14.20 % $927,000 9.85 % Center Rentals 4,803 8,407 75.04 50,500 16.65 Miscellaneous 55 716 1201.82 26,800 2.67 TOTAL REVENUES 84,849 100,475 18.42 1,004,300 10.00 EXPENDITURES: Center Operations 0 0 0.00 259,748 0.00 Debt Service 0 0 0.00 58,947 0.00 Chamber of Commerce 0 0 0.00 357,500 0.00 Arts Council 0 44,516 100.00 110,000 40.47 B/CS Athlethic Fed. 0 0 0.00 14,500 0.00 Parks & Recreation 1,835 2,075 13.08 92,450 2.24 Conf. Ctr: Capital 0 0 0.00 45,978 0.00 Contingency 0 0.00 30,000 Trf: Wolfpen Creek 0 0 0.00 226,500 0.00 TOTAL EXPENDITURES 1,835 46,591 2439.02 1,195,623 3.90 REVENUES IN EXCESS OF EXPENDITURES (DEFICIT) $83,014 $53,884 ($191,323) REVENUES: Property Tax (1) Transfer from other funds Investment Earnings TOTAL REVENUES EXPENDITURES: General Obligation Bonds: Principal Interest Certificate of Obligation: Principal Interest Miscellaneous TOTAL EXPENDITURES REVENUES IN EXCESS OF EXPENDITURES(DEFICIT) DEBT SERVICE FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 OCTOBER, 1991 (8% OF FISCAL YEAR) ACTUAL ACTUAL 1991 1992 (1 MONTH) (1 MONTH) $51,569 $38,089 0 0 190 0 51,759 38,089 0 0 0 0 766 766 $50,993 0 0 0 0 831 831 $37,258 PERCENTAGE INCREASE (DECREASE) (26.14) % 0.00 (100.00) (26.41) 0.00 0.00 0.00 0.00 8.49 8.49 1992 ANNUAL BUDGET $3,129,550 58,945 135,000 3,323,495 2,100,220 1,486,275 203,018 68,675 15,000 3,873,188 ($549,693) PERCENT OF ANNUAL BUDGET 1.22 % 0.00 0.00 1.15 0.00 0.00 0.00 0.00 5.54 0.02 (1) Debt service property tax increased from 26.75c per $100 valuation in 1991 to 27.75c per $100 in 1992, offset by decrease in General Fund Property Tax. SOLID WASTE COLLECTION FUNDS REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 OCTOBER, 1991 (8% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (1 MONTH) (1 MONTH) (DECREASE) BUDGET BUDGET REVENUES: Collection Charges $115,869 $159,901 38.00 % $1,855,537 8.62 % Penalties 1,772 1,837 3.67 20,000 9.19 Recycling 487 330 (32.24) 4,000 8.25 Interest Earnings 727 0 (100.00) 38,000 0.00 Reimbursed Administrative 0 0 0.00 49,444 0.00 Miscellaneous (3,579) 1,970 (155.04) 181,426 1.09 TOTAL REVENUES 115,276 164,038 42.30 2,148,407 7.64 EXPENSES: Collection 97,673 101,172 3.58 1,700,337 5.95 Reimbursed Administrative 0 0 0.00 300,122 0.00 Transfer In Lieu of Taxes 0 0 0.00 156,270 0.00 Contribution to Brazos Beautiful 0 0 0.00 10,000 0.00 Capital Outlay 0 1,187 100.00 0 0.00 Debt Service 0 6,521 100.00 81,517 8.00 Miscellaneous 0 0 0.00 135,847 0.00 TOTAL EXPENSES 97,673 108,880 11.47 2,384,093 4.57 Unexpended Appropriations (69,500) NET INCOME (CASH BASIS) $17,603 $55,158 - ($166,186) NOTE: BVSWMA started operations in May, 1990. City of College Station pays $15/ton tipping fee at landfill. SOLID WASTE COLLECTION REVENUE VS BUDGET 2,000,000 - 1,800,000 - 1,600,000 - 1,400,000 - 1,200,000 - 1,000,000 - 800,000 - 600,000 - 400,000 - 200,000 - 0 1 1 I I I I I I I I I I OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ❑ BUDGET ® ACTUAL - BUDGET/ 12 LANDFILL FUND REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 OCTOBER, 1991 (8% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (1 MONTH) (1 MONTH) (DECREASE) BUDGET BUDGET REVENUES: Landfill Operator Fees $38,443 $0 (100.00) $710,237 0.00 % Interest Earnings ($41) 0 (100.00) 0 0.00 TOTAL REVENUES 38,402 0 (100.00) 710,237 0.00 EXPENSES: Landfill Operator 33,783 44,065 30.44 496,669 8.87 Reimbursed Administrative 0 0 0.00 185,378 0.00 Capital Outlay 477 0 (100.00) 31,690 0.00 Contingency 0 0 0.00 20,000 0.00 TOTAL EXPENSES 34,260 44,065 28.62 733,737 6.01 Unexpended Appropriations (23,500) NET INCOME (CASH BASIS) $4,142 ($44,065) $0 NOTE: BVSWMA started operations in May, 1990. City of College Station serves as landfill operator and is reimbursed for expenses. ELECTRIC FUND REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 OCTOBER, 1991 (8% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (1 MONTH) (1 MONTH) (DECREASE) BUDGET BUDGET REVENUES: Sale of Electricity (1) $1,682,789 $2,193,948 30.38 % $30,021,964 7.31 % Investment Earnings 19,009 31,250 64.40 625,000 5.00 Miscellaneous 40,059 1,994 (95.02) 448,700 0.44 TOTAL REVENUES 1,741,857 2,227,192 27.86 31,095,664 7.16 EXPENSES: Wholesale Power (2) 1,120 8,744 680.71 19,767,143 0.04 Electric Operations 9,211 10,374 12.63 291,696 3.56 Transmission & Distribution 118,927 115,922 (2.53) 2,597,507 4.46 Reimbursed Admin. & Transfer in -lieu of Taxes (1) 0 0 0.00 3,187,766 0.00 Development Foundation 0 0 0.00 110,000 0.00 Debt Service (Budget Proration) 76,144 84,152 10.52 1,241,143 6.78 Utility Billing 0 0 0.00 713,346 0.00 Capital Outlay 498 9,424 1792.37 116,551 8.09 TOTAL EXPENSES 205,900 228,616 11.03 28,025,152 0.82 NET INCOME (CASH BASIS) $1,535,957 $1,998,576 $3,070,512 (1) One month electric sales. (2) Zero months wholesale power purchases. 35,000,000 - 30, 000, 000 - 25, 000, 000 - 20,000,000 - 15, 000, 000 - 10,000,000 - 5,000,000 - 0 "I ELECTRIC REVENUE BUDGET VS ACTUAL ❑ BUDGET ® ACTUAL BUDGET/ 12 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP WATER FUND REVENUE/EXPENDSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 OCTOBER, 1991 (8% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (1 MONTH) (1 MONTH) (DECREASE) BUDGET BUDGET REVENUES: Water Sales (1) $338,341 $424,357 25.42 % $5,249,200 8.08 % investment Earnings 39 0 (100.00) 0 0.00 Miscellaneous 1,457 111,270 7536.93 88,300 126.01 TOTAL REVENUES 339,837 535,627 57.61 5,337,500 10.04 EXPENSES: Water Production & Distribution 1,785 178,283 9887.84 2,573,393 6.93 Reimbursed Admin.& Transfer in -lieu of Taxes 0 0 0.00 1,053,032 0.00 Debt Service (Budget Proration) 142,400 153,598 7.86 2,081,835 7.38 Utility Billing 0 0 0.00 272,236 0.00 Capital Outlay 4,229 5,120 21.07 24,250 21.11 TOTAL EXPENSES 148,414 337,001 127.07 6,004,746 5.61 NET INCOME (CASH BASIS) $191,423 $198,626 ($667,246) (1) Water rates increased by 10% In 1992, the fifth year of 5-year scheduled increases to cost of service. 6,000,000 - 5,000,000 - 4,000,000 - 3,000,000 - 2,000,000 - 1,000,000 - WATER REVENUE VS ACTUAL 0 \-I 1 I I I I I I I 1 1 I OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ❑ BUDGET ® ACTUAL -- BUDGET/ 12 SEWER FUND REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 OCTOBER, 1991 (8% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (1 MONTH) (1 MONTH) (DECREASE) BUDGET BUDGET REVENUES: Sewer Service Revenue $260,235 $360,999 38.72 % $4,370,800 8.26 % investment Earnings 2,383 0 (100.00) 60,000 0.00 Miscellaneous 1,749 6,841 291.14 70,100 9.76 TOTAL REVENUES 264,367 367,840 39.14 4,500,900 8.17 EXPENSES: Sewer Collection & Treatment 76,619 75,030 (2.07) 1,906,097 3.94 Reimbursed Admin. & Trf. in -lieu of Taxes 0 0 0.00 799,586 0.00 Debt Service (Budget Proration) 0 1,222,197 0.00 1,650,391 74.05 Utility Billing 0 0 0.00 143,574 0.00 Capital Outlay 0 2,187 0.00 72,700 3.01 TOTAL EXPENSES 76,619 1,299,414 1595.94 4,572,348 28.42 NET INCOME (CASH BASIS) $187,748 ($931,574) ($71,448) 4,500,000 - 4,000,000 - 3,500,000 - 3,000,000 - 2,500,000 - 2,000,000 - 1,500,000 - 1,000,000 - 500,000 - SEWER REVENUE VS BUDGET 0 ' I I I I I I I 1 I I I I OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ❑ BUDGET ® ACTUAL -- BUDGET/ 12 BRAZOS VALLEY SOLID WASTE MANAGEMENT AGENCY REVENUE/EXPENSE ANALYSIS (CASH BASIS) FISCAL YEARS 1991 & 1992 OCTOBER, 1991 (8% OF FISCAL YEAR) OPERATING BUDGET ACTUAL ACTUAL PERCENTAGE 1992 PERCENT 1991 1992 INCREASE ANNUAL OF ANNUAL (1 MONTH) (1 MONTH) (DECREASE) BUDGET BUDGET REVENUES: Landfill Charges $133,203 $146,476 9.96 % $1,875,000 7.81 % Miscellaneous 1,593 50,197 3051.10 30,000 167.32 Interest 0 (5,989) 81,300 (7.37) TOTAL REVENUES 134,796 190,684 41.46 1,986,300 9.60 EXPENSES: Operating Expenses: Landfill Operator $34,260 0 (100.00) 710,237 0.00 Consultants/Professional Svcs 0 0 0.00 75,000 0.00 Equipment Rental 0 0 0.00 17,000 0.00 State Disposal Fees 0 0 0.00 62,500 0.00 Maintenance 0 37,121 0.00 30,000 123.74 Insurance 8,330 0 (100.00) 17,000 0.00 Reimbursed Administrative 0 14,588 0.00 40,000 36.47 Project Rose 0 0 0.00 50,000 0.00 Contingency 0 0 0.00 25,000 0.00 Miscellaneous 3,464 0 (100.00) 90,000 0.00 Total Operating Expenses 46,054 51,709 12.28 1,116,737 4.63 Machinery and Equipment 26,909 0 35,500 0.00 Debt Service - Notes 85,051 168,213 389,023 43.24 Reserves (Budget Proration) 0 40,000 500,000 8.00 Total Other Expenses 0 208,213 924,523 22.52 TOTAL EXPENSES $158,014 $259,922 $2,041,260 12.73 NET INCOME (CASH BASIS) ($23,218) ($69,238) ($54,960) REVENUES: Debt Issue (2) City of Bryan (2) Total Revenues $719,000 683,000 1,402,000 CAPITAL BUDGET 0 0 0 EXPENSES: Capital Outlay: Land $168,301 0 Improvements 276,237 88,000 Machinery and Equipment 447,934 35,500 Total Expenses 892,472 123,500 Note: BVSWMA commenced operations in May, 1990. (1) Funds will be scheduled to be received when equipment purchases and capital construction are to take place. CITY OF COLLEGE STATION INVESTMENT MATURITY SCHEDULE October 31,1991 MATURITY SETTLEMENT DESCRIPTION BROKER INTEREST RATE AMOUNT DATE Daily Demand Accounts N.C.N.B: A&M $72,930.39 First American $542,844.92 Daily Agency Fund 1st City Nat'l Bank -Houston $15,722.93 Daily TexPool Fund -1st City TexPool $842,816.80 Daily TexPool Fund -First American TexPool 6.03% $957,193.66 TexPool Fund -Sales Tax TexPool $1,367,246.68 01-15-92 08/17/90 REFCORP Strip Coupon (1,500K) Union Planters 100% Bond Funds CUSIP: 76116EDM9 01-31-92 02/08/90 Treasury Note 8-1/8% (1,000K) First -Southwest 100% Operating Funds CUSIP: 912827YL0 05-31-92 09/25/90 Treasury Note 8-1/2% (2,000K) Prudential-Bache 50% Operating Funds 50% Bond Funds CUSIP: 912827YX4 8.22% 8.34% 8.11% $1,338,825.00 $996,015.63 $2,011,562.50 06-10-92 10/01/90 F.N.M.A. 10-1/8% (1,740K) First Southwest 8.06% $1,795,462.50 100% Operating Funds CUSIP: 313586SW0 08-15-92 02/05/90 Treasury Notes 7-7/8% (2,000K) Prudential-Bache 8.39% $1,976,718.75 100% Bond Funds CUSIP: 912827XV9 09-18-92 01/09/91 S.LM.A. Notes 8.15% (1,000K) First Tennessee 7.25% $1,013,906.25 100% Bond Funds CUSIP: 863871 GR4 11-02-92 11/02/90 Cert. of Deposit - 1st City 1st City Nat'l Bank 7.90% $50,000.00 100% Cemetery Fund Houston 01-15-93 02/05/90 Treasury Note 8-3/4% (1,000K) Prudential-Bache 8.39% $1,009,218.75 100% Bonds Funds 02-15-93 08/31/90 Treasury Note 8-1/4% (1,600K) Prudential-Bache 8.21% $1,601,500.00 100% Operating Funds CUSIP: 912827VQ2 05-11-93 07/01/91 Financing Corporation Bonds (FICO) Vining -Sparks 7.20% $876,650.00 100% Operating Funds (1000K) CUSIP: 31771CAK1 10-12-93 08/01/90 F.N.M.A. NOTE 9.05% (1,000K) Index Sinking Fund Debenture 100% Operating Funds CUSIP: 313586S58 Paine-Webber 8.70% $366,919.06 CITY OF COLLEGE STATION INVESTMENT MATURITY SCHEDULE October 31,1991 MATURITY SETTLEMENT DESCRIPTION BROKER INTEREST RATE AMOUNT DATE 11-15-93 11/15/90 Treasury Note 7-3/4% (1,000K) Shearson -Lehman 100% Bond Funds CUSIP: 912827ZM7 11-15-93 02/07/91 Treasury Note 7-3/4% ($1,000K) Prudential-Bache 100% Operating Funds CUSIP: 912827ZM7 01-10-94 07/03/91 F.N.M.A. NOTE 7.55% ($1,000K) Shearson -Lehman 100% Operating Funds CUSIP: 313586U80 03-01-94 03/01/91 F.F.C.B. Note 7.15% (1,000K) Prudential-Bache 100% Operating Funds CUSIP: 313311 F31 C 04-15-94 03/20/91 REFCORP Strip Coupon (1,000K) First Tennessee 100% Operating Funds CUSIP: 76116EAJ9 12-12-94 05/28/91 FNMA Coupon 8.30% (1,500K) MGSI Cali Date 12/12/91 100% Bond Funds CUSIP: 313586123 7.78% 7.00% 7.40% 7.15% 7.75% 7.60% $999,210.00 $1,018,437.50 $1,003,281.25 $1,000,000.00 $791,726.28 $1,531,875.00 04-05-95 06/14/91 Financing Corporation Bonds (FICO) Vining -Sparks 8.15% $1,622,500.00 100% Bond Funds (2,200K) CUSIP: 31771 DCZ4 09/15/95 01/29/91 F.H.LM.C. 8.25% (1,000K) C.M.O. 2.4 years Cali Date 5/15/93 100% Bond Funds CUSIP: 312904X42 Shearson -Lehman 7.92% $868,174.87 7/1/96 8/22/91 F.H.LM.C. Gold 8% 5 yr. balloon (9751 Vining Sparks 7.56% $109,478.84 100% Bond Fundss CUSIP: 31281XSG8 07-1-96 8/22/91 FHLMC Gold 8% 5 yr. balloon (975K) Vining Sparks 7.56% $109,503.97 100% Bond Funds CUSIP: 31281XPU0 07-01-96 8/22/91 FHLMC Gold 8% 5 yr. balloon (975K) Vining Sparks 100% Bond Funds CUSIP: 31281XRC8 7-1-96 8/22/91 FHLMC Gold 7.5% 5 yr. bailn. (1,000K) M.G.S.I. 100% Bond Funds CUSIP: 31281XW99 10/1/96 10/1/91 Fed. Home Loan Bank (2,000K) M.G.S.I. 100% Bond Funds 7.56% 7.48% Float $767,882.91 $1,002,105.17 $2,000,000.00 CITY OF COLLEGE STATION INVESTMENT MATURITY SCHEDULE October 31,1991 MATURITY SETTLEMENT DESCRIPTION BROKER INTEREST RATE AMOUNT DATE CUSIP: 313388B33060 10-15-96 03/25/91 RECORP Strip Coupon (220K) First Southwest 8.23% $140,525.00 BVSWMA Closure Reserve CUSIP: 76116EAP5 TOTAL $27,659,709.61 COLLATERAL HELD: CITY OF COLLEGE STATION COLLATERAL RECONCILIATION October 31,1991 COLLATERAL BOOK MARKET VALUE BALANCE I. FIRST AMERICAN BANK $1,000,000 $1,015,900.00 S.LM.A. (+accrued interest) 10.50 4/22/93 1.0159 CUSIP 863871AJ8 (10/31/91 WSJ) Plus $100,000 FDIC coverage $542,844.92 COLLATERAL HELD: CITY OF COLLEGE STATION COLLATERAL RECONCILIATION October 31,1991 COLLATERAL BOOK MARKET VALUE BALANCE I. N.C.N.B. TEXAS A&M BRANCH S150,000 $151,635.00 Treasury Notes (+accrued interest) 9-1/8% 2-15-92 1.0109 CUSIP 912827X09 (10/31/91 WSJ) Plus $100,000 FDIC coverage $72,930.39