Loading...
HomeMy WebLinkAbout10 QUARTERLY INVESTMENT REPORTMEETING DATE: TO: FROM: AGENDA REPORT MAY 5, 2015 JEFFREY C. PARKER, CITY MANAGER Agenda Item 10 Reviewed: City Manager Finance Director PAMELA ARENDS-KING, FINANCE DIRECTOR/CITY TREASURER SUBJECT: QUARTERLY INVESTMENT REPORT FOR THE CITY OF TUSTIN AND THE SUCCESSOR AGENCY FOR THE TUSTIN COMMUNITY REDEVELOPMENT AGENCY SUMMARY: Government Code Section 53646 requires that the Treasurer make an Investment Report to the City Council at least quarterly showing balances by authorized investment and certifying its compliance with the adopted Investment Policy. RECOMMENDATION: Receive and file. DISCUSSION: In compliance with Government Code Section 53646, the attached Investment Report reporting cash and investments for the City of Tustin and the Successor Agency for the Tustin Community Redevelopment Agency for the quarter ending March 31, 2015 is rendered. Other than normal recurring revenues and expenditures there were no significant impacts to cash and investments during the quarter ending March 31, 2015. The weighted average portfolio yield of 0.83% remained the same as the quarter ending December 31, 2014. Pamela Arends-King Finance Director/City Treasurer Attachment: March 31, 2015 Quarterly Investment Report CITY OF TUSTIN and THE SUCCESSOR AGENCY FOR THE TUSTIN COMMUNITY REDEVELOPMENT AGENCY Fw g :. w 11 CITY OF TUSTIN and THE SUCCESSOR AGENCY FOR THE TUSTIN COMMUNITY REDEVELOPMENT AGENCY DISTRIBUTION OF CASH AND INVESTMENTS March 31, 2015 DISTRIBUTION OF CASH AND INVESTMENTS Total Investments as of 0313112015: $184,866,376 US Treasury $29,949,837 —16.20% Liquid (Daily) $47,234,759 Corporate_ Bonds $16,369,289 8.85% Negotiable Certificate of Deposit $12,152,000 6.57% Municipal Bonds $2,006,632 1.09% I DISTRIBUTION OF CASH AND INVESTMENTS Total Investments as of 0313112014: $154,888,422 US Treasury 22,914,961 1 A 749A i Corporate Bonds $9,013,228 5.82% Negotiable Certificate of Deposit $5,701,290 3.68% �Municlpal Bonds $1,004,390 0.65% ral Agencies $40,438,333 26.11% CITY OF TUSTIN and THE SUCCESSOR AGENCY FOR THE TUSTIN COMMUNITY REDEVELOPMENT AGENCY PORTFOLIO WEIGHTED AVERAGE March 31, 2015 800 700 600 500 400 300 200 100 WEIGHTED AVERAGE PORTFOLIO LIFE (DAYS) 0 oti" otiti otic otic' otic oti" otic otic oti° oti°` oti° otic' o�ti o�ti ti�ti ti�ti o�ti o�ti 4'v ti�ti 6T 6'v ti\'ti ti�ti 0�3 titi\� b\3 0\3 r5\3 titi�� b\3 -Cz=-Weighted Average Portfolio Life (Days) 2 WEIGHTED AVERAGE PORTFOLIO YIELD (%) vs. BENCHMARKS 1.00% 0.90% - — 0.80% i ivi 0.70sa 0.60% J- 0.50% 0.40% 0.30% 0.20% -- 0.10% -- - - 0.00% + N N a .-1 N N m -i .-i .-a M .-r Cr) ,-i m .-1 � .1 a ,rt a u9 . q 0 0 N N 0 0 0 N N N 0 N 0 N 0 0 N N 0 N 0 N 0 N 0 N -4 o o M M \ \ m m M \ \ \ M \ M \ M m \ M \ M \ M \ m \ M l0 rn M l0 01 m M l0 Ol M Tustin Weighted Average Portfolio Yield (%) Treasury Yield (24 -month Daily) (%) -t-LAIF Yield (%) CITY OF TUSTIN and THE SUCCESSOR AGENCY FOR THE TUSTIN COMMUNITY REDEVELOPMENT AGENCY DISTRIBUTION OF INVESTMENT LIQUIDITY and COMPLIANCE WITH INVESTMENT POLICY March 31, 2015 25.0% 20.0'% 15.0% 10.09'0 5.0% 0.0% Liquidity Distribution ---- — — — M Up to l year t 2 years 3years 4 years 5 years ■ > 5 years t T Up to 1 2 years 3 years 4 years 5 years > 5 year years �Gsz> 3 Compliance with Investment Limitations Total % Invested Compli+ Commercial Notes: < 15% of total portfolio 8.85% Yes < 5 years remaining maturity n/a Yes Commercial Paper: <_ 25% of total portfolio 0.00% Yes <_ 270 days remaining maturity n/a Yes If 2:15% of total portfolio, weighted avg must be <_ 90 days n/a Yes Municipal securities: < 15% of total portfolio 1.09% Yes < 5% in one issuer 1.09% Yes Federal agency bonds or notes: < 75% of total portfolio 41.73% Yes <_ 5 years remaining maturity n/a Yes U.S. Treasury securities: <_ 5 years remaining maturity n/a Yes Negotiable Certificates of Deposit < 30% of total portfolio 6.57% Yes Maturity limitations: <_ 5 years maturity n/a Yes 75% of Fiscal Year General Fund Budgeted Expenditures <_ 1 year 102.06% Yes Commercial Paper and Commercial Notes: < 5% of total portfolio in one issuer 3.33% Yes CITY OF TUSTIN and THE SUCCESSOR AGENCY FOR THE TUSTIN COMMUNITY REDEVELOPMENT AGENCY CORPORATE BOND RATINGS March 31, 2015 Berkshire Hathaway Finance Global Sr Unsecured Toyota Motor Credit Corp Domestic MTN Sr Unsecur Berkshire Hathaway Finance Global Sr Unsecured Royal Bank of Canada BB&T Corporation JPMorgan Chase & Co Global Sr Unsecured John Deere Capital Corp Wal-Mart Stores Inc. Toyota Motor Credit Corp Domestic MTN Sr Unsecur 084664BX8 $2,000,000 Rating at Purchase AA Current Rating Moody's S&P Fitch Compli Aa2 AA A+ Yes 89233P5S1 2,000,000 AA- Aa3 AA- A Yes 084670BD9 4,000,000 AA Aa2 AA- A+ Yes 78019UD20 1,000,000 Aa3e Aa3 AA- AA Yes 05531FAM5 1,000,000 A2 A2 A- A+ Yes 46625HJG6 2,000,000 A A3 A A+ Yes 24422ESB6 2,125,000 A2 A2 A A Yes 931142DF7 1,000,000 AA Aa2 AA AA Yes 89236TBP9 1,000,000 A Aa3 AA- A Yes The City's investment policy requires that corporate issuances have at least an 'A' rating from one of the three rating agencies at the time of purchase. 4 CITY OF TUSTIN and THE SUCCESSOR AGENCY FOR THE TUSTIN COMMUNITY REDEVELOPMENT AGENCY INVESTMENT REPORT INVESTMENT SCHEDULE AS OF: MARCH 31, 2015 (1) DESCRIPTION -LIMITS CUSIP (2) PAR VALUE COUPON/ Dollar Price YIELD TO MATURITY (3) RATING PURCHASE DATE MATURITY DATE (4) ORIGINAL BOOK PRICE (5) CURRENT BOOK VALUE (6) CURRENT MARKET VALUE US TREASURY BILLS/NOTES-No Limit: U.S. Treasury Note 91282BA67 $3,000,000 $99 0.42% 01/08/14 12/31/15 $2,990,165 $2,990,165 $3,000,468 U.S. Treasury Note 912828WF3 3,000,000 $99 0.63% 05/13/14 11/15/16 3,008,803 3,008,803 3,007,734 U.S. Treasury Nate 912828874 2,000,000 99 0.64% 02/12/15 02/15/17 2,005,148 2,005,148 2,003,282 U.S. Treasury Note 912828874 5,000,000 $99 0.64% 11/05/14 02/15/17 5,005,048 5,005,048 5,008,205 U.S. Treasury Note 912828WP1 5,000,000 $99 0.92% 06/11/14 06/15/17 4,993,479 4,993,479 5,026,170 U.S. Treasury Note 912828TGS 5,000,000 $99 0.58% 07/31/12 07/31/17 4,979,333 4,979,333 4,980,860 U.S. Treasury Note 912828/398 2,000,000 $99 1.06% 09/16/14 06/15/17 1,996,774 1,996,774 2,013,750 U.S. Treasury Note 912828TWO 3,000,000 $99 1.05% 07/14/14 10/31/17 2,975,523 2,975,523 2,999,766 U.S. Treasury Note 912828U37 2,000,000 $99 1.04% 11/24/14 01/31/18 1,995564 1,995,564 2,001,718 $30,000,000 $29,949,837 $29,949,837 $30,041,953 FEDERAL AGENCIES .75% Limit: Freddie Mac 3134G54C6 2,000,000 $100 0.50% AAA 04/28/14 05/20/16 2,000,000 2,000,000 2,000,026 Freddie Mac Global Bond 3134GSGE9 3,000,000 $100 0.57% AAA 08/26/14 08/26/16 3,000,000 3,000,000 3,000,613 Federal Home Loan Bank US Domestic 313370TWS 4,000,000 $102 0.64% Aaa 08/25/14 09/09/16 4,146,929 4,146,929 4,087,724 Freddie Mac Global Bond 3134GSHA6 3,000,000 $100 0.70% AAA 09/14/14 09/19/16 3,000,000 3,000,000 3,000,858 Freddic Mac 3134G5LS2 2,000,000 $100 0.60% AAA 11/17/14 11/17/16 2,000,000 2,000,000 1,996,176 Freddie Mac Global Band 3134GSSB2 3,000,000 $100 0.75% AAA 12/19/14 12/19/16 3,000,000 3,000,000 2,999,263 Freddie Mac 3134G5VG7 2,000,000 $100 0.78% AA+ 12/29/14 12/29/16 2,000,000 2,000,000 2,002,320 Freddie Mac 3134G5AQ8 2,000,000 $100 0.70% AAA 06/11/14 12/30/16 2,000,000 2,000,000 2,000,574 Freddie Mac 3134G54B8 3,000,000 $99 0.90% AAA 04/28/14 02/15/17 3,000,000 3,000,000 3,002,263 Freddie Mac 3134G6AY9 3,500,000 $100 0.70% Aaa 02/17/15 02/17/17 3,500,000 3,500,000 3,500,969 Federal Home Loan Bank Global Bond 313OA27EO 2,000,000 $100 0.80% Aaa 06/30/14 03/24/17 2,000,000 2,000,000 2,002,360 Federal Home Loan Bank 313OA3ML5 2,000,000 $100 0.75% Aaa 12/30/14 03/30/17 2,000,000 2,000,000 1,998,630 Federal Farm Credit Bank 3133EELS7 1,000,000 $100 0.88% Aaa 01/27/15 07/27/17 1,000,000 1,000,000 999,623 Federal Home Loan Bank Global Bond 3130A4BE1 2,000,000 $100 1.05% AA+ 02/25/15 08/25/17 2,000,000 2,000,000 2,004,768 Fannie Mae 3135GOPD9 6,000,000 $99 1.09% AAA 02/10114 09/27/17 5,015,765 5,015,765 4,980,950 Federal Home Loan Bank US Domestic 3130AIGZ5 2,000,000 $100 1.35% Aaa 04/17114 10/17/17 2,000,000 2,000,000 2,000,776 Feddle Mae 3134GSMP7 2,000,000 $100 1.13% AAA 11/03/14 11/03/17 2,000,000 2,000,000 2,001,398 Federal Home Loan Bank - US Domestic 313OA44P4 2,000,000 $100 1.00% AAA 02/27/15 11/27/17 2,000,000 2,000,000 2,004,656 Federal Home Loan Bank- US Domestic 3130AOWLO 1,000,000 $100 1.20% Aaa 02/28114 11/28/17 1,000,000 1,000,000 1,000,103 Fannie Mae 3136GOTDS 1,000,000 $99 1.00% AAA 07/21/14 12/28/17 994,594 994,594 997,196 Fannie Mae 3136G23B1 2,000,000 $100 1.30% AAA 08/15/14 02/15/18 2,000,000 2,000,000 2,004,322 Federal Farm Credit Bank 3133EDQM5 2,000,000 $100 1.11% Aaa 02/20/15 02/20/18 2,000,000 2,000,000 2,003,508 Fannie Mae 3136GIDGI 2,000,000 $99 1.05% AAA 07/01114 02/27/18 1,994,233 1,994,233 1,985,172 Federal Home Loan Global Bond 31338ZA94 1,500,000 $98 1.25% Aaa 12/19113 02/28/18 1,496,781 1,496,781 1,501,127 Freddie Mac 3134G35Y2 2,000,000 $99 1.17% AAA 03/13/14 03/12/18 1,986,065 1,986,065 2,001,136 Federal Farts Credit Bank 3133EELNS 3,000,000 $100 1.23% Aaa 01/20/15 04/23/18 3,000,000 3,000,000 2,997,051 Federal Farts Credit Bank 3133EDL75 1,000,000 $100 1.41% AAA 05108/14 05/08/18 1,000,000 1,000,000 1,001,195 Freddie Mac 3134G46D5 2,000,000 $99 1.29% AAA 06/03/14 06/12/18 2,004,400 2,004,400 1,996,120 Fannie Mae 3136G2B71 1,000,000 $100 1.40% AAA 12122/14 6/22118 1,000,000 1,000,000 1,001,975 Federal Home Loan Bank Global Bond 313381U60 2,000,000 $99 1.15% Aaa 07/14/14 07/25/18 1,990,797 1,990,797 1,994,106 Fannie Mae 3136GOSP7 250,000 $99 1.45% AAA 06/03/14 10/30/18 249,485 249,485 250,064 (4) (5) (6) YIELD ORIGINAL CURRENT CURRENT (1) (2) COUPON/ TO (3) PURCHASE MATURITY BOOK BOOK MARKET DESCRIPTION -LIMITS CUSIP PAR VALUE Dollar Price MATURITY RATING DATE DATE PRICE VALUE VALUE FEDERAL AGENCIES - 75% Limit: (continued) Federal Farm Credit Bank 3133EDN81 1,000,000 $100 1.85% AAA 06/12/14 06/12/19 1,000,000 1,000,000 1,002,376 Freddie Mac 3134G57A7 2,000,000 $100 1.80% AAA 06/26/14 06/26/19 2,000,000 2,000,000 2,006,706 Freddie Mac 3134GSEQ4 1,000,000 $100 2.00% AAA 08/21/14 08/21/19 1,000,000 1,000,000 1,002,132 Federal Home Loan Bank US Domestic 3130A3NA8 1,000,000 $101 2.00% Ass 12/02/14 09/17/19 1,013,460 1,013,460 1,008,338 Freddie Mac 3134G3N97 1,750,000 $99 1.55% Asa 02/05/15 10/10/19 1,754,010 1,754,010 1,745,160 Freddie Mac Global Bond 3134G3V72 2,000,000 $99 1.66% AAA 03/27/15 11/21/19 2,007,340 2,007,340 1,992,146 Federal Home Loan Bank (Step Up) 3130A4CB6 2,000,000 $100 1.25% AAA 02/27/15 02/27/20 2,000,000 2,000,000 2,004,604 $77,000,000 $77,153,859 $77,153,859 977,078,364 MUNICIPAL BONDS -15 % Limit: California St Txabl- General Obligation UNLTD 13063CPN4 $2,000,000 $100 1.15% Aa3 12/04/14 11/01/17 $2,006,632 $2,006,632 $1,997,680 $2,000,000 $2,006,632 $2,006,632 $1,997,680 NEGOTIABLE CERTIFICATES OF DEPOSITS - 30% Limit - FDIC Insured Merrick Bank 59012Y3T2 248,000 $100 0.60% 300 06/21/13 06/22/15 248,000 248,000 248,195 Fanners & Merchant Bank TN 30246ACK2 248,000 $100 0.40% 190 06/27/13 06/26/15 248,000 248,000 248,203 First General Bank 320337AP3 248,000 $100 0.40% 296 06/26/13 06/26/15 248,000 248,000 248,207 Fox Chase Bank 35137QAP9 248,000 $100 0.40% 209 06/27/13 06/26/15 248,000 248,000 248,203 Lake Forest Bank & Trust 509685EQ2 248,000 $100 0.45% 283 06/28/13 06/29/15 248,000 248,000 248,207 North Shore Community Bank 662326BVB 248,000 $100 0.45% 217 06/28/13 06/29/15 248,000 248,000 248,212 Tradition Capital Bank 89269FBK0 248,000 $100 0.40% 203 07/03/13 07/02/15 248,000 248,000 248,216 Medallion Bank of Utah 58403BO33 248,000 $100 0.50% 300 06/26/14 12/28/15 248,000 248,000 248,006 Satre National Bank 78658QEP4 248,000 $100 0.55% 196 08/16/14 02/16/16 248,000 248,000 247,994 Enerbank USA 29266NASO 248,000 $100 0.65% 300 07/24/14 08/01/16 248,000 248,000 247,942 First National Bank Paragould 32114LAG4 248,000 $100 0.65% 294 07/24/14 08/01/16 248,000 248,000 247,942 TCF National Bank 872278GD2 248,000 $100 0.70% 230 07/24/14 08/01/16 248,000 248,000 248,105 Telmer Bank & Trust 87482VAA3 248,000 $100 0.70% 163 08/06/14 08/08/16 248,000 248,000 248,094 Flushing Bank 34387AAJ8 248,000 $100 0.70% 216 08/16/14 08/15/16 248,000 248,000 248,082 Great Southern Bank 39120VRK2 248,000 $100 1.00% 200 08/28/14 02/28/17 248,000 248,000 248,241 BMW Bank North America 05668p6w2 248,000 $100 1.00% 261 03/14/14 03/14/17 248,000 248,000 248,918 Ally Bank 02006LDPS 248,000 $100 1.00% 261 03/17/14 03/27/17 248,000 248,000 248,799 Barclays Bank/Delaware 06740KGE1 248,000 $100 1.05% 300 04/14/14 04/18/17 248,000 248,000 248,721 First Savings Bank 33621LAZ6 248,000 $100 1.10% 267 08/21/14 08/21/17 248,000 248,000 247,718 Provident Bank 743837BNS 248,000 $100 1.05% 239 08/21/14 08/21/17 248,000 248,000 247,498 Spring Bank 849430AC7 248,000 $100 1.00% 294 08/22/14 08/22/17 248,000 248,000 247,489 First Bank of Highland 319141CG0 248,000 9100 1.10% 190 08/27/14 08/28/17 248,000 248,000 247,497 Homebanc 43738AFQ4 248,000 $100 1.10% 149 08/27/14 08/28/17 248,000 248,000 247,497 Highland Bank 429882EKS 248,000 $100 1.05% 143 08/29/14 08/29/17 248,000 248,000 247,488 Synovus Bank 87164DFK1 248,000 $100 1.15% 223 08/29/14 08/29117 248,000 248,000 247,781 Traditions Bank 89269CBJ0 248,000 $100 1.20% 229 07/18/14 01/18/18 248,000 248,000 248,470 Middleton Community Bank 596689EA3 248,000 $100 1.25% 252 07/09/14 02/09/18 248,000 248,000 248.535 Marlin Business Bank 57116AJE9 248,000 $100 1.45% 300 12/16/14 06/25/18 248,000 248,000 248,431 Third Federal Savings 8 Loan 884130AZ1 248,000 $100 1.25% 224 02/13/15 08/13/18 248,000 248,000 260,218 Wells Fargo Bank 94986TNE3 248,000 $100 1.83% 262 08/30/13 08/29/18 248,000 248,000 250,275 Sallie Mae Bank/Salt Lake City 79WORA5 248,000 $100 2.15% 300 10/30/13 10/30/18 248,000 248,000 253,284 HSBC Bank USA 40434AJV2 248,000 $100 1.25% 250 04/07/14 04/25/19 248,000 248,000 244,900 First Capital Bank 31944FBH2 248,000 $100 1.50% 166 01/14/15 05/28/19 248,000 248,000 250,748 GE Capital Retail Bank 36160KL60 248,000 $100 2.00% 300 05/27/14 05/30/19 248,000 248,000 250,492 Discover Bank 2646712E9 248,000 $100 2.00% 300 07/09/14 07/09/19 248,000 248,000 249,962 American Express Bank FSB Bridgewater Bank Connectone Bank Capital One Bank USA CIT Bank American Express Centruion Bank GE Capital Bank Peoples United Bank Bank of Georgetown Pnvatebank & Trust Co Machias Savings Bank BMO Harris Bank (Step Up) JP Morgan Chase Bank Goldman Sachs Bank USA CORPORATE BONDS - 10% Limit: Berkshire Hathaway Finance Global Sr Unsecured Toyota Motor Credit Corp Domestic MTN Sr Unsecur Berkshire Hathaway Finance Global Sr Unsecured Royal Bank of Canada BB&T Corporation JPMorgan Chase & Co Global Sr Unsecured John Deere Capital Corp Wal-Mart Stores Inc. Toyota Motor Credit Corp Domestic MTN Sr Unsecur DAILY -No Limit Reconciled General Checking Account Ending Balance 0.24% N/A (7) $18,718,045 $18,718,045 YIELD 10,416,746 10,416,746 Local Agency Investment Fund 0.28% N/A ORIGINAL CURRENT CURRENT $47,234,759 (2) COUPON/ TO (3) PURCHASE MATURITY BOOK BOOK MARKET CUSIP PAR VALUE Dollar Price MATURITY RATING DATE DATE PRICE VALUE VALUE 02587CAC4 248,000 $100 1.95% 300 07/10/14 07/10/19 248,000 248,000 249,956 108622EE7 248,000 $100 1.55% 276 01/14/15 07/26119 248,000 248,000 250,781 20786ABA2 248,000 $100 1.55% 219 01/14/15 07/29119 248,000 248,000 260,755 140420QN3 248,000 $100 2.00% 300 11/05/14 11/05/19 248,000 248,000 249,953 17284C2R4 248,000 $100 2.15% 284 11/06/14 11/05/19 248,000 248,000 251,034 02587DWKO 248,000 $100 2.20% 300 12/21/14 11/29/19 248,000 248,000 249,826 36162PFS6 248,000 $100 1.80% 281 01/14/16 01/16/20 248,000 248,000 250,398 71270QLM6 248,000 $100 1.85% 206 01/14/15 01/21/20 248,000 248,000 250,346 06424%BT8 248,000 $100 1.65% 202 01/14/15 01/30/20 248,000 248,000 250,271 74267GUWS 248,000 $100 1.80% 277 01/14/15 01/30/20 248,000 248,000 260,147 554479DS1 248,000 $100 1.65% 254 02/06/15 02106/20 248,000 248,000 260,209 05573JR89 248,000 $100 2.07% 246 02/27/15 02127/20 248,000 248,000 246,402 48125T21_8 248,000 $100 2.00% 206 02/27/16 02/27/20 248,000 248,000 246,867 38148JMVO 248,000 $100 1.95% 287 03/11/15 03/11/20 248,000 248,000 248,213 $12,152,000 $12,152,000 $12,152,000 $12,193,728 0846648%8 $2,000,000 $100 0.60% AA 03/19/14 08/15/16 $2,018,458 $2,018,468 $2,008,936 89233PSSI 2,000,000 $103 0.89% AA- 08/21/14 01/12/17 2,059,442 2,059,442 2,042,458 0846708D9 4,000,000 $102 0.82% AA 06/05/14 01/31/17 4,139,989 4,139,989 4,079,412 78019UD20 1,000,000 $100 1.17% Aa3e 06/16/14 06/16/17 1,002,100 1,002,100 1,001,543 05631FAMS 1,000,000 $99 1.45% A2 02118/15 01/12/18 1,001,430 1,001,430 1,001,736 46625HJGG 2,000,000 $100 1.75% A 02/10/14 01/25/18 2,005,360 2,005,360 2,016,086 24422ESB6 2,125,000 $100 1.17% A2 02/09/15 03/12/18 2,144,865 2,144,865 2,132,095 931142DF7 1,000,000 $99 1.35% AA 11/24/14 04/11/18 994,209 994,209 1,001,219 89236TBP9 1,000,000 $100 2.06% A 07/22/14 07/18119 1,003,436 1,003,436 1,015,949 $16,125,000 Current Totals: $16,369,289 $16,369,289 $16,298,434 Reconciled General Checking Account Ending Balance 0.24% N/A (7) $18,718,045 $18,718,045 Deposits in Orange Co. Investment Pool 0.39% (8) 10,416,746 10,416,746 Local Agency Investment Fund 0.28% N/A 18,099,968 18,099,968 Current Daily -No Limit Total: $47,234,759 $47,234,759 Total: $184,866,376 $184,844,918 CITY OF TUSTIN CASH AND INVESTMENTS Unrestricted General Fund cash balance as of 03131/15 (unaudited) $28,098,063 Semi -restricted cash balance as of 03/31/15 (unaudited) ( Capital Projects, Proceeds from Land Sales, Backbone Infrastructure) 53,390,143 Restricted Cash balances as of 03/31/15 (unaudited) (Water, Special Revenue Funds, Community Facility Districts, Bond Proceeds) 99,196,626 CITY OF TUSTIN CASH AND INVESTMENTS TOTAL: $180,684,831 SUCCESSOR AGENCY FOR THE TUSTIN COMMUNITY REDEVELOPMENT AGENCY CASH AND INVESTMENTS TOTAL.' $4,181,545 PERFORMANCE MEASUREMENT: Weighted Average Days to Maturity: 713 Weighted Average Portfolio Yield: 0.83% Current 24 mo Treasury Equivalent: 0.56% FOOTNOTES: (1) DESCRIPTION -LIMITS reflects the various authorized Investments as documented In the most current adopted Investment policy and the allowable percentage of total portfolio per Investment type. (2) PAR VALUE Is the full value of the security before any discount or premium Is paid at purchase. (3) Highest ratings from Standards 8 Poor's, Moody's or IDC Publishing Inc for bank ratings. IDC ratings are 1 (lowest) to 300 (highest). (4) Original Purchase Price IS the amount paid for securities less any discount plus any premium. (5) Current Book Value Is original cost of securities less receipt of principal payments, net of amortized premiums/discounts. (6) Current Market Value Is the price at which similar securities are currently trading. Current market values are provided by Bank of America and the State Treasurer's Office on all securities or deposits held In safekeeping for the City and the Successor Agency for the Tustin Community Redevelopment Agency. Market value differences are only booked at year end. (7) Earnings allowance on compensating bank balances to offset bank activity charges. Allowance Is included In the Average Yield calculation. The cash balances Include amounts'swepV from account for overnight Investments. (8) Orange County Treasury Money Market Fund rating is AAAm. Orange County Treasury Extended Fund is not rated by sponsor's choice. (9) Investments and earnings on monies held by fiscal agents generally are limited as to type and yield by the bond documents or current IRS codes. CERTIFICATION: We centy that this report tell acts all CRY of Tustin and the Successor Agency for the Tustin Community Red evelopment Agency (SATCRA) pooled Investments. Excluding the Barclays Bank PLC Domestic Sr. Unsecured bond, the Investments represented In this report are in conformity with the currant adopted investment policy of the City of Tustin. The market valves represented in this report ate provided by Custodians and Trustees currently holding securities for the City of Tustin and SATCRA The Investment program herein shown provides sufficient cash flow liquidity to meet the next twelve (12) months estimated expenditures, r. -. This statement is prepared In conformance with Sectilpn 646 of the Government Code. Signed: �Di�'. D d�_,�..� Dan Erickson, Chair, City of Tustin Audit Commission Pamela Arends-King, Finance Director/ City Treasurer (4) (5) (6) YIELD ORIGINAL CURRENT CURRENT (1) (2) COUPON/ TO (3) PURCHASE MATURITY BOOK BOOK MARKET DESCRIPTION -LIMITS CUSIP PAR VALUE Dollar Price MATURITY RATING DATE DATE PRICE VALUE VALUE Restricted Deposits with Fiscal Agents: (9) 1998 RDA Tax Allocation Refunding Bonds N/A $1,689,858 §1,689,858 2010 RDA Housing Tax Allocation Bonds N/A 1,872,598 1,872,598 2010 RDATax Allocation Bonds N/A 2,827,688 2,827,688 2011 Water Revenue Bonds N/A 2,306,4166 2,306,466 2012 Refunding Water Revenue Bonds N/A 861,088 861,088 2013 Water Revenue Bonds NIA 372,013 372,013 CFD041 N/A 761,089 761,089 CFD 06.1 N/A 5,909,731 5,909,731 CFD 07-1 N/A 1,476,413 1,476,413 Total Restricted Deposits with Fiscal Agents: $18,076,944 $18,076,944 FOOTNOTES: (1) DESCRIPTION -LIMITS reflects the various authorized Investments as documented In the most current adopted Investment policy and the allowable percentage of total portfolio per Investment type. (2) PAR VALUE Is the full value of the security before any discount or premium Is paid at purchase. (3) Highest ratings from Standards 8 Poor's, Moody's or IDC Publishing Inc for bank ratings. IDC ratings are 1 (lowest) to 300 (highest). (4) Original Purchase Price IS the amount paid for securities less any discount plus any premium. (5) Current Book Value Is original cost of securities less receipt of principal payments, net of amortized premiums/discounts. (6) Current Market Value Is the price at which similar securities are currently trading. Current market values are provided by Bank of America and the State Treasurer's Office on all securities or deposits held In safekeeping for the City and the Successor Agency for the Tustin Community Redevelopment Agency. Market value differences are only booked at year end. (7) Earnings allowance on compensating bank balances to offset bank activity charges. Allowance Is included In the Average Yield calculation. The cash balances Include amounts'swepV from account for overnight Investments. (8) Orange County Treasury Money Market Fund rating is AAAm. Orange County Treasury Extended Fund is not rated by sponsor's choice. (9) Investments and earnings on monies held by fiscal agents generally are limited as to type and yield by the bond documents or current IRS codes. CERTIFICATION: We centy that this report tell acts all CRY of Tustin and the Successor Agency for the Tustin Community Red evelopment Agency (SATCRA) pooled Investments. Excluding the Barclays Bank PLC Domestic Sr. Unsecured bond, the Investments represented In this report are in conformity with the currant adopted investment policy of the City of Tustin. The market valves represented in this report ate provided by Custodians and Trustees currently holding securities for the City of Tustin and SATCRA The Investment program herein shown provides sufficient cash flow liquidity to meet the next twelve (12) months estimated expenditures, r. -. This statement is prepared In conformance with Sectilpn 646 of the Government Code. Signed: �Di�'. D d�_,�..� Dan Erickson, Chair, City of Tustin Audit Commission Pamela Arends-King, Finance Director/ City Treasurer CITY OF TUSTIN and THE SUCCESSOR AGENCY TO THE TUSTIN COMMUNITY REDEVELOPMENT AGENCY INVESTMENT REPORT INVESTMENT SUMMARY MARCH 31, 2015 Original Current Current Purchase Book Market Total Value Value $29,949,837 $29,949,837 $30,041,953 77,153,859 77,153,859 77,078,364 2,006,632 2,006,632 1,997,680 12,162,000 12,162,000 12,193,728 Allowable Total 16,298,434 18,718,045 Maximum Portion of Percentage DESCRIPTION PAR VALUE Maturity Portfolio of Portfolio U. S. Treasuries $30,000,000 5 yrs No Limit 16.2% Federal Agencies $77,000,000 Syrs 75% 41.7% Municipal Bonds $2,000,000 Syrs 15% 1.1% Commercial Paper $0 S yrs 16% 0.0% Negotiable Certificates of Deposits $12,152,000 NIA 30% 6.6% Corporate Bonds $16,125,000 5yrs 10% 8.9% Cash N/A WA N/A 10.1 Deposits in Orange County Commingled Pool N/A NIA N/A 5.6% Local Agency Investment Fund N/A NIA NIA 9.8 100.0% Restricted Cash with Fiscal Agents ` WA NIA NIA Original Current Current Purchase Book Market Total Value Value $29,949,837 $29,949,837 $30,041,953 77,153,859 77,153,859 77,078,364 2,006,632 2,006,632 1,997,680 12,162,000 12,162,000 12,193,728 16,369,289 16,369,289 16,298,434 18,718,045 18,718,045 18,718,045 10,416,746 10,416,746 10,416,746 18,099,968 18,099,966 18,099,968 $184,866,376 $184,866,376 $184,844,918 18,076,944 18,076,944 18,076,941 $202,943,319 $202,943,319 $202,921,862 PERFORMANCE MEASUREMENT: Weighted Average Portfolio Life (Days): 713 Weighted Average Portfolio Yield: 0.83% Current 24 mo Treasury Equivalent, 0.66% Cash with Fiscal Agents are the Reserve and Construction funds held by Trustees for various City and RDA bond issues. City of Tustin and The Successor Agency for the Tustin Community Redevelopment Agency January 2015 through March 2015 Investment Transactions Description CUSIPN Trade Date Settlement Date ParAmount Principal Accrued Interest Total Purchase Price Maturity Date Cnupon Bate Yield to Maturity First Capital Bank (Negotiable CD) 31944FBH2 01/14/15 01./28/15 $ 248,000 $ 248,000 $ - $ 248,000 05/28/19 $ 0 1.50% Bridgewater Bank (Negotiable CD) 108622EE7 01/14/15 01/27/15 $ 248,000 $ 248,000 $ - $ 248,000 07/26/19 $ 0 1.55% ConneRone Bank (Negotiable CD) 20786ABA2 01/14/15 01/28/15 $ 248,000 $ 248,000 $ - $ 248,000 07/29/19 $ 0 1.55% GE Capital Bank (Negotiable CD) 36162PFS6 01/14/15 01/16/15 $ 248,000 $ 248,000 $ - $ 248,000 01/16/20 $ 0 1.80% Peoples United Bank (Negotiable CD) 71270QLM6 01./14/15 01/21/15 $ 248,000 $ 248,000 $ - $ 248,000 01/21/20 $ 0 1.85% Bank of Georgetown (Negotiable CD) 06424XBT8 01/14/15 01/30/15 $ 248,000 $ 248,000 $ - $ 248,000 01/30/20 $ 0 1.65% Privatebank & Trust Co. (Negotiable CD) 74267GUW5 01/14/15 01/30/15 $ 248,000 $ 248,000 $ - $ 248,000 01/30/20 $ 0 1.80% Federal Farm Credit Bank (Federal Agency Bond) 3133EELNB 01/20/15 01/23/15 $ 3,000,000 $ 3,000,000 $ - $ 3,000,000 04/23/18 $ 0 1.23% Federal Farm Credit Bank (Federal Agency Bond) 3133EEL57 01/20/15 01/27/15 $ 1,000,000 $ 1,000,000 $ - $ 1,000,000 07/27/17 $ 0 0.88% Freddie Mac (Federal Agency Bond) 3134G6AY9 01/26/15 02/17/15 $ 3,500,000 $ 3,500,000 $ - $ 3,500,000 02/17/17 $ 0 0.70% Federal Home Loan Bank (Federal Agency Bond) 3130MBE1 02/12/15 02/25/15 $ 2,000,000 $ 2,000,000 $ - $ 2,000,000 08/25/17 $ 0 1.05% Federal Home Loan Bank (Federal Agency Bond) 3130A44P4 02/04/15 02/27/15 $ 2,000,000 $ 2,000,000 $ - $ 2,000,000 11/27/17 $ 0 1.00% Federal Farm Credit Bank (Federal Agency Bond) 3133EEQM5 02/12/15 02/20/15 $ 2,000,000 $ 2,000,000 $ - $ 2,D00,000 02/20/18 $ 0 1.11% Freddie Mac (Federal Agency Bond) 3134G3N97 02/03/15 02/05/15 $ 1,750,000 $ 1,745,625 $ 8,385 $ 1,754,010 10/10/19 $ 0 1.55% Federal Home Loan Bank (Federal Agency Bond)(Step Up) 3130MCB6 02/12/15 02/27/15 $ 2,000,000 $ 2,000,000 $ - $ 2,000,000 02/27/20 $ 0 2.19% BB&T Corporation (Corporate Bond) 05531FAM5 02/15/15 02/18/15 $ 1,000,000 $ 999,980 $ 1,450 $ 1,001,430 01/12/18 $ 0 1.45% John Deere Capital Corporation (Corporate Bond) 24422ESB6 02/04/15 02/09/15 $ 2,000,000 $ 2,133,585 $ 11,280 $ 2,144,865 03/12/18 $ 0 1.17% Third Federal Savings& Loan (Negotiable CD) 88413QAZ1 01/28/15 02/13/15 $ 248,000 $ 248,000 $ - $ 248,000 08/13/18 $ 0 1.25% Machias Savings Bank (Negotiable CD) 554479DS1 01/14/15 02/06/15 $ 248,000 $ 248,000 $ - $ 248,000 02/06/20 $ 0 1.65% BMO Harris Bank (Negotiable CD) Step Up) 05573JR89 02/11/15 02/27/15 $ 248,000 $ 248,000 $ - $ 248,000 02/27/20 $ 0 2.06% JPMorgan Chase Bank (Negotiable CO) 48125T218 02/11/15 02/27/15 $ 248,000 $ 248,000 $ - $ 248,000 02/27/20 $ 0 2.00% U.S. Treasury Note 912828874 02/11/15 02/12/15 $ 2,000,000 $ 1,999,000 $ 6,148 $ 2,005,148 02/15/17 $ 0 0.65% Goldman Sachs Bank USA (Negotiable CD) 381481MV0 03/11/15 03/11/15 $ 248,000 $ 248,000 $ - $ 248,000 11/21/19 $ - 1.95% Freddie Mac (Federal Agency Bond) 3134G3V72 03/27/15 03/30/15 $ 2,000,000 $ 2,000,000 $ 7,340 $ 2,007,340 02/27/20 $ - 1.66% 10 SALES/MATO RITI ES/CA LLS 11 Purchase Principal Net Amortized Sales/ Call Principal Sale/Maturity/ Gain/(Loss) Premium Coupon Yield to Description CUSIP# Trade Date Maturity Date Date Paramount Amount Call Amount on Principal Interest Rate Maturity Freddie Mac (Federal Agency Bond)(Sold) 3134G3XG0 01/14/15 06/28/19 01/16/15 $2,000,000 $ 1,971,000 $ 1,984,000 $ 13,000 $ - 1.68% 1.68% Federal Home Loan Bank (Federal Agency Bond) (Call) 3130AIG05 03/20/14 04/15/19 01/27/15 $ 1,000,000 $ 1,000,000 $ 1,000,000 $ - $ - 2.07% 2.07% Comenity Capital Bank (Negotiable CO)(Matured) 20033ABL9 D6128/13 01/26/15 N/A S 248,000 $ 248,000 $ 248,000 S - $ - 040% 040% Freddie Mac (Federal Agency Bond)(Call) 3134G5KX2 10/13/14 10/30/19 01/30/15 $1,000,000 $ 11000,000 $ 1,000,000 $ - $ - 2.15% 2.15% California State General Obligation Bond (Matured( 13063CPN4 03/27/13 02/01/15 N/A $ 1,000,000 $ 1,000,000 $ 1,000,000 $ - $ - 0.85% 0.85% Federal Home Loan Bank (Federal Agency Bond) (Call) 3130A2MT0 08/14/14 08/14/14 02/13/15 $ 2,100,000 $ 2,100,000 $ 2,100,000 $ - $ - 1.63% 1.63% Federal Home Loan Bank (Federal Agency Bond) (Sale) 313375RN9 02/24/15 03/11/16 02/25/15 $ 3,000,000 $ 3,028,410 $ 3,018,000 $ - $ 17,716 0.51% 0.51% Farmer Mac (Federal Agency Bond) (Sale) 31315PGTO 02/25/15 09/15/15 02/26/15 $ 5,000,000 $ 5,171,100 $ 5,046,875 $ - $ 124,225 0.63% 0.63% Fannie Mae (Federal Agency Bond) (Sale) 3136G1MF3 12/12/13 11/20/17 03/09/15 $ 5,000,000 $ 4,940,000 $ 4,940,000 5 - $ - 0.85% 0.97% 11