HomeMy WebLinkAbout1/9/2008 - STAFF REPORTS - 2.F. ���Y pLM sp4
iy
u �
c'`'�°"NAP City Council Staff Report
DATE: January 9, 2008 CONSENT CALENDAR
SUBJECT: TREASURER'S INVESTMENT REPORT AS OF NOVEMBER 30,
2007
FROM: Craig A. Graves, City Treasurer
BY: Department of Finance and Treasury
SUMMARY
Attached is the Treasurers Investment Report as of November 30, 2007. The report
includes the face value and coupon rate (if applicable) of the investments and the source
for the market value estimate_ Also included is information on the investments of Bond
Issue reserve funds, and on loan repayment programs managed by a bank.
RECOMMENDATION:
Receive and File Treasurer's Investment Report as of November 30, 2007
STAFF ANALYSIS:
The attached monthly Treasurer's Investment Report is for the period ending November
30, 2007, The report includes the face value and coupon rate (if applicable) of the
investments and the source for the market value estimate. Also included is information
on the investments of Bond Issue reserve funds, and on loan repayment programs
managed by a bank.
The investments, in type, maturity and as a percentage of the total portfolio, are in
compliance with the existing City Council-approved investment policy with one
exception: the FICO notes ($500,000, 4/16118, 9.8%) exceed the 5 year limitation on
maturities (Detail of Investments, Long Term Investments, Mortgage Pass Thru's). The
investment in question was purchased prior to the adoption of the 5-year limitation.
Since it appears to represent no additional risk either because of credit-worthiness or
liquidity, earlier councils decided to allow it to be retained in the investment pool because
the yield is higher than attainable under current market conditions. We recommend that
this exception to the policy be continued. The second exception is Mortgage Pass Thru's
ITEM NO. '
City Council Staff Report
January 9, 2008—Page 2
Treasurer's Investment Report as of November 30, 2007
are 1.3% over their maximum percentage of 10%. At the time of the last purchase of
this investment type they were still under the 10% limitation, but with the reduction of the
portfolio the percentage changed. Since the portfolio will again increase with seasonal
property tax, in-lieu taxes and tax increment it is recommended that the current amount
remain with no new investments in that category as the increased revenue will bring the
percentage back under 10%.
State law requires this report to be submitted within 30 days of the end of the quarter.
Because all of the City's bank accounts may not be completely reconciled, there may be
minor adjustments to the cash on hand in the checking account and to the valuation of
the bond issue's money market investments. All other amounts are actual.
The weighted average maturity (WAM) of the portfolio is 524 days. The maximum WAM
allowed by the Investment Policy is 1095 days. The current portfolio and expected
revenue cash flow will be sufficient to meet budgeted expenditure requirements for the
next six months and the foreseeable future thereafter.
FISCAL IMPACT:
None
Craig A. Graves, City Treasurer
Attachments: Treasurer's Investment Report
��® '� 2
irimuarep CITY OF PALM SPRINGS
12/13/2007 TREASURER'S MONTHLY REPORT
SUMMARY OF INVESTMENTS
NOVEMBER 30, 2007
On Call De Sits Adjusted Basis Category Total percentage
Checking Account $ -645,628
Suite Pool 26,940,000 S 26-194.372 32.61°/.
Short Term Investments
(I year or less)
Corporate Notes 1,983,760
Mortgage Pass-I hrus 1,623,627
Time Deposits 3,514,000
U.S.Gov t Agencies 9,750,000
U S.Treasury Notes 0 15,971,387 19.69%
rm Term Investments
to"yciii
Corporate Notes 1,799,310
MorlBage Pas Thm:, 6,534.304
US Gov't Agtmui s 16,917,944 25,251,559 31 32%
Long Term Investments
(3 revs 10$Yeats)
Corporate Notes 986,120
Mortgage Pass-Thrus 977,586
U.S.Gott Agencies 11,242,872 13,206,578 16.38%
S 80,623.895 100 00%
"Some Investments made prior to the implementation ofthe
current investment Policy exceed the 5 yulr limit
i
ireasrcp TREASURER'S MONTHLY REPORT
r_I13n007 DETAIL OF INVESTMENTS
NOVEMBFR 30,2007
Coupon Ymld AA,.awd (memo only) Fnor Qu.
Pm Val.. Rat. R4trng Mutuoty mYlmmny Coot Ba;u: Category Total Market Yaluc Source MwkCt Vuluc
Un Can D.posas
Checking-Bank ofAmenca S NIA v-uaahle AAA open 410% $ 645,ul; S -645,628 E 1,958419
Local Agnn.y hw.sr Fund(LAF) 26,940.000 a-able N/A open 496% 26,940000 26,954,911 LAM 19163110e4
26,194,370
Short Tenn lnvesuncnts
I ev or l.s. '
earpnmte Not"
Boor Steams Cc 1,000,000 A00% AAl 01131/OB 43A% 990,670 995,950 BNY Wetmn Tr 994,470 1
Wells Forgo Company 1,000,000 350% AAI UAmlOs 373% 993,090 993,400 BNY Wewem Tr 969,910
1.983,760
Mart" P4.s•Th 1
Federal Home Lawn Mortgage CnTnrnhnn 2,0OO,U(N 4UU'Y N/A O6I01/08 482:4 637,54E Wg,158 BNY Western Tr 685,481 (
redeml flame Loan Mortgovc Comoration 465,000 400% N/A 08/01/06 556% 128,45 132,085 BNY Wesuhu'rl 137,6�1 ')
Fedcml Home Loan Mortgage Corpo,atmn 1,400.000 40011. N/A 09/01/O8 543% 404,350 414,982 BNY Wa.mm Tr 431,551
Federal Home Loam Murtygc Cmp.mhon 1,800000 450% N/A 11/01/08 507% 453,266 456,570 RNY Wt,:(em Tr 471,819
1,p2"1,fi,7
T.me DMwin.
Wn;hmgton Mutual Bank(Libraty l rust) 500,000 520% AAA 10/01/07 5W% 0 0 Wa:hwgton Mw 500,000
Washmgmn Mutual sank(Librry Trust) 1,000,000 527% AAA 1o118/n7 JZ7% 0 a lafahrnoon Mutual 1,000,000
CD Account Reysmy Semam(CDARS) 490,000 535% AAA 01/24/OS 550% 430,000 460,000 Palm Desert Nat.Bank 480,000
Wmhmgmn Mutual Bank 1,000,000 524% AM 02/05/OS 514% 1oan.o0o 1,000,000 Washmgtch Mutual 1,000,000
Wo,hmTo.Mlltnal Bank 1.000,000 524% AAA 02/05/08 5241K 1,On0,DUD 1,000,000 Wu. Iran Mutual 1,000,000
CD Account Regteh y Sorvmo(CDAPS) 910,000 535% AAA 07/17/n6 55tp/, 940,000 940,000 Palm Dnen Nat Baal 940,000 '
CD Accounn Rcgrsuy Setvmc(CDARS) 94,000 535YA AAA 67/24/08 55D'6 94000 94,000 Palm Du,Sort Nar Bank 94,000
3,514,000 1
1
US GoJc Agency Sceunue, I
Fcd ad Neuon-d Mortgage Asrocmww 1,000,000 35U% NIA 10/12/07 350% 0 0 BNY Westem Ti 999,688 �Y
Federal Borne Lawn Bank 50000 476% N/A 10/26/07 476% 0 0 BNY Western El 999,8-14 N
Fodor l dome Lawn Bah 1,000,n00 5 0U% N/A 11/26/07 5 00% 0 0 BNY Wcstcm T. 1.000,000 Y
Federal llama Low Bank 1,000,VOD 5.10% NIA =S/07 510% 1,000,000 1'=,3313 BNY Western Et 1,000,313 Y
Cederol Flomc Loan Bank 500,000 410% N/A 01/30/08 4 30110 500,000 499,844 BNY Wanem Tr 4991906 1
Federal Homo Loan Bank 1,000 000 5 O4% N/A 02/26/06 5 04% 1,000.000 1,001,563 BNY Western Tr 1,000,213 1
Fedeal Nm..al Mortgage A:.,.hn. Ionnnno 52S% N/A 04/IO/OS 515% 0 0 BNY Western T. 1,000,000 1
Federal How.Loan Hank 1,000000 402% N/A (16/19,06 402% 1000,000 997,500 BNY WesTem Tr 9D5,000
Fcdend Homo Law Mortgaga Cmpnrnhw Ip00,nn0 525% N/A 06Q7/08 525% 1,000,000 1,000,520 BNY Western I 1,001200 1
Federal Homo Low Bank 1,000,000 530% N/A 07/23/08 530'/ 1,000,000 1,001,250 BNY Westum Yr 1,001,E75
G Federal Home Loan Bank 500,000 4 36% N/A 07M/08 4191A sound 499,68E BNY Wcmm Tr 498,594
G Federal Home Cann Bank 1,000,000 5 OO°/ N/A OS/O8/06 5 0ov, 0 0 BNY W, Tr 1,000,313
Federal Home Loan Bonk 750,000 500% N/A 10/27/08 Son% 750,000 750,93S BNY Wa:tamh 750234
4 Federal Faun Credit Bank 1.000,000 3 85% N/A 10/29/08 3 85% 1,000,00D 996,875 BNY Wa•cm Tr 992,500
Federal Home Loan Back 1,000,000 400% NIA I1/17/08 400% 1,000,000 99S.M BNY Western Tr e93,750
�^ 9,750,000
N
I
toosrev TREASURER'S MONTHLY REPORT
MM007 DETAIL OF IN VES I'MENTS
NOVEMBER.30,2007
Coupon V1eld Adjusted (nloano 01*) Prior Qv.
P&VWua Raw Rang Mntunty to Malmo, Com Bna: C.i,.,T9m1 Market Value Source Market Value
❑S Treasury Notes
❑S Trewury Note 498,490 425% NIA 10/31/07 425% 0 0 BNYWeStem Tr 500,156
0
Medium Term Investinems
(1 vcar to 3 yams)
Curpuram Notes
Wclln Fsso&Company 800,000 39R% AAI lo129/10 42U°A 795,160 791,96E BNYWa,tem Tr 0
SEC Commumrnunn:,lac 1,000,000 530% A2 11115/10 517°/. 1,004,150 1,025570 BNY Wcstem Tr 100R,850
1,799,310
Mortgage Pnse-Thrus
Federal Home Loan minna,Curpunuon 3,000000 500°A N/A 02/01/09 5U8% 230,214 231,361 ENY Western Tr 240371
Federal Homo Lam Mmtyge Cmpomto. T,a35,000 450% N/A 03/01/09 488% 810,593 S10,4S1 BNY Wesrmn Tr S29,750 !
FadcrN Home Lam ModSnge Corporation 480,000 4.1)U% N1/A 04/01/09 5Is% 222,499 225,796 BNYWesrem Tr
Federal Home Lome Mortgage Cmpmauou 540,000 350% N/A 06/0009 479% 509,189 313,238 BNY Wcstcrtl Tr 326,336
Fedceal l4cae Loan Morays,Cmpontion 570.000 4 50% N/A 09/01/09 5 37% 345,929 351,343 BNY Werrem Tr ,61,677
Fcdenl Home Low Mmtgase Cnrpnmtinn 3,000,000 S 50% N/A 10/01/09 5 43% 280,667 2R6,508 BNry Westcm Tr 296 259
Federal Home Loan M9rtsaf Ccmomnon 2,050,000 4 50% N/A 10/OV09 5 01% 395,076 79',676 BNY Western Tr 399,940
Federal Nnomal Mongspe Association 2.700,000 45091. NIA 01/01/10 4 9 1% 577,577 584,113 BNY Westen Tr 599,S06
Federal Nwonal Mongsgc Asieaauon 2,500,000 450% N/A 02/01/tn 446% 625,457 621,675 BNY We,tern Tr 623,134
Federal Hortc Low Mortgage Cmponnon 1,455,000 450% N/A 02/01/lu 522% 415,006 420,286 13NY Westem Tr M,977
Federal Namur Mortsnse hs9emn9n I,000,0U0 4MN. N/A 03/01/10 512°A 360,613 S8;,R99 BNYWestem Tr 37 i3OU6
redenl Home Loon Mortgage Corpomtion 2,230.000 450% N/A 05/01/10 529% 7S0,180 795,627 BNY Western'Er 81{,261
Federal Home Loan MonpABe Corgoaawn 1.370,000 500% N/A 09/01/10 535% 420$20 1126,283 BNY Westen Ir 433,319 !
Fedeml National Mon g,r Aseomatmn 500,000 400% N/A 10/01/10 495% 225,333 226.678 ENY Western Tr 330,517
Federal Home Lams Bank 775,000 4 75% N/A w/25/10 4 68% 534.951 538,1S6 BNY W,tem Tr 542,46E
6,534,304
US C9Jt Agency Secnrmes
redcvl Home Loral Bank 1,00,000 5 25% N/A 0105/09 5 35% 1,000,000 1002,188 BNY Western Tr 1,0021MO
Federal Home Latin Bert, 1,000.000 423% N/A 0J1 O/09 423% 1000000 1,000,000 BNY Weswtn'tr 993,625
Federal!Tome Loan Bank 1.000,000 525% NIA 02/27/09 525% 1,000noo 1,002,813 BNY Wc5wm Tr 1,00^_,313
Federal Home Low Mortt.gc Corporation 1,000,000 222% N/A 04/15/09 365% 999.250 993,750 BNY Western Tr 954,375
Fedarl Home Lam Buds Ilow,000 550% N/A 07/17/09 550% a 0 BNYWwwa Tr 1,000,625
Federal Notional Mongase A,peatmn 1,000,VU0 445% N/A 081251U9 480% 993,530 1,000,000 BNY Wmem Tr 996,875
Federal N=.m Mortgage A55namtion 1,000,000 4 01% N/A 10/07/09 510% 976,196 999,063 BNY Westem I 991,2M
redone Home Lame Morrgnge Comoranan 1,000 000 5 do% NIA 10/26M9 5 12% 996,R75 1.000,060 BNY Wester T. 2.000.030
Q Fedeml Farm Credit Bonk 1,000,000 425% NN I1/IRI09 425°n 1,000,000 1,000,313 BNY Westemh 994,375
Federal Home Loan Bank 500,000 500% N/A 11/25/09 500,00O 501,094 BNY Weston Ir 500,156
p Fedeml Home Loan Bank 1,000,000 4 30% N/A 12101/09 416% 1,000,000 1,000,000 BNY Western Tr 994,688
Federal Manuel MorrWe Assooemon 1.000,000 525°% N/A 12-8/09 538% 997,1oo 1,000,938 BNY Wcnam Tr I,001,975 1
Federal Home Law Bade 1,000,000 435% N/A 02/22/jn 435% 1,000.000 1,000,000 BNY Westem Tr 994,06;
Fedeeal Hume Lu.m Mortgaso Cmpomtmn 1,000u00 550% N/A 03105/IU 550% 1,000.000 1,000,060 BNY Wesrnm Tr 1.001,790 I
=1
1
na,w4p TREASURER'S MONTHLY REPORT
1JI3/2007 DETAIL OF INVESTMENTS
NOVEMBER 30,2007
Condon Yield Ad2n ted (memn nnly) Prior Qu
Pill Valuc Rate Rating MaaBty to Mitmny Cost Bwn Category Toed M.mk.t Value Snurec NNrkct Vnluc
Federal Homc Loan Mortgage Corporation 1,000,000 405% N/A 03/08/10 4R0% 9b2,39D 998,720 BNY Wcetam Tr 9S9,1300
Federal Home Lost Bank 500,000 41O% N/A 054,6/10 46V'/ 494,293 499,375 BNY Wcamn Tr 0
F.dcd Farm Cmdn Bad, 1,000,000 4BV% N/A 05/05110 325% 9SSf8D 1,000,000 BNY Wcstcm Tr W906;
Tedeml 17.Credit Bank 1,000,000 53m°i N/A W04/10 53R% 0 0 BNY Western fP I,000,ODD
Federal Fnrm Credit Bank 2,000,000 555% N/A 07/16/10 555% 2,000,000 2,003,125 BNY Wester I 2,005,625
Federal Home Lams➢ak 11000,000 550% N/A 07/nM 5 50% D 0 ANY Weamn Tr I DOD 000 I
16,917,944
Long Tana hwsnnent
i years to 5 years)
Corporal.Note:
Goldman Sachs Group,Lie 1,000,000 500% AA3 01/ISM 1 537% 986,120 1,009,= BNY Wc•mm Tr 992,900
9S6,120
Mortgage Ra••Thrv:
Federal Home Loan Mortgage Cmporauon 1,015,552 450% N/A 02/01/11 524°4 413.127 475,922 llN Westem Tr 4SO,724
Federal Houle Lean Mongvgo Corpur,mem 695,000 400% N/A 04/0I/11 522% 397.926 397,S65 RWWestem Tr 40 695
Peden Ham.Low Mortgage Corporation 200,000 450% N/A 05/01/11 537% 111,933 11;.IR0 BNY Western Tr 11S,47R
977,566
US Godt Agwcy Securincs
Federal Home Loan Bank 750,000 530% N/A 2115110 541% 747,636 759,375 BNY Wcstcm Tr 756,32S
Federal Nome Loan Bank 7.000,000 530% N/A 02/2R/II 5[1% I,OU0,000 1,003,125 ➢NY Wcstcm Tr 1,00343E
Federal National Mortgage Association 1,000000 539".G N/A n7/01/II 547% 996,640 1,002,500 BNY Westem Tr I000,93S 1
Federal Hnne Lean Bunk 1,000,000 55n45 N/A 1)7/11/11 550°6 1,000000 100156; BNY Wcstcm Tr 1,003,115
Fodcral Home Low Bank 2,000,000 S 30% NIA 07/27/11 550% 2,000 000 2 056,875 BNY Wcstcm Tr Z,035,625
F.d.o,al Home Low Bwk 1,000,000 550% N/A D727/ll 550% 1,000,000 1y2S 436 BNY Wcs[cm Tr 1,017,813
Fcdmal dome Loon pwlr 2,000,000 5]5% N/A Gale 1/11 575% 2,000000 2,033,75D ➢NYWostcm Tr 2,020,000 �
rcder.l Rome Loan Morreoge Corporattn 1,300,000 3.65% N/A OM4/12 5e5% 0 0 BNY Wostmn Ir 7,502,310 I
Federal Home Loan Mongagc Corpoeauun 1,000,000 550% N/A 09/10/12 SSO% 1.000.000 1,011,16E BNY Wesem Tr 1,007,391 I
Fcdcral Homo Local M.ngago Cmp.r.L.. 1,000,000 530% N/A ID/i NIZ 530% 1'000,000 1,010,690 BNY Westem Tr 0 t
Financing Corporatron(FICO) 500000 980% N/A WWI 9S0°i, 499,394 711,094 NwnnsBnnk 692,844
11,2a2 S7n
lY
Tmal lnvc.ted C.h S 80.623.895 $ 81 20,561 S S5,314253
Q
d
0
d
C7 Y
I
TREASURER'S MONTHLY REPORT
treasrep MISCELLANEOUS AND TRUST ACCOUNTS
12/13/2007 NOVEMEER 30, 2007
Yield Adjustcl
Par Value Coupon Rating Maturity to Maturity Cost Basis Category Total
Total invested Cash S 80,623,895 S 80,623,893
$ 80,623,895
Nuscellaneous Accounts
Petty Cash 3,275 N/A N/A open none 3,275
Revolving Fund-Bank of America 6,595 N/A N/A open none 6,595
Trust&Agency-Bank of America 1,389,940 N/A N/A open none 1,389,940
Govemmunt Grant Trust-Bank of America 78,932 N/A N/A open none 78,932
Transportation Grant Trust-Bank of America 0 N/A N/A open none 0
Downpayment Assistance(Housing
Fund)-Washington Mutual 33,556 variable N/A open 0.25% 33,556
Workers Compensation-Bank ofAramca -21,684 N/A N/A open none -21,684
General Liability-Bank of Amcnca 18,227 N/A N/A open none 18,227 1,508,841
I
r
Deposits Hcld In Trust h
Time Deposits
(FDIC Insured) '
a
Downey S&L(Cut Cyn Country Club) 67,986 4.93% N/A 2/11/2008 5.01% 67,986 t
Downey S&I,(Donovan Bequest) 14,393 4 93% N/A 2/4/2008 5.01% 14,393 1
Op Downey S&L(Palmer Cable TV) 5,240 4 97% N/A 1/18/2008 4.97% 5,240
p Guaranty Bank(Coyore Springs Apr) 18,890 4 91% N/A 6/24/2008 5,00% 18,890
106,509
4� t
b
i
Total Cash Deposited F 82,239,245 t
i
TREASURER'S MONTHLY REPORT
Irensrep BOND ISSUE RESERVE,DEBT SERVICE&RELATED FUNDS
12/13/07 NOVEMBER 30,2007
Coupon Y'Vld Adjusted (memo only) Prrar Qtr
P Value gate Rnhng MaTur, to MatuutV Cost B.u.x Category Total Mnrlra Value Farm, Market VVduc
1991/97/01/04 Convention Ccntct
AIM Govenunent&Agency Pord Pnvate 35,961 venable AAA open 428% 353,981 353,981 BNY Wtsttm If 155,179
AIG lavesunent Agitate. 1280,673 536% AAA 11/01/25 536% 1280,673 1,280673 BNY Wustem TV 1_80,673
AIG hlvm=mL Agrc=mt 1,:90,000 668% AAA 11/01 a 668% 1290,000 1290000 ONY We!tern Tr 1290000
MB1A Invuxment Agreement 3,300,402 555% AAA 11/01/35 559% 5.3(mA02 3,300402 ➢NY Wectem Tr 3,3004C2
6,M5,056
199106Anpmt
AIM Shnrr•Term invest Try PnvoG 1409,449 vannble AAA open 428% 1,409,419 1409449 BNYWestem Tr 1,2S7,598
1,409,449
1991 MI Series B-Housing
ATM Government&Agency PorlP Pnvate 4335 variable AAA open 423% 4,335 4,335 ➢NY Wc5nm TV 4,304
AIG lnvestntcut Agm9mtm 468,105 522% AAA as/01/21 522% 468105 468,105 BNY Wtstvra 3r 468,105
472,440
1994/04 Senco A&B
AIM Govmnment&Aycnry Portf Pnvate 2,310,G36 vmreble AAA open 428% ga10,636 2,310,636 ➢NY Wertem Tr y392,733
MB1A Inv.xtmcnt Agmoment 1,651,446 517% AAA 09/01/34 517% 1.661.456 1,651.456 ➢NY Wertem Tr 1,651,456
3,962,092
1996AW07 M91uplc Capital Famhtre:Project
Cash 0 0 0 ➢NY Wustem Tr 0
AIM Govermntnt&Age yPurdr Pnvmc 24,726 variable AAA open 42S°ia 2472f 24,726 BNY Wuatcm Tr 50,140
2a,72G
1998 Anon GARB
AIG lnvesment AW-Restrva 561,221 570% AAA 01/01/28 5709/. 561,221 561,221 BNY Wes=Ta 561'"I
AIM Cmnmmem&Agency Pori'Private 326,299 vmrnhje AAA 0pcn 428% 326,29E 326.2% BNY Western rr 142,075
887,519
6
O
b
I
TREASURER'S MONTHLY REPORT
Ueasmp BOND ISSUE RESERVE, DEBT SERVICE& RELATED FUNDS
1v13r07 NOVEMBER 30,2007
Coupon Y,.Id Adluted (memo only) i'�Ior Qu
Par Vnlue Rnte Raring Malwity io Mutuvty Coo B., Cntegnry Tnml Marker Value Source Market Valuc
1999 Atmon PFC
AIGlnvemenlAW-Rcscrvo 549725 5700/0 AAA 011O1125 570% 849,725 849,72E BNY Westcry Ti 819,728
AIM Governmew&Agent'PonfPnvate 512,108 variable AAA open 42S% 512109 512,109 BNY Weatcm Tr 376,396
1,361,636
1908 Aesesxmcnt Dutn[t 155 A&II
A IM GOVCIILRCOt&Agency Poril Private 29,044 variable AAA open 428% 256.744 286,744 BNY Wostcm Tr 284,5E
286,744
2001 AsscssmrntEu,una 157115S
AEM Gov- rn=t&Agimry Pauf private 192,321 v.vwblc AAA open 422% 182�321 162,321 BNY We-tam Tr IBIp35
182,321
2002 Parkmg Strum
Cash 3 3 BNY WeRcm Tr -
AIM Govemmenr&A,-n Pnrrfprivatc 39,690 vwable AAA open AZV° 39,690 39,690 BNY Wesmm Tr 32,99E
39,693
2004 Ayv mcm Dismet 161
AIM Govemmenr&Agency Ponf Puvale 415,166 venable AAA opmi 423% 415,166 415,166 BNYWestcm Tr 112,149
415 166
20W A_e55ment Dramcr 162
AIM Govemment&Agency PonfPrrvaw 160,841 vanoble AAA open 428% 160,841 I60,941 BNYWesecm Tr 159,631
160,541 j
_005 h:esmn t D=a Iti4
AIM Covemment&Agency PorrfPrlvale 368,091 variable AAA open 428% 368,091 365091 BNY Weseem Tr 363,424
368,091
2007 Mcryed Pm,9et�I&tl2
AIM Govemment&Agency Ponf Prrvatc 13,799,504 vanuble AAA open 428% 13,795,504 13,798,504 BNY Wmum Tr 13,7119,232 1
13,79SS04
Trims B 79.594479 5 29,594,479 S 30,094,070
0
0
0
0
ca
treasrep TREASURER'S MONTHLY REPORT
12/13/07 CALCULATION OF INVESTMENT LIMITATIONS
NOVEMBER 30, 2007
Allowable Percentages
By Maturity: Minimum Maximum Current Mo.
I day to 365 days $8,000,000 N/A $42,165,760
I year to 3 years 0.00% 50.00% 31.32% i
3 years to 5 years 0.000/0 30.00% 15.76%
over 5 years N/A N/A 0.62%
Y
Y�
9
9
By Type of Investment:
i
Bankers Acceptance - in total N/A 40.00% 0.00%
Bankers Acceptance- single bank N/A 20.00% 0.00%
M
Commercial Paper N/A 15.00% 0.00%
Certificates of Deposit N/A 30.00% 4.36%
M
Corporate Notes N/A 20.00% 5.92%
W
Money Market Mutual Funds N/A M00% 0.00%
Mortgage Pass Thr 's N/A 10.00% 11.33%
a U.S. Government Agencies N/A 50.00% 45.78%
c3 U.S. Treasury Notes/Bonds N/A N/A 0.00%
i�
C� t�
1
treasrep
1211312007
Calculation of Weighted Avg Maturity
Mature Current No of D,iys X Cost
Dille ➢,ae Days
On Call Dcpnsit 39,416
Checking-Rank ofAmeficn S 39,417 39,416 1 -645,628
Local Agency invest Fund(_ATF) 39,417 39,416 1 26,940,000
Short Term ivvestmrsts
(I year or less)
Corpuntle Notes
Bear Ste,trns'Cu 39,478 39,416 61 61,421.540
Wells Fargo Company 39,542 39,416 126 125,129,340
Morlgzige pass=fhrus
Federal Home Loan Morigage Corpurtion 39,60D 39,416 184 117,309,374
Federal Home Loan Mortgage Corporation 39,661 39,416 245 31,474,006
Federal Home Lawn Mortgage Corporation 39,692 39,416 276 111,600,663
Federal Horne Loan Mortgage Corporation 39,753 39,416 337 152,750,676
Time Dcposrts
Waahmynon Mutual Bank(Library Trust) 39,35E 39 416 �60 0
WMhmglOn Mutual Bank(Library Trust) 39,373 39;t 16 -43 0
CD Account Rcgigay Service(CDARS) 39,471 39,416 55 26,400,000
WnehmyKon Mama]Bank 59,483 39 416 67 67,000,000
Washmglon Mutual Bahl, 39,483 39,416 67 67,000,000
CD Account Registry Servicc(CDARS) 39,646 39,416 230 216,200,000
CD Account Reynstry Service(CDARS) 39,653 39.416 211 22,278,000
118 GOO Agency Securities
Federal National MoRJdpe Association 39,367 39,416 49 0
Federal Home Loan Bank 39181 3Q,416 -35 0
Federrl 140me Loan Bank 39,414 39,416 -2 0
Federal Hama l.oari Bank 39,444 39,416 18 28,000,000
Federal Home Loan Bank 39,477 39,416 61 30,500,000
Q Federal Nome Loan Bank 39,506 39,41E 90 90,000,000
d Federal Nallonal Mortgage Association 39,548 39,416 132 0
Federal Home Loan Bank 39,609 39,416 193 193,000,000
O Federal llome Loan Mortgage Corporation 39,626 39,416 210 210,000,000
(..._s Federal Home Loan Bank 39,652 39,416 236 236,000,000
Federal Home Loan Bank 39,654 3941E 238 119,000,000
Federal Home Lean Barik 39,669 39,416 251 0
Federal Home Loan Baitk 19,749 39,416 332 249,000,000
i
treasrcp
12/13l2007
Calculation of Weighted Avg Maturity
Mature Current No of Days X Cost
Date Date Days
U.S.Treasury Notes
U S fmus'ury Note 39,386 39,416 -30 0
Medium Term Invicetinem5
(]Venr m 3 Y.
Corporare Notes
Wells Fargo&Company 40,480 39,416 1064 946,050,240
SBC Communications,Inc 40,497 39,416 I'm 1,085,486,150
Mortgage Pass•Thrus
Federal Home Loan MorlBuge Corporation 39,845 39,416 429 98,761,927 '
Federal Home Loan Mortgage Co'pniation 39,873 39,416 457 370,441,111
Fedcml NO=Loan Mortgage Corporation 39,904 19,416 488 109,579,575
Federal Flonic Taim Mortgage Corporation 39,965 39,41E 549 169,744,305
Federal Home Loan Mortgage Coi potation 40,057 39,416 641 221,740,470
Fedcval Hume Loan Mortgage Corporation 40,097 39,416 671 188,327,638
Fcdctal FTome Lprn MortIpge Corporation 40,087 39,416 671 265,09G 217
Federal National Mortgage A;son.won 40,179 39,416 763 440,691,175 �
federal National Mori Association 40,2I0 39,41E 794 496,612,977
Federal No=Loan Mortgage Corporation 40,210 39,416 794 329,5 L1,772
Federal National Mortgage Aywgiatmn 40,239 39,416 8Z2 296,424,174 'I
rcdeml Home Loan Mortgage Corparaton 40,299 39,416 883 688,898,543 '
Federal Home Loan Mortgage Corpomvon 40,422 39;t16 I.006 423,344,518
fedeml National Mortgage Associaton 40.452 39,416 1,036 233,652,064
Federal Home Loam Uank 40,476 39,416 1,060 567,048,323 l
I
U.S.Gov't Agency$ecurj4ey
I ederal Home Loan Bank 39,849 39,416 433 433,000,000
Federal dome Loan Boni: 39,854 39,416 438 438,000,000
Federal Home Loan Bank 39,371 39,41E 455 455,000,000
Federal Home Loan Mortgage Corporation 39.918 39,416 502 496,61M60
Federal Home Loan Bank 40,011 39,416 595 0
p Federal National Mortgage Association 40,050 39,416 634 629,898,020
p l•edeml National Mortgage Associadon 40,093 39,416 677 660,834,692
p Federal Home Loan Mortgage Corporation 40,112 39,416 696 693,925,000
d Federal Farm Credit Bank 40,135 39,416 719 719,000,000
�. Federal Home Loan Bank 40,142 39,416 726 363,000,000 I
+V Federal l-Tome Loan Bank 40,14E 39,416 732 732 000,000 i
Cederal National Mortgage ASomauin 40,175 39,416 759 756,798,900
Federal Home Loan Bank 40.231 39,416 815 815,000,000 r
1
0ensrcp
12l13/2V0]
Calculation of Weiglrwd Avg Maturay
Mamie Current No.of Days X Cost
Dare Du: Days
Long Term Inyenmem
(3 arts w 5 ear.)
Coipoiatc Notes
Goldman Sachs Group,hie 40558 39,416 1,142 1,126,149,040
i
Mortgage PIN-man 1
Federal Home Loan Mongxge CoMomtmn 40,575 39,416 7,159 549,049,975 1
Fed rd l Inane Lam Corporation 40634 39,416 1.219 477,366,259 1
Federal Home Loan Mortgage Corporauon 40,6(k 39.416 1248 139,692.072
US Gov t Agency Scamper
Fedcml Rem,L..m Bunk 40,527 39,1116 1,111 830,625,263
Cedml Home[Am Bank 40,602 39,416 1,156 1,186,000,000
FcJ<-r,d Nu innd Mmt6nge Association 40,723 39.416 1,309 1,304,601,760 1
Federal Home Lamt Buk 40,735 39,416 1.319 11319,000,000 1
Federal Game Lnan Bank 40751 39,416 1,335 2,670,000,000
Federal Rome Loan Bank 40,751 39,416 1,335 1,335,000,000
Federal Home Loan Baal 40,756 39,416 1,340 2,680,000,000
Federal I lame Lou Morfrnpe Corpomtion 40,v53 39,416 1,537 0 r
Federal Home Loan Mongugc Curpomvnn 41,162 39,116 1,746 1,746,000,000 1
Federal Hume Lour Mortgage Corpombon 41,195 39,416 1,792 1,782,00 ,000 x
Financing Corporation(F1CO) 43,196 39,416 3,780 I,E84,6115,320 r
M
1 o[al Orve:red Cmh 40,765,740,470 V
Torul Lrvcsnnrn0 at Cnet B0,623,tl95
A
WAM it,l)vyx 624 01 �
O �
Q
O
I�
1
k