HomeMy WebLinkAbout2010-05-11; City Council; 20226; Report on City Investments 3/31/201010
CITY OF CARLSBAD - AGENDA BILL
AB# 20,226
MTG. 5/11/10
DEPT. TRS
REPORT ON CITY INVESTMENTS
AS OF MARCH 31, 2010
DEPT. HEAD "ft. v
CITY ATTY. ///
CITYMGR. // U/—
RECOMMENDED ACTION:
Accept and file report.
ITEM EXPLANATION:
The City's Investment Policy requires the City Treasurer to report to the City Council on a monthly
basis the status of the City's pooled investment portfolio. A quarterly report is also required for
the investments of bond proceeds held separately. The City's pooled investment portfolio as of
the month ended March 31, 2010 is summarized below.
Pooled Investment Portfolio (Cash and Securities)
Par Value
Cost of Investments
Amortized Cost (1)
Market Value (2)
Current Month
545,440,381
554,268,383
550,889,413
558,609,034
Prior Month
547,608,552
555,586,190
552,426,247
561,564,666
(1) The cost of investments adjusted for amortized premiums and discounts.
(2) The amount at which the investments could be sold. Source of market values is Union Bank
of California's custodial report as of 3/31/10.
The equity portion of the various funds in the total portfolio is summarized in the graph below.
Fund balances are restricted for various purposes. See Exhibit 8 for a more detailed breakdown.
FUND EQUITY IN POOLED INVESTMENTS
(Dollar Amounts in Millions)
General
Special Revenue
$47
Internal Service S.9
$27
Capital Projects
$277
Agency $)3
Enterprise $125
Total Treasurer's Investment Portfolio at Amortized Cost
March 31, 2010 S550.9 million
FOR CITY CLERKS USE ONLY.
COUNCIL ACTION: APPROVED D
DENIED D
CONTINUED D
WITHDRAWN D
AMENDED D
CONTINUED TO DATE SPECIFIC D
CONTINUED TO DATE UNKNOWN D
RETURNED TO STAFF D
OTHER - SEE MINUTES D
Council received tbe report.
DEPARTMENT CONTACT: Nancy Sullivan (760) 602-2473 nsull@ci.carlsbad.ca.us
PAGE 2 OF AB REPORT ON CITY INVESTMENTS AS OF MARCH 31. 2010
Pooled Investment Interest Income
Cash Income Fiscal
Year-to-Date *
Current
Month FYTD
14,384,338
Prior
Month FYTD
12,914,913
Current Month
Income
1,469,425
*The cash income received is adjusted for any accrued interest purchased.
Pooled Investment Performance/Measurement
January 2010
February 2010
March 2010
Average Life
(Years)
1.55
1.50
1.64
Average Yield
To Maturity
2.44%
2.41%
2.42%
Modified Duration
1.481
1.432
1.557
All pooled investments have been made in accordance with the City's Investment Policy adopted
January 2, 1985 and last revised March 23, 2010. All investments were initially made in
accordance with the City's Investment Policy. Events subsequent to the purchase might have
resulted in some investments not being in compliance with the current policy. These events are
typically a change in the City's Investment Policy, a change in the credit rating subsequent to a
purchase, or a temporary reduction in total portfolio assets. See Exhibit 9 for details.
The pooled investment portfolio has the ability to meet the City's cash flow demands for the next
six (6) months.
Investment Portfolio for Bond Proceeds
Par Value
Cost
Current Quarter
21,533,504
21,533,504
Prior Quarter
21,610,233
21,610,233
EXHIBITS FOR POOLED INVESTMENTS:
1. Investment Portfolio Breakdown By Amortized Cost, Market Value, Cash Income, and Average Yield
2. Investment Portfolio Breakdown Of Maturities
3. Yield Comparison Graph
4. Market Yield Curve
5. Cumulative Cash Income Graph
EXHIBITS FOR POOLED INVESTMENTS: (continued)
6. Third Quarter Transactions
7. Detailed Investment Report
8. Fund Equity in Pooled Investments
9. Corporate Note and Commercial Paper Ratings
10. Percentage Weightings By Corporate Note Issuer
EXHIBIT FOR INVESTMENTS OF BOND PROCEEDS HELD SEPARATELY:
11. Detailed Investment Report - Quarterly Report
EXHIBIT FOR SUMMARY OF OUTSTANDING HOUSING LOANS:
12. Detail Of Outstanding Housing Loans - Quarterly Report
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF MARCH 31, 2010
BREAKDOWN BY AMORTIZED COST, MARKET VALUE, CASH INCOME, AND AVERAGE YIELD BY CLASS
AMORTIZED COST MARKET VALUE AVERAGE YIELD
Class
CD
FN
CP
TR
FA
CN
LAIF
CUSTODY
SWEEP
BANKACCT
Current Month
33,000
11,370,031
0
116,417,051
295,882,565
102,965,465
19,455,089
2,300,000
2,058,021
408,191
Prior Month Current Month
33,000
9,463,627
0
111,471,940
286,047,300
103,020,908
36,955,015
3,000,000
1,861,263
573,193
33,000
11,485,060
0
116,527,660
300,038,776
106,303,236
19,455,089
2,300,000
2,058,021
408,191
Prior Month
33,000
9,668,950
0
111,662,620
291,269,624
106,541,001
36,955,015
3,000,000
1,861,263
573,193
Cash Income
Year to Date Current Month Prior Month
225
0
0
758,513
8,876,142
4,155,800
592,143
96
1,418
0
0.05
2.58
0.00
0.50
2.70
4.21
0.56
0.05
0.10
0.10
0.90
2.72
0.00
0.48
2.79
4.21
0.56
0.05
0.10
0.10
TOTALS $550,889,413 $552,426,247 $558,609,034 $561,564,666 $14,384,338 2.42%2.41%
CD - Certificate of Deposit
FN - Federal Discount Notes
CP - Corporate Paper
TR - US Treasury
FA - Federal Agency
CN - Corporate Notes
LAIF - Local Agency Investment Fund
Custody - Investment Cash account
SWEEP - General Fund Overnight Cash acccount
Bank Account - General Fund Cash account
mx
DO
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF MARCH 31, 2010
BREAKDOWN OF MATURITIES BY CLASSIFICATION AND LENGTH OF TIME
CLASS
CD
FN
CP
TR
FA
CN
LAIF
CUSTODY
SWEEP
BANK ACCT
TOTALS
% TOTALS
Total within One
WITHIN 6 MONTHS
33,000
0
0
49,603,021
47,934,097
16,075,380
19,455,089
2,300,000
2,058,021
408,191
$137,866,799 (1)
24.9%
Year
7 MONTHS TO 1 YEAR
0
956,370
0
34,215,211
20,278,132
11,935,830
0
0
0
0
$67,385,542 (1)
12.2%
$205,252,342 (1)
1 TO 5 YEARS
0
10,126,814
0
33,223,318
229,896,245
75,769,665
0
0
0
0
$349,016,042
63.0%
TOTAL
33,000
11,083,184
0
117,041,550
298,108,474
103,780,875
19,455,089
2,300,000
2,058,021
408,191
$554,268,383
100.0%
% TOTAL
0.0%
2.0%
0.0%
21.1%
53.8%
18.7% (2)
3.5%
0.4%
0.4%
0.1%
100.0%
POLICY:
• 37.0%
(1) Not less than $126,950,000 to mature within one year. (2/3rds of current year operating budget of $190,416,000.00)
(2) Policy states that not more than 30% of portfolio is to be invested in corporate notes.
x:ni—i
DO
YIELD COMPARISON
PORTFOLIO EX-LAIF VS. LAIF
JULY 1996 - MARCH 2010
CO
MARKET YIELD CURVE
6/30/08,6/30/09,3/31/10
Market Rates
3Mth 2Yr 5Yr
3Mth 2Yr 5Yr 10 Yr
-•-06/30/2008
-*- 06/30/2009
<N 03/31/2010
1.73
.18
.15
2.62
1.11
1.02
3.33
2.56
2.54
3.97
3.53
3.83
10 Yr
X=n
I-H
CO
Cumulative
Millions $
Cumulative Cash Income
F Y09-10
(March 2010)
20
18
16
14
12
10
8
4
2
1.99
1.61 1.6 1.38 1.31 1.47
1.17
Monthly Interest Income
Millions $
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
Interest Income —«-- Budget Actual
8
7
6
5
4
3
2
1
0
CO
I—I
-H
City of Carlsbad
TRANSACTIONS FOR PERIOD:
01/01/10 TO 03/31/10 3rd QUARTER 2009-2010
Trans
Date
BUYS
JANUARY
01/13/2010
01/11/2010
01/11/2010
01/19/2010
01/19/2010
01/19/2010
01/19/2010
01/19/2010
01/20/2010
01/19/2010
FEBRUARY
02/03/2010
02/10/2010
02/11/2010
02/11/2010
02/11/2010
02/12/2010
02/22/2010
02/22/20 10
02/22/2010
02/05/2010
MARCH
03/02/2010
02/22/2010
02/22/2010
02/22/2010
03/04/2010
03/05/2010
03/08/2010
03/15/2010
03/12/2010
03/23/2010
03/23/2010
03/23/2010
03/23/2010
03/23/2010
03/23/2010
03/23/2010
Investment
Date
01/26/2010
01/19/2010
01/22/2010
01/20/2010
01/20/2010
01/20/2010
01/20/2010
01/22/2010
01/25/2010
01/21/2010
02/08/2010
02/11/2010
02/12/2010
02/12/2010
02/12/2010
02/19/2010
02/23/2010
02/23/2010
02/26/2010
02/26/2010
03/02/2010
03/10/2010
03/09/2010
03/10/2010
03/22/2010
03/08/2010
03/09/2010
03/16/2010
03/23/2010
03/24/2010
03/24/2010
03/24/2010
03/24/2010
03/24/2010
03/24/2010
03/24/2010
Maturity
Date
07/26/2013
07/19/2012
07/22/201 1
11/18/2010
07/31/2011
07/15/2012
07/20/2012
08/10/2012
08/10/2012
07/21/2014
06/15/2012
10/26/2011
12/31/2010
02/12/2014
04/28/2014
08/15/2013
10/07/2013
09/30/201 1
08/26/2013
08/26/2013
04/02/2010
06/10/2013
03/09/2015
09/10/2013
09/22/2014
09/21/2012
06/27/2013
08/10/2012
03/23/2015
07/27/2012
09/27/2013
06/13/2014
08/13/2014
09/12/2014
09/22/2014
10/31/2011
Type
FA
FA
FA
TR
TR
FA
FA
FA
FA
FA
CN
FA
TR
FA
FA
FA
FA
TR
FA
FA
CD
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
TR
Security
FHLB
FHLMC
FHLB
US TREASURY
US TREASURY
FHLMC
FNMA
FNMA
FAMCA
FNMA
GENERAL ELECTRIC
FFCB
US TREASURY
FFCB
FNMA
FHLMC
FFCB
US TREASURY
FHLMC
FNMA
WELLS FARGO CO
FHLMC
FNMA
FHLB
FNMA
FHLMC
FICO
FNMA
FHLMC
FHLB
FHLMC
FHLB
FHLB
FHLB
FFCB
US TREASURY
Call
Date
01/26/2011
07/19/2010
02/22/2010
N/A
N/A
N/A
07/20/2010
N/A
N/A
07/21/2010
N/A
04/26/2010
N/A
N/A
10/28/2010
02/15/2011
N/A
N/A
08/26/2010
08/26/2010
N/A
06/10/2010
09/09/2010
09/10/2010
09/22/2010
N/A
N/A
N/A
03/23/2011
N/A
N/A
N/A
N/A
N/A
N/A
N/A
Par
Value
2,000,000.00
3,000,000.00
1,000,000.00
4,000,000.00
1,000,000.00
1,000,000.00
1,250,000.00
1,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
4,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
3,000,000.00
1,000,000.00
2,000,000.00
33,000.00
1,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
3,000,000.00
2,000,000.00
3,000,000.00
4,000,000.00
2,000,000.00
3,000,000.00
3,000,000.00
3,000,000.00
2,000,000.00
2,000,000.00
8,000,000.00
Coupon
2.125%
1 .625%
1 .000%
0.000%
1 .000%
5.125%
1.500%
1 .750%
2.100%
3.030%
6.000%
0.950%
0.875%
3.000%
2. 125% STEP
1%STEP
3.875%
1 .000%
2.125%
2.050%
0.500%
2.000%
3.000%
2.100%
2.570%
2.125%
0.000%
1.750%
1%STEP
1 .250%
4.125%
2.500%
5.500%
5.250%
3.000%
1.000%
Amount
(Cost)
2,000,000.00
3,000,000.00
1,000,400.00
3,991,946.67
1,005,625.00
1,092,760.00
1,249,375.00
1,009,004.81
1,015,908.69
1,001,875.00
2,174,860.00
4,002,000.00
2,010,100.00
1,028,536.49
1,014,759.55
1,000,000.00
1,065,180.00
3,016,170.00
1,000,000.00
2,000,000.00
33,000.00
1,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
3,058,800.00
1,882,080.00
3,034,050.00
4,000,000.00
2,000,352.89
3,222,330.00
3,016,423.52
3,395,255.41
2,231,960.00
2,047,400.80
8,025,312.50
Return
Rate
2.125%
1.625%
0.973%
0.244%
0.630%
1.320%
1 .520%
1 .390%
1 .460%
2.985%
2.167%
0.921%
0.301%
2.250%
3.167%
2.054%
2.000%
0.660%
2.125%
2.050%
0.500%
2.000%
3.000%
2.100%
2.750%
1.336%
1.850%
1.268%
3.400%
1 .243%
1.930%
2.363%
2.323%
2.490%
2.440%
0.801%
Interest
148,750.00
121,875.00
14,600.00
8,053.33
9,673.91
34,653.19
47,500.00
35,717.41
37,466.31
134,475.00
107,473.33
62,916.67
5,321.27
91,463.51
121,601.56
72,388.89
75,181.11
31,797.03
74,375.00
143,500.00
1.42
65,000.00
165,000.00
73,500.00
231,300.00
102,877.08
235,840.00
91,950.00
680,000.00
58,188.78
211,826.25
300,034.82
328,452.92
237,040.00
222,265.87
102,864.30
Investment
Return
2,148,750.00
3,121,875.00
1,015,000.00
4,000,000.00
1,015,298.91
1,127,413.19
1,296,875.00
1,044,722.22
1,053,375.00
1,136,350.00
2,282,333.33
4,064,916.67
2,015,421.27
1,120,000.00
1,136,361.11
1,072,388.89
1,140,361.11
3,047,967.03
1,074,375.00
2,143,500.00
33,001.42
1,065,000.00
1,165,000.00
1,073,500.00
2,231,300.00
3,161,677.08
2,117,920.00
3,126,000.00
4,680,000.00
2,058,541.67
3,434,156.25
3,316,458.34
3,723,708.33
2,469,000.00
2,269,666.67
8,128,176.80
City of Carlsbad
TRANSACTIONS FOR PERIOD:
01/01/10 TO 03/31/10 3rd QUARTER 2009-2010
Trans
Date
Investment
Date
Maturity
Date
TOTAL THIRD QUARTER 2009-2010
MATURITIES
JANUARY
FEBRUARY
MARCH
02/01/2008
06/05/2009
07/22/2009
01/30/2008
01/31/2008
04/09/2008
01/28/2008
01/31/2008
09/29/2008
06/01/2009
06/05/2009
05/11/2009
07/22/2009
01/28/2008
02/04/2008
02/13/2008
04/02/2008
10/30/2008
06/05/2009
03/02/2009
01/29/2010
01/31/2010
01/31/2010
01/15/2010
01/15/2010
01/15/2010
02/12/2010
02/12/2010
02/12/2010
02/09/2010
02/15/2010
02/28/201 0
02/28/2010
03/08/2010
03/12/2010
03/12/2010
03/12/2010
03/12/2010
03/31/2010
03/02/2010
Type
FA
TR
TR
CN
CN
CN
FA
FA
FA
FN
TR
TR
TR
FA
FA
FA
FA
FA
TR
CD
Security
FHLMC
US TREASURY
US TREASURY
BERKSHIRE HATHA\
BERKSHIRE HATHA\
WELL FARGO CO
FHLB
FHLB
FHLMC
FHLBN
US TREASURY
US TREASURY
US TREASURY
FNMA
FHLB
FHLB
FHLB
FHLB
US TREASURY
WELL FARGO CO
Call
Date
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
TOTAL THIRD QUARTER 2009-2010
CALLS and / or SALES
JANUARY
FEBRUARY
X^
^
01/23/2008
08/10/2009
02/12/2009
05/14/2009
11/17/2009
05/19/2009
01/22/2010
01/07/2013
08/10/2012
02/12/2014
05/14/2014
05/17/2013
02/19/2013
07/22/201 1
FA
FA
FA
FA
FA
FA
FA
FHLB
FHLB
FNMA
FNMA
FHLB
FNMA
FHLB
01/14/2010
02/10/2010
02/12/2010
08/14/2014
02/17/2010
02/19/2013
02/22/2010
Par
Value
74,283,000.00
3,000,000.00
3,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
3,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
3,000,000.00
3,000,000.00
33,000.00
39,033,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
Coupon
3.250%
2.125%
2.125%
4.125%
4.125%
4.200%
3.875%
7.375%
3.125%
0.000%
6.500%
2.000%
2.000%
4.400%
2.375%
2.375%
2.750%
2.750%
1 .750%
0.900%
4.700%
2.000%
2% STEP
2% STEP
1.1 25% STEP
2.320%
1.000%
Amount
(Cost)
75,625,466.33
3,000,000.00
3,035,156.25
2,019,531.25
2,040,548.16
2,038,582.81
1,018,383.81
1,020,550.00
2,177,668.00
2,997,750.00
997,329.44
3,128,320.31
2,025,000.00
1,010,312.50
2,064,240.00
1,989,880.00
1,994,095.84
1,006,020.00
2,978,060.95
3,033,867.19
33,000.00
39,608,296.51
2,056,800.00
1,999,500.00
2,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,400.00
Return
Rate
0.277%
3.250%
0.331%
0.262%
3.050%
3.100%
3.120%
2.830%
2.841%
3.180%
0.386%
0.342%
0.411%
0.303%
2.821%
2.622%
2.520%
2.430%
3.300%
0.369%
0.900%
0.682%
4.061%
2.009%
3.500%
2.000%
3.297%
2.320%
0.973%
Interest
4,484,923.96
194,458.33
28,593.75
2,775.38
121,014.34
122,750.52
55,816.19
58,456.94
122,248.67
130,635.42
2,670.56
7,425.55
7,173.91
1,861.41
121,537.78
110,133.89
104,730.55
47,452.22
134,689.05
9,165.60
620.00
1,384,210.06
409,022.22
121,500.00
355,000.00
320,000.00
235,000.00
87,000.00
14,600.00
Investment
Return
80,110,390.29
3,194,458.33
3,063,750.00
2,022,306.63
2,161,562.50
2,161,333.33
1,074,200.00
1,079,006.94
2,299,916.67
3,128,385.42
1,000,000.00
3,135,745.86
2,032,173.91
1,012,173.91
2,185,777.78
2,100,013.89
2,098,826.39
1,053,472.22
3,112,750.00
3,043,032.79
33,620.00
40,992,506.57
2,465,822.22
2,121,000.00
2,355,000.00
2,320,000.00
2,235,000.00
1,087,000.00
1,015,000.00
City of Carlsbad
TRANSACTIONS FOR PERIOD:
01/01/10 TO 03/31/10
Trans Investment Maturity
Date
MARCH
Date Date Type
03/12/2009 09/12/2012
12/29/2009 06/29/2012
03/26/2007 03/26/2012
03/26/2007 03/26/2012
04/20/2007 03/26/2012
FA
FA
FA
FA
FA
FHLMC
FHLB
FHLMC
FHLMC
FHLMC
3rd QUARTER 2009-2010
Security
TOTAL THIRD QUARTER 2009-2010
Call
Date
03/12/2010
03/29/2010
03/26/2010
03/26/2010
03/26/2010
Par
Value
2,000,000.00
3,000,000.00
3,000,000.00
2,000,000.00
1,000,000.00
Coupon
2% STEP
1.450%
5.000%
5.000%
5.000%
Amount
(Cost)
2,000,000.00
2,997,750.00
3,000,000.00
2,000,000.00
999,687.50
Return
Rate
2.710%
1.481%
5.000%
5.000%
5.006%
Interest
190,000.00
111,000.00
750,000.00
500,000.00
246,979.17
Investment
Return
2,190,000.00
3,108,750.00
3,750,000.00
2,500,000.00
1,246,666.67
23,000,000.00 23,054,137.50 3.172% 3,340,101.39 26,394,238.89
INVESTMENT REPORT
AS OF MARCH 31,2010
INVESTMENT
DATE
04/22/2008
01/28/2008
07/25/2007
04/22/2008
05/05/2008
12/21/2007
03/16/2009
02/26/2008
05/08/2008
04/17/2009
08/05/2008
10/09/2007
07/25/2007
07/15/2008
03/12/2008
02/20/2008
02/13/2008
10/30/2007
02/12/2008
09/18/2007
09/26/2007
05/08/2008
12/05/2008
03/11/2009
09/26/2007
110/13/2009
06/01/2009
05/05/2008
04/22/2009
06/03/2009
06/01/2009
06/03/2009
12/05/2008
02/20/2008
06/03/2009
05/11/2009
05/12/2009
06/22/2009
08/31/2007
05/08/2008
09/17/2008
03/09/2007
08/01/2007
08/31/2007
05/08/2008
TYPE
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
SECURITY
FFCB 2.375% NON-CALL
FHLMC4.02% NON-CALL
FFCB 4.780% NON-CALL
FFCB 5.320% NON-CALL
FHLB 7.625% NON-CALL
FNMA 3.625% NON-CALL
FHLB 1.250% NON-CALL
FHLB 4.25% NON-CALL
FHLB 3.00% NON-CALL
FHLB 5.25% NON-CALL
FHLMC3.50% NON-CALL
FHLB 4.5% NON-CALL
FNMA 5.125% NON-CALL
FFCB 3.200% NON-CALL
FHLB 4.44% NON-CALL
FNMA 4.70% NON-CALL
FHLB 5.00% NON-CALL
FHLB 4.7% NON-CALL
FHLB 3.190% CALL 8/12/08
FHLMC 5.125% NON-CALL
FHLB 5.125% NON-CALL
FHLB 3.00% NON-CALL
FHLB 3.375% NON-CALL
FHLB 1.4% NON-CALL
FFCB 5.25% NON-CALL
FHLB .35% CALL 4/13/10
FHLB 1.25% NON-CALL
FHLB 4.375% NON-CALL
FHLB 1.125% NON-CALL
FHLB 4.375% NON-CALL
FHLB 1.050% NON-CALL
FHLB 1.050% NON-CALL
FHLMC 4.50% NON-CALL
FHLB 2.875% NON-CALL
FNMA 2.050% CALL 4/1/10
FHLB 1.375% NON-CALL
FNMA 1.45% CALL
FHLB 1.125% NON-CALL
FHLB 5.275% NON-CALL
FHLB 5.25% NON-CALL
FHLB 5.25% NON-CALL
FNMA 3.64% NON-CALL
FAMCA5.50% NON-CALL
FAMCA5.50% NON-CALL
FAMCA5.5% NON-CALL
PAR
VALUE
2,000,000.00
1,500,000.00
2,000,000.00
1,000,000.00
3,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
3,000,000.00
3,000,000.00
1 ,000,000.00
1,000,000.00
1,000,000.00
3,000,000.00
2,550,000.00
1,000,000.00
3,000,000.00
3,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
3,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
3,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
629,000.00
2,000,000.00
INVESTED
AMOUNT
1,984,800.00
1,537,935.00
1,981,720.00
1,050,120.00
3,273,695.78
1,996,499.26
1,000,000.00
1,030,795.00
999,862.00
1,049,288.56
3,010,680.00
2,991,510.00
1,000,640.00
1,000,000.00
1,043,000.00
3,134,430.00
2,688,248.25
1,009,328.80
3,000,000.00
3,048,120.00
2,034,188.23
1,994,876.00
2,032,660.00
2,000,000.00
2,041,700.00
2,000,000.00
2,014,960.00
1,032,893.26
3,000,000.00
2,101,180.00
2,008,660.00
2,007,180.00
3,119,880.00
2,993,378.76
2,024,200.00
1,001,350.00
1,000,000.00
1,988,700.00
1,020,930.00
1,055,434.00
2,132,207.14
1,909,480.00
3,034,380.00
644,775.32
2,116,712.00
RETURN
RATE
2.776%
2.850%
5.135%
2.790%
2.950%
3.700%
1 .250%
2.849%
3.005%
0.930%
3.300%
4.610%
5.100%
3.200%
2.559%
2.786%
2.710%
4.337%
3.190%
4.530%
4.500%
3.115%
2.420%
1 .400%
4.490%
0.550%
0.700%
2.980%
1.125%
0.701%
0.750%
0.800%
2.470%
2.950%
1.377%
1 .305%
1.450%
1.420%
4.761%
3.345%
2.720%
4.805%
5.175%
4.781%
3.545%
INTEREST
108,220.83
97,740.00
283,304.44
59,087.78
189,522.97
180,118.80
15,625.00
66,482.78
62,888.00
11,086.44
185,028.33
373,365.00
150,405.14
64,000.00
62,326.67
209,453.33
175,897.58
121,226.76
239,250.00
402,452.92
268,756.21
145,457.34
86,402.50
41,922.22
269,508.33
11,000.00
19,276.11
74,901.88
50,625.00
20,104.72
21,906.67
23,270.00
154,245.00
270,402.49
50,738.89
25,653.47
29,000.00
55,112.50
181,976.25
106,732.67
154,501.19
406,997.78
618,286.67
118,184.21
233,760.22
INVESTMENT
RETURN
2,093,020.83
1,635,675.00
2,265,024.44
1,109,207.78
3,463,218.75
2,176,618.06
1,015,625.00
1,097,277.78
1,062,750.00
1,060,375.00
3,195,708.33
3,364,875.00
1,151,045.14
1,064,000.00
1,105,326.67
3,343,883.33
2,864,145.83
1,130,555.56
3,239,250.00
3,450,572.92
2,302,944.44
2,140,333.34
2,119,062.50
2,041,922.22
2,311,208.33
2,011,000.00
2,034,236.11
1,107,795.14
3,050,625.00
2,121,284.72
2,030,566.67
2,030,450.00
3,274,125.00
3,263,781.25
2,074,938.89
1,027,003.47
1,029,000.00
2,043,812.50
1,202,906.25
1,162,166.67
2,286,708.33
2,316,477.78
3,652,666.67
762,959.53
2,350,472.22
TERM
(Days)
715
821
1,013
749
739
889
457
836
764
420
680
987
1,077
730
866
889
898
1,015
912
1,070
1,080
855
644
548
1,083
365
500
900
548
506
532
530
741
1,115
667
717
730
711
1,379
1,128
996
1,588
1,444
1,414
1,163
mx
INVESTMENT REPORT
AS OF MARCH 31,2010
INVESTMENT
DATE
03/31/2009
05/11/2009
12/30/2009
04/27/2009
06/29/2009
10/01/2009
03/19/2007
01/23/2009
06/22/2009
03/05/2007
03/15/2007
01/23/2009
10/30/2007
12/08/2009
03/15/2007
02/11/2010
12/07/2009
12/08/2009
03/19/2007
12/30/2009
12/09/2009
06/29/2009
05/21/2007
08/17/2009
07/25/2007
10/19/2009
07/25/2007
07/25/2007
07/15/2008
10/20/2009
11/25/2009
11/06/2009
03/24/2010
01/20/2010
10/19/2009
01/19/2010
12/10/2007
01/20/2010
08/05/2008
08/12/2009
10/27/2009
07/30/2007
12/24/2009
01/25/2010
01/20/2010
03/16/2010
TYPE SECURITY
FA FFCB 3.625% NON-CALL
FA FAMCA 5.50% NON-CALL
FA FHLMC 5.25% NON-CALL
FA FHLMC 1.75% CALL 4/27/10
FA FHLB 1.625% NON-CALL
FA FHLB 1.375% NON-CALL
FA FHLB 5.75% NON-CALL
FA FHLB 5.75% NON-CALL
FA FFCB 3.875% NON-CALL
FA FHLB 5.00% NON-CALL
FA FHLB 5.00% NON-CALL
FA FHLB 5.00% NON-CALL
FA FHLMC 5.50% NON-CALL
FA FFCB 1.128% NON-CALL
FA FHLB 4.875% NON-CALL
FA FFCB .950% CALL 4/26/10
FA FHLB 4.25% NON-CALL
FA FHLB 4.25% NON-CALL
FA FHLB 4.875% NON-CALL
FA FNMA 1.0% NON-CALL
FA FFCB .875% NON-CALL
FA FFCB 2.0% NON-CALL
FA FFCB 4.875% NON-CALL
FA FHLMC 2.0% CALL 5/17/10
FA TVA 6.790% NON-CALL
FA TVA 6.790% NON-CALL
FA FHLB 5.375% NON-CALL
FA FHLB 5.375% NON-CALL
FA FHLB 4.375% NON-CALL
FA FFCB 2.125% NON-CALL
FA FFCB 5.45% NON-CALL
FA FHLMC 2.45% CALL 6/29/10
FA FHLB 1.25% NON-CALL
FA FHLMC 5.125% NON-CALL
FA FFCB 1.55% CALL 10/19/10
FA FHLMC 1.625% CALL 7/19/10
FA FHLB 5.58% CALL 7/20/10
FA FNMA 1.5% CALL 7/20/10
FA FFCB 3.950% NON-CALL
FA FHLB 2.0% CALL 7/27/10
FA FNMA 1.70% CALL 10/27/10
FA FHLB 5.52% CALL 7/30/10
FA FNMA 5.00% NON-CALL
FA FAMCA 2.1% NON-CALL
FA FNMA 1.75% NON-CALL
FA FNMA 1.75% NON-CALL
PAR
VALUE
1,000,000.00
1,000,000.00
1,737,000.00
3,000,000.00
2,000,000.00
1,000,000.00
3,000,000.00
1,000,000.00
3,000,000.00
2,000,000.00
3,000,000.00
1 ,000,000.00
3,000,000.00
3,000,000.00
3,000,000.00
4,000,000.00
1,000,000.00
2,000,000.00
3,000,000.00
3,000,000.00
1,000,000.00
4,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
1,000,000.00
3,000,000.00
3,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
3,000,000.00
3,000,000.00
1,000,000.00
1,250,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,770,000.00
1,037,000.00
1,000,000.00
1,000,000.00
3,000,000.00
INVESTED
AMOUNT
1,044,420.00
1,072,970.00
1,853,035.07
3,000,000.00
2,012,680.00
1,006,100.00
3,111,810.00
1,097,950.00
3,152,520.00
2,018,200.00
3,032,352.00
1,077,520.00
3,117,300.00
3,014,854.10
3,018,777.00
4,002,000.00
1,061,850.00
2,126,060.00
3,009,690.00
2,994,090.00
997,136.00
4,036,800.00
1,987,880.00
1,997,500.00
2,130,980.00
3,399,498.48
1,005,040.00
1,005,254.43
3,050,958.11
3,049,023.21
2,210,347.28
1,011,600.00
2,000,352.89
1,092,760.00
2,995,200.00
3,000,000.00
1,037,000.00
1,249,375.00
2,002,900.00
1,988,600.00
998,800.00
1,770,000.00
1,127,519.73
1,015,908.69
1,009,004.81
3,034,050.00
RETURN
RATE
1 .639%
2.050%
0.900%
1.750%
1.315%
1.375%
4.800%
1.818%
1 .490%
4.773%
4.730%
1.958%
4.390%
0.850%
4.720%
0.921%
1 .020%
0.956%
4.795%
1.105%
1 .020%
1 .630%
5.015%
2.047%
5.235%
1.534%
5.255%
5.250%
3.900%
1 .496%
1.280%
1.997%
1.243%
1.320%
1.610%
1.625%
4.677%
1 .520%
3.910%
2.200%
1 .745%
5.520%
1 .567%
1 .460%
1.390%
1 .268%
INTEREST
85,530.00
46,807.78
25,313.30
118,125.00
54,847.78
19,261.11
648,148.33
49,313.89
100,323.75
432,911.11
640,148.00
53,868.89
522,075.00
46,552.13
647,473.00
62,916.67
20,552.78
38,509.44
672,403.75
62,826.67
20,364.00
167,200.00
489,057.50
112,500.00
524,632.22
128,989.85
256,692.64
256,478.21
460,552.31
120,622.62
70,024.94
53,256.94
58,188.78
34,653.19
132,675.00
121,875.00
220,300.00
47,500.00
310,466.67
129,733.33
47,950.00
488,520.00
44,578.33
37,466.31
35,717.41
91,950.00
INVESTMENT
RETURN
1,129,950.00
1,119,777.78
1,878,348.37
3,118,125.00
2,067,527.78
1,025,361.11
3,759,958.33
1,147,263.89
3,252,843.75
2,451,111.11
3,672,500.00
1,131,388.89
3,639,375.00
3,061,406.23
3,666,250.00
4,064,916.67
1,082,402.78
2,164,569.44
3,682,093.75
3,056,916.67
1,017,500.00
4,204,000.00
2,476,937.50
2,110,000.00
2,655,612.22
3,528,488.33
1,261,732.64
1,261,732.64
3,511,510.42
3,169,645.83
2,280,372.22
1,064,856.94
2,058,541.67
1,127,413.19
3,127,875.00
3,121,875.00
1,257,300.00
1,296,875.00
2,313,366.67
2,118,333.33
1,046,750.00
2,258,520.00
1,172,098.06
1,053,375.00
1,044,722.22
3,126,000.00
TERM
(Days)
836
795
565
821
758
673
1,610
934
794
1,649
1,639
959
1,416
664
1,665
622
708
707
1,705
693
730
932
1,788
1,004
1,764
947
1,780
1,780
1,424
972
939
966
856
907
1,004
912
1,684
912
1,448
1,080
1,004
1,827
952
928
933
878
INVESTMENT REPORT
AS OF MARCH 31,2010
INVESTMENT
DATE
08/13/2008
01/29/2009
12/24/2009
11/17/2009
02/27/2009
09/04/2009
05/05/2008
08/22/2008
03/08/2010
10/01/2009
11/25/2009
12/24/2009
05/11/2009
12/10/2007
10/22/2007
12/07/2009
06/03/2008
05/19/2009
12/14/2009
01/14/2008
10/20/2009
11/25/2009
03/10/2008
11/25/2009
08/26/2009
05/14/2008
10/20/2009
03/10/2010
10/20/2009
11/10/2008
08/13/2009
12/24/2009
12/28/2009
12/03/2008
08/27/2008
08/21/2009
01/26/2010
02/19/2010
08/19/2009
02/26/2010
02/26/2010
11/12/2008
03/10/2010
12/17/2008
03/24/2010
02/23/2010
TYPE SECURITY
FA FHLB4.35% CALL 8/13/10
FA FHLB 4.625% NON-CALL
FA FHLB 4.625% NON-CALL
FA FHLB 1.75% CALL 8/17/10
FA FNMA 2.625% CALL 8/27/10
FA FNMA 2.50% CALL 9/7/10
FA FHLB 5.00% NON-CALL
FA FHLB 4.5% NON-CALL
FA FHLMC 2.125% NON-CALL
FA FFCB 1.80% NON-CALL
FA FFCB 1.80% NON-CALL
FA FHLMC 2.0% CALL 9/28/10
FA FHLMC 3.875% NON-CALL
FA FFCB 4.5% NON-CALL
FA FHLB 5.00% CALL 4/22/10
FA FNMA 1.875% CALL 10/29/10
FA FNMA 6.41% NON-CALL
FA FNMA 2.2% CALL 5/19/10
FA FHLB 1.0% CALL 12/14/11 STEP
FA FHLB 4.25% CALL 10/14/08
FA FFCB 5.15% NON-CALL
FA FHLB 2.0% CALL 8/25/10
FA FHLB 3.50% NON-CALL
FA FHLB 2.35% CALL 9/15/10
FA FHLMC 2.5% CALL 4/8/11
FA FHLB 4.00% CALL 5/15/10
FA FHLMC 4.25% NON-CALL
FA FHLMC 2.0% CALL
FA FHLMC 4.0% NON-CALL
FA FHLB 5.375% NON-CALL
FA FHLB 4.25% NON-CALL
FA FNMA 2.125% CALL 12/24/10
FA FHLB 1.85% NON-CALL
FA FFCB 4.625% CALL 7/8/10
FA FNMA 4.375% NON-CALL
FA FHLMC 2.4% CALL 7/23/10
FA FHLB 2.125% CALL 1/26/11
FA FHLMC 1.0% CALL 2/15/11
FA FFCB 2.7% NON-CALL
FA FNMA 2.05% CALL 8/26/10
FA FHLMC 2.125% CALL 8/26/10
FA FHLB 4.0% NON-CALL
FA FHLB 2.1% CALL
FA FHLB 4.375% NON-CALL
FA FHLMC 4.125% NON-CALL
FA FFCB 3.875% NON-CALL
PAR
VALUE
2,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
1,175,000.00
1,000,000.00
3,000,000.00
1,000,000.00
3,000,000.00
3,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,807,000.00
2,000,000.00
1,000,000.00
3,000,000.00
1,000,000.00
1,000,000.00
3,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
500,000.00
1,000,000.00
500,000.00
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
INVESTED
AMOUNT
1,999,500.00
2,150,960.00
1,078,810.00
2,000,000.00
2,000,000.00
2,000,000.00
1,238,814.19
1,022,730.00
3,058,800.00
1,003,470.00
3,032,750.01
3,014,100.00
1,063,510.00
2,034,780.00
2,000,000.00
1,003,900.00
1,990,388.82
2,000,000.00
999,500.00
3,000,000.00
1,102,490.00
999,531.25
2,963,940.00
1,009,500.00
2,008,000.00
2,000,000.00
536,967.86
1,000,000.00
532,794.50
1,065,788.37
2,130,988.03
1,000,000.00
1,987,226.45
2,053,420.00
2,035,600.00
1,991,200.00
2,000,000.00
1,000,000.00
1,005,669.88
2,000,000.00
1,000,000.00
1,007,890.00
1,000,000.00
2,154,940.00
3,222,330.00
1,065,180.00
RETURN
RATE
4.357%
2.391%
1.567%
1.750%
2.625%
2.500%
3.640%
3.889%
1.336%
1.680%
1 .405%
1 .824%
1.928%
4.100%
5.000%
1 .736%
3.890%
2.200%
1 .673%
4.250%
1.926%
2.015%
3.765%
2.051%
2.384%
4.000%
2.100%
2.000%
2.120%
3.800%
2.450%
2.125%
2.040%
3.983%
3.970%
2.518%
2.125%
2.054%
2.550%
2.050%
2.125%
3.818%
2.100%
2.625%
1.930%
2.000%
INTEREST
348,500.00
176,901.11
43,367.08
96,250.00
183,750.00
150,416.67
192,237.89
160,020.00
102,877.08
50,180.00
120,099.99
151,566.67
67,701.81
401,970.00
500,000.00
50,370.83
331,405.40
154,000.00
50,500.00
637,500.00
67,316.94
65,468.75
560,476.67
68,180.56
172,833.33
320,000.00
39,296.03
65,000.00
40,094.39
181,163.02
195,081.41
74,375.00
142,273.55
371,823.06
392,177.78
197,066.67
148,750.00
72,388.89
102,330.12
143,500.00
74,375.00
184,776.67
73,500.00
259,712.78
211,826.25
75,181.11
INVESTMENT
RETURN
2,348,000.00
2,327,861.11
1,122,177.08
2,096,250.00
2,183,750.00
2,150,416.67
1,431,052.08
1,182,750.00
3,161,677.08
1,053,650.00
3,152,850.00
3,165,666.67
1,131,211.81
2,436,750.00
2,500,000.00
1,054,270.83
2,321,794.22
2,154,000.00
1,050,000.00
3,637,500.00
1,169,806.94
1,065,000.00
3,524,416.67
1,077,680.56
2,180,833.33
2,320,000.00
576,263.89
1,065,000.00
572,888.89
1,246,951.39
2,326,069.44
1,074,375.00
2,129,500.00
2,425,243.06
2,427,777.78
2,188,266.67
2,148,750.00
1,072,388.89
1,108,000.00
2,143,500.00
1,074,375.00
1,192,666.67
1,073,500.00
2,414,652.78
3,434,156.25
1,140,361.11
TERM
(Days)
1,461
1,294
965
1,004
1,277
1,099
1,593
1,484
928
1,089
1,034
1,009
1,238
1,773
1,827
1,057
1,624
1,280
1,096
1,827
1,206
1,188
1,824
1,206
1,321
1,826
1,310
1,188
1,331
1,677
1,401
1,278
1,278
1,678
1,785
1,432
1,277
1,273
1,461
1,277
1,277
1,759
1,280
1,731
1,283
1,322
INVESTMENT REPORT
AS OF MARCH 31,2010
INVESTMENT
DATE
10/19/2009
11/26/2008
01/20/2009
02/12/2010
02/12/2010
03/24/2010
10/20/2009
01/21/2010
11/05/2009
03/24/2010
03/24/201 0
03/22/2010
03/24/2010
09/24/2009
02/24/2010
12/30/2009
03/09/2010
03/12/2010
03/12/2009
02/11/2009
02/18/2009
02/25/2009
03/02/2009
03/02/2009
03/09/2010
04/30/2009
06/05/2009
07/22/2009
1 1/24/2009
06/05/2009
04/21/2009
12/24/2009
06/05/2009
09/16/2009
06/05/2009
09/16/2009
11/24/2009
11/24/2009
TYPE
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FN
FN
FN
FN
FN
FN
FN
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
SECURITY
FFCB 5.350% NON-CALL
FHLB3.5% CALL 11/26/10
FHLB 3.125% NON-CALL
FFCB 3.00% NON-CALL
FNMA 2.125% CALL 10/28/1 1
FHLB 2.5% NON-CALL
FFCB 4.375% NON-CALL
FNMA 3.03% CALL 7/21/10
FNMA 3.3% CALL 7/30/10
FHLB 5.5% NON-CALL
FHLB 5.25% NON-CALL
FNMA 2.570% CALL
FFCB 3.0% NON-CALL
FNMA 2.0% CALL 9/23/1 1 STEP
FHLMC 3.125% QUARTERLY CALL
FNMA 2.3% QRTLY CALL STEP
FNMA 3.0% CALL
FHLMC 1 .0% STEP CALL 3/23/1 1
SUB-TOTAL
FICO STRIP 0.00% NON-CALL
FICO STRIP 0.00% NON-CALL
FICO STRIP 0.00% NON-CALL
FICO STRIP 0.00% NON-CALL
FICO 0.0% NON-CALL
FICO 0.0% NON-CALL
FICO 0.0% NON-CALL
SUB-TOTAL
Federal Investments Total
US TREASURY 00%
US TREASURY 4.0%
US TREASURY 2. 125%
US TREASURY 00%
US TREASURY 4.50%
US TREASURY 2.625%
US TREASURY 0.0%
US TREASURY 2.8750%
US TREASURY 2.8750%
US TREASURY 2.750%
US TREASURY 2.750%
US TREASURY 00%
US TREASURY 00%
PAR
VALUE
2,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
3,000,000.00
3,000,000.00
1,000,000.00
1,100,000.00
3,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
4,000,000.00
291,555,000.00
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
12,000,000.00
303,555,000.00
2,000,000.00
3,000,000.00
5,000,000.00
3,000,000.00
3,000,000.00
3,000,000.00
6,000,000.00
3,000,000.00
2,000,000.00
3,000,000.00
2,000,000.00
4,000,000.00
2,000,000.00
INVESTED
AMOUNT
2,235,072.36
2,000,000.00
2,047,941.08
1,028,536.49
1,014,759.55
3,016,423.52
3,234,480.00
1,001,875.00
1,110,340.00
3,395,255.41
2,231,960.00
2,000,000.00
2,047,400.80
3,000,000.00
2,010,896.00
2,000,000.00
1,000,000.00
4,000,000.00
298,108,473.73
956,370.00
1,889,240.00
916,713.56
1,826,280.00
1,818,680.00
1,793,820.00
1,882,080.00
11,083,183.56
309,191,657.29
1,991,806.11
3,093,164.06
5,069,531.25
2,998,156.25
3,114,140.63
3,069,492.19
5,995,298.33
3,076,875.00
2,040,781.25
3,077,578.13
2,042,343.75
3,994,500.00
1,996,801.67
RETURN
RATE
2.264%
4.361%
2.600%
2.250%
3.167%
2.363%
2.595%
2.985%
3.084%
2.323%
2.490%
2.570%
2.440%
3.163%
3.000%
3.150%
3.000%
3.400%
2.697%
2.200%
2.300%
2.710%
2.850%
3.000%
3.050%
1.850%
2.576%
0.437%
0.382%
0.325%
0.127%
0.452%
0.529%
0.157%
0.469%
0.282%
0.501%
0.317%
0.183%
0.193%
INTEREST
193,522.08
440,000.00
258,135.31
91,463.51
121,601.56
300,034.82
381,665.83
134,475.00
161,580.83
328,452.92
237,040.00
231,300.00
222,265.87
479,833.33
284,937.33
315,000.00
150,000.00
680,000.00
28,585,949.62
43,630.00
110,760.00
83,286.44
173,720.00
181,320.00
206,180.00
117,920.00
916,816.44
29,502,766.06
8,193.89
10,114.63
12,754.76
1,843.75
13,155.57
17,911.66
4,701.67
15,331.49
4,531.25
17,684.30
5,631.79
5,500.00
3,198.33
INVESTMENT
RETURN
2,428,594.44
2,440,000.00
2,306,076.39
1,120,000.00
1,136,361.11
3,316,458.34
3,616,145.83
1,136,350.00
1,271,920.83
3,723,708.33
2,469,000.00
2,231,300.00
2,269,666.67
3,479,833.33
2,295,833.33
2,315,000.00
1,150,000.00
4,680,000.00
326,694,423.35
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
12,000,000.00
338,694,423.35
2,000,000.00
3,103,278.69
5,082,286.01
3,000,000.00
3,127,296.20
3,087,403.85
6,000,000.00
3,092,206.49
2,045,312.50
3,095,262.43
2,047,975.54
4,000,000.00
2,000,000.00
TERM
(Days)
1,463
1,826
1,788
1,461
1,536
1,542
1,714
1,642
1,728
1,603
1,633
1,645
1,643
1,825
1,728
1,826
1,826
1,837
1,175
744
908
1,178
1,171
1,166
1,314
1,206
1,098
2,273
343
314
282
177
344
405
182
390
287
421
318
275
303
INVESTMENT REPORT
AS OF MARCH 31,2010
INVESTMENT
DATE
12/24/2009
07/22/2009
09/02/2009
11/24/2009
01/20/2010
09/02/2009
11/24/2009
02/12/2010
10/01/2009
10/19/2009
10/19/2009
12/30/2009
10/28/2009
09/24/2009
10/28/2009
11/24/2009
01/20/2010
11/24/2009
02/23/2010
03/24/2010
11/10/2008
11/12/2008
03/02/2010
12/15/2008
03/19/2008
11/01/2007
03/19/2008
02/03/2006
01/31/2008
03/16/2007
10/11/2007
09/28/2007
02/17/2006
03/30/2006
06/20/2006
04/19/2006
06/12/2006
04/16/2007
04/21/2009
05/21/2007
04/02/2009
05/30/2008
' 05/30/2008
TYPE
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
CD
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
SECURITY
US TREASURY 00%
US TREASURY 2.00%
US TREASURY 1.50%
US TREASURY 1.50%
US TREASURY 0.0%
US TREASURY 1.25%
US TREASURY 1.25%
US TREASURY .875%
US TREASURY 0.875%
US TREASURY 0.875%
US TREASURY 0.875%
US TREASURY 0.875%
US TREASURY 0.875%
US TREASURY 1.1250%
US TREASURY 1.1250%
US TREASURY 1.1250%
US TREASURY 1.00%
US TREASURY 1.00%
US TREASURY 1.00%
US TREASURY 1.00%
US TREASURY 3.125%
US TREASURY 3.125%
SUB-TOTAL
WELLS FARGO BANK 9218910637
SUB-TOTAL
TOYOTA 3.834% NON-CALL
GOLDMAN SACHS 4.50% NON-CALL
WAL-MART 4.125% NON-CALL
WAL-MART 4.125% NON-CALL
US BANCORP 4.50% NON-CALL
WELLS FARGO 4.625% NON-CALL
WAL-MART 4.75% NON-CALL
WAL-MART 4.75% NON-CALL
NEW YORK LIFE 4.625% NON-CALL
CITIGROUP 5.125% NON-CALL
CITIGROUP 5.125% NON-CALL
CITIGROUP 5.125% NON-CALL
HOME DEPOT 5.20% NON-CALL
GENERAL ELECTRIC 5.50% NON-CALL
GENERAL ELECTRIC 5.50% NON-CALL
TOYOTA FIN 5.375% NON-CALL
TOYOTA 5.450% NON-CALL
ROYAL BANK OF CANADA 5.65% NON-CALL
WELLS FARGO CO 5.30% NON-CALL
GENWORTH GLOBAL 5.375% NON-CALL
PAR
VALUE
5,000,000.00
3,000,000.00
5,000,000.00
2,000,000.00
4,000,000.00
5,000,000.00
3,000,000.00
2,000,000.00
3,000,000.00
3,000,000.00
3,000,000.00
4,000,000.00
3,000,000.00
4,000,000.00
3,000,000.00
4,000,000.00
1,000,000.00
5,000,000.00
3,000,000.00
8,000,000.00
1,000,000.00
1,000,000.00
116,000,000.00
33,000.00
33,000.00
1,000,080.00
1,000,000.00
1,000,000.00
2,000,000.00
3,000,000.00
2,000,000.00
3,000,000.00
2,000,000.00
1,000,000.00
5,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
3,000,000.00
3,000,000.00
2,000,000.00
4,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
INVESTED
AMOUNT
4,990,520.83
3,052,031.25
5,062,500.00
2,023,125.00
3,991,946.67
5,048,828.13
3,029,179.69
2,010,100.00
3,014,531.25
3,012,656.25
3,011,718.75
4,010,625.00
3,008,320.31
4,018,593.75
3,018,398.44
4,037,343.75
1,005,625.00
5,031,445.31
3,016,170.00
8,025,312.50
1,031,328.00
1,030,781.25
117,041,549.75
33,000.00
33,000.00
997,777.82
1,025,648.53
991,910.00
2,060,389.92
2,952,150.09
2,063,614.72
3,002,689.16
1,993,580.00
987,620.00
5,000,000.00
1,991,793.10
1,969,446.60
2,974,590.00
3,006,145.34
3,048,646.38
2,078,000.00
4,054,280.00
1,066,260.00
1,032,919.79
2,016,628.76
RETURN
RATE
0.254%
0.537%
0.419%
0.259%
0.244%
0.461%
0.291%
0.301%
0.509%
0.544%
0.587%
0.661%
0.699%
0.859%
0.755%
0.538%
0.630%
0.641%
0.660%
0.801%
2.430%
2.452%
0.501%
0.050%
0.050%
4.000%
3.300%
4.448%
2.750%
4.900%
3.300%
4.720%
4.870%
5.090%
5.125%
5.220%
5.500%
5.400%
5.450%
5.050%
3.372%
5.070%
2.659%
4.200%
5.100%
INTEREST
9,479.17
19,444.16
24,524.46
4,886.05
8,053.33
28,869.96
8,935.06
5,321.27
20,421.20
21,012.23
24,103.07
33,125.00
33,421.49
60,889.95
38,096.13
34,680.71
9,673.91
56,814.36
31,797.03
102,864.30
118,792.86
121,777.13
937,535.92
620.00
620.00
34,892.59
75,101.47
118,090.00
127,985.08
653,849.91
169,690.84
483,790.01
276,642.22
145,734.17
1,279,114.58
507,609.68
507,178.40
784,610.00
798,687.99
616,853.62
142,375.00
815,903.33
63,690.00
138,741.32
344,093.46
INVESTMENT
RETURN
5,000,000.00
3,071,475.41
5,087,024.46
2,028,011.05
4,000,000.00
5,077,698.09
3,038,114.75
2,015,421.27
3,034,952.45
3,033,668.48
3,035,821.82
4,043,750.00
3,041,741.80
4,079,483.70
3,056,494.57
4,072,024.46
1,015,298.91
5,088,259.67
3,047,967.03
8,128,176.80
1,150,120.86
1,152,558.38
117,979,085.67
33,620.00
33,620.00
1,032,670.41
1,100,750.00
1,110,000.00
2,188,375.00
3,606,000.00
2,233,305.56
3,486,479.17
2,270,222.22
1,133,354.17
6,279,114.58
2,499,402.78
2,476,625.00
3,759,200.00
3,804,833.33
3,665,500.00
2,220,375.00
4,870,183.33
1,129,950.00
1,171,661.11
2,360,722.22
TERM
(Days)
187
435
424
341
302
454
371
322
487
469
497
456
580
644
610
583
557
645
584
586
1,755
1,783
489
31
31
519
818
973
834
1,637
921
1,248
1,039
1,053
1,823
1,782
1,700
1,777
1,781
1,473
748
1,458
839
1,183
1,203
INVESTMENT REPORT
AS OF MARCH 31,2010
INVESTMENT
DATE
05/12/2009
05/29/2007
08/14/2009
04/28/2009
08/17/2009
03/20/2007
10/11/2007
11/15/2007
05/12/2009
05/05/2009
04/21/2009
04/23/2009
04/30/2008
08/31/2007
05/30/2008
02/08/2010
07/17/2008
08/31/2007
10/31/2007
11/23/2007
01/30/2008
04/24/2008
05/07/2008
05/12/2009
05/30/2008
05/09/2008
12/23/2008
05/12/2009
06/26/2009
05/29/2009
TYPE
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
0
O
O
0
O
O
O
0
SECURITY
MET LIFE GLOBAL FUNDING 5
GENERAL ELECTRIC 5.50% CALL 11/15/08
SUNTRUST BANK 3.0% NON-CALL
CITIGROUP 2.875% NON-CALL
TOYOTA 5.25% NON-CALL
GENERAL ELECTRIC 5.875% NON-CALL
GENERAL ELETRIC 5.875% NON-CALL
GENERAL ELETRIC 5.875% NON-CALL
CHEVRON 3.450% NON-CALL
BARCLAYS BANK 2.7% NON-CALL
BERKSHIRHATWY 4.00% NON-CALL
BERKSHIRHATWY 4.00% NON-CALL
PRINCIPAL LIFE INC 4.5% NON-CALL
GENERAL ELECTRIC 6.00% NON-CALL
GENERAL ELECTRIC 6.00% NON-CALL
GENERAL ELECTRIC 6.00% NON-CALL
PROTECTIVE LIFE 5.050% NON-CALL
JOHNSON & JOHNSON 5.15% NON-CALL
GENERAL ELECTRIC 5.250% NON-CALL
GENERAL ELECTRIC 5.250% NON-CALL
WELLS FARGO 5.250% NON-CALL
MET LIFE GLOBAL FUNDING 5
MET LIFE GLOBAL FUNDING 5
WAL-MART 4.250% NON-CALL
ALLSTATE LIFE 5.375% NON-CALL
NEW YORK LIFE 4.650% NON-CALL
BERKSHIRHATWY 4.60% NON-CALL
3 M 4.375% NON-CALL
PROTER & GAMBLE 4.60% NON-CALL
WAL-MART 3.20% NON-CALL
WELLS FARGO BANK
CORPORATE CASH MANAGEMENT ACCOUNT
LIBRARY ACCOUNT
UNION TRUST
L A I F WATER DISTRICT
L A I F PUBLIC IMPROVEMENT
L A I F PUBLIC FINANCING CORPORATION
L A I F CITY OF CARLSBAD
i% NON-CAL
11/15/08
I-CALL
DALL
;ALL
,LL
,LL
ML
CALL
CALL
CALL
ALL
vl-CALL
I-CALL
I-CALL
i% NON-CAL
i% NON-CAL
L
_L
>LL
ALL
SUB-TOTAL
T ACCOUNT
'RPORATION
3 RATION
SUB-TOTAL
PAR
VALUE
1,000,000.00
1,850,000.00
2,000,000.00
2,000,000.00
2,250,000.00
5,956,000.00
3,000,000.00
2,000,000.00
3,000,000.00
1,575,000.00
1,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
5,000,000.00
1,000,000.00
101,631,080.00
407,543.00
2,058,021.01
648.42
2,300,000.00
3,985,000.00
6,602,000.00
2,138,088.61
6,730,000.00
24,221,301.04
INVESTED
AMOUNT
1,020,480.00
1,850,000.00
2,066,260.00
2,060,840.00
2,427,570.00
6,187,688.40
3,089,347.40
2,089,414.35
3,103,177.11
1,590,861.34
1,022,563.95
2,039,340.00
1,000,000.00
1,033,437.31
1,052,958.51
2,174,860.00
3,000,000.00
1,017,457.28
2,036,663.70
2,065,283.50
1,042,814.41
1,003,232.48
2,019,402.04
1,047,829.91
2,023,559.81
1,006,649.66
1,023,835.68
2,121,417.76
5,246,650.00
1,003,190.00
103,780,874.81
407,543.00
2,058,021.01
648.42
2,300,000.00
3,985,000.00
6,602,000.00
2,138,088.61
6,730,000.00
24,221,301.04
RETURN
RATE
4.250%
5.500%
1 .500%
1.680%
1.800%
4.970%
5.100%
4.700%
2.180%
2.330%
3.200%
3.300%
4.500%
5.200%
4.550%
2.167%
5.050%
4.750%
4.830%
4.500%
4.240%
5.050%
4.900%
2.950%
5.100%
4.500%
4.000%
2.850%
3.420%
3.130%
4.207%
0.100%
0.100%
0.000%
0.050%
0.560%
0.560%
0.560%
0.560%
0.465%
INTEREST
107,217.92
453,918.06
69,073.33
89,458.61
99,695.62
1,483,867.09
676,360.93
409,960.65
187,485.39
104,626.16
96,769.38
198,882.22
178,375.00
253,896.02
189,541.49
107,473.33
605,158.33
237,753.83
484,836.30
449,799.83
205,539.76
251,024.46
485,410.46
118,982.59
504,981.86
225,850.34
177,542.10
251,186.41
800,488.89
155,565.56
17,745,355.59
1.12
5.64
-
3.19
61.99
102.70
33.26
104.69
312.58
INVESTMENT
RETURN
1,127,697.92
2,303,918.06
2,135,333.33
2,150,298.61
2,527,265.62
7,671,555.49
3,765,708.33
2,499,375.00
3,290,662.50
1,695,487.50
1,119,333.33
2,238,222.22
1,178,375.00
1,287,333.33
1,242,500.00
2,282,333.33
3,605,158.33
1,255,211.11
2,521,500.00
2,515,083.33
1,248,354.17
1,254,256.94
2,504,812.50
1,166,812.50
2,528,541.67
1,232,500.00
1,201,377.78
2,372,604.17
6,047,138.89
1,158,755.56
121,526,230.40
407,544.12
2,058,026.65
648.42
2,300,003.19
3,985,061.99
6,602,102.70
2,138,121.87
6,730,104.69
24,221,613.62
TERM
(Days)
911
1,631
824
955
857
1,793
1,588
1,553
1,026
1,035
1,090
1,088
1,447
1,750
1,477
858
1,459
1,811
1,815
1,792
1,728
1,812
1,799
1,434
1,796
1,826
1,604
1,556
1,664
1,812
1,372
1
1
1
1
1
1
1
1
GRAND TOTAL 545,440,381.04 554,268,382.89 2.416% 48,186,590.15 602,454,973.04
EXHIBIT 8
CITY OF CARLSBAD
Fund Equity in Pooled Investments
AS OF MARCH 31, 2010
Cash Balance by Fund:
General 61,088,467
Special Revenue 47,611,478
Debt Service 0
Capital Projects:
General Capital Construction 68,410,719
Traffic Impact Fees 16,173,400
Public Facilities Fees 44,286,566
Park Development 2,372,089
Transnet Taxes 6,090,365
Drainage Fees 7,773,155
Special Districts 73,644,512
Infrastructure Replacement 53,671,749
Redevelopment 2,545,626
Other Capital Construction 3,019,464
Total 277,987,645
Enterprise:
Carlsbad Municipal Water District 67,280,888
Sewer Fund 49,040,414
Solid Waste 7,049,622
Storm Water 1,962,531
Golf Course 217,174
Total 125,550,629
Internal Service 27,409,411
Agency Funds 13,697,515
Misc. Special Funds 0
Total General Ledger Balance ** 553,345,144
Reconciling Adjustments (1) (2,455,732)
Total Treasurer's Investment Portfolio at Amortized Cost 550,889,413
(1) The Reconciling Adjustments consist of differences between the General Ledger which is prepared
on an accrual basis and the Treasurer's report which is prepared on the cash basis. Accrued Interest,
amortized premium or discounts and outstanding checks and deposits in transit are not included in the
Treasurer's summary. Differences between the time journal entries are posted and the time this
report is produced may also be a component of the adjustment.
** Figures based on best estimate at the time report run on 4/06/10
EXHIBIT 9
CITY OF CARLSBAD INVESTMENT PORTFOLIO
As of March 31, 2010
CORPORATE NOTE AND COMMERCIAL PAPER RATINGS
Corporate Note Investments Meeting the Current Investment Policy:
(Ratings must be AA or better by both Moody's and S&P)
Moody's S&P
BARCLAYS BANK
BERKSHIRE HATHAWAY
CHEVRON
GENERAL ELECTRIC
JOHNSON & JOHNSON
MET LIFE GLOBAL
NEW YORK LIFE
PROCTER & GAMBLE
ROYAL BANK OF CANADA
SUNTRUST BANK
3M
TOYOTA
WAL-MART
AAA
AA2
AA1
AA2
AAA
AA3
AAA
AA3
AAA
AAA
AA2
AA1
AA2
AAA
AA-
AA
AA+
AAA
AA-
AAA
AA-
AA-
AAA
AA-
AA
AA
Commercial Paper Investments Meeting the Current Investment Policy:
(Ratings must be A1/P1 or better by both Moody's and S&P)
(Ratings of other debt must be AA or better by Moody's and S&P)
NONE
Investments with Subsequent Changes in Credit
Moodv's
ALL STATE LIFE
CITIGROUP
GENWORTH GLOBAL
GOLDMAN SACHS
HOME DEPOT
PRINCIPAL LIFE
PROTECTIVE LIFE
US BANCORP
WELLS FARGO
A1
A3
A2
A1
BAA1
AA3
A2
AA3
A1
Rating *
S&P
AA-
A
A
A
BBB+
A+
AA-
A+
AA-
Carrying
Purchased Value
05/30/2008 2,014,761
06/20/2006 11,032,133
05/07/2008 2,007,213
03/19/2008 1,002,355
06/12/2006 2,995,214
04/30/2008 1,000,000
07/17/2008 3,000,000
02/03/2006 2,996,506
01/30/2008 4,046,405
Market
Value
2,178,700
11,333,840
2,079,960
1,007,460
3,115,950
1,022,970
2,949,390
3,034,890
4,160,030
* The City's Investment Policy allows the City Treasurer to determine the course of action that would correct exceptions
to the policy. All of these investments are paying interest at the required times. The principal of all investments are
considered secure. It is the intent of the City Treasurer to hold these assets in the portfolio until maturity unless events
indicate they should be sold.
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF MARCH 31, 2010
WEIGHTINGS FOR CORPORATE AND FEDERAL AGENCY ISSUERS
EXHIBIT 10
PERCENTAGE WEIGHTINGS BY CORPORATE NOTE ISSUER
ALL STATE LIFE
BARCLAYS BANK
BERKSHIRE HATHAWAY
CHEVRON
CITIGROUP
GENERAL ELECTRIC CAP
GENWORTH GLOBAL
GOLDMAN SACHS
HOME DEPOT
JOHNSON & JOHNSON
MET LIFE GLOBAL FUND
NEW YORK LIFE
PRINCIPAL LIFE
PROCTER & GAMBLE
PROTECTIVE LIFE
ROYAL BANK OF CANADA
SUNTRUST BANK
3M
TOYOTA
US BANKCORP
WAL-MART
WELLS FARGO
PERCENTAGE WEIGHTINGS BY FEDERAL AGENCY ISSUER
FAMCA
FICO
FEDERAL FARM CREDIT BANK
FEDERAL HOME LOAN BANK
FEDERAL HOME LOAN MORTGAGE CORP
FEDERAL NATIONAL MORTGAGE ASSOC
TVA
U.S.TREASURY
Total Portfolio
* No more than 5% may be invested with a single corporate issuer.
"There are no percentage limits on federal agency issuers.
Investment Cost
2,023,559.81
1,590,861.34
4,085,739.63
3,103,177.11
11,022,079.70
27,634,444.89
2,016,628.76
1,025,648.53
2,974,590.00
1,017,457.28
4,043,114.52
1,994,269.66
1 ,000,000.00
5,246,650.00
3,000,000.00
1,066,260.00
2,066,260.00
2,121,417.76
9,557,627.82
2,952,150.09
10,099,588.99
4,139,348.92
'ENCY ISSUER
Investment Cost
7,884,746.01
11,083,183.56
56,394,670.13
131,436,218.50
50,227,408.43
46,634,952.17
5,530,478.48
117,041,549.75
Percent of Portfolit
0.37%
0.29%
0.74%
0.56%
1.99%
4.99%
0.36%
0.19%
0.54%
0.18%
0.73%
0.36%
0.18%
0.95%
0.54%
0.19%
0.37%
0.38%
1.72%
0.53%
1.82%
0.75%
Percent of Portfolio**
1 .42%
2.00%
10.17%
23.71%
9.06%
8.41%
1.00%
21.12%
$554,268,382.89
City of Carlsbad
Bond Proceeds Investment Report
March 31, 2010
Fund Type
Assessment District 03-01
Project Fund
Redemption Fund
Investments
(College/Cannon)
LAIF
LAIF
Re-Assessment District 97-01 (Alga Road & College Blvd)
Imprvmnt Fund - Alga AIM STIT Treasury
Assessment District 95-01
Reserve Fund
Assessment District 96-01
Reserve Fund
Assessment District 02-01
Improvement Fund
Redemption Fund
EFJPA
Reserve Fund
(Carlsbad Ranch)
Repub Natl Bank Repo Agreement (HSBC)
(Rancho Carrillo)
Repub Natl Bank Repo Agreement (HSBC)
(Poinsettia Lane)
AIM
LAIF
AIG Investment Agreement
Communities Facilities District #3 Improvement Area 1
Project Fund AIM STIT Treasury
Reserve Fund BNY Hamilton Money Market
Other BNY Hamilton Money Market
Communities Facilities District #3 Improvement Area 2
Project Fund LAIF
Reserve Fund BNY Hamilton Money Market
Other LAIF/BNY
CPFA Golf Course Bonds
Reserve Fund
Other
BNY Hamilton Money Market
BNY Hamilton Money Market
Stated Int.
Rate
0.56%
0.56%
N/A
5.83%
6.03%
N/A
0.56%
5.36%
N/A
various
various
0.56%
various
various
various
various
Maturity
Date
N/A
N/A
N/A
N/A
09/02/28
N/A
N/A
08/01/14
N/A
09/01/36
N/A
N/A
09/01/38
N/A
N/A
N/A
Par Value
$ 952,808 $
$ 1,189,011 $
$ 277,728 $
$ 921,351 $
$ 1,292,770 $
$ 4,601,797 $
$ 2,474,645 $
$ 953,706 $
$ 1 ,926,034 $
$ 771,235 $
$ 24,492 $
$ 12,811 $
$ 1,068,180 $
$ 3,828,611 $
$ 1,238,325 $
$0;-t>
Cost
Fiscal Agent:
952,808
1,189,011
Fiscal Agent:
277,728
Fiscal Agent:
921,351
Fiscal Agent:
1,292,770
Fiscal Agent:
4,601,797
2,474,645
Fiscal Agent:
953,706
Fiscal Agent:
1,926,034
771,235
24,492
Fiscal Agent:
12,811
1,068,180
3,828,611
Fiscal Agent:
1,238,325
Source
BNY Western Trust
LAIF
LAIF
US Bank
AIM Instit. Fund Services
BNY Western Trust
HSBC Bank of New York
BNY Western Trust
HSBC Bank of New York
BNY Western Trust
AIM Instit. Fund Services
LAIF
BNY Western Trust
GIC
BNY Western Trust
AIM Instit. Fund Services
BNY Western Trust
BNY Western Trust
BNY Western Trust
LAIF
BNY Western Trust
LAIF/BNY
BNY Western Trust !
BNY Western Trust ;
BNY Western Trust |
ii
21,533,504 $21,533,504
City of Carlsbad
Summary of Outstanding Housing Loans
As of March 31, 2010
Borrower
Individual homebuyers
Individual homebuyers
Individual homebuyers
Individual homebuyers
Individual homebuyers
Individual homebuyers
Catholic Charities
Development
City-wide (CHAP)
Calavera Hills
Cherry Tree Walk
Serrano
Rancho Carlsbad
Solamar
Homeless shelter
CB Laurel Tree Apartment: Laurel Tree
CB Housing Partnership
Pacific Vista Las Flores
Poinsettia Housing Assoc
Bridge Housing Corp
Dove Family Housing
CIC Calavera LP
Individual homebuyers
Individual homebuyers
El Camino Family Housing
Individual homebuyers
Individual homebuyers
Habitat for Humanity
CIC La Costa
Down Payment & Closing
Cost Assistance
CIC Glen Ridge, LP
Rancho Carrillo
Vista Las Flores
Poinsettia Station
Villa Loma
La Costa Paloma
Mariposa Apts
Mulberry at
Bressi Ranch
Village bv the Sea
Cassia Heights
Laguna Point
The Bluffs
Roosevelt St.
Condos
Hunter's Point
Various
Glen Ridge
Purpose
Sale
Sale
Sale
Sale
Sale
Sale
Shelter
Rentals
Rentals
Rentals
Rentals
Rentals
Rentals
Rentals
Sale
Sale
Rentals
Sale
Sale
Sale
Rentals
Assistance
Rentals
First date
issued
06/28/99
10/15/99
06/28/99
05/25/01
05/20/99
09/26/88
09/19/97
12/24/98
03/05/01
02/27/01
10/21/99
11/04/94
07/15/03
09/15/04
04/29/05
10/28/05
03/07/06
07/06/06
06/14/07
08/30/07
08/19/08
06/25/09
10/05/09
# of Loans issued by Loans issued by
loans City to developers/ Developer to # of loans
Issued homeowners homeowners outstanding
133
5
42
90
22
9
1
2
1
1
1
2
1
1
100
11
1
3
8
1
1
4
1
$1,680,000 $
75,000 150,000
453,600 452,600
1,350,000 4,050,000
752,533
147,726
200,000
1,134,000
1,157,584
363,948
920,000
2,212,000
2,070,000
1 ,060,000
1,840,000 19,660,200
220,000 4,087,200
1,454,276
210,000
200.000
797,539
1,932,000
47,500
1,014,000
38
1
14
34
15
1
1
2
1
1
1
2
1
1
100
7
1
3
8
1
1
1
1
Loan amount Developer loan
Developer due to City amount due to
City loan loan repaid to (recorded as City (not on
repaid to City City AR) City's books)
($1,300,262) $ - $379,73800 $
(60,000) (120,000) 15,000
(302,400) (283,250) 151,200
(840,133) (2,520,000) 509,867
(256,410) - 496,123
(135,065) - 12,661
200,000
(357,839) - 776,161
1,157,584
363,948
920,000
(1,481,610) - 730,390
(847792) - 1,222,208
1,060,000
1,840,000
220,000
1.454,276
210,000
200.000
797,539
1.932,000
47,500
1,014,000
379,738
30,000 45,000
169,350 320,550
1,530,000 2.039,867
496,123
12,661
200,000
776,161
1,157,584
363,948
920,000
730,390
1,222,208
1,060,000
19,660,200 21,500,200
4,087,200 4,307,200
1,454,276
210,000
200,000
797,539
1.932.000
47,500
1,014,000
Type of Loan
Payment deferred 15 years. No interest is due unless home
is sold before 16th year
Payment deferred 30 years No interest is due unless home
is sold before 31th year
Payment deferred 30 years. No interest is due unless home
is sold before 31th year
Payment deferred 30 years No interest is due unless home
is sold before 31th year
Principal is due when home is sold
Principal is due when home is sold
Principal is due when property is sold
Principal and 3% interest each year for 30 years when
surplus cash is available
Principal and 3% interest each year for 55 years when
surplus cash is available
Principal and 3% interest each year for 55 years when
surplus cash is available
Principal and 3% interest each year for 55 years when
surplus cash is available
Principal and 3% interest each year for 1 5 yeare when
surplus cash is available
Principal and 3% interest each year for 55 years when
surplus cash is available
Principal and 3% interest each year for 55 years when
surplus cash is available
Payment deferred 30 years. No interest is due unless home
is sold before 31th year
Payment deferred 30 years. No interest is due unless home
is sold before 31th year
Principal and 3% interest each year for 55 years when
surplus cash is available
Payment deferred 45 years. No interest is due unless home
is sold before 46th year
Payment deferred 30 years. No interest is due unless home
is sold before 31th year
Refer to Agenda Bill 18,569 / Resolution 2006-131 & AB
19.183/R2007-255
Refer to Council Resolutions 05-264 & 06-160
Referto Agenda Bill 19,415 / Resolution 2008-121
Refer to Agenda Bill 397 / Resolution 435 p_.
X
441 $ 21,291,706 $ 28,400,000 236
During the 3rd quarter of FY2009-10. $16,508 was received for CHAP loan payments The current outstanding loan balance is $15,710,195
$ (5,581,511) $ (2,923,250) $ 15,710,195 $ 25,476.750 $ 41.186,945