RTIRZ-2012-04 - 2012-06-11 RESOLUTION NO. - RTIRZ-2012-04
A RESOLUTION OF THE TAX INCREMENT REINVESTMENT ZONE
NO. 2 (TIRZ), ACCEPTING THE INVESTMENT REPORT FOR THE
QUARTERS ENDING DECEMBER 2011 and MARCH 2012.
BE IT RESOLVED BY THE TIRZ BOARD OF DIRECTORS:
Section 1. That the Board hereby accepts the Investment Reports for the
Quarter ending December 2011 and March 2012.
PASSED, APPROVED, AND ADOPTED this 11th day of June, A.D., 2012.
RZ CHAIRMAN Or
ATTEST:
TIRZ SECR TAR
RESOLUTION NO. RTIRZ NO. 2012-04
EXHIBIT "A"
TIRZ II
Quarterly Investment Report
December 31, 2011- March 31, 2012
Portfolio at December
31. 2011
Portfolio at March 31, 2012
Ending Book Value
$ 6,054,096.93
Ending Book Value $
8,051,941.89
Ending Market Value
6,054,096.93
Ending Market Value
8,051,751.67
Accrued Interest Receivable
Accrued Interest Receivable
61.15
Unrealized Gain/(Loss)
Unrealized Gain/(Loss)
-
Change in Unrealized Gain/Loss
Change in Unrealized Gain/Loss
Weighted Average Maturity
1 Day
Weighted Average Maturity
5 Days
Change in Market Value
1,884,251.40
Change in Market Value
1,997,654.74
Yield to Maturity at Cost
0.04%
Yield to Maturity at Cost
0.05%
T-Bill Benchmark
0.12%
T-Bill Benchmark
0.19%
Agency Note Benchmark
0.01%
Agency Note Benchmark
0.01%
Average
for Quarter
Total Rate of Return
0.05%
1 Year T-Bill Benchmark Yield
0.17%
Agency Note Benchmark Yield
0.01%
This quarterly report is in compliance with the investment policy and strategy as established by the City and the Public Funds Investment Act
(Chapter 2256, Texas Government Code).
Prepared by:
(in, &Y("L j
Claire Bogard
Director of Finance
IJ
Rick gaa d
Assistant Ir for of Finance
Fatima Uwakwe
Senior Accountant
Description Face Amount \ Shares
Cash $ 2,466,169.63 S
MM 5,337,772.26
CD 248,000.00
Total/Average S 8.051.941.89 5
Group Portfolio Holdings
by Type
TIRZ II
Summary by Type
March 31, 2012
Cost Value
2,466,169.63 $
5,337,772.26
248,000.00
Book Value
2,466,169.63 $
5,337,772.26
248,000.00
8.051.941.89 S 8.051.941.89 S
9,000,000.00
8.000.000.00
% 7,000,000.00
6,000,000.00
5,000,000.00
4,000,000.00
3,000,000.00
2,000,000.00
1,000,000.00
0.00
Market Value
YTM OD Cost Days To Maturity
2,466,169.63
0.05 1
5,337,772.26
0.05 1
247,809.79
0.20 137
8,051,751.67 0.05 5
Book Value by Maturity
■Cash ■MM ■CD I 0-1 month 1.3 Months 3-6 Months 6-9 Months
Interest Rates
Date
Ilml I= 6.ms
"r Z-A 3x 5x
Lff levy LOX i9.12
12/30/2011
0.01 0.02 0.06
0.12 0.25 0.36 0.83
1.35 1.89 2.57 2.89
3/30/2012
0.05 0.07 0.15
0.19 0.33 0.51 1.04
1.61 2.23 3.00 3.35
Yield Curve Comparison
4.00
-- -- - -
--- -
3.50
3.00
..
_
2.50
2.00
..
tIRZ's Portfolio YTM .OS°'e
1.50
- S Day WAM
1.0
i
oso
�
i
0.00
1 mo 3 mo 6 mo 1
yr 2 yr 3 yr 5 yr 7 yr
10 yr 20 yr 30 yr
-30M12-0-12JMII
Portfolio vs. Benchmark
0.25
0.20
0.15
0.10
0.05
0.00
All1� 1� 11 11 11 11 11 11 1ti 11 1ti
p1f �,ol" )�`' py>8 SalO� �o" peg' NY,Fsse, �,at"
"►-Portfolio TOW rt-i Y..r T•EHH -AOOncy N.I.
City of Pearland
Quarterly Investment Report
Report Format: By CUSIP
Group By: Security Type
Portfolio/Report Group: 66: TIRZ II
Begin Date: 12/31/2011, End Date: 3/31/2012
Portfolio Maturity
Annualized
Amortized
Amortized
Investment
Description CUSIP/Tiicker Name Date
TRR-BV
Beginning BV
Buy Principal
Sell Principal
Discount
Premium
Ending BV
Income-BV
CASH
Wells Fargo vJFSWEEP 66, TIRZ N/A
0.05
1,989,003.61
1,519,850.61
1,042,684.59
0.00
0.00
2,466,169.63
300.25
Sweep Cash II
Sub
Total/Average
0.05
1,989,003.61
1,S19,850.61
1,042,684.59
0.00
0.00
2,466,169.63
300.23
Cash
CERTIFICATE OF DEPOSIT
MARLIN 66: TIRZ
BUSINESS BANK CD57116ADR6 8/15/2012
0.20
0.00
248,000.00
0.00
0.00
0.00
248,000.00
61.15
II
0.2 8/15/2012
Sub
Total/Average
0.20
0.00
248,000.00
0.00
0.00
0.00
248,000.00
61.15
CertUlrate Of
Deposit
MONEY MARKET
Welk Fargo MM WF7843 66: TIRZ N/A
0.05
4,065,093.32
2,502,623.69
1,229,944.75
0.00
0.00
5,337,772.26
668.44
II
Sub
Total/Average
0.05
4,065,093.32
2,502,623.69
1,229,944.75
0.00
0.00
5,337,772.26
668.44
Money Market
Total /
0.05
6,054,096.93
4,270,474.30
2,272,629.34
0.00
0.00 8,051,941.89
1,029.84
Average
City of Pearland
Quarterly Investment Report at Quarterend
Report Format: By Transaction
Group By: Security Type
Portfolio/Report Group: 66: TIRZ II
As of 3/31/2012
Description CUSIP/Ticker
Portfolio Settlement
Name Date
Maturity
Date
YTM @
Cost
Face
Amount/Shares
Cost Value
Book Value
Market Value
Days To Accrued % of
Maturity Interest Portfolio
Cash
Wells Fargo WFSWEEP
66: TIRZ
5/31/2006
N/A
0.05000
2,466,169.63
2,466,169.63
2,466,169.63
2,466,169.63
1
N/A
30.63
Sweep Cash
U
Sub Total/
0.05000
2,466,169.63
2,466,169.63
2,466,169.63
2,466,169.63
1
0.00
30.63
Average
Certificate Of Deposit
MARLIN
BUSINp S CD57116ADR6
66, TIRZ2/15/2012
8/15/2012
0.20000
248,000.00
248,000.00
248,000.00
247,809.78
137
61.15
3.08
11
8/15/2012
Sub Total /
0.20000
248,000.00
248,000.00
248,000.00
247,809.78
137
61.15
3.08
Average
Money Market
Is Fargo WF7843
66, TIRZ
5/30/2006
N/A
0.05000
5,337,772.26
5,337,772.26
5,337,772.26
5,337,772.26
1
N/A
66.29
M
Sub Total /
Average
0.05000
5,337,772.26
5,337,772.26
5,337,772.26
5,337,772.26
1
0.00
66.29
Total /
0.05462
8,051,941.89 8,051,941.89 8,051,941.89
8,051,751.67
5
61.15
100
Average
0
City of Pearland
Purchases
Portfolio/Report Group: 66: TIRZ II
From 1/1/2012 To 3/31/2012
Portfolio Settlement Maturity Purchase Face YTM
Name Description Bullet/Callable CUSIP/Ticker Action Date Date Price Amount/Shares Cost Principal Interest/Dividends Broker/Dealer
66: TIRZ MARLIN
II BUSINESS BANK CD57116ADR6 Buy 2/15/2012 8/15/2012 100 248,000.00 0.20000 248,000.00 0.00 Vining Sparks
0.2 8/15/2012
Page I of I
M
Pledged Collateral Reconciliation Report
March 31, 2012
Bank
Account Number
Account Name
Amount
Wells Fargo
201-0419505
Operating
$ -
Wells Fargo
201-0419513
Payroll Fund
-
Wells Fargo
001-3042841
Sweep Account
73,327,278.43
Wells Fargo
201-0419554
98 CO Escrow
-
Wells Fargo
807-1613395
Credit Card Account
471,260.08
Wells Fargo
818-4567843
Alvin ISD
5,337,772.26
Wells Fargo
001-3043112
PEDC Sales Tax
-
Wells Fargo
280-7409871
Health Claims
292,144.55
Wells Fargo
Certificate of Deposit
-
Total of Bank Balances $ 79,428,455.32
Pledged Collateral for City 108,544,009.25
FDIC Insurance 250,000.00
Total Collateral $ 108,794,009.25
Over (Under) Collateralized $ 29,365,553.93
Total % Collateralized 137.0%
Bank Account Number Account Name
Amount
Wells Fargo 100-7284258 Development Authority
2,676,180.25
Total of Bank Balances
$ 2,676,180.25
Pledged Collateral for DAP
10,671,089.06
FDIC Insurance
250,000.00
Total Collateral
$ 10,921,089.06
Over (Under) Collateralized
$ 8,244,908.81
Total %Collateralized
408.1%
Total $ Over (Under) Collateralized
$ 37,610,462.74
Total % Collateralized
145.8%
Status
Collateralized
I:Hnvestmentslinvestment ReportslTIRZ Investment Report - TIRZ - Otr 0312
TIRZ II
Quarterly Investment Report
September 30, 2011- December 31, 2011
Portfolio at September
Ending Book Value
30, 2011
$ 4,169,845.53
Portfolio at September
Ending Book Value
30. 2012
$ 6,054,096.93
Ending Market Value
4,169,845.53
Ending Market Value
6,054,096.93
Accrued Interest Receivable
Accrued Interest Receivable
Unrealized Gain/(Loss)
Unrealized Gain/(Loss)
Change in Unrealized Gain/Loss
Change in Unrealized Gain/toss
Weighted Average Maturity
1 Day
Weighted Average Maturity
1 Day
Change in Market Value
(8,722,538.46)
Change in Market Value
1,884,251.40
Yield to Maturity at Cost
0.10%
Yield to Maturity at Cost
0.04%
T-Bill Benchmark
0.13%
T-Bill Benchmark
0.12%
Agency Note Benchmark
0.01%
Agency Note Benchmark
0.01%
Average
for Quarter
Total Rate of Return
0.06%
1 Year T-Bill Benchmark Yield
0.12%
Agency Note Benchmark Yield
0.01%
This quarterly report is in compliance with the investment policy and strategy as established by the City and the Public Funds Investment Act
(Chapter 2256, Texas Government Code).
Prepared by:
d, bP,,
Claire Bogard Rick e6virgaar Fatima Uwakwe
Director of Finance Assistant Dire or of Finance Senior Accountant
TIRZ 11
Summary by Type
December 31, 2011
Description Fau Amount \ Shares Cost Value Book Value
Cash $ 1,989,003.61 $ 1,989,003.61 $ 1,989,003.61 $
MM 4,065,093.32 4,065,093.32 4,065,093.32
Total/Average S 6.054.096.93 S 6.054.096.93 S
Group Portfolio Holdings
by Type
33
679G
WCash ■M.1
Market Value YTM 0 Cost Days To Maturity
1,989,003.61 0.04 1
4,065,093.32 0.04 1
6.054.096.93 S 6.0S4.096.93 0.04 1
7.000.0D0.00
6.000.000.00
5.000.000.00
4,000,000.00
3.000.0D0.00
2,000,000.00
1,000,000.00
0.00
Book value by Maturity
0-1 Wnth 1-3 Yorits 3.6 Months 69 4ontla
lnwrer.--,fes
f
Date lID4 i= €M 119 LZ am IM Z39 I" ffiM RZ
9/30/2011 0.02 0.02 0.06 0.13 0.25 M42 0.96 1.43 1.92 2.66 2.90
12/30/2011 0.01 0.02 0.06 0.12 025 036 0.83 1.35 1.89 2.57 2-89
Yield Curve Comparison
-+-- 12,3-- w-. , -.-^.'CIZ-3
Portfolio vs. Benchmark
0.35
0.30
025
0.20
0.15
0.10
0.05
0.00
N1 �1 11 11 11 1% 11 11
�� Fdo- �t �c �y� Vol71�r N� SBA N°r 00`
- Pw*&Taa -- --��Y. Tan _.__-»-AWWrrye.
City of Pea nand
Quarterly Investment Report
Report Format: By CUSIP
Group By: Secunty Type
Portfolio/Report Group: 66: TIRZ II
Begin Date: 9/30/2011, End Date: 12/31/2011
Portfolio Maturity Annualized
TRR-BV
Beginning BV
Buy Principal
Sell Principal
Amortized
Discount
Amortized
Premium
Endirg BV
Investment
Income-BV
Description CUSIP/Ticker Name Date
CASH
Wells Fargo WFSWEEP 66: TIRZ N,'A
0.07
210,82429
1,778,179.32
0.00
0.00
0.00
1,989,003.61
99.67
Sweep Cash II
Sub
Total/Average
0.07
210,824.29
1,778,179.32
0.00
0.00
0.00
1,989,003.61
99.67
Cash
MONEY14ARKET
Wets Fargo M1M WF7843 666. TIRZ NIA
0.06
3,959,021.24
422,449.72
316,377.64
0.00
0.00
4,065,093.32
652.87
Sub
0.06
3,9S9,021.24
422,449.72
316,377.64
0.00
0.00
4,065,09332
65
Totaf/Average
Money Market
Total /
0.06
4,169,94S.S3
2,200,629.04
316,377.64
0.00
0.00
6,054,096.93
752.54
Average
1 0f 1
I
loft
City of Pearland
Quarterly Investment Report at Quarterend
Report Format: By Transaction
Group By: Security Type
Portfolio/Report Group: 66: TIRZ 11
As of 12/31/2011
Portfolio Settlement Maturity
YTM ®
Face
Days To Accrued
% of
Description CUSIP/Ticker
Name Date Date
Cast
Amount/Shares
Cost Value
Book Vakre
Market Value
Matuity, Interest Portfofo
Cash
Weis Fargo
Sweep WFSWEEP
66: T1R2
Q 5/31/2006 WA
0.04000
1,989,003.61
1,989,003.61
1,989,003.61
1,989,003.61
1 N/A
32.85
Cash
Sub Total
/ Average
0.04000
1,989,003.61
1,989,003.61
1,989,003.61
1,989,003.61
1 0.00
32.85
Money Market
_
WetFargo
WF7843
11 T1FiZ
5/30/2006 N/A
MM
0.04000
4,065,093.32
4,065,093.32
4,065,093.32
4,065,09332
1 WA
67.15
Sub Total
/ Average
0.04000
4,065,09332
4,065,09332
4,065,09332
4,065,09332
1 0.00
67.15
Total /
Average
0.04000
6,054,096.93 6,054,096.93
6,054,096.93
6,054,096.93
1 0.00
100
Pledged Collateral F onciliation Report
December 31, 2011
Bank
Account Number
Account Name
Amount
Wells Fargo
201-0419505
Operating
$ _
Wells Fargo
201-0419513
Payroll Fund
_
Wells Fargo
001-3042841
Sweep Account
71,637,847.55
Wells Fargo
201-0419554
98 CO Escrow
-
Wells Fargo
807-1613395
Credit Card Account
526,584.55
Wells Fargo
818-4567843
Alvin ISD
4,065,093,32
Wells Fargo
001-3043112
PEDC Sales Tax
-
Wells Fargo
280-7409871
Health Claims
334,232.23
Wells Fargo
Certificate of Deposit
Total of Bank Balances
$ 76,563,757.65
Pledged Collateral for City
83,750,735.52
FDIC Insurance
250,000.00
Total Collateral
$ 84 000 735 52
Bank Account Number
Wells Fargo 100-7284258
1-unvestmentsVrnesiment ReportslTIRZtlmestment Report - TIRZ - Qtr 1211
Over (Under) Collateralized $ 7,436,977.87
Total % Collateralized
109.7%
Account Name
Amount
Development Authority
2,677,441.70
Total of Bank Balances $
2,677,441-70
Pledged Collateral for DAP
11,539,998.06
FDIC Insurance
250,000.00
Total Collateral $
11,789,998.06
Over (Under) Collateralized $
9,112,556.36
Total % Collateralized
440.3%
Total $ Over (Under) Collateralized $
16,549,534.23
Total % Collateralized
120.9%
Status
Collateralized