Loading...
HomeMy WebLinkAbout1991- 2nd Quaterly Financial Report4'0 QUARTERLY FINANCIAL REPORT SIX MONTHS ENDING MARCH, 1991 OF COLLEGE STATION ([CITY / FINANCE DEPARTMENT Post Office Box 9960 1101 Texas Avenue College Station, Texas 77842-0960 (409) 764-3555 MEMORANDUM TO: Ron Ragland, City Manager FROM: Glenn Schroeder, Acting Executive Director Fiscal and Human Re DATE: April 22, 1991 SUBJECT: Quarterly Financial Report The second quarter financial reports for the fiscal year 1991 are attached. This quarterly financial report for the six months ended March 31, 1991 has been prepared on a cash basis. Please note that these are unaudited statements and that entries to post such items as depreciation and expense accruals have not been made. SUMMARY: During the six months covered by this report, October 1, 1990 through March 31, 1991, financial operations of the City of College Station were as anticipated. All departments of the city are operating within budget appropriations and revenues have been generally consistent with projections. Fiscal Year 1991 is the first year of the increase in the local sales tax from one percent to one and one-half percent, with a corresponding decrease in the transfer to the General Fund from the Utilities. This is also the fourth year of a five-year restructuring of utility rates designed to reduce dependence on electric revenues. Financial results indicate that this project is proceeding on schedule. Fiscal Year 1991 is the first full year of operations of the Brazos Valley Solid Waste Management Agency (BVSWMA). Thus comparisons to the previous fiscal year for the Sanitation, Landfill, and BVSWMA funds are somewhat misleading. As of March 31, 1991, the City's investment portfolio consisted of the following: Bank Demand Accounts* $321,161 1.0% TexPool 3,261,124 10.6 Insured Cert. of of Deposit 50,000 0.1 U.S. Government Obligations 16,727,750 54.4 Government Agency Notes* 10,414,549 33.9 TOTAL $30,774,584 100.0% *The Bank Demand Accounts total reflects $367,404.59 (or 1%) in the BVSWMA account. This account will be combined with the Clearing Account during the month of April. The Government Agency Notes total also reflects $220,000 (or 0.7%) in REFCORP Strips for the BVSWMA Landfill Closure Reserve. At the end of the quarter, the weighted average rate of return on the portfolio was 7.83%. Interest rates have been generally. in a downward trend for the past twelve months; current rates on short-term investments are now at their lowest levels in four years. Rate reductions have come as a direct result of Federal Reserve activity to stimulate the economy. To protect the portfolio from declining interest rates, maturities have been extended. Weighted average maturity in the portfolio at March 31, 1991 was 17.1 months, compared to 9.5 months a year ago. Total investment earnings for fiscal year 1991 will depend on interest rates over the balance of the fiscal year; however, earnings should reach the budgeted return of 7.5%. CASH -FLOW ANALYSIS: In cash -basis accounting, revenues are generally recorded in the month earned and expenditures, with the exception of the payroll, generally recorded in the month following the true cost of operations. For that reason, expenditures on a cash basis are always understated. As an example, electric utility revenues show six months of operation, while wholesale power purchased .reflects only five monthly payments. March power consumption will be paid for in April. 0.0 ENERAL FUND: G Sales Tax: Sales tax revenues will fluctuate with new development and with the health of the local economy. This revenue source for the City of College Station is also directly related to the level of enrollment at the University. Sales tax revenues reached $4,184,100 for the calendar year ended December 31, 1990, a 5.4% increase over the previous year (both years calculated at a one percent local rate for comparability). For the second quarter of Fiscal Year 1991, revenues of $1,662,908 put the City on target to slightly exceed the annual budget of $5,800,000 which was based on a 5% growth in addition to the one-half cent rate increase. 96,000,000.00 $5,000,000.00 $4,000,000.00 $3,000,000.00 SALES TAX REVENUE: BUDGET VS. ACTUAL FISCAL YEAR 1991 $0.00 I I I I I I Oct Nov Dee Jan Feb Mar Apr May { Jun Jul Aug Sept Actual El Budget Property Tax: Local property taxes tend to be a reasonably secure source for funding municipal operations and debt service. Property tax collections, on a direct comparison basis, are unchanged from last year. Total current tax collecton is at 89% compared to 88% last year and delinquent tax collections are at 50% compared to 33.5% last year. Total outstanding delinquent tax as of March 31, 1991 is $277,096.15 compared to $359,008.49 last year. HOTEL/MOTEL TAX FUND Revenues from the hotel/motel room tax are very near the amount estimated in the budget. Comparison to last fiscal year's revenues are misleading in that the reporting requirements were changed at the beginning of Fiscal Year 1990 so that two additional months of revenue were reported in that fiscal year compared to this fiscal year. Expenditures are also as projected as the transfer of hotel/motel monies to the Wolfpen Creek Project fund is anticipated to take place in the third quarter. Renovation of the HVAC system in the College Station Conference Center is expected to be done in July when the least number of groups use that facility. UTILITY OPERATING FUNDS: Ongoing monitoring of utility revenues becomes an essential part of the budget process due to the effect of outside influences on revenues. Hot, dry summers and cold winters will tend to increase both water and electric consumption and related revenues, while a cool summer will depress revenues. The graphs of the utility funds included in this report plot actual year-to-date revenues against the historical annual distribution of budgeted revenues. Seasonally moderate temperatures during the fall of 1990 and to date this spring have resulted in lower than projected revenues. Revenues for March are also lower than usual because timing caused only seven of the eight utility cycles to be billed during this month. That resulted in revenues being understated for March (and the corresponding graphs) in the following amounts: electric $287,280.45; water $33,389.72; sewer $31,277.56; and sanitation $17,648.17. We should see actual revenues closer to projections as the year progresses. As noted above, the large excess of revenues over expenditures in the electric utility fund is not an accurate representation. In the revenue/expenditure analysis for this utility, all items are on a cash basis except for the proration of annual debt service; the imbalance is caused by the difference between electric sales and wholesale power purchases. SANITATION/LANDFILLBVSWMA FUNDS: The past year has seen many changes in the City's solid waste management system. The cities of College Station and Bryan joined together to form the Brazos Valley Solid Waste Mangement Agency (BVSWMA). That agency was in operation for the last five months of fiscal year 1990. College Station serves as the landfill operator under contract with BVSWMA and is paid by BVSWMA, but solid waste collection expenditures reflect the payment of tipping fees to BVSWMA. The projected $1.5 million for capital outlay items in the landfill has not been received, therefore resulting in a difference in revenues and expenditures for BVSWMA. CONTINGENCY FUNDS: Each year the City budgets funds to cover unexpected costs which arise during the course of the year. An additional major use of contingency funds is to budget for the expenditure of funds received during the year but not reflected in the original budget. City charter does not provide for amending the budget to include these expenditures, even when revenues are available. Year-to-date contingency reports have been included at the back of this report for purposes of full disclosure. cc: Mayor and City Council Executive Staff REVENUES: Sales Tax (1) Property Tax (2) Court Revenues Parks & Recreation Trf. In -lieu -of taxes Transfer - Admin. Miscellaneous TOTAL REVENUES EXPENDITURES: Police Fire Public Services Culture & Recreation Development Services Administration (3) Fiscal & Human Res. Management Services TOTAL EXPENDITURES Unexpended Appropriations REVENUES IN EXCESS OF EXPENDITURES (DEFICIT) GENERAL FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1990 & 1991 (50% OF FISCAL YEAR) ACTUAL 1990 (6 MONTHS) $2,140,500 1,470,900 277,600 80,300 2,350,700 1,148,600 425,500 7,894,100 ACTUAL 1991 (6 MONTHS) $2,892,410 1,220,531 222,443 76,126 1,886,030 944,352 674,447 PERCENTAGE INCREASE (DECREASE) 35.13 (17.02) (19.87) (5.20) (19.77) (17.78) 58.51 1991 ANNUAL BUDGET % 5,800,000 1,465,800 575,000 351,300 3,772,000 2,490,800 1,138,100 7,916,339 0.28 15,593,000 1,601,900 1,762,883 1,319,300 1,417,999 658,200 751,828 956,800 1,073,939 562,400 591,414 441,800 463,393 636,700 665,116 459,800 . 664,769 6,636,900 7,391,341 $1,257,200 $524,998 PERCENT OF ANNUAL BUDGET 49.87 83.27 38.69 21.67 50.00 37.91 59.26 50.77 10.05 % 3,770,600 46.75 7.48 2,967,400 47.79 14.22 2,155,100 34.89 12.24 2,441,800 43.98 5.16 1,234,500 47.91 4.89 1,128,300 41.07 4.46 1,429,600 46.52 44.58 1,349,100 49.27 11.37 16,476,400 44.86 ($728,800) $154,600 (1) Local sales tax Increased from 1% to 1-1/2%, effective with December 1990 payments. (2) General fund property tax declined from 161 per $100 in 1990 to 13.251 per $100 In 1991. (3) Includes non -departmental and contingency funds. 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 REVENUES IN EXCESS OF EXPENDITURES (DEFICIT) HOTEL/MOTEL TAX FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1990 & 1991 (50% OF FISCAL YEAR) ACTUAL 1990 (6 MONTHS) $484,700 26,800 8,900 520,400 78,400 38,200 150,000 75,000 12,000 7,800 100,000 461,400 $59,000 ACTUAL 1991 (6 MONTHS) $441,364 25,926 13,996 481,286 89,318 38,000 162,500 51,600 18,000 16,700 376,118 $105,168 PERCENTAGE INCREASE (DECREASE) 1991 ANNUAL BUDGET (8.94) % (3.26) 57.26 $780,000 47,000 17,000 (7.52) 844,000 13.93 (0.52) 8.33 (31.20) 50.00 114.10 178,600 75,900 325,000 103,200 18,000 60,500 77,700 25,000 100,000 (18.48) 963,900 ($119,900) PERCENT OF ANNUAL BUDGET 56.59 % 55.16 82.33 57.02 50.01 50.07 50.00 50.00 100.00 27.60 39.02 REVENUES: DEBT SERVICE FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1990 & 1991 (50% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1991 PERCENT 1990 1991 INCREASE ANNUAL OF ANNUAL (6 MONTHS) (6 MONTHS) (DECREASE) BUDGET BUDGET Property Tax (1) $2,538,300 $2,820,185 11.11 % $2,954,300 95.46 Transfer from other funds 397,400 323,403 (18.62) 646,800 50.00 Investment Earnings 77,200 73,245 (5.12) 146,000 50.17 TOTAL REVENUES 3,012,900 3,216,833 6.77 3,747,100 85.85 EXPENDITURES: General Obligation Bonds: Principal 2,140,000 2,420,000 13.08 2,465,000 98.17 Interest 786,000 823,575 4.78 1,781,600 46.23 Certificate of Obligation: Principal 142,900 Interest 84,600 Miscellaneous 5,300 5,587 5.42 15,000 TOTAL EXPENDITURES 37.25 2,931,300 3,249,162 10.84 4,489,100 72.38 REVENUES IN EXCESS OF EXPENDITURES(DEFICIT) $81,600 ($32,329) ($742,000) (1) Debt service property tax increased from 244 per $100 valuation In 1990 to 26.754 per $100 In 1991, offset by decrease in General Fund Property Tax. REVENUES: ELECTRIC FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1990 & 1991 (50% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1991 PERCENT 1990 1991 INCREASE ANNUAL OF ANNUAL (6 MONTHS) (6 MONTHS) (DECREASE) BUDGET BUDGET Sale of Electricity (1) $12,765,799 $12,214,771 (4.32) % $28,344,000 43.09 % Investment Earnings 215,483 356,283 65.34 696,000 51.19 Miscellaneous 244,006 251,156 2.93 418,700 59.98 TOTAL REVENUES 13,225,288 12,822,210 (3.05) 29,458,700 43.53 EXPENDITURES: Wholesale Power (2) 6,962,000 7,384,006 6.06 19,732,300 37.42 Electric Operations 120,756 90,895 (24.73) 262,400 34.64 Transmission & Distribution 751,754 935,233 24.41 2,492,200 37.53 Reimbursed Admin. & Transfer in -lieu of Taxes 1,986,563 1,663,359 (16.27) 3,318,100 50.13 Development Foundation 29,167 - 50,000 - Debt Service (Budget Proration) 477,083 475,900 (0.25) 951,800 50.00 Utility Billing 279,729 331,971 18.68 663,900 50.00 Capital Outlay 43,744 134,248 206.89 214,100 62.70 TOTAL EXPENDITURES 10,650,796 11,015,612 3.43 27,684,800 39.79 REVENUES IN EXCESS OF EXPENDITURES (DEFICIT) $2,574,492 $1,806,598 $1,773,900 (1) Electric rates reduces by 4.65% In 1991, reflecting at reduction In General Fund Transfer and offset to water rate increase. Six months electric sales. (2) Five months wholesale power purchases. ELECTRIC REVENUE BUDGET VS ACTUAL 30,000,000 25, 000, 000 20,000,000 15,000,000 10,000,000 5,000,000 0 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ❑ BUDGET ACTUAL - BUDGET/ 12 REVENUES: WATER FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1990 & 1991 (50% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1991 PERCENT 1990 1991 INCREASE ANNUAL OF ANNUAL (6 MONTHS) (6 MONTHS) (DECREASE) BUDGET BUDGET Water Sales $2,126,393 $2,236,947 5.20 % $4,995,000 44.78 % Investment Earnings 10,252 (11,793) (215.03) 41,000 Miscellaneous 21,865 47,068 115.27 103,300 45.56 TOTAL REVENUES 2,158,510 2,272,222 5.27 5,139,300 44.21 EXPENDITURES: Water Production & Distribution 1,000,600 1,073,022 7.24 2,478,700 43.29 Reimbursed Admin.& Transfer in -lieu of Taxes 566,325 400,548 (29.27) 801,100 50.00 Debt Service (Budget Proration) 932,810 890,000 (4.59) 1,780,000 50.00 Utility Billing 135,353 160,632 18.68 321,300 49.99 Capital Outlay 12,500 40,898 227.18 100,700 40.61 TOTAL EXPENDITURES 2,647,588 2,565,100 (3.12) 5,481,800 46.79 REVENUES IN EXCESS OF EXPENDITURES (DEFICIT) ($489,078) ($292,878) ($342,500) (1) Water rates increased by 10% in 1991, the fourth year of 5-year scheduled Increases to cost of service. 5,000,000 - 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 - 0 WATER REVENUE BUDGET VS ACTUAL OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ❑ BUDGET ACTUAL - BUDGET / 12 REVENUES: SEWER FUND REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1990 & 1991 (50% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1991 PERCENT 1990 1991 INCREASE ANNUAL OF ANNUAL (6 MONTHS) (6 MONTHS) (DECREASE) BUDGET BUDGET Sewer Service Revenue (1) $1,861,576 $1,864,274 0.14 % $3,793,300 49.15 % Investment Earnings 16,572 25,321 52.79 60,000 42.20 Miscellaneous 749 38,344 5019.36 83,800 45.76 TOTAL REVENUES 1,878,897 1,927,939 2.61 3,937,100 48.97 EXPENDITURES: Sewer Collection & Treatment 594,600 720,699 21.21 1,930,300 37.34 Reimbursed Admin. & Trf. in -lieu of Taxes 378,931 298,027 (21.35) 596,100 50.00 Debt Service (Budget Proration) 630,619 674,700 6.99 1,349,400 50.00 Utility Billing 225,559 26,772 (88.13) 53,500 50.04 Capital Outlay 978 42,389 4234.25 77,000 55.05 TOTAL EXPENDITURES 1,830,687 1,762,587 (3.72) 4,006,300 44.00 REVENUES IN EXCESS OF EXPENDITURES (DEFICIT) $48,210 $165,352 ($69,200) (1) No changes to rate structure In 1991. �9 SEWER REVENUE BUDGET VS ACTUAL 4,000,000 - 3,500,000 - 3,000,000 2,500,000 - 2,000,000 - 1,500,000 - 1,000,000 - 500,000 - 0 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ❑ BUDGET E ACTUAL BUDGET/12 REVENUES: SANITATION & LANDFILL FUNDS REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1990 & 1991 (50% OF FISCAL YEAR) ACTUAL ACTUAL PERCENTAGE 1991 PERCENT 1990 1991 INCREASE ANNUAL OF ANNUAL (6 MONTHS) (6 MONTHS) (DECREASE) BUDGET BUDGET Collection $891,975 $893,018 0.12 % $1,885,000 47.37 % Landfill -City Owned 64,911 - Landfill Operator Fees - 275,736 - 580,300 47.52 Miscellaneous 7,762 78,043 905.45 170,100 45.88 TOTAL REVENUES 964,648 1,246,797 29.25 2,635,400 47.31 EXPENDITURES: Collection 317,400 713,669 124.85 1,619,400 32.90 Landfill -City Owned 109,700 - Landfiil Operator Expenses - 249,286 450,600 42.30 Capital Outlay 185,300 27,538 (85.14) 109,200 24.20 Administrative Transfer & Trf. In -lieu -of Taxes 306,800 259,117 (15.54) 518,200 41.70 Contribution -Brazos Beautiful 9,000 9,000 9,000 100.00 Contingency 535 30,000 TOTAL EXPENDITURES 928,735 1,258,610 35.52 2,736,400 35.70 Unexpended Appropriations (89,500) REVENUES IN EXCESS OF EXPENDITURES (DEFICIT) $35,913 ($11,813) ($11,500) NOTE: BVSWMA started operations In May, 1990. City of College Station pays $15/ton tipping fee at landfill. City of College Station serves as landfill operator and is reimbursed for expenses. 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 SANITATION REVENUE BUDGET VS ACTUAL OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ❑ BUDGET ACTUAL - BUDGET/ 12 BRAZOS VALLEY SOLID WASTE MANAGEMENT AGENCY REVENUE/EXPENDITURE ANALYSIS (CASH BASIS) FISCAL YEARS 1990 & 1991 (50% OF FISCAL YEAR) REVENUES: ACTUAL ACTUAL PERCENTAGE 1991 PERCENT 1990 1991 INCREASE ANNUAL OF ANNUAL (6 MONTHS) (6 MONTHS) (DECREASE) BUDGET BUDGET Landfill Charges $876,029 $1,710,000 51.23 Sale of Equipment 42,900 Miscellaneous 13,384 Debt Issue 800,000 City of Bryan 750,000 TOTAL REVENUES 932,313 3,260,000 28.60 EXPENDITURES: Landfill Operator 375,462 580,300 64.70 State Disposal Fees - 15,000 57,500 26.09 Reserves (Budget Proration) 250,000 500,000 50.00 Consultant Contracts - 5,000 100,000 5.00 Equipment Purchases - 805,000 Capital Constr. & Land 218,783 656,800 33.31 Debt Service - Notes - 93,400 186,800 50.00. Miscellaneous - 71,347 208,900 34.15 TOTAL EXPENDITURES - 1,028,992 3,095,300 33.24 REVENUES IN EXCESS OF EXPENDITURES (DEFICIT) - ($96,679) $164,700 Note: BVSWMA commenced operations in May, 1990. COLLATERAL HELD: CITY OF COLLEGE STATION COLLATERAL RECONCILIATION March 29, 1991 COLLATERAL BOOK MARKET VALUE BALANCE I. N.C.N.B. TEXAS A&M BRANCH $1,000,000 $1,021,875.00 Treasury Notes (+accrued Interest) 9-1/8% 2-15-92 1.021875 CUSIP 912827XD9 (03/29/91 WSJ) $312,161.25 CITY OF COLLEGE STATION INVESTMENT MATURITY SCHEDULE March 29, 1991 MATURITY SETTLEMENT DESCRIPTION DATE Daily Daily Daily Daily Daily 05-16-91 12/19/90 07-31-91 01/26/90 08-15-91 02/01/90 01-15-92 08/17/90 01-31-92 02/08/90 Clearing Account BVSWMA Agency Fund TexPool Fund -1st City TexPool Fund -NCNB A&M F.N.M.A. Disc. Note (1,100K) 100% Bond Funds CUSIP: 313588FR1 Treasury Note 7-3/4% (1,000K) 100% Operating Funds Treasury Note 8-3/4% (1,000K) 100% Operating Funds BROKER N.C.N.B.-A&M N.C.N.B.-A&M INTEREST RATE AMOUNT 1st City Nat'l Bank -Houston TexPool TexPool First Tennessee Prudential—Bache Union Planters REFCORP Strip Coupon (1,500K) Union Planters 100% Bond Funds CUSIP: 76116EDM9 Treasury Note 8-1/8% (1,000K) 100% Operating Funds 05-31-92 09/25/90 Treasury Note 8-1/216 (2,000K) 50% Operating Funds 50% Bond Funds CUSIP: 912827YX4 06-10-92 10/01/90 08-10-92 12/11/90 08-15-92 12/11 /90 08-15-92 02/05/90 09-18-92 01/09/91 F.N.M.A. 10-1/8% (1,740K) 100% Operating Funds CUSIP: 313586SW0 F.N.M.A. Notes 7-3/4% (1,000K) 100% Bond Funds CUSIP: 313586G94 Treasury Notes 7-7/8% (1,00019 100% Bond Funds CUSIP: 912827XV9 Treasury Notes 7-7/8% (2,000K) 100% Bond Funds S.LM.A. Notes 8.15% (1,000K) 100% Bond Funds CUSIP: 863871 GR4 First -Southwest Prudential-Bache First Southwest Shearson -Lehman Prudential -Bache Prudential-Bache First Tennessee ($87,245.96) $367,404.59 $32,002.62 $3,069,181.56 6.4605% $191,942.01 7.20% $1,068,796.67 8.29% 8.28% 8.22% 8.34% 8.11% 8.06% 7.41% 7.35% 8.39% 7.25% $992,500.00 $1,006,562.50 $1,463,233.39 $996,015.63 $2,011,562.50 $1,795,462.50 $1,005,156.25 $1,007,968.75 $1,976,718.75 S1,013,906.25 CITY OF COLLEGE STATION INVESTMENT MATURITY SCHEDULE March 29, 1991 MATURITY SETTLEMENT DESCRIPTION DATE 09-30-92 01/10/91 11-02-92 11/02/90 01-15-93 02/05/90 02-15-93 08/31/90 05-15-93 01/29/91 05-15-93 02/13/91 09-13-93 09/13/90 10-12-93 08/01/90 Treasury Notes 8-1/8% (3,075K) 100% Bond Funds CUSIP: 912827ZH8 Cert. of Deposit -1st City 100% Cemetery Fund Treasury Note 8-3/4% (1,000K) 100% Bonds Funds Treasury Note 8-1/4% (1,600K) 100% Operating Funds CUSIP: 912827VO2 F.H.LM.C. 8.25% (1,000K) C.M.O. 2.4 years Final 9/15/95 100% Bond Funds CUSIP: 312904X42 Treasury Strips ($1,000K) 100% Operating Funds CUSIP: 912833EW6 S.LM.A. Notes 8.65% (500K) Call Date 09/13/91 100% Operating Funds CUSIP: 863871 GP8 F.N.M.A. NOTE 9.05% (1,000K) Index Sinking Fund Debenture 100% Operating Funds CUSIP: 313586558 11-15-93 11/15/90 Treasury Note 7-3/4% (1,000K) 104% Bond Funds CUSIP: 912827ZM7 11-15-93 02/07/91 Treasury Note 7-3/4% ($1,000K) 100% Operating Funds CUSIP: 912827ZM7 BROKER Prudential-Bache 1st City Nat'l Bank Houston Prudential-Bache Prudential-Bache Shearson -Lehman Prudential-Bache Union Planters Paine-Webber Shearson -Lehman Prudential-Bache INTEREST RATE AMOUNT 7.08% 7.90% 8.39% 8.21% 7.92% 6.95% 8.65% 8.70% 7.78% 7.00% $3,125,929.69 $69,324.78 $50,000.00 $1,009,218.75 $1,601,500.00 $976,591.30 $894,817.47 $500,000.00 $626,539.06 $999,210.00 $1,018,437.50 $17,983.43 CITY OF COLLEGE STATION INVESTMENT MATURITY SCHEDULE March 29, 1991 MATURITY SETTLEMENT DESCRIPTION BROKER INTEREST RATE AMOUNT DATE 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% $824,338.90 100% Operating Funds CUSIP: 76116EAJ9 10-15-96 03/25/91 RECORP Strip Coupon (220K) First Southwest 8.23% $140,525.00 BVSWMA Closure Reserve CUSIP: 76116EAP5 TOTAL $30,765,583.89 3ENERAL FUND CONTINGENCY STATEMENT FOR MONTH ENDING MARCH 31, 1991 :ISCAL YEAR - 1990-91 DATE DESCRIPTION CONTINGENCY RESERVED FOR TOTAL AMOUNT OF AVAILABLE FOR RESERVED FOR SALARY CONTINGENCY DIVISION TRANSFER OTHER USES FUEL COSTS ADJUSTMENTS BALANCE Dct-90 BEGINNING BALANCE 85,000 Oct-90 TILLER PURCHASE 5383 3,500 81,500 OVERHEAD PROJECTOR 1001 783 80,717 WOLF PEN CREEK CONCERT 5381 570 80,147 5383 353 79,794 6016 1,262 78,532 25,000 55,000 165,000 POSITION RECLASSIFICATION 6016 972 54,028 PRINTING ASSISTANT POSITION RECLASSIFICATION 3028 2,101 51,927 DEPUTY FINANCE DIRECTOR POSITION RECLASSIFICATION 4145 1,060 50,867 RECORDS SUPERVISOR Oct-90 ENDING BALANCE 78,532 25,000 50,867 154,399 Nov-90 POSITION RECLASSIFICATION 4141 5,808 45,059 POLICE SERGEANTS 4142 591 44,468 4143 591 43,877 LEGAL SERVICES 1013 COLLEGE STATION SIGN BEDS 5384 FLOAT EXPENSES 6016 POLICE ACCREDITATION 4140 TUITION REIMBURSEMENT 3020 2,500 650 208 6,000 115 76,032 75,382 75,174 69,174 69,059 Nov-90 ENDING BALANCE 69,059 25,000 Dec-90 PUBLIC EXECUTIVE INSTITUTE 1011 750 68,309 43,877 137,936 Dec-90 ENDING BALANCE 68,309 25,000 43,877 137,186 Jan-91 POSITION RECLASSIFICATION 3044 3,504 40,373 MUNICIPAL COURT CLERKS TUITION REIMBURSEMENT 4410 181 68,128 RIOT EQUIPMENT PURCHASE 4141 7,382 60,746 Page 1 GENERAL FUND CONTINGENCY STATEMENT FOR MONTH ENDING MARCH 31, 1991 FISCAL YEAR - 1990-91 DATE DESCRIPTION CONTINGENCY RESERVED FOR TOTAL AMOUNT OF AVAILABLE FOR RESERVED FOR SALARY CONTINGENCY DIVISION TRANSFER OTHER USES FUEL COSTS ADJUSTMENTS BALANCE TUITION REIMBURSEMENT 4410 120 60,626 Jan-91 ENDING BALANCE 60,626 Feb-91 CHRISTMAS DECORATIONS 1011 300 60,326 TUITION REIMBURSEMENT 3044 115 60,211 NIXDORF MAINTENANCE 4145 11,700 44,536. 3044 3,975 9600 BAUD MODEM 3021 945 43,591 EXTENDED LIBRARY HOURS 6018 4,267 39,324 TUITION REIMBURSEMENT NON•DEPT 1,500 37,824 ACCOUNT SETUP 25,000 40,373 125,999 Feb-91 ENDING BALANCE 37,824 Mar-91 HUMAN/RESOURCES COMPUTER 3012 1,900 35,924 UPGRADE MIS PHONE SYSTEM 6026 7,298 28,626 NATIONAL JUDICIAL COLLEGE CO 3044 1,800 26,826 25,000 40,373 103,197 Mar-91 ENDING BALANCE 26,826 25,000 40,373 92,199 Page 2 ELECTRIC FUND CONTINGENCY STATEMENT FOR MONTH ENDING MARCH 31, 1991 'ISCAL YEAR - 1990-91 )ATE DESCRIPTION CONTINGENCY RESERVED FOR TOTAL AMOUNT OF AVAILABLE FOR RESERVED FOR SALARY CONTINGENCY DIVISION TRANSFER OTHER USES FUEL COSTS ADJUSTMENTS BALANCE )ct-90 BEGINNING BALANCE 31,600 8,400 20,000 60,000 )ct-90 ENDING BALANCE 31,600 8,400 20,000 60,000 4ov-90 ENDING BALANCE 31,600 8,400 20,000 60,000 )ec-90 ENDING BALANCE 31,600 8,400 20,000 60,000 lan-91 ENDING BALANCE 31,600 8,400 'eb-91 TUITION REIMBURSEMENT NON-DEPT 500 31,100 ACCOUNT SETUP 20,000 60,000 :eb-91 ENDING BALANCE 31,100 8,400 20,000 59,500 Aar-91 ENDING BALANCE 31,100 8,400 20,000 59,500 Page 1 NATER FUND CONTINGENCY STATEMENT FOR MONTH ENDING MARCH 31, 1991 :ISCAL YEAR - 1990-91 )ATE DESCRIPTION CONTINGENCY RESERVED FOR TOTAL AMOUNT OF AVAILABLE FOR RESERVED FOR SALARY CONTINGENCY DIVISION TRANSFER OTHER USES FUEL COSTS ADJUSTMENTS BALANCE Dct-90 BEGINNING BALANCE 36,250 3,750 20,000 60,000 Dct-90 ENDING BALANCE 36,250 3,750 20,000 60,000 Vov-90 TUITION REIMBURSEMENT 5194 175 '36,075 Vov-90 ENDING BALANCE 36,075 3,750 20,000 59,825 Dec-90 ENDING BALANCE 36,075 3,750 20,000 59,825 Jan-91 ENDING BALANCE 36,075 3,750 =eb-91 TUITION REIMBURSEMENT NON-DEPT 500 35,575 ACCOUNT SETUP 20,000 59,825 =eb-91 ENDING BALANCE 35,575 3,750 20,000 59,325 Aar-91 ENDING BALANCE 35,575 3,750 20,000 59,325 Page 1 SEWER FUND CONTINGENCY STATEMENT FOR MONTH ENDING MARCH 31, 1991 FISCAL YEAR - 1990-91 DATE DESCRIPTION CONTINGENCY RESERVED FOR TOTAL AMOUNT OF AVAILABLE FOR RESERVED FOR SALARY CONTINGENCY DIVISION TRANSFER OTHER USES FUEL COSTS ADJUSTMENTS BALANCE Oct-90 BEGINNING BALANCE 33,000 7,000 20,000 60,000 Oct-90 ENDING BALANCE 33,000 7,000 20,000 60,000 Nov-90 ENDING BALANCE 33,000 7,000 20,000 60,000 Dec-90 ENDING BALANCE 33,000 7,000 20,000 60,000 Jan-91 ENDING BALANCE 33,000 7,000 Feb-91 TUITION REIMBURSEMENT NON•DEPT 500 32,500 ACCOUNT SETUP DISPOSAL LEASE 5195 5,000 27,500 20,000 60,000 POSITION RECLASSIFICATION 5196 9,607 10,393 FACIUTY MAINTENANCE SUPERVISOR Feb-91 ENDING BALANCE 27,500 7,000 10,393 44,893 Mar-91 ENDING BALANCE 27,500 7,000 10,393 44,893 Page 1 JTILITY BILLING FUND CONTINGENCY STATEMENT FOR MONTH ENDING MARCH 31, 1991 ,ISCAL YEAR - 1990-91 )ATE DESCRIPTION CONTINGENCY RESERVED FOR TOTAL AMOUNT OF AVAILABLE FOR RESERVED FOR SALARY CONTINGENCY DIVISION TRANSFER OTHER USES FUEL COSTS ADJUSTMENTS BALANCE )ct-90 BEGINNING BALANCE )ct-90 ENDORSER PURCHASE DESK CHAIR REPLACEMENT ADDS TERMINALS 6023 6023 6023 12,500 2,785 9,715 1,000 8,715 3,000 5,715 1,000 6,500 20,000 )ct-90 ENDING BALANCE 5,715 1,000 6,500 13,215 lov-90 ENDING BALANCE 5,715 1,000 6,500 13,215 1ec-90 ENDING BALANCE 5,715 1,000 6,500 13,215 an-91 ENDING BALANCE 5,715 1,000 6,500 13,215 "eb-91 TUITION REIMBURSEMENT NON•DEPT 500 5,215 ACCOUNT SETUP 'eb-91 ENDING BALANCE 5,215 1,000 6,500 12,715 lar-91 ENDING BALANCE 5,215 1,000 6,500 12,715 Page 1 SOLID WASTE COLLECTION FUND CONTINGENCY STATEMENT FOR MONTH ENDING MARCH 31, 1991 FISCAL YEAR - 1990-91 DATE DESCRIPTION CONTINGENCY RESERVED FOR TOTAL AMOUNT OF AVAILABLE FOR RESERVED FOR SALARY CONTINGENCY DIVISION TRANSFER OTHER USES FUEL COSTS ADJUSTMENTS BALANCE Oct-90 BEGINNING BALANCE O 10,000 5,000 15,000 Oot-90 ENDING BALANCE 0 10,000 5,000 15,000 Nov-90 ENDING BALANCE O 10,000 5,000 15,000 Dec-90 ENDING BALANCE O 10,000 5,000 15,000 Jan-91 ENDING BALANCE O 10,000 5,000 15,000 Feb-91 ENDING BALANCE O 10,000 5,000 15,000 Mar-91 ENDING BALANCE 0 10,000 5,000 15,000 Page 1 ANDFILL OPERATION FUND CONTINGENCY STATEMENT FOR MONTH ENDING MARCH 31, 1991 'ISCAL YEAR - 1990-91 )ATE DESCRIPTION CONTINGENCY RESERVED FOR TOTAL AMOUNT OF AVAILABLE FOR RESERVED FOR SALARY CONTINGENCY DIVISION TRANSFER OTHER USES FUEL COSTS ADJUSTMENTS BALANCE )ct-90 BEGINNING BALANCE O 10,000 5,000 15,000 )ct-90 ENDING BALANCE O 10,000 5,000 15,000 Jov-90 ENDING BALANCE O 10,000 5,000 15,000 )ec-90 ENDING BALANCE O 10,000 5,000 15,000 Ian-91 ENDING BALANCE 0 10,000 5,000 15,000 ,eb-91 ENDING BALANCE O 10,000 5,000 15,000 Aar-91 ENDING BALANCE 0 10,000 5,000 15,000 Page 1 ;APITAL EQUIPMENT FUND CONTINGENCY STATEMENT FOR MONTH ENDING MARCH 31, 1991 ISCAL YEAR - 1990-91 )ATE DESCRIPTION CONTINGENCY TOTAL AMOUNT OF AVAILABLE FOR CONTINGENCY DIVISION TRANSFER OTHER USES BALANCE )ct-90 BEGINNING BALANCE 45,000 45,000 )ct-90 ENDING BALANCE 45,000 45,000 lov-90 MEMORY EXPANSION NON-DEPT 28,750 16,250 lov-90 ENDING BALANCE 16,250 16,250 lec-90 ENDING BALANCE 16,250 16,250 an-91 SOFTWARE TRAINING NON-DEPT 2,182 14,068 an-91 ENDING BALANCE 14,068 14,068 'eb-91 ENDING BALANCE 14,068 14,068 Aar-91 FLEET MGMT TRAINING NON -DEFT 5,000 9,068 Aar-91 ENDING BALANCE 9,068 9,068 Page 1 IOTEL/MOTEL FUND CONTINGENCY STATEMENT FOR MONTH ENDING MARCH 31, 1991 SCAL YEAR - 1990-91 ATE DESCRIPTION CONTINGENCY TOTAL AMOUNT OF AVAILABLE FOR CONTINGENCY DIVISION TRANSFER OTHER USES BALANCE ct-90 BEGINNING BALANCE 25,000 25,000 ct-90 ENDING BALANCE 25,000 25,000 ov-90 ENDING BALANCE 25,000 25,000 ec-90 HISTORICAL PLAQUES NON-DEPT 3,525 21,475 ea-90 ENDING BALANCE 21,475 21,475 to-91 ENDING BALANCE 21,475 21,475 3b-91 ENDING BALANCE 21,475 21,475 ar-91 ENDING BALANCE 21,475 21,475 Page 1