Loading...
HomeMy WebLinkAboutInvestment Reports October 2012 ------....\ *... 2012 At- Ill II' City of Palm Desert ©elde, xeadttxex G tfneedtmea ui ECONOMIC COMMENTARY The Federal Open Market Committee(FOMC)met on October 25, and took no Capital Markets Team action. The FOMC stated that while the U.S. economy is improving moderately, growth is slow, and the unemployment rate remains high. Fed officials have City Treasurer indicated that they intend to hold interest rates low even after the recovery Paul S. Gibson, C.C.M.T. has strengthened. In other words,the Fed will continue to intervene until economic growth is fast enough to sharply reduce unemployment. The next Deputy City Treasurer FOMC meeting will be on December 11-12. Thomas W. Jeffrey, J.D., M.B.A. Wells Fargo economists are forecasting 1.4%economic growth in 4Q2012, and less than 2%growth in the first half of next year. They believe that the current strength in consumer spending is not sustainable, due to weak income Investment Objectives growth, modest job gains, and weak wage increases. Some of this spending has also been financed by a decline in the saving rate. Lower energy prices The treasurer shall invest all have helped to lessen inflation. Although Wells Fargo believes that there public monies in a manner may be some increase in inflation over the coming quarters, it is thought that that ensures safety of price growth will remain modest enough for the Fed to continue its principal;sufficient liquidity accomodative policy stance. to finance the City's expenditures; and the Europe is in recession, and continues to struggle with its banking and sovereign highest yield possible after debt crises,while China,which is dependent upon exports, is finding that many the previous two objectives of its products are no longer competitive in the international market because of have been met. rising labor and land costs. Yazd S. gikan, ee.m.✓9- City Treasurer Certified California Municipal Treasurer PORTFOLIO STATISTICS STATISTICS OCT-12 SEP-12 AUG-12 JUL-12 JUN-12 MAY-12 Thousands of Dollars Month-End Book Value $ 195,056 $ 198,990 $ 206,754 $ 205,805 $ 216,803 $ 218,086 Month-End Market Value $ 195,071 $ 199,032 $ 206,794 $ 205,845 $ 216,813 $ 218,101 Paper Gain(Loss) $ 15 $ 42 $ 40 $ 40 $ 10 $ 15 Prior Year Book Variance $ (828) $ (6,063) $ 99 $ (1,578) $ (6,478) $ (1,596) Interest Earnings $ 64 $ 64 $ 71 $ 72 $ 75 $ 76 Yield-To-Maturity 0.39% 0.39% 0.40% 0.42% 0.43% 0.43% Weighted Maturity(Days) 30 29 28 40 40 38 Effective Duration 0.04 0.04 0.04 0.05 0.05 0.05 All data as of October 31,2012 PORTFOLIO CHARACTERISTICS October 2012 Dollars in Thousands Maturities Market Value < 1 M $ 167,330 Maturities Distribution <2M 100 95 <3M ___ <6M - 80 - < 1Y 8,729 c 60 <2Y - o <3Y - c a 40 - <4Y - 20 - <5Y - 0 0 05 0 0 0 0 Total: $ 176,059 <1M <2M <3M <6M <1Y <2Y <3Y <4Y <5Y J i. L 1 Credit Quality I Ratings Market Value AAA or Aaa AAA or Aaa $ 94,638 50% AA or Aa 4,698 A 4,027 Unrated AA or Aa Unrated 86,248 46% A 2% Total: $ 189,611 2% Assets Market Value Asset Allocation 1 LAIF County Pool 88,092 25% LAIF 47,282 County Pool WF/LAIF Bond Proceeds 25,411 47% City Loan to RDA 13,555 MTN 8,726 Agencies 0% WF/LAIF Bond CAMP 2,346 Proceeds WF/Bond Proceeds 4,199 13% Agencies - WF/Bond City Loan to Total: $ 189,611 ProceedsCAMP MTN2% 1% 5% RDA \ 7% Month City Yield LAIF Yield Variance �L Performance I Nov11 0.44 0.40 0.04 Dec 0.37 0.38 -0.01 0.5 Jan12 0.40 0.39 0.01 _- - - - - - Feb 0.41 0.39 0.02 -- -- -- - - - - - _ _ Mar 0.45 0.38 0.07 Apr 0.42 0.37 0.05 d 0.3 May 0.43 0.36 0.07 > Jun 0.43 0.36 0.08 Jul 0.42 0.36 0.05 Aug 0.40 0.38 0.02 0.0 . NovllDecJanl2Feb Mar Apr May Jun Jul Aug Sep Oct Sep 0.39 0.35 0.04 Oct 0.39 0.34 0.05 WAIFYiekl DCRy Yield J CITY OF PALM DESERT TREASURER'S OFFICE PAGE 2 OF 3 STATEMENT OF COMPLIANCE October 2012 The investment of the City of Palm Desert securities portfolio is governed by California Government Code Section 53601 and by the Palm Desert Statement of Investment Policy. The City investment policy is more conservative than State law. The Palm Desert Audit, Finance, and Investment Committee, and the Palm Desert City Council review the City investment policy annually. For the month ended October 31, 2012, the City investment portfolio was in compliance with all applicable state and local laws and regulations. The City Treasurer's Office continued to pursue conservative and prudent investment strategies, based upon the stated objectives of safety, liquidity, and yield. Barring unforeseen events,the City Treasury should have sufficient cash to finance City expenditures for the next six months. In addition, portions of the City investment portfolio could be liquidated in order to meet any significant, unexpected cash requirements. Interactive Data Services provided the market value prices for securities in the City investment portfolio. All balances are bank balances. Respectfully submitted, .razds gild an, ee. .9- City Treasurer SUMMARY OF AUTHORIZED INVESTMENTS California Government Code City Investment Policy CA Govt Maximum Maximum Minimum Maximum Maximum Minimum %of City Code Investment Category Maturity Limit Quality Maturity Limit Quality Portfolio 53601(a) Palm Desert Bonds 5 Years No Limit - 53633 Demand Deposits No Limit No Limit No Limit No Limit - 53601(b) U.S.Treasuries 5 Years No Limit 5 Years No Limit - 53601(c) CA State Debt 5 Years No Limit Not Authorized 53601(d) CA Local Agency Debt 5 Years No Limit Not Authorized 53601(e) Federal Agencies 5 Years No Limit 5 Years No Limit - 53601(f) Bankers's Acceptances 180 Days 40% 180 Days 40% A-1 or P-1 - 53601(g) Commercial Paper 270 Days 25% A-1/P-1 270 Days 25% A-1 or P-1 - 53601(h) Negotiable CDs 5 Years 30% 5 Years 30% AA-or Aa3 - 53601(i) Repos 1 Year No Limit 30 Days 20% - 53601(1) Reverse Repos 92 Days 20% Not Authorized 53601(j) Medium-Term Notes 5 Years 30% A 5 Years 30% A 4.6% 53601(k) Money Market Funds 90 Days 20% AAA&Aaa 90 Days 20% AAA&Aaa 2.2% 53601(I) Trust Indenture Debt Not Authorized 53601(m) Secured Bank Deposits 5 Years No Limit Not Authorized 53601(k) Local Government AAA&Aaa AAA&Aaa Investment Pools 90 Days No Limit or Advisor 90 Days 50% (1) or Advisor 47.7% 53601(n) Mortgage-Backed 5 Years 20% A(Issuer)& Not Authorized Securities AA(Security) 16429.1(b) L.A.I.F. No Limit $50MM/Acct No Limit $50MM/Acct 38.3% (2) 92.8% Footnotes: (1) Maximum concentration limit for local agency investment pools, excluding bond proceeds. (2) Total does not include the City Loan to RDA,and cash. CITY OF PALM DESERT TREASURER'S OFFICE PAGE 3 OF 3 TO: FROM: DATE: CITY OF PALM DESERT FINANCE DEPARTMENT INTEROFFICE MEMORANDUM RACHELLE KLASSEN, CITY CLERK NIAMH ORTEGA, RECORDING SECRETARY NOVEMBER 27, 2012 SUBJECT: COMPLIANCE ANALYSIS AND INVESTMENT REPORTS Please find attached the Compliance Analysis and Investment Report which was presented and approved at the recent meeting of the Audit, Investment and Finance Committee for the month of October 2012. Please include the report on the upcoming agenda for review and acceptance by City Council. Also included are the approved Minutes of the October 2012 meeting for acceptance by the City Council. Please feel free to contact me at Ext. 382 if you have any questions. Thank you. nmo Attachment (as noted) CITY COUNCIL ACTION APPROVED DFNIFD RECEIVED.=lP, OTHER MEETING DATE AYES:,-36LInai NOES: Mnile- ABSENT: A l7Y) ABSTAIN:.-radjo''r" VERIFIED BY: /e KJr Original on File with City Clerk's Office kecer 91- ON 1 VERIFIED a / - g /� D.L %��.__ K. Original on file with C..ity Clerk's Office G:\FINANCE\NIAMH ORTEGA\INVESTMENT COMMITTEE\MEMOS\RKLASSENINVREPORT.WPD TO: FROM: DATE: CITY OF PALM DESERT FINANCE DEPARTMENT INTEROFFICE MEMORANDUM RACHELLE KLASSEN, CITY CLERK NIAMH ORTEGA, RECORDING SECRETAR NOVEMBER 27, 2012 SUBJECT: COMPLIANCE ANALYSIS AND INVESTMENT REPORTS Please find attached the Compliance Analysis and Investment Report which was presented and approved at the recent meeting of the Audit, Investment and Finance Committee for the month of October 2012. Please include the report on the upcoming agenda for review and acceptance by City Council. Also included are the approved Minutes of the October 2012 meeting for acceptance by the City Council. Please feel free to contact me at Ext. 382 if you have any questions. Thank you. nmo Attachment (as noted) CITY COUNCILACTION APPROVED DENIED RECEIVED 4 Fi I P_ OTHER MEETING DATE AY Es: 136i5On,.�i,ei 4 rem ner, /.i) I erg NOES: AVYle ABSENT: A )rile ABSTAIN: ki tn9 VERIFIED BY: /eox/r Original on File with City Clerk's Office Ilarn i ,C keeei 91- lc lam° r ON `/ -a013 VERIFIED D BY___R--Jagdij Original on Me with :_'it C1 -,.•k's Office G:\FINANCE\NIAMH ORTEGA\INVESTMENT COMMITTEE\MEMOS\RKLASSENINVREPORT.WPD CITY PORTFOLIO CONCENTRATION LIMITS October 2012 % of Investments Book Value Portfolio CALIFORNIA ASSET MANAGEMENT PROGRAM $ 2,346,324.18 1.24% CITY LOAN TO RDA 13,554,999.95 7.15% WF/L.A.I.F. BOND PROCEEDS 25,410,566.16 13.40% FEDERAL AGENCY -- COUPON 0.00% LOCAL AGENCY INVESTMENT FUND 47,282,029.06 24.94% WELLS FARGO CORPORATE TRUST 4,199,518.92, 2.21% CORPORATE MEDIUM -TERM NOTES 8,710,911.16 4.59% RIVERSIDE COUNTY TREASURER 88,091,734.33 46.46% TOTAL BEFORE CASH $ 189,596,083.76 100.00% PLUS: CASH 0.00% GRAND TOTAL $ 189,596,083.76 (1) 100.00% FOOTNOTE: (1) In the Citv of Palm Desert Comprehensive Annual Financial Report ("CAFR"), both the City of Palm Desert ("City") and the City's external auditor define total investments as demand deposits, investments in various instruments, and investments held in local government investment pools. The concentration percentages shown above were calculated based on that definition. r o 0 a 0a 0 0 0) N CC) N v ) 0 COO 'af O O o O O o O N CO 0 0 oNi cM \e e O NV. 00) N CP N 4 O at 4p rel N NJ 4 to 4 L 0 O o a. N mg, ro 12. Investments co tr-0) 0) Cr) 0 cn N M 25,410,566.16 47,282,029.06 0) CD CO CO u 0 crJ 0) o 0) r` o aCOC CO 0) ID 0 0) LO N 001 COO N O 0)0) N 0) N O n cn V � —O W 00) N N .P'1- N 'R CO 2,346,324.18 0 0 re a Z 5 w � Z O Z ca co U 25,410,566.16 WFIL.A.I F. BOND PROCEEDS 47,282,029.06 LOCAL AGENCY INVESTMENT FUND 4,199,518.92 WELLS FARGO CORPORATE TRUST 0 0 0 Co CORPORATE MEDIUM -TERM NOTES 88,091,734.33 88,091,734.33 RIVERSIDE COUNTY TREASURER 189,596,083.76 189,610,765.11 189,543,172.60 0 O 5,460,168.66 N 195,056,252.42 195,070,933.77 195,003,341.26 Total Cash and Investments C N cC N. W N. coM 0 2 M d a u 0 N c C ca W 0 1- Current Year 195,461,156.19 Average Daily Balance Effective Rate of Return U_ O aE .. N a E.c N > O C p� O U m m 7 OTo ca NE Oy ETo � a° a > C w c E' co O r- a 0 0` 'o c0 CO c c0 00 y >,r (A N N coo p, O.0i -NO N cc N Na3 E C O N 0 > E N 0 p X 'E 0 o c a O c Z O O O E N N 7 c 0_7� o 2 aao a)a _c N N C 0 co c 2 0 cco` EL— N 0 8 c — O_ N N O .2 e 0 0 N a. O 0- .c o E N E— G) a) c Na FL-- 0 .0 .M.T., City Treasurer Reporting period 10/01/2012-10/31/2012 a No fiscal year history available Run Date 11/16/2012 - 0 0 0 2 m A 2 a Book Value Market Value co A a Investment # a N 0 CA ASSET MANAGEMENT PROGRAM N N O 0 N. N. NN O 0 2,338,552.17 .R- 0 r0 (N N. N (0 R M of R to co el M N N 2,338,552.17 O co N. n R 40 0 0 M M N 0 '6 co a) Subtotal and Average CITY LOAN TO RDA 0 O 13,554,999.95 13,554,999.95 CITY OF PALM DESERT N 13,554,999.95 0) 0) N mt 13,554,999.95 13,554,999.95 Subtotal and Average WF/L.A.I.F. BOND PROCEEDS 0 O 25,410,566.16 25,410,566.16 25,410,566.16 LOCAL AGENCY INVESTMENT FUND 0 01 01 SYS1233084 co co O N N 25,410,566.16 25,400,329.59 Subtotal and Average LOCAL AGENCY INVESTMENT FUND O 0 ✓ O 47,282,029.06 47,282,029.06 47,282,029.06 0 N 0 0 } y 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 O 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 O O 0 0 0 N N CO CO 00 CO (0 CO CO (0 CO(0 10 (0 CO (0 (0 (0 < < < < < < < < < < << < < < < < < a" co 0 0 COO 0 0 O 0 h yU 0 0 0 0 N O M O (0 0 0 0 0 (O 0 (O O O 01 O O M 0 0 0 O (0 N O OnO 0 (O o c0 0 0 c ' LO r• r co 0 r 0) co' of co w 0) CO co co coN 0 cn co 0 O O 0 0 0 0 (O ( 0010 ONO MO 0 0 CO 0 0 0 0 (0 0 0 0 0 CO. 0 CO 0 O. 0 00 03 0 0 0 0 00 0 o0 O O co 00 O O (O (0 R r a0 O) 0) co- coMcococon (O 0 0 CO 0 0 0 0 CO V 0 0) 0 0 N C. Cl 0 O O. 0 CO O O. O O 1.17 (0 O C. 0 0 O 0 (O 0 0 OI o Oi n O O O O N O O vi 0 a (O O O O N co(0 r O) O N 00) O co CAD CO a co a 47,266,409.46 Subtotal and Average WELLS FARGO CORPORATE TRUST 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N N N N N N N N N N N N N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ADVANTAGE TREASURY PLUS MMF ADVANTAGE TREASURY PLUS MMF ADVANTAGE TREASURY PLUS MMF ADVANTAGE TREASURY PLUS MMF LL LL LL LL LL LL LL LL LL LL LL LL LL LL N• N N 00 N NN N ON 0 N(n • 7_J 7 7>> 7 7>> 7> J J J J J J J J J J J J J J as a a a a as a a a a a a r>- r rr r >-> r>->- } rr a rea a a a a a a re w > 0 0 0 (00 0 0 0 0 0 0 0 0 CO N N N N N N (n to (n N N CO (n 6 6 ug ug ug ug ug ug 6 6 ace��I-�F�I— - �Fa-cc W W W W W W W W W W W W W W O 0 0 0 ▪ F• a- z Ia- Ia- z la- Ia' z z 1a- z z zzz zzz zzz z z z >> 0 0 0 0 0> 0 0 0 0>> < < ¢ a a a < < < < < < < < F- F; F- H F- I- F- H F- F- h F F- F; I- F- F- H O O N N) O N O N O N (+) O O O O 0 0 0 O O O 0 0 0 0 0 0 0 O O M M (- N R n CO CO CO 0) O) O) 0 0 O 0 r .- .- O Q V V V It C O V V (0 1() (0 (0 CO 0) 0) 0) rnrn 0) a) a) 0) 0)o) 0) rnrn o as co co co (0 co co co(O cc,(O .0 co co (o O (0 0 0 I- F F- H F- I- F- 17 F- F- F 17 I- F; 17 I- F; 17 O O N (7 O N O N O N M O 0 0 0 0 0 0 0 0 0 0 0 o a 0 0 0 0 0 M M 7 N ▪ Y V v v v 0) 0) o 100 100 (00 1O0 r 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) rn v .Cr CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO (0 N E. N 0 W (n V0 (n (n (Q N (n N N N (n CO N 0 (n N 0 0 0 0 0 N 0 0 0 0 0 N N N N N N N Q U 0 PM (PRF_PM2) 7 3 0 Run Date 11 /16/2012 - 22 27 Report Ver 7 3 3b o O O O O O 0 0 0 O O O O O O crop O O OO O O O O O O O O O o O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O ace O O O O O O 0 0 0 goo O O O O O O O 0 0 0 6 0 0 O o O O 0 O O 0 0 O O 0 O O 0 0 O 0 O 0 O 0 0 0 O 0 as co a sakaa� CO 01 CO CO a� CO CO CO CO CO 03 CO CO CO CO a CO 8 2 N cc 8 m Market Value r 4.6 5 N r. C W 0 E N y r' N O C•) O O 0) O O O O 0) O O O C'�) 0 0 0) O u) O aD a v• O V O O V O N W Q% ; Q 7 O V 0 0 0 0 0 0 0) 0) O O O O O O O N u) f. O O M 0 0) 0 0 00 0) N O N O O cO O O O c0 O) CO O 0 0 6 O O O V CO 10 O O O 0) 0) O 00 0 0 CO O O C� Ca C N 10 C) coO'OV_ C) 00) COO ) 0 CC) If) C = ^ 10 .- CO N n N 0 Q N el d g 0 O N C 0 V LL •r 0 t°0 CD O A� ` 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ,t 0 N N N NNN NNNNNNNNNNNNNNNNNNNNNNN C) Y. O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O 00 d. a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 O O 0 C7 0 0 0) 0 0 0 u) V 0) 0 0 OM 00 0) t0 O 0 30 V 0 0 0 0 N 0 V 0 0 0 0 0 0 CO O 03 0 0 0 CO 0 0 0 N u) P O— 0 (0 0 0) 0 0 0 0 0) O N O O() O 0 0(0 10 f0 O O O O O O O 10 10 O O O 0) 0 O O O O cci ( O 00 c0 M co V cq s�l CO N N V •- V c+1 N 1- N 0) rn ch O N r 0 v) 0 0 0) 0 0 0 0 0) o 0 o () o o 0) con o co V. oo 0 0 p 0 O V 0 0 0 0 O O cn 0 0) 0 O. 0 CO 0 0 o N O N 0 c�) 0 30 0 0 0 O N O O cc;CO 0 0 0 Ch rn CO O O O Ch O O O V h O O O 0) ) O O O O c0 O () u) CO CO CO 0 CO 0) 0) O c0 (0 a0 c7 co V M O 0. V N u) a .^-- n N 0) CV O N 4,199,518.92 d N ID d u 0) cCp LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL it LL LL LL LL LL LL LL LL co N CO N N CO t/T CO CO N N N N (n V) N N (A N N N N N (A N N N to U) V) Q) N N crs J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J V' a. a Q. a o_ a a a a a a a a a o_ a a a a a a a a o o. a a a a a Dm mnm re cc cc FFF FF� FFF FFF cc cc cc OFF FFF CD 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1.11 0 0 0 0 0 0 0 0 0 0 0 0 0 y a a a a Q a a a a a a a a a a a a a a a a a a a a a a a cn rrr z rr r rr zr r rr F zF- r zr rzz r I- I-- r zF- z z z z ZZ z z z z z z z z z z z z z z z z z z z z z z z z > > > > > > > > > > > > > > > > > > > > > > ❑ O O ❑ ❑ ❑ ❑ ❑ ❑ ❑ ❑ O ❑ O ❑ O ❑ ❑ ❑ ❑ O O ❑ O O O O ❑ ❑ ❑ a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a Investment # a WELLS FARGO CORPORATE TRUST r F- r F- r r F- F- F- r F- F- r F- r F- F- F- r I-r r 1-7N 6Cn cc)r 00 O) C7 .- N M 4-if) c0 a0 6O M 0 0 O O 0 0 0 0 0 0 0 0 0 0 0 N N v v NI. v v a V' v v'V v v V' StV' V v v v N. v O p 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 OON N N N N N NNOININN NNNNNN N N N NNCV NNN NN r 176 r F- r r r F- r r r r r 170 f- F- N (0 COa U) c0 0 a0 0 0 N c0 V 10 CD W O) 0 C) 0 0 CO 0 0 0 0 0 0 0 0 VD N 0 n n VVVVV V V V V V V V' V' V' V V V N N N N 0 O 0 0 0 0 0 0 0 0 0 0 OCICIOONNINN NNN N N N N N N NNIN N N N NNN NNN CO 0 (0 h 0 cn 0 0 (1) (0 a rn 0 cn 0 (0V) CO V) cn 0 >-rr 3-3->->->-3 rr>. 3-3.->- 3-3-3- 3-3->- 0 (0 V) (/) V) 0 (.0) V) CO CO 0 N CO (/) 0 0 N 0 (./) (/) to SYS22710200-T 22710202-T rr O O 0 0 N N N CO � 22710203-T SYS22710203-T ADVA - rrF-rr 0 0 0 0 0 O 0) m O a0 c0 0) 0) 0) 0) 0) 0) CO ro aO p m CO u) N to u) u) v) C7 (0 N N N N N N SYS23589800-T SYS23589801-T SYS23589802-T SYS23589808-T SYS23589810-T ADVA 23589812-T r r N CA m 0) (0 2 0) 2 0) 0 Subtotal and Average Portfolio CITY a Run Date 11/16/2012 -22 27 PM (PRF_PM2) 7 3 0 Book Value Market Value a 0 0 O • 0 0 4,027,487.13 4,000,000.00 4,683,424.03 4,658,000.00 d w N '- N R O O L O N N ` on 7 a o .- 0 1+01 CO 00 to 0 0 0 0 0 h 10 0 d 0 N 010 N Ec a w > 1° 0 Q m Om ri J a' n < 0 a0 a O • 0 U w au U 0 O w H ISw y _1 o w O0 Z T O F • O Investment # a_ 0 CORPORATE MEDIUM -TERM NOTES v N CO N 36962G4Q4 89233P4H6 Subtotal and Average RIVERSIDE COUNTY TREASURER 0 c0 v O 88,091,734.33 88,091,734.33 88, 091,734.33 POOLED INVESTMENT FUND 0 0 0 O SYS052460 88,091,734.33 88,091,734.33 88,091,734.33 90,487,771.02 Subtotal and Average 189,596,083.76 189,610,765.11 189,543,172.60 195,461,156.19 Total and Average Run Date 11/1612012 - 22 27 } Q C) 0 o0 0 a 0 0 a Book Value Market Value a d Investment # a 0 UNION BANK CHECKING ACCOUNTS 0 0 O O) O O O O 0 0 0 5,111, 589.47 5,111,589.47 5,111, 589.47 CITY OF PALM DESERT MAIN 0 O h 0) t0 0 N - N 00 O o DESERT WILLOW GOLF COURSE RECREATIONAL FACILITIES CORP CO M 0 r- N CSO 0 th 01 Cc) 0 0 Average Balance 195,056,252.42 195,070,933.77 195,003,341.26 195,461,156.19 Total Cash and Investments PM (PRF_PM2) 7 3 0 Run Date 11 /16/2012 - 22 27 U > 0 0) r. pop 0 0 7 el NI. C�) O 0 W 0 0 0 o ri o M E d H TY mj Investments 0) 0) 0 O 0 M 0 () N CO ri 0 CO N 113,599,279.97 113,599,279.97 48,968,028.16 48,968,028.16 0) co r_ co N O 0 0) c' e WF/L.A.I.F. BOND PROCEEDS RIVERSIDE COUNTY TREASURER 5,759,832.40 5,759,832.40 5,759,832.40 CA ASSET MANAGEMENT PROGRAM 0) o co cn o r- m.; 0 0 N O N cri o 0) N (0 0- N csi 2,659,000.00 2,708,230.78 00') 0 CO f) O O N 0 N 0) co Ul0 0 CV N LOCAL AGENCY INVESTMENT FUND ENERGY INDEPENDENT PROGRAM WELLS FARGO CORPORATE TRUST 0 v 0 41 0 O 173,695,496.70 173,695,496.70 173,695,496.70 0 4,198, 376.98 4,198,376.98 co 0 O a. S 0 v 10 0) 177,893,873.68 177,893,873.68 177,893,873.68 Total Cash and Investments 177,581,453.39 Average Daily Balance 0 a c o c0 ! (Ni 0 X ap o <0 o co c0 co o ` > uS 7 U«. a m a d C '0 0- '2 ) Ei E To E c o co rn co`° c m Ewco d13 E 2 t 0 E .e oU N 0 O 0 .? E�° m o L7 CO �U coL'° .. m o c c0 O tcUpp 01 7 U oc`o 0 n O ;-;- E .Z = E N ~ O 0 to c f0 N f0 Eya O I/) 00 U0� E 0 O o N a(5 c c N 0 c O N OCU Q.0 t O Q Effective Rate of Return NOV. 20, 2012 Reporting period 10/01/2012-10/31/2012 No fiscal year history available Run Date 11/16/2012 - 22 32 0 0) a •c w 0 0 CO Market Value 0 0 0 0 0 0 0 0 0 0 AAA AAA AA a 0 0 0 0 0 0 0 0 0 0 O oA 0 a0 o p o 0 0 0 0 0 0 0 0 0 0 0 0 O 15,587,175.53 0(0 1- CO 0)0 (LC)ND Lv (0 .- (0 (O 0 N O a O) V CO N CO 0:, O (O V (0 0) CO ((0 (0CDOn) ((0 CO ( N CO N (D CO (0 O CO (O V N .- CO-' (O (0 . V ((0 0 (0 e- 00) 0 ((7 O (n (n .- (fi (O 0i CV 0 � co.- (O O (O 3 (0 ON) cc0 (v CON00)) ((0 (0 (0 (0 (0 CO N (O CO (O 0 CO (0 V M •- co- co" (0 .- L- N - 15, 587,175.53 4,854,815.05 23,262,691.68 14,624,816.42 r) 0) N O N O) 0 (0 (0 a (0 (O 0) N O (O (0 ( a (On 0 co 0) av Cr; (0. CO (OD MI COY_ (0 M O (0 R 16,621,597.04 16,621,597.04 16,621,597.04 113,599,279.97 113,599,279.97 113,599,279.97 0 48,968,028.16 48,968,028.16 48,968,028.16 v 0 48,968,028.16 48,968,028.16 48,968,028.16 0 5,759,832.40 N 0 0 0) M (0 N N 0 go (0 '0 N ' 2,659,000.00 2,659,000.00 NNN NNN NNN N N N N 0) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NNN NNN NNN N N N N N a a a a a a a a a a Lc) O O (`) M M co CO CO CO CO Cr) CO M a a (0 4) 0 0 0 0 0 0 0 0 0 O 0 O O 0 www www www w N (n CO (n (/) CO N 0) (n N 0 W W W W W W W W W co J J J J -I J J J J J 0 Q Q Q Q Q Q a a a Q y aaa aaa a a a a LL LL LL LL LL LL LL LL Li. LL 0 0 0 0 0 0 0 0 0 0 Investment # WF/L.A.I.F. BOND PROCEEDS U 0 U U 0 0 0 U U U 0 N M( O CO O CO 00)) 0 0 0 0 0 0 0 0 0 0 COMCO) COMCO CO CO CO CO CO CO Cr) CO MCOM N N N N N N N N N N N (0 (O (O ((00 (0 (0 CCOO COOCO 0 0) CO0COOCOY CO CO COOCO r0) COOCO CO CO M CO CO Cr) co co co CO NNN NNN N ND! N 0) 0 V) CO CO 0) CO CO CO } } } } } )- } } } } 0) (/) CO CO CO N CO CO (I) V) 113,813,459.98 Subtotal and Average RIVERSIDE COUNTY TREASURER POOLED INVESTMENT FUND 0 48,962,511.08 Subtotal and Average CA ASSET MANAGEMENT PROGRAM C.A.M.P. POOL (RDA S.A.) n h 5,758,762.08 Subtotal and Average LOCAL AGENCY INVESTMENT FUND L.A.I.F. (RDA S.A.) O (0 O N } ❑ O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 O O O O O O 0 0 0 0 0 O a 0 0 0 0 0 0 O O O O O O 0 of (0 CJ O Tt 0 0 O O O O 00 O O O O O ct 0) (D N O 0 o O 10 0 0 LO Subtotal and Average ENERGY INDEPENDENT PROGRAM CITY OF PALM DESERT Subtotal and Average WELLS FARGO CORPORATE TRUST 0 0 0 0 0 0 N N NNN N 00 0 0 0 0 0 0 0 0 0 0 NTAGE TREASURY PLUS MMF NTAGE TREASURY PLUS MMF ❑ ❑ Q Q ADVANTAGE TREASURY PLUS MMF ADVANTAGE TREASURY PLUS MMF F- F- F- F- F- F- 0 N CA) (O 0 0 0 0 0 0 0 NN NNNV (0 4) N N N O 00 0 0 0 0 0) 0) 0) 0) 0) 0) CO CO O CO CO CO F- H H 1- a!) O O O O O 0 N N N N N V (0 (0 (0 (0 V) (0 00 0 0 0 0 0) CO 0) 0) 0) CO CO CO CO CO CO CO } } } } } } CO 0 0 N N 0 Run Date' 11/16/2012 - 22 32 PM (PRF_PM2) 7.3 0 Report Ver 7 3 3b N T.WJ 0 7 0 a 2 V1 2 PI 000 000 000000000000000000000000000000 000 000 0 0 0 0 0 0 000 000 000 000 0 0 0 0 0 0 000 000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O— U A 0� f0 m m m m ,A;LO m L0 0 m m 0 10 `0 m m `O m m CAm m m m m m m m m co m aa�aaa�a��aa��aa�aaaaa���� 0 132 Bre (0) W O O O O O O ono 0 0 L0 N O 0 n 0 0 O. 0 0 0 0 0 0 0 e) 10 0 0 0 N 0 0 7 0 0 0 0 0 0 0 0 0 0 0 c') O 0 0 V O 0 O 0 0 0 0 O 0 O O O 0 O O O O 0 0 0 iTo O O O O O O O O O O O ) O O O csi co a)O O O O O o O o 0 0 0 O 0) 0 O O O o 0 0 Y N n O 0 0 m } N W m E 0 E N Cs! .a- 0 W O O O O O O ono O O f) N c) O n O O O O O O O O O o) u) O O O oleo 0000000000001000 v o0 0 08 000 000 00)0 000 000 /�/ i o 0 0 0 0 0 0 0 0 0 0� 0 0 o cN O o 0 0 0 0 0 0 0 0 0 0 ai 0 0 0 0 0 0 0 IL as ` N n O C 1 e- COo Cr) vi M c N2=L. .- W .0 V .p d o Dv WW .2 0 0 CO m A 000 000 000 000 000 000 000 000 000 000 000 000 Q /� U13 N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N ii 7 000 000 0 0 0 0 0 0 000 0 0 O 000 0 0 O 000 0 0 0 0 0 0 000 re a a 7 O O O 000 000 000 000 000 000 0.00 000 000 O O O 0.00 O 0 0 0 0 O ono O O O N c0 0 0 0 0 0 0 0 0 0 0 0 0 O) 0 0 0 O 0 0 O O O O O O O O Om 0 0 N n 0 0 V 0 0 0 000 O ro 0) 000 N O 0 O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O O O O O O o 0 O O O O O O O O O O n Market Value W W O) 0 coiii N LL LL LL. LL LL LL LL LL LL LL LL LL LL LL LL LL LL U. LL LL LL LL LL LL LL LL LL LL LL LL co co 0 to V) co co to to co to (i) co (0 V) V) V) V) CO V) 0) V) V) V) V) CO U) V1 V) 7 > 7 7 7 > > > > 7 > > > > 7 > > > = 7 > > > > J J J J J J J J J J J J J J J J J J J J J J J J J J J J J O. a a a a a a a a a a a a a a a a a a a a a a a a a a a a >->- >» >>>- >» >» >->> >» >>-> r>-> >» as aC4 X XX iX CLa a LYa a MCC tY Ma aX tra reCe OD 7 MD 7 OD 7 7 7 DDD 7 OD 7 7 7 7 7 0 7 7 7 7 7 7 a'a' cYw K a'F- z ce a'a' a'- - a'a' CCa' a W M CeCL F- F F F- F F F- F- I- F- I- F- F F F F- F F F I- F F I- F F I- F I- I- ... Li.' W W W W Lai W W W W W W W W W W W W W W W IL W W W W W CD (Li 7 U 00 0 0 0 0 0 0 0 0 0 0 0 0 U 00 0 00 0 00 0 00 0 00 a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a 0 — F F F F F F F F F F F F F F F F I-F I- F F I- F F F I-F F F z z z ZZ ZZZ z ZZ ZZ z z z z z z z z z z z ZZ z ZZ >> >> >>> >>> >> >> >> >> >> >> 00 0 00 0 0 0 0 0 0 O O O 0 00 O 00 0 00 0 0 O O 00 a a a a a a a a a a a a a a a a a a a a a a a a a a a a a 1,470,152.41 Investment # ADVAt ADVANTAGE TREASURY PLUS MMF ADVANTAGE TREASURY PLUS MMF ADVANTAGE TREASURY PLUS MMF ADVANTAGE TREASURY PLUS MMF F; 1- F F H F; F F; F; F; F H F F F F F H F; F F 1- F F F F; F; F F; F F; I- F F F; N M O N c) O N C') O c') (0 O N c') O N r) O N A a O N c") O O 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.. 0 00 000 0 00 0 O O O 0000 V1 U) VI 7 WI V01 N VOI O) KO) 0) 00 N N 10) N CD u0) 0 0 0 0 0 0 0 0 0 n r- n n r CD 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0) 0 0) 0) CO 0) 0) 0) 0 0) 0) 0) 0 0) 0) 0) 0 0 0) 0) 0) 0) 0) 0) 0) 0 0 0) 0) 0 0 0 0 0 0 O CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO 0 0 0 0 0 0 N N N N N N 20007602-T H F; F F F- F- F F F F; F F F F; F F F F I- F F F; F F F h F F F F H IT F F H/ N M 0 N c') O N c') O c%) c0 O N r) O N C') O N M O N C) O N 0 0 0 0 0 0 0 00 0 0 0 000 0 0 0 0 00 0 0 O O 0 0 0 0 0 0 O 0 0 0 0 3 3 O LC) N c0 c0 c0 CO CO CO CO CO CO 0) 0) 0 0) N N N N to (') CO CO c!) of H) c0 CO u) fn O O O N c(1 N O O N O N N O N f0 c0 0 0 0 0 0 0 0 0 0 n n n n n n n 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0) 0 0) 0 0) 0) 0) 0) Of 0) 0) 0 0) 0 0) 0) 0 CO 0) 0 0) 0) 0) 0) 0) 0) 0) 0 0 0 0 0 0 0 a J CO CO CO CO CO CO CO CO CO CO CO CO m CO CO CO CO CO CO CO m CO CO CO CO CO CO CO CO 0 0 0 0 0 0 0 0 (7)N N N N N N N IlJ V) V) V) V) V) V) N V) V) V) V) V) V) V) V) V) V) V) V) V) V) V) V) V) V) co V) co co co coy V) CDN D >» > >>. >-» >» >>-> >» >» >» >» >>> >» >>>- U 3 CO CO CO V) CO CO CO CO CO CO CO V) CO 0 V) V) V) CO CO V) CO CO V) V1 U) V) CO V) (/) V) V) V) V) V) CO V) Portfolio RDAS Run Date.11 a) .c o o) cl a 2 0 c m w 0 E Q y r W o 0 CO 0 0 0 O O) a 0 0 O) M 0 0 0 M I. O aa N O O O O 0 0 0 O) O Q 7 O O O O .- 000 O 00 M 000 000 00.0 O (0 W 0 0 O .- 0 O O O O) O N C N > o 0 o D o n o 0 0 0 ui o o N o 0 0 0 0 0 o W Do 0 0 0 o ri o 0 0 0 )ri o 0 0 .. 61 V' N O O) O .- CV r0) r N M (0 n t` CO y CI a N n W� S a) 0.2 a)o V O Dt .so y 0 co 6' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000 000 0 0 0 0 0 0 0 0 0 0 0 0 Q a `O N N N N N N N N N N N N N N N N N N NNNNNNNNNNNNNNNNNN 000 000 000 000 0 0 O 000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000 C4 d 0. 000 0 0 0 0 0 0 0 0 0 000 000 000 00.0000000000000 0 N 0 0 0 000,000000 0 0 0 0 0 0 0 0 0 O 0 0 000 000 000 000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00.0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ..= 0A CI 0 i Ce d O 0 0 0 CO CO 0 0 0 Of 7 0 0 O M 0 0 0 M 1- 0 e0 N _ 00 0 0 e1. 000 W O 7 0,-0 00 .- O 00 O COO O O to O O O O CO. O O f0 CO 00 O N-O O O O W O N 0 0 0 0 0 N O O O O O U) O O a 0 0 0 O O 0 (O O 0 0 0 0 r) O O O O U) O O V N co ON) Y O O 0 M m Nco - ca 1- 0,10 0 0 00 O) O 0 0 O) V' 0 0 O) M 0 0 O M 1- O N 0 0 0 0 a 000 0) 0,1 0 .- 0 0 0 .- 000 0 0 M 000 0 0 0 0 (O 0 O(0 _ OD 0 0 01-0 000 O) O N 0 0 0 0 0 oi 0 0 0 0 O O N O o 0 O O 0 0 0 00 0 0 0 0 N 0 0 0 0 ui 0 0 NO W V 0 1- co M M n 6On) N . 1� Market Value 07 O) U e N LL U. LL LL LL LL LL LL LL LL LL LL LL LL U. LL LL U LL LL LL U.LL LL U.LL LL LL U. LL LL U. U LL U. (n 0) V) V) (n V) rn V) V) in (n 0) (n cn V) v) rn V) (4) V) V) cn v) V) V) co v) (n V) CO CO CO V) CO CO CO > > > > > > > 7 > > 7 -I MDD DM MMDMMDMDMMM > > M J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J J aaa a a a aaa aaa a a a a a a aaa a a a a a a aaa a O. a a O. a >->->- >r> >->->- >- r>- >-r>- >- >- r >- >- >->->- >- >- r >->->->->-r>>->- C C4 CC C C XXX CLC C C UGC C C C C C C C C C C C C C X C C CLC C DMO DMM DDM DDM MMM DMM 7 MMMMDDMM DDM > > > > > > 666666666666666666 66666666666666666 C C C C C C I C C C C C C C C C C C C C C C C C XCLCCXWCCMCLCLCLCLCC I - I- F- F- F- F- F- F- I- F- F- F- F- F- F- F- F- I- F- F- F- I- F- F- F- F- F- F- I- F- F- F- F- F- F- F- ry W W W WWW WWW UJWW LUWW WWW W W W WWW WWW W W W W W W W W W a CO 0 0 000 000 000 000 000 0 00 000 000 000 000 000 1 z F- z I-- F- H -- II-- F- H Fa- H F- Fa- I-- F- F- Fa- la- Fa- Fa- F- H I-- Fa- F II-- Fa- F z Fa- H H Fa- H H Z Z Z ZZZ Z Z Z ZZZ ZZZ ZZZ Z ZZ ZZZ ZZZ Z Z Z ZZZ ZZZ a a¢ a a¢ a a a a a a a a a ¢aaa ¢ a a a a a a a a a a¢¢¢ a a a > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > <<<<<<<<<<<on <<<<<<<<aaa aaa<<<<<<<<<<<<< Investment # WELLS FARGO CORPORATE TRUST F- 1- F- r) o 0 0 0 (n° (4) a O N N 0N N SYS20007603-T SYS20235900-T SYS20235901-T 20235902-T 20235903-T F- 0 CD 0 0N r) 3 O 0 O M M M 000 NNCV >>- } } V) 0 V) 20300300-T SYS20300300-T 0 0 009 0 SYS20300301-T 20300302-T SYS20300302-T 20300303-T SYS20300303-T E- F- - F- F- 1- 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 el CIM el CO al O 0 0 0 0 0 NN N NNN SYS20300401-T SYS20300500-T 20300501-T 20300502-T 20300503-T M M M 0 0 0 >- V) V) V) 1- F- 0 0 0 0 0 0 00 N N SYS20300504-T SYS20300600-T 20300601-T SYS20300601-T 20300602-T 20300603-T F F- CV 0 0 00 M O 00 NCV N V) V1 V1 20300800-T SYS20300800-T H F- 0 0 co 0 0 O 0 N N F- F- 00 0 0 00 0 0 N V) V) V) 20300803-T SYS20300802-T 0 8 0 F7 F7 F F- F- F- 0E- 0 0 0 0 0 CON (V N N N N N o O alM M M M M U) r) O) CD CD CD0) 0) ON- ) 0 0 0 0 0 000 NNNNNNNN 17 F- F- F- F- Fad F- O o o o 0 0 0 CON NNN N N 0 M M M M M M M O) O) O) O) O) O) 0 0 0 0 0 00 N N N N N N N V) V) V) CO 0 V) CO >- >- >- >- >- >. } V) V) V) CO CO V) V) SYS20975500-T co a ¢a C 0 a Run Date 11 /102012 - 22.32 PM (PRF_PM2) 7 3 0 >- Z r C=1 W m E O C 1 0.)as Nco W C p V .2 m rt 0 20 s°c oa C ° Book Value Market Value 0 0 0 0 O 0 0 0 O 0 O 0 O O O O CO N CO CO a<a a O 0 0 I� 0 0 0 N O O O C) 0) m CO 0 O 1� O 0 O N ti To O O O c7 M Cr; N a 0 N CD r A ssos 0 NNN N O (I; E. O O O O dd n us c� 0 d To 2 N am i 2 2 CO CO tp n 7 7 N CI. 0- ›- Y 7 7 I- I- 0 0 L9 w N ~ Z 2 Q Q 0 0 Q 4 Investment # AD � r � N O o Oo 0 N M 0 0 0 0 0 0 N N N 1- I- N C7 O 0 N N N n 0 0 O. 0 O CT) N W ( 3 N CO CO 1 AD 20975504-T SYS20975504-T Subtotal and Average 173,695,496.70 173,695,496.70 173,695,496.70 177,581,453.39 Total and Average PM (PRF_PM2) 7 3 0 Run Date 11/16/2012 - 22 32 co 0- Aft os ° 0 %- ƒ _ s - _& os $ 0 co 01. ® % © k # k 0 AA \ co, co i ` - � $ \ 0 ° % y c\ CO 1"7 s co $ , 0 To0 ƒ CC 4 t \ it 3 \ % 0 « v Z % £ % U 1 l U W ID m M E `m 1- 0 N O 0 co M co C') 11,437,530.90 11,437,530.90 11,437, 530.90 0 C 0 O O O O 11,437,662.08 11,437,662.08 11,437,662.08 Investments 0 0 2,159,967.38 0) co- N a M G 13,597,629.46 13,597,629.46 Total Cash and Investments 13,519,324.83 Average Daily Balance Effective Rate of Return 0 co c.t c (00 m E D) T " r N U C O co • 2 0) 0) (0 O D7 O co 0 4,2 — c N V7 O 1 N > L co 0. 6 Q Ce a No fiscal year history available fir' a▪ r rn «� a 2 E y N 0w H ' = N c 1 r Q C4 H - (.9 .0 Z .2c o °o =a° t 0 a 0 H ? csi N. Tr cv n 0 N O pO M O co asto O • O M 4) n a Market Value as O CO 0 a Investment # CA ASSET MANAGEMENT PROGRAM Subtotal and Average 11,437,530.90 11,437,530.90 N O N a 0 LOCAL AGENCY INVESTMENT FUND O O O M O 0 N r- N co M O O a N 0 O. LL N C in 2 c g co 11,437,530.90 11,437,530.90 11,437,530.90 11,432,965.65 Subtotal and Average 11,437,662.08 11,437,662.08 11,437,662.08 13,519,324.83 Total and Average Portfolio HA Run Date 11/16/2012 - 22 36 Report Ver 7 3 3b N m lV 0- j M 0 0 } 00 0 O 0 r aU 85 O 2 0 T 0 0 2 Book Value Market Value 1,753,963.38 0 0 0 0 0 co 0 • O • g 0 0 (0 co- o r y « N N CO L Q N N a • as 0 0 a) m 0 rnu 0 LA o i A am d N Investment # a_ V1 CHECKING HOUSING AUTH CHECKING HOUSING AUTH TRUST 0 0 0 0 (n 0 N N (n (O O 0 n V) N N V) V) } } V) N Average Balance 13,597,629.46 13,597,629.46 13,597,629.46 13,519,324.83 Portfolio HA Run Date 11/16/2012 - 22 36