First Quarter 2009 Pisd Investments
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View First Quarter 2009 Pisd Investments as PDF for free.
More details
- Words: 4,674
- Pages: 17
Investment Portfolio Summary For the Quarter Ended March 31, 2009
Prepared By
Plano ISD Quarterly Investment Report Investment Officers’ Certification For the Quarter Ended March 31, 2009
This report is prepared for the Plano Independent School District (the "District") in accordance with Chapter 2256 of the Public Funds Investment Act ("PFIA"). Section 2256.023(a) of the PFIA states that “Not less than quarterly, the investment officer shall prepare and submit to the governing body of the entity a written report of the investment transactions for all funds covered by this chapter for the preceding reporting period.” This report is signed by the District's investment officers and includes the disclosures required in the PFIA. Market prices were obtained from independent pricing sources, including Interactive Data Corporation and Bloomberg L.P. The investment portfolio complied with the PFIA and the District's approved Investment Policy and Strategy throughout the period. All investment transactions made in the portfolio during this period were made on behalf of the District and were made in full compliance with the PFIA and the District's approved Investment Policy.
Page 2 of 17
Plano ISD FIXED INCOME DISTRIBUTION March 31, 2009
Summary Information Totals Par Value Market Value Adjusted Cost Net Gain/Loss Annual Income Number of Issues
599,440,828.94 604,975,486.14 603,979,482.75 996,003.40 12,667,389.64 46
Average Average Average Average
Weighted Averages YTM Maturity (yrs) Coupon (%) Duration
1.360 0.6 2.139 0.6
Distribution by Maturity % Bond Holdings 34.2
Average Average Average Y T M Coupon Duration 1.504 1.371% 0.100
Maturity 0 - 3 Months
Number 18
Mkt Value 206,846,617.69
3 - 6 Months
8
138,180,148.12
22.8
1.167
2.392%
0.364
6 - 9 Months
6
86,868,469.50
14.4
1.155
1.646%
0.630
9 - 12 Months
2
30,346,875.00
5.0
1.346
2.189%
0.937
1 - 2 Years
10
135,555,875.83
22.4
1.446
3.316%
1.235
2 - 3 Years
2
7,177,500.00
1.2
2.139
2.911%
2.049
Page 3 of 17
Plano ISD Portfolio Composition March 31, 2009
Portfolio Composition by Issuer
Portfolio Composition by Security Type
FHLB
Agency Securities 58.9%
26.4% Pie chart w/ Issuer breakdown goes hereFFCB
Commercial Paper 8.4%
3.0%
Commercial Paper 8.4%
Pools & Money Markets 8.0%
TexStar 6.8% FHLMC 25.6%
CD's 24.6%
TexPool 1.2%
FNMA 3.8%
Portfolio Composition by Maturity (Percentage)
CD's 24.6%
Portfolio Composition by Maturity (Amount)
0-3 Months 34.2%
$225 $200
3-6 Months 22.8%
$175 Millions
$150 $125 $100 $75 2-3 Years 1.2%
1-2 Years 22.4%
$50 $25 6-9 Months 14.4% 9-12 Months 5.0%
$0-3 Months
3-6 Months
6-9 Months
9-12 Months
1 - 2 Years
2 - 3 Years
Over 3 Years
Page 4 of 17
Plano ISD Benchmark Comparison March 31, 2009
6.000% Plano Portfolio Month-End Wtd Avg Yld TexPool Monthly Average
5.000%
3-Mo CMT (3-Month Moving Avg) 6-Mo CMT (6-Month Moving Avg) 4.000% 1-Yr CMT (12-Month Moving Avg)
3.000%
2.000%
1.000%
Notes:
Mar-09
Feb-09
Jan-09
Dec-08
Nov-08
Oct-08
Sep-08
Aug-08
Jul-08
Jun-08
May-08
Apr-08
Mar-08
Feb-08
Jan-08
Dec-07
Nov-07
Oct-07
0.000%
1.) Benchmark data for TexPool is the monthly average yield. 2.) CMT stands for Constant Maturity Treasury. This data is published in Federal Reserve Statistical Release H.15 and represents an average of all actively traded Treasury securities having that time remaining until maturity. This is a standard industry benchmark for Treasury securities. 3.) The CMT benchmarks are moving averages. The 3-month CMT is the daily average for the previous 3 months, the 6-month CMT is the daily average for the previous 6 months, and the 1-year CMT is the daily average for the previous 12-months.
Page 5 of 17
Plano ISD DETAIL OF SECURITY HOLDINGS As of March 31, 2009 Security Description Pooled Funds TexSTAR TexPool TexPool Prime FHLB FHLB FNMA FHLB FHLB Disc Note FHLB Bank of America, N.A. CD FNMA Citigroup Funding TLGP (FDIC) FHLB Bank of America, N.A. CD FHLMC Disc Note FHLB Citigroup Funding TLGP (FDIC) FHLB FHLMC GE Capital Corp CP TLGP (FDIC) Bank of America, N.A. CD FHLB FNMA Bank of America, N.A. CD FHLMC FHLB FHLMC Disc Note FHLMC FFCB Disc Note FHLB Disc Note FNMA Bank of America, N.A. CD FHLB FHLB FHLMC FHLB FHLB FHLMC FFCB FHLB FHLMC FHLB FFCB FHLB FFCB FHLB
GRAND TOTAL
Security CUSIP
texstar texpool texprime 3133XSEQ7 3133X4ZC8 31359MK69 3133XQYQ9 313385FA9 3133XQZA3 337119822 31359MVE0 17314GSJ9 3133XFLG9 337109870 313397HE4 3133XRP46 17314GTQ2 3133XREU0 3134A4US1 36161CUL4 337118892 3133XLUM3 31359MU68 337121140 3134A3M78 3133XGNJ9 313397MX6 3128X3K85 313313PK8 313385PR1 31359M2S1 337109871 3133XT3E4 3133XPY57 3128X8LR1 3133MBJA6 3133XKXD2 3128X8LY6 31331GHB8 3133XRN22 3128X4GL9 3133XCUR2 31331VSK3 3133XECU1 31331YG46 3133XR4U1
Coupon
0.594 0.579 0.773 3.400 3.000 4.875 2.500 0.000 2.480 0.620 4.250 0.000 5.250 1.400 0.000 3.000 0.000 2.700 4.250 0.000 1.080 5.125 5.375 1.150 6.625 5.000 0.000 4.125 0.000 0.000 4.625 1.950 1.050 2.750 1.120 7.625 4.875 1.080 2.350 3.500 4.790 4.500 4.875 4.625 2.625 3.125 2.137 2.137
Settlement Date
10-02-08 04-24-08 10-27-08 05-22-08 10-29-08 07-28-08 02-09-09 11-19-08 12-16-08 10-29-08 12-16-08 10-15-08 09-15-08 01-21-09 06-10-08 10-29-08 01-21-09 02-03-09 11-19-08 11-19-08 02-18-09 12-17-08 01-13-09 02-05-09 02-05-09 11-19-08 02-05-09 12-30-08 12-16-08 02-18-09 12-17-08 02-24-09 02-18-09 02-18-09 02-25-09 12-15-08 12-17-08 02-18-09 12-16-08 12-16-08 12-16-08 12-16-08 12-16-08
Maturity Date
04-02-09 04-15-09 04-15-09 04-24-09 05-01-09 05-07-09 05-11-09 05-15-09 05-18-09 06-12-09 06-15-09 06-22-09 06-23-09 06-24-09 06-30-09 07-15-09 07-20-09 08-03-09 08-05-09 08-15-09 08-17-09 09-15-09 09-18-09 10-13-09 11-18-09 11-18-09 11-24-09 12-15-09 12-16-09 03-09-10 03-12-10 04-15-10 05-14-10 05-14-10 05-25-10 06-15-10 07-16-10 08-04-10 09-10-10 02-18-11 02-18-11 04-21-11 06-10-11
Next Call Date
06-15-09
Par Value
Purchase Price
Purchase Cost
Book Value
Market Price
Market Value
Accrued Interest
Days to Days to Yield to Yield to Maturity Next Call Maturity Next Call
41,015,949.91 7,429,045.15 22,833.88 10,000,000.00 10,000,000.00 8,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 25,000,000.00 4,025,000.00 20,000,000.00 3,725,000.00 20,000,000.00 5,000,000.00 3,500,000.00 15,000,000.00 4,000,000.00 10,000,000.00 16,000,000.00 54,000,000.00 2,000,000.00 3,823,000.00 25,000,000.00 20,000,000.00 6,500,000.00 24,990,000.00 14,500,000.00 5,000,000.00 10,000,000.00 7,000,000.00 25,000,000.00 10,000,000.00 20,000,000.00 30,000,000.00 6,570,000.00 6,115,000.00 20,000,000.00 5,000,000.00 15,000,000.00 28,360,000.00 10,865,000.00 5,000,000.00 5,000,000.00 3,000,000.00 4,000,000.00 599,440,828.94
100.000 100.000 100.000 100.010 100.714 100.900 100.076 98.477 99.649 100.000 101.192 99.753 101.295 100.000 97.965 100.283 99.773 99.831 100.794 99.710 100.000 102.135 102.450 100.000 104.261 103.045 99.562 102.634 97.993 99.363 103.600 100.000 99.964 101.563 100.017 107.822 104.453 100.018 100.010 102.661 104.868 104.297 106.262 105.555 101.314 102.286 100.952
41,015,949.91 7,429,045.15 22,833.88 10,000,980.00 10,071,400.00 8,072,000.00 10,007,600.00 9,847,688.89 9,964,900.00 25,000,000.00 4,072,969.95 19,950,700.00 3,773,249.93 20,000,000.00 4,898,263.89 3,509,919.00 14,965,991.67 3,993,252.00 10,079,400.00 15,953,600.00 54,000,000.00 2,042,706.00 3,916,659.68 25,000,000.00 20,852,300.00 6,697,925.00 24,880,668.75 14,881,915.50 4,899,647.22 9,936,327.78 7,252,000.00 25,000,000.00 9,996,440.00 20,312,680.00 30,005,160.00 7,083,931.68 6,387,294.84 20,003,700.00 5,000,490.00 15,399,105.00 29,740,649.88 11,331,869.05 5,313,100.00 5,277,740.00 3,039,417.00 4,091,440.00 604,972,911.65
41,015,949.91 7,429,045.15 22,833.88 10,000,005.38 10,002,807.87 8,005,929.41 10,000,518.69 9,975,166.67 9,995,534.98 25,000,000.00 4,036,924.73 19,984,855.56 3,740,371.66 20,000,000.00 4,966,630.56 3,502,929.81 14,981,450.00 3,998,414.44 10,032,189.19 15,971,644.44 54,000,000.00 2,020,775.89 3,870,352.11 25,000,000.00 20,523,287.13 6,635,674.40 24,904,721.62 14,808,470.21 4,936,314.58 9,948,320.84 7,185,760.00 25,000,000.00 9,996,826.77 20,239,938.60 30,004,714.54 7,036,211.31 6,362,011.30 20,003,416.16 5,000,201.92 15,326,469.45 29,632,011.31 11,253,671.83 5,271,237.26 5,240,605.04 3,034,539.19 4,080,748.95 603,979,482.75
100.000 100.000 100.000 100.000 100.094 100.156 100.125 99.990 100.187 100.000 100.437 99.967 100.937 100.000 99.960 100.562 99.946 100.531 101.094 99.907 100.000 101.594 101.812 100.000 102.687 101.906 99.810 101.954 99.740 99.740 102.594 100.000 100.094 101.687 100.188 107.312 104.281 100.050 100.219 102.406 104.733 104.656 106.375 105.969 102.250 102.750 100.949
41,015,949.91 7,429,045.15 22,833.88 10,000,000.00 10,009,375.00 8,012,500.00 10,012,500.00 9,999,000.00 10,018,750.00 25,000,000.00 4,042,609.37 19,993,340.00 3,759,921.87 20,000,000.00 4,998,000.00 3,519,687.50 14,991,855.00 4,021,250.00 10,109,375.00 15,985,200.00 54,000,000.00 2,031,875.00 3,892,291.87 25,000,000.00 20,537,500.00 6,623,906.25 24,942,519.00 14,783,388.00 4,987,000.00 9,974,000.00 7,181,562.50 25,000,000.00 10,009,375.00 20,337,500.00 30,056,400.00 7,050,431.25 6,376,798.44 20,010,060.00 5,010,937.50 15,360,937.50 29,702,222.08 11,370,901.56 5,318,750.00 5,298,437.50 3,067,500.00 4,110,000.00 604,975,486.14
0.00 0.00 0.00 169,055.56 138,333.33 179,833.33 234,027.78 0.00 223,200.00 21,657.53 64,623.61 0.00 59,211.98 81,315.07 0.00 28,583.33 0.00 90,300.00 89,722.22 0.00 91,075.07 15,944.44 26,256.58 33,082.19 58,888.89 11,736.11 0.00 220,973.96 0.00 0.00 95,326.39 141,575.34 15,166.67 29,027.78 34,533.33 189,252.50 113,445.99 21,600.00 34,597.22 109,375.00 215,086.97 28,520.62 29,114.58 27,621.53 35,000.00 38,541.67 2,995,606.58
1 1 1 2 15 15 24 31 37 41 45 48 73 76 83 84 85 91 106 111 125 127 137 139 168 171 196 232 232 238 259 260 343 346 380 409 409 420 441 472 491 528 689 689 751 801 206
599,440,828.94
100.952
604,972,911.65
603,979,482.75
100.949
604,975,486.14
2,995,606.58
206
76
0.594 0.579 0.773 3.380 2.255 2.915 2.411 3.068 2.927 0.620 1.790 0.590 3.116 1.400 3.032 2.624 0.539 2.863 3.107 0.590 1.080 2.080 2.013 1.150 0.867 0.511 0.642 0.757 2.054 0.801 0.845 1.950 1.084 1.468 1.105 1.240 1.240 1.065 2.343 1.785 1.411 1.965 1.917 1.998 2.048 2.174 1.360
2.330
1.360
Page 6 of 17
Plano ISD CHANGE IN VALUE From 12-31-08 To 03-31-09 Security Description Pooled Funds TexPool TexPool Prime TexSTAR Bank of America, N.A. CD FHLB Disc Note FHLB Bank of America, N.A. CD FHLB FHLMC FHLMC FNMA FHLMC FHLB FHLB FNMA FHLB FHLB Disc Note FHLB Bank of America, N.A. CD FNMA Citigroup Funding TLGP (FDIC) FHLB Bank of America, N.A. CD FHLMC Disc Note FHLB Citigroup Funding TLGP (FDIC) FHLB FHLMC GE Capital Corp CP TLGP (FDIC) Bank of America, N.A. CD FHLB FNMA Bank of America, N.A. CD FHLMC FHLB FHLMC Disc Note FFCB Disc Note FHLMC FHLB Disc Note FNMA Bank of America, N.A. CD FHLB FHLB FHLMC FHLB FHLB FHLMC FFCB FNMA FHLB FHLMC
CUSIP
texpool texprime texstar 337089917 313385BL9 3133XPNE0 337100115 3133XEK24 3137EAAA7 3137EAAQ2 3136F6M22 3134A3EM4 3133XSEQ7 3133X4ZC8 31359MK69 3133XQYQ9 313385FA9 3133XQZA3 337119822 31359MVE0 17314GSJ9 3133XFLG9 337109870 313397HE4 3133XRP46 17314GTQ2 3133XREU0 3134A4US1 36161CUL4 337118892 3133XLUM3 31359MU68 337121140 3134A3M78 3133XGNJ9 313397MX6 313313PK8 3128X3K85 313385PR1 31359M2S1 337109871 3133XT3E4 3133XPY57 3128X8LR1 3133MBJA6 3133XKXD2 3128X8LY6 31331GHB8 31398AEE8 3133XRN22 3128X4GL9
Coupon
0.579 0.773 0.594 3.550 0.000 2.750 1.700 5.000 4.875 4.750 4.300 5.750 3.400 3.000 4.875 2.500 0.000 2.480 0.620 4.250 0.000 5.250 1.400 0.000 3.000 0.000 2.700 4.250 0.000 1.080 5.125 5.375 1.150 6.625 5.000 0.000 0.000 4.125 0.000 4.625 1.950 1.050 2.750 1.120 7.625 4.875 1.080 2.350 5.500 3.500 4.790
Maturity Date
12-31-08 Book Value
12-31-08 Market Value
Additions Purchases
Withdrawals Sales
01-13-09 02-04-09 02-06-09 02-09-09 02-13-09 02-17-09 03-05-09 03-09-09 03-15-09 04-02-09 04-15-09 04-15-09 04-24-09 05-01-09 05-07-09 05-11-09 05-15-09 05-18-09 06-12-09 06-15-09 06-22-09 06-23-09 06-24-09 06-30-09 07-15-09 07-20-09 08-03-09 08-05-09 08-15-09 08-17-09 09-15-09 09-18-09 10-13-09 11-18-09 11-18-09 11-24-09 12-15-09 12-16-09 03-09-10 03-12-10 04-15-10 05-14-10 05-14-10 05-25-10 06-15-10 07-09-10 07-16-10 08-04-10
121,186,984.40 22,778.11 77,676,126.28 10,000,000.00 9,969,022.22 10,000,000.00 5,000,000.00 5,012,922.28 3,336,745.20 5,022,375.62 10,021,381.74 15,091,894.93 10,000,490.00 10,020,858.43 8,044,047.06 10,002,548.37 9,900,666.67 9,984,372.44 0.00 4,061,316.23 19,955,855.56 3,759,586.23 20,000,000.00 4,930,005.56 3,506,106.72 0.00 3,996,839.45 10,059,779.92 0.00 0.00 2,035,615.81 3,901,688.06 0.00 20,805,298.16 0.00 0.00 4,911,502.08 0.00 0.00 7,250,560.00 25,000,000.00 0.00 20,302,288.37 0.00 0.00 0.00 0.00 5,000,444.23 6,315,933.34 15,388,728.49 0.00
121,186,984.40 22,778.11 77,676,126.28 10,000,000.00 10,000,000.00 10,021,875.00 5,000,000.00 5,026,562.50 3,342,664.06 5,037,500.00 10,075,000.00 15,164,062.50 10,078,125.00 10,078,125.00 8,100,000.00 10,068,750.00 9,992,000.00 10,075,000.00 0.00 4,081,601.56 19,961,660.00 3,805,320.31 20,000,000.00 4,993,000.00 3,543,750.00 0.00 4,045,000.00 10,203,125.00 0.00 0.00 2,055,000.00 3,937,690.00 0.00 20,825,000.00 0.00 0.00 4,971,000.00 0.00 0.00 7,249,375.00 25,000,000.00 0.00 20,468,750.00 0.00 0.00 0.00 0.00 5,029,687.50 6,317,917.50 15,473,437.50 0.00
29,091,679.01 55.77 76,081,830.97 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 25,000,000.00 0.00 0.00 0.00 0.00 0.00 0.00 14,965,991.67 0.00 0.00 15,953,600.00 54,000,000.00 0.00 0.00 25,000,000.00 0.00 6,801,744.44 24,880,668.75 0.00 15,009,847.79 9,936,327.78 0.00 0.00 9,999,065.00 0.00 30,005,160.00 7,213,346.99 6,465,133.69 20,003,700.00 0.00 0.00 0.00 29,793,478.26
-142,849,618.26 0.00 -112,742,007.34 -10,000,000.00 -10,000,000.00 -10,137,500.00 -5,000,000.00 -5,125,000.00 -3,406,046.87 -5,118,750.00 -10,215,000.00 -15,431,250.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -6,485,580.00 0.00 0.00
Interest Received
178,560.75 55.77 174,823.63 88,750.00 0.00 0.00 21,486.11 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 212,500.00 0.00 0.00 51,250.00 102,743.12 0.00 662,500.00 162,500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 275,000.00 0.00 0.00 0.00 0.00 0.00 0.00 262,500.00 0.00
Accrued Interest
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 169,055.56 138,333.33 179,833.33 234,027.78 0.00 223,200.00 21,657.53 64,623.61 0.00 59,211.98 81,315.07 0.00 28,583.33 0.00 90,300.00 89,722.22 0.00 91,075.07 15,944.44 26,256.58 33,082.19 58,888.89 11,736.11 0.00 0.00 220,973.96 0.00 95,326.39 141,575.34 15,166.67 29,027.78 34,533.33 189,252.50 113,445.99 21,600.00 34,597.22 0.00 109,375.00 215,086.97
03-31-09 Book Value
7,429,045.15 22,833.88 41,015,949.91 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,000,005.38 10,002,807.87 8,005,929.41 10,000,518.69 9,975,166.67 9,995,534.98 25,000,000.00 4,036,924.73 19,984,855.56 3,740,371.66 20,000,000.00 4,966,630.56 3,502,929.81 14,981,450.00 3,998,414.44 10,032,189.19 15,971,644.44 54,000,000.00 2,020,775.89 3,870,352.11 25,000,000.00 20,523,287.13 6,635,674.40 24,904,721.62 4,936,314.58 14,808,470.21 9,948,320.84 7,185,760.00 25,000,000.00 9,996,826.77 20,239,938.60 30,004,714.54 7,036,211.31 6,362,011.30 20,003,416.16 5,000,201.92 0.00 15,326,469.45 29,632,011.31
03-31-09 Market Value
7,429,045.15 22,833.88 41,015,949.91 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,000,000.00 10,009,375.00 8,012,500.00 10,012,500.00 9,999,000.00 10,018,750.00 25,000,000.00 4,042,609.37 19,993,340.00 3,759,921.87 20,000,000.00 4,998,000.00 3,519,687.50 14,991,855.00 4,021,250.00 10,109,375.00 15,985,200.00 54,000,000.00 2,031,875.00 3,892,291.87 25,000,000.00 20,537,500.00 6,623,906.25 24,942,519.00 4,987,000.00 14,783,388.00 9,974,000.00 7,181,562.50 25,000,000.00 10,009,375.00 20,337,500.00 30,056,400.00 7,050,431.25 6,376,798.44 20,010,060.00 5,010,937.50 0.00 15,360,937.50 29,702,222.08
Page 7 of 17
Plano ISD CHANGE IN VALUE From 12-31-08 To 03-31-09 Security Description FHLB FFCB FHLB FFCB FHLB
GRAND TOTAL
CUSIP 3133XCUR2 31331VSK3 3133XECU1 31331YG46 3133XR4U1
Coupon
Maturity Date
12-31-08 Book Value
12-31-08 Market Value
4.500 4.875 4.625 2.625 3.125
09-10-10 02-18-11 02-18-11 04-21-11 06-10-11
11,320,065.70 5,306,781.10 5,272,134.72 3,038,680.73 4,089,826.26 540,502,250.46
11,482,946.87 5,373,437.50 5,350,000.00 3,087,187.50 4,150,000.00 542,350,439.10
540,502,250.46
542,350,439.10
Additions Purchases
Withdrawals Sales
Interest Received
Accrued Interest
03-31-09 Book Value
03-31-09 Market Value
0.00 0.00 0.00 0.00 0.00 400,201,630.12
0.00 0.00 0.00 0.00 0.00 -336,510,752.47
244,462.50 121,875.00 115,625.00 0.00 0.00 2,674,631.88
28,520.62 29,114.58 27,621.53 35,000.00 38,541.67 2,995,606.58
11,253,671.83 5,271,237.26 5,240,605.04 3,034,539.19 4,080,748.95 603,979,482.75
11,370,901.56 5,318,750.00 5,298,437.50 3,067,500.00 4,110,000.00 604,975,486.15
400,201,630.12
-336,510,752.47
2,674,631.88
2,995,606.58
603,979,482.75
604,975,486.15
Page 8 of 17
Plano ISD Pooled Funds INVESTMENT TRANSACTIONS From 01-01-09 To 03-31-09 Settle Date
Security
PURCHASES 01-13-09 FHLB Accrued Interest 01-21-09 Citigroup Funding TLGP (FDIC) 01-21-09 GE Capital Corp CP TLGP (FDIC) 02-03-09 Bank of America, N.A. CD 02-05-09 FHLB Disc Note 02-05-09 FHLMC Disc Note 02-05-09 FHLMC Accrued Interest 02-09-09 Bank of America, N.A. CD 02-18-09 FHLB Accrued Interest 02-18-09 FHLB Accrued Interest 02-18-09 FHLB Accrued Interest 02-18-09 FHLMC Accrued Interest 02-18-09 Bank of America, N.A. CD 02-24-09 FHLMC 02-25-09 FHLMC
CALLS 01-09-09
FNMA Accrued Interest
MATURITIES 01-13-09 Bank of America, N.A. CD 02-04-09 FHLB Disc Note 02-06-09 FHLB Accrued Interest 02-09-09 Bank of America, N.A. CD 02-13-09 FHLB Accrued Interest 02-17-09 FHLMC Accrued Interest 03-05-09 FHLMC Accrued Interest 03-09-09 FNMA
CUSIP
Coupon
Mature Date
3133XGNJ9
5.000 09-18-09
17314GTQ2 36161CUL4 337118892 313385PR1 313397MX6 3128X3K85
0.000 0.000 1.080 0.000 0.000 4.125
Call Date
Quantity
Unit Price
Amount
6,500,000
103.045
6,697,925.00 103,819.44 14,965,991.67 15,953,600.00 54,000,000.00 9,936,327.78 24,880,668.75 14,881,915.50 127,932.29 25,000,000.00 9,996,440.00 2,625.00 7,083,931.68 129,415.31 6,387,294.84 77,838.85 29,740,649.88 52,828.38 25,000,000.00 30,005,160.00 20,003,700.00 295,028,064.37
06-24-09 07-20-09 08-03-09 11-24-09 10-13-09 11-18-09
15,000,000 16,000,000 54,000,000 10,000,000 24,990,000 14,500,000
99.773 99.710 100.000 99.363 99.562 102.634
337119822 3133XT3E4
0.620 05-11-09 1.050 03-09-10
25,000,000 10,000,000
100.000 99.964
3133MBJA6
7.625 05-14-10
6,570,000
107.822
3133XKXD2
4.875
05-14-10
6,115,000
104.453
3128X4GL9
4.790 08-04-10
28,360,000
104.868
337121140 3128X8LR1 3128X8LY6
1.150 08-17-09 1.120 04-15-10 1.080 05-25-10
25,000,000 30,000,000 20,000,000
100.000 100.017 100.018
31398AEE8
5.500 07-09-10
01-09-09
6,312,000
100.000
6,312,000.00 173,580.00 6,485,580.00
337089917 313385BL9 3133XPNE0
3.550 01-13-09 0.000 02-04-09 2.750 02-06-09
08-06-08
10,000,000 10,000,000 10,000,000
100.000 100.000 100.000
337100115 3133XEK24
1.700 02-09-09 5.000 02-13-09
5,000,000 5,000,000
100.000 100.000
3137EAAA7
4.875 02-17-09
3,325,000
100.000
3137EAAQ2
4.750 03-05-09
5,000,000
100.000
3136F6M22
4.300 03-09-09
10,000,000
100.000
10,000,000.00 10,000,000.00 10,000,000.00 137,500.00 5,000,000.00 5,000,000.00 125,000.00 3,325,000.00 81,046.87 5,000,000.00 118,750.00 10,000,000.00
Page 9 of 17
Plano ISD Pooled Funds INVESTMENT TRANSACTIONS From 01-01-09 To 03-31-09 Settle Date
03-15-09 03-15-09
Security Accrued Interest FHLMC FHLMC Accrued Interest
CUSIP
3134A3EM4 3134A3EM4
Coupon
Mature Date
5.750 03-15-09 5.750 03-15-09
Call Date
Quantity
10,000,000 5,000,000
Unit Price
100.000 100.000
Amount 215,000.00 10,000,000.00 5,000,000.00 431,250.00 74,433,546.87
Page 10 of 17
Plano ISD EARNED INCOME From 12-31-08 To 03-31-09 Beginning Accrued Interest Pooled Funds TexSTAR (texstar) TexPool (texpool) TexPool Prime (texprime) Bank of America, N.A. CD 3.550% Due 01-13-09 (337089917) FHLB Disc Note 0.000% Due 02-04-09 (313385bl9) FHLB 2.750% Due 02-06-09 (3133xpne0) Bank of America, N.A. CD 1.700% Due 02-09-09 (337100115) FHLB 5.000% Due 02-13-09 (3133xek24) FHLMC 4.875% Due 02-17-09 (3137eaaa7) FHLMC 4.750% Due 03-05-09 (3137eaaq2) FNMA 4.300% Due 03-09-09 (3136f6m22) FHLMC 5.750% Due 03-15-09 (3134a3em4) FHLB 3.400% Due 04-02-09 (3133xseq7) FHLB 3.000% Due 04-15-09 (3133x4zc8) FNMA 4.875% Due 04-15-09 (31359mk69) FHLB 2.500% Due 04-24-09 (3133xqyq9) FHLB Disc Note 0.000% Due 05-01-09 (313385fa9) FHLB 2.480% Due 05-07-09 (3133xqza3) Bank of America, N.A. CD 0.620% Due 05-11-09 (337119822) FNMA 4.250% Due 05-15-09 (31359mve0) Citigroup Funding TLGP (FDIC) 0.000% Due 05-18-09 (17314gsj9) FHLB 5.250% Due 06-12-09 (3133xflg9) Bank of America, N.A. CD 1.400% Due 06-15-09 (337109870) FHLMC Disc Note 0.000% Due 06-22-09 (313397he4) FHLB 3.000% Due 06-23-09 (3133xrp46) Citigroup Funding TLGP (FDIC) 0.000% Due 06-24-09 (17314gtq2) FHLB 2.700% Due 06-30-09 (3133xreu0) FHLMC 4.250% Due 07-15-09 (3134a4us1) GE Capital Corp CP TLGP (FDIC) 0.000% Due 07-20-09 (36161cul4) Bank of America, N.A. CD 1.080% Due 08-03-09 (337118892) FHLB 5.125% Due 08-05-09 (3133xlum3) FNMA 5.375% Due 08-15-09 (31359mu68) Bank of America, N.A. CD 1.150% Due 08-17-09 (337121140) FHLMC 6.625% Due 09-15-09 (3134a3m78)
Purchased Interest
Sold Interest
Interest Received
Earned Interest
Ending Accrued Interest
Amortization/ Accretion
Adjusted Earned Income
0.00 0.00 0.00 75,863.01
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
174,823.63 178,560.75 55.77 88,750.00
174,823.63 178,560.75 55.77 12,886.99
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
174,823.63 178,560.75 55.77 12,886.99
0.00 110,763.89 12,109.59
0.00 0.00 0.00
0.00 137,500.00 0.00
0.00 0.00 21,486.11
0.00 26,736.11 9,376.52
0.00 0.00 0.00
30,977.78 0.00 0.00
30,977.78 26,736.11 9,376.52
95,833.33 60,334.90 76,527.78 133,777.78 253,958.33 84,055.56 63,333.33 82,333.33 171,527.78 0.00 161,200.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
125,000.00 81,046.87 118,750.00 215,000.00 431,250.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
29,166.67 20,711.97 42,222.22 81,222.22 177,291.67 85,000.00 75,000.00 97,500.00 62,500.00 0.00 62,000.00 21,657.53
0.00 0.00 0.00 0.00 0.00 169,055.56 138,333.33 179,833.33 234,027.78 0.00 223,200.00 21,657.53
-12,922.28 -11,745.20 -22,375.62 -21,381.74 -91,894.93 -484.62 -18,050.56 -38,117.65 -2,029.67 74,500.00 11,162.54 0.00
16,244.39 8,966.77 19,846.60 59,840.48 85,396.74 84,515.38 56,949.44 59,382.35 60,470.33 74,500.00 73,162.54 21,657.53
21,857.99 0.00
0.00 0.00
0.00 0.00
0.00 0.00
42,765.62 0.00
64,623.61 0.00
-24,391.50 29,000.00
18,374.12 29,000.00
10,321.35 12,273.97
0.00 0.00
0.00 0.00
0.00 0.00
48,890.62 69,041.10
59,211.98 81,315.07
-19,214.57 0.00
29,676.05 69,041.10
0.00 2,333.33 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 26,250.00 0.00
0.00 28,583.33 0.00
36,625.00 -3,176.90 15,458.33
36,625.00 23,073.10 15,458.33
63,300.00 195,972.22 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 212,500.00 0.00
27,000.00 106,250.00 0.00
90,300.00 89,722.22 0.00
1,574.98 -27,590.73 18,044.44
28,574.98 78,659.27 18,044.44
0.00
0.00
0.00
0.00
91,075.07
91,075.07
0.00
91,075.07
41,569.44 77,628.14 0.00
0.00 0.00 0.00
0.00 0.00 0.00
51,250.00 102,743.12 0.00
25,625.00 51,371.56 33,082.19
15,944.44 26,256.58 33,082.19
-14,839.92 -31,335.95 0.00
10,785.08 20,035.61 33,082.19
390,138.89
0.00
0.00
662,500.00
331,250.00
58,888.89
-282,011.03
49,238.97
Page 11 of 17
Plano ISD EARNED INCOME From 12-31-08 To 03-31-09 Beginning Accrued Interest FHLB 5.000% Due 09-18-09 (3133xgnj9) FHLMC Disc Note 0.000% Due 10-13-09 (313397mx6) FHLMC 4.125% Due 11-18-09 (3128x3k85) FFCB Disc Note 0.000% Due 11-18-09 (313313pk8) FHLB Disc Note 0.000% Due 11-24-09 (313385pr1) FNMA 4.625% Due 12-15-09 (31359m2s1) Bank of America, N.A. CD 1.950% Due 12-16-09 (337109871) FHLB 1.050% Due 03-09-10 (3133xt3e4) FHLB 2.750% Due 03-12-10 (3133xpy57) FHLMC 1.120% Due 04-15-10 (3128x8lr1) FHLB 7.625% Due 05-14-10 (3133mbja6) FHLB 4.875% Due 05-14-10 (3133xkxd2) FHLMC 1.080% Due 05-25-10 (3128x8ly6) FFCB 2.350% Due 06-15-10 (31331ghb8) FNMA 5.500% Due 07-09-10 (31398aee8) FHLB 3.500% Due 07-16-10 (3133xrn22) FHLMC 4.790% Due 08-04-10 (3128x4gl9) FHLB 4.500% Due 09-10-10 (3133xcur2) FFCB 4.875% Due 02-18-11 (31331vsk3) FHLB 4.625% Due 02-18-11 (3133xecu1) FFCB 2.625% Due 04-21-11 (31331yg46) FHLB 3.125% Due 06-10-11 (3133xr4u1)
GRAND TOTAL
Purchased Interest
Sold Interest
Interest Received
Earned Interest
Ending Accrued Interest
Amortization/ Accretion
Adjusted Earned Income
0.00 0.00 0.00 0.00 0.00 14,388.89 21,369.86
103,819.44 0.00 127,932.29 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00
162,500.00 0.00 0.00 0.00 0.00 0.00 0.00
70,416.67 0.00 93,041.67 0.00 0.00 80,937.50 120,205.48
11,736.11 0.00 220,973.96 0.00 0.00 95,326.39 141,575.34
-62,250.60 24,052.87 -73,445.29 24,812.50 11,993.06 -64,800.00 0.00
8,166.07 24,052.87 19,596.38 24,812.50 11,993.06 16,137.50 120,205.48
0.00 166,527.78 0.00 0.00 0.00 0.00 5,222.22 165,865.33 240,625.00 0.00 150,751.87 90,052.08 85,434.03 15,312.50 7,291.67 3,159,855.19
2,625.00 0.00 0.00 129,415.31 77,838.85 0.00 0.00 0.00 0.00 52,828.38 0.00 0.00 0.00 0.00 0.00 494,459.27
0.00 0.00 0.00 0.00 0.00 0.00 0.00 173,580.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,282,126.87
0.00 275,000.00 0.00 0.00 0.00 0.00 0.00 0.00 262,500.00 0.00 244,462.50 121,875.00 115,625.00 0.00 0.00 2,674,631.88
12,541.67 137,500.00 34,533.33 59,837.19 35,607.14 21,600.00 29,375.00 7,714.67 131,250.00 162,258.59 122,231.25 60,937.50 57,812.50 19,687.50 31,250.00 3,298,050.87
15,166.67 29,027.78 34,533.33 189,252.50 113,445.99 21,600.00 34,597.22 0.00 109,375.00 215,086.97 28,520.62 29,114.58 27,621.53 35,000.00 38,541.67 2,995,606.58
386.77 -62,349.77 -445.46 -47,720.37 -25,283.54 -283.84 -242.31 -3,933.34 -62,259.04 -108,638.57 -66,393.87 -35,543.84 -31,529.69 -4,141.54 -9,077.30 -1,001,312.96
12,928.44 75,150.23 34,087.87 12,116.82 10,323.60 21,316.16 29,132.69 3,781.33 68,990.96 53,620.02 55,837.38 25,393.66 26,282.81 15,545.96 22,172.70 2,296,737.91
3,159,855.19
494,459.27
1,282,126.87
2,674,631.88
3,298,050.87
2,995,606.58
-1,001,312.96
2,296,737.91
Page 12 of 17
Plano ISD AMORTIZATION AND ACCRETION From 12-31-08 To 03-31-09 Purchase Information Purchase Quantity Pooled Funds Bank of America, N.A. CD 3.550% Due 01-13-09 (337089917) FHLB Disc Note 0.000% Due 02-04-09 (313385bl9) FHLB 2.750% Due 02-06-09 (3133xpne0) Bank of America, N.A. CD 1.700% Due 02-09-09 (337100115) FHLB 5.000% Due 02-13-09 (3133xek24) FHLMC 4.875% Due 02-17-09 (3137eaaa7) FHLMC 4.750% Due 03-05-09 (3137eaaq2) FNMA 4.300% Due 03-09-09 (3136f6m22) FHLMC 5.750% Due 03-15-09 (3134a3em4) FHLMC 5.750% Due 03-15-09 (3134a3em4) FHLB 3.400% Due 04-02-09 (3133xseq7) FHLB 3.000% Due 04-15-09 (3133x4zc8) FNMA 4.875% Due 04-15-09 (31359mk69) FHLB 2.500% Due 04-24-09 (3133xqyq9) FHLB Disc Note 0.000% Due 05-01-09 (313385fa9) FHLB 2.480% Due 05-07-09 (3133xqza3) Bank of America, N.A. CD 0.620% Due 05-11-09 (337119822) FNMA 4.250% Due 05-15-09 (31359mve0) Citigroup Funding TLGP (FDIC) 0.000% Due 05-18-09 (17314gsj9) FHLB 5.250% Due 06-12-09 (3133xflg9) Bank of America, N.A. CD 1.400% Due 06-15-09 (337109870) FHLMC Disc Note 0.000% Due 06-22-09 (313397he4) FHLB 3.000% Due 06-23-09 (3133xrp46) Citigroup Funding TLGP (FDIC) 0.000% Due 06-24-09 (17314gtq2) FHLB 2.700% Due 06-30-09 (3133xreu0) FHLMC 4.250% Due 07-15-09 (3134a4us1) GE Capital Corp CP TLGP (FDIC) 0.000% Due 07-20-09 (36161cul4) Bank of America, N.A. CD 1.080% Due 08-03-09 (337118892) FHLB 5.125% Due 08-05-09 (3133xlum3) FNMA 5.375% Due 08-15-09 (31359mu68) Bank of America, N.A. CD 1.150% Due 08-17-09 (337121140) FHLMC 6.625% Due 09-15-09 (3134a3m78) FHLB 5.000% Due 09-18-09 (3133xgnj9) FHLMC Disc Note 0.000% Due 10-13-09 (313397mx6) FHLMC 4.125% Due 11-18-09 (3128x3k85) FFCB Disc Note 0.000% Due 11-18-09 (313313pk8)
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,000,000.00 10,000,000.00 8,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 25,000,000.00 4,025,000.00 20,000,000.00 3,725,000.00 20,000,000.00 5,000,000.00 3,500,000.00 15,000,000.00 4,000,000.00 10,000,000.00 16,000,000.00 54,000,000.00 2,000,000.00 3,823,000.00 25,000,000.00 20,000,000.00 6,500,000.00 24,990,000.00 14,500,000.00 5,000,000.00
Date
Price
10/15/2008 9/30/2008 2/8/2008 11/10/2008 8/4/2008 3/17/2008 3/14/2008 9/29/2008 7/28/2008 11/3/2008 10/2/2008 4/24/2008 10/27/2008 5/22/2008 10/29/2008 7/28/2008 2/9/2009 11/19/2008 12/16/2008 10/29/2008 12/16/2008 10/15/2008 9/15/2008 1/21/2009 6/10/2008 10/29/2008 1/21/2009 2/3/2009 11/19/2008 11/19/2008 2/18/2009 12/17/2008 1/13/2009 2/5/2009 2/5/2009 11/19/2008
0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 100.010 100.714 100.900 100.076 98.477 99.649 100.000 101.192 99.753 101.295 100.000 97.965 100.283 99.773 99.831 100.794 99.710 100.000 102.135 102.450 100.000 104.261 103.045 99.562 102.634 97.993
Total Cost
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,000,980.00 10,071,400.00 8,072,000.00 10,007,600.00 9,847,688.89 9,964,900.00 25,000,000.00 4,072,969.95 19,950,700.00 3,773,249.93 20,000,000.00 4,898,263.89 3,509,919.00 14,965,991.67 3,993,252.00 10,079,400.00 15,953,600.00 54,000,000.00 2,042,706.00 3,916,659.68 25,000,000.00 20,852,300.00 6,697,925.00 24,880,668.75 14,881,915.50 4,899,647.22
Date To Date
0.00 30,977.78 0.00 0.00 -12,922.28 -11,745.20 -22,375.62 -21,381.74 -57,181.22 -34,713.71 -484.62 -18,050.56 -38,117.65 -2,029.67 74,500.00 11,162.54 0.00 -24,391.50 29,000.00 -19,214.57 0.00 36,625.00 -3,176.90 15,458.33 1,574.98 -27,590.73 18,044.44 0.00 -14,839.92 -31,335.95 0.00 -282,011.03 -62,250.60 24,052.87 -73,445.29 24,812.50
Amortization/Accretion Information Total To Date Balance
0.00 115,711.11 -1,471.87 0.00 -58,000.00 -84,215.60 -126,440.00 -51,380.00 -180,160.00 -62,770.00 -974.62 -68,592.13 -66,070.59 -7,081.31 127,477.78 30,634.98 0.00 -36,045.22 34,155.56 -32,878.27 0.00 68,366.67 -6,989.19 15,458.33 5,162.44 -47,210.81 18,044.44 0.00 -21,930.11 -46,307.57 0.00 -329,012.87 -62,250.60 24,052.87 -73,445.29 36,667.36
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -5.38 -2,807.87 -5,929.41 -518.69 24,833.33 4,465.02 0.00 -11,924.73 15,144.44 -15,371.66 0.00 33,369.44 -2,929.81 18,550.00 1,585.56 -32,189.19 28,355.56 0.00 -20,775.89 -47,352.11 0.00 -523,287.13 -135,674.40 85,278.37 -308,470.21 63,685.42
Adjusted Cost
10,000,005.38 10,002,807.87 8,005,929.41 10,000,518.69 9,975,166.67 9,995,534.98 25,000,000.00 4,036,924.73 19,984,855.56 3,740,371.66 20,000,000.00 4,966,630.56 3,502,929.81 14,981,450.00 3,998,414.44 10,032,189.19 15,971,644.44 54,000,000.00 2,020,775.89 3,870,352.11 25,000,000.00 20,523,287.13 6,635,674.40 24,904,721.62 14,808,470.21 4,936,314.58
Page 13 of 17
Plano ISD AMORTIZATION AND ACCRETION From 12-31-08 To 03-31-09 Purchase Information Purchase Quantity FHLB Disc Note 0.000% Due 11-24-09 (313385pr1) FNMA 4.625% Due 12-15-09 (31359m2s1) Bank of America, N.A. CD 1.950% Due 12-16-09 (337109871) FHLB 1.050% Due 03-09-10 (3133xt3e4) FHLB 2.750% Due 03-12-10 (3133xpy57) FHLMC 1.120% Due 04-15-10 (3128x8lr1) FHLB 7.625% Due 05-14-10 (3133mbja6) FHLB 4.875% Due 05-14-10 (3133xkxd2) FHLMC 1.080% Due 05-25-10 (3128x8ly6) FFCB 2.350% Due 06-15-10 (31331ghb8) FNMA 5.500% Due 07-09-10 (31398aee8) FHLB 3.500% Due 07-16-10 (3133xrn22) FHLMC 4.790% Due 08-04-10 (3128x4gl9) FHLB 4.500% Due 09-10-10 (3133xcur2) FFCB 4.875% Due 02-18-11 (31331vsk3) FHLB 4.625% Due 02-18-11 (3133xecu1) FFCB 2.625% Due 04-21-11 (31331yg46) FHLB 3.125% Due 06-10-11 (3133xr4u1) GRAND TOTAL
10,000,000.00 7,000,000.00 25,000,000.00 10,000,000.00 20,000,000.00 30,000,000.00 6,570,000.00 6,115,000.00 20,000,000.00 5,000,000.00 0.00 15,000,000.00 28,360,000.00 10,865,000.00 5,000,000.00 5,000,000.00 3,000,000.00 4,000,000.00
Date
Price
2/5/2009 12/30/2008 12/16/2008 2/18/2009 12/17/2008 2/24/2009 2/18/2009 2/18/2009 2/25/2009 12/15/2008 3/13/2008 12/17/2008 2/18/2009 12/16/2008 12/16/2008 12/16/2008 12/16/2008 12/16/2008
99.363 103.600 100.000 99.964 101.563 100.017 107.822 104.453 100.018 100.010 0.000 102.661 104.868 104.297 106.262 105.555 101.314 102.286
Total Cost
Date To Date
Amortization/Accretion Information Total To Date Balance
Adjusted Cost
9,936,327.78 7,252,000.00 25,000,000.00 9,996,440.00 20,312,680.00 30,005,160.00 7,083,931.68 6,387,294.84 20,003,700.00 5,000,490.00 0.00 15,399,105.00 29,740,649.88 11,331,869.05 5,313,100.00 5,277,740.00 3,039,417.00 4,091,440.00
11,993.06 -64,800.00 0.00 386.77 -62,349.77 -445.46 -47,720.37 -25,283.54 -283.84 -242.31 -3,933.34 -62,259.04 -108,638.57 -66,393.87 -35,543.84 -31,529.69 -4,141.54 -9,077.30
11,993.06 -66,240.00 0.00 386.77 -72,741.40 -445.46 -47,720.37 -25,283.54 -283.84 -288.08 -148,483.49 -72,635.55 -108,638.57 -78,197.22 -41,862.74 -37,134.96 -4,877.81 -10,691.05
51,679.16 -185,760.00 0.00 3,173.23 -239,938.60 -4,714.54 -466,211.31 -247,011.30 -3,416.16 -201.92 0.00 -326,469.45 -1,272,011.31 -388,671.83 -271,237.26 -240,605.04 -34,539.19 -80,748.95
9,948,320.84 7,185,760.00 25,000,000.00 9,996,826.77 20,239,938.60 30,004,714.54 7,036,211.31 6,362,011.30 20,003,416.16 5,000,201.92 15,326,469.45 29,632,011.31 11,253,671.83 5,271,237.26 5,240,605.04 3,034,539.19 4,080,748.95
556,505,082.71
-1,001,312.96
-1,590,638.76
-4,538,653.81
555,511,653.80
Page 14 of 17
Plano ISD PROJECTED FIXED INCOME CASH FLOWS Beginning April 1, 2009 SECURITY DESCRIPTION
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
JAN
FEB
MAR
TOTAL
AGENCY COUPON SECURITIES FHLB 3.400% Due 04-02-09 (3133xseq7)
10,170,000.00
10,170,000.00
FHLB 3.000% Due 04-15-09 (3133x4zc8)
10,150,000.00
10,150,000.00
8,195,000.00
8,195,000.00
10,250,000.00
10,250,000.00
FNMA 4.875% Due 04-15-09 (31359mk69) FHLB 2.500% Due 04-24-09 (3133xqyq9) FHLB 2.480% Due 05-07-09 (3133xqza3) FNMA 4.250% Due 05-15-09 (31359mve0)
10,248,000.00
10,248,000.00
4,110,531.25
4,110,531.25
FHLB 5.250% Due 06-12-09 (3133xflg9)
3,822,781.25
3,822,781.25
FHLB 3.000% Due 06-23-09 (3133xrp46)
3,552,500.00
3,552,500.00
FHLB 2.700% Due 06-30-09 (3133xreu0)
4,117,000.00
4,117,000.00
FHLMC 4.250% Due 07-15-09 (3134a4us1)
10,212,500.00
10,212,500.00
FHLB 5.125% Due 08-05-09 (3133xlum3)
2,051,250.00
2,051,250.00
FNMA 5.375% Due 08-15-09 (31359mu68)
3,925,743.12
3,925,743.12
FHLMC 6.625% Due 09-15-09 (3134a3m78) FHLB 5.000% Due 09-18-09 (3133xgnj9) FHLMC 4.125% Due 11-18-09 (3128x3k85)
20,662,500.00
20,662,500.00
6,662,500.00
6,662,500.00
299,062.50
FNMA 4.625% Due 12-15-09 (31359m2s1)
14,799,062.50 161,875.00
15,098,125.00 7,161,875.00
7,323,750.00
FHLB 1.050% Due 03-09-10 (3133xt3e4) FHLB 2.750% Due 03-12-10 (3133xpy57)
275,000.00
FHLMC 1.120% Due 04-15-10 (3128x8lr1)
168,000.00
10,113,750.00
10,113,750.00
20,275,000.00
20,550,000.00
168,000.00
336,000.00
FHLB 7.625% Due 05-14-10 (3133mbja6)
250,481.25
250,481.25
500,962.50
FHLB 4.875% Due 05-14-10 (3133xkxd2)
149,053.12
149,053.12
298,106.25
FHLMC 1.080% Due 05-25-10 (3128x8ly6) FFCB 2.350% Due 06-15-10 (31331ghb8) FHLB 3.500% Due 07-16-10 (3133xrn22) FHLMC 4.790% Due 08-04-10 (3128x4gl9) FHLB 4.500% Due 09-10-10 (3133xcur2)
108,000.00
108,000.00
58,750.00
216,000.00
58,750.00 262,500.00
117,500.00 262,500.00
679,222.00
525,000.00 679,222.00
244,462.50
1,358,444.00 244,462.50
488,925.00
Page 15 of 17
Plano ISD PROJECTED FIXED INCOME CASH FLOWS Beginning April 1, 2009 SECURITY DESCRIPTION
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
JAN
FEB
MAR
TOTAL
FFCB 4.875% Due 02-18-11 (31331vsk3)
121,875.00
121,875.00
243,750.00
FHLB 4.625% Due 02-18-11 (3133xecu1)
115,625.00
115,625.00
231,250.00
FFCB 2.625% Due 04-21-11 (31331yg46)
39,375.00
39,375.00
FHLB 3.125% Due 06-10-11 (3133xr4u1) Total
AGENCY DISCOUNT NOTES FHLB Disc Note 0.000% Due 05-01-09 (313385fa9)
78,750.00
62,500.00 38,804,375.00 15,057,128.12 11,775,406.25 10,475,000.00
62,500.00 7,169,715.12 27,844,462.50
39,375.00 15,198,596.87
7,283,125.00
10,000,000.00
FHLMC Disc Note 0.000% Due 06-22-09 (313397he4)
125,000.00 262,500.00
1,192,722.00 30,633,212.50
165,735,618.37
10,000,000.00 5,000,000.00
5,000,000.00
FHLMC Disc Note 0.000% Due 10-13-09 (313397mx6)
24,990,000.00
24,990,000.00
FFCB Disc Note 0.000% Due 11-18-09 (313313pk8)
5,000,000.00
5,000,000.00
FHLB Disc Note 0.000% Due 11-24-09 (313385pr1)
10,000,000.00
10,000,000.00
24,990,000.00 15,000,000.00
54,990,000.00
Total
10,000,000.00
CERTIFICATES OF DEPOSIT Bank of America, N.A. CD 0.620% Due 05-11-09 (337119822)
25,038,643.84
Bank of America, N.A. CD 1.400% Due 06-15-09 (337109870)
5,000,000.00
25,038,643.84
20,138,849.32
20,138,849.32
Bank of America, N.A. CD 1.080% Due 08-03-09 (337118892)
54,289,203.29
54,289,203.29
Bank of America, N.A. CD 1.150% Due 08-17-09 (337121140)
25,141,780.82
25,141,780.82
Bank of America, N.A. CD 1.950% Due 12-16-09 (337109871) Total
25,038,643.84 20,138,849.32
COMMERCIAL PAPER Citigroup Funding TLGP (FDIC) 0.000% Due 05-18-09 (17314gsj9)
20,000,000.00
79,430,984.11
25,487,500.00
25,487,500.00
25,487,500.00
150,095,977.26
20,000,000.00
Page 16 of 17
Plano ISD PROJECTED FIXED INCOME CASH FLOWS Beginning April 1, 2009 SECURITY DESCRIPTION
Citigroup Funding TLGP (FDIC) 0.000% Due 06-24-09 (17314gtq2) GE Capital Corp CP TLGP (FDIC) 0.000% Due 07-20-09 (36161cul4) Total
Grand Total
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
JAN
FEB
MAR
TOTAL
15,000,000.00
15,000,000.00
16,000,000.00
16,000,000.00
20,000,000.00 15,000,000.00 16,000,000.00
51,000,000.00
38,804,375.00 70,095,771.96 51,914,255.57 26,475,000.00 86,600,699.23 27,844,462.50 25,029,375.00 30,198,596.87 32,770,625.00
262,500.00
1,192,722.00 30,633,212.50
421,821,595.64
Page 17 of 17
Prepared By
Plano ISD Quarterly Investment Report Investment Officers’ Certification For the Quarter Ended March 31, 2009
This report is prepared for the Plano Independent School District (the "District") in accordance with Chapter 2256 of the Public Funds Investment Act ("PFIA"). Section 2256.023(a) of the PFIA states that “Not less than quarterly, the investment officer shall prepare and submit to the governing body of the entity a written report of the investment transactions for all funds covered by this chapter for the preceding reporting period.” This report is signed by the District's investment officers and includes the disclosures required in the PFIA. Market prices were obtained from independent pricing sources, including Interactive Data Corporation and Bloomberg L.P. The investment portfolio complied with the PFIA and the District's approved Investment Policy and Strategy throughout the period. All investment transactions made in the portfolio during this period were made on behalf of the District and were made in full compliance with the PFIA and the District's approved Investment Policy.
Page 2 of 17
Plano ISD FIXED INCOME DISTRIBUTION March 31, 2009
Summary Information Totals Par Value Market Value Adjusted Cost Net Gain/Loss Annual Income Number of Issues
599,440,828.94 604,975,486.14 603,979,482.75 996,003.40 12,667,389.64 46
Average Average Average Average
Weighted Averages YTM Maturity (yrs) Coupon (%) Duration
1.360 0.6 2.139 0.6
Distribution by Maturity % Bond Holdings 34.2
Average Average Average Y T M Coupon Duration 1.504 1.371% 0.100
Maturity 0 - 3 Months
Number 18
Mkt Value 206,846,617.69
3 - 6 Months
8
138,180,148.12
22.8
1.167
2.392%
0.364
6 - 9 Months
6
86,868,469.50
14.4
1.155
1.646%
0.630
9 - 12 Months
2
30,346,875.00
5.0
1.346
2.189%
0.937
1 - 2 Years
10
135,555,875.83
22.4
1.446
3.316%
1.235
2 - 3 Years
2
7,177,500.00
1.2
2.139
2.911%
2.049
Page 3 of 17
Plano ISD Portfolio Composition March 31, 2009
Portfolio Composition by Issuer
Portfolio Composition by Security Type
FHLB
Agency Securities 58.9%
26.4% Pie chart w/ Issuer breakdown goes hereFFCB
Commercial Paper 8.4%
3.0%
Commercial Paper 8.4%
Pools & Money Markets 8.0%
TexStar 6.8% FHLMC 25.6%
CD's 24.6%
TexPool 1.2%
FNMA 3.8%
Portfolio Composition by Maturity (Percentage)
CD's 24.6%
Portfolio Composition by Maturity (Amount)
0-3 Months 34.2%
$225 $200
3-6 Months 22.8%
$175 Millions
$150 $125 $100 $75 2-3 Years 1.2%
1-2 Years 22.4%
$50 $25 6-9 Months 14.4% 9-12 Months 5.0%
$0-3 Months
3-6 Months
6-9 Months
9-12 Months
1 - 2 Years
2 - 3 Years
Over 3 Years
Page 4 of 17
Plano ISD Benchmark Comparison March 31, 2009
6.000% Plano Portfolio Month-End Wtd Avg Yld TexPool Monthly Average
5.000%
3-Mo CMT (3-Month Moving Avg) 6-Mo CMT (6-Month Moving Avg) 4.000% 1-Yr CMT (12-Month Moving Avg)
3.000%
2.000%
1.000%
Notes:
Mar-09
Feb-09
Jan-09
Dec-08
Nov-08
Oct-08
Sep-08
Aug-08
Jul-08
Jun-08
May-08
Apr-08
Mar-08
Feb-08
Jan-08
Dec-07
Nov-07
Oct-07
0.000%
1.) Benchmark data for TexPool is the monthly average yield. 2.) CMT stands for Constant Maturity Treasury. This data is published in Federal Reserve Statistical Release H.15 and represents an average of all actively traded Treasury securities having that time remaining until maturity. This is a standard industry benchmark for Treasury securities. 3.) The CMT benchmarks are moving averages. The 3-month CMT is the daily average for the previous 3 months, the 6-month CMT is the daily average for the previous 6 months, and the 1-year CMT is the daily average for the previous 12-months.
Page 5 of 17
Plano ISD DETAIL OF SECURITY HOLDINGS As of March 31, 2009 Security Description Pooled Funds TexSTAR TexPool TexPool Prime FHLB FHLB FNMA FHLB FHLB Disc Note FHLB Bank of America, N.A. CD FNMA Citigroup Funding TLGP (FDIC) FHLB Bank of America, N.A. CD FHLMC Disc Note FHLB Citigroup Funding TLGP (FDIC) FHLB FHLMC GE Capital Corp CP TLGP (FDIC) Bank of America, N.A. CD FHLB FNMA Bank of America, N.A. CD FHLMC FHLB FHLMC Disc Note FHLMC FFCB Disc Note FHLB Disc Note FNMA Bank of America, N.A. CD FHLB FHLB FHLMC FHLB FHLB FHLMC FFCB FHLB FHLMC FHLB FFCB FHLB FFCB FHLB
GRAND TOTAL
Security CUSIP
texstar texpool texprime 3133XSEQ7 3133X4ZC8 31359MK69 3133XQYQ9 313385FA9 3133XQZA3 337119822 31359MVE0 17314GSJ9 3133XFLG9 337109870 313397HE4 3133XRP46 17314GTQ2 3133XREU0 3134A4US1 36161CUL4 337118892 3133XLUM3 31359MU68 337121140 3134A3M78 3133XGNJ9 313397MX6 3128X3K85 313313PK8 313385PR1 31359M2S1 337109871 3133XT3E4 3133XPY57 3128X8LR1 3133MBJA6 3133XKXD2 3128X8LY6 31331GHB8 3133XRN22 3128X4GL9 3133XCUR2 31331VSK3 3133XECU1 31331YG46 3133XR4U1
Coupon
0.594 0.579 0.773 3.400 3.000 4.875 2.500 0.000 2.480 0.620 4.250 0.000 5.250 1.400 0.000 3.000 0.000 2.700 4.250 0.000 1.080 5.125 5.375 1.150 6.625 5.000 0.000 4.125 0.000 0.000 4.625 1.950 1.050 2.750 1.120 7.625 4.875 1.080 2.350 3.500 4.790 4.500 4.875 4.625 2.625 3.125 2.137 2.137
Settlement Date
10-02-08 04-24-08 10-27-08 05-22-08 10-29-08 07-28-08 02-09-09 11-19-08 12-16-08 10-29-08 12-16-08 10-15-08 09-15-08 01-21-09 06-10-08 10-29-08 01-21-09 02-03-09 11-19-08 11-19-08 02-18-09 12-17-08 01-13-09 02-05-09 02-05-09 11-19-08 02-05-09 12-30-08 12-16-08 02-18-09 12-17-08 02-24-09 02-18-09 02-18-09 02-25-09 12-15-08 12-17-08 02-18-09 12-16-08 12-16-08 12-16-08 12-16-08 12-16-08
Maturity Date
04-02-09 04-15-09 04-15-09 04-24-09 05-01-09 05-07-09 05-11-09 05-15-09 05-18-09 06-12-09 06-15-09 06-22-09 06-23-09 06-24-09 06-30-09 07-15-09 07-20-09 08-03-09 08-05-09 08-15-09 08-17-09 09-15-09 09-18-09 10-13-09 11-18-09 11-18-09 11-24-09 12-15-09 12-16-09 03-09-10 03-12-10 04-15-10 05-14-10 05-14-10 05-25-10 06-15-10 07-16-10 08-04-10 09-10-10 02-18-11 02-18-11 04-21-11 06-10-11
Next Call Date
06-15-09
Par Value
Purchase Price
Purchase Cost
Book Value
Market Price
Market Value
Accrued Interest
Days to Days to Yield to Yield to Maturity Next Call Maturity Next Call
41,015,949.91 7,429,045.15 22,833.88 10,000,000.00 10,000,000.00 8,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 25,000,000.00 4,025,000.00 20,000,000.00 3,725,000.00 20,000,000.00 5,000,000.00 3,500,000.00 15,000,000.00 4,000,000.00 10,000,000.00 16,000,000.00 54,000,000.00 2,000,000.00 3,823,000.00 25,000,000.00 20,000,000.00 6,500,000.00 24,990,000.00 14,500,000.00 5,000,000.00 10,000,000.00 7,000,000.00 25,000,000.00 10,000,000.00 20,000,000.00 30,000,000.00 6,570,000.00 6,115,000.00 20,000,000.00 5,000,000.00 15,000,000.00 28,360,000.00 10,865,000.00 5,000,000.00 5,000,000.00 3,000,000.00 4,000,000.00 599,440,828.94
100.000 100.000 100.000 100.010 100.714 100.900 100.076 98.477 99.649 100.000 101.192 99.753 101.295 100.000 97.965 100.283 99.773 99.831 100.794 99.710 100.000 102.135 102.450 100.000 104.261 103.045 99.562 102.634 97.993 99.363 103.600 100.000 99.964 101.563 100.017 107.822 104.453 100.018 100.010 102.661 104.868 104.297 106.262 105.555 101.314 102.286 100.952
41,015,949.91 7,429,045.15 22,833.88 10,000,980.00 10,071,400.00 8,072,000.00 10,007,600.00 9,847,688.89 9,964,900.00 25,000,000.00 4,072,969.95 19,950,700.00 3,773,249.93 20,000,000.00 4,898,263.89 3,509,919.00 14,965,991.67 3,993,252.00 10,079,400.00 15,953,600.00 54,000,000.00 2,042,706.00 3,916,659.68 25,000,000.00 20,852,300.00 6,697,925.00 24,880,668.75 14,881,915.50 4,899,647.22 9,936,327.78 7,252,000.00 25,000,000.00 9,996,440.00 20,312,680.00 30,005,160.00 7,083,931.68 6,387,294.84 20,003,700.00 5,000,490.00 15,399,105.00 29,740,649.88 11,331,869.05 5,313,100.00 5,277,740.00 3,039,417.00 4,091,440.00 604,972,911.65
41,015,949.91 7,429,045.15 22,833.88 10,000,005.38 10,002,807.87 8,005,929.41 10,000,518.69 9,975,166.67 9,995,534.98 25,000,000.00 4,036,924.73 19,984,855.56 3,740,371.66 20,000,000.00 4,966,630.56 3,502,929.81 14,981,450.00 3,998,414.44 10,032,189.19 15,971,644.44 54,000,000.00 2,020,775.89 3,870,352.11 25,000,000.00 20,523,287.13 6,635,674.40 24,904,721.62 14,808,470.21 4,936,314.58 9,948,320.84 7,185,760.00 25,000,000.00 9,996,826.77 20,239,938.60 30,004,714.54 7,036,211.31 6,362,011.30 20,003,416.16 5,000,201.92 15,326,469.45 29,632,011.31 11,253,671.83 5,271,237.26 5,240,605.04 3,034,539.19 4,080,748.95 603,979,482.75
100.000 100.000 100.000 100.000 100.094 100.156 100.125 99.990 100.187 100.000 100.437 99.967 100.937 100.000 99.960 100.562 99.946 100.531 101.094 99.907 100.000 101.594 101.812 100.000 102.687 101.906 99.810 101.954 99.740 99.740 102.594 100.000 100.094 101.687 100.188 107.312 104.281 100.050 100.219 102.406 104.733 104.656 106.375 105.969 102.250 102.750 100.949
41,015,949.91 7,429,045.15 22,833.88 10,000,000.00 10,009,375.00 8,012,500.00 10,012,500.00 9,999,000.00 10,018,750.00 25,000,000.00 4,042,609.37 19,993,340.00 3,759,921.87 20,000,000.00 4,998,000.00 3,519,687.50 14,991,855.00 4,021,250.00 10,109,375.00 15,985,200.00 54,000,000.00 2,031,875.00 3,892,291.87 25,000,000.00 20,537,500.00 6,623,906.25 24,942,519.00 14,783,388.00 4,987,000.00 9,974,000.00 7,181,562.50 25,000,000.00 10,009,375.00 20,337,500.00 30,056,400.00 7,050,431.25 6,376,798.44 20,010,060.00 5,010,937.50 15,360,937.50 29,702,222.08 11,370,901.56 5,318,750.00 5,298,437.50 3,067,500.00 4,110,000.00 604,975,486.14
0.00 0.00 0.00 169,055.56 138,333.33 179,833.33 234,027.78 0.00 223,200.00 21,657.53 64,623.61 0.00 59,211.98 81,315.07 0.00 28,583.33 0.00 90,300.00 89,722.22 0.00 91,075.07 15,944.44 26,256.58 33,082.19 58,888.89 11,736.11 0.00 220,973.96 0.00 0.00 95,326.39 141,575.34 15,166.67 29,027.78 34,533.33 189,252.50 113,445.99 21,600.00 34,597.22 109,375.00 215,086.97 28,520.62 29,114.58 27,621.53 35,000.00 38,541.67 2,995,606.58
1 1 1 2 15 15 24 31 37 41 45 48 73 76 83 84 85 91 106 111 125 127 137 139 168 171 196 232 232 238 259 260 343 346 380 409 409 420 441 472 491 528 689 689 751 801 206
599,440,828.94
100.952
604,972,911.65
603,979,482.75
100.949
604,975,486.14
2,995,606.58
206
76
0.594 0.579 0.773 3.380 2.255 2.915 2.411 3.068 2.927 0.620 1.790 0.590 3.116 1.400 3.032 2.624 0.539 2.863 3.107 0.590 1.080 2.080 2.013 1.150 0.867 0.511 0.642 0.757 2.054 0.801 0.845 1.950 1.084 1.468 1.105 1.240 1.240 1.065 2.343 1.785 1.411 1.965 1.917 1.998 2.048 2.174 1.360
2.330
1.360
Page 6 of 17
Plano ISD CHANGE IN VALUE From 12-31-08 To 03-31-09 Security Description Pooled Funds TexPool TexPool Prime TexSTAR Bank of America, N.A. CD FHLB Disc Note FHLB Bank of America, N.A. CD FHLB FHLMC FHLMC FNMA FHLMC FHLB FHLB FNMA FHLB FHLB Disc Note FHLB Bank of America, N.A. CD FNMA Citigroup Funding TLGP (FDIC) FHLB Bank of America, N.A. CD FHLMC Disc Note FHLB Citigroup Funding TLGP (FDIC) FHLB FHLMC GE Capital Corp CP TLGP (FDIC) Bank of America, N.A. CD FHLB FNMA Bank of America, N.A. CD FHLMC FHLB FHLMC Disc Note FFCB Disc Note FHLMC FHLB Disc Note FNMA Bank of America, N.A. CD FHLB FHLB FHLMC FHLB FHLB FHLMC FFCB FNMA FHLB FHLMC
CUSIP
texpool texprime texstar 337089917 313385BL9 3133XPNE0 337100115 3133XEK24 3137EAAA7 3137EAAQ2 3136F6M22 3134A3EM4 3133XSEQ7 3133X4ZC8 31359MK69 3133XQYQ9 313385FA9 3133XQZA3 337119822 31359MVE0 17314GSJ9 3133XFLG9 337109870 313397HE4 3133XRP46 17314GTQ2 3133XREU0 3134A4US1 36161CUL4 337118892 3133XLUM3 31359MU68 337121140 3134A3M78 3133XGNJ9 313397MX6 313313PK8 3128X3K85 313385PR1 31359M2S1 337109871 3133XT3E4 3133XPY57 3128X8LR1 3133MBJA6 3133XKXD2 3128X8LY6 31331GHB8 31398AEE8 3133XRN22 3128X4GL9
Coupon
0.579 0.773 0.594 3.550 0.000 2.750 1.700 5.000 4.875 4.750 4.300 5.750 3.400 3.000 4.875 2.500 0.000 2.480 0.620 4.250 0.000 5.250 1.400 0.000 3.000 0.000 2.700 4.250 0.000 1.080 5.125 5.375 1.150 6.625 5.000 0.000 0.000 4.125 0.000 4.625 1.950 1.050 2.750 1.120 7.625 4.875 1.080 2.350 5.500 3.500 4.790
Maturity Date
12-31-08 Book Value
12-31-08 Market Value
Additions Purchases
Withdrawals Sales
01-13-09 02-04-09 02-06-09 02-09-09 02-13-09 02-17-09 03-05-09 03-09-09 03-15-09 04-02-09 04-15-09 04-15-09 04-24-09 05-01-09 05-07-09 05-11-09 05-15-09 05-18-09 06-12-09 06-15-09 06-22-09 06-23-09 06-24-09 06-30-09 07-15-09 07-20-09 08-03-09 08-05-09 08-15-09 08-17-09 09-15-09 09-18-09 10-13-09 11-18-09 11-18-09 11-24-09 12-15-09 12-16-09 03-09-10 03-12-10 04-15-10 05-14-10 05-14-10 05-25-10 06-15-10 07-09-10 07-16-10 08-04-10
121,186,984.40 22,778.11 77,676,126.28 10,000,000.00 9,969,022.22 10,000,000.00 5,000,000.00 5,012,922.28 3,336,745.20 5,022,375.62 10,021,381.74 15,091,894.93 10,000,490.00 10,020,858.43 8,044,047.06 10,002,548.37 9,900,666.67 9,984,372.44 0.00 4,061,316.23 19,955,855.56 3,759,586.23 20,000,000.00 4,930,005.56 3,506,106.72 0.00 3,996,839.45 10,059,779.92 0.00 0.00 2,035,615.81 3,901,688.06 0.00 20,805,298.16 0.00 0.00 4,911,502.08 0.00 0.00 7,250,560.00 25,000,000.00 0.00 20,302,288.37 0.00 0.00 0.00 0.00 5,000,444.23 6,315,933.34 15,388,728.49 0.00
121,186,984.40 22,778.11 77,676,126.28 10,000,000.00 10,000,000.00 10,021,875.00 5,000,000.00 5,026,562.50 3,342,664.06 5,037,500.00 10,075,000.00 15,164,062.50 10,078,125.00 10,078,125.00 8,100,000.00 10,068,750.00 9,992,000.00 10,075,000.00 0.00 4,081,601.56 19,961,660.00 3,805,320.31 20,000,000.00 4,993,000.00 3,543,750.00 0.00 4,045,000.00 10,203,125.00 0.00 0.00 2,055,000.00 3,937,690.00 0.00 20,825,000.00 0.00 0.00 4,971,000.00 0.00 0.00 7,249,375.00 25,000,000.00 0.00 20,468,750.00 0.00 0.00 0.00 0.00 5,029,687.50 6,317,917.50 15,473,437.50 0.00
29,091,679.01 55.77 76,081,830.97 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 25,000,000.00 0.00 0.00 0.00 0.00 0.00 0.00 14,965,991.67 0.00 0.00 15,953,600.00 54,000,000.00 0.00 0.00 25,000,000.00 0.00 6,801,744.44 24,880,668.75 0.00 15,009,847.79 9,936,327.78 0.00 0.00 9,999,065.00 0.00 30,005,160.00 7,213,346.99 6,465,133.69 20,003,700.00 0.00 0.00 0.00 29,793,478.26
-142,849,618.26 0.00 -112,742,007.34 -10,000,000.00 -10,000,000.00 -10,137,500.00 -5,000,000.00 -5,125,000.00 -3,406,046.87 -5,118,750.00 -10,215,000.00 -15,431,250.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -6,485,580.00 0.00 0.00
Interest Received
178,560.75 55.77 174,823.63 88,750.00 0.00 0.00 21,486.11 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 212,500.00 0.00 0.00 51,250.00 102,743.12 0.00 662,500.00 162,500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 275,000.00 0.00 0.00 0.00 0.00 0.00 0.00 262,500.00 0.00
Accrued Interest
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 169,055.56 138,333.33 179,833.33 234,027.78 0.00 223,200.00 21,657.53 64,623.61 0.00 59,211.98 81,315.07 0.00 28,583.33 0.00 90,300.00 89,722.22 0.00 91,075.07 15,944.44 26,256.58 33,082.19 58,888.89 11,736.11 0.00 0.00 220,973.96 0.00 95,326.39 141,575.34 15,166.67 29,027.78 34,533.33 189,252.50 113,445.99 21,600.00 34,597.22 0.00 109,375.00 215,086.97
03-31-09 Book Value
7,429,045.15 22,833.88 41,015,949.91 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,000,005.38 10,002,807.87 8,005,929.41 10,000,518.69 9,975,166.67 9,995,534.98 25,000,000.00 4,036,924.73 19,984,855.56 3,740,371.66 20,000,000.00 4,966,630.56 3,502,929.81 14,981,450.00 3,998,414.44 10,032,189.19 15,971,644.44 54,000,000.00 2,020,775.89 3,870,352.11 25,000,000.00 20,523,287.13 6,635,674.40 24,904,721.62 4,936,314.58 14,808,470.21 9,948,320.84 7,185,760.00 25,000,000.00 9,996,826.77 20,239,938.60 30,004,714.54 7,036,211.31 6,362,011.30 20,003,416.16 5,000,201.92 0.00 15,326,469.45 29,632,011.31
03-31-09 Market Value
7,429,045.15 22,833.88 41,015,949.91 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,000,000.00 10,009,375.00 8,012,500.00 10,012,500.00 9,999,000.00 10,018,750.00 25,000,000.00 4,042,609.37 19,993,340.00 3,759,921.87 20,000,000.00 4,998,000.00 3,519,687.50 14,991,855.00 4,021,250.00 10,109,375.00 15,985,200.00 54,000,000.00 2,031,875.00 3,892,291.87 25,000,000.00 20,537,500.00 6,623,906.25 24,942,519.00 4,987,000.00 14,783,388.00 9,974,000.00 7,181,562.50 25,000,000.00 10,009,375.00 20,337,500.00 30,056,400.00 7,050,431.25 6,376,798.44 20,010,060.00 5,010,937.50 0.00 15,360,937.50 29,702,222.08
Page 7 of 17
Plano ISD CHANGE IN VALUE From 12-31-08 To 03-31-09 Security Description FHLB FFCB FHLB FFCB FHLB
GRAND TOTAL
CUSIP 3133XCUR2 31331VSK3 3133XECU1 31331YG46 3133XR4U1
Coupon
Maturity Date
12-31-08 Book Value
12-31-08 Market Value
4.500 4.875 4.625 2.625 3.125
09-10-10 02-18-11 02-18-11 04-21-11 06-10-11
11,320,065.70 5,306,781.10 5,272,134.72 3,038,680.73 4,089,826.26 540,502,250.46
11,482,946.87 5,373,437.50 5,350,000.00 3,087,187.50 4,150,000.00 542,350,439.10
540,502,250.46
542,350,439.10
Additions Purchases
Withdrawals Sales
Interest Received
Accrued Interest
03-31-09 Book Value
03-31-09 Market Value
0.00 0.00 0.00 0.00 0.00 400,201,630.12
0.00 0.00 0.00 0.00 0.00 -336,510,752.47
244,462.50 121,875.00 115,625.00 0.00 0.00 2,674,631.88
28,520.62 29,114.58 27,621.53 35,000.00 38,541.67 2,995,606.58
11,253,671.83 5,271,237.26 5,240,605.04 3,034,539.19 4,080,748.95 603,979,482.75
11,370,901.56 5,318,750.00 5,298,437.50 3,067,500.00 4,110,000.00 604,975,486.15
400,201,630.12
-336,510,752.47
2,674,631.88
2,995,606.58
603,979,482.75
604,975,486.15
Page 8 of 17
Plano ISD Pooled Funds INVESTMENT TRANSACTIONS From 01-01-09 To 03-31-09 Settle Date
Security
PURCHASES 01-13-09 FHLB Accrued Interest 01-21-09 Citigroup Funding TLGP (FDIC) 01-21-09 GE Capital Corp CP TLGP (FDIC) 02-03-09 Bank of America, N.A. CD 02-05-09 FHLB Disc Note 02-05-09 FHLMC Disc Note 02-05-09 FHLMC Accrued Interest 02-09-09 Bank of America, N.A. CD 02-18-09 FHLB Accrued Interest 02-18-09 FHLB Accrued Interest 02-18-09 FHLB Accrued Interest 02-18-09 FHLMC Accrued Interest 02-18-09 Bank of America, N.A. CD 02-24-09 FHLMC 02-25-09 FHLMC
CALLS 01-09-09
FNMA Accrued Interest
MATURITIES 01-13-09 Bank of America, N.A. CD 02-04-09 FHLB Disc Note 02-06-09 FHLB Accrued Interest 02-09-09 Bank of America, N.A. CD 02-13-09 FHLB Accrued Interest 02-17-09 FHLMC Accrued Interest 03-05-09 FHLMC Accrued Interest 03-09-09 FNMA
CUSIP
Coupon
Mature Date
3133XGNJ9
5.000 09-18-09
17314GTQ2 36161CUL4 337118892 313385PR1 313397MX6 3128X3K85
0.000 0.000 1.080 0.000 0.000 4.125
Call Date
Quantity
Unit Price
Amount
6,500,000
103.045
6,697,925.00 103,819.44 14,965,991.67 15,953,600.00 54,000,000.00 9,936,327.78 24,880,668.75 14,881,915.50 127,932.29 25,000,000.00 9,996,440.00 2,625.00 7,083,931.68 129,415.31 6,387,294.84 77,838.85 29,740,649.88 52,828.38 25,000,000.00 30,005,160.00 20,003,700.00 295,028,064.37
06-24-09 07-20-09 08-03-09 11-24-09 10-13-09 11-18-09
15,000,000 16,000,000 54,000,000 10,000,000 24,990,000 14,500,000
99.773 99.710 100.000 99.363 99.562 102.634
337119822 3133XT3E4
0.620 05-11-09 1.050 03-09-10
25,000,000 10,000,000
100.000 99.964
3133MBJA6
7.625 05-14-10
6,570,000
107.822
3133XKXD2
4.875
05-14-10
6,115,000
104.453
3128X4GL9
4.790 08-04-10
28,360,000
104.868
337121140 3128X8LR1 3128X8LY6
1.150 08-17-09 1.120 04-15-10 1.080 05-25-10
25,000,000 30,000,000 20,000,000
100.000 100.017 100.018
31398AEE8
5.500 07-09-10
01-09-09
6,312,000
100.000
6,312,000.00 173,580.00 6,485,580.00
337089917 313385BL9 3133XPNE0
3.550 01-13-09 0.000 02-04-09 2.750 02-06-09
08-06-08
10,000,000 10,000,000 10,000,000
100.000 100.000 100.000
337100115 3133XEK24
1.700 02-09-09 5.000 02-13-09
5,000,000 5,000,000
100.000 100.000
3137EAAA7
4.875 02-17-09
3,325,000
100.000
3137EAAQ2
4.750 03-05-09
5,000,000
100.000
3136F6M22
4.300 03-09-09
10,000,000
100.000
10,000,000.00 10,000,000.00 10,000,000.00 137,500.00 5,000,000.00 5,000,000.00 125,000.00 3,325,000.00 81,046.87 5,000,000.00 118,750.00 10,000,000.00
Page 9 of 17
Plano ISD Pooled Funds INVESTMENT TRANSACTIONS From 01-01-09 To 03-31-09 Settle Date
03-15-09 03-15-09
Security Accrued Interest FHLMC FHLMC Accrued Interest
CUSIP
3134A3EM4 3134A3EM4
Coupon
Mature Date
5.750 03-15-09 5.750 03-15-09
Call Date
Quantity
10,000,000 5,000,000
Unit Price
100.000 100.000
Amount 215,000.00 10,000,000.00 5,000,000.00 431,250.00 74,433,546.87
Page 10 of 17
Plano ISD EARNED INCOME From 12-31-08 To 03-31-09 Beginning Accrued Interest Pooled Funds TexSTAR (texstar) TexPool (texpool) TexPool Prime (texprime) Bank of America, N.A. CD 3.550% Due 01-13-09 (337089917) FHLB Disc Note 0.000% Due 02-04-09 (313385bl9) FHLB 2.750% Due 02-06-09 (3133xpne0) Bank of America, N.A. CD 1.700% Due 02-09-09 (337100115) FHLB 5.000% Due 02-13-09 (3133xek24) FHLMC 4.875% Due 02-17-09 (3137eaaa7) FHLMC 4.750% Due 03-05-09 (3137eaaq2) FNMA 4.300% Due 03-09-09 (3136f6m22) FHLMC 5.750% Due 03-15-09 (3134a3em4) FHLB 3.400% Due 04-02-09 (3133xseq7) FHLB 3.000% Due 04-15-09 (3133x4zc8) FNMA 4.875% Due 04-15-09 (31359mk69) FHLB 2.500% Due 04-24-09 (3133xqyq9) FHLB Disc Note 0.000% Due 05-01-09 (313385fa9) FHLB 2.480% Due 05-07-09 (3133xqza3) Bank of America, N.A. CD 0.620% Due 05-11-09 (337119822) FNMA 4.250% Due 05-15-09 (31359mve0) Citigroup Funding TLGP (FDIC) 0.000% Due 05-18-09 (17314gsj9) FHLB 5.250% Due 06-12-09 (3133xflg9) Bank of America, N.A. CD 1.400% Due 06-15-09 (337109870) FHLMC Disc Note 0.000% Due 06-22-09 (313397he4) FHLB 3.000% Due 06-23-09 (3133xrp46) Citigroup Funding TLGP (FDIC) 0.000% Due 06-24-09 (17314gtq2) FHLB 2.700% Due 06-30-09 (3133xreu0) FHLMC 4.250% Due 07-15-09 (3134a4us1) GE Capital Corp CP TLGP (FDIC) 0.000% Due 07-20-09 (36161cul4) Bank of America, N.A. CD 1.080% Due 08-03-09 (337118892) FHLB 5.125% Due 08-05-09 (3133xlum3) FNMA 5.375% Due 08-15-09 (31359mu68) Bank of America, N.A. CD 1.150% Due 08-17-09 (337121140) FHLMC 6.625% Due 09-15-09 (3134a3m78)
Purchased Interest
Sold Interest
Interest Received
Earned Interest
Ending Accrued Interest
Amortization/ Accretion
Adjusted Earned Income
0.00 0.00 0.00 75,863.01
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
174,823.63 178,560.75 55.77 88,750.00
174,823.63 178,560.75 55.77 12,886.99
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
174,823.63 178,560.75 55.77 12,886.99
0.00 110,763.89 12,109.59
0.00 0.00 0.00
0.00 137,500.00 0.00
0.00 0.00 21,486.11
0.00 26,736.11 9,376.52
0.00 0.00 0.00
30,977.78 0.00 0.00
30,977.78 26,736.11 9,376.52
95,833.33 60,334.90 76,527.78 133,777.78 253,958.33 84,055.56 63,333.33 82,333.33 171,527.78 0.00 161,200.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
125,000.00 81,046.87 118,750.00 215,000.00 431,250.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
29,166.67 20,711.97 42,222.22 81,222.22 177,291.67 85,000.00 75,000.00 97,500.00 62,500.00 0.00 62,000.00 21,657.53
0.00 0.00 0.00 0.00 0.00 169,055.56 138,333.33 179,833.33 234,027.78 0.00 223,200.00 21,657.53
-12,922.28 -11,745.20 -22,375.62 -21,381.74 -91,894.93 -484.62 -18,050.56 -38,117.65 -2,029.67 74,500.00 11,162.54 0.00
16,244.39 8,966.77 19,846.60 59,840.48 85,396.74 84,515.38 56,949.44 59,382.35 60,470.33 74,500.00 73,162.54 21,657.53
21,857.99 0.00
0.00 0.00
0.00 0.00
0.00 0.00
42,765.62 0.00
64,623.61 0.00
-24,391.50 29,000.00
18,374.12 29,000.00
10,321.35 12,273.97
0.00 0.00
0.00 0.00
0.00 0.00
48,890.62 69,041.10
59,211.98 81,315.07
-19,214.57 0.00
29,676.05 69,041.10
0.00 2,333.33 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 26,250.00 0.00
0.00 28,583.33 0.00
36,625.00 -3,176.90 15,458.33
36,625.00 23,073.10 15,458.33
63,300.00 195,972.22 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 212,500.00 0.00
27,000.00 106,250.00 0.00
90,300.00 89,722.22 0.00
1,574.98 -27,590.73 18,044.44
28,574.98 78,659.27 18,044.44
0.00
0.00
0.00
0.00
91,075.07
91,075.07
0.00
91,075.07
41,569.44 77,628.14 0.00
0.00 0.00 0.00
0.00 0.00 0.00
51,250.00 102,743.12 0.00
25,625.00 51,371.56 33,082.19
15,944.44 26,256.58 33,082.19
-14,839.92 -31,335.95 0.00
10,785.08 20,035.61 33,082.19
390,138.89
0.00
0.00
662,500.00
331,250.00
58,888.89
-282,011.03
49,238.97
Page 11 of 17
Plano ISD EARNED INCOME From 12-31-08 To 03-31-09 Beginning Accrued Interest FHLB 5.000% Due 09-18-09 (3133xgnj9) FHLMC Disc Note 0.000% Due 10-13-09 (313397mx6) FHLMC 4.125% Due 11-18-09 (3128x3k85) FFCB Disc Note 0.000% Due 11-18-09 (313313pk8) FHLB Disc Note 0.000% Due 11-24-09 (313385pr1) FNMA 4.625% Due 12-15-09 (31359m2s1) Bank of America, N.A. CD 1.950% Due 12-16-09 (337109871) FHLB 1.050% Due 03-09-10 (3133xt3e4) FHLB 2.750% Due 03-12-10 (3133xpy57) FHLMC 1.120% Due 04-15-10 (3128x8lr1) FHLB 7.625% Due 05-14-10 (3133mbja6) FHLB 4.875% Due 05-14-10 (3133xkxd2) FHLMC 1.080% Due 05-25-10 (3128x8ly6) FFCB 2.350% Due 06-15-10 (31331ghb8) FNMA 5.500% Due 07-09-10 (31398aee8) FHLB 3.500% Due 07-16-10 (3133xrn22) FHLMC 4.790% Due 08-04-10 (3128x4gl9) FHLB 4.500% Due 09-10-10 (3133xcur2) FFCB 4.875% Due 02-18-11 (31331vsk3) FHLB 4.625% Due 02-18-11 (3133xecu1) FFCB 2.625% Due 04-21-11 (31331yg46) FHLB 3.125% Due 06-10-11 (3133xr4u1)
GRAND TOTAL
Purchased Interest
Sold Interest
Interest Received
Earned Interest
Ending Accrued Interest
Amortization/ Accretion
Adjusted Earned Income
0.00 0.00 0.00 0.00 0.00 14,388.89 21,369.86
103,819.44 0.00 127,932.29 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00
162,500.00 0.00 0.00 0.00 0.00 0.00 0.00
70,416.67 0.00 93,041.67 0.00 0.00 80,937.50 120,205.48
11,736.11 0.00 220,973.96 0.00 0.00 95,326.39 141,575.34
-62,250.60 24,052.87 -73,445.29 24,812.50 11,993.06 -64,800.00 0.00
8,166.07 24,052.87 19,596.38 24,812.50 11,993.06 16,137.50 120,205.48
0.00 166,527.78 0.00 0.00 0.00 0.00 5,222.22 165,865.33 240,625.00 0.00 150,751.87 90,052.08 85,434.03 15,312.50 7,291.67 3,159,855.19
2,625.00 0.00 0.00 129,415.31 77,838.85 0.00 0.00 0.00 0.00 52,828.38 0.00 0.00 0.00 0.00 0.00 494,459.27
0.00 0.00 0.00 0.00 0.00 0.00 0.00 173,580.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,282,126.87
0.00 275,000.00 0.00 0.00 0.00 0.00 0.00 0.00 262,500.00 0.00 244,462.50 121,875.00 115,625.00 0.00 0.00 2,674,631.88
12,541.67 137,500.00 34,533.33 59,837.19 35,607.14 21,600.00 29,375.00 7,714.67 131,250.00 162,258.59 122,231.25 60,937.50 57,812.50 19,687.50 31,250.00 3,298,050.87
15,166.67 29,027.78 34,533.33 189,252.50 113,445.99 21,600.00 34,597.22 0.00 109,375.00 215,086.97 28,520.62 29,114.58 27,621.53 35,000.00 38,541.67 2,995,606.58
386.77 -62,349.77 -445.46 -47,720.37 -25,283.54 -283.84 -242.31 -3,933.34 -62,259.04 -108,638.57 -66,393.87 -35,543.84 -31,529.69 -4,141.54 -9,077.30 -1,001,312.96
12,928.44 75,150.23 34,087.87 12,116.82 10,323.60 21,316.16 29,132.69 3,781.33 68,990.96 53,620.02 55,837.38 25,393.66 26,282.81 15,545.96 22,172.70 2,296,737.91
3,159,855.19
494,459.27
1,282,126.87
2,674,631.88
3,298,050.87
2,995,606.58
-1,001,312.96
2,296,737.91
Page 12 of 17
Plano ISD AMORTIZATION AND ACCRETION From 12-31-08 To 03-31-09 Purchase Information Purchase Quantity Pooled Funds Bank of America, N.A. CD 3.550% Due 01-13-09 (337089917) FHLB Disc Note 0.000% Due 02-04-09 (313385bl9) FHLB 2.750% Due 02-06-09 (3133xpne0) Bank of America, N.A. CD 1.700% Due 02-09-09 (337100115) FHLB 5.000% Due 02-13-09 (3133xek24) FHLMC 4.875% Due 02-17-09 (3137eaaa7) FHLMC 4.750% Due 03-05-09 (3137eaaq2) FNMA 4.300% Due 03-09-09 (3136f6m22) FHLMC 5.750% Due 03-15-09 (3134a3em4) FHLMC 5.750% Due 03-15-09 (3134a3em4) FHLB 3.400% Due 04-02-09 (3133xseq7) FHLB 3.000% Due 04-15-09 (3133x4zc8) FNMA 4.875% Due 04-15-09 (31359mk69) FHLB 2.500% Due 04-24-09 (3133xqyq9) FHLB Disc Note 0.000% Due 05-01-09 (313385fa9) FHLB 2.480% Due 05-07-09 (3133xqza3) Bank of America, N.A. CD 0.620% Due 05-11-09 (337119822) FNMA 4.250% Due 05-15-09 (31359mve0) Citigroup Funding TLGP (FDIC) 0.000% Due 05-18-09 (17314gsj9) FHLB 5.250% Due 06-12-09 (3133xflg9) Bank of America, N.A. CD 1.400% Due 06-15-09 (337109870) FHLMC Disc Note 0.000% Due 06-22-09 (313397he4) FHLB 3.000% Due 06-23-09 (3133xrp46) Citigroup Funding TLGP (FDIC) 0.000% Due 06-24-09 (17314gtq2) FHLB 2.700% Due 06-30-09 (3133xreu0) FHLMC 4.250% Due 07-15-09 (3134a4us1) GE Capital Corp CP TLGP (FDIC) 0.000% Due 07-20-09 (36161cul4) Bank of America, N.A. CD 1.080% Due 08-03-09 (337118892) FHLB 5.125% Due 08-05-09 (3133xlum3) FNMA 5.375% Due 08-15-09 (31359mu68) Bank of America, N.A. CD 1.150% Due 08-17-09 (337121140) FHLMC 6.625% Due 09-15-09 (3134a3m78) FHLB 5.000% Due 09-18-09 (3133xgnj9) FHLMC Disc Note 0.000% Due 10-13-09 (313397mx6) FHLMC 4.125% Due 11-18-09 (3128x3k85) FFCB Disc Note 0.000% Due 11-18-09 (313313pk8)
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,000,000.00 10,000,000.00 8,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 25,000,000.00 4,025,000.00 20,000,000.00 3,725,000.00 20,000,000.00 5,000,000.00 3,500,000.00 15,000,000.00 4,000,000.00 10,000,000.00 16,000,000.00 54,000,000.00 2,000,000.00 3,823,000.00 25,000,000.00 20,000,000.00 6,500,000.00 24,990,000.00 14,500,000.00 5,000,000.00
Date
Price
10/15/2008 9/30/2008 2/8/2008 11/10/2008 8/4/2008 3/17/2008 3/14/2008 9/29/2008 7/28/2008 11/3/2008 10/2/2008 4/24/2008 10/27/2008 5/22/2008 10/29/2008 7/28/2008 2/9/2009 11/19/2008 12/16/2008 10/29/2008 12/16/2008 10/15/2008 9/15/2008 1/21/2009 6/10/2008 10/29/2008 1/21/2009 2/3/2009 11/19/2008 11/19/2008 2/18/2009 12/17/2008 1/13/2009 2/5/2009 2/5/2009 11/19/2008
0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 100.010 100.714 100.900 100.076 98.477 99.649 100.000 101.192 99.753 101.295 100.000 97.965 100.283 99.773 99.831 100.794 99.710 100.000 102.135 102.450 100.000 104.261 103.045 99.562 102.634 97.993
Total Cost
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,000,980.00 10,071,400.00 8,072,000.00 10,007,600.00 9,847,688.89 9,964,900.00 25,000,000.00 4,072,969.95 19,950,700.00 3,773,249.93 20,000,000.00 4,898,263.89 3,509,919.00 14,965,991.67 3,993,252.00 10,079,400.00 15,953,600.00 54,000,000.00 2,042,706.00 3,916,659.68 25,000,000.00 20,852,300.00 6,697,925.00 24,880,668.75 14,881,915.50 4,899,647.22
Date To Date
0.00 30,977.78 0.00 0.00 -12,922.28 -11,745.20 -22,375.62 -21,381.74 -57,181.22 -34,713.71 -484.62 -18,050.56 -38,117.65 -2,029.67 74,500.00 11,162.54 0.00 -24,391.50 29,000.00 -19,214.57 0.00 36,625.00 -3,176.90 15,458.33 1,574.98 -27,590.73 18,044.44 0.00 -14,839.92 -31,335.95 0.00 -282,011.03 -62,250.60 24,052.87 -73,445.29 24,812.50
Amortization/Accretion Information Total To Date Balance
0.00 115,711.11 -1,471.87 0.00 -58,000.00 -84,215.60 -126,440.00 -51,380.00 -180,160.00 -62,770.00 -974.62 -68,592.13 -66,070.59 -7,081.31 127,477.78 30,634.98 0.00 -36,045.22 34,155.56 -32,878.27 0.00 68,366.67 -6,989.19 15,458.33 5,162.44 -47,210.81 18,044.44 0.00 -21,930.11 -46,307.57 0.00 -329,012.87 -62,250.60 24,052.87 -73,445.29 36,667.36
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -5.38 -2,807.87 -5,929.41 -518.69 24,833.33 4,465.02 0.00 -11,924.73 15,144.44 -15,371.66 0.00 33,369.44 -2,929.81 18,550.00 1,585.56 -32,189.19 28,355.56 0.00 -20,775.89 -47,352.11 0.00 -523,287.13 -135,674.40 85,278.37 -308,470.21 63,685.42
Adjusted Cost
10,000,005.38 10,002,807.87 8,005,929.41 10,000,518.69 9,975,166.67 9,995,534.98 25,000,000.00 4,036,924.73 19,984,855.56 3,740,371.66 20,000,000.00 4,966,630.56 3,502,929.81 14,981,450.00 3,998,414.44 10,032,189.19 15,971,644.44 54,000,000.00 2,020,775.89 3,870,352.11 25,000,000.00 20,523,287.13 6,635,674.40 24,904,721.62 14,808,470.21 4,936,314.58
Page 13 of 17
Plano ISD AMORTIZATION AND ACCRETION From 12-31-08 To 03-31-09 Purchase Information Purchase Quantity FHLB Disc Note 0.000% Due 11-24-09 (313385pr1) FNMA 4.625% Due 12-15-09 (31359m2s1) Bank of America, N.A. CD 1.950% Due 12-16-09 (337109871) FHLB 1.050% Due 03-09-10 (3133xt3e4) FHLB 2.750% Due 03-12-10 (3133xpy57) FHLMC 1.120% Due 04-15-10 (3128x8lr1) FHLB 7.625% Due 05-14-10 (3133mbja6) FHLB 4.875% Due 05-14-10 (3133xkxd2) FHLMC 1.080% Due 05-25-10 (3128x8ly6) FFCB 2.350% Due 06-15-10 (31331ghb8) FNMA 5.500% Due 07-09-10 (31398aee8) FHLB 3.500% Due 07-16-10 (3133xrn22) FHLMC 4.790% Due 08-04-10 (3128x4gl9) FHLB 4.500% Due 09-10-10 (3133xcur2) FFCB 4.875% Due 02-18-11 (31331vsk3) FHLB 4.625% Due 02-18-11 (3133xecu1) FFCB 2.625% Due 04-21-11 (31331yg46) FHLB 3.125% Due 06-10-11 (3133xr4u1) GRAND TOTAL
10,000,000.00 7,000,000.00 25,000,000.00 10,000,000.00 20,000,000.00 30,000,000.00 6,570,000.00 6,115,000.00 20,000,000.00 5,000,000.00 0.00 15,000,000.00 28,360,000.00 10,865,000.00 5,000,000.00 5,000,000.00 3,000,000.00 4,000,000.00
Date
Price
2/5/2009 12/30/2008 12/16/2008 2/18/2009 12/17/2008 2/24/2009 2/18/2009 2/18/2009 2/25/2009 12/15/2008 3/13/2008 12/17/2008 2/18/2009 12/16/2008 12/16/2008 12/16/2008 12/16/2008 12/16/2008
99.363 103.600 100.000 99.964 101.563 100.017 107.822 104.453 100.018 100.010 0.000 102.661 104.868 104.297 106.262 105.555 101.314 102.286
Total Cost
Date To Date
Amortization/Accretion Information Total To Date Balance
Adjusted Cost
9,936,327.78 7,252,000.00 25,000,000.00 9,996,440.00 20,312,680.00 30,005,160.00 7,083,931.68 6,387,294.84 20,003,700.00 5,000,490.00 0.00 15,399,105.00 29,740,649.88 11,331,869.05 5,313,100.00 5,277,740.00 3,039,417.00 4,091,440.00
11,993.06 -64,800.00 0.00 386.77 -62,349.77 -445.46 -47,720.37 -25,283.54 -283.84 -242.31 -3,933.34 -62,259.04 -108,638.57 -66,393.87 -35,543.84 -31,529.69 -4,141.54 -9,077.30
11,993.06 -66,240.00 0.00 386.77 -72,741.40 -445.46 -47,720.37 -25,283.54 -283.84 -288.08 -148,483.49 -72,635.55 -108,638.57 -78,197.22 -41,862.74 -37,134.96 -4,877.81 -10,691.05
51,679.16 -185,760.00 0.00 3,173.23 -239,938.60 -4,714.54 -466,211.31 -247,011.30 -3,416.16 -201.92 0.00 -326,469.45 -1,272,011.31 -388,671.83 -271,237.26 -240,605.04 -34,539.19 -80,748.95
9,948,320.84 7,185,760.00 25,000,000.00 9,996,826.77 20,239,938.60 30,004,714.54 7,036,211.31 6,362,011.30 20,003,416.16 5,000,201.92 15,326,469.45 29,632,011.31 11,253,671.83 5,271,237.26 5,240,605.04 3,034,539.19 4,080,748.95
556,505,082.71
-1,001,312.96
-1,590,638.76
-4,538,653.81
555,511,653.80
Page 14 of 17
Plano ISD PROJECTED FIXED INCOME CASH FLOWS Beginning April 1, 2009 SECURITY DESCRIPTION
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
JAN
FEB
MAR
TOTAL
AGENCY COUPON SECURITIES FHLB 3.400% Due 04-02-09 (3133xseq7)
10,170,000.00
10,170,000.00
FHLB 3.000% Due 04-15-09 (3133x4zc8)
10,150,000.00
10,150,000.00
8,195,000.00
8,195,000.00
10,250,000.00
10,250,000.00
FNMA 4.875% Due 04-15-09 (31359mk69) FHLB 2.500% Due 04-24-09 (3133xqyq9) FHLB 2.480% Due 05-07-09 (3133xqza3) FNMA 4.250% Due 05-15-09 (31359mve0)
10,248,000.00
10,248,000.00
4,110,531.25
4,110,531.25
FHLB 5.250% Due 06-12-09 (3133xflg9)
3,822,781.25
3,822,781.25
FHLB 3.000% Due 06-23-09 (3133xrp46)
3,552,500.00
3,552,500.00
FHLB 2.700% Due 06-30-09 (3133xreu0)
4,117,000.00
4,117,000.00
FHLMC 4.250% Due 07-15-09 (3134a4us1)
10,212,500.00
10,212,500.00
FHLB 5.125% Due 08-05-09 (3133xlum3)
2,051,250.00
2,051,250.00
FNMA 5.375% Due 08-15-09 (31359mu68)
3,925,743.12
3,925,743.12
FHLMC 6.625% Due 09-15-09 (3134a3m78) FHLB 5.000% Due 09-18-09 (3133xgnj9) FHLMC 4.125% Due 11-18-09 (3128x3k85)
20,662,500.00
20,662,500.00
6,662,500.00
6,662,500.00
299,062.50
FNMA 4.625% Due 12-15-09 (31359m2s1)
14,799,062.50 161,875.00
15,098,125.00 7,161,875.00
7,323,750.00
FHLB 1.050% Due 03-09-10 (3133xt3e4) FHLB 2.750% Due 03-12-10 (3133xpy57)
275,000.00
FHLMC 1.120% Due 04-15-10 (3128x8lr1)
168,000.00
10,113,750.00
10,113,750.00
20,275,000.00
20,550,000.00
168,000.00
336,000.00
FHLB 7.625% Due 05-14-10 (3133mbja6)
250,481.25
250,481.25
500,962.50
FHLB 4.875% Due 05-14-10 (3133xkxd2)
149,053.12
149,053.12
298,106.25
FHLMC 1.080% Due 05-25-10 (3128x8ly6) FFCB 2.350% Due 06-15-10 (31331ghb8) FHLB 3.500% Due 07-16-10 (3133xrn22) FHLMC 4.790% Due 08-04-10 (3128x4gl9) FHLB 4.500% Due 09-10-10 (3133xcur2)
108,000.00
108,000.00
58,750.00
216,000.00
58,750.00 262,500.00
117,500.00 262,500.00
679,222.00
525,000.00 679,222.00
244,462.50
1,358,444.00 244,462.50
488,925.00
Page 15 of 17
Plano ISD PROJECTED FIXED INCOME CASH FLOWS Beginning April 1, 2009 SECURITY DESCRIPTION
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
JAN
FEB
MAR
TOTAL
FFCB 4.875% Due 02-18-11 (31331vsk3)
121,875.00
121,875.00
243,750.00
FHLB 4.625% Due 02-18-11 (3133xecu1)
115,625.00
115,625.00
231,250.00
FFCB 2.625% Due 04-21-11 (31331yg46)
39,375.00
39,375.00
FHLB 3.125% Due 06-10-11 (3133xr4u1) Total
AGENCY DISCOUNT NOTES FHLB Disc Note 0.000% Due 05-01-09 (313385fa9)
78,750.00
62,500.00 38,804,375.00 15,057,128.12 11,775,406.25 10,475,000.00
62,500.00 7,169,715.12 27,844,462.50
39,375.00 15,198,596.87
7,283,125.00
10,000,000.00
FHLMC Disc Note 0.000% Due 06-22-09 (313397he4)
125,000.00 262,500.00
1,192,722.00 30,633,212.50
165,735,618.37
10,000,000.00 5,000,000.00
5,000,000.00
FHLMC Disc Note 0.000% Due 10-13-09 (313397mx6)
24,990,000.00
24,990,000.00
FFCB Disc Note 0.000% Due 11-18-09 (313313pk8)
5,000,000.00
5,000,000.00
FHLB Disc Note 0.000% Due 11-24-09 (313385pr1)
10,000,000.00
10,000,000.00
24,990,000.00 15,000,000.00
54,990,000.00
Total
10,000,000.00
CERTIFICATES OF DEPOSIT Bank of America, N.A. CD 0.620% Due 05-11-09 (337119822)
25,038,643.84
Bank of America, N.A. CD 1.400% Due 06-15-09 (337109870)
5,000,000.00
25,038,643.84
20,138,849.32
20,138,849.32
Bank of America, N.A. CD 1.080% Due 08-03-09 (337118892)
54,289,203.29
54,289,203.29
Bank of America, N.A. CD 1.150% Due 08-17-09 (337121140)
25,141,780.82
25,141,780.82
Bank of America, N.A. CD 1.950% Due 12-16-09 (337109871) Total
25,038,643.84 20,138,849.32
COMMERCIAL PAPER Citigroup Funding TLGP (FDIC) 0.000% Due 05-18-09 (17314gsj9)
20,000,000.00
79,430,984.11
25,487,500.00
25,487,500.00
25,487,500.00
150,095,977.26
20,000,000.00
Page 16 of 17
Plano ISD PROJECTED FIXED INCOME CASH FLOWS Beginning April 1, 2009 SECURITY DESCRIPTION
Citigroup Funding TLGP (FDIC) 0.000% Due 06-24-09 (17314gtq2) GE Capital Corp CP TLGP (FDIC) 0.000% Due 07-20-09 (36161cul4) Total
Grand Total
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
JAN
FEB
MAR
TOTAL
15,000,000.00
15,000,000.00
16,000,000.00
16,000,000.00
20,000,000.00 15,000,000.00 16,000,000.00
51,000,000.00
38,804,375.00 70,095,771.96 51,914,255.57 26,475,000.00 86,600,699.23 27,844,462.50 25,029,375.00 30,198,596.87 32,770,625.00
262,500.00
1,192,722.00 30,633,212.50
421,821,595.64
Page 17 of 17
Related Documents
First Quarter 2009 Pisd Investments
May 2020 2
2009-2010 Pisd Budget
May 2020 8
Framework First Quarter 09
April 2020 9
First Quarter 2007 Report
November 2019 27
First Quarter 2008 Report
November 2019 20
First Quarter 2009_ Newsletter
May 2020 9More Documents from "Eric"
Plano Isd School Transfer Requests
June 2020 5
2009-2010 Pisd Budget Chart Of Acounts
May 2020 3
Plano Isd Proposed Tax Rate
May 2020 1
2009-2010 Pisd Budget
May 2020 8
First Quarter 2009 Pisd Investments
May 2020 2