09 - Laserfiche WebLink

CITY OF PLEASANTON Portfolio Management Page4 Portfolio Details Investments July 31, 2009 Average Purchase Stated YTM YTM Days to Maturity CUSIP Investment Issuer Balance Date Par Value Market Value Book Value Rate 360 365 Maturity Date Federal Agency Issues Coupon 3133XR4U1 3445 FEDERAL HOME LOAN BANK 11/25/2008 2,000,000.00 2,062,500.00 1.991,505.94 3.125 3.255 3.300 678 06/10/2011 3133XU7J6 3460 FEDERAL HOME LOAN BANK 07/16/2009 1,000,000.00 996,562.50 998,910.00 1.125 1.164 1.180 716 07/18/2011 31331Y3P3 3433 FEDERAL FARM CREDIT BANK 07/15/2008 1,000,000.00 1,045,000.00 998,140.00 3.500 3.514 3.563 793 10/03/2011 Subtotal and Average 88,445,558.14 85,455,000.00 87,260,234.74 86,417,411.69 3.005 3.047 306 Federal Agency Issues Discount 313589K51 3557 FEDERAL NATIONAL MORTGAGE ASSN 06/25/2009 1,000,000.00 999,834.00 999,746.67 0.160 0.160 0.162 20 08/21/2009 313589LL5 3547 FEDERAL NATIONAL MORTGAGE ASSN 12/03/2008 2,000,000.00 1,979,035.40 1,975,975.00 1.550 1.586 1.608 38 09/08/2009 313589MT7 3548 FEDERAL NATIONAL MORTGAGE ASSN 12/05/2008 1,000,000.00 990,396.60 988,022.22 1.400 1.432 1.452 69 10/09/2009 313589RB1 3550 FEDERAL NATIONAL MORTGAGE ASSN 03/10/2009 2,000,000.00 1,991,938.00 1,987,303.33 0.780 0.797 0.808 149 12/28/2009 313385RD0 3553 FEDERAL HOME LOAN BANK 03/24/2009 1,000,000.00 996,860.60 995,394.72 0.590 0.602 0.610 151 12/30/2009 313397RN3 3559 FREDDIE MAC 07/29/2009 2,000,000.00 1,997,540.20 1,997,555.00 0.270 0.270 0.274 160 01/08/2010 313385RR9 3554 FEDERAL HOME LOAN BANK 03/26/2009 3,000,000.00 2,989,029.30 2,983,995.00 0.660 0.674 0.683 163 01/11/2010 313589SG9 3551 FEDERAL NATIONAL MORTGAGE ASSN 03/11/2009 2,000,000.00 1,990,181.80 1,984,306.67 0.880 0.899 0.911 178 01/26/2010 3135895K0 3558 FEDERAL NATIONAL MORTGAGE ASSN 07/16/2009 1,000,000.00 998,454.30 998,303.61 0.310 0.317 0.321 181 01/29/2010 313385SR8 3555 FEDERAL HOME LOAN BANK 03/30/2009 2,000,000.00 1,992,457.60 1,988,769.44 0.650 0.663 0.672 187 02/04/2010 313385WH5 3556 FEDERAL HOME LOAN BANK 05/15/2009 2,000,000.00 1,991,167.80 1,989,998.33 0.510 0.519 0.526 275 05/03/2010 Subtotal and Average 16,602,076.63 19,000,000.00 18,916,895.80 18,889,369.99 0.735 0.746 152 Treasury Securities Coupon 912828CS7 2261 U S TREASURY 03/07/2007 1,000,000.00 1,001,020.00 976,562.50 3.500 4.461 4.523 14 08/15/2009 912826057 2311 U STREASURY 09/05/2008 2,757,000.00 2,759,812.14 2,794,047.19 3.500 2.025 2.053 14 08/15/2009 912828CS7 2316 U S TREASURY 12/16/2008 4,329,000.00 4,333,415.58 4,417,947.42 3.500 0.400 0.406 14 08/15/2009 912828CS7 2321 U 5 TREASURY 04/15/2009 3,098,000.00 3,118,832.25 3,150,524.79 3.500 0.157 0.159 14 08/15/2009 912828HB9 2271 U S TREASURY 09/07/2007 1,000,000.00 1,002.812.50 998,750.00 4.000 4.010 4.066 30 08/31/2009 912828HB9 2272 U S TREASURY 09/07/2007 1,000,000.00 1,002,812.50 998,750.00 4.000 4.010 4.066 30 08/31/2009 9128281-189 2312 U S TREASURY 10/21/2008 393,000.00 394,105.31 401,474.06 4.000 1.443 1.463 30 08/31/2009 912828CV0 2274 U S TREASURY 09/18/2007 1,000,000.00 1,003,630.00 987,187.50 3.375 3.995 4.051 45 09/15/2009 912828CV0 2275 U 5 TREASURY 10/02/2007 1,000,000.00 1,003,630.00 989,062.50 3.375 3.907 3.962 45 09/15/2009 912828HD5 2276 U S TREASURY 10/02/2007 1,000,000.00 1,005,900.00 1,000,625.00 4.000 3.913 3.967 60 09/30/2009 912828HD5 2277 U S TREASURY 10/16/2007 1,000,000.00 1,005,900.00 996,406.25 4.000 4.135 4.192 60 09/30/2009 912828HD5 2318 U S TREASURY 03/06/2009 1,000,000.00 1,005,900.00 1,020,234.38 4.000 0.427 0.433 60 09/30/2009 912828CX6 2278 U STREASURY 10/16/2007 1,000,000.00 1,006,170.00 984,531.25 3.375 4.133 4.190 75 10/15/2009 912828CX6 2319 U STREASURY 03/27/2009 2,000,000.00 2,012,340.00 2,033,125.00 3.375 0.364 0.370 75 10/15/2009 912828HF0 2280 U STREASURY 10/31/2007 1,000,000.00 1,008,160.00 998,437.50 3.625 3.656 3.707 91 10/31/2009 912828HFO 2282 U STREASURY 10/31/2007 1,000,000.00 1,008,160.00 997,187.50 3.625 3.721 3.772 91 10/31/2009 Portfolio PLST CC Run Date: 08/18/2009 15:06 PM (PRF_PM2) SymRept 6.41.202b