Loading...
01-21-1997 - Statement of Treasurer's Accountability - 11/30/96CITY OF WEST COVINA STATEMENT OF TREASURER'S ACCOUNTABILITY NOVEMBER 30,1996 TYPES OF DEPOSITS: OCTOBER 31 DEPOSITS WITHDRAWALS NOVEMBER 30 CHECKING ACCOUNTS AGENDA ITEM ISO - DATE! JanuarX 21, 1997 WELLS FARGO GENERAL CHECKING $ WELLS FARGO GENERAL AUTO & LIABILITY 595,411.02- $ 4,445,588.26 $ 4,953,654.06 $ 87,345.22 % OF PORTFOLIO WELLS FARGO WORKERS' COMPENSATION 14,946.28 3,252.57 11,693.71 WELLS FARGO PAYROLL 9,826,50 79,785.65 76,685.72 11,693.71 43 WELLS FARGO CDBG DEFERRED LOAN PROGRAM 25,022.56 1,868,811.92 25,02 811.92 1,855,856.64 5,85 37,977.84 WELLS_FARGO_BAIUFINE— .58 .64 78 977.83 24.5.00 500.00 500.00' 245.00 SUB -TOTAL ; 730,982.94 ; 6,394,814.08 ; 6,897,219.99 $ 228,577.03 0.37% OTHER INVESTMENTS FEDERAL HOME LOAN BANK (FHLB) 14,000,000.00 FEDERAL FARM CREDIT BANK (FFCB) 2,444,688.24 14,000,000.00 " 22.76% FEDERAL NATIONAL MORTGAGE ASSOCIATION (FNMA) 18,804,926.56 FEDERAL HOME LOAN MORTGAGE CORPORATION (FHLMC) 15,720,053.75 8,804,926.56 18,804,926.56 30.57% 0.57 STATE & LOCAL GOVERNMENT CERT. OF INDEBTEDNESS (SLG) 151,000.00 15,720,053.75 26.65% CORPORATE MEDIUM TERM NOTES (MTN) 5,984,280.00 151,000.00 0.25% LOCAL AGENCY INVESTMENT FUND -CITY LAIF ( ) LOCAL AGENCY INVESTMENT FUND-W.C.P.F.A. (LAIF) 4,,987,981.47 600,000.00 1,550,000.00 5,984,280.00 4,037,981.47 9.73% 6.56% LOS ANGELES COUNTY POOL (LACIP) 107,028.01 37,441.08 107,028.01 0.17% 247.21 37,688.29 0.06% SUB -TOTAL ; 62,237,399.11 $ . 600,247.21 $ 1,550,000.00 .$ 61,287,646.32 100.00% TOTAL $ - 62,968,382.05 $ 6,995,061.29 $ 8,447,219.99 $ 61,516,223.35 It has been verified that this investment portfolio is in with the City of West Covina's investment po lic y.which was approved by City Council The investment December on 16, 1995. portfolio provides sufficient cash flow liquidity to most estimated expenditures for the next six months. This report i acc rate with respect to all information received as of January 6, 1997. EARNED INTEREST YIELD THIS PERIOD: 6.184% ONTH TREAS BILL YIELD: 5.220% REVIEWED BY: PREPA D By Abraham Wodlfbinlarsky, Finance D r Panas, Controller11 Mari n V Treasurer Page 1 TRESRPT.XLS City of West Covina Portfolio Details November 30, 1996 5378 FHLB U.S. GOVERNMENT AGENCY 04/11/94 04/11/97 313390AZ9 5.3130 5.3130 1,000,000.00 .,vvv,vvv. vv 1,000,000.00 ,--.w 998,125.00 IJ,JJJ.VV 33.234.17 5106 FHLB U.S. GOVERNMENT AGENCY 07/16/93 07/16/97 313389PP7 5.2500 5.2500 1,000,000.00 1,000,000.00_ 986,875.00 45,937.50 2863.. - SLGS U.S. GOVERNMENT AGENCY 10/24/84 08/01/97 11.1569 11.1569 151,000.00 151,000.00 151,000.00 5,585.12 5154 FNMA U.S. GOVERNMENT AGENCY 08/31/93 02/17/98 31364AWU2 5.50W 4.8007• 1,010,000.00 1,000,000.00 1,006,562.50 2,138.89 4987 FNMA U.S. GOVERNMENT AGENCY 03/23/93 03/11/98 3135866C8 5.3000 5.4520 2,980,312.50 3,000,000.00 2,982,187.50 35,333.33 .5155 FNMA U.S. GOVERNMENT AGENCY 08/03/93 05/13/98 3135867U7 5.2500 5.2930 998,125.00 1,000,000.00 992,500.00 2,625.00 5095 MTN WACHOVIA BANK 06/02/93 05/15/98 929764CG2 5.5000 5.6400 993,990.00 ' 1,000.000.00 995,312.50 2,444.44 5097 MTN SO CAL EDISON CO. 06/17/93 06/15/98 84240ODD2 5.4500 5.5300 996,540.00 1,000.000.00 992,656.25 25,130.56 5105 MTN WISCONSIN PUBLIC SERVICE CORP. 07/15/93 07/01/98 976843AW2 5.2500 5.3170 997,090.00 1,000,000.00 990,937.50 48,125.00 5361 MTN SHEARSON LEHMAN 07/06/93 07/06/98 82087KRSO 6.0200 6.0470 998,850.00 1,000,000.00 993,906.25 17,725.56 5107 FNMA U.S. GOVERNMENT AGENCY 07/22/93 07/22/98 3135867Y9 5.1000 5.1110 999,531.05 1,000,000.00 - 991,250.00 43,775.00 5153 FHLB U.S. GOVERNMENT AGENCY 08/03/93 08/03/98 313389RM2 5.3700 5.3700 1,500,000.00 1,500,000.00 1,492,500.00 26,402.50 5186 FHLB U.S. GOVERNMENT AGENCY 09/01/93 08/24/98 313389SY5 4.6500 4.6500 1,000,000.00 1,000,000.00 985,937.50 904.17 5412 FNMA U.S. GOVERNMENT AGENCY 01/05/96 09/23/98 31364BLC2 6.2400 6.0709 1,004,062.50 1,000,000.00 1,000,937.50 11,786.67 5187 FNMA U.S. GOVERNMENT AGENCY 09/28/93 09/28/98 31364AE65 4.9200 4.9030 1.000,625.00 1,000,000.00 987,187.50 8,610.00 5213 MTN NEW ENGLAND TELEPHONE CO. 10/05/93 10/01/98 644239BG9 5.0500 5.1000 997,810.00 1,000,000.00 982,500.00 33,666.67 5212 MTN ASSOC. CORP. OF NORTH AMERICA ' 10/29/93 10/29/98 04590321-4 5.2300 5.2300 1,0W,000.00 1,000,000.00 989,062.50 4,358.29 5241 FHLB U.S. GOVERNMENT AGENCY 11/18/93 11/18/98 313389C89 5.3000 5.3000 1,500,000.00 1,500,000.00 1.487,812.50 2,870.83 5418 FNMA U.S. GOVERNMENT AGENCY 03/20/96 11/26/98 31364AJ29 5.2300 6.1040 489,296.88 500,000.00 495,781.25 435.83 5274 FHLB U.S. GOVERNMENT AGENCY 12/10/93 12/10/98 313389E95 2.4950 2.4950 2,000,000.00 2,000,000.00 1,902,500.00 23,702.50 5275 FHLB U.S. GOVERNMENT AGENCY 12/29/93 12/29/98 3133891<98 5.4700 5.4700 1,000,000.00 1,000,060.00 993,750.00 23,095.56 5416 FNMA U.S. GOVERNMENT AGENCY 03/08/96, 02/18/99 313648WC0 5.2000 5.6710 987,343.75 1,000,000.00 989,375.06 14,877.78 5371 FFCB U.S. GOVERNMENT AGENCY 03/10/94 03/01/99 . 31331HCBI 5.7900 5.9660 453,125.74 456,521.74 455,523.10 6,608.15 5377 FHLB U.S. GOVERNMENT AGENCY 03/08/94 03/08/99 3133894F2 5.7700 5.7700 1,000,000.00 1,000,000.00 1,000,000.00 13;303.06 5372 FHLB U.S. GOVERNMENTAGENCY 03/15/94 03/15/99 31338941-9 5.2850 5.2850 2,000,000.00 2,000,000.00 1,965,625.00" 22,314.44 5421 FHLMC U.S. GOVERNMENT AGENCY 04/15/96 04/15/99 3134AOB68 6.6500 6.6500 .1,000,000.00" 1,000,000.00 1,006,250.00 41.747.22 5410 FHLMC U.S. GOVERNMENT AGENCY 12/12/95 12/13/99 3134AORYO 6.1800 6.1800 1,000,000.00 1,000,000.00 999.375.00 29,011.67 5424 FHLMC U.S. GOVERNMENT AGENCY 05/02/96 04/03/00 3134AOA38 6.3600 6.7123 993,268.75 5,300.00 1,000,000.00 1,006,250.00 42,046.67 5405 FFCB U.S. GOVERNMENT AGENCY 07/07/95 06/12/00 31331NQJ6 .5.8900 6.0894 991,562.50 1,000,000.00 999,375.60 27,650.28 5428 FFCB U.S. GOVERNMENT AGENCY 06/04/96 12/04/00 313993OW2 7.0000 7.0000 1,000,000.00 1,000,000.00 1,000,000.00 34,416.67 5409 FNMA U.S. GOVERNMENT AGENCY 12/26/95 12/26/00 31364BRT9 6.1900 6.1900 230,000.00 , 230,000.00 229,928.13 6,129.82 " 5411 FNMA U.S. GOVERNMENT AGENCY 01/04/96 12/27/00 31364BSA9 6.2500 6.2221 1,176,363.00 1,175,000.00 1,173,898.44 31,414.93 5414 FNMA U.S. GOVERNMENT AGENCY 02/27/96 01/25/01 31364BTZ3 5,6700 5.8502 498,691.88 2,520.00 500,000.00 496,171.88 24,097.50 5415 FNMA U.S. GOVERNMENT AGENCY 03/05/96 63/05/01 31364BXU9 . 6.0100 6.0400 998,720.00 1,000,000.00 995,625.00 14,357.22 5419 FNMA U.S. GOVERNMENT AGENCY 04/15/96 03/14/01 31364BYV6 6.3100 6.5303 990,781.25 1,000,000.00 999,687.50 13,496.39 5420 FNMA U.S. GOVERNMENT AGENCY 04/18/96 04/16/01 31364CAW8 7.1400 7.1400 250,000.00 250,000.00 251,718.75 11,057.08 5429 FHLMC U.S. GOVERNMENT AGENCY 09/20/96 05/01/01 3134AOFSO 7.0000 7.1505 994,062.50 1,000,000.00 1,009,687.50 6,833.33 5425 FNMA U.S. GOVERNMENT AGENCY 05t03/96 05/04/01 31364CCF3 6.8500 6.8500 1,000,000.00 1,000,000.00 1,016,875.00 5,137.50. 5423 FHLMC U.S. GOVERNMENT AGENCY 05/29/96 05/29/01 3134AOM33 7.0000 7.0000 550,000.00 550,000.00 561,000.00 213.89 5428 FNMA U.S. GOVERNMENT AGENCY 05/29/96 05/29/01 31364CDN5 7.0000 7.0000 505,000.00 505,000.00 514.942.19 196.39 5427 FHLB U.S. GOVERNMENT AGENCY 06/11/96 06/11/01 3133933AG 7.2800 7.2800 1,000,000.00 1,000,000.00 998,437.50 34,377.78 5413 •FHLB U.S. GOVERNMENT AGENCY 01/18/96 12/18/01 3133921,183 6.3700 6.3700 1,000,000.00 1,000,000.00 992,812.50 28,841.94 2454 FNMA U.S. GOVERNMENT AGENCY 02/26/87. 12/10/15. 313586U83 10.3500 8.2490 3,688,593.75 3,000,000.00 4,155,000.00 147,487.50. 4770 FHLMC U.S. GOVERNMENT AGENCY 07/30/92 06/01/16 313400MC4 8.2500 7.6300 10,199,962.50. 9,555,000.00 11,083,800.00 394,143.75 3914 LAIF STATE OF CALIFORNIA OPEN OPEN 5.5990 5.5990 4,037,981.47 4,037,981.47 4,037,981.47 Not Available 5273 LAIF STATE OF CALIFORNIA OPEN OPEN 5.5990 5.5990 107,028.01 107,028.01 107,028.01 Not Available' 4693 LACIP . LOS ANGELES COUNTY TREASURER OPEN OPEN 6.0400 6.0400 37,688.29 37,688.29 37,688.29 Not Available TOTALS: 61,295,466.32 7,820.00 60,055,219.51 62,492,399.01 1,360,201.61 MARKET VALUES HAVE BEEN PROVIDED BY SUNGARD FINANCIAL SYSTEMS, Page 2 wEIcHrEO aveRnoE DAYs ro MAruarTv.• 2300 ' INVDTAL.XLS 9 CITY OF WEST COVINA BOND DETAIL REPORT November 30,1996 BOND ISSUE FUND INVESTMENTS ISSUER fMATURITYJ ORIGINAL PAR MARKET RATE DATE COST L VALUE W Water- v ue- Water_Revenue_Bonds Escrow Treasury Notes U.S. Government 2/28/97 181,869.87 178,000.00 1.78,6.12.32-6.750 Trustee: First Trust California Escrow Escrow Treasury Notes U.S. Government 8/31/97 432,483.28 438,000.00 438,683.28 5.625 Treasury Notes U.S. Government 2/28/98 181,559.75 188,000.00 187,118.28 5.125 Escrow Treasury Notes U.S. Government 8/31/96 435,955.77 462,000.00 455,790.72 4.750 Escrow Treasury Strips U.S. Government 11/15/98 4,337,684.80 5,742,000.00 5,157,923.76 6.400 Escrow Cash 1,806.25 1.806.25 1,806.25 ENDING BALANCES 6,671,359.72 7,009,806.25 6,419,934.61 W.C.P.F.A.1993 Eastland Revenue U.S. Govt. Obligation Fund First American Funds, Inc. Open 120.00 120.00 Revenue Tax Allocation Bonds Eastland Revenue Cash 120.00 4.90 Trustee: First Trust California Eastland Reserve U.S. Govt. Obligation Fund. First American Funds, Inc. Open 0.56 290,652.00 0.56 290,652.00 0.56 290,652.00 4.90 Eastland Reserve F.N.M.A. U.S. Government Agency 3/25/98 274,570.31 275,000.00 273,707.50 5.25 Eastland Reserve Cash C.B.D. Revenue U.S. Govt. Obligation Fund First American. Funds, Inc:.- Open . 0.50 169.00 0.50 169.00 0.50 169.00 4.90 C.B.D. Revenue Cash C.B.D. Reserve F.N.M.A. U.S. Government Agency 3/25/98 0.25 828,703.13 0.25 830,000.00 0.25 826,099.00 5.25 C.B.D. Reserve U.S. Govt. Obligation Fund First American Funds, Inc. Open 873,938.00 873,938.00 873,938.00 4.90 C.B.D. Reserve Cash Interest U.S. Govt. Obligation Fund First American Funds, Inc. Open 0.87 321.00 0.87 321.00 0.87 Interest Cash 321.00 4.90 Principal U.S. Govt. Obligation Fund First American Funds, Inc. Open 0.85 730.85 0.85 730.85 0.85 730.85 4.90 Principal Cash Rebate U.S. Govt. Obligation Fund. First American Funds, Inc. Open 0.70 22,252.00 0.70 .22,252.00 0.70 22,252.00 4.90 Rebate Cash 0.92 0.92 0.92 ENDING BALANCES 2,291,466.09 2,293,192.65 2,287,999.15 W.C.P F.A. Revenue Revenue- - _ . _ - _-U.S: Govt. Obligation Fund first American Funds, Inc. " ' Open 937.00 937.00 937.00 4.90 Refunding Bonds Series 1994 Revenue Cash Trustee: First Trust California 0 28 0 28 0 28 ENDING BALANCES 937.28 937.28 937.28 Page 3 CITYBOND.XLS CITY OF WEST COVINA BOND DETAIL REPORT November 30,1996 BOND ISSUE FUND INVESTMENTS ISSUER MATURITY ORIGINAL PAR MARKET RATE DATE COST VALUE West Covina Civic Center Lease Payment FICA Master Market Int. Acct. Wells Fargo Bank Open 3,161.30 3,161.30 3,161.30 3.20 Refunding Lease Payment Cash Trustee: Wells Fargo Bank Reserve FICA Master Market.Int. Acct. Wells Fargo Bank Open 23.41 23.41 23.41 3.20 Reserve SLMA Medium Term Note U.S. Government Agency 1212113 2,782,599.75 2,f85,000.00 2,691,981.00 6.55 Reserve Cash Earnings FICA Master Market Int. Acct. Wells Fargo Bank Open 227,897.76 227,897.76 227,897.76 3.20 Earnings Cash ENDING BALANCES 3,013,682.22 .2,916.082.47 2,923,063.47 City of West Covina Cert. of 1967 Bond Escrow U.S. Treasury BD SLG U.S. Government 8/1/97 188,300.00 188,300.00 188,300.00 11.27 Participation (Civic Cntr Cmplx) 1967 Bond Escrow Cash 123.46 123.46 123.46 Trustee: First Trust California 1972 Bond Escrow U.S. Treasury BD SLG U.S. Government ` 7/15/97 94,300.00 94,300.00 94,300.00 11.30 1972 Bond Escrow Cash 1,258.13 1.258.13 1,258.13 ENDING BALANCES 283,981.69 283,981.69 283,981.69 GRAND TOTALS 11,161,426.90 12,504,000.24 11,916,916.10 *Market valuations have been provided by Wells Fargo Bank and First Trust Califomia .0