HomeMy WebLinkAbout9/4/2013 - STAFF REPORTS - 2.G. .\�,?ALMS..
iZ
c
V N
Yt c
Cq��FORN%P• City Council Staff Report
DATE: September 4, 2013 CONSENT CALENDAR
SUBJECT: TREASURER'S INVESTMENT REPORT AS OF
JUNE 30, 2013
FROM: Geoffrey S. Kiehl, Director of Finance and Treasurer
BY: Department of Finance and Treasury
SUMMARY
Attached is the Treasurer's Investment Report as of June 30, 2013. The report
includes the face value and coupon rate (if applicable) of the investments and the
source for the market value estimate. The City's total invested cash is
$116,091,006 plus $19,889,628 in bond issue capital projects, reserve and debt
service funds. The market value of the invested cash is $115,221,741.
RECOMMENDATION:
Receive and File Treasurer's Investment Report as of June 30, 2013.
STAFF ANALYSIS:
The attached 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, debt service and related
funds.
The investments, in type, maturity and as a percentage of the total portfolio, are
in compliance with the existing City Council-approved investment policy.
ITEM NO.
City Council Staff Report
September 4, 2013 — Page 2
Treasurer's Investment Report as of June 30, 2013
The weighted average maturity (WAM) of the portfolio is 69.30 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
Geoffrey S. Kehl, Director of Finance and Treasurer
Attachments: Treasurer's Investment Report
02
CITY OF PALM SPRINGS
TREASURER'S MONTHLY REPORT
SUMMARY OF INVESTMENTS
June 30, 2013
On Call De osits Adiusted Basis Category Total Percentage
Checking Account $ 13,130,987
CalTrust ShortTerm 27,180,345
CalTrust MidTerm 28,196,707
State Pool 15,023 $ 68,523,062 59.03%
Short Term Investments
1 year or less
U.S.Gov't Agencies 45,070,750 45,070,750 38.82%
Medtum Term Investments
I ear to 3 ears
Corporate Notes 1,000,000
Time Deposits 200,000
U.S.Gov't Agencies 0 1,200,000 1.03%
Long erm Investments
3 ear[0 5 ears
Time Deposits 798,600
U.S.Gov't Agencies 498,594 1,297,194 1.12%
$ 116,091,006 100.00%
treasrep
07/22/13
O
W
TREASURER'S MONTHLY REPORT
DETAIL OF INVESTMENTS
June 30, 2013
Par Coupon Malmor,or Yield Adjusted Category (memo only) Prior Qtr.
Value Rate Rejoin Call Date o maton Cost Basis Taml Market\"aloe Source Market Value
On Call Deposits
Checking-Bank of America S N/A N/A AAA open None 13,130.997 8 13J30,987 Bank of Amenca 4472,390
CalTrust ShortTerm• N/A N/A open 0.35% 27,180,345 27,154304 CslTrust 22.16n,999
Caffmat MidT. N/A N/A open D.62% 28,196,707 28,021,069 CalTrust 18,149,193
Local Agenev Incest Fund H1 F) 15,023 variable N/A open 0.244% 15,023 15,029 LAIF I5 02]
68,523,062
Short Term lnv:)"-1,
(1 year or less)
U.S.G.W Agency Scouritia,
Federal Farm Credit Bank 1,000,OW 0.80% N<A 10'23/12 D 80% 0 0 Bank of NY Mellon 1000,050
Federal Farm Credit Bank 1000,000 0,90% N/A H/15/12 090% 0 0 Bank of NY Mellon 999,870
Federal Farm Credit Bank 1,000,0W 0 85% N/A 11/15!12 a 85% 999,000 997,370 Bank of NY Mellon l,W0,060
Federal Farm Credit Bank 2,000 OW 0.92% N/A 12/05,12 0.92% 0 0 Bank of NY Mellon 1,997,990
Federal Home loan Bask 2,000,OW LW% N/A 12,18/12 IOIP/o 1999,000 1,959,360 Bank of NY Mellon 1998,400
Federal Home Loan Mortgage Coparatmo 2,000.600 103% N/A 02/28/13 103% 0 0 Bonk of NY Mellon 0
Federal Home Loan Bank 2,000,OW E10% N/A 03/01/13 LIG% 0 0 Bank of NY Mellon 1999,520
Federal National Mortgage Association 2,0000W 1.10% WA 03/20A3 I Y% 0 0 Bank of NY Mellon 0
Federal Home Loan Bank 2,000,0W 1250% N/A 03/22d3 1.250% 0 0 Bank of NY Mellon =001,140
Federal National Mortgage Association 2,000,OW 1.125% N/A 03/28/13 1.125% 0 0 Bankof NYMcllon 0
Federal National Mortgage Associazion I,000,OW 2.50% N/A 04/19/13 250K O 0 Bank of NY Mellon 1001,120
Federal Fans Crdrl Bank 2,000,0W 1.12% N/A 05/20/6 112% 2,000,000 1960,920 Bank of NY Mellon 2,O01,640
Federal National Mongege Association 2.000,000 1.00% N/A 0NW13 100% 0 0 Bankof N\ Mellon :001960
Federal National Mongaga Associazion 2,000,000 100% N/A 06/07/13 100% 0 0 Bankof NYMcllon ;001500
Federal ll9me Loan Mongege Corporation 1000,OW 100% N/A 0/I1I3 100% 10000W 976,010 BankofNYMe1lon 99]010
Federal Home Loan Mortgage Corporation 1000,OW 105% N/A 07/16/13 105% 2,000,000 1OW750 Bankof NYMcllon 1999.11W
Federal Home Lawn Mongege Coryorazion 5,000,000 200% N/A 0/IA13 2.00% 5,079,750 5,004,050 Bank of NY Mellon 5,029,100
Federal Home Loan Bank 1,000,000 100% N/A 07,30/13 1DO% 1000,0W 9]7,]IO Bank of NY Mellon 998640
Federal Home Loan Bank 1000,000 045% N/A 081109/13 0.45% 1000,OW 9920'X1 Bank of Nl"Mellon 0
Federal Home Loan Bank 1,000.000 1,05% N/A 09/12/13 105% 1000,00 979,090 Bank of NY Mellon 1000,000
Federal Farm Credit Bank 2,000,000 098% N/A Oe.'IS/13 0.98% 1997.000 1,972,080 Bank of NY Mellon 2.W5,240
Federal National Mortgage Association 1000,000 1.00% N/A 08/28/13 1.00% 998 000 982,460 Bankof NY Mellon 1002 400
Federal National Mortgage Aasco ation 2,000.000 1.10% WA 0828/13 1.10% 2000.000 1,97].W Book of NY Mellon 2,006,040
Federal Home Loan Mortgage Coporation 2,000,000 100% N/A 09/20/13 LW% 2,000,000 1,961750 Bank of NY Mellen 2,003,100
Federal Home 1-nan Bank 2,000,000 1.00/. WA 09,120/13 1.00% 1,998,000 1941.240 Bank of NY Mellon 0
Federal Home Loan Mortgage Corporanon 2,000,000 1 04% N/A 09,127/11 1.04% 2,000.000 1,963 980 Bank Of NY Mellon 2003 460
Federal Natural Mortgage Asaociazion 2,000001) 1.0% N/A 0927/13 1.07% 2,000.000 196],]40 Bank ofNY Mellon 2006,720
Federal Home Loan Bank 1,000,000 075% NIA 1129/13 075% 1,000,000 973.160 Bank of NY Mellon 0
Federal National Mortgage Assmoavion 4,OOO,000 103% N/A 0IADI14 1.03% 4,000,W0 3908,800 Bank of NY Mellon 3999,760
Federal Home Loan Mongege Corporation 2,OW,000 1.125% WA 02/24/14 1125% 2000,W0 1983690 Bunkrf NY'Me11an 2.W),520
Federal National Mortgage As Nsation 2000,000 1.10% N/A D3/12/14 1.10% 2,000,000 1961,160 Bank of NY Mellon .009,140
Fadeal Home Loan Mortgage Corporation 2,OW,000 1,20% NIA 03/20/14 120% 2,0W,W0 1952,880 Bank afN)'Mellon I996,250
Federal Home Loan Mortgage Corporation 2,000,000 1.15% N/A 04/25/14 1.15% 2,00,000 1952,860 Book of,N1'Mellon 0
Federal National Mortgage Association 2,00QW0 103% N/A 0521/14 1.03% 2000,W0 1937,240 Bank of NY Mellon 0
Federal Home Loan Bank IOo0,000 0.80% N/A 0,112/14 080% I,OW,WD 974,050 Bank ofNYMcllon D
450]q]5D
treaarm
Q 07122113
rA
TREASURER'S MONTHLY REPORT
DETAIL OF INVESTMENTS
June 30, 2013
Par Coupon Maturity or Yield Adjusted Category (memo only) Prior Qtr.
Value Rate Rating Call Date to Maturity Cot Basis Total Market Value Source Market Value
Medium Term Investments
( I year to 3 years)
Corporate Notes
General Electric Capital Corporation 1,000,000 0.60% AI/AA+ 04/13/15 1,20% 1,000,000 995,080 Bank of NY Mellon 995.040
000,000
Time Deposits
Ally Bank CD 200,000 1.15% N/A 7/27/15 L 15% 200,000 200000 Bank of NY Mellon 200,000
200,000
U.S.Gov't Agency Securities
0
Long Tenn Investment
(3 years to 5 years)
Time Deposits
GE Cap Retail Bank CD 200,000 1.35% N/A 7/20/16 1.35% 200,000 203,015 Bank of NY Mellon 204 986
GE Cap Bank CD 200,000 1.35% N/A 7/20/16 1.35% 200,000 203.015 Bank of NY Mellon 204,986
Goldman Sachs Bank CD 200,000 1.80% N/A 7/25/17 1.80% 198.00 204,530 Bank of NY Mellon 208b46
Discover Bank CD 200,000 1.70% N/A 7/26/17 1,70% 200,000 203,729 Bank of NY Mellon 207,790
798,600
U.S.Gov't Agencv Securities
Financing Corporation(FICO) 500,000 9.80% N/A 04/06/18 9.90% 498,594 682,795 Bank of America 709,910
498,594
$ 116.091,006 $ 115,221 741 S 96.608.446
Total Invested Cash
*Includes the}'allowing deposits of non-City funds: Principal Interest Total
Palm Springs Historical Society 250,000 782 250,782
t..P
o7R2/13
0
cn
TREASURER'S MONTHLY REPORT
MISCELLANEOUS AND TRUST ACCOUNTS
June 30, 2013
Yield Adjusted
Par Value Coupon Rating Maturity to Maturity Cost Basis Cateoory Total
Total Invested Cash $ 116,091,006 $ 116,091,006
$ 116,091,006
Miscellaneous Accounts
Petty Cash 4,000 N/A N/A open None 4,000
Trust&Agency-Bank of America 809,253 N/A N/A open None 809,253
Downpayment Assistance(Housing
Fund)-Bank of America 33,813 0.05% N/A open 0.05% 33,813
Workers Compensation-Bank of America 12,430 N/A N/A open None 12,430
General Liability-Bank of America 30,000 NIA N/A open None 30,000
1930's General Store Museum-Bank of America 6,586 N/A N/A open None 6,586
On-Line Credit Card Fire Inspection Fees 97,304 N/A N/A open None 97,304
-Bank of America
On-Line Credit Card Transportation Permits 7,794 N/A N/A open None 7,794 1,00L179
-Bank of America
Total Cash Deposited $ 117,092,185
treasrep
07/22/13
CD
TREASURER'S MONTHLY REPORT
BOND ISSUE RESERVE, DEBT SERVICE & RELATED FUNDS
June 30, 2013
Par Coupon Yield Adjusted Category (nnno only) Prior Qtr.
Value Rate Ratine Maturity to Maturity Cost Basis Total Market Value Source Market Value
2004/2012 Convention Center
Invesco Government&Agency Private 359,567 variable AAA open 201% 358,567 358,566 Bank of NY Mellon 245,940
Cash 0 0 0 Bank of NY Mellon 112,710
Federal Home Loan Morgtgage Corporation 5,465,000 4.125% N/A 9/27/13 1 93% 5,867,848 5,517,245 Bank of NY Mellon 5,573,152
6,226,415
1991/01 Series B•Housing
Invesco Government&Agency Private 742,452 variable AAA open 0 02% 742,452 742,452 Bank of NY Mellon 742,414
742,452
1994/04 Series A&B/2007A,B,&C
Invesco Government&Agency Private L261,394 variable AAA open 0.01% 1,261394 1,261,394 Bank of NY Mellon 1,261,344
Federal Home Loan Mortgage Corporation 965,000 4.125% N/A 9/27/13 1.93% 1036,134 974,225 Bank of NY Mellon 984,097
Federal Home Loan Mortgage Corporation 571,000 4.125% N/A 9/27/13 1.93% 613,091 576,459 Bank of NY Mellon 582,300
2,910,619
t 998 Airport PFC
Invesco Government&Agency Private 1,351927 variable AAA open 0.01% 1,351,927 1,351927 Bank of NY Mellon 1.103589
Cash 0 0 0 Bank of NY Mellon 37,701
351,927 �I
2001 Assessment District 157/158
Invesco Government&Agency Private 0 variable AAA open 0.00% 0 0 Bank of NY Mellon I
0
2002 Parking Structure
Cash 3 3 3 Bank of NY Mellon 336
Invesco Government&Agency Private 2,127 variable AAA open 0.01% 2,127 2.127 Bank of NY Mellon 2,461
2,130
2004 Assessment District 161
Invesco Government&Agency Private 399,183 variable AAA open 0,02% 399,193 399,183 Bank ofNY Mellon 399,163
399,183
tr asrep
07/22/13
0
TREASURER'S MONTHLY REPORT
BOND ISSUE RESERVE, DEBT SERVICE & RELATED FUNDS
June 30, 2013
Par Coupon Yield Adjusted Category (incmo only) Prior Qir.
Value Rate Ratme Mat ri to Maturitv Cost Basis Total Market Value Source Market Value
2004 Assessment District 162
Invesco Government&Agency Private 159,635 variable AAA open 0,02% 158,635 158,635 Bank of NY Mellon 158 628
159,635
2005 Assessment District 164
Invesco Government&Agency Private 367,721 variable AAA open 0 02% 367.721 367,721 Bank of NY Mellon 367,702
367,721
2006 Airport PFC
Invesco Government&Agency Private 2,746,277 variable AAA open 0 02% 2,746,277 2746,277 Bank of NY Mellon 1.529,821
Cash 0 0 0 Bank of NY Mellon 128,994
2,746,277
2007 Refunding Lease Revenue Bonds
Cash 0 0 0 Bank of NY Mellon 1,418 350
Invesco Government&Agency Private I variable AAA open 001% 1 1 Bank of NY Mellon I
1
2008 Airport PFC Refunding
Invesco Government&Agency Private 32,027 variable AAA open 0.02% 32,027 32,027 Bank of NY Mellon 32,027
Federal Home Loan Mortgage Corporation 603,000 4.125% N/A 9127/13 1.93% 647,450 608.765 Bank ul'NY Mellon 614,933
679,477
Reserve for 2012 Downtown Revitalization Lease Revenue Bond
Invesco Cmvemment&Agency Private 3,188985 variable AAA open 001% 3.188.985 3,188.985 Bank of NY Mellon 3,189923
3,189,985
Funds With Century Golf I,t 15,806 1,115,906 1,115,806 Cemury Golf 1,296,620
1,115,806
Totals 19,989628 19,401,798 $ $1978I017
veasrep
07/22/13
00
TREASURER'S MONTHLY REPORT
CALCULATION OF INVESTMENT LIMITATIONS
June 30, 2013
Allowable Percentages
By Maturity: MinimumVlaximum Current Mo.
1 day to 365 days $8,000,000 N/A $113,593,812
1 year to 3 years 0.00% 50.00% 1.03%
3 years to 5 years 0.00% 30.00% 1.12%
over 5 years N/A N/A 0.00%
By Type of Investment:
Bankers Acceptance - in total N/A 40.00% 0.00%
Bankers Acceptance - single bank N/A 20.00% 0.00°%
Commercial Paper N/A 15.00% 0.00%
Time Deposits N/A 30.00% 0.86%
Corporate Notes N/A 20.00% 0.86%
Money Market Mutual Funds N/A 10.00% 0.00%
Mortgage Pass Thrus N/A 10.00% 0.00%
U.S. Government Agencies N/A 60.00% 39.25%
U.S. Treasury Notes/Bonds N/A N/A 0.00%
treasrep
07/22/13
O
CO
A.O4 p A LM S,p�
iy
c
V N
a
y e
Cq<lFORN�P City Council Staff Report
DATE: September 4, 2013 CONSENT CALENDAR
SUBJECT: TREASURER'S INVESTMENT REPORT AS OF
JULY 31, 2013
FROM: Geoffrey S. Kiehl, Director of Finance and Treasurer
BY: Department of Finance and Treasury
SUMMARY
Attached is the Treasurer's Investment Report as of July 31, 2013. The report
includes the face value and coupon rate (if applicable) of the investments and the
source for the market value estimate. The City's total invested cash is
$109,976,269 plus $36,430,467 in bond issue capital projects, reserve and debt
service funds. The market value of the invested cash is $109,390,889.
RECOMMENDATION:
Receive and File Treasurer's Investment Report as of July 31, 2013.
STAFF ANALYSIS:
The attached 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, debt service and related
funds.
The investments, in type, maturity and as a percentage of the total portfolio, are
in compliance with the existing City Council-approved investment policy.
10
City Council Staff Report
September 4, 2013 — Page 2
Treasurer's Investment Report as of July 31, 2013
The weighted average maturity (WAM) of the portfolio is 74.97 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
Geoffrey S. Riehl, Director of Finance and Treasurer
Attachments: Treasurer's Investment Report
11
CITY OF PALM SPRINGS
TREASURER'S MONTHLY REPORT
SUMMARY OF INVESTMENTS
July 31, 2013
On Call Deposits Adjusted Basis Category Total Percentage
Checking Account $ 7,072,385
CalTrust ShortTerm 27,189,677
CalTrust MidTerm 28,210,981
State Pool 15,032 $ 62,488,075 56.82%
Short Term Investments
(1 year or less)
U.S. Gov't Agencies 44,991,000 44,991,000 40.91%
Medium Term Investments
(1 year to 3 ears)
Corporate Notes 1,000,000
Time Deposits 200,000
U.S. Gov't Agencies 0 1,200,000 1.09%
Long Term Investments
(3 year to 5 ears)
Time Deposits 798,600
U.S. Gov't Agencies 498,594 1,297,194 1.18%
$ 109,976,269 100.00%
ucasrep
08/20/13
H
N
TREASURER'S MONTHLY REPORT
DETAIL OF INVESTMENTS
July 31,2013
Par Coupon MatoraW or Yield Adjnsled Category (mend only) Prior Q0.
Was Rate Rating Call Date to Maturiry Cam Basis Total Markel Value Snort, Market Value
On Call Deposits
Checking-Bade ofAnrenca S N/A N/A AAA open None 7,072,385 S 7,072,385 Bank ofAmeriw 7,072,385
CdT.t ShortTerma N/A N/A open 0.33% 27,189,677 27.19U72 CalTmst 27,154,304
CdT.t MnfT. N/A N/A open 0,58% 28,210,981 28.091.246 CalTmst 28,021,W9
Local Agenry Invest Food(LA1F) 15,032 variable NIA open 0.267% 15,032 15016 LAIF 15,027
62,498.075
Short Term Invesmaents
(1 year a las
sI
U.S.Gov't Age.y Securities
Federal Farm Credit Bads 1,000000 0,85% N/A 11/15,12 0.85% 999,00() 991,530 Bank nfNY Mellon 98i370
Federal Home Loan Bank 2,000,000 1.00% N/A 12/I8A2 1,00% 1,999,000 1967,700 Bank ofNY Mellon 1,959,360
Federal Fann Credit Bank 2,000,000 1.12% N/A 0520A3 1,12% 2,000,000 1966,380 Bank ofNY Mellon 1,960,820
Federal Home Loan Mortgage Corporation 1,000,000 L00% N/A 07/1IJ13 1.00% 1,000,000 979,831) Bank ofNY Mellon 976,010
Federal Hone Loan Mortgage Corporation 2,000,000 1.05% N/A 07116/13 1.05% 2,000,W0 1,965900 Bank ofNY Mellon 1,958,750
Federal Horne Loan Mortgage Corporation 5,W0,W0 2.00% N/A 07/17/13 2.00% 0 0 Bank ofNY Mellon 5,W4,050
Federal Horne Loan Bank 1,000,000 1.00% N/A 07/30/13 1.00% LWO,WO 981.550 Bank cfNY Mellon 977.710
Federal Home Loan Bank 1000,W0 045% N/A 08i09/13 0,45% IOOO,WO 093,700 Bank ofNY Mellon W2.090
Federal Hotne Loan Bank 1,000.000 105% N/A 08/12/13 1,05% I,WO,WO 982,720 Bank ofNY Mellon 9790%
Federal Farm Credit Bank 2,000,000 0,98% N/A O8/15/13 098% 1997,W0 L978,M0 Bank of NY Mellon 1972,080
Federal National Mortgage As.iafioa 1,000,000 LW% N/A O828/13 100% WS.WO W5510 Bank of NY Mellon 982,460
Federal National Mortgage Association 2,000,000 1,10% N/A 08/28/I3 1,10% 2,1)(10,W0 1977.780 Bank of NY Mellon 1971,860
Federal House Loan Mortgage Corporation 2,000,000 1.00% N.IA 09/20,,13 100% 2.WO,WO 1972,020 Bank of NY Mellon 1963750
Federal Home Loan Bank 2,000,000 1.00% WA 0920!13 100% 1998,0*0 1955A40 Bank of NY Mellon 1947,240
Federal Horse loan Mortgage Corporation 2,000,000 L04% N/A 092TI3 104% 2,WO,000 1W2,140 Basil;of NY Mellon 1963990
Federal National Mortgage Association 2,000,000 L07% NIA 0927/13 107% 2,W0,W0 1W3,180 Bank of NY Mellon 1,%7.740
Federal National Mortgage Association 2,000,000 220% N/A 1024/13 2,20% 2,W0,W0 2005,420 Bank ofNY Mellon 0
Federal Home Loan Mortgage Corporation 1,000,000 2.00% N/A IO170.113 2.00% I,000,000 1,003,270 Bank ofNY Mellon 0
Federal Hone loan Mortgage Coporation L000,000 2.05% N/A 10/10/13 205% I,W0,000 1,003,010 Bank ofNY Mellon 0
Federal Hone Loan Bank 1,000,000 075% N/A 1129/13 0,75% I,WOWO 9]7,500 Bank of NY Me11. 973,160
Federal National Mortgage Association 4,000,000 1.03% N/A 01/30/14 1.03% 4,1)0O,W0 3.919.720 Bank ofNY Mellon 3,%8,800
Federal National Mortgage Ass mhon 1,000,000 2.00% N/A OW0114 2.00% IOOO,WO 1,004,250 Bank TNY Mellon 0
Federal Horne Loan Mortgage Corporation 2,000,000 1.125% N/A 0224/I4 L125% 2,W0,W0 1,991,DSO Bank ofNY Mellon 1,98.3,680
Federal National Mortgage Association 2,000,000 1,10% N/A 03/12/14 1,1016 2,WO,W0 1,941,460 Bank ofNY Mellon 1961,160
Federal Hones Loma Mortgage Corporation 2,000,000 1.20% N/A 03r'20/14 1,20% 2,000,W0 1959WO Bank afNY Mellon 1952.880
Federal Horne Loma Mortgage Corporation 2,000.000 115% N/A 0425/14 1.15% 2,00O,00O 1,959,698 Bank ofNY Mellon 1952.860
Federal National Mortgage Associatinn 2,000,000 103% N/A 0521/14 103% 2W0,W0 1,941700 Bank of NY Mellon I937,240
Federal Home Loan Bede 1,000,000 0,80% N/A 06/12.!14 0.80% I,W0,000 978,180 Bank of NY Mellon 974,050
44,991.000
treasrep
08/20/13
r
w
TREASURER'S MONTHLY REPORT
DETAIL OF INVESTMENTS
July 31,2013
Par Coupon Maturity or Yield Adjusted Category (memo only) Pnor Qtr.
Value Rate Rating Call Date to Maturi Cost Basis Total Market Value Source Market Value
Medium Term Investments
(1 year to 3 years)
Corporate Notes
General Electric Capital Corporation 1,000,000 0,60% AI/AA+ 04,11Nl5 1.20% 1,000,000 995350 Bank of NY Mellon 995080
000,000
Time Deposits
Ally Bank CD 200,000 1.15% N/A 7/27/15 1.15% 200,000 200,000 Bank of NY Mellon 200,000
200 000
U.S.Gott Agency Securities
0
Lang Term Investment
(3 years to 5 years)
Time Deposits
GE Cap Retail Bank CD 200,000 1,35% N/A 7/20/16 1.35% 200,000 203,221 Bank of NY Mellon 203.015
GE Cap Bank CD 200,000 1,35% N/A 7/20/I6 1,35% 200,000 203,221 Bank of NY Mellon 203,015
Goldman Sachs Bank CD 200 000 1.80% N/A 7/25/17 1.80% 198.600 204.569 Bank of NY Mellon 204.530
Discover Bank CD 200,000 1.70% N/A 7/26.;17 1.70% 200,000 203,785 Bank of NY Mellon 203,729
798,600
U.S.Gov't Agency Securities
Financing Corporation(FICO) 500,000 9.80% N/A 04/06/18 9.80% 498,594 681..847 Bank of America 682,795
498,594
$ 109,976,269 S 109,390,889 S 109,163,139
Total invested Cash
"Includes the following deposits of non-City funds: Principal Interest Total
Palm Springs Historical Society 250,000 853 250,853
treasrep
OS/80/13
r
TREASURER'S MONTHLY REPORT
MISCELLANEOUS AND TRUST ACCOUNTS
July 31, 2013
Yield Adjusted
Par Value Coupon Rating Maturity to Maturity Cost Basis Category Total
Total Invested Cash $ 109,976,269 $ 109,976,269
$ 109,976,269
Miscellaneous Accounts
Petty Cash 4,000 N/A N/A open None 4,000
Trust&Agency-Bank of America 783,131 N/A N/A open None 783,131
Downpayment Assistance(Housing
Fund)-Bank of America 33,814 0.05% N/A open 0.05% 33,814
Workers Compensation-Bank of America -tS,BS? N/A N/A open None -8,853
General Liability-Bank of America 30,000 N/A N/A open None 30,000
1930's General Store Museum-Bank of America 6,532 N/A N/A open None 6,532
On-Line Credit Card Fire Inspection Fees 104,421 N/A N/A open None 104,421
-Bank of America
On-Line Credit Card Transportation Permits 7,864 N/A N/A open None 7,864 960,910
-Bank of America
Total Cash Deposited $ 110,937,179
treasrep
08/20/13
t�
Cn
TREASURER'S MONTHLY REPORT
BOND ISSUE RESERVE, DEBT SERVICE & RELATED FUNDS
July 31, 2013
Par Coupon Yield Adjusted Category (memo only) Prior Qtr.
value Rate Rating Maturity to MaluriN Cost Basis Total Market Value Source Market Value
2004/2012 Convention Center
Invesco Government&Agency Private 358,573 variable AAA open 0 01% 358,573 358,572 Bank of NY Mellon 358,566
Federal Home Loan Morgtgage Corporation 5,465,000 4.125% N/A 9127/13 1 93% 5,867,848 5,499,484 Bank of NY Mellon 5,517,245
6,226,421
1991/0l Series B-Housing
Invesco Government&Agency Private 859,211 variable AAA open 0.02% 859,211 859,211 Bank of NY Mellon 742,452
859,211
1994104 Series A&B12007A,B,&C
Invesco Government&Agency Private 1,261,409 variable AAA open 0.01% 1,261,408 1,261,408 Bank of NY Mellon 1,261 394
Federal Home Loan Mortgage Corporation 965,000 4.125% N/A 9127/13 1.93% 1,036,134 971,089 Bank of NY Mellon 974,225
Federal Home Loan Mortgage Corporation 571,000 4,125% N/A 9/27/13 193% 613,091 574,603 Bank of NY Mellon 576,459
2,910,633
1998 Airport PFC
Invesco Government&Agency Private 1,177,524 variable AAA open 0.01% I,177,524 1,177,524 Bank of NY Mellon 1351927
1,177,524
2002 Parking Structure
Cash 3 3 3 Bank of NY Mellon 3
Invesco Government&Agency Private 232,202 variable AAA open 0.01% 232,202 232,202 Bank of NY Mellon 2,127
232205
2004 Assessment District 161
Invesco Govemment&Agency Private 399,190 variable AAA open 0.02% 399,190 399,190 Bank of NY Mellon 399,183
399,190
ueasrep
0820/13
H
TREASURER'S MONTHLY REPORT
BOND ISSUE RESERVE, DEBT SERVICE & RELATED FUNDS
July 31, 2013
Par Coupon Yield Adjusted Category (memo onl)) Prior Qtr.
Value Rot Rating Maturityto Maturn Cost Basis Total Market Value Source Market Value
2004 Assessment District 162
Invesco Government&Agency Private 158,638 variable AAA open 002% 158,638 158,638 Bank of NY Mellon 158.635
158,638
2005 Assessment District 164
Invesco Government&Agencv Prvate 367,727 variable AAA open 0 02% 367,727 367,727 Bank ofNY Mellon 367,721
367,727
2006 Airport PFC
Invesco Government&Agency Private 1,059,169 variable AAA open 0 02% 1,059,169 1,059,169 Bank of NY Mellon 2 746,277
1,059,169
2007 Refunding Lease Revenue Bonds
Cash 0 0 0 Bank of NY Mellon 0
Invesco Government&Agency Private 1 variable AAA open 0,01% 1 1 Bank of NY Mellon I
1
2009 Airport PFC Refunding
Invesco Government&Agency Private 32,027 variable AAA open 0.02% 32,027 32,027 Bank of NY Mellon 32,027
Federal Home Loan Mortgage Corporation 603,000 4,125% N/A 9/27/13 1 93% 647,450 606,805 Bank of NY Mellon 608,765
679,477
Reserve for 2012 Downtown Revitalization Lease Revenue Bond
Invesco Government&Agency Private 3,189,039 variable AAA open 0 01% 3,189,039 3.189.039 Bank of NY Mellon 3,188,985
3,189,039
Chevron/CoGen Lease Proceeds
Cash 18,218,851 18,218,851 18,219,851 Deutsche Bank 0
18,218,851
Funds With Century Golf 952,380 952,380 952.380 Century Golf 1,115806
952,390
Totals 36,430,467 35,917,924 b $19,401798
neaarep
O CO/13
f..a i
TREASURER'S MONTHLY REPORT
CALCULATION OF INVESTMENT LIMITATIONS
July 31, 2013
Allowable Percentages
By Maturity: Minimum Maximum Current Mo.
1 day to 365 days $8,000,000 N/A $107,479,075
1 year to 3 years 0.00% 50.00% 1.09%
3 years to 5 years 0.00% 30.00% 1.18%
over 5 years N/A N/A 0.00%
By Type of Investment:
Bankers Acceptance- in total N/A 40.00% 0.00%
Bankers Acceptance-single bank N/A 20.00% 0.00%
Commercial Paper N/A 15.00% 0.00%
Time Deposits N/A 30.00% 0.91%
Corporate Notes N/A 20.00% 0.91%
Money Market Mutual Funds N/A 10.00% 0.00%
Mortgage Pass Thrus N/A 10.00% 0.00%
U.S. Government Agencies N/A 60.00% 41.36%
U.S. Treasury Notes/Bonds N/A N/A 0.00%
[rewrap
08/20/13
h-�
00