Loading...
102-Investment Portfolio.pdfCity of Cupertino Investment Portfolio December 31, 2011 ACTIVITY DATE COUPON YIELD ADJUSTED MATURITY MARKET UNREALIZED PURCHASE MATURITY DESCRIPTION RATE To Maturity COST VALUE VALUE PROFIT/LOSS SECURITIES MATURED 12/20/10 10/31/11 US Treasury Note 1.00%0.26%2,000,000 2,000,000 2,000,000 0 01/19/11 11/30/11 US Treasury Note 0.75%0.23%3,000,000 3,000,000 3,000,000 0 SECURITIES PURCHASED 11/17/11 08/31/13 US Treasury Note 0.13%0.22%1,996,721 2,000,000 1,996,480 (241) 12/07/11 10/31/13 US Treasury Note 0.25%0.23%3,000,905 3,000,000 3,000,480 (425) CITY PORTFOLIO CASH 12/31/11 Wells Fargo - Workers Comp Checking 16,704 16,704 16,704 0 12/31/11 Wells Fargo - Repurchase Agreements 0.05%0.05%1,530,059 1,530,059 1,530,059 0 1,546,763 1,546,763 1,546,763 0 LAIF 12/31/11 LAIF - State Pool 0.38%0.38%597,516 597,516 597,516 0 MONEY MARKET FUNDS 12/31/11 Wells Fargo 100% Treasury 0.01%0.01%4,157,395 4,157,395 4,157,395 0 4,157,395 4,157,395 4,157,395 0 US TREASURY SECURITIES 01/11/11 01/31/12 US Treasury Note 0.88%0.30%6,002,944 6,000,000 6,003,780 836 02/02/11 02/29/12 US Treasury Note 0.88%0.28%4,003,922 4,000,000 4,005,320 1,398 03/28/11 03/31/12 US Treasury Note 1.00%0.27%1,001,811 1,000,000 1,002,300 489 05/25/11 04/30/12 US Treasury Note 1.00%0.17%1,002,731 1,000,000 1,003,130 399 05/11/11 06/30/12 US Treasury Note 0.63%0.22%1,002,017 1,000,000 1,002,770 753 05/25/11 07/31/12 US Treasury Note 0.63%0.23%1,002,287 1,000,000 1,003,102 816 06/15/11 07/31/12 US Treasury Note 0.63%0.24%1,002,262 1,000,000 1,003,078 816 06/03/11 08/31/12 US Treasury Note 0.38%0.24%1,000,922 1,000,000 1,001,801 879 06/15/11 08/31/12 US Treasury Note 0.38%0.25%2,001,721 2,000,000 2,003,479 1,758 03/28/11 09/30/12 US Treasury Note 0.38%0.52%998,914 1,000,000 1,000,935 2,021 06/15/11 09/30/12 US Treasury Note 0.38%0.26%1,000,860 1,000,000 1,002,885 2,025 06/03/11 10/15/12 US Treasury Note 1.38%0.27%1,008,715 1,000,000 1,009,730 1,015 06/27/11 10/31/12 US Treasury Note 0.38%0.21%2,002,664 2,000,000 2,003,980 1,316 05/19/11 11/30/12 US Treasury Note 0.50%0.36%1,001,260 1,000,000 1,002,576 1,316 06/27/11 11/30/12 US Treasury Note 0.50%0.23%1,002,507 1,000,000 1,003,824 1,318 03/28/11 12/31/12 US Treasury Note 0.63%0.64%999,822 1,000,000 1,004,690 4,868 03/28/11 03/15/13 US Treasury Note 1.38%0.72%1,007,852 1,000,000 1,014,260 6,408 08/25/11 03/31/13 US Treasury Note 0.75%0.19%3,021,046 3,000,000 3,020,850 (196) 05/06/11 04/30/13 US Treasury Note 0.63%0.57%1,000,733 1,000,000 1,005,820 5,087 05/19/11 06/15/13 US Treasury Note 1.13%0.58%1,007,896 1,000,000 1,013,160 5,264 09/26/11 07/31/13 US Treasury Note 0.38%0.20%2,005,628 2,000,000 2,004,760 (868) 11/17/11 08/31/13 US Treasury Note 0.13%0.22%1,996,721 2,000,000 1,996,480 (241) 03/28/11 09/15/13 US Treasury Note 0.75%0.96%996,541 1,000,000 1,008,550 12,009 12/07/11 10/31/13 US Treasury Note 0.25%0.23%3,000,905 3,000,000 3,000,480 (425) 40,072,679 40,000,000 40,121,740 49,061 Total Managed Portfolio 46,374,353 46,301,674 46,423,414 49,061 Average Yield 0.28% Average Length to Maturity (in years) 0.73 TRUST PORTFOLIO MONEY MARKET FUNDS Kester Trust 12/31/11 Wells Institutional Money Mkt Acct 0.07%0.07%48,470 48,470 48,470 0 BOND RESERVE PORTFOLIO Bond Reserve Acct Ambac Assurance Security Bond 1 1 1 Bond Payment Acct Wells Treasury Plus Money Mkt 0.01%0.01%992,572 992,572 992,572 0 Total Bond Reserve Portfolio 992,572 992,572 992,572 0